P_InvtryMgmtSuplrInfoRecdVH

Invtry Management Materials Supplier Inforecord | view: PINVTRYSUPIRECVH | Extraction: Not supported | Component: Basic Functions
Tables used: MCHAMAKTT134TT001WLFA1EINAMARAMARC
Column Name Description
Material Material Number
Plant FK Plant
Batch FK Batch Number
Supplier FK Vendor's account number
Column Name Description
Column Name Description
Column Name Description
ShelfLifeExpirationDate Shelf Life Expiration or Best-Before Date
Column Name Description
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
SupplierName Name 1 NAME
SupplierBasicAuthorizationGrp Authorization Group BRGRU
Master Data Relations Join Conditions
Batch Number
  • Client
  • Batch Number
  • Material Number
  • P_INVTRYMGMTSUPLRINFORECDVH.MANDT == MCH1.MANDT
  • P_INVTRYMGMTSUPLRINFORECDVH.BATCH == MCH1.CHARG
  • P_INVTRYMGMTSUPLRINFORECDVH.MATERIAL == MCH1.MATNR
Material type
  • Client
  • Material type
  • P_INVTRYMGMTSUPLRINFORECDVH.MANDT == T134.MANDT
  • P_INVTRYMGMTSUPLRINFORECDVH.MATERIALTYPE == T134.MTART
Plant
  • Client
  • Plant
  • P_INVTRYMGMTSUPLRINFORECDVH.MANDT == T001W.MANDT
  • P_INVTRYMGMTSUPLRINFORECDVH.PLANT == T001W.WERKS
Product Hierarchy
  • Client
  • Product hierarchy
  • P_INVTRYMGMTSUPLRINFORECDVH.MANDT == T179.MANDT
  • P_INVTRYMGMTSUPLRINFORECDVH.PRODUCTHIERARCHY == T179.PRODH
Serial Number Profile
  • Client
  • Serial Number Profile
  • P_INVTRYMGMTSUPLRINFORECDVH.MANDT == T377P.MANDT
  • P_INVTRYMGMTSUPLRINFORECDVH.SERIALNUMBERPROFILE == T377P.SERAIL
Vendor's account number
  • Client
  • Vendor's account number
  • P_INVTRYMGMTSUPLRINFORECDVH.MANDT == LFA1.MANDT
  • P_INVTRYMGMTSUPLRINFORECDVH.SUPPLIER == LFA1.LIFNR