MCSD

Customer Stock | view | #masterdata | Component: Spare Part Sharing and Stock Providede by Customer
Column Name Description
MANDT FK Client
MATNR FK Material Number
WERKS FK Plant
LGORT FK Storage location
CHARG FK Batch Number
SOBKZ FK Special Stock Indicator
KUNNR FK Customer Number
Column Name Description
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
SDLAB Valuated Unrestricted-Use Stock
SDINS Stock in Quality Inspection
SDSPE Blocked Stock
SDEIN Total Stock of All Restricted Batches
SDVLA Valuated unrestricted-use stock in previous period
SDVIN Stock in Quality Inspection in Previous Period
SDVSP Blocked stock of previous period
SDVEI Restricted-Use Stock in Previous Period
Column Name Description
ERSDA Created On
SDDLL Date of Last Posted Count
Column Name Description
SDSPR Physical Inventory Blocking Indicator Show values
SDRUE 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
SDILL Physical inventory indicator for whse stock in current year INVKZ
SDILQ Phys. inventory ind. f. stock in qual. insp. in current year INVKZ
SDILS Physical inventory indicator for blocked stock INVKZ
SDVLL Physical inventory indicator for stock in previous year INVKZ
SDVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period INVKZ
SDVLS Phys. inventory indicator for blocked stock in prev. period INVKZ
SDFLL Physical inventory indicator for stock in following year INVKZ
SDFLQ Physical inventory indicator, quality insp.stck, follow.yr. INVKZ
SDFLS Phys. inventory ind. for blocked stock in following period INVKZ
SDJIN Fiscal year of current physical inventory indicator GJAHR
Master Data Relations Join Conditions
Material/plant/batch
  • Material Number
  • Batch Number
  • Plant
  • MCSD.MANDT == MCHA.MANDT
  • MCSD.MATNR == MCHA.MATNR
  • MCSD.CHARG == MCHA.CHARG
  • MCSD.WERKS == MCHA.WERKS
Vendor
  • MCSD.MANDT == KNA1.MANDT
  • MCSD.KUNNR == KNA1.KUNNR
Storage location
  • Plant
  • Material Number
  • Storage location
  • MCSD.MANDT == MARD.MANDT
  • MCSD.WERKS == MARD.WERKS
  • MCSD.MATNR == MARD.MATNR
  • MCSD.LGORT == MARD.LGORT
Client MCSD.MANDT == T000.MANDT
Material
  • Material Number
  • Client
  • MCSD.MATNR == MARA.MATNR
  • MCSD.MANDT == MARA.MANDT
Special stock indicator
  • MCSD.MANDT == T148.MANDT
  • MCSD.SOBKZ == T148.SOBKZ
Plant
  • Material Number
  • Client
  • Plant
  • MCSD.MATNR == MARC.MATNR
  • MCSD.MANDT == MARC.MANDT
  • MCSD.WERKS == MARC.WERKS