P_SupplierByMaterialPlant

Get all Supplier of material + plant | view: PSUPPMATPLANT | TRAN | Extraction: Not supported | Component: VDM Stock and Goods Movements
Tables used: EKKOEKPOEQUKEQUPEQUPEKKOT001TKA02MARAT023TMAKTEORDT001WT024WEINAT024EEINELFA1LFB1LFA1USR21
Column Name Description
Supplier FK Supplier
Plant FK Plant
PurchasingOrganization FK Purchasing organization
Material FK Material Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
Master Data Relations Join Conditions
Material Number
  • Client
  • Material Number
  • P_SUPPLIERBYMATERIALPLANT.MANDT == MARA.MANDT
  • P_SUPPLIERBYMATERIALPLANT.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • P_SUPPLIERBYMATERIALPLANT.MANDT == T001W.MANDT
  • P_SUPPLIERBYMATERIALPLANT.PLANT == T001W.WERKS
Purchasing organization
  • Purchasing organization
  • Client
  • P_SUPPLIERBYMATERIALPLANT.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SUPPLIERBYMATERIALPLANT.MANDT == T024E.MANDT
Supplier
  • Client
  • Supplier
  • P_SUPPLIERBYMATERIALPLANT.MANDT == LFA1.MANDT
  • P_SUPPLIERBYMATERIALPLANT.SUPPLIER == LFA1.LIFNR