MSRD_MD

Master Data Fields of Project Stock with Vendor | #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
PSPNR FK Work Breakdown Structure Element (WBS Element)
Column Name Description
Column Name Description
Column Name Description
RDDLL Date of Last Posted Count
ERSDA Created On
Column Name Description
RDSPR Physical Inventory Blocking Indicator Show values
Column Name Description Domain name
LFGJA Fiscal Year of Current Period GJAHR
LFMON Current period (posting period) MONAT
RDILL Physical inventory indicator for whse stock in current year INVKZ
RDILQ Phys. inventory ind. f. stock in qual. insp. in current year INVKZ
RDVLL Physical inventory indicator for stock in previous year INVKZ
RDVLQ Phys. inventory ind. f. stock in qual. insp. in prev. period INVKZ
RDFLL Physical inventory indicator for stock in following year INVKZ
RDFLQ Physical inventory indicator, quality insp.stck, follow.yr. INVKZ
RDJIN Fiscal year of current physical inventory indicator GJAHR
Master Data Relations Join Conditions
Batch
  • Material Number
  • Batch Number
  • Plant
  • MSRD_MD.MANDT == MCHA.MANDT
  • MSRD_MD.MATNR == MCHA.MATNR
  • MSRD_MD.CHARG == MCHA.CHARG
  • MSRD_MD.WERKS == MCHA.WERKS
Vendor
  • MSRD_MD.MANDT == LFA1.MANDT
  • MSRD_MD.LIFNR == LFA1.LIFNR
Client MSRD_MD.MANDT == T000.MANDT
Material
  • Material Number
  • Client
  • MSRD_MD.MATNR == MARA.MATNR
  • MSRD_MD.MANDT == MARA.MANDT
Special stock indicator
  • MSRD_MD.MANDT == T148.MANDT
  • MSRD_MD.SOBKZ == T148.SOBKZ
Plant
  • Material Number
  • Client
  • Plant
  • MSRD_MD.MATNR == MARC.MATNR
  • MSRD_MD.MANDT == MARC.MANDT
  • MSRD_MD.WERKS == MARC.WERKS