C_Sourceofsupplymanage

Manage Sources of Supply | view: CMMSOSMANAGE | Extraction: Not supported | Component: Vendor-Material Relationships and Conditions
Tables used: EKKOEKPOEQUKEQUPEQUPEKKOT001TKA02MARAT023TMAKTEORDT001WT024WEINAT024EEINELFA1LFB1LFA1USR21
Column Name Description
SourceDocument Purchasing Document Number
SourceDocumentItem Item Number of Purchasing Document
Material FK Material Number
Plant FK Plant
PurchasingOrganization FK Purchasing organization
SourceListRecord Number of Source List Record
PurchasingInfoRecordCategory Purchasing info record category
PurchasingSourceType Purchasing Source Type
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate End of Validity Period
ValidityStartDate Start of Validity Period
Column Name Description
Column Name Description Domain name
QuotaInPercent Quota of Quota Arrangement Item in Percent PRZ31
MaterialName Material Description TEXT40
SourceOfSupplyIsBlocked null
SourceOfSupplyIsFixed null
WeightedRelevance Weighted Relevance
PurchasingDocumentCategory Purchasing Document Category
PurchasingDocumentCategoryName Purchasing Document Category Name DDTEXT
IsExpired Single-Character Flag CHAR1
PlantName Plant Name TEXT30
SupplierName Name of Supplier TEXT80
PurchasingOrganizationName Purchasing Organization Name
FormattedDocumentKey null
StandardTextDescription Source description CHAR60
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_SOURCEOFSUPPLYMANAGE.MANDT == T001.MANDT
  • C_SOURCEOFSUPPLYMANAGE.COMPANYCODE == T001.BUKRS
Material Number
  • Client
  • Material Number
  • C_SOURCEOFSUPPLYMANAGE.MANDT == MARA.MANDT
  • C_SOURCEOFSUPPLYMANAGE.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_SOURCEOFSUPPLYMANAGE.MANDT == T023.MANDT
  • C_SOURCEOFSUPPLYMANAGE.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_SOURCEOFSUPPLYMANAGE.MANDT == T001W.MANDT
  • C_SOURCEOFSUPPLYMANAGE.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Category
  • Client
  • Purchasing Document Type
  • C_SOURCEOFSUPPLYMANAGE.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_SOURCEOFSUPPLYMANAGE.MANDT == T161.MANDT
  • C_SOURCEOFSUPPLYMANAGE.PURCHASINGDOCUMENTTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • C_SOURCEOFSUPPLYMANAGE.MANDT == T024.MANDT
  • C_SOURCEOFSUPPLYMANAGE.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • C_SOURCEOFSUPPLYMANAGE.MANDT == T024E.MANDT
  • C_SOURCEOFSUPPLYMANAGE.PURCHASINGORGANIZATION == T024E.EKORG
Storage Location
  • Client
  • Storage Location
  • Plant
  • C_SOURCEOFSUPPLYMANAGE.MANDT == T001L.MANDT
  • C_SOURCEOFSUPPLYMANAGE.STORAGELOCATION == T001L.LGORT
  • C_SOURCEOFSUPPLYMANAGE.PLANT == T001L.WERKS
Supplier
  • Supplier
  • Client
  • C_SOURCEOFSUPPLYMANAGE.SUPPLIER == LFA1.LIFNR
  • C_SOURCEOFSUPPLYMANAGE.MANDT == LFA1.MANDT