C_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 C_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: CPURINFRECHIST

CREATE VIEW C_PurInfoRecdPrHist AS
SELECT
  PurchasingInfoRecord,
  PurchasingOrganization,
  PurchasingInfoRecordCategory,
  Plant,
  ConditionValidityEndDate,
  ConditionRecord,
  PurchasingDocument,
  PurchasingDocumentItem,
  PurchasingDocumentType,
  _PurgInfoRecdType._Text [1: Language = $session.system_language ].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  ParentNode,
  Supplier,
  Material,
  IsDeleted,
  ConditionValidityStartDate,
  ConditionRateValue,
  ConditionRateValueUnit,
  ConditionQuantity,
  ConditionQuantityUnit,
  HierarchyNodeLevel,
  PurgDocDrillDownState,
  Currency,
  BaseUnit,
  PurchasingGroup,
  MaterialGroup,
  SupplierSubrange,
  Manufacturer,
  IncotermsClassification,
  TaxCode,
  PriorSupplier,
  PricingDateControl,
  SupplierMaterialNumber,
  MaterialPlannedDeliveryDurn,
  OverdelivTolrtdLmtRatioInPct,
  UnderdelivTolrtdLmtRatioInPct,
  AvailabilityStartDate,
  AvailabilityEndDate,
  TaxCalculationProcedure,
  SupplierName,
  _TaxCodeText.TaxCodeName AS TaxCodeName,
  _PurchasingOrganizationVH.PurchasingOrganizationName AS PurchasingOrganizationName,
  cast(_InfoRecdUpdtCatVH._Text.PurchasingInfoRecordTitle as vdm_categorytext) AS PurchasingInfoRecordTitle,
  PlantName,
  _Material.MaterialName AS MaterialName,
  _MaterialGroupVH.MaterialGroupName AS MaterialGroupName,
  _PurchasingGroupVH.PurchasingGroupName AS PurchasingGroupName,
  _IncotermsClassification.IncotermsClassificationName AS IncotermsClassificationName,
  _ManufacturerText.SupplierName AS ManufacturerName,
  _PriceDateCatValueHelp.PricingDateControlText AS PricingDateControlText,
  _PriorSupplierText.SupplierName AS PreferredSupplierName,
  _SupplierSubrangeVH.SupplierSubrangeName AS SupplierSubrangeName,
  _CurrencyValueHelp.CurrencyName AS CurrencyName,
  _MassUpdtUoMGrpVH.UnitOfMeasureLongName AS UnitOfMeasureLongName,
  '' AS PriceVarianceInPct,
  ConditionType
FROM P_PurInfoRecdPrHist
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupVH ON MaterialGroup = _MaterialGroupVH.MaterialGroup AND _MaterialGroupVH.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SupplierSubrangeText AS _SupplierSubrangeVH ON Supplier = _SupplierSubrangeVH.Supplier AND SupplierSubrange = _SupplierSubrangeVH.SupplierSubrange AND _SupplierSubrangeVH.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganizationVH ON PurchasingOrganization = _PurchasingOrganizationVH.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroupVH ON PurchasingGroup = _PurchasingGroupVH.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_ProcmtPricingDateControlTxt AS _PriceDateCatValueHelp ON _PriceDateCatValueHelp.PricingDateControl = PricingDateControl  -- association [0..1]
LEFT OUTER JOIN I_PurgInfoRecordCategory AS _InfoRecdUpdtCatVH ON _InfoRecdUpdtCatVH.PurchasingInfoRecordCategory = PurchasingInfoRecordCategory  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _Material ON Material = _Material.Material AND _Material.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _ManufacturerText ON Manufacturer = _ManufacturerText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _PriorSupplierText ON PriorSupplier = _PriorSupplierText.Supplier  -- association [0..1]
LEFT OUTER JOIN I_CurrencyText AS _CurrencyValueHelp ON Currency = _CurrencyValueHelp.Currency AND _CurrencyValueHelp.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_MassUpdtUoMGrpVH AS _MassUpdtUoMGrpVH ON BaseUnit = _MassUpdtUoMGrpVH.ProductUnitGroup  -- association [0..1]
LEFT OUTER JOIN I_TaxCodeText AS _TaxCodeText ON TaxCalculationProcedure = _TaxCodeText.TaxCalculationProcedure AND TaxCode = _TaxCodeText.TaxCode AND _TaxCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassificationText AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification AND _IncotermsClassification.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PurgInfoRecdType AS _PurgInfoRecdType ON _PurgInfoRecdType.PurchasingDocumentType = PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN C_PurgInfoRecdVarcCalc AS _PurgInfoRecdVarcCalc ON PurchasingInfoRecord = _PurgInfoRecdVarcCalc.PurchasingInfoRecord AND PurchasingOrganization = _PurgInfoRecdVarcCalc.PurchasingOrganization AND PurchasingInfoRecordCategory = _PurgInfoRecdVarcCalc.PurchasingInfoRecordCategory AND Plant = _PurgInfoRecdVarcCalc.Plant AND ConditionValidityEndDate = _PurgInfoRecdVarcCalc.ConditionValidityEndDate AND ConditionRecord = _PurgInfoRecdVarcCalc.ConditionRecord  -- association [0..1]
;