on 04-29-2014 12:09 PM
Hi,
i am working on the SAP Query report. But having problem in creating joins between the following tables
please guide me
regard
khurram
Hi khurram nagi,
Fetch the LIKP-VBELN into LIPS-VBELN. pass these VBELN,POSNR into VBFA-VBELV VBFA-POSNV with conditions VBTYP_N = 'M' and VBTYP_V = 'J' and get the VBELN ( Billing document no). pass this VBELN into VBRK & VBRP you will get the Billing details.
Let me know if you have any issues.
Regards,
Gurunath D
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
select a~ b~ c~ d~ into corresponding fields of table itab from likp as a inner join
LIPS as b on a~VBELN = b~VBELN
VBRK as c~VBELN = a~VBELN
VBRP as d~VBELN = a~~VBELN.
also check the first condition a~VBELN = b~(KDAUF,VBELV,VGBEL,WKTNR)
second condition a~VBELN = c~SFAKN
third condition a~VBELN = d~(AUBEL,VBELV,VGBEL,VGBEL_EX)
hope it solves...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.