P_SourcesOfSupply

Collection of all individual SOS records | view: PSOS | 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
CreationDate Creation Date of Purchasing Document
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurInfoRecordCat Purchasing info record category Show values
Column Name Description Domain name
MaterialName Material Description TEXT40
SourceDocument Purchasing Document Number EBELN
SourceDocumentItem Item Number of Purchasing Document EBELP
QuotaInPercent Quota of Quota Arrangement Item in Percent PRZ31
PurchasingSourceType Purchasing Source Type
SourceOfSupplyIsFixed null
SourceOfSupplyIsBlocked null
QuotaArrangementIsFixed null
SourceListRecord Number of Source List Record NUM5
Master Data Relations Join Conditions
Material number
  • Client
  • Material number
  • P_SOURCESOFSUPPLY.MANDT == MARA.MANDT
  • P_SOURCESOFSUPPLY.MANUFACTURERMATERIAL == MARA.MATNR
Material Number
  • Material Number
  • Client
  • P_SOURCESOFSUPPLY.MATERIAL == MARA.MATNR
  • P_SOURCESOFSUPPLY.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • P_SOURCESOFSUPPLY.MATERIALGROUP == T023.MATKL
  • P_SOURCESOFSUPPLY.MANDT == T023.MANDT
Plant
  • Client
  • Plant
  • P_SOURCESOFSUPPLY.MANDT == T001W.MANDT
  • P_SOURCESOFSUPPLY.PLANT == T001W.WERKS
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • Purchasing Document Category
  • P_SOURCESOFSUPPLY.MANDT == T161.MANDT
  • P_SOURCESOFSUPPLY.PURCHASINGDOCUMENTTYPE == T161.BSART
  • P_SOURCESOFSUPPLY.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • P_SOURCESOFSUPPLY.MANDT == T024.MANDT
  • P_SOURCESOFSUPPLY.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • P_SOURCESOFSUPPLY.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SOURCESOFSUPPLY.MANDT == T024E.MANDT
Storage Location
  • Storage Location
  • Client
  • Plant
  • P_SOURCESOFSUPPLY.STORAGELOCATION == T001L.LGORT
  • P_SOURCESOFSUPPLY.MANDT == T001L.MANDT
  • P_SOURCESOFSUPPLY.PLANT == T001L.WERKS
Supplier
  • Supplier
  • Client
  • P_SOURCESOFSUPPLY.SUPPLIER == LFA1.LIFNR
  • P_SOURCESOFSUPPLY.MANDT == LFA1.MANDT