R_OIL_ExchangeAgreementDraft

DDL: R_OIL_EXCHANGEAGREEMENTDRAFT Type: view_entity BASIC
41 Fields 1 Data Sources 1 Associations

Exchange Agreement - Draft

R_OIL_ExchangeAgreementDraft is a Basic CDS View that provides data about "Exchange Agreement - Draft" in SAP S/4HANA. It reads from 1 data source (oia01_d) and exposes 41 fields with key fields ExchangeAgreement, DraftUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
oia01_d oia01_d from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_OIL_ExchangeAgreementDraft _ExchangeAgreementExtension _ExchangeAgreementExtension.ExchangeAgreement = $projection.ExchangeAgreement and _ExchangeAgreementExtension.DraftUUID = $projection.DraftUUID

Annotations (15)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Exchange Agreement - Draft view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix EXA view
AbapCatalog.extensibility.quota.maximumFields 816 view
AbapCatalog.extensibility.quota.maximumBytes 8160 view
AbapCatalog.extensibility.allowNewDatasources false view
AbapCatalog.extensibility.allowNewCompositions true view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY ExchangeAgreement exchangeagreement Exchange no.
KEY DraftUUID draftuuid UUID
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
OverallStatusCriticality overallstatuscriticality
StartDate startdate Valid From
EndDate enddate Term to
ExchangeAgreementReviewDate exchangeagreementreviewdate Review date
ReviewDateCriticality reviewdatecriticality
EvergreenType evergreentype Evergreen type
ExchangeNoticePeriodInDays exchangenoticeperiodindays Notice period
ExchAgreementIsNotSelectable exchagreementisnotselectable Flag to Sel Exchange
ExchangeFeeIsPricingBased exchangefeeispricingbased Pricing-based fees
PrmtHbSchedDtaAgingFltrDte prmthbscheddtaagingfltrdte Data Aging
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes

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 R_OIL_ExchangeAgreementDraft.
-- 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 R_OIL_ExchangeAgreementDraft AS
SELECT
  ExchangeAgreement,
  DraftUUID,
  ExchangeAgreementType,
  ExchangePartner,
  ExchAgreementPartnerRefCode,
  MaterialPostingRule,
  FeePostingRule,
  IsNettingActive,
  QuantityScheduleBreakdown,
  IndicatorForOwnershipCheck,
  ExchangeDocumentNumberRange,
  IsFeeCheckApplied,
  IsVATRelevant,
  QuantityScheduleSplitType,
  CreationDate,
  CreationTime,
  CreatedByUser,
  LastChangeDate,
  ChangedTime,
  LastChangeByUser,
  PaymentBlockKey,
  BaseProductPricingRoutine,
  BaseProductAssignmentUserExit,
  BaseLocation,
  ExchangeAgreementStatus,
  OverallStatusCriticality,
  StartDate,
  EndDate,
  ExchangeAgreementReviewDate,
  ReviewDateCriticality,
  EvergreenType,
  ExchangeNoticePeriodInDays,
  ExchAgreementIsNotSelectable,
  ExchangeFeeIsPricingBased,
  PrmtHbSchedDtaAgingFltrDte,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM oia01_d
LEFT OUTER JOIN E_OIL_ExchangeAgreementDraft AS _ExchangeAgreementExtension ON _ExchangeAgreementExtension.ExchangeAgreement = ExchangeAgreement AND _ExchangeAgreementExtension.DraftUUID = DraftUUID  -- association [0..1]
;

Learn More