P_SourcesOfSupplyMatchAgg

Agg. of sources of supply on supplier-material level | view: PSOSMATCHAGG | Extraction: Not supported | Component: Quota Arrangement
Tables used: EKKOEKPOEQUKEQUPEQUPEKKOT001TKA02MARAMAKTEORDT001WT024WEINAEINELFA1LFB1LFA1USR21
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
MaterialName Material Description TEXT40
SourceOfSupplyIsBlocked null
SourceOfSupplyIsFixed null
QuotaArrangementIsFixed null
Relevance null
Master Data Relations Join Conditions
Material Number
  • Material Number
  • Client
  • P_SOURCESOFSUPPLYMATCHAGG.MATERIAL == MARA.MATNR
  • P_SOURCESOFSUPPLYMATCHAGG.MANDT == MARA.MANDT
Plant
  • Client
  • Plant
  • P_SOURCESOFSUPPLYMATCHAGG.MANDT == T001W.MANDT
  • P_SOURCESOFSUPPLYMATCHAGG.PLANT == T001W.WERKS
Purchasing organization
  • Purchasing organization
  • Client
  • P_SOURCESOFSUPPLYMATCHAGG.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SOURCESOFSUPPLYMATCHAGG.MANDT == T024E.MANDT
Supplier
  • Client
  • Supplier
  • P_SOURCESOFSUPPLYMATCHAGG.MANDT == LFA1.MANDT
  • P_SOURCESOFSUPPLYMATCHAGG.SUPPLIER == LFA1.LIFNR