VBFA

Transparent Table Application Table
43 Fields 17 CDS Views

Sales Document Flow

VBFA is an SAP database table in S/4HANA. Sales Document Flow. It contains 43 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
ATPC_CDS_PREDECESSOR view from Predecessor documents
EWA_ALY_I_BOI view right_outer Bill Waste Disposal Order Item
EWA_ALY_I_OPS view right_outer Payment status Waste Disposal Order item
EWA_ALY_P_OSB view right_outer
FSH_ATP_VBBE_ALL view left_outer Read View on Table VBBE
fsh_atp_vbbe_p view left_outer Read View on Table VBBE - with Parameters
fsh_atp_vbbe_sel view left_outer View for ATP_VBBE fields
I_BR_SaleHistory view from BASIC Brazil Sale History
I_FldLogsDelivGRQty view from BASIC Outbound delivery quantity
I_FldLogsPutawayQty view from BASIC Field Logistics Putaway Quantity
I_SDDocumentMultiLevelProcFlow view from BASIC SD Document Multi Level Process Flow
V_Vbfa_P1 view from Document Flow Predecessor on Path Level 1
V_Vbfa_P2 view from Document Flow Predecessor on Path Level 2
V_Vbfa_P3 view from Document Flow Predecessor on Path Level 3
v_Vbfa_S1 view from Document Flow Successor on Path Length 1
v_Vbfa_s2 view from Document Flow Successor on Path Length 2
v_Vbfa_s3 view from Document Flow Successor on Path Length 3

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY ruuid SD_DOC_REL_UUID DocRelUUID
vbelv VBELN_VON Preceding Doc.
posnv POSNR_VON Preceding Item
vbeln VBELN_NACH Follow-on Doc.
posnn POSNR_NACH Subsequent Item
vbtyp_n VBTYPL_N Subs.Doc.Categ.
rfmng RFMNG Quantity
meins MEINS Base Unit
rfwrt RFWRT Reference Value
waers WAERS_V Stats Currency
vbtyp_v VBTYPL_V Prec.Doc.Categ.
plmin PLMIN Pos./Negative
taqui TAQUI Confirmation ID
erdat ERDAT Created On
erzet ERZET Time
matnr MATNR Material
bwart BWART Movement Type
bdart BDART RequirementType
plart PLART Planning type
lgnum LGNUM Warehouse No.
aedat AEDAT Changed On
fktyp FKTYP BillingCategory
brgew BRGEW_15 Gross Weight
gewei GEWEI Unit of Weight
volum VOLUM_15 Volume
voleh VOLEH Volume Unit
fplnr FPLNR Bill. Plan No.
fpltr FPLTR Item
rfmng_flo RFMNG_FLTV Quantity
rfmng_flt RFMNG_FLT Quantity
vrkme VRKME Sales Unit
abges ABGES_CM Guaranteed
sobkz SOBKZ Special Stock
sonum LVS_SONUM Spec.Stock No.
kzbef LVS_KZBEF Inv.Mgmt active
ntgew NTGEW Net Weight
logsys LOGSYS Logical system
wbsta WBSTA Goods Mvmnt Sts
cmeth OIB_CMETH Conv. Method
mjahr MJAHR Mat. Doc. Year
stufe STUFE_VBFA Level
_dataaging DATA_TEMPERATURE Data Aging

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Sales Document Flow
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VBFA (
    MANDT,       -- Client [MANDT]
    RUUID,       -- DocRelUUID [SD_DOC_REL_UUID]
    VBELV,       -- Preceding Doc. [VBELN_VON]
    POSNV,       -- Preceding Item [POSNR_VON]
    VBELN,       -- Follow-on Doc. [VBELN_NACH]
    POSNN,       -- Subsequent Item [POSNR_NACH]
    VBTYP_N,     -- Subs.Doc.Categ. [VBTYPL_N]
    RFMNG,       -- Quantity [RFMNG]
    MEINS,       -- Base Unit [MEINS]
    RFWRT,       -- Reference Value [RFWRT]
    WAERS,       -- Stats Currency [WAERS_V]
    VBTYP_V,     -- Prec.Doc.Categ. [VBTYPL_V]
    PLMIN,       -- Pos./Negative [PLMIN]
    TAQUI,       -- Confirmation ID [TAQUI]
    ERDAT,       -- Created On [ERDAT]
    ERZET,       -- Time [ERZET]
    MATNR,       -- Material [MATNR]
    BWART,       -- Movement Type [BWART]
    BDART,       -- RequirementType [BDART]
    PLART,       -- Planning type [PLART]
    LGNUM,       -- Warehouse No. [LGNUM]
    AEDAT,       -- Changed On [AEDAT]
    FKTYP,       -- BillingCategory [FKTYP]
    BRGEW,       -- Gross Weight [BRGEW_15]
    GEWEI,       -- Unit of Weight [GEWEI]
    VOLUM,       -- Volume [VOLUM_15]
    VOLEH,       -- Volume Unit [VOLEH]
    FPLNR,       -- Bill. Plan No. [FPLNR]
    FPLTR,       -- Item [FPLTR]
    RFMNG_FLO,   -- Quantity [RFMNG_FLTV]
    RFMNG_FLT,   -- Quantity [RFMNG_FLT]
    VRKME,       -- Sales Unit [VRKME]
    ABGES,       -- Guaranteed [ABGES_CM]
    SOBKZ,       -- Special Stock [SOBKZ]
    SONUM,       -- Spec.Stock No. [LVS_SONUM]
    KZBEF,       -- Inv.Mgmt active [LVS_KZBEF]
    NTGEW,       -- Net Weight [NTGEW]
    LOGSYS,      -- Logical system [LOGSYS]
    WBSTA,       -- Goods Mvmnt Sts [WBSTA]
    CMETH,       -- Conv. Method [OIB_CMETH]
    MJAHR,       -- Mat. Doc. Year [MJAHR]
    STUFE,       -- Level [STUFE_VBFA]
    _DATAAGING,  -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, RUUID)
);

Learn More