Follow us on LinkedIn for your next SAP project

← Back to Search

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

Possible values

MANDT

Client

MANDT

T000

CLNT

VBELV

Preceding sales and distribution document

VBELN_VON

VBUK

CHAR

POSNV

Preceding item of an SD document

POSNR_VON

VBUP

NUMC

VBELN

Subsequent sales and distribution document

VBELN_NACH

VBUK

CHAR

POSNN

Subsequent item of an SD document

POSNR_NACH

VBUP

NUMC

VBTYP_N

Document category of subsequent document

VBTYP_N

CHAR

Value	Description
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
NULL	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

MEINS

Base Unit of Measure

MEINS

T006

UNIT

RFWRT

Reference value

RFWRT

CURR

WAERS

Statistics currency

WAERS_V

TCURC

CUKY

VBTYP_V

Document category of preceding SD document

VBTYP_V

CHAR

Value	Description
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
NULL	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

Value	Description
NULL	Zero
+	Positive
-	Negative

TAQUI

ID: MM-WM transfer order confirmed

TAQUI

CHAR

Value	Description
X	Yes
NULL	No

ERDAT

Date on Which Record Was Created

ERDAT

DATS

ERZET

Entry time

ERZET

TIMS

MATNR

Material Number

MATNR

MARA

CHAR

BWART

Movement Type (Inventory Management)

BWART

T156

CHAR

BDART

Requirement type

BDART

CHAR

PLART

Planning type

PLART

CHAR

STUFE

Level of the document flow record

STUFE_VBFA

NUMC

LGNUM

Warehouse Number / Warehouse Complex

LGNUM

T300

CHAR

AEDAT

Changed On

AEDAT

DATS

FKTYP

Billing category

FKTYP

CHAR

Value	Description
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

GEWEI

Weight Unit

GEWEI

UNIT

VOLUM

Volume

VOLUM_15

QUAN

VOLEH

Volume unit

VOLEH

UNIT

FPLNR

Billing plan number / invoicing plan number

FPLNR

FPLA

CHAR

FPLTR

Item for billing plan/invoice plan/payment cards

FPLTR

NUMC

RFMNG_FLO

Referenced quantity in sales unit (float)

RFMNG_FLTV

FLTP

RFMNG_FLT

Referenced quantity in base unit of measure (float)

RFMNG_FLT

FLTP

VRKME

Sales unit

VRKME

T006

UNIT

ABGES

Guaranteed (factor between 0 and 1)

ABGES_CM

FLTP

SOBKZ

Special Stock Indicator

SOBKZ

CHAR

SONUM

Special Stock Number

LVS_SONUM

CHAR

KZBEF

Indicator Inventory Management active

LVS_KZBEF

CHAR

Value	Description
X	Yes
NULL	No

NTGEW

Net Weight

NTGEW

QUAN

LOGSYS

Logical system

LOGSYS

TBDLS

CHAR

WBSTA

Goods movement status

WBSTA

CHAR

Value	Description
NULL	Not Relevant
A	Not yet processed
B	Partially processed
C	Completely processed

CMETH

Quantity Conversion Method

OIB_CMETH

CHAR

Value	Description
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

VBTYPEXT_V

Extension of SD document category of preceding document

TDD_VBTYP_EXT_V

CHAR

Value	Description
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

Value	Description
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