Skip to Content
0
Former Member
Sep 17, 2007 at 09:21 AM

SAP Query SQ01

47 Views

Hi Gurus,

ℹ️ How to get serial numbers in SAP query ?

(ii) When i'm joining certain tables to an existing set of tables, suddenly, the system becomes unable to select the records; sometimes, the number of records is reduced to the number of records available in the last table added. E.g. I have 3 tables ℹ️ LC request (document by which LC is applied for) / LC document (document created when LC opened by the bank is received by the user in the system) Vs PO no (ii) LC request details & (iii) LC Document details. For each LC request, LC document is created individaully at a later time. Now, in the first table, one single field is used for LC req & LC Doc which are of different types and have different number ranges. When I'm using only table ℹ️, i'm getting both Req & Doc against the PO but without details as it is not available in the table, but when I join ℹ️ & (ii), I get only Requests with details and when I join all the three, I only get LC documents with details.

Now, my requirement is that against each PO, I want to see all the request details along with document details where available. How to get it ?

Thanks in advance.

Sheeja