MSCD

Customer stock with vendor | view | #masterdata | Component: Spare Part Sharing and Stock Providede by Customer
Column Name Description
MANDT FK Client
MATNR FK Material Number
WERKS FK Plant
CHARG FK Batch Number
SOBKZ FK Special Stock Indicator
LIFNR FK Account Number of Supplier
KUNNR FK Customer Number
Column Name Description
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
CDLAB Valuated Unrestricted-Use Stock
CDINS Stock in Quality Inspection
CDVLA Valuated unrestricted-use stock in previous period
CDVIN Stock in Quality Inspection in Previous Period
CDEIN Total Stock of All Restricted Batches
CDVEI Restricted-Use Stock in Previous Period
Column Name Description
CDDLL Date of Last Posted Count
ERSDA Created On
Column Name Description
CDSPR Physical Inventory Blocking Indicator Show values
CDRUE 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
CDILL Physical inventory indicator for whse stock in current year INVKZ
CDILQ Phys. inventory ind. f. stock in qual. insp. in current year INVKZ
CDVLL Physical inventory indicator for stock in previous year INVKZ
CDVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period INVKZ
CDFLL Physical inventory indicator for stock in following year INVKZ
CDFLQ Physical inventory indicator, quality insp.stck, follow.yr. INVKZ
CDJIN Fiscal year of current physical inventory indicator GJAHR
Master Data Relations Join Conditions
Batch
  • Material Number
  • Batch Number
  • Plant
  • MSCD.MANDT == MCHA.MANDT
  • MSCD.MATNR == MCHA.MATNR
  • MSCD.CHARG == MCHA.CHARG
  • MSCD.WERKS == MCHA.WERKS
Customer Number
  • MSCD.MANDT == KNA1.MANDT
  • MSCD.KUNNR == KNA1.KUNNR
Vendor
  • MSCD.MANDT == LFA1.MANDT
  • MSCD.LIFNR == LFA1.LIFNR
Client MSCD.MANDT == T000.MANDT
Material
  • Material Number
  • Client
  • MSCD.MATNR == MARA.MATNR
  • MSCD.MANDT == MARA.MANDT
Special stock indicator
  • MSCD.MANDT == T148.MANDT
  • MSCD.SOBKZ == T148.SOBKZ
Plant
  • Material Number
  • Client
  • Plant
  • MSCD.MATNR == MARC.MATNR
  • MSCD.MANDT == MARC.MANDT
  • MSCD.WERKS == MARC.WERKS