C_SourcesOfSupply

Sources of Supply | view: CMMSOSSIMULATE | Extraction: Not supported | Component: Vendor-Material Relationships and Conditions
Tables used: EKKOEKPOEQUKEQUPEQUPMARAEORDEINAEINEA017A018A025A028KONPLFA1LFA1LFM2LFM1USR21
Column Name Description
SourceDocument FK Purchasing Document Number
SourceDocumentItem Item Number of Purchasing Document
Material FK Material Number
Plant FK Plant
SourceListRecord Number of Source List Record
PurchasingInfoRecordCategory Purchasing info record category Show values
Column Name Description
Column Name Description
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
ValidFrom Source List Record Valid From
ValidTo Source List Record Valid To
Column Name Description
PurchasingInfoRecordCategory Purchasing info record category Show values
PurOutlineAgreementIsFixed Fixed Outline Purchase Agreement Item Show values
SourceOfSupplyIsFixed General Flag Show values
SourceOfSupplyIsBlocked Blocked Source of Supply Show values
Column Name Description Domain name
PurchasingSourceType null
Supplier Account Number of Supplier LIFNR
SupplierName Name 1 NAME
AuthorizationGroup Authorization Group BRGRU
QuotaInPercent null
SupplierRank null
Master Data Relations Join Conditions
Material Number
  • Material Number
  • Client
  • C_SOURCESOFSUPPLY.MATERIAL == MARA.MATNR
  • C_SOURCESOFSUPPLY.MANDT == MARA.MANDT
Plant
  • Client
  • Plant
  • C_SOURCESOFSUPPLY.MANDT == T001W.MANDT
  • C_SOURCESOFSUPPLY.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Type
  • ?
  • Client
  • C_SOURCESOFSUPPLY.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_SOURCESOFSUPPLY.[column in domain "BSTYP"] == T161.BSTYP
  • C_SOURCESOFSUPPLY.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_SOURCESOFSUPPLY.PURCHASINGGROUP == T024.EKGRP
  • C_SOURCESOFSUPPLY.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_SOURCESOFSUPPLY.PURCHASINGORGANIZATION == T024E.EKORG
  • C_SOURCESOFSUPPLY.MANDT == T024E.MANDT
Storage Location
  • Storage Location
  • Client
  • Plant
  • C_SOURCESOFSUPPLY.STORAGELOCATION == T001L.LGORT
  • C_SOURCESOFSUPPLY.MANDT == T001L.MANDT
  • C_SOURCESOFSUPPLY.PLANT == T001L.WERKS