C_SourceOfSupply

Souce of Supply | view: CMMSRCOFSUPPLY | Extraction: Not supported | Component: Reporting
Column Name Description
SourceDocument Purchasing Document Number
SourceDocumentItem Item Number of Purchasing Document
PurchaseContract FK Purchasing Contract Header
PurchaseContractItem Item Number of Purchasing Contract
Column Name Description
💲 Currency Key (DocumentCurrency):
TargetAmount Target Value for Header Area per Distribution
Column Name Description
Column Name Description
ValidityEndDate End of Validity Period
ValidityStartDate Start of Validity Period
CreationDate Creation Date of Purchasing Document
Column Name Description
PurchasingSourceType Purchasing Document Category Show values
PurchaseContractValidityStatus Validity Status Show values
Column Name Description Domain name
SupplierName Name of Supplier TEXT80
PurchasingDocumentCategoryName Purchasing Document Category Name DDTEXT
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
ContractConsumptionInPct Contract Consumption in Percentage CHAR34
PurContrStatusCriticality Purchase Contract Validity Status Criticality INT1
PurContrValidityStatusName Purchase Contract Validity Status CHAR20
Master Data Relations Join Conditions
Currency Key
  • Client
  • Currency Key
  • C_SOURCEOFSUPPLY.MANDT == TCURC.MANDT
  • C_SOURCEOFSUPPLY.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • C_SOURCEOFSUPPLY.MANDT == MARA.MANDT
  • C_SOURCEOFSUPPLY.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • C_SOURCEOFSUPPLY.MANDT == T001W.MANDT
  • C_SOURCEOFSUPPLY.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Category
  • Client
  • Purchasing Document Type
  • C_SOURCEOFSUPPLY.PURCHASINGSOURCETYPE == T161.BSTYP
  • C_SOURCEOFSUPPLY.MANDT == T161.MANDT
  • C_SOURCEOFSUPPLY.PURCHASINGDOCUMENTTYPE == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • C_SOURCEOFSUPPLY.PURCHASINGGROUP == T024.EKGRP
  • C_SOURCEOFSUPPLY.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • C_SOURCEOFSUPPLY.MANDT == T024E.MANDT
  • C_SOURCEOFSUPPLY.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • C_SOURCEOFSUPPLY.MANDT == LFA1.MANDT
  • C_SOURCEOFSUPPLY.SUPPLIER == LFA1.LIFNR