topic Re: table relationship prob in Application Development and Automation Discussions

table relationship prob

Former Member — Thu, 27 Sep 2007 10:34:30 GMT

My report logic is as follows

The report should list all the record which fulfils the following logic:

1. Select records in table LQUA based on the selection-screen

2. If the SOBKZ = “Q”, use field SONUM to lookup table PRPS. Get the customer number from field POSKI.

3. If the field SOBKZ = “E”, use first 10 digit of SONUM which is the sales order number (vbeln) to lookup table VBAK and then get the customer in field KUNNR.

4. Filter those records using the entries in the Customer Select-option entered in the selection-screen.

5. Use fields LGNUM and LGPLA to lookup table LAGP. Get the bin total capacity from field LKAPV.

6. List the summary report.

Iam finding it difficult to sort out the 2nd point alone...

If the SOBKZ = “Q”, use field SONUM to lookup table PRPS. Get the customer number from field POSKI.

How can i use field sonum to look up table prps and get cust no field poski....

can anyone help me out...

Re: table relationship prob

Former Member — Thu, 27 Sep 2007 10:40:25 GMT

there is no direct relation between thwat table take VBELN delivery number from LQUA and enter in VBPA table and take the Sold to party number from it which is nothing but customer

other wise there is no straight link with PRPS with LQUA

Re: table relationship prob

Former Member — Thu, 27 Sep 2007 10:45:13 GMT

But i hve been asked to look for a direct relation....

What could be done...

Re: table relationship prob

Former Member — Thu, 20 Dec 2007 06:36:28 GMT

Solved prob...

Re: table relationship prob

Former Member — Thu, 10 Dec 2009 00:37:43 GMT

Hi Naveen,

Would you mind sharing the solution for the direct link?