MSOA

Total Sales Orders on Hand with Supplier | #masterdata | Component: Material Master
Column Name Description
MANDT FK Client
MATNR FK Material Number
WERKS FK Plant
LIFNR FK Account Number of Supplier
SOBKZ FK Special Stock Indicator
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):
OALAB Valuated Unrestricted-Use Stock
OAINS Stock in Quality Inspection
OASPE Blocked Stock
Column Name Description
Column Name Description
Column Name Description Domain name
LFGJA Fiscal Year of Current Period GJAHR
LFMON Current period (posting period) MONAT
Master Data Relations Join Conditions
Vendor
  • MSOA.MANDT == LFA1.MANDT
  • MSOA.LIFNR == LFA1.LIFNR
Client MSOA.MANDT == T000.MANDT
Material No.
  • Material Number
  • Client
  • MSOA.MATNR == MARA.MATNR
  • MSOA.MANDT == MARA.MANDT
Sonderbestandskennzeichen
  • MSOA.MANDT == T148.MANDT
  • MSOA.SOBKZ == T148.SOBKZ
Plant
  • MSOA.MANDT == T001W.MANDT
  • MSOA.WERKS == T001W.WERKS