‎2008 May 27 5:49 PM
Hi Experts,
I will appreciate if someone can explain to me how is table VBFA populated. What is the logic for creating a record inside this table ?. Why are also some documents that only have 000000 as value in the POSNN field?
Thanks for your help.
‎2008 May 27 6:01 PM
Hi
The system populates that table in order to create a link beetween the previous and next document:
The fields:
- VBELV and POSNV are the number of document and item of previuos document;
- VBELN and POSNN are the number of document and item of next document;
So if u have a document 1 and item 10, if u need to select the next documents u should get all records where VBELV and POSNV are 1 and 10, then u should select all next documents of the next documents of your first one (doc. 1 and item 10), and so....
U can see the fm RV_ORDER_FLOW_INFORMATION in ordert to understand how to read VBFA
Max
‎2008 May 27 5:59 PM
VBFA is being populated based on the indicator "Set Document Flow" in the copy control configuration maintained for the SD documents.
E.g Sales Order SO1 (with 1 item) has delivery DEL1. Than VBFA has 1 entry.
SO1 ... DEL1
Than billing BIL1 has been created for DEL1 than VBFA will have total 3 entries:
SO1... DEL1
SO1.... BIL1
DEL1... BIL1
Entry with POSNN '000000' is being generated when you create a new document with reference to antoher document.
E.g. Sales Order 123 has been created as a copy of 120 than you will find an entry with 000000.
Regards,
Naimesh Patel
‎2008 May 27 8:31 PM
Hi Naimesh,
As I explained to you in my original question I have VBELN = 716838 and POSNN = 000000. How do I find then the subsequent documents for this combination in a select statement...?
When using SE16 you just put VBELV = 716838 ,POSNV = 0 and some records are being displayed but the values for POSNV are not zeroes. When using a select the program doesn't read any record because there are not occurrences for POSNV = 000000.
Please advise.
Thanks Luis.
‎2008 May 27 8:43 PM
As Max directed, you can use the FM RV_ORDER_FLOW_INFORMATION to get the document flow for one perticular document.
Regards,
Naimesh Patel
‎2008 May 27 6:01 PM
Hi
The system populates that table in order to create a link beetween the previous and next document:
The fields:
- VBELV and POSNV are the number of document and item of previuos document;
- VBELN and POSNN are the number of document and item of next document;
So if u have a document 1 and item 10, if u need to select the next documents u should get all records where VBELV and POSNV are 1 and 10, then u should select all next documents of the next documents of your first one (doc. 1 and item 10), and so....
U can see the fm RV_ORDER_FLOW_INFORMATION in ordert to understand how to read VBFA
Max
‎2008 May 27 8:49 PM
Hi Max,
Could you or Naimesh point me into the documentation on how to use the FM module RV_ORDER_FLOW_INFORMATION ?
Thanks for your kind help.
Luis Leston
‎2008 May 27 8:55 PM
The easiest way to use it is like:
DATA: BEGIN OF L_COMWA OCCURS 1.
INCLUDE STRUCTURE VBCO6.
DATA: END OF L_COMWA.
data: begin of it_vbfa occurs 1.
include structure vbfa.
data: end of it_vbfa.
L_COMWA-VBELN = P_VBELN. " VBELN
CALL FUNCTION 'RV_ORDER_FLOW_INFORMATION'
EXPORTING
* AUFBEREITUNG = '2'
* BELEGTYP = ' '
COMWA = L_COMWA
* NACHFOLGER = 'X'
* N_STUFEN = '50'
* VORGAENGER = 'X'
* V_STUFEN = '50'
* IMPORTING
* BELEGTYP_BACK =
TABLES
VBFA_TAB = IT_VBFA
EXCEPTIONS
NO_VBFA = 1
NO_VBUK_FOUND = 2
OTHERS = 3
Regards,
Naimesh Patel