I_OIL_ExchangeStatement

DDL: I_OIL_EXCHANGESTATEMENT Type: view_entity BASIC
73 Fields 1 Data Sources 1 Associations

Exchange Statement

I_OIL_ExchangeStatement is a Basic CDS View that provides data about "Exchange Statement" in SAP S/4HANA. It reads from 1 data source (I_OIL_ExchangeStatementHeader) and exposes 73 fields with key field ExchangeStatementDocument. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_OIL_ExchangeStatementHeader I_OIL_ExchangeStatementHeader from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_OIL_ExchNettingProposal _ExchNettingProposal $projection.ExchangeStatementDocument = _ExchNettingProposal.ExchangeNettingDocumentNumber

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Analytics.internalName #LOCAL view
Analytics.technicalName IOILExchangeStatement view
EndUserText.label Exchange Statement view
ObjectModel.representativeKey ExchangeStatementDocument view
ObjectModel.sapObjectNodeType.name OIL_ExchangeStatement view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #BASIC view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY ExchangeStatementDocument ExchangeStatementDocument ExgSt req no.
ExchStatementIsNettingDocument ExchStatementIsNettingDocument Netting doc.
ExchangeStatementType ExchangeStatementType Exg. stmnt type
ExchangePartner ExchangePartner Exg.partner
SalesOrganization SalesOrganization Sales Organization
Division Division Internal Division ID
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Currency Currency Valuation Crcy
FromExchangeAgreement FromExchangeAgreement FromExchangeNo.
ToExchangeAgreementNumber ToExchangeAgreementNumber ToExchangeNo.
FromExchangeType FromExchangeType FromExchangeTyp
ToExchangeType ToExchangeType ToExchangeTyp
FromMaterialGroupReference FromMaterialGroupReference FromMatGrp ref.
ToMaterialGroupReference ToMaterialGroupReference ToMatGrpRef
FromMaterialNumber FromMaterialNumber From mat. no.
ToMaterialNumber ToMaterialNumber To material
FromBaseProductNumber FromBaseProductNumber FromBaseProduct
ToBaseProductNumber ToBaseProductNumber ToBaseProduct
FromPlant FromPlant Plant
ToPlant ToPlant To plant
FromPeriod FromPeriod
ToPeriod ToPeriod To period
ExchangeMovementFromDate ExchangeMovementFromDate From day
ExchangeMovementToDate ExchangeMovementToDate To day
FromWeek FromWeek
ToWeek ToWeek
FromPostingPeriod FromPostingPeriod
ToPostingPeriod ToPostingPeriod
ExchangeDocumentStatus ExchangeDocumentStatus Nt.doc status
FinancialYear FinancialYear Fiscal Year
BatchInputSessionName BatchInputSessionName Session
NettingDocumentBatchInputValue NettingDocumentBatchInputValue BatchI.counter
NetBalance NetBalance Netting bal.
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
ChangedTime ChangedTime Changed at
LastChangeByUser LastChangeByUser User Name
InvoiceCycle1IsActive InvoiceCycle1IsActive Inv.CycleInd
InvoiceCycle2IsActive InvoiceCycle2IsActive Inv.CycleInd
InvoiceCycle3IsActive InvoiceCycle3IsActive Inv.CycleInd
InvoiceCycle4IsActive InvoiceCycle4IsActive Inv.CycleInd
InvoiceCycle5IsActive InvoiceCycle5IsActive Inv.CycleInd
InvoiceCycle6IsActive InvoiceCycle6IsActive Inv.CycleInd
InvoiceCycle7IsActive InvoiceCycle7IsActive Inv.CycleInd
InvoiceCycle8IsActive InvoiceCycle8IsActive Inv.CycleInd
InvoiceCycle9IsActive InvoiceCycle9IsActive Inv.CycleInd
LgclInvtryAdjustmentIsIncluded LgclInvtryAdjustmentIsIncluded LIA incl. ind.
PureFinancialsAreIncluded PureFinancialsAreIncluded PFA incl. ind.
UnitOfMeasure UnitOfMeasure Unit Protected Qty
MvtWithoutFinancialsIsIncluded MvtWithoutFinancialsIsIncluded Mov. w/o FI
ExchangeBalanceIsIncluded ExchangeBalanceIsIncluded Balance ind.
CompanyCodeCurrency CompanyCodeCurrency Local Currency
PrmtHbSchedDtaAgingFltrDte PrmtHbSchedDtaAgingFltrDte Data Aging
_BillingDocumentType _BillingDocumentType
_Supplier _Supplier
_SalesOrganization _SalesOrganization
_Division _Division
_CompanyCodeCurrency _CompanyCodeCurrency
_Currency _Currency
_DistributionChannel _DistributionChannel
_ExchangeHeaderFrom _ExchangeHeaderFrom
_ExchangeHeaderTo _ExchangeHeaderTo
_ExchangeAgreementTypeFrom _ExchangeAgreementTypeFrom
_ExchangeAgreementTypeTo _ExchangeAgreementTypeTo
_MaterialFrom _MaterialFrom
_MaterialTo _MaterialTo
_PlantFrom _PlantFrom
_PlantTo _PlantTo
_UnitOfMeasure _UnitOfMeasure
_ExchangeDocumentStatusVH _ExchangeDocumentStatusVH
_ExchNettingProposal _ExchNettingProposal

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_ExchangeStatement.
-- 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_ExchangeStatement AS
SELECT
  ExchangeStatementDocument,
  ExchStatementIsNettingDocument,
  ExchangeStatementType,
  ExchangePartner,
  SalesOrganization,
  Division,
  DistributionChannel,
  Currency,
  FromExchangeAgreement,
  ToExchangeAgreementNumber,
  FromExchangeType,
  ToExchangeType,
  FromMaterialGroupReference,
  ToMaterialGroupReference,
  FromMaterialNumber,
  ToMaterialNumber,
  FromBaseProductNumber,
  ToBaseProductNumber,
  FromPlant,
  ToPlant,
  FromPeriod,
  ToPeriod,
  ExchangeMovementFromDate,
  ExchangeMovementToDate,
  FromWeek,
  ToWeek,
  FromPostingPeriod,
  ToPostingPeriod,
  ExchangeDocumentStatus,
  FinancialYear,
  BatchInputSessionName,
  NettingDocumentBatchInputValue,
  NetBalance,
  CreationDate,
  CreationTime,
  CreatedByUser,
  LastChangeDate,
  ChangedTime,
  LastChangeByUser,
  InvoiceCycle1IsActive,
  InvoiceCycle2IsActive,
  InvoiceCycle3IsActive,
  InvoiceCycle4IsActive,
  InvoiceCycle5IsActive,
  InvoiceCycle6IsActive,
  InvoiceCycle7IsActive,
  InvoiceCycle8IsActive,
  InvoiceCycle9IsActive,
  LgclInvtryAdjustmentIsIncluded,
  PureFinancialsAreIncluded,
  UnitOfMeasure,
  MvtWithoutFinancialsIsIncluded,
  ExchangeBalanceIsIncluded,
  CompanyCodeCurrency,
  PrmtHbSchedDtaAgingFltrDte
FROM I_OIL_ExchangeStatementHeader
LEFT OUTER JOIN I_OIL_ExchNettingProposal AS _ExchNettingProposal ON ExchangeStatementDocument = _ExchNettingProposal.ExchangeNettingDocumentNumber  -- association [0..*]
;

Learn More