P_DERIVATIVEPOSADPTRLAYER
P_DERIVATIVEPOSADPTRLAYER is a CDS View in S/4HANA. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_DerivativePosOptnDelta | view | from | COMPOSITE |
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PVFINDAL'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@AbapCatalog.preserveKey: true
define view P_DerivativePosAdptrLayer
with parameters
@Consumption.defaultValue: 'P'
P_DisplayView : cds_view_uom,
@Environment.systemField: #SYSTEM_DATE
P_EvaluationDate : cds_evaluation_date,
@Environment.systemField: #SYSTEM_DATE
P_ComparisionDate : cds_evaluation_date
as select from P_DrvtvPosEndOfDayTechLayer (P_EvaluationDate: $parameters.P_EvaluationDate, P_DisplayView: $parameters.P_DisplayView) as DerivativePositionEOD
association [0..1] to I_UnitOfMeasure as _UnitOfMeasure on $projection.CommodityPriceExposureUnit = _UnitOfMeasure.UnitOfMeasure
{
key DerivativePositionEOD.CompanyCode,
key DerivativePositionEOD.CommodityPriceExposure,
key DerivativePositionEOD.CommodityExposureCategory,
key DerivativePositionEOD.CommodityPriceSubExposure,
key DerivativePositionEOD.CommodityPriceExposureVersion,
DerivativePositionEOD.ValidityStartDateTime,
DerivativePositionEOD.ValidityEndDateTime,
DerivativePositionEOD.ValidityStartDate,
DerivativePositionEOD.ValidityStartTime,
DerivativePositionEOD.ValidityEndDate,
DerivativePositionEOD.ValidityEndTime,
DerivativePositionEOD.ValidityStartCharTimestamp,
DerivativePositionEOD.ValidityEndCharTimestamp,
DerivativePositionEOD.MaximumVersion,
DerivativePositionEOD.RiskAnalyzerVersionUUID,
DerivativePositionEOD.ExposureDueDate,
DerivativePositionEOD.ReportingDate,
DerivativePositionEOD.Commodity,
DerivativePositionEOD.CashFlowDirection,
DerivativePositionEOD.TreasuryPositionLongShortCode,
DerivativePositionEOD.DerivativeContrSpecification,
DerivativePositionEOD.MarketIdentifierCode,
DerivativePositionEOD.QuotationPriceType,
DerivativePositionEOD.TimeToMaturity,
DerivativePositionEOD.CmmdtyForwardIndexTiming,
DerivativePositionEOD.MaturityKeyDate,
DerivativePositionEOD.DerivativeContractMaturityCode,
DerivativePositionEOD.FinancialInstrProductCategory,
DerivativePositionEOD.FinancialAssetsMgmtProductType,
DerivativePositionEOD.FinInstrTransactionCategory,
DerivativePositionEOD.FinancialInstrumentProductType,
DerivativePositionEOD.FinancialInstrActivityCategory,
DerivativePositionEOD.FinancialObject,
DerivativePositionEOD.HasError,
DerivativePositionEOD.TermStartDate,
DerivativePositionEOD.TermEndDate,
DerivativePositionEOD.DeliveryDate,
DerivativePositionEOD.NumberOfCommodityContracts,
DerivativePositionEOD.CommodityPriceFixationStatus,
DerivativePositionEOD.TreasuryPositionAccount,
DerivativePositionEOD.DerivativeContract,
DerivativePositionEOD.QuotationCurrency,
DerivativePositionEOD.PaymentCurrency,
DerivativePositionEOD.OptionStrikePrice,
DerivativePositionEOD.OptionStrikeCurrency,
DerivativePositionEOD.OptionPutCallCode,
DerivativePositionEOD.OptionExerciseType,
DerivativePositionEOD.EndOfDayBusinessEntityKey,
DerivativePositionEOD.ReportingMonth,
DerivativePositionEOD.ReportingYear,
DerivativePositionEOD.EvaluationDate,
/*End of day */
DerivativePositionEOD.EndOfDaySnapshotDate,
DerivativePositionEOD.EndOfDaySnapshotDateTime,
DerivativePositionEOD.ConsumptionType,
DerivativePositionEOD.DisplayView,
DerivativePositionEOD.FinInstrExternalReference,
DerivativePositionEOD.TradedDrvtvContrSpecification,
DerivativePositionEOD.ParDrvtvContractSpecification,
DerivativePositionEOD.RiskViewIsNotRelevant,
cast ( case when ( DisplayView = 'P' ) then ( CommodityPriceExposureQuantity )
when ( DisplayView = 'M' ) then ( CmmdtyPriceExpsrQtyInMassUnit )
when ( DisplayView = 'V' ) then ( CmmdtyPriceExpsrQtyInVolUnit )
else CommodityPriceExposureQuantity end as ftr_exposure_qty ) as CommodityPriceExposureQuantity,
cast ( case when ( DisplayView = 'P' ) then ( CommodityPriceExposureUnit )
when ( DisplayView = 'M' ) then ( CmmdtyPriceExpsrMassUnit )
when ( DisplayView = 'V' ) then ( CmmdtyPriceExpsrVolumeUnit )
else CommodityPriceExposureUnit end as tpm_cty_uom ) as CommodityPriceExposureUnit,
DerivativePositionEOD.FinancialTransactionPortfolio,
DerivativePositionEOD.CmmdtyHdgPlanExposureHedgeBook,
DerivativePositionEOD.CommodityHedgePlanExposureID,
// DerivativePositionEOD._CommodityPriceFixationStatus,
DerivativePositionEOD._CompanyCode,
DerivativePositionEOD._DerivativeContrSpecification,
DerivativePositionEOD._FinAssetsMgmtProductType,
DerivativePositionEOD._MarketIdentifierCode,
DerivativePositionEOD._PhysicalCommodity,
_UnitOfMeasure
}
union
select from P_DerivativePosDODTechLayer (P_SNAPSHOT0: $parameters.P_EvaluationDate, P_SNAPSHOT1: $parameters.P_ComparisionDate, P_DisplayView: $parameters.P_DisplayView) as DerivativePositionDoD
association [0..1] to I_UnitOfMeasure as _UnitOfMeasure on $projection.CommodityPriceExposureUnit = _UnitOfMeasure.UnitOfMeasure
{
key DerivativePositionDoD.CompanyCode,
key DerivativePositionDoD.CommodityPriceExposure,
key DerivativePositionDoD.CommodityExposureCategory,
key DerivativePositionDoD.CommodityPriceSubExposure,
key DerivativePositionDoD.CommodityPriceExposureVersion,
DerivativePositionDoD.ValidityStartDateTime,
DerivativePositionDoD.ValidityEndDateTime,
DerivativePositionDoD.ValidityStartDate,
DerivativePositionDoD.ValidityStartTime,
DerivativePositionDoD.ValidityEndDate,
DerivativePositionDoD.ValidityEndTime,
DerivativePositionDoD.ValidityStartCharTimestamp,
DerivativePositionDoD.ValidityEndCharTimestamp,
DerivativePositionDoD.MaximumVersion,
DerivativePositionDoD.RiskAnalyzerVersionUUID,
DerivativePositionDoD.ExposureDueDate,
DerivativePositionDoD.ReportingDate,
DerivativePositionDoD.Commodity,
DerivativePositionDoD.CashFlowDirection,
DerivativePositionDoD.TreasuryPositionLongShortCode,
DerivativePositionDoD.DerivativeContrSpecification,
DerivativePositionDoD.MarketIdentifierCode,
DerivativePositionDoD.QuotationPriceType,
DerivativePositionDoD.TimeToMaturity,
DerivativePositionDoD.CmmdtyForwardIndexTiming,
DerivativePositionDoD.MaturityKeyDate,
DerivativePositionDoD.DerivativeContractMaturityCode,
DerivativePositionDoD.FinancialInstrProductCategory,
DerivativePositionDoD.FinancialAssetsMgmtProductType,
DerivativePositionDoD.FinInstrTransactionCategory,
DerivativePositionDoD.FinancialInstrumentProductType,
DerivativePositionDoD.FinancialInstrActivityCategory,
DerivativePositionDoD.FinancialObject,
DerivativePositionDoD.HasError,
DerivativePositionDoD.TermStartDate,
DerivativePositionDoD.TermEndDate,
DerivativePositionDoD.DeliveryDate,
DerivativePositionDoD.NumberOfCommodityContracts,
DerivativePositionDoD.CommodityPriceFixationStatus,
DerivativePositionDoD.TreasuryPositionAccount,
DerivativePositionDoD.DerivativeContract,
DerivativePositionDoD.QuotationCurrency,
DerivativePositionDoD.PaymentCurrency,
DerivativePositionDoD.OptionStrikePrice,
DerivativePositionDoD.OptionStrikeCurrency,
DerivativePositionDoD.OptionPutCallCode,
DerivativePositionDoD.OptionExerciseType,
DerivativePositionDoD.EndOfDayBusinessEntityKey,
DerivativePositionDoD.ReportingMonth,
DerivativePositionDoD.ReportingYear,
DerivativePositionDoD.EvaluationDate,
/*End of day */
DerivativePositionDoD.EndOfDaySnapshotDate,
DerivativePositionDoD.EndOfDaySnapshotDateTime,
DerivativePositionDoD.ConsumptionType,
DerivativePositionDoD.DisplayView,
DerivativePositionDoD.FinInstrExternalReference,
DerivativePositionDoD.TradedDrvtvContrSpecification,
DerivativePositionDoD.ParDrvtvContractSpecification,
DerivativePositionDoD.RiskViewIsNotRelevant,
cast ( case when ( DisplayView = 'P' ) then ( CommodityPriceExposureQuantity )
when ( DisplayView = 'M' ) then ( CmmdtyPriceExpsrQtyInMassUnit )
when ( DisplayView = 'V' ) then ( CmmdtyPriceExpsrQtyInVolUnit )
else CommodityPriceExposureQuantity end as ftr_exposure_qty ) as CommodityPriceExposureQuantity,
cast ( case when ( DisplayView = 'P' ) then ( CommodityPriceExposureUnit )
when ( DisplayView = 'M' ) then ( CmmdtyPriceExpsrMassUnit )
when ( DisplayView = 'V' ) then ( CmmdtyPriceExpsrVolumeUnit )
else CommodityPriceExposureUnit end as tpm_cty_uom ) as CommodityPriceExposureUnit,
DerivativePositionDoD.FinancialTransactionPortfolio,
DerivativePositionDoD.CmmdtyHdgPlanExposureHedgeBook,
DerivativePositionDoD.CommodityHedgePlanExposureID,
// DerivativePositionDOD._CommodityPriceFixationStatus,
DerivativePositionDoD._CompanyCode,
DerivativePositionDoD._DerivativeContrSpecification,
DerivativePositionDoD._FinAssetsMgmtProductType,
DerivativePositionDoD._MarketIdentifierCode,
DerivativePositionDoD._PhysicalCommodity,
_UnitOfMeasure
}
union select from P_DerivativePosTechLayer (P_EvaluationDate: $parameters.P_EvaluationDate, P_DisplayView: $parameters.P_DisplayView) as DerivativePositionCurrent
association [0..1] to I_UnitOfMeasure as _UnitOfMeasure on $projection.CommodityPriceExposureUnit = _UnitOfMeasure.UnitOfMeasure
{
key DerivativePositionCurrent.CompanyCode,
key DerivativePositionCurrent.CommodityPriceExposure,
key DerivativePositionCurrent.CommodityExposureCategory,
key DerivativePositionCurrent.CommodityPriceSubExposure,
key DerivativePositionCurrent.CommodityPriceExposureVersion,
DerivativePositionCurrent.ValidityStartDateTime,
DerivativePositionCurrent.ValidityEndDateTime,
DerivativePositionCurrent.ValidityStartDate,
DerivativePositionCurrent.ValidityStartTime,
DerivativePositionCurrent.ValidityEndDate,
DerivativePositionCurrent.ValidityEndTime,
DerivativePositionCurrent.ValidityStartCharTimestamp,
DerivativePositionCurrent.ValidityEndCharTimestamp,
DerivativePositionCurrent.MaximumVersion,
DerivativePositionCurrent.RiskAnalyzerVersionUUID,
DerivativePositionCurrent.ExposureDueDate,
DerivativePositionCurrent.ReportingDate,
DerivativePositionCurrent.Commodity,
DerivativePositionCurrent.CashFlowDirection,
DerivativePositionCurrent.TreasuryPositionLongShortCode,
DerivativePositionCurrent.DerivativeContrSpecification,
DerivativePositionCurrent.MarketIdentifierCode,
DerivativePositionCurrent.QuotationPriceType,
DerivativePositionCurrent.TimeToMaturity,
DerivativePositionCurrent.CmmdtyForwardIndexTiming,
DerivativePositionCurrent.MaturityKeyDate,
DerivativePositionCurrent.DerivativeContractMaturityCode,
DerivativePositionCurrent.FinancialInstrProductCategory,
DerivativePositionCurrent.FinancialAssetsMgmtProductType,
DerivativePositionCurrent.FinInstrTransactionCategory,
DerivativePositionCurrent.FinancialInstrumentProductType,
DerivativePositionCurrent.FinancialInstrActivityCategory,
DerivativePositionCurrent.FinancialObject,
DerivativePositionCurrent.HasError,
DerivativePositionCurrent.TermStartDate,
DerivativePositionCurrent.TermEndDate,
DerivativePositionCurrent.DeliveryDate,
DerivativePositionCurrent.NumberOfCommodityContracts,
DerivativePositionCurrent.CommodityPriceFixationStatus,
DerivativePositionCurrent.TreasuryPositionAccount,
DerivativePositionCurrent.DerivativeContract,
DerivativePositionCurrent.QuotationCurrency,
DerivativePositionCurrent.PaymentCurrency,
DerivativePositionCurrent.OptionStrikePrice,
DerivativePositionCurrent.OptionStrikeCurrency,
DerivativePositionCurrent.OptionPutCallCode,
DerivativePositionCurrent.OptionExerciseType,
DerivativePositionCurrent.EndOfDayBusinessEntityKey,
DerivativePositionCurrent.ReportingMonth,
DerivativePositionCurrent.ReportingYear,
DerivativePositionCurrent.EvaluationDate,
/*End of day */
DerivativePositionCurrent.EndOfDaySnapshotDate,
DerivativePositionCurrent.EndOfDaySnapshotDateTime,
DerivativePositionCurrent.ConsumptionType,
DerivativePositionCurrent.DisplayView,
DerivativePositionCurrent.FinInstrExternalReference,
DerivativePositionCurrent.TradedDrvtvContrSpecification,
DerivativePositionCurrent.ParDrvtvContractSpecification,
DerivativePositionCurrent.RiskViewIsNotRelevant,
cast ( case when ( DisplayView = 'P' ) then ( CommodityPriceExposureQuantity )
when ( DisplayView = 'M' ) then ( CmmdtyPriceExpsrQtyInMassUnit )
when ( DisplayView = 'V' ) then ( CmmdtyPriceExpsrQtyInVolUnit )
else CommodityPriceExposureQuantity end as ftr_exposure_qty ) as CommodityPriceExposureQuantity,
cast ( case when ( DisplayView = 'P' ) then ( CommodityPriceExposureUnit )
when ( DisplayView = 'M' ) then ( CmmdtyPriceExpsrMassUnit )
when ( DisplayView = 'V' ) then ( CmmdtyPriceExpsrVolumeUnit )
else CommodityPriceExposureUnit end as tpm_cty_uom ) as CommodityPriceExposureUnit,
DerivativePositionCurrent.FinancialTransactionPortfolio,
DerivativePositionCurrent.CmmdtyHdgPlanExposureHedgeBook,
DerivativePositionCurrent.CommodityHedgePlanExposureID,
// DerivativePositionCurrent._CommodityPriceFixationStatus,
DerivativePositionCurrent._CompanyCode,
DerivativePositionCurrent._DerivativeContrSpecification,
DerivativePositionCurrent._FinAssetsMgmtProductType,
DerivativePositionCurrent._MarketIdentifierCode,
DerivativePositionCurrent._PhysicalCommodity,
_UnitOfMeasure
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_DERIVATIVEPOSDODTECHLAYER",
"P_DERIVATIVEPOSTECHLAYER",
"P_DRVTVPOSENDOFDAYTECHLAYER"
],
"ASSOCIATED":
[
"I_CMMDTY",
"I_COMPANYCODE",
"I_DERIVATIVECONTRSPEC",
"I_FINASSETSMGNTPRODUCTTYPE",
"I_MARKETIDENTCODE",
"I_UNITOFMEASURE"
],
"BASE":
[
"P_DRVTVPOSENDOFDAYTECHLAYER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/