C_SourceOfSupply

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_SourceOfSupply.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CMMSRCOFSUPPLY

CREATE VIEW C_SourceOfSupply AS
SELECT
  SourceOfSupply.SourceDocument AS SourceDocument,
  SourceOfSupply.SourceDocumentItem AS SourceDocumentItem,
  ContractMaintItem.PurchaseContract AS PurchaseContract,
  ContractMaintItem.PurchaseContractItem AS PurchaseContractItem,
  SourceOfSupply.Supplier AS Supplier,
  _Supplier.SupplierName AS SupplierName,
  SourceOfSupply.PurchasingOrganization AS PurchasingOrganization,
  SourceOfSupply.PurchasingGroup AS PurchasingGroup,
  SourceOfSupply.PurchasingSourceType AS PurchasingSourceType,
  cast(_PurchasingDocumentCategory._Text[1: Language = $session.system_language ].PurchasingDocumentCategoryName as purchasingdocumentcategoryname preserving type ) AS PurchasingDocumentCategoryName,
  SourceOfSupply.Material AS Material,
  SourceOfSupply.Plant AS Plant,
  SourceOfSupply.PurchasingDocumentType AS PurchasingDocumentType,
  _PurchasingDocumentTypeText[1: Language = $session.system_language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  SourceOfSupply.ValidityEndDate AS ValidityEndDate,
  SourceOfSupply.ValidityStartDate AS ValidityStartDate,
  SourceOfSupply.CreationDate AS CreationDate,
  SourceOfSupply.DocumentCurrency AS DocumentCurrency,
  SourceOfSupply.TargetAmount AS TargetAmount,
  cast( cast( Contract.ContractConsumptionInPct as abap.char( 34 ) ) as mm_contract_consumption_pct preserving type ) AS ContractConsumptionInPct,
  cast (3 as mm_oa_validity_criticality preserving type) AS PurContrStatusCriticality,
  cast( '02' as mm_contract_status_id ) AS PurchaseContractValidityStatus,
  cast( 'Valid' as mm_oa_validity_status ) AS PurContrValidityStatusName
FROM P_SourceOfSupply AS SourceOfSupply
INNER JOIN P_PurchaseContractItemSOS AS ContractMaintItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurContrCnsmpnInPercentage AS Contract ON SourceOfSupply.PurchasingSourceType = 'K' AND SourceOfSupply.SourceDocument = Contract.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _Material ON Material = _Material.Material AND Plant = _Material.Plant  -- association [1..1]
LEFT OUTER JOIN I_PurchasingObjectCategory AS _PurchasingDocumentCategory ON PurchasingSourceType = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchasingDocumentTypeText ON PurchasingDocumentType = _PurchasingDocumentTypeText.PurchasingDocumentType AND PurchasingSourceType = _PurchasingDocumentTypeText.PurchasingDocumentCategory  -- association [0..*]
;