P_DrvtvInstrDODAllVersion
P_DrvtvInstrDODAllVersion is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_CmmdtyFinSyncResult, I_DerivativeCmmdtyExpsr) and exposes 69 fields with key fields CompanyCode, CommodityPriceExposure, CommodityExposureCategory, CommodityPriceSubExposure, CommodityPriceExposureVersion.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_CmmdtyFinSyncResult | FINSYNC | left_outer |
| I_DerivativeCmmdtyExpsr | VFIND | from |
Parameters (3)
| Name | Type | Default |
|---|---|---|
| P_EvaluationDate | cds_evaluation_date | |
| P_ComparisionDate | cds_evaluation_date | |
| P_DisplayView | cds_view_uom |
Annotations (9)
| Name | Value | Level | Field |
|---|---|---|---|
| VDM.private | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| AbapCatalog.sqlViewName | PDRVTVDODALL | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| AbapCatalog.preserveKey | true | view |
Fields (69)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | I_DerivativeCmmdtyExpsr | CompanyCode | Receiver Company Code |
| KEY | CommodityPriceExposure | I_DerivativeCmmdtyExpsr | CommodityPriceExposure | Exposure ID |
| KEY | CommodityExposureCategory | I_DerivativeCmmdtyExpsr | CommodityExposureCategory | Exposure Cat |
| KEY | CommodityPriceSubExposure | I_DerivativeCmmdtyExpsr | CommodityPriceSubExposure | Expo Subkey |
| KEY | CommodityPriceExposureVersion | I_DerivativeCmmdtyExpsr | CommodityPriceExposureVersion | Exposure Version |
| ValidityStartDateTime | I_DerivativeCmmdtyExpsr | ValidityStartDateTime | Valid From Timestamp | |
| ValidityEndDateTime | I_DerivativeCmmdtyExpsr | ValidityEndDateTime | Valid To Timestamp | |
| ValidityStartDate | I_DerivativeCmmdtyExpsr | ValidityStartDate | Validity Start Date | |
| ValidityStartTime | I_DerivativeCmmdtyExpsr | ValidityStartTime | Valid From Time | |
| ValidityEndDate | I_DerivativeCmmdtyExpsr | ValidityEndDate | ValidTo | |
| ValidityEndTime | I_DerivativeCmmdtyExpsr | ValidityEndTime | Valid To Time | |
| ValidityStartCharTimestamp | ||||
| ValidityEndCharTimestamp | ||||
| MaximumVersion | I_DerivativeCmmdtyExpsr | MaximumVersion | Highest Version | |
| RiskAnalyzerVersionUUID | I_DerivativeCmmdtyExpsr | RiskAnalyzerVersionUUID | Version GUID | |
| ExposureDueDate | I_DerivativeCmmdtyExpsr | ExposureDueDate | Exp. Due Date | |
| CalculationPeriodEndDate | I_DerivativeCmmdtyExpsr | CalculationPeriodEndDate | Calc. End Date | |
| ReportingDate | I_DerivativeCmmdtyExpsr | ReportingDate | Reporting Date | |
| Commodity | I_DerivativeCmmdtyExpsr | Commodity | Commodity Code | |
| CashFlowDirection | I_DerivativeCmmdtyExpsr | CashFlowDirection | Side | |
| TreasuryPositionLongShortCode | I_DerivativeCmmdtyExpsr | TreasuryPositionLongShortCode | Long/Short Position | |
| DerivativeContrSpecification | I_DerivativeCmmdtyExpsr | DerivativeContrSpecification | DCS ID | |
| MarketIdentifierCode | I_DerivativeCmmdtyExpsr | MarketIdentifierCode | MIC | |
| TimeToMaturity | I_DerivativeCmmdtyExpsr | TimeToMaturity | Time to Maturity | |
| CmmdtyForwardIndexTiming | I_DerivativeCmmdtyExpsr | CmmdtyForwardIndexTiming | Timing | |
| MaturityKeyDate | I_DerivativeCmmdtyExpsr | MaturityKeyDate | Maturity Key Date | |
| DerivativeContractMaturityCode | I_DerivativeCmmdtyExpsr | DerivativeContractMaturityCode | Contr. Maturity Code | |
| FinancialInstrProductCategory | I_DerivativeCmmdtyExpsr | FinancialInstrProductCategory | Prod. Category | |
| FinancialAssetsMgmtProductType | I_DerivativeCmmdtyExpsr | FinancialAssetsMgmtProductType | Product Type | |
| FinInstrTransactionCategory | I_DerivativeCmmdtyExpsr | FinInstrTransactionCategory | Transaction Cat | |
| FinancialInstrumentProductType | I_DerivativeCmmdtyExpsr | FinancialInstrumentProductType | TransType | |
| FinancialInstrActivityCategory | I_DerivativeCmmdtyExpsr | FinancialInstrActivityCategory | Activity Cat. | |
| FinancialObject | I_DerivativeCmmdtyExpsr | FinancialObject | Val. Obj. No. | |
| PnLEventType | I_DerivativeCmmdtyExpsr | PnLEventType | Type of Event | |
| HasError | I_DerivativeCmmdtyExpsr | HasError | TRUE | |
| IsNotRelevantForMTMRisk | I_DerivativeCmmdtyExpsr | IsNotRelevantForMTMRisk | Reporting Relevant | |
| TermStartDate | I_DerivativeCmmdtyExpsr | TermStartDate | Term Start | |
| TermEndDate | I_DerivativeCmmdtyExpsr | TermEndDate | Term End | |
| DeliveryDate | I_DerivativeCmmdtyExpsr | DeliveryDate | Delivery Date | |
| NumberOfCommodityContracts | I_DerivativeCmmdtyExpsr | NumberOfCommodityContracts | Number of Contracts | |
| CommodityPriceExposureUnit | I_DerivativeCmmdtyExpsr | CommodityPriceExposureUnit | Unit of Measure | |
| CommodityPriceExposureBaseUnit | I_DerivativeCmmdtyExpsr | CommodityPriceExposureBaseUnit | Weight UoM | |
| CmmdtyPriceExpsrMassUnit | I_DerivativeCmmdtyExpsr | CmmdtyPriceExpsrMassUnit | ||
| CmmdtyPriceExpsrVolumeUnit | I_DerivativeCmmdtyExpsr | CmmdtyPriceExpsrVolumeUnit | ||
| CommodityPriceExposureQuantity | I_DerivativeCmmdtyExpsr | CommodityPriceExposureQuantity | Value | |
| CommodityPriceExposureBaseQty | I_DerivativeCmmdtyExpsr | CommodityPriceExposureBaseQty | Base Quantity | |
| CmmdtyPriceExpsrQtyInMassUnit | I_DerivativeCmmdtyExpsr | CmmdtyPriceExpsrQtyInMassUnit | ||
| CmmdtyPriceExpsrQtyInVolUnit | I_DerivativeCmmdtyExpsr | CmmdtyPriceExpsrQtyInVolUnit | ||
| CommodityPriceFixationStatus | I_DerivativeCmmdtyExpsr | CommodityPriceFixationStatus | ||
| TreasuryPositionAccount | I_DerivativeCmmdtyExpsr | TreasuryPositionAccount | Futures Acct | |
| DerivativeContract | I_DerivativeCmmdtyExpsr | DerivativeContract | Derivative Contract | |
| OptionStrikePrice | I_DerivativeCmmdtyExpsr | OptionStrikePrice | Strike Price | |
| OptionStrikeCurrency | I_DerivativeCmmdtyExpsr | OptionStrikeCurrency | Currency Unit | |
| OptionPutCallCode | I_DerivativeCmmdtyExpsr | OptionPutCallCode | Put/Call | |
| OptionExerciseType | I_DerivativeCmmdtyExpsr | OptionExerciseType | Exercise Type | |
| EndOfDayBusinessEntityKey | I_DerivativeCmmdtyExpsr | EndOfDayBusinessEntityKey | Node Key | |
| ReportingMonth | I_DerivativeCmmdtyExpsr | ReportingMonth | ||
| ReportingYear | I_DerivativeCmmdtyExpsr | ReportingYear | ||
| FinInstrExternalReference | I_DerivativeCmmdtyExpsr | FinInstrExternalReference | External Reference | |
| EvaluationDate | ||||
| EndOfDaySnapshotDate | DayEndRun1 | EndOfDaySnapshotDate | ||
| EndOfDaySnapshotDateTime | DayEndRun1 | EndOfDaySnapshotDateTime | ||
| DisplayView | ||||
| _CompanyCode | I_DerivativeCmmdtyExpsr | _CompanyCode | ||
| _DerivativeContrSpecification | I_DerivativeCmmdtyExpsr | _DerivativeContrSpecification | ||
| _FinAssetsMgmtProductType | I_DerivativeCmmdtyExpsr | _FinAssetsMgmtProductType | ||
| _MarketIdentifierCode | I_DerivativeCmmdtyExpsr | _MarketIdentifierCode | ||
| _PhysicalCommodity | I_DerivativeCmmdtyExpsr | _PhysicalCommodity | ||
| _UnitOfMeasure | I_DerivativeCmmdtyExpsr | _UnitOfMeasure |
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 P_DrvtvInstrDODAllVersion.
-- 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.
-- SQL view name: PDRVTVDODALL
-- Parameters: P_EvaluationDate : cds_evaluation_date, P_ComparisionDate : cds_evaluation_date, P_DisplayView : cds_view_uom
CREATE VIEW P_DrvtvInstrDODAllVersion AS
SELECT
VFIND.CompanyCode AS CompanyCode,
VFIND.CommodityPriceExposure AS CommodityPriceExposure,
VFIND.CommodityExposureCategory AS CommodityExposureCategory,
VFIND.CommodityPriceSubExposure AS CommodityPriceSubExposure,
VFIND.CommodityPriceExposureVersion AS CommodityPriceExposureVersion,
VFIND.ValidityStartDateTime AS ValidityStartDateTime,
VFIND.ValidityEndDateTime AS ValidityEndDateTime,
VFIND.ValidityStartDate AS ValidityStartDate,
VFIND.ValidityStartTime AS ValidityStartTime,
VFIND.ValidityEndDate AS ValidityEndDate,
VFIND.ValidityEndTime AS ValidityEndTime,
cast ( VFIND.ValidityStartDateTime as abap.char(17) ) AS ValidityStartCharTimestamp,
cast ( VFIND.ValidityEndDateTime as abap.char(17) ) AS ValidityEndCharTimestamp,
VFIND.MaximumVersion AS MaximumVersion,
VFIND.RiskAnalyzerVersionUUID AS RiskAnalyzerVersionUUID,
VFIND.ExposureDueDate AS ExposureDueDate,
VFIND.CalculationPeriodEndDate AS CalculationPeriodEndDate,
VFIND.ReportingDate AS ReportingDate,
VFIND.Commodity AS Commodity,
VFIND.CashFlowDirection AS CashFlowDirection,
VFIND.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
VFIND.DerivativeContrSpecification AS DerivativeContrSpecification,
VFIND.MarketIdentifierCode AS MarketIdentifierCode,
VFIND.TimeToMaturity AS TimeToMaturity,
VFIND.CmmdtyForwardIndexTiming AS CmmdtyForwardIndexTiming,
VFIND.MaturityKeyDate AS MaturityKeyDate,
VFIND.DerivativeContractMaturityCode AS DerivativeContractMaturityCode,
VFIND.FinancialInstrProductCategory AS FinancialInstrProductCategory,
VFIND.FinancialAssetsMgmtProductType AS FinancialAssetsMgmtProductType,
VFIND.FinInstrTransactionCategory AS FinInstrTransactionCategory,
VFIND.FinancialInstrumentProductType AS FinancialInstrumentProductType,
VFIND.FinancialInstrActivityCategory AS FinancialInstrActivityCategory,
VFIND.FinancialObject AS FinancialObject,
VFIND.PnLEventType AS PnLEventType,
VFIND.HasError AS HasError,
VFIND.IsNotRelevantForMTMRisk AS IsNotRelevantForMTMRisk,
VFIND.TermStartDate AS TermStartDate,
VFIND.TermEndDate AS TermEndDate,
VFIND.DeliveryDate AS DeliveryDate,
VFIND.NumberOfCommodityContracts AS NumberOfCommodityContracts,
VFIND.CommodityPriceExposureUnit AS CommodityPriceExposureUnit,
VFIND.CommodityPriceExposureBaseUnit AS CommodityPriceExposureBaseUnit,
VFIND.CmmdtyPriceExpsrMassUnit AS CmmdtyPriceExpsrMassUnit,
VFIND.CmmdtyPriceExpsrVolumeUnit AS CmmdtyPriceExpsrVolumeUnit,
VFIND.CommodityPriceExposureQuantity AS CommodityPriceExposureQuantity,
VFIND.CommodityPriceExposureBaseQty AS CommodityPriceExposureBaseQty,
VFIND.CmmdtyPriceExpsrQtyInMassUnit AS CmmdtyPriceExpsrQtyInMassUnit,
VFIND.CmmdtyPriceExpsrQtyInVolUnit AS CmmdtyPriceExpsrQtyInVolUnit,
VFIND.CommodityPriceFixationStatus AS CommodityPriceFixationStatus,
VFIND.TreasuryPositionAccount AS TreasuryPositionAccount,
VFIND.DerivativeContract AS DerivativeContract,
VFIND.OptionStrikePrice AS OptionStrikePrice,
VFIND.OptionStrikeCurrency AS OptionStrikeCurrency,
VFIND.OptionPutCallCode AS OptionPutCallCode,
VFIND.OptionExerciseType AS OptionExerciseType,
VFIND.EndOfDayBusinessEntityKey AS EndOfDayBusinessEntityKey,
VFIND.ReportingMonth AS ReportingMonth,
VFIND.ReportingYear AS ReportingYear,
VFIND.FinInstrExternalReference AS FinInstrExternalReference,
cast ( $parameters.P_EvaluationDate as cds_evaluation_date ) AS EvaluationDate,
DayEndRun1.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
DayEndRun1.EndOfDaySnapshotDateTime AS EndOfDaySnapshotDateTime,
cast ( $parameters.P_DisplayView as cds_view_uom ) AS DisplayView,
VFIND._CompanyCode AS _CompanyCode,
VFIND._DerivativeContrSpecification AS _DerivativeContrSpecification,
VFIND._FinAssetsMgmtProductType AS _FinAssetsMgmtProductType,
VFIND._MarketIdentifierCode AS _MarketIdentifierCode,
VFIND._PhysicalCommodity AS _PhysicalCommodity,
VFIND._UnitOfMeasure AS _UnitOfMeasure
FROM I_DerivativeCmmdtyExpsr AS VFIND
LEFT OUTER JOIN I_CmmdtyFinSyncResult AS FINSYNC ON /* join condition not captured in parsed metadata */
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA