P_PurInfoRecdPOPrHist

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 P_PurInfoRecdPOPrHist.
-- 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: PPIRPOPRHIST

CREATE VIEW P_PurInfoRecdPOPrHist AS
SELECT
  _Header.PurchasingInfoRecord AS PurchasingInfoRecord,
  _Header.PurchasingOrganization AS PurchasingOrganization,
  _Header.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  _Header.Plant AS Plant,
  '00000000' AS ConditionValidityEndDate,
  cast('_' as ebeln) AS PurchasingDocument,
  cast('00000' as ebelp) AS PurchasingDocumentItem,
  _Header.ReferenceDocumentCrcy AS Currency,
  _Header.ReferenceDocumentUnit AS BaseUnit,
  cast(0 as kbetr_kond) AS NetAmount,
  cast('_' as konwa) AS ConditionRateValueUnit,
  cast(0 as epein) AS ConditionQuantity,
  cast('_' as kmein) AS ConditionQuantityUnit,
  cast(0 as abap.int4 ) AS NumberOfItems,
  cast('0' as abap.char(1)) AS HierarchyNodeLevel,
  cast('expanded' as abap.char(8)) AS PurgDocDrillDownState,
  cast('0' as abap.char(1)) AS PurchasingDocumentType,
  cast(' ' as abap.char(50)) AS ParentNode,
  cast(concat(concat(concat(concat(concat(concat(_Header.PurchasingInfoRecord, '/'), _Header.PurchasingOrganization),'/'), _Header.PurchasingInfoRecordCategory),'/'), _Header.Plant) as abap.char(50)) as FormattedPurDoc AS char50asFormattedPurDoc,
  cast('_' as abap.char(50)) AS FormattedPurchaseOrderItem,
  cast('00000000' as abap.dats) AS ConditionValidityStartDate,
  '_' AS ConditionIsDeleted,
  _InfoRecord.Supplier AS Supplier,
  _InfoRecord.Material AS Material,
  case when _InfoRecord.MaterialGroup = '' then _InfoRecord._Material.MaterialGroup else _InfoRecord.MaterialGroup end as MaterialGroup AS MaterialGroupendasMaterialGroup,
  _InfoRecord.SupplierSubrange AS SupplierSubrange,
  _InfoRecord.Manufacturer AS Manufacturer,
  _InfoRecord.PriorSupplier AS PriorSupplier,
  _InfoRecord.SupplierMaterialNumber AS SupplierMaterialNumber,
  _InfoRecord.IsDeleted AS IsDeleted,
  _InfoRecord.AvailabilityStartDate AS AvailabilityStartDate,
  _InfoRecord.AvailabilityEndDate AS AvailabilityEndDate,
  _InfoRecord._Supplier.SupplierName AS SupplierName,
  _PlantData.PurchasingGroup AS PurchasingGroup,
  _PlantData.IncotermsClassification AS IncotermsClassification,
  _PlantData.TaxCode AS TaxCode,
  _PlantData.PricingDateControl AS PricingDateControl,
  _PlantData.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  _PlantData.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  _PlantData.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  concat(concat(concat(concat(concat(concat(_OrderPrice.PurchasingInfoRecord, '/'), _OrderPrice.PurchasingOrganization),'/'), _OrderPrice.PurchasingInfoRecordCategory),'/'), _OrderPrice.Plant) as ParentNode AS PlantasParentNode,
  FormattedPurchaseOrderItem AS FormattedPurDoc,
  _PlantData._Plant._StandardOrganizationAddress._Country.TaxCalculationProcedure AS TaxCalculationProcedure
FROM P_PurgInfoRecdOrdPrcCalc AS _Header
LEFT OUTER JOIN I_PurchasingInfoRecord AS _InfoRecord ON PurchasingInfoRecord = _InfoRecord.PurchasingInfoRecord  -- association [0..1]
LEFT OUTER JOIN I_PurgInfoRecdOrgPlantData AS _PlantData ON PurchasingInfoRecord = _PlantData.PurchasingInfoRecord AND _Header.ReferenceDocumentPlant = _PlantData.Plant AND PurchasingInfoRecordCategory = _PlantData.PurchasingInfoRecordCategory AND PurchasingOrganization = _PlantData.PurchasingOrganization  -- association [0..1]
-- UNION ALL with additional select branch(es): P_PurgInfoRecdOrdPrcCalc
;