I_InvtryMgmtMatlMstrVH

Invtry Management Materials | view: IINVTRYMGMATLVH | Extraction: Not supported | Component: Basic Functions
Tables used: MCH1MCHAMAKTT134TT001WMARAMARCMARA
Column Name Description
Material Material Number
Plant FK Plant
Batch FK Batch Number
Column Name Description
Column Name Description
Column Name Description
ShelfLifeExpirationDate Shelf Life Expiration or Best-Before Date
RootBatShelfLifeExprtnDte Shelf Life Expiration or Best-Before Date
Column Name Description
BatchIsMarkedForDeletion Deletion Flag for All Data in a Batch Show values
BatIsMrkdForDeltnInPlnt Deletion Flag for All Data on a Batch at a Plant Show values
Column Name Description Domain name
MaterialName Material Description TEXT40
PlantName Plant Name TEXT30
MaterialTypeName Description of Material Type TEXT25
AuthorizationGroup Authorization Group BEGRU
DfsProductExternalIdentifier External Representation of Material Number CHAR40
Master Data Relations Join Conditions
Batch Number
  • Client
  • Batch Number
  • Material Number
  • I_INVTRYMGMTMATLMSTRVH.MANDT == MCH1.MANDT
  • I_INVTRYMGMTMATLMSTRVH.BATCH == MCH1.CHARG
  • I_INVTRYMGMTMATLMSTRVH.MATERIAL == MCH1.MATNR
Material type
  • Client
  • Material type
  • I_INVTRYMGMTMATLMSTRVH.MANDT == T134.MANDT
  • I_INVTRYMGMTMATLMSTRVH.MATERIALTYPE == T134.MTART
Plant
  • Client
  • Plant
  • I_INVTRYMGMTMATLMSTRVH.MANDT == T001W.MANDT
  • I_INVTRYMGMTMATLMSTRVH.PLANT == T001W.WERKS
Product Hierarchy
  • Client
  • Product hierarchy
  • I_INVTRYMGMTMATLMSTRVH.MANDT == T179.MANDT
  • I_INVTRYMGMTMATLMSTRVH.PRODUCTHIERARCHY == T179.PRODH
Serial Number Profile
  • Client
  • Serial Number Profile
  • I_INVTRYMGMTMATLMSTRVH.MANDT == T377P.MANDT
  • I_INVTRYMGMTMATLMSTRVH.SERIALNUMBERPROFILE == T377P.SERAIL