P_SourcesOfSupplyTypeAgg

Aggregation of sources of supply on type level | view: PSOSTYPEAGG | Extraction: Not supported | Component: Quota Arrangement
Tables used: EKKOEKPOEQUKEQUPT001TKA02MARAMAKTEORDT001WT024WEINAEINELFA1LFB1USR21
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
PurchasingSourceType Purchasing Source Type
Relevance null
SourceOfSupplyIsFixed null
SourceOfSupplyIsBlocked null
QuotaArrangementIsFixed null
Master Data Relations Join Conditions
Material Number
  • Material Number
  • Client
  • P_SOURCESOFSUPPLYTYPEAGG.MATERIAL == MARA.MATNR
  • P_SOURCESOFSUPPLYTYPEAGG.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_SOURCESOFSUPPLYTYPEAGG.MATERIALGROUP == T023.MATKL
  • P_SOURCESOFSUPPLYTYPEAGG.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • P_SOURCESOFSUPPLYTYPEAGG.PLANT == T001W.WERKS
  • P_SOURCESOFSUPPLYTYPEAGG.MANDT == T001W.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • P_SOURCESOFSUPPLYTYPEAGG.MANDT == T024E.MANDT
  • P_SOURCESOFSUPPLYTYPEAGG.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • P_SOURCESOFSUPPLYTYPEAGG.SUPPLIER == LFA1.LIFNR
  • P_SOURCESOFSUPPLYTYPEAGG.MANDT == LFA1.MANDT