MSFS

Sales Order Stock with Vendor - Total | view | #masterdata | Component: Spare Part Sharing and Stock Providede by Customer
Column Name Description
MANDT FK Client
MATNR FK Material Number
WERKS FK Plant
SOBKZ FK Special Stock Indicator
LIFNR FK Account Number of Supplier
VBELN Sales and Distribution Document Number
POSNR Item number of the SD document
Column Name Description
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
FSLAB Valuated Unrestricted-Use Stock
FSINS Stock in Quality Inspection
FSEIN Total Stock of All Restricted Batches
Column Name Description
ERSDA Created On
Column Name Description
XOBEW Vendor Stock Valuation Indicator Show values
FSRUE MxxxH rec. already exists for per. before last of Mxxx per. Show values
Column Name Description Domain name
LFGJA Fiscal Year of Current Period GJAHR
LFMON Current period (posting period) MONAT
Master Data Relations Join Conditions
Vendor
  • MSFS.MANDT == LFA1.MANDT
  • MSFS.LIFNR == LFA1.LIFNR
Client MSFS.MANDT == T000.MANDT
Material
  • Material Number
  • Client
  • MSFS.MATNR == MARA.MATNR
  • MSFS.MANDT == MARA.MANDT
Special stock indicator
  • MSFS.MANDT == T148.MANDT
  • MSFS.SOBKZ == T148.SOBKZ
Plant
  • MSFS.MANDT == T001W.MANDT
  • MSFS.WERKS == T001W.WERKS