Query Returning No Data in SAP Business One Using Table Relationship

Giri Raju
Updated on 30-Jul-2019 22:30:20

471 Views

This looks like an issue with Join in queries. Try replacing Inner join with Left join like this. I ran this query and it is working fine:select T0.DocNum as 'Payment Number', T0.DocDate 'Payment Date', T0.CardCode, T0.CardName 'Customer Name', T1.BankCode 'Bankcode', T3.BankName 'Bank Name', T2.Phone1 , T0.CreditSum, T0.CashSum, T0.TrsfrSum, t0.CheckSum, t1.CheckNum as 'Check Number', t1.DueDate as 'check date', t6.VoucherNum as 'Voucher Number', t0.TrsfrRef as 'Transfer No', t0.TrsfrDate AS 'Transfer Date', ousr.USER_code as 'user code', T5.DocNum, t11.U_P_BuildingName as 'Building Name', CASE when T5.DocNum is null then 'On Account' else 'Paid For Invoice' END AS 'Payment Status', CASE when T5.DocStatus = 'O' then ... Read More

Max Length of a Python String

Rajendra Dharmkar
Updated on 30-Jul-2019 22:30:20

4K+ Views

With a 64-bit Python installation, and 64 GB of memory, a Python 2 string of around 63 GB should be quite feasible. If you can upgrade your memory much beyond that, your maximum feasible strings should get proportionally longer. But this comes with a hit to the runtimes.With a typical 32-bit Python installation, of course, the total memory you can use in your application is limited to something like 2 or 3 GB (depending on OS and configuration), so the longest strings you can use will be much smaller than in 64-bit installations with very high amounts of RAM.

Interfacing Database to External Parties in SAP System

Ramu Prasad
Updated on 30-Jul-2019 22:30:20

200 Views

Interacting directly with SAP databases is not considered a good programming practice. As SAP database is nothing but a normal database, it can interact in any way like any ODBC technique - ADO.NET or other.Remote Function Calls can be used to make calls to databases. ERP Connect supports RFC and can be used for reading data from tables.In case one needs a high customization and control, one can create a custom RFC component to fetch and return the intended data.

RV Invoice Document Read Not Returning Data in SAP FM

Sreemaha
Updated on 30-Jul-2019 22:30:20

398 Views

I think what you may be missing over here is Alpha conversion set.When you are calling a function module in SE37, it performs alpha conversions as a part of parameter processions. You might do go for internal formatting of the parameters before passing it to ABAP for further use.

Finding Code for Admin User Creation in SAP Hybris

Sai Subramanyam
Updated on 30-Jul-2019 22:30:20

160 Views

There is a method addUserRights at below path in which it is done.hybris/bin/platform/bootstrap/bin → ybootstrap.jar → DMLRecordFactory

Write Single Line Comment in Java

mkotla
Updated on 30-Jul-2019 22:30:20

558 Views

To comment a particular line just place ‘double back slash (//)’ before the line as shown below. // Hello this line is commented Example Following example demonstrates the usage of single line comments in Java. Live Demo public class CommentsExample { public static void main(String args[]) { //Declaring a variable named num int num = 1; //Printing the value of the variable num System.out.println("value if the variable num: "+num); } } Output value if the variable num: 1

What is an Array Data Structure in Java

Sai Subramanyam
Updated on 30-Jul-2019 22:30:20

254 Views

Array is a container which can hold a fix number of items and these items should be of the same type. Most of the data structures make use of arrays to implement their algorithms. Following are the important terms to understand the concept of Array. Element − Each item stored in an array is called an element. Index − Each location of an element in an array has a numerical index, which is used to identify the element. Example Live Demo public class ArrayExample { public static void main(String args[]){ int myArray[] = {44, 69, 89, 635}; for (int i = 0; i

Identify the Database Used for Backend in ABAP

Samual Sam
Updated on 30-Jul-2019 22:30:20

275 Views

If you would have searched a little in the SAP documentation, then you would have found out the answer.You can use the CL_DB_SYS=>DBSYS_TYPE to fetch the database. For e.g. If you are using SAP HANA as the database, then the DBSYS_TYPE will have the value as HDB.

Getting Data in SAPUI5 Application from Backend Tables in NetWeaver

mkotla
Updated on 30-Jul-2019 22:30:20

386 Views

Note that Eclipse is just a standard editor to develop UI5 application. You should use SAP IDE which is one of the recommended editor now.When you backend system as NetWeaver system, Gateway and OData would be the recommended way to use.

Difference between SAP ERP and a DBMS System

Sravani S
Updated on 30-Jul-2019 22:30:20

1K+ Views

On a very basic level, a DBMS is a method for looking at something. For ex. SQL Server, MySQL, and others. It is basically a program that lets you communicate with databases.Database management system is a product which sorts out information in a database, gets information, controls and manipulates information. Generally, most of DBMS like SQL Server Management Studio or MySQL Workbench provides an easy to use interface. Also, it lets the user extract data, database entities and structures at will with simple mouse clicks.AN ERP is a product which oversees the complex business process and incorporates each one of ... Read More

Advertisements