I_OIL_ExchQtyPurchaseHeader

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_ExchQtyPurchaseHeader.
-- 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_ExchQtyPurchaseHeader AS
SELECT
  ebeln AS PurchasingDocument,
  ebelp AS PurchasingDocumentItem,
  subitm AS ExchangePurchaseSubitem,
  bukrs AS CompanyCode,
  cind AS IndicatorIsContract,
  lvorm AS ObjectLinkIsMarkedForDeletion,
  matnr AS Material,
  werks AS Plant,
  exgtyp AS ExchangeAgreementType,
  exgptr AS ExchangePartner,
  cnttyp AS PurchasingOrderType,
  smenge_pos AS ExchangeGoodsReceiptQuantity,
  smenge AS GoodsReceiptQuantity,
  intqty AS ScheduledQuantity,
  meins AS ScheduleUnitOfMeasure,
  entlu AS QuantityScheduleBreakdown,
  split AS QuantityScheduleSplitType,
  mod AS DeliveryTransportMode,
  vondat AS BrexitProtocolValidFromDate,
  bisdat AS BrexitProtocolValidToDate,
  oiprior AS ExchangeAgreementPriority,
  kalid AS FactoryCalendar,
  erdat AS CreationDate,
  ertim AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aetim AS ChangedTime,
  aenam AS LastChangeByUser
FROM oia06h
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON _CompanyCode.CompanyCode = CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON _PurchasingDocument.PurchasingDocument = PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentItem AS _PurchasingDocumentItem ON _PurchasingDocumentItem.PurchasingDocumentItem = PurchasingDocumentItem  -- association [1..*]
LEFT OUTER JOIN I_Material AS _Material ON _Material.Material = Material  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant  -- association [1..1]
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_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = ScheduleUnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_OIL_QtySchedBreakdownCodeVH AS _QtySchedBreakdownCodeVH ON _QtySchedBreakdownCodeVH.QuantityScheduleBreakdown = QuantityScheduleBreakdown  -- association [1..1]
LEFT OUTER JOIN I_FactoryCalendar AS _FactoryCalendar ON _FactoryCalendar.FactoryCalendar = FactoryCalendar  -- association [1..1]
LEFT OUTER JOIN I_OIL_QtySchedSplitCodeVH AS _QtySchedSplitCodeVH ON _QtySchedSplitCodeVH.QuantityScheduleSplitType = QuantityScheduleSplitType  -- association [1..1]
LEFT OUTER JOIN I_OIL_ContractIndicatorVH AS _OIL_ContractIndicatorVH ON _OIL_ContractIndicatorVH.IndicatorIsContract = IndicatorIsContract  -- association [1..1]
;