C_PPS_PurReqnSOSContractVH_2

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_2.
-- 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_2 AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  PurchasingDocumentName,
  PurchaseContractItemText,
  _Extension.PPSSmartDocumentNumber AS PPSSmartDocumentNumber,
  Supplier,
  Material,
  MaterialGroup,
  ContractNetPriceAmount,
  DocumentCurrency,
  ValidityStartDate,
  ValidityEndDate,
  PurchasingOrganization,
  PurchasingGroup,
  IsEndOfPurposeBlocked,
  PurchaseContractType,
  PurchasingDocumentDeletionCode,
  CompanyCode,
  Plant,
  PurchasingDocumentType,
  PurchasingDocumentOrigin,
  PurchasingDocumentCategory,
  PurchaseContractCategory,
  _MaterialGroupText[1: Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  _PurchasingOrgValueHelp.PurchasingOrganizationName AS PurchasingOrganizationName,
  _MaterialPlant._MaterialText[1: Language = $session.system_language].MaterialName AS MaterialName,
  _PurchasingGroupValueHelp.PurchasingGroupName AS PurchasingGroupName,
  PPSIsOptionalItem,
  PPSOptionalItemStatus,
  PPSPerdOfPerfStartDate,
  PPSPerdOfPerfEndDate,
  _Extension.PPSSmartNumberHeader AS PPSSmartNumberHeader,
  _Extension.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,
  _Supplier.SupplierName AS SupplierName,
  _Supplier_to_BusinessPartner._BusinessPartner.OrganizationBPName1 AS OrganizationBPName1,
  _Supplier_to_BusinessPartner._BusinessPartner.OrganizationBPName2 AS OrganizationBPName2,
  _Supplier_to_BusinessPartner._BusinessPartner.FirstName AS FirstName,
  _Supplier_to_BusinessPartner._BusinessPartner.LastName AS LastName
FROM I_PPS_PurchaseReqnSOSContract
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrgValueHelp ON _PurchasingOrgValueHelp.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroupValueHelp ON _PurchasingGroupValueHelp.PurchasingGroup = PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier_to_BusinessPartner AS _Supplier_to_BusinessPartner ON Supplier = _Supplier_to_BusinessPartner.Supplier  -- association [0..1]
LEFT OUTER JOIN I_MaterialPlant AS _MaterialPlant ON _MaterialPlant.Material = Material AND _MaterialPlant.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..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..*]
;