I_OIL_ExchangeStatementHeader

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_ExchangeStatementHeader.
-- 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_ExchangeStatementHeader AS
SELECT
  preqno AS ExchangeStatementDocument,
  netdoc AS ExchStatementIsNettingDocument,
  preqtyp AS ExchangeStatementType,
  exgptr AS ExchangePartner,
  vkorg AS SalesOrganization,
  spart AS Division,
  vtweg AS DistributionChannel,
  waers AS Currency,
  vexgnum AS FromExchangeAgreement,
  bexgnum AS ToExchangeAgreementNumber,
  vexgtyp AS FromExchangeType,
  bexgtyp AS ToExchangeType,
  vmatref AS FromMaterialGroupReference,
  bmatref AS ToMaterialGroupReference,
  vmatnr AS FromMaterialNumber,
  bmatnr AS ToMaterialNumber,
  voibasprod AS FromBaseProductNumber,
  boibasprod AS ToBaseProductNumber,
  vwerks AS FromPlant,
  bwerks AS ToPlant,
  cast (vspmon as oiurep_base_yyyymm) AS FromPeriod,
  cast (bspmon as oiurep_base_yyyymm) AS ToPeriod,
  vsptag AS ExchangeMovementFromDate,
  bsptag AS ExchangeMovementToDate,
  cast (vspwoc as vdm_yearweek_kk) AS FromWeek,
  cast (bspwoc as vdm_yearweek_kk) AS ToWeek,
  cast (vspbup as vdm_yearmonth_kk) AS FromPostingPeriod,
  cast (bspbup as vdm_yearmonth_kk) AS ToPostingPeriod,
  docstat AS ExchangeDocumentStatus,
  njahr AS FinancialYear,
  mappe AS BatchInputSessionName,
  bicnt AS NettingDocumentBatchInputValue,
  netbal AS NetBalance,
  erdat AS CreationDate,
  ertim AS CreationTime,
  ernam AS CreatedByUser,
  aedat AS LastChangeDate,
  aetim AS ChangedTime,
  aenam AS LastChangeByUser,
  oiinvcyc1 AS InvoiceCycle1IsActive,
  oiinvcyc2 AS InvoiceCycle2IsActive,
  oiinvcyc3 AS InvoiceCycle3IsActive,
  oiinvcyc4 AS InvoiceCycle4IsActive,
  oiinvcyc5 AS InvoiceCycle5IsActive,
  oiinvcyc6 AS InvoiceCycle6IsActive,
  oiinvcyc7 AS InvoiceCycle7IsActive,
  oiinvcyc8 AS InvoiceCycle8IsActive,
  oiinvcyc9 AS InvoiceCycle9IsActive,
  oiinclia AS LgclInvtryAdjustmentIsIncluded,
  oiincpfa AS PureFinancialsAreIncluded,
  dispme AS UnitOfMeasure,
  oiamwofi AS MvtWithoutFinancialsIsIncluded,
  oiabalan AS ExchangeBalanceIsIncluded,
  _SalesOrganization._CompanyCode.Currency AS CompanyCodeCurrency
FROM oiaqa
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = ExchangePartner  -- association [1..1]
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON _BillingDocumentType.BillingDocumentType = ExchangeStatementType  -- association [1..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON _SalesOrganization.SalesOrganization = SalesOrganization  -- association [1..1]
LEFT OUTER JOIN I_Division AS _Division ON _Division.Division = Division  -- association [1..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON _DistributionChannel.DistributionChannel = DistributionChannel  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON _Currency.Currency = Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON _CompanyCodeCurrency.Currency = CompanyCodeCurrency  -- association [1..1]
LEFT OUTER JOIN I_OIL_ExchangeAgreement AS _ExchangeHeaderFrom ON _ExchangeHeaderFrom.ExchangeAgreement = FromExchangeAgreement  -- association [1..1]
LEFT OUTER JOIN I_OIL_ExchangeAgreement AS _ExchangeHeaderTo ON _ExchangeHeaderTo.ExchangeAgreement = ToExchangeAgreementNumber  -- association [1..1]
LEFT OUTER JOIN I_ExchangeAgreementType AS _ExchangeAgreementTypeFrom ON _ExchangeAgreementTypeFrom.ExchangeAgreementType = FromExchangeType  -- association [1..1]
LEFT OUTER JOIN I_ExchangeAgreementType AS _ExchangeAgreementTypeTo ON _ExchangeAgreementTypeTo.ExchangeAgreementType = ToExchangeType  -- association [1..1]
LEFT OUTER JOIN I_Material AS _MaterialFrom ON _MaterialFrom.Material = FromMaterialNumber  -- association [1..1]
LEFT OUTER JOIN I_Material AS _MaterialTo ON _MaterialTo.Material = ToMaterialNumber  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _PlantFrom ON _PlantFrom.Plant = FromPlant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _PlantTo ON _PlantTo.Plant = ToPlant  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_OIL_ExchangeDocumentStatusVH AS _ExchangeDocumentStatusVH ON _ExchangeDocumentStatusVH.ExchangeDocumentStatus = ExchangeDocumentStatus  -- association [1..1]
;