P_DrvtvInstrAvgGrpg

DDL: P_DRVTVINSTRAVGGRPG SQL: PVFINDAVGTL Type: view COMPOSITE
59 Fields 2 Data Sources

P_DrvtvInstrAvgGrpg is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (P_DrvtvInstrMatGrpg, P_DerivativePosTechLayer) and exposes 59 fields with key fields CompanyCode, CommodityPriceExposure, CommodityExposureCategory, CommodityPriceExposureVersion.

Data Sources (2)

SourceAliasJoin Type
P_DrvtvInstrMatGrpg code inner
P_DerivativePosTechLayer P_DerivativePosTechLayer from

Parameters (2)

NameTypeDefault
P_EvaluationDate cds_evaluation_date
P_DisplayView cds_view_uom

Annotations (10)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PVFINDAVGTL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AbapCatalog.preserveKey true view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode vfind CompanyCode Receiver Company Code
KEY CommodityPriceExposure vfind CommodityPriceExposure Exposure ID
KEY CommodityExposureCategory vfind CommodityExposureCategory
KEY CommodityPriceExposureVersion vfind CommodityPriceExposureVersion Exposure Version
CommodityPriceSubExposure vfind CommodityPriceSubExposure
ValidityStartDateTime vfind ValidityStartDateTime Valid From Timestamp
ValidityEndDateTime vfind ValidityEndDateTime Valid To Timestamp
ValidityStartDate vfind ValidityStartDate Validity Start Date
ValidityStartTime vfind ValidityStartTime Valid From Time
ValidityEndDate vfind ValidityEndDate ValidTo
ValidityEndTime vfind ValidityEndTime Valid To Time
ValidityStartCharTimestamp vfind ValidityStartCharTimestamp
ValidityEndCharTimestamp vfind ValidityEndCharTimestamp
MaximumVersion vfind MaximumVersion Highest Version
RiskAnalyzerVersionUUID vfind RiskAnalyzerVersionUUID Version GUID
ExposureDueDate vfind ExposureDueDate
ReportingDate vfind ReportingDate
Commodity vfind Commodity Commodity Code
CashFlowDirection vfind CashFlowDirection
TreasuryPositionLongShortCode vfind TreasuryPositionLongShortCode
DerivativeContrSpecification vfind DerivativeContrSpecification DCS ID
MarketIdentifierCode vfind MarketIdentifierCode MIC
TimeToMaturity vfind TimeToMaturity Time to Maturity
CmmdtyForwardIndexTiming vfind CmmdtyForwardIndexTiming
MaturityKeyDate vfind MaturityKeyDate Maturity Key Date
FinancialInstrProductCategory vfind FinancialInstrProductCategory
FinancialAssetsMgmtProductType vfind FinancialAssetsMgmtProductType
FinInstrTransactionCategory vfind FinInstrTransactionCategory
FinancialInstrumentProductType vfind FinancialInstrumentProductType
FinancialInstrActivityCategory vfind FinancialInstrActivityCategory
FinancialObject vfind FinancialObject
PnLEventType vfind PnLEventType
HasError vfind HasError TRUE
TermStartDate vfind TermStartDate
TermEndDate vfind TermEndDate
DeliveryDate vfind DeliveryDate Delivery Date
NumberOfCommodityContracts vfind NumberOfCommodityContracts
CommodityPriceExposureUnit vfind CommodityPriceExposureUnit
CommodityPriceExposureBaseUnit vfind CommodityPriceExposureBaseUnit
CmmdtyPriceExpsrMassUnit vfind CmmdtyPriceExpsrMassUnit
CmmdtyPriceExpsrVolumeUnit vfind CmmdtyPriceExpsrVolumeUnit
TreasuryPositionAccount vfind TreasuryPositionAccount
DerivativeContract vfind DerivativeContract
OptionStrikePrice vfind OptionStrikePrice
OptionStrikeCurrency vfind OptionStrikeCurrency
OptionPutCallCode vfind OptionPutCallCode
OptionExerciseType vfind OptionExerciseType
EvaluationDate vfind EvaluationDate
ConsumptionType vfind ConsumptionType
DisplayView vfind DisplayView
QuotationPriceType vfind QuotationPriceType Price Type
IsNotRelevantForMTMRisk vfind IsNotRelevantForMTMRisk
FinInstrExternalReference vfind FinInstrExternalReference
_CompanyCode _CompanyCode
_DerivativeContrSpecification _DerivativeContrSpecification
_FinAssetsMgmtProductType _FinAssetsMgmtProductType
_MarketIdentifierCode _MarketIdentifierCode
_PhysicalCommodity _PhysicalCommodity
_UnitOfMeasure _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_DrvtvInstrAvgGrpg.
-- 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: PVFINDAVGTL
-- Parameters: P_EvaluationDate : cds_evaluation_date, P_DisplayView : cds_view_uom

CREATE VIEW P_DrvtvInstrAvgGrpg AS
SELECT
  vfind.CompanyCode AS CompanyCode,
  vfind.CommodityPriceExposure AS CommodityPriceExposure,
  vfind.CommodityExposureCategory AS CommodityExposureCategory,
  vfind.CommodityPriceExposureVersion AS CommodityPriceExposureVersion,
  vfind.CommodityPriceSubExposure AS CommodityPriceSubExposure,
  vfind.ValidityStartDateTime AS ValidityStartDateTime,
  vfind.ValidityEndDateTime AS ValidityEndDateTime,
  vfind.ValidityStartDate AS ValidityStartDate,
  vfind.ValidityStartTime AS ValidityStartTime,
  vfind.ValidityEndDate AS ValidityEndDate,
  vfind.ValidityEndTime AS ValidityEndTime,
  vfind.ValidityStartCharTimestamp AS ValidityStartCharTimestamp,
  vfind.ValidityEndCharTimestamp AS ValidityEndCharTimestamp,
  vfind.MaximumVersion AS MaximumVersion,
  vfind.RiskAnalyzerVersionUUID AS RiskAnalyzerVersionUUID,
  vfind.ExposureDueDate AS ExposureDueDate,
  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.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.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.TreasuryPositionAccount AS TreasuryPositionAccount,
  vfind.DerivativeContract AS DerivativeContract,
  vfind.OptionStrikePrice AS OptionStrikePrice,
  vfind.OptionStrikeCurrency AS OptionStrikeCurrency,
  vfind.OptionPutCallCode AS OptionPutCallCode,
  vfind.OptionExerciseType AS OptionExerciseType,
  vfind.EvaluationDate AS EvaluationDate,
  vfind.ConsumptionType AS ConsumptionType,
  vfind.DisplayView AS DisplayView,
  vfind.QuotationPriceType AS QuotationPriceType,
  vfind.IsNotRelevantForMTMRisk AS IsNotRelevantForMTMRisk,
  vfind.FinInstrExternalReference AS FinInstrExternalReference
FROM P_DerivativePosTechLayer
INNER JOIN P_DrvtvInstrMatGrpg AS code ON /* join condition not captured in parsed metadata */
;

Learn More