SAP Table WB2_INDEX_SORTED_VBFA

Trading Expenses: VBFA with Index and Additional Info

WB2_INDEX_SORTED_VBFA (Trading Expenses: VBFA with Index and Additional Info) 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 WB2_INDEX_SORTED_VBFA to other SAP tables.

Source: WB2_INDEX_SORTED_VBFA (Trading Expenses: VBFA with Index and Additional Info)

WB2_INDEX_SORTED_VBFA table fields

Field Data element Checktable Datatype Length Decimals
INDEX INT4 10 0
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)
MENGE_2 Quantity Ordered Against this Purchase Requisition BSMNG QUAN 13 3
MEINS_2 Purchase Order Unit of Measure BSTME UNIT 3 0
VALUE_2 Net value of the order item in document currency NETWR_AP CURR 15 2
WAERS_2 Currency Key WAERS CUKY 5 0
CHARG Batch Number CHARG_D CHAR 10 0
BWTAR Valuation Type BWTAR_D CHAR 10 0

WB2_INDEX_SORTED_VBFA foreign key relationships

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