I_OIL_ExchangeAgreementHeader

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_OIL_ExchangeAgreementHeader.
-- 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.

CREATE VIEW I_OIL_ExchangeAgreementHeader AS
SELECT
  exgnum AS ExchangeAgreement,
  exgtyp AS ExchangeAgreementType,
  exgptr AS ExchangePartner,
  ptrref AS ExchAgreementPartnerRefCode,
  matpst AS MaterialPostingRule,
  feepst AS FeePostingRule,
  nettng AS IsNettingActive,
  entlu AS QuantityScheduleBreakdown,
  ownchk AS IndicatorForOwnershipCheck,
  numkr AS ExchangeDocumentNumberRange,
  feechk AS IsFeeCheckApplied,
  oia_ipmvat AS IsVATRelevant,
  split AS QuantityScheduleSplitType,
  erdat AS CreationDate,
  ertim AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aetim AS ChangedTime,
  aenam AS LastChangeByUser,
  netcyc AS PaymentBlockKey,
  oisbrel AS BaseProductPricingRoutine,
  oichsbp AS BaseProductAssignmentUserExit,
  oia_baselo AS BaseLocation,
  exgstat AS ExchangeAgreementStatus,
  begda AS StartDate,
  endda AS EndDate,
  revda AS ExchangeAgreementReviewDate,
  evgtype AS EvergreenType,
  notper AS ExchangeNoticePeriodInDays,
  exgselect AS ExchAgreementIsNotSelectable,
  oia_pb_fee AS ExchangeFeeIsPricingBased
FROM oia01
LEFT OUTER JOIN I_OIL_ExchangeAgreementTypeVH AS _ExchangeAgreementTypeVH ON _ExchangeAgreementTypeVH.ExchangeAgreementType = ExchangeAgreementType  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = ExchangePartner  -- association [1..1]
LEFT OUTER JOIN I_OIL_PaymentBlockingReasonVH AS _PaymentBlockingReason ON _PaymentBlockingReason.PaymentBlockKey = PaymentBlockKey  -- association [1..1]
LEFT OUTER JOIN I_OIL_ExchAgrmtMatlPostgRuleVH AS _MaterialPostingRuleVH ON _MaterialPostingRuleVH.MaterialPostingRule = MaterialPostingRule  -- association [1..1]
LEFT OUTER JOIN I_OIL_ExchAgrmtFeePostgRuleVH AS _FeePostingRuleVH ON _FeePostingRuleVH.FeePostingRule = FeePostingRule  -- association [1..1]
LEFT OUTER JOIN I_OIL_QtySchedBreakdownCodeVH AS _QtySchedBreakdownCodeVH ON _QtySchedBreakdownCodeVH.QuantityScheduleBreakdown = QuantityScheduleBreakdown  -- association [1..1]
LEFT OUTER JOIN I_OIL_QtySchedSplitCodeVH AS _QtySchedSplitCodeVH ON _QtySchedSplitCodeVH.QuantityScheduleSplitType = QuantityScheduleSplitType  -- association [1..1]
LEFT OUTER JOIN I_OIL_ExchAgreementStatusVH AS _ExchAgreementStatusVH ON _ExchAgreementStatusVH.ExchangeAgreementStatus = ExchangeAgreementStatus  -- association [1..1]
LEFT OUTER JOIN I_OIL_ExchangeEvergreenTypeVH AS _ExchangeEvergreenTypeVH ON _ExchangeEvergreenTypeVH.EvergreenType = EvergreenType  -- association [1..1]
LEFT OUTER JOIN E_OIL_ExchangeAgreement AS _ExchangeAgreementExtension ON _ExchangeAgreementExtension.ExchangeAgreement = ExchangeAgreement  -- association [0..1]
;