SAP Table VBFA

Sales Document Flow

VBFA (Sales Document Flow) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VBFA to other SAP tables.

VBFA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
VBELV Preceding sales and distribution document VBELN_VON VBUK CHAR 10 0
POSNV Preceding item of an SD document POSNR_VON VBUP NUMC 6 0
VBELN Subsequent sales and distribution document VBELN_NACH VBUK CHAR 10 0
POSNN Subsequent item of an SD document POSNR_NACH VBUP NUMC 6 0
VBTYP_N Document category of subsequent document VBTYP_N CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
RFMNG Referenced quantity in base unit of measure RFMNG QUAN 15 3
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
RFWRT Reference value RFWRT CURR 15 2
WAERS Statistics currency WAERS_V TCURC CUKY 5 0
VBTYP_V Document category of preceding SD document VBTYP_V CHAR 1 0
A Inquiry
B Quotation
C Order
D Item proposal
E Scheduling agreement
F Scheduling agreement with external service agent
G Contract
H Returns
I Order w/o charge
J Delivery
K Credit memo request
L Debit memo request
M Invoice
N Invoice cancellation
O Credit memo
P Debit memo
Q WMS transfer order
R Goods movement
S Credit memo cancellation
T Returns delivery for order
U Pro forma invoice
V Purchase Order
W Independent reqts plan
X Handling unit
0 Master contract
1 Sales activities (CAS)
2 External transaction
3 Invoice list
4 Credit memo list
5 Intercompany invoice
6 Intercompany credit memo
7 Delivery/shipping notification
8 Shipment
a Shipment costs
b CRM Opportunity
c Unverified delivery
d Trading Contract
e Allocation table
f Additional Billing Documents
g Rough Goods Receipt (only IS-Retail)
h Cancel Goods Issue
i Goods receipt
j JIT call
n Reserved
o Reserved
p Goods Movement (Documentation)
q Reserved
r TD Transport (only IS-Oil)
s Load Confirmation, Reposting (Only IS-Oil)
t Gain / Loss (Only IS-Oil)
u Reentry into Storage (Only IS-Oil)
v Data Collation (only IS-Oil)
w Reservation (Only IS-Oil)
x Load Confirmation, Goods Receipt (Only IS-Oil)
$ (AFS)
+ Accounting Document (Temporary)
- Accounting Document (Temporary)
# Revenue Recognition (Temporary)
~ Revenue Cancellation (Temporary)
Revenue Recognition/New View (Temporary)
NULL Revenue Cancellation/New View (Temporary)
: Service Order
. Service Notification
& Warehouse Document
* Pick Order
, Shipment Document
^ Reserved
| Reserved
k Agency Document
PLMIN Quantity is calculated positively, negatively or not at all PLMIN CHAR 1 0
0 Zero
+ Positive
- Negative
TAQUI ID: MM-WM transfer order confirmed TAQUI CHAR 1 0
X Yes
NULL No
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERZET Entry time ERZET TIMS 6 0
MATNR Material Number MATNR MARA CHAR 18 0
BWART Movement Type (Inventory Management) BWART T156 CHAR 3 0
BDART Requirement type BDART CHAR 2 0
PLART Planning type PLART CHAR 1 0
STUFE Level of the document flow record STUFE_VBFA NUMC 2 0
LGNUM Warehouse Number / Warehouse Complex LGNUM T300 CHAR 3 0
AEDAT Changed On AEDAT DATS 8 0
FKTYP Billing category FKTYP CHAR 1 0
A Order-related billing document
B Order-related billing document for rebate settlement
C Order-related billing document for partial rebate settlement
D Periodic billing document
E Periodic billing with active invoice accrual
F Accrual
I Delivery-related billing document for inter-company billing
K Order-related billing document for rebate correction
L Delivery-related billing document
P Down payment request
R Invoice list
U Billing request
W POS billing document
X Billing using general interface
S CRM Billing Document
N Provisional or Differential Billing Document
O Final Billing Document
BRGEW Gross weight BRGEW_15 QUAN 15 3
GEWEI Weight Unit GEWEI UNIT 3 0
VOLUM Volume VOLUM_15 QUAN 15 3
VOLEH Volume unit VOLEH UNIT 3 0
FPLNR Billing plan number / invoicing plan number FPLNR FPLA CHAR 10 0
FPLTR Item for billing plan/invoice plan/payment cards FPLTR NUMC 6 0
RFMNG_FLO Referenced quantity in sales unit (float) RFMNG_FLTV FLTP 16 16
RFMNG_FLT Referenced quantity in base unit of measure (float) RFMNG_FLT FLTP 16 16
VRKME Sales unit VRKME T006 UNIT 3 0
ABGES Guaranteed (factor between 0 and 1) ABGES_CM FLTP 16 16
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0
SONUM Special Stock Number LVS_SONUM CHAR 16 0
KZBEF Indicator Inventory Management active LVS_KZBEF CHAR 1 0
X Yes
NULL No
NTGEW Net Weight NTGEW QUAN 13 3
LOGSYS Logical system LOGSYS TBDLS CHAR 10 0
WBSTA Goods movement status WBSTA CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
CMETH Quantity Conversion Method OIB_CMETH CHAR 1 0
NULL Standard Conversion
1 Quantity Conversion (Oil, Natural Gas,...) with Conv. Group
2 Std Conv. with Tax Group/Without UoM Group (only IS-OIL-TDP)
MJAHR Material Document Year MJAHR NUMC 4 0
VBTYPEXT_V Extension of SD document category of preceding document TDD_VBTYP_EXT_V CHAR 4 0
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)
VBTYPEXT_N Extension of Subsequent SD Document Category TDD_VBTYP_EXT_N CHAR 4 0
f001 Period-End Invoice
f002 Period-End Credit Memo
f003 Period-End Invoice (Intercompany Billing)
f004 Period-End Credit Memo (Intercompany Billing)

VBFA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VBFA BWART VBFA MANDT T156 Movement Type MANDT
VBFA BWART VBFA BWART T156 Movement Type BWART
VBFA FPLNR VBFA MANDT FPLA Billing Plan MANDT
VBFA FPLNR VBFA FPLNR FPLA Billing Plan FPLNR
VBFA LGNUM VBFA MANDT T300 WM Warehouse Numbers MANDT
VBFA LGNUM VBFA LGNUM T300 WM Warehouse Numbers LGNUM
VBFA LOGSYS VBFA LOGSYS TBDLS Logical system LOGSYS
VBFA MANDT VBFA MANDT T000 Clients MANDT
VBFA MATNR VBFA MANDT MARA General Material Data MANDT
VBFA MATNR VBFA MATNR MARA General Material Data MATNR
VBFA MEINS VBFA MEINS T006 Units of Measurement MSEHI
VBFA MEINS VBFA MANDT T006 Units of Measurement MANDT
VBFA POSNN VBFA POSNN VBUP Sales Document: Item Status POSNR
VBFA POSNN VBFA MANDT VBUP Sales Document: Item Status MANDT
VBFA POSNN VBFA VBELN VBUP Sales Document: Item Status VBELN
VBFA POSNV VBFA MANDT VBUP Sales Document: Item Status MANDT
VBFA POSNV VBFA VBELV VBUP Sales Document: Item Status VBELN
VBFA POSNV VBFA POSNV VBUP Sales Document: Item Status POSNR
VBFA VBELN VBFA MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBFA VBELN VBFA VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
VBFA VBELV VBFA MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
VBFA VBELV VBFA VBELV VBUK Sales Document: Header Status and Administrative Data VBELN
VBFA VRKME VBFA MANDT T006 Units of Measurement MANDT
VBFA VRKME VBFA VRKME T006 Units of Measurement MSEHI
VBFA WAERS VBFA MANDT TCURC Currency Codes MANDT
VBFA WAERS VBFA WAERS TCURC Currency Codes WAERS