I_PurInfCndPeriodWithDraft

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_PurInfCndPeriodWithDraft.
-- 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: I_PURINFCNDPRDWD

CREATE VIEW I_PurInfCndPeriodWithDraft AS
SELECT
  Document.ConditionValidityEndDate AS ConditionValidityEndDate,
  Document.Plant AS Plant,
  Document.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  Document.PurchasingOrganization AS PurchasingOrganization,
  Document.PurchasingInfoRecord AS PurchasingInfoRecord,
  Document.ConditionRecord AS ConditionRecord,
  Document.ConditionSequentialNumber AS ConditionSequentialNumber,
  Document.ConditionValidityEndDate AS ConditionValdtyEndDateForEdit,
  Document.ConditionType AS ConditionType,
  Document.ConditionValidityStartDate AS ConditionValidityStartDate,
  Document.ConditionRateValue AS ConditionRateValue,
  Document.ConditionRateValueUnit AS ConditionRateValueUnit,
  Document.ConditionQuantity AS ConditionQuantity,
  Document.ConditionQuantityUnit AS ConditionQuantityUnit,
  Document.ConditionApplication AS ConditionApplication,
  Document.ConditionCalculationType AS ConditionCalculationType,
  Document.ConditionIsDeleted AS ConditionIsDeleted,
  Document.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  Document.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  Document.BaseUnit AS BaseUnit
FROM P_PurgInfoRecordMainCndn AS Document
LEFT OUTER JOIN I_PurgInfoRecordWWithDraft AS _PurgInfoRecordWWithDraft ON _PurgInfoRecordWWithDraft.Plant = Plant AND _PurgInfoRecordWWithDraft.PurchasingInfoRecordCategory = PurchasingInfoRecordCategory AND _PurgInfoRecordWWithDraft.PurchasingOrganization = PurchasingOrganization AND _PurgInfoRecordWWithDraft.PurchasingInfoRecord = PurchasingInfoRecord  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON _DocumentCurrency.Currency = ConditionRateValueUnit  -- association [0..1]
LEFT OUTER JOIN I_PurConditionText AS _ConditionText ON _ConditionText.ConditionType = ConditionType  -- association [0..*]
;