SAP Table VBFA stores Sales Document Flowdata

  

In this post, I will try and describe everything you need to know about the SAP vbfa table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for VBFA what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from VBFA....Right lets get started!


SAP VBFA dictionary attributes

Object Name: VBFA
Dictionary Type: Transparent table
Description: Sales Document Flow


VBFA field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) T000ClientMANDTTEST
VBELVVBELN_VONCHAR10(0) VBUKPreceding sales and distribution documentVBELNAUFV
POSNVPOSNR_VONNUMC6(0) VBUPPreceding item of an SD documentPOSNRV
VBELNVBELN_NACHCHAR10(0) VBUKSubsequent sales and distribution documentVBELNAUFV
POSNNPOSNR_NACHNUMC6(0) VBUPSubsequent item of an SD documentPOSNRV
VBTYP_NVBTYP_NCHAR1(0) Document category of subsequent documentVBTYPV
RFMNGRFMNGQUAN15(3) Referenced quantity in base unit of measureMENG15VA
MEINSMEINSUNIT3(0) T006Base Unit of MeasureMEINSMG
RFWRTRFWRTCURR15(2) Reference valueWERTV8VF
WAERSWAERS_VCUKY5(0) TCURCStatistics currencyWAERSV
VBTYP_VVBTYP_VCHAR1(0) Document category of preceding SD documentVBTYPV
PLMINPLMINCHAR1(0) Quantity is calculated positively, negatively or not at allPLMINVS
TAQUITAQUICHAR1(0) ID: MM-WM transfer order confirmedXFELDVL
ERDATERDATDATS8(0) Date on Which Record Was CreatedDATUMSAP
ERZETERZETTIMS6(0) Entry timeUZEITSAP
MATNRMATNRCHAR18(0) MARAMaterial NumberMATNRMATMGS_MAT1MATNR
BWARTBWARTCHAR3(0) T156Movement Type (Inventory Management)BWARTBWAMB
BDARTBDARTCHAR2(0) Requirement typeBDARTBDAVA
PLARTPLARTCHAR1(0) *Planning typePLARTMD
STUFESTUFE_VBFANUMC2(0) Level of the document flow recordNUM2VS
LGNUMLGNUMCHAR3(0) T300Warehouse Number / Warehouse ComplexLGNUMLGNLVS
AEDATAEDATDATS8(0) Changed OnDATUMSAP
FKTYPFKTYPCHAR1(0) Billing categoryFKTYPVF
BRGEWBRGEW_15QUAN15(3) Gross weightMENG15V
GEWEIGEWEIUNIT3(0) *Weight UnitMEINSMG
VOLUMVOLUM_15QUAN15(3) VolumeMENG15V
VOLEHVOLEHUNIT3(0) *Volume unitMEINSV
FPLNRFPLNRCHAR10(0) FPLABilling plan number / invoicing plan numberFPLNR
FPLTRFPLTRNUMC6(0) *Item for billing plan/invoice plan/payment cardsFPLTR
RFMNG_FLORFMNG_FLTVFLTP16(16) Referenced quantity in sales unit (float)RFMNG_FLO
RFMNG_FLTRFMNG_FLTFLTP16(16) Referenced quantity in base unit of measure (float)RFMNG_FLO
VRKMEVRKMEUNIT3(0) T006Sales unitMEINSV
ABGESABGES_CMFLTP16(16) Guaranteed (factor between 0 and 1)FLTP
SOBKZSOBKZCHAR1(0) *Special Stock IndicatorSOBKZMG
SONUMLVS_SONUMCHAR16(0) Special Stock NumberLVS_SONUMLVS
KZBEFLVS_KZBEFCHAR1(0) Indicator Inventory Management activeXFELD
NTGEWNTGEWQUAN13(3) Net WeightMENG13MG
LOGSYSLOGSYSCHAR10(0) TBDLSLogical systemLOGSYS
WBSTAWBSTACHAR1(0) Goods movement statusSTATVV
CMETHOIB_CMETHCHAR1(0) Quantity Conversion MethodOIB_CMETH
MJAHRMJAHRNUMC4(0) Material Document YearGJAHRMJAMB
VBTYPEXT_VTDD_VBTYP_EXT_VCHAR4(0) Extension of SD document category of preceding documentDOM_VBTYP_EXT
VBTYPEXT_NTDD_VBTYP_EXT_NCHAR4(0) Extension of Subsequent SD Document CategoryDOM_VBTYP_EXT