C_OIL_ExchangeAgreementDEX

DDL: C_OIL_EXCHANGEAGREEMENTDEX Type: view_entity CONSUMPTION
41 Fields 1 Data Sources

Exchange Header

C_OIL_ExchangeAgreementDEX is a Consumption CDS View that provides data about "Exchange Header" in SAP S/4HANA. It reads from 1 data source (I_OIL_ExchangeAgreement) and exposes 41 fields with key field ExchangeAgreement.

Data Sources (1)

SourceAliasJoin Type
I_OIL_ExchangeAgreement I_OIL_ExchangeAgreement from

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Analytics.technicalName COILExchangeAgreementDEX view
Analytics.dataExtraction.enabled true view
EndUserText.label Exchange Header view
ObjectModel.representativeKey ExchangeAgreement view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY ExchangeAgreement ExchangeAgreement Exchange no.
ExchangeAgreementType ExchangeAgreementType Exchange type
ExchangePartner ExchangePartner Exg.partner
ExchAgreementPartnerRefCode ExchAgreementPartnerRefCode Partner ref.
MaterialPostingRule MaterialPostingRule Mat.posting
FeePostingRule FeePostingRule Fee posting
IsNettingActive IsNettingActive Netting active
QuantityScheduleBreakdown QuantityScheduleBreakdown QS breakdown
IndicatorForOwnershipCheck IndicatorForOwnershipCheck Ownership check
ExchangeDocumentNumberRange ExchangeDocumentNumberRange No.range
IsFeeCheckApplied IsFeeCheckApplied Apply fee check
IsVATRelevant IsVATRelevant VAT on int.mat.
QuantityScheduleSplitType QuantityScheduleSplitType QS split
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
PaymentBlockKey PaymentBlockKey Payment Block
BaseProductPricingRoutine BaseProductPricingRoutine S/B prod.ind.
BaseProductAssignmentUserExit BaseProductAssignmentUserExit S/B prod. check
BaseLocation BaseLocation Base Location
ExchangeAgreementStatus ExchangeAgreementStatus Exchange status
StartDate StartDate Valid From
EndDate EndDate Term to
ExchangeAgreementReviewDate ExchangeAgreementReviewDate Review date
EvergreenType EvergreenType Evergreen type
ExchangeNoticePeriodInDays ExchangeNoticePeriodInDays Notice period
ExchAgreementIsNotSelectable ExchAgreementIsNotSelectable Flag to Sel Exchange
ExchangeFeeIsPricingBased ExchangeFeeIsPricingBased Pricing-based fees
PrmtHbSchedDtaAgingFltrDte PrmtHbSchedDtaAgingFltrDte Data Aging
_ExchangeAgreementTypeVH _ExchangeAgreementTypeVH
_Supplier _Supplier
_MaterialPostingRuleVH _MaterialPostingRuleVH
_FeePostingRuleVH _FeePostingRuleVH
_QtySchedBreakdownCodeVH _QtySchedBreakdownCodeVH
_QtySchedSplitCodeVH _QtySchedSplitCodeVH
_PaymentBlockingReason _PaymentBlockingReason
_ExchAgreementStatusVH _ExchAgreementStatusVH
_ExchangeEvergreenTypeVH _ExchangeEvergreenTypeVH

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 C_OIL_ExchangeAgreementDEX.
-- 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 C_OIL_ExchangeAgreementDEX AS
SELECT
  ExchangeAgreement,
  ExchangeAgreementType,
  ExchangePartner,
  ExchAgreementPartnerRefCode,
  MaterialPostingRule,
  FeePostingRule,
  IsNettingActive,
  QuantityScheduleBreakdown,
  IndicatorForOwnershipCheck,
  ExchangeDocumentNumberRange,
  IsFeeCheckApplied,
  IsVATRelevant,
  QuantityScheduleSplitType,
  CreationDate,
  CreationTime,
  CreatedByUser,
  LastChangeDate,
  ChangedTime,
  LastChangeByUser,
  PaymentBlockKey,
  BaseProductPricingRoutine,
  BaseProductAssignmentUserExit,
  BaseLocation,
  ExchangeAgreementStatus,
  StartDate,
  EndDate,
  ExchangeAgreementReviewDate,
  EvergreenType,
  ExchangeNoticePeriodInDays,
  ExchAgreementIsNotSelectable,
  ExchangeFeeIsPricingBased,
  PrmtHbSchedDtaAgingFltrDte
FROM I_OIL_ExchangeAgreement
;

Learn More