I_EngmtProjFinPlanVersion

DDL: I_ENGMTPROJFINPLANVERSION SQL: IEPFINPLNVERSN Type: view BASIC

Engagement Project Financial Plan Version

I_EngmtProjFinPlanVersion is a Basic CDS View that provides data about "Engagement Project Financial Plan Version" in SAP S/4HANA. It reads from 1 data source (/cpd/d_pfp_pv) and exposes 10 fields with key fields EngagementProjFinPlanUUID, EngmtProjFinPlanVersion. It has 2 associations to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
/cpd/d_pfp_pv PlanVersion from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_EngmtProjFinPlanVersionType _EngmtProjFinPlanVersionType $projection.EngmtProjFinPlanVersionType = _EngmtProjFinPlanVersionType.EngmtProjFinPlanVersionType
[0..1] I_EngagementProjFinancialPlan _EngagementProjFinancialPlan $projection.EngagementProjFinPlanUUID = _EngagementProjFinancialPlan.EngagementProjFinPlanUUID

Annotations (8)

NameValueLevelField
EndUserText.label Engagement Project Financial Plan Version view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName IEPFINPLNVERSN view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY EngagementProjFinPlanUUID /cpd/d_pfp_pv parent_key
KEY EngmtProjFinPlanVersion /cpd/d_pfp_pv version_id
EngmtProjFinPlanVersionUUID /cpd/d_pfp_pv db_key
EngmtProjFinPlanVersionType /cpd/d_pfp_pv version_type
CreatedByUser /cpd/d_pfp_pv created_by
CreationDateTime
LastChangedByUser /cpd/d_pfp_pv changed_by
LastChangeDateTime
_EngmtProjFinPlanVersionType _EngmtProjFinPlanVersionType
_EngagementProjFinancialPlan _EngagementProjFinancialPlan 
@EndUserText.label: 'Engagement Project Financial Plan Version'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.sqlViewName: 'IEPFINPLNVERSN'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view I_EngmtProjFinPlanVersion
  as select from /cpd/d_pfp_pv as PlanVersion

  association [0..1] to I_EngmtProjFinPlanVersionType as _EngmtProjFinPlanVersionType on $projection.EngmtProjFinPlanVersionType = _EngmtProjFinPlanVersionType.EngmtProjFinPlanVersionType
  association [0..1] to I_EngagementProjFinancialPlan as _EngagementProjFinancialPlan on $projection.EngagementProjFinPlanUUID = _EngagementProjFinancialPlan.EngagementProjFinPlanUUID
{

  key  PlanVersion.parent_key                               as EngagementProjFinPlanUUID,
  key  PlanVersion.version_id                               as EngmtProjFinPlanVersion,
       PlanVersion.db_key                                   as EngmtProjFinPlanVersionUUID,
       PlanVersion.version_type                             as EngmtProjFinPlanVersionType,
       PlanVersion.created_by                               as CreatedByUser,
       @Semantics.dateTime:true
       @Semantics.systemDateTime.createdAt:true
       cast(PlanVersion.created_on as /cpd/cpm_createdon)   as CreationDateTime,
       PlanVersion.changed_by                               as LastChangedByUser,
       @Semantics.dateTime:true
       @Semantics.systemDateTime.lastChangedAt:true
       cast(PlanVersion.changed_on as /cpd/cpm_changedon)   as LastChangeDateTime,
       _EngmtProjFinPlanVersionType,
       _EngagementProjFinancialPlan
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/CPD/D_PFP_PV"
],
"ASSOCIATED":
[
"I_ENGAGEMENTPROJFINANCIALPLAN",
"I_ENGMTPROJFINPLANVERSIONTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More