C_OIL_ExchangeMovementIndexDEX

DDL: C_OIL_EXCHANGEMOVEMENTINDEXDEX Type: view_entity CONSUMPTION
32 Fields 1 Data Sources

Exchange Movement Index

C_OIL_ExchangeMovementIndexDEX is a Consumption CDS View that provides data about "Exchange Movement Index" in SAP S/4HANA. It reads from 1 data source (I_OIL_ExchangeMovementIndex) and exposes 32 fields with key fields ExchangePartner, PostingDate, ExchangePeriodMonth, ExchangePeriodCurrentDate, ExchangePeriodWeek.

Data Sources (1)

SourceAliasJoin Type
I_OIL_ExchangeMovementIndex I_OIL_ExchangeMovementIndex from

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
Analytics.technicalName COILExchangeMovementIndexDEX view
EndUserText.label Exchange Movement Index view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey ExchangePartner view
ObjectModel.sapObjectNodeType.name OIL_ExchangeMovement view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY ExchangePartner ExchangePartner Exg.partner
KEY PostingDate PostingDate Posting Date for GR
KEY ExchangePeriodMonth ExchangePeriodMonth
KEY ExchangePeriodCurrentDate ExchangePeriodCurrentDate Date
KEY ExchangePeriodWeek ExchangePeriodWeek
KEY ExchangePostingPeriod ExchangePostingPeriod
KEY ExchangeAgreement ExchangeAgreement Exchange no.
KEY ExchangeAgreementType ExchangeAgreementType Exchange type
KEY ExchangeMaterialGroupReference ExchangeMaterialGroupReference Mat grp ref.
KEY Material Material Vehicle Model
KEY ExchangeBaseProductNumber ExchangeBaseProductNumber Base prod.no
KEY Plant Plant Valuation Area
KEY MaterialDocument MaterialDocument Material Doc.
KEY MaterialDocumentYear MaterialDocumentYear Material Document Year
KEY ExchangeItemNumber ExchangeItemNumber Mat. Doc.Item
LgclInvtryAdjmtItmType LgclInvtryAdjmtItmType LIA item type
ExchangeNettingCycle ExchangeNettingCycle Netting cycle
ExchangeDebitCreditCode ExchangeDebitCreditCode Returns
IsReversalMovementType IsReversalMovementType RevMvmtTypeInd.
PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
DeliveryDocument DeliveryDocument Outbound Delivery
DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
OrderDocument OrderDocument SD Document
SourceSalesDocumentItem SourceSalesDocumentItem Sales Ord. Item
ExchNettingDocClrgItemNumber ExchNettingDocClrgItemNumber Clearng.doc.no.
RFM_Dummy RFM_Dummy Dummy function in length 1
LadingExternalBill LadingExternalBill Extern.BOL no.
ExchMiscDeliveryNumber ExchMiscDeliveryNumber Miscell.del.no.
BillOfExchangeDataAgingDate BillOfExchangeDataAgingDate Data Aging
_DebitCreditIndicatorVH _DebitCreditIndicatorVH
_LgclInvtryAdjmtItmVH _LgclInvtryAdjmtItmVH

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_ExchangeMovementIndexDEX.
-- 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_ExchangeMovementIndexDEX AS
SELECT
  ExchangePartner,
  PostingDate,
  ExchangePeriodMonth,
  ExchangePeriodCurrentDate,
  ExchangePeriodWeek,
  ExchangePostingPeriod,
  ExchangeAgreement,
  ExchangeAgreementType,
  ExchangeMaterialGroupReference,
  Material,
  ExchangeBaseProductNumber,
  Plant,
  MaterialDocument,
  MaterialDocumentYear,
  ExchangeItemNumber,
  LgclInvtryAdjmtItmType,
  ExchangeNettingCycle,
  ExchangeDebitCreditCode,
  IsReversalMovementType,
  PurchasingDocument,
  PurchasingDocumentItem,
  DeliveryDocument,
  DeliveryDocumentItem,
  OrderDocument,
  SourceSalesDocumentItem,
  ExchNettingDocClrgItemNumber,
  RFM_Dummy,
  LadingExternalBill,
  ExchMiscDeliveryNumber,
  BillOfExchangeDataAgingDate
FROM I_OIL_ExchangeMovementIndex
;

Learn More