P_CmmdtyHedgeExposureVersion

DDL: P_CMMDTYHEDGEEXPOSUREVERSION SQL: PEXPSRVER Type: view COMPOSITE

Active Version of ExposureID

P_CmmdtyHedgeExposureVersion is a Composite CDS View that provides data about "Active Version of ExposureID" in SAP S/4HANA. It reads from 1 data source (I_CommodityHedgePlanExposure) and exposes 5 fields with key fields CommodityHedgePlanExposureID, CmmdtyHdgPlnExpsrCompanyCode, CmmdtyHedgePlanExposureHashKey.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_CommodityHedgePlanExposure I_CommodityHedgePlanExposure from

Parameters (1)

NameTypeDefault
P_CmmdtyHdgPlanExposureVersion cmm_exposure_version

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PEXPSRVER view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Active Version of ExposureID view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CommodityHedgePlanExposureID CommodityHedgePlanExposureID
KEY CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode
KEY CmmdtyHedgePlanExposureHashKey CmmdtyHedgePlanExposureHashKey
CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion
CmmdtyHdgPlanExposureVersion 
@AbapCatalog.sqlViewName: 'PEXPSRVER'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Active Version of ExposureID'
define view P_CmmdtyHedgeExposureVersion
  with parameters
    P_CmmdtyHdgPlanExposureVersion : cmm_exposure_version
  as select from I_CommodityHedgePlanExposure
{
  key CommodityHedgePlanExposureID,
  key CmmdtyHdgPlnExpsrCompanyCode,
  key CmmdtyHedgePlanExposureHashKey,
       CmmdtyHedgePlanExposureVersion as CmmdtyHedgePlanExposureVersion,
       $parameters.P_CmmdtyHdgPlanExposureVersion as CmmdtyHdgPlanExposureVersion 
}
where CmmdtyHedgePlanExposureStatus = 'ICPE4';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMMODITYHEDGEPLANEXPOSURE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More