1. Home
  2. Resources
  3. SAP Tables
  4. MSFD - Sales Order Stock with Vendor

SAP Table MSFD

Sales Order Stock with Vendor

MSFD (Sales Order Stock with Vendor) 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 MSFD to other SAP tables.

MSFD table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
WERKS Plant WERKS_D MARC CHAR 4 0
CHARG Batch Number CHARG_D MCHA CHAR 10 0
SOBKZ Special Stock Indicator SOBKZ T148 CHAR 1 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
VBELN Sales and Distribution Document Number VBELN VBUK CHAR 10 0
POSNR Item number of the SD document POSNR VBUP NUMC 6 0
LFGJA Fiscal Year of Current Period LFGJA NUMC 4 0
LFMON Current period (posting period) LFMON NUMC 2 0
FDSPR Physical Inventory Blocking Indicator SPERR CHAR 1 0
NULL No physical inventory defined for material
X Due to phys. inv., material is blocked for movements
A Physical inventory not yet completed for material
FDLAB Valuated Unrestricted-Use Stock LABST QUAN 13 3
FDINS Stock in Quality Inspection INSME QUAN 13 3
FDVLA Valuated unrestricted-use stock in previous period VMLAB QUAN 13 3
FDVIN Stock in Quality Inspection in Previous Period VMINS QUAN 13 3
FDILL Physical inventory indicator for whse stock in current year KZILL CHAR 3 0
FDILQ Phys. inventory ind. f. stock in qual. insp. in current year KZILQ CHAR 3 0
FDVLL Physical inventory indicator for stock in previous year KZVLL CHAR 3 0
FDVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period KZVLQ CHAR 3 0
FDFLL Physical inventory indicator for stock in following year KZFLL CHAR 3 0
FDFLQ Physical inventory indicator, quality insp.stck, follow.yr. KZFLQ CHAR 3 0
FDDLL Date of Last Posted Count for Unrestricted-Use Stock DLINL DATS 8 0
FDEIN Total Stock of All Restricted Batches EINME QUAN 13 3
FDVEI Restricted-Use Stock in Previous Period VMEIN QUAN 13 3
ERSDA Created On ERSDA DATS 8 0
FDJIN Fiscal year of current physical inventory indicator GJINV NUMC 4 0
FDRUE MxxxH rec. already exists for per. before last of Mxxx per. SBRUE CHAR 1 0
X Yes
NULL No

MSFD foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MSFD CHARG MSFD MANDT MCHA Batches MANDT
MSFD CHARG MSFD MATNR MCHA Batches MATNR
MSFD CHARG MSFD WERKS MCHA Batches WERKS
MSFD CHARG MSFD CHARG MCHA Batches CHARG
MSFD LIFNR MSFD MANDT LFA1 Vendor Master (General Section) MANDT
MSFD LIFNR MSFD LIFNR LFA1 Vendor Master (General Section) LIFNR
MSFD MANDT MSFD MANDT T000 Clients MANDT
MSFD MATNR MSFD MANDT MARA General Material Data MANDT
MSFD MATNR MSFD MATNR MARA General Material Data MATNR
MSFD POSNR MSFD POSNR VBUP Sales Document: Item Status POSNR
MSFD POSNR MSFD MANDT VBUP Sales Document: Item Status MANDT
MSFD POSNR MSFD VBELN VBUP Sales Document: Item Status VBELN
MSFD SOBKZ MSFD MANDT T148 Special Stock Indicator MANDT
MSFD SOBKZ MSFD SOBKZ T148 Special Stock Indicator SOBKZ
MSFD VBELN MSFD MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
MSFD VBELN MSFD VBELN VBUK Sales Document: Header Status and Administrative Data VBELN
MSFD WERKS MSFD MANDT MARC Plant Data for Material MANDT
MSFD WERKS MSFD MATNR MARC Plant Data for Material MATNR
MSFD WERKS MSFD WERKS MARC Plant Data for Material WERKS