P_PurInfoRecdPrHist

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_PurInfoRecdPrHist.
-- 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: PPURINFRECHIST

CREATE VIEW P_PurInfoRecdPrHist AS
SELECT
  _Header.PurchasingInfoRecord AS PurchasingInfoRecord,
  _Header.PurchasingOrganization AS PurchasingOrganization,
  _Header.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  _Header.Plant AS Plant,
  '00000000' AS ConditionValidityEndDate,
  cast('0000000000' as knumh) AS ConditionRecord,
  cast(concat(concat(concat(concat(concat(concat(_Header.PurchasingInfoRecord, '/'), _Header.PurchasingOrganization),'/'), _Header.PurchasingInfoRecordCategory),'/'), _Header.Plant) as abap.char(50)) as FormattedPurDoc AS char50asFormattedPurDoc,
  _Header.Currency AS Currency,
  _Header.PurchasingGroup AS PurchasingGroup,
  cast('_' as ebeln) AS PurchasingDocument,
  cast('00000' as ebelp) AS PurchasingDocumentItem,
  cast('_' as abap.char(50)) AS FormattedPurchaseOrderItem,
  cast('00000000' as abap.dats) AS ConditionValidityStartDate,
  '_' AS ConditionIsDeleted,
  cast(0 as kbetr_kond) AS ConditionRateValue,
  cast('_' as konwa) AS ConditionRateValueUnit,
  cast(0 as abap.quan(13,3)) AS ConditionQuantity,
  cast('_' as kmein) AS ConditionQuantityUnit,
  _Header.PurgDocOrderQuantityUnit AS BaseUnit,
  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(0 as kbetr_kond) AS NetAmount,
  _Header.Supplier AS Supplier,
  _Header.Material AS Material,
  case when _Header.MaterialGroup = '' then _Material.MaterialGroup else _Header.MaterialGroup end as MaterialGroup AS MaterialGroupendasMaterialGroup,
  _Header.SupplierSubrange AS SupplierSubrange,
  _Header.Manufacturer AS Manufacturer,
  _Header.IncotermsClassification AS IncotermsClassification,
  _Header.TaxCode AS TaxCode,
  _Header.PriorSupplier AS PriorSupplier,
  _Header.PricingDateControl AS PricingDateControl,
  _Header.SupplierMaterialNumber AS SupplierMaterialNumber,
  _Header.MaterialPlannedDeliveryDurn AS MaterialPlannedDeliveryDurn,
  _Header.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  _Header.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  _Header.IsDeleted AS IsDeleted,
  _Header.AvailabilityStartDate AS AvailabilityStartDate,
  _Header.AvailabilityEndDate AS AvailabilityEndDate,
  _Header._Supplier.SupplierName AS SupplierName,
  _Header._Plant.PlantName AS PlantName,
  _Header._Plant._StandardOrganizationAddress._Country.TaxCalculationProcedure AS TaxCalculationProcedure,
  _InfoRecord.MaterialGroup AS MaterialGroup,
  _Item.ConditionType AS ConditionType
FROM I_PurgInfoRecordWithOrgData AS _Header
LEFT OUTER JOIN I_Material AS _Material ON _Material.Material = Material  -- association [0..1]
LEFT OUTER JOIN I_PurgInfoRecordWithOrgData AS _InfoRecord ON PurchasingInfoRecord = _InfoRecord.PurchasingInfoRecord AND Plant = _InfoRecord.Plant AND PurchasingInfoRecordCategory = _InfoRecord.PurchasingInfoRecordCategory AND PurchasingOrganization = _InfoRecord.PurchasingOrganization  -- association [0..1]
-- UNION ALL with additional select branch(es): I_PurInfCndPeriod
;