09-27-2007 11:34 AM
Hi
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...
09-27-2007 11:40 AM
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
09-27-2007 11:45 AM
But i hve been asked to look for a direct relation....
What could be done...
12-20-2007 6:36 AM
12-10-2009 12:37 AM
Hi Naveen,
Would you mind sharing the solution for the direct link?