SAP Managed Tags: ABAP Development Hi, I need to join 3 tables VBRK,VBAK,VBRP Tables.Actually to improve the performance first i retrieved matnr and belnr(billing records) from VRPMA Table into I_VRPMA where s_vkorg,s_fkdat,s_fkart.(selection screen) Now i need to fetch billing re...
SAP Managed Tags: ABAP Development join vbrk vbrp based on vbeln and get the knumv along in it into table it_bill. now use for all entries for it_bill select knumv ... from konv into it_konv for all entries in it_bill where knumv = it_bill-knumv. " now move all the related...
SAP Managed Tags: ABAP Development Hi The link between bill and FI document is a header data: BKPF-AWTYP = 'VBRK'. BKPF-AWKEY = VBRK-VBELN. In the condition table (KONV, KONV-KNUMV = VBRK-KNUMV) you can find the G/L account (KONV-SAKN1) used to post the condition. So a po...
SAP Managed Tags: ABAP Development hi, Ok. If we are getting 4 records here then the some where in the previous JOIN statements the records are being duplicated. If possible try to use join condition on the VBAK table, which is header table in the select statement if that is not possi...