I_CustomerProjectPlanData

DDL: I_CUSTOMERPROJECTPLANDATA SQL: ICUSTPROJPLAN Type: view COMPOSITE Package: CPD_CDS

Customer Project Planning Data

I_CustomerProjectPlanData is a Composite CDS View that provides data about "Customer Project Planning Data" in SAP S/4HANA. It reads from 2 data sources (I_CustomerProject, I_EngmntProjectPlnDataVersion) and exposes 26 fields with key fields PlanLineItemUUID, CustProjFinancialPlanUUID, CustProjWorkPackageUUID, CustProjFinancialPlanVersion, CustomerProjectResourceType. It has 4 associations to related views. Part of development package CPD_CDS.

2 data source(s) 26 fields

Data Sources (2)

SourceAliasJoin Type
I_CustomerProject CustomerProject left_outer
I_EngmntProjectPlnDataVersion PlanData from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Currency _Currency $projection.Currency = _Currency.Currency
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure
[0..*] I_CustProjResourceText _CustProjResourceText $projection.CustomerProjectResource = _CustProjResourceText.CustomerProjectResource
[0..1] I_CustProjWrkPckgText _CustProjWrkPckgText $projection.CustProjWorkPackageUUID = _CustProjWrkPckgText.CustProjWorkPackageUUID

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTPROJPLAN view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Customer Project Planning Data view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY PlanLineItemUUID PlanLineItemUUID
KEY CustProjFinancialPlanUUID
KEY CustProjWorkPackageUUID
KEY CustProjFinancialPlanVersion
KEY CustomerProjectResourceType
KEY FiscalPeriod I_EngmntProjectPlnDataVersion FiscalPeriod
KEY FiscalYear I_EngmntProjectPlnDataVersion FiscalYear
KEY CustomerProjectResource
KEY PersonnelNumber I_EngmntProjectPlnDataVersion EmploymentInternalID
KEY CustProjWorkPckgEmplIsStaffed I_EngmntProjectPlnDataVersion EngmtProjEmployeeIsStaffed
CustomerProject I_CustomerProject CustomerProject
CustomerProjectType I_CustomerProject CustomerProjectType
CustomerProjectServiceOrg I_CustomerProject CustomerProjectServiceOrg
Currency I_EngmntProjectPlnDataVersion Currency
CustProjWrkPckgPlanCost I_EngmntProjectPlnDataVersion PlndCostAmt
UnitOfMeasure I_EngmntProjectPlnDataVersion UnitOfMeasure
CustProjWrkPckgPlanEffortQty I_EngmntProjectPlnDataVersion PlndEffortQty
CustProjWrkPckgPlanRevenue I_EngmntProjectPlnDataVersion PlndRevnAmt
_Currency _Currency
_UnitOfMeasure _UnitOfMeasure
_CustProjResourceText _CustProjResourceText
_CustProjWrkPckgText _CustProjWrkPckgText
EngagementProject I_EngmntProjectPlnDataVersion EngagementProject
_MyProject I_EngmntProjectPlnDataVersion _MyProject
_EngagementProject I_EngmntProjectPlnDataVersion _EngagementProject
_PersonWorkAgreement_1 I_EngmntProjectPlnDataVersion _PersonWorkAgreement_1 
@AbapCatalog.sqlViewName: 'ICUSTPROJPLAN'
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Customer Project Planning Data'
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

// This view is deprecated Kindly use I_EngagementProjectPlanData


define view I_CustomerProjectPlanData
  as select from    I_EngmntProjectPlnDataVersion as PlanData
    left outer join I_CustomerProject             as CustomerProject on PlanData.EngagementProjFinPlanUUID = CustomerProject.CustProjFinancialPlanUUID


  association [0..1] to I_Currency             as _Currency             on $projection.Currency = _Currency.Currency
  association [0..1] to I_UnitOfMeasure        as _UnitOfMeasure        on $projection.UnitOfMeasure = _UnitOfMeasure.UnitOfMeasure
  association [0..*] to I_CustProjResourceText as _CustProjResourceText on $projection.CustomerProjectResource = _CustProjResourceText.CustomerProjectResource
  association [0..1] to I_CustProjWrkPckgText  as _CustProjWrkPckgText  on $projection.CustProjWorkPackageUUID = _CustProjWrkPckgText.CustProjWorkPackageUUID

{

  key PlanLineItemUUID                                                               as PlanLineItemUUID,
  key cast(PlanData.EngagementProjFinPlanUUID   as /cpd/ss_cp_fp_uuid )              as CustProjFinancialPlanUUID,
  key cast(PlanData.WorkPackageUUID  as /cpd/ss_cp_wp_uuid )                         as CustProjWorkPackageUUID,
  key cast(PlanData.EngmtProjFinPlanVersion  as /cpd/ss_cp_fp_version )              as CustProjFinancialPlanVersion,
  key cast(PlanData.EngagementProjectResourceType as /cpd/ss_cp_res_typ )            as CustomerProjectResourceType,
  key PlanData.FiscalPeriod                                                          as FiscalPeriod,
  key PlanData.FiscalYear                                                            as FiscalYear,
  key cast(PlanData.EngagementProjectResource as /cpd/ss_cp_resource )               as CustomerProjectResource,
  key PlanData.EmploymentInternalID                                                  as PersonnelNumber,
  key PlanData.EngmtProjEmployeeIsStaffed                                            as CustProjWorkPckgEmplIsStaffed,
      CustomerProject.CustomerProject                                                as CustomerProject,
      CustomerProject.CustomerProjectType                                            as CustomerProjectType,
      CustomerProject.CustomerProjectServiceOrg                                      as CustomerProjectServiceOrg,
      @Semantics.currencyCode: true
      PlanData.Currency                                                              as Currency,
      @Semantics.amount.currencyCode: 'Currency'
      PlanData.PlndCostAmt                                                           as CustProjWrkPckgPlanCost,
      @Semantics.unitOfMeasure: true
      PlanData.UnitOfMeasure                                                         as UnitOfMeasure,
      @Semantics.quantity.unitOfMeasure:'UnitOfMeasure'      
      PlanData.PlndEffortQty                                                         as CustProjWrkPckgPlanEffortQty,
      @Semantics.amount.currencyCode: 'Currency'      
      PlanData.PlndRevnAmt                                                           as CustProjWrkPckgPlanRevenue,
      _Currency,

      _UnitOfMeasure,
      _CustProjResourceText,
      _CustProjWrkPckgText,
      PlanData.EngagementProject,
      PlanData._MyProject,
      PlanData._EngagementProject,
      PlanData._PersonWorkAgreement_1
}
where
  EngmtProjFinPlanVersion = '1'

Learn More