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...
You can get the sales order number at billing document level is only from table VBRP-AUBEL VBRP-AUBEL : Sales order number VBRP-AUPOS: sales order item Thanks, Siva. You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in....
The link between sales order and billing is found in VBRP table. The following fields will tell you which sales order is used to create the billing document / item. you can also find the delivery document here. VBRP-VGBEL Document number of the reference document ( This will be the delive...
xvbrkTYPESTANDARDTABLEOFvbrkvb, xvbrpTYPESTANDARDTABLEOFvbrpvb, xvbssTYPESTANDARDTABLEOFvbss.SELECTSINGLE*FROMvbrkWHEREvbeln = @is_nvbrk-vbelnINTO@ls_vbrk.CALLFUNCTION'RV_INVOICE_DOCUMENT_READ'EXPORTINGkonv_read='X'vbrk_i=ls_vbrkTABLESxkomv=xkomv xvbpa=xvbpa xvbrk=xvbrk xvbrp=xvbrp xkomfk...
Solved: I want to create Secondary Indexes in tables LIPS,LIKP,VBRP and VBRK as these tables have no secondary indexes or have very few secondary indexes resulting in
VBRP-KURSK -> Doc Currency for price determination , comes from copy control KOMV-KKURS -> determined on pricing date and this rate is for local currency at pricing condition level VBRK-KURRF -> If you maintain the exchange rate type is billing date in tghe copy control it gets determine...
xvbrpTYPESTANDARDTABLEOFvbrpvb, xvbssTYPESTANDARDTABLEOFvbss.SELECTSINGLE*FROMvbrkWHEREvbeln = @is_nvbrk-vbelnINTO@ls_vbrk.CALLFUNCTION'RV_INVOICE_DOCUMENT_READ'EXPORTINGkonv_read='X'vbrk_i=ls_vbrkTABLESxkomv=xkomv xvbpa=xvbpa xvbrk=xvbrk ...
SAP Managed Tags: ABAP Development Hi U can find the link between VBRK and VBAK without to use VBFA table, this improves the performance of the program: SELECT SINGLE * FROM VBRK WHERE VBELN = P_VBELN. WRITE: 'Nr. bill:', VBRK-VBELN. SELECT * FROM VBRP WHERE VBELN = VBRK-VBEL...
3,699 SAP Managed Tags: ABAP Development Hi I have two tables : VBRK and BKPF My main table´s is VBRK, but i need to search some information in the BKPF. How can i do it?? Which is the relations between VBRK and BKPF?? Thanks GregoryReply...