C_PPS_PurReqnSOSContractVH

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_PPS_PurReqnSOSContractVH.
-- 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.

CREATE VIEW C_PPS_PurReqnSOSContractVH AS
SELECT
  _PurchaseContractItem.PurchaseContract AS PurchaseContract,
  _PurchaseContractItem.PurchaseContractItem AS PurchaseContractItem,
  _PurchaseContract.PurchasingDocumentName AS PurchasingDocumentName,
  _PurchaseContractItem.PurchaseContractItemText AS PurchaseContractItemText,
  _PurchaseContractHdrExtension.PPSSmartDocumentNumber AS PPSSmartDocumentNumber,
  _PurchaseContract.Supplier AS Supplier,
  _PurchaseContractItem.Material AS Material,
  _PurchaseContractItem.MaterialGroup AS MaterialGroup,
  _PurchaseContractItem.ContractNetPriceAmount AS ContractNetPriceAmount,
  _PurchaseContract.DocumentCurrency AS DocumentCurrency,
  _PurchaseContract.ValidityStartDate AS ValidityStartDate,
  _PurchaseContract.ValidityEndDate AS ValidityEndDate,
  _PurchaseContract.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseContract.PurchasingGroup AS PurchasingGroup,
  _PurchaseContract.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  _PurchaseContract.PurchaseContractType AS PurchaseContractType,
  _PurchaseContract.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  _PurchaseContract.CompanyCode AS CompanyCode,
  _PurchaseContractItem.Plant AS Plant,
  _MaterialValueHelp.MaterialGroupName AS MaterialGroupName,
  _PurchasingOrgValueHelp.PurchasingOrganizationName AS PurchasingOrganizationName,
  _MaterialValueHelp.MaterialName AS MaterialName,
  _PurchasingGroupValueHelp.PurchasingGroupName AS PurchasingGroupName,
  _PurchaseContractItemExtension.PPSIsOptionalItem AS PPSIsOptionalItem,
  _PurchaseContractItemExtension.PPSOptionalItemStatus AS PPSOptionalItemStatus,
  _PurchaseContractItemExtension.PPSPerdOfPerfStartDate AS PPSPerdOfPerfStartDate,
  _PurchaseContractItemExtension.PPSPerdOfPerfEndDate AS PPSPerdOfPerfEndDate,
  _PurchaseContractHdrExtension.PPSSmartNumberHeader AS PPSSmartNumberHeader,
  _PurchaseContractHdrExtension.PPSNumberOfModification AS PPSNumberOfModification,
  cast(' ' as val_text) AS CommitmentPlanCategoryText,
  case when _PurContrEmrkdFundTotal.EmrkdFndsOpenTotalInTransCrcy is not null then _PurContrEmrkdFundTotal.EmrkdFndsOpenTotalInTransCrcy when _PurContrEmrkdFundTotGartdMin.EmrkdFndsOpenTotalInTransCrcy is not null then _PurContrEmrkdFundTotGartdMin.EmrkdFndsOpenTotalInTransCrcy else abap.curr'0.00' end as EmrkdFndsOpenTotalInTransCrcy AS 00endasEmrkdFndsOpenTotalInTransCrcy,
  _SupplierValueHelp.SupplierName AS SupplierName,
  _SupplierValueHelp.OrganizationBPName1 AS OrganizationBPName1,
  _SupplierValueHelp.OrganizationBPName2 AS OrganizationBPName2,
  _SupplierValueHelp.FirstName AS FirstName,
  _SupplierValueHelp.LastName AS LastName,
  _PurchaseContractItem._PurchaseContract AS _PurchaseContract
FROM I_PurchaseContractItem AS _PurchaseContractItem
INNER JOIN I_PurchaseContract AS _PurchaseContract ON /* join condition not captured in parsed metadata */
INNER JOIN I_PPS_PurchasingDocumentType AS _PPSPurgDocType ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_PurchasingOrgValueHelp AS _PurchasingOrgValueHelp ON _PurchasingOrgValueHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroupValueHelp ON _PurchasingGroupValueHelp.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN C_MM_SupplierValueHelp AS _SupplierValueHelp ON _SupplierValueHelp.Supplier = Supplier AND _SupplierValueHelp.CompanyCode = CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_MM_MaterialValueHelp AS _MaterialValueHelp ON _MaterialValueHelp.Material = Material AND _MaterialValueHelp.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_CO2eqSuplrFprntAvgBaseUoM AS _CO2eqSuplrFprntAvgBaseUoM ON _CO2eqSuplrFprntAvgBaseUoM.Product = Material AND _CO2eqSuplrFprntAvgBaseUoM.Plant = Plant AND _CO2eqSuplrFprntAvgBaseUoM.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN R_PPS_PurContractHdrExtension AS _PurchaseContractHdrExtension ON _PurchaseContract.PurchaseContract = _PurchaseContractHdrExtension.PurchaseContract  -- association [1..1]
LEFT OUTER JOIN R_PPS_PurContractItemExtension AS _PurchaseContractItemExtension ON _PurchaseContract.PurchaseContract = _PurchaseContractItemExtension.PurchaseContract AND _PurchaseContractItem.PurchaseContractItem = _PurchaseContractItemExtension.PurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN I_PPS_PurContrCmtmtPlan AS _PurContrCmtmtPlan ON _PurContrCmtmtPlan.PurchaseContract = PurchaseContract AND _PurContrCmtmtPlan.PurchaseContractItem = PurchaseContractItem  -- association [0..1]
LEFT OUTER JOIN I_PPS_PurContrCmtmtPlan AS _PurContrCmtmtPlanGartdMin ON _PurContrCmtmtPlanGartdMin.PurchaseContract = PurchaseContract AND _PurContrCmtmtPlanGartdMin.PurchaseContractItem = '00000'  -- association [0..1]
LEFT OUTER JOIN I_PPS_PurContrEmrkdFundTotal AS _PurContrEmrkdFundTotal ON _PurContrEmrkdFundTotal.PurchaseContract = PurchaseContract AND _PurContrEmrkdFundTotal.PurchaseContractItem = PurchaseContractItem  -- association [0..*]
LEFT OUTER JOIN I_PPS_PurContrEmrkdFundTotal AS _PurContrEmrkdFundTotGartdMin ON _PurContrEmrkdFundTotGartdMin.PurchaseContract = PurchaseContract AND _PurContrEmrkdFundTotGartdMin.PurchaseContractItem = '00000'  -- association [0..*]
;