I_CustomerProjectWorkPackage

DDL: I_CUSTOMERPROJECTWORKPACKAGE SQL: ICPWORKPACKAGE Type: view BASIC

Customer Project Work Package

I_CustomerProjectWorkPackage is a Basic CDS View that provides data about "Customer Project Work Package" in SAP S/4HANA. It reads from 1 data source (I_WorkPackage) and exposes 19 fields with key field CustProjWorkPackageUUID. It has 2 associations to related views.

1 data source(s) 19 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkPackage CustomerProjectWorkpackage from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CustomerProject _CustomerProject $projection.CustProjFinancialPlanUUID = _CustomerProject.CustProjFinancialPlanUUID
[1..1] E_CustomerProjectWorkPackage _Extension CustomerProjectWorkpackage.WorkPackageUUID = _Extension.CustProjWorkPackageUUID

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ICPWORKPACKAGE view
EndUserText.label Customer Project Work Package view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CustProjWorkPackageUUID
CustProjFinancialPlanUUID
CustomerProjectWorkPackage
CustProjWorkPackageName
CustProjWorkPackageStartDate I_WorkPackage WorkPackageStartDate
CustProjWorkPackageEndDate I_WorkPackage WorkPackageEndDate
CustomerProject _CustomerProject CustomerProject
CustomerProjectType _CustomerProject CustomerProjectType
CustomerProjectServiceOrg _CustomerProject CustomerProjectServiceOrg
Currency _CustomerProject Currency
CustomerProjectUUID
CustomerProjectName
WBSElementObject I_WorkPackage WBSElementObject
SalesOrderItem
SalesOrder I_WorkPackage SalesOrder
WBSDescription I_WorkPackage WBSDescription
LastChangeDateTime I_WorkPackage LastChangeDateTime
LastChangedByUser I_WorkPackage LastChangedByUser
_CustomerProject _CustomerProject 
@AbapCatalog.sqlViewName: 'ICPWORKPACKAGE'
@EndUserText.label: 'Customer Project Work Package'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view I_CustomerProjectWorkPackage
  as select from I_WorkPackage as CustomerProjectWorkpackage
  association [0..1] to I_CustomerProject            as _CustomerProject on $projection.CustProjFinancialPlanUUID = _CustomerProject.CustProjFinancialPlanUUID
  association [1..1] to E_CustomerProjectWorkPackage as _Extension       on CustomerProjectWorkpackage.WorkPackageUUID = _Extension.CustProjWorkPackageUUID
  //association [0..1] to C_SalesOrderItemList on $projection.SalesOrder = C_SalesOrderItemList.SalesOrder

{
  key cast(CustomerProjectWorkpackage.WorkPackageUUID     as /cpd/ss_cp_wp_uuid )                         as CustProjWorkPackageUUID,
      cast(CustomerProjectWorkpackage.EngagementProjFinPlanUUID  as /cpd/cust_pfp_db_key preserving type) as CustProjFinancialPlanUUID,

      cast(CustomerProjectWorkpackage.WorkPackage   as /cpd/ss_cp_wp )                                    as CustomerProjectWorkPackage,
      cast(CustomerProjectWorkpackage.WorkPackageName as /cpd/ss_cp_wp_name )                             as CustProjWorkPackageName,
      CustomerProjectWorkpackage.WorkPackageStartDate                                                     as CustProjWorkPackageStartDate,
      CustomerProjectWorkpackage.WorkPackageEndDate                                                       as CustProjWorkPackageEndDate,
      _CustomerProject.CustomerProject                                                                    as CustomerProject,
      _CustomerProject.CustomerProjectType                                                                as CustomerProjectType,
      _CustomerProject.CustomerProjectServiceOrg                                                          as CustomerProjectServiceOrg,
      _CustomerProject.Currency                                                                           as Currency,
      cast(_CustomerProject.CustomerProjectUUID      as /cpd/ss_cp_uuid )                                 as CustomerProjectUUID,
      cast(_CustomerProject.CustomerProjectName      as /cpd/ss_cp_desc )                                 as CustomerProjectName,
      concat(
          concat(
             _CustomerProject.CustomerProjectName,
              '-'),
          CustomerProjectWorkpackage.WorkPackageName)                                                     as CustProjWorkPackageFullName,
      CustomerProjectWorkpackage.WBSElementObject                                                         as WBSElementObject,
      cast(CustomerProjectWorkpackage.SalesOrderItem  as /cpd/so_item_id preserving type)                 as SalesOrderItem,
      CustomerProjectWorkpackage.SalesOrder                                                               as SalesOrder,
      CustomerProjectWorkpackage.WBSDescription                                                           as WBSDescription,
      @Semantics.dateTime:true
      @Semantics.systemDateTime.lastChangedAt:true
      CustomerProjectWorkpackage.LastChangeDateTime                                                       as LastChangeDateTime,
      CustomerProjectWorkpackage.LastChangedByUser                                                        as LastChangedByUser,
      _CustomerProject

}

Learn More