cancel
Showing results for 
Search instead for 
Did you mean: 

Join Problem LIKP,LIPS,VBRK and VBRP

0 Kudos

Hi,

i am working on the SAP Query report. But having problem in creating joins between the following tables

  1. LIKP
  2. LIPS
  3. VBRK
  4. VBRP

please guide me

regard

khurram

Accepted Solutions (0)

Answers (2)

Answers (2)

gurunathkumar_dadamu
Active Contributor
0 Kudos

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


former_member206650
Active Participant
0 Kudos
  1. LIKP
  2. LIPS
  3. VBRK
  4. VBRP

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...