I_PurInfoRecdOrderUnitPrcgCndn

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 I_PurInfoRecdOrderUnitPrcgCndn.
-- 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: IPURIROUPRCGCND

CREATE VIEW I_PurInfoRecdOrderUnitPrcgCndn AS
SELECT
  i_a066.knumh AS ConditionRecord,
  i_a066.datbi AS ConditionValidityEndDate,
  i_a066.datab AS ConditionValidityStartDate,
  i_a066.kschl AS ConditionType,
  i_a066.kappl AS ConditionApplication,
  i_a066.lifnr AS Supplier,
  i_a066.matnr AS Material,
  i_a066.ekorg AS PurchasingOrganization,
  cast (' ' as werks_d) AS Plant,
  i_a066.esokz AS PurchasingInfoRecordCategory,
  inf_org.PurchasingInfoRecord AS PurchasingInfoRecord,
  i_a066.bstme as PurgDocOrderQuantityUnit AS knumhasConditionRecord,
  i_a067.bstme AS PurgDocOrderQuantityUnit
FROM a066 AS i_a066
INNER JOIN I_PurgInfoRecdOrgPlantData AS inf_org ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchasingInfoRecord AS inf_gen ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): a067
;