SAP VBFA Sales Document Flow Table data and field list

VBFA is a standard SAP Table which is used to store Sales Document Flow data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The VBFA table consists of various fields, each holding specific information or linking keys about Sales Document Flow data available in SAP. These include VBELV (Preceding sales and distribution document), POSNV (Preceding item of an SD document), VBELN (Subsequent sales and distribution document), POSNN (Subsequent item of an SD document)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

VBFA table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VBFA table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VBFA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
VBELVPreceding sales and distribution document VBELN_VONCHAR10VBUKALPHAVBELNAUF
POSNVPreceding item of an SD document POSNR_VONNUMC6VBUPPOSNR
VBELNSubsequent sales and distribution document VBELN_NACHCHAR10VBUKALPHAVBELNAUF
POSNNSubsequent item of an SD document POSNR_NACHNUMC6VBUPPOSNR
VBTYP_NDocument category of subsequent document VBTYP_NCHAR1VBTYP
RFMNGReferenced quantity in base unit of measure RFMNGQUAN15(3) MENG15
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
RFWRTReference value RFWRTCURR15(2) WERTV8
WAERSStatistics currency WAERS_VCUKY5TCURCWAERS
VBTYP_VDocument category of preceding SD document VBTYP_VCHAR1VBTYP
PLMINQuantity is calculated positively, negatively or not at all PLMINCHAR1PLMIN
TAQUIID: MM-WM transfer order confirmed TAQUICHAR1XFELD
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERZETEntry time ERZETTIMS6UZEIT
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
BWARTMovement Type (Inventory Management) BWARTCHAR3T156BWARTBWA
BDARTRequirement type BDARTCHAR2BDARTBDA
PLARTPlanning type PLARTCHAR1Assigned to domainPLART
STUFELevel of the document flow record STUFE_VBFANUMC2NUM2
LGNUMWarehouse Number / Warehouse Complex LGNUMCHAR3T300LGNUMLGN
AEDATChanged On AEDATDATS8DATUM
FKTYPBilling category FKTYPCHAR1FKTYP
BRGEWGross weight BRGEW_15QUAN15(3) MENG15
GEWEIWeight Unit GEWEIUNIT3Assigned to domainCUNITMEINS
VOLUMVolume VOLUM_15QUAN15(3) MENG15
VOLEHVolume unit VOLEHUNIT3Assigned to domainCUNITMEINS
FPLNRBilling plan number / invoicing plan number FPLNRCHAR10FPLAFPLNR
FPLTRItem for billing plan/invoice plan/payment cards FPLTRNUMC6Assigned to domainFPLTR
RFMNG_FLOReferenced quantity in sales unit (float) RFMNG_FLTVFLTP16(16) RFMNG_FLO
RFMNG_FLTReferenced quantity in base unit of measure (float) RFMNG_FLTFLTP16(16) RFMNG_FLO
VRKMESales unit VRKMEUNIT3T006CUNITMEINS
ABGESGuaranteed (factor between 0 and 1) ABGES_CMFLTP16(16) FLTP
SOBKZSpecial Stock Indicator SOBKZCHAR1Assigned to domainSOBKZ
SONUMSpecial Stock Number LVS_SONUMCHAR16ALPHALVS_SONUM
KZBEFIndicator Inventory Management active LVS_KZBEFCHAR1XFELD
NTGEWNet Weight NTGEWQUAN13(3) MENG13
LOGSYSLogical system LOGSYSCHAR10TBDLSALPHALOGSYS
WBSTAGoods movement status WBSTACHAR1STATV
CMETHQuantity Conversion Method OIB_CMETHCHAR1OIB_CMETH
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
VBTYPEXT_VExtension of SD document category of preceding document TDD_VBTYP_EXT_VCHAR4DOM_VBTYP_EXT
VBTYPEXT_NExtension of Subsequent SD Document Category TDD_VBTYP_EXT_NCHAR4DOM_VBTYP_EXT

Key field Non-key field



How do I retrieve data from SAP table VBFA using ABAP code

The following ABAP code Example will allow you to do a basic selection on VBFA to SELECT all data from the table
DATA: WA_VBFA TYPE VBFA.

SELECT SINGLE *
FROM VBFA
INTO CORRESPONDING FIELDS OF WA_VBFA
WHERE...

How to access SAP table VBFA

Within an ECC or HANA version of SAP you can also view further information about VBFA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to VBFA

    ADMIX - Help structure for reading via ADK in LDB(SD)
        VBUK - Sales Doc.: Header Status and Administrative Data
    VBPA - Sales Document: Partner
    SADR - Address Management: Company data
    VBUV - Sales Document: Incompletion Log
    STXH - STXD SAPscript text file header
    STXL - STXD SAPscript text file lines
    CDHDR - Change document header
    CDPOS - Change document items
    VBAK - Sales Document: Header Data
        VBFA - Sales Document Flow
        NAST - Message status
        VBKD - Sales Document: Business Data
        VBUP - Sales Document: Item Status
        VBAP - Sales Document: Item Data
        VBEP - Sales Document: Schedule Line Data
        KONV - Conditions (Transaction Data)

    VBUK - Sales Document: Header Status and Admin. Data
        VBKA - Sales activities
            NAST - Message status
            VBFA - Sales Document Flow
            VBPA - Sales Document: Partner
            SADR - Address Management: Company data
            STXH - STXD SAPscript text file header
            STXL - STXD SAPscript text file lines
            VBUV - Sales Document: Incompletion Log

    ADMIX - Help structure for reading via ADK in LDB(SD)
        VBUK - Sales Document: Header Status and Admin. Data
    EIKP - Foreign Trade: Export/Import Header Data
    EIPO - Foreign Trade: Export/Import: Item Data
    VEKP - SD Document: Shipping Unit Header
    VEPO - SD Document: Shipping Unit Item (Content)
    STXH - STXD SAPscript text file header
    STXL - STXD SAPscript text file lines
        LIKP - SD Document: Delivery Header Data
            VBFA - Sales Document Flow
            NAST - Message status
            VBUP - Sales Document: Item Status
            LIPS - SD document: Delivery: Item data
            VBPA - Sales Document: Partner
            SADR - Address Management: Company data
            VBSSSK - Table Generated for View VBSSSK

    ADMIX - Help structure for reading via ADK in LDB(SD)
        VBUK - Sales Document: Header Status and Admin. Data
    EIKP - Foreign Trade: Export/Import Header Data
    EIPO - Foreign Trade: Export/Import: Item Data
    STXH - STXD SAPscript text file header
    STXL - STXD SAPscript text file lines
    VBRL - Sales Document: Invoice List
        VBRK - Billing Document: Header Data
            NAST - Message status
            VBFA - Sales Document Flow
            VBRP - Billing Document: Item Data
            KONV - Conditions (Transaction Data)
            VBPA - Sales Document: Partner
            SADR - Address Management: Company data
            VBSSSK - Table Generated for View VBSSSK

    VAKPA - vakpa
        VBAK - Sales Document: Header Data
    VBFAVG - Sales document: Cumulative records,followed by doc
    KONV - Conditions (Transaction Data)
    FPLT - SD document: Billing plan item
        VBUP - Sales Document: Item Status
        VEDAPO - SD document: Contract data item
        VBUK - SD document: Header status and administration
        VBKD - Sales Document: Business Data
        VEDA - SD document: Contract data header
        VFPLA - SD document: Billing plan header
            VFPLT - SD document: Billing plan item
        VBUV - SD document: Incompletion log
        VBPA - Sales Document: Partner
            VBADR - Address work area
        VBAP - Sales Document: Item Data
            VBKDPO - SD document: Business item data
            VBPAPO - Item partner for SD document
            VBEP - Sales Document: Schedule Line Data
            VBFA - Sales Document Flow

    VAKPA - SD document: Indices
        VBUK - SD document: Header status and administration
        VFPLA - SD document: Billing plan payment cards
            VFPLT - SD document: Billing plan payment cards
        VBUP - Sales Document: Item Status
            VBAP - Sales Document: Item Data
                VBKDPO - SD document: Business item data
                    FPLAPO - SD document: Billing plan
                        FPLTPO - SD document: Billing plan dates
                VBPAPO - Item partner for SD document
                    VBADRPO - Address work area
                VEDAPO - SD document: Contract data item
        VBAK - Sales Document: Header Data
                VBEP - Sales Document: Schedule Line Data
                VBFA - Sales Document Flow
                VBFAVG - Sales document: Cumulative records,followed by doc
                KONV - Conditions (Transaction Data)
        VBKD - Sales Document: Business Data
            FPLA - SD document: Billing plan
                FPLT - SD document: Billing plan dates
        VBUV - SD document: Incompletion log
        VBPA - SD document: Partner
            VBADR - Address work area
        VEDA - SD document: Contract data header

    VBAK - Sales Document: Header Data
        VBUK - Sales Doc.: Header Status and Administrative Data
                VBFA - Sales Document Flow
                VBFAVG - Sales document: Cumulative records,followed by doc
                KONV - Conditions (Transaction Data)
        VBKD - Sales Document: Business Data
            VBPA - Sales Document: Partner
        VBUV - Sales Document: Incompletion Log
        VBAP - Sales Document: Item Data
            VBUP - Sales Document: Item Status
            VBKDPO - Sales document: Business item data (POSNR > 0)
            VBPAPO - Item partner of sales document (for LDB)
            VBEP - Sales Document: Schedule Line Data

    VBKPA - SD index: Sales activities by partner function
        VBKA - Sales activities
            KNVV - Customer Master Sales Data
            KNVK - Customer Master Contact Partner
            VBADR - Address work area
        VBFA - Sales Document Flow
            VBAK - Sales Document: Header Data
            SADLSTADM - Administrative Data - Address List
                SADLSTIAD - Administration Table for Address Lists
                    SADLSTRECH - Statistical part of an address list (rec. header)
                    SADLSTRECB - Dynamic part of address record (record body)
                SADLSTDIR1 - Address List Directory
            SADLSTSORT - Sort Fields for Address List
        VBPA - Sales Document: Partner
            KNA1 - General Data in Customer Master

    VBRK - Billing Document: Header Data
        VBUK - Sales Doc.: Header Status and Administrative Data
        VBPA - Sales Document: Partner
        VBRP - Billing Document: Item Data
            VBFA - Sales Document Flow
            VBFAVG - Sales document: Cumulative records,followed by doc
            VBPAPO - Item partner of sales document (for LDB)
            KONV - Conditions (Transaction Data)

    LIKP - SD Document: Delivery Header Data
        VBUK - Sales Doc.: Header Status and Administrative Data
        LIPS - SD document: Delivery: Item data
            VBUP - Sales Document: Item Status
            VBFA - Sales Document Flow
            VBFAVG - Sales document: Cumulative records,followed by doc
        VBPA - Sales Document: Partner

    VBAK - Sales Document: Header Data
        VBUK - Sales Doc.: Header Status and Administrative Data
            VBFA - Sales Document Flow
            VBFAVG - Sales document: Cumulative records,followed by doc
            KONV - Conditions (Transaction Data)
        VBKD - Sales Document: Business Data
            VBPA - Sales Document: Partner
        VBUV - Sales Document: Incompletion Log
        VBAP - Sales Document: Item Data
            VBUP - Sales Document: Item Status
            VBKDPO - Sales document: Business item data (POSNR > 0)
            VBPAPO - Item partner of sales document (for LDB)
            VBEP - Sales Document: Schedule Line Data