Link between VBAP and VBFA - Toolbox for IT Groups
Link between VBAP and VBFA Ja
Hi All I'm in the process creating a simple query using VBAP and VBFA in order to link some logistic data in to a particular sales order. but once I run the program, it says "no data". please help me to resolve this. ja
Mister Ja. Firstly... check whether subsequent Delivery Document of Sales Order exist. I would do it via VA03 => Button "Display Flow Document". If so and your query is a "Z" query, review your abap code: Select VBELN (where Delivery Doc Number is) from VBFA where VBELV EQ VBAP-VBELN and POSNV EQ VBAP-POSNR and VBTYP_N EQ 'J' (in case you want to select Delivery documents) and VBTYP_V EQ 'C'. But if you're using as such Report Generator Tool (E.g.: SQVI), no idea... only evaluating step-by-step it, but in advance... I'd suggest using VBAK instead VBAP. Hope be useful. Marcelo Preuss
Thanks Marcelo, I'll try this & get back to you
Hi, What is your requirement, what fields you would you like to get on reports, vbap is sales doc itemlevel, vbfa for doccument flow. Try to find out common field, go though the process of SQ02, SQ03 AND SQ01, if you don't find common field, ask abaper create z field and generate required report. Give the data for which you would like to report. Warm regards, JK
shailwas
VBELN and Header type and Item Type
This thread has been closed due to inactivity. Start a new thread here 5018770
Delivered quantity field in sales order
Query using SQVI - Repeat Line Items
Standard table?
Find keys to link table VBAK-> VBFA ->LIPS
Report on Delivery and billing document
Link between VBAP and VBFA - Toolbox for IT Groups
Link between VBAP and VBFA Ja
Hi All I'm in the process creating a simple query using VBAP and VBFA in order to link some logistic data in to a particular sales order. but once I run the program, it says "no data". please help me to resolve this. ja
Mister Ja. Firstly... check whether subsequent Delivery Document of Sales Order exist. I would do it via VA03 => Button "Display Flow Document". If so and your query is a "Z" query, review your abap code: Select VBELN (where Delivery Doc Number is) from VBFA where VBELV EQ VBAP-VBELN and POSNV EQ VBAP-POSNR and VBTYP_N EQ 'J' (in case you want to select Delivery documents) and VBTYP_V EQ 'C'. But if you're using as such Report Generator Tool (E.g.: SQVI), no idea... only evaluating step-by-step 
it, but in advance... I'd suggest using VBAK instead VBAP. Hope be useful. Marcelo Preuss
Thanks Marcelo, I'll try this & get back to you
Hi, What is your requirement, what fields you would you like to get on reports, vbap is sales doc itemlevel, vbfa for doccument flow. Try to find out common field, go though the process of SQ02, SQ03 AND SQ01, if you don't find common field, ask abaper create z field and generate required report. Give the data for which you would like to report. Warm regards, JK
shailwas
VBELN and Header type and Item Type
This thread has been closed due to inactivity. Start a new thread here 5018770
Delivered quantity field in sales order
Query using SQVI - Repeat Line Items
Standard table?
Find keys to link table VBAK-> VBFA ->LIPS
Report on Delivery and billing document