C_WorkpackageWorkItem

DDL: C_WORKPACKAGEWORKITEM SQL: CWPWORKITEM Type: view CONSUMPTION

Workpackage workitem

C_WorkpackageWorkItem is a Consumption CDS View that provides data about "Workpackage workitem" in SAP S/4HANA. It reads from 1 data source (I_WorkPackageWorkItem) and exposes 16 fields. It has 1 association to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkPackageWorkItem WorkpackageWorkItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_EngmntProjWithUserInvlmnt _MyProjects $projection.EngagementProjectUUID = _MyProjects.ProjectUUID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CWPWORKITEM view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Workpackage workitem view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (16)

KeyFieldSource TableSource FieldDescription
WorkItemUUID I_WorkPackageWorkItem WorkItemUUID
EngagementProjFinPlanUUID I_WorkPackageWorkItem EngagementProjFinPlanUUID
WorkPackageUUID I_WorkPackageWorkItem WorkPackageUUID
WorkPackage I_WorkPackageWorkItem WorkPackage
WorkItem I_WorkPackageWorkItem WorkItem
WorkItemNameendasWorkItemName
WorkItemIsInactive I_WorkPackageWorkItem WorkItemIsInactive
SalesOrder _WorkPackage SalesOrder
SalesOrderItem _WorkPackage SalesOrderItem
WorkPackageName _WorkPackage WorkPackageName
EngagementProjectUUID _EngagementProjFinancialPlan EngagementProjectUUID
_WorkPackage _WorkPackage
_EngagementProjFinancialPlan _EngagementProjFinancialPlan
_EngagementProject _EngagementProjFinancialPlan _EngagementProject
_EngagementProjectPlanData _EngagementProjectPlanData
_MyProjects _MyProjects 
@AbapCatalog.sqlViewName: 'CWPWORKITEM'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Workpackage workitem'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view C_WorkpackageWorkItem
  as select from I_WorkPackageWorkItem as WorkpackageWorkItem   
  association [1..1] to I_EngmntProjWithUserInvlmnt   as _MyProjects                  on $projection.EngagementProjectUUID = _MyProjects.ProjectUUID
{

  WorkpackageWorkItem.WorkItemUUID                   as WorkItemUUID,
  WorkpackageWorkItem.EngagementProjFinPlanUUID      as EngagementProjFinPlanUUID,
  WorkpackageWorkItem.WorkPackageUUID                as WorkPackageUUID,
  //--[ GENERATED:012:GlBfhyJl7jY4oBIOE}WCZW

  @Consumption.valueHelpDefinition: [
    { entity:  { name:    'I_WorkPackageStdVH',
                 element: 'WorkPackage' }
    }]
  // ]--GENERATED

  WorkpackageWorkItem.WorkPackage                    as WorkPackage,
  WorkpackageWorkItem.WorkItem                       as WorkItem,

  case
  when WorkpackageWorkItem.WorkItemName is null or WorkpackageWorkItem.WorkItemName = ' '
  then
    WorkpackageWorkItem.WorkItem
  else
    WorkpackageWorkItem.WorkItemName end             as WorkItemName,

  WorkpackageWorkItem.WorkItemIsInactive             as WorkItemIsInactive,
  _WorkPackage.SalesOrder                            as SalesOrder,
  _WorkPackage.SalesOrderItem                        as SalesOrderItem,
  _WorkPackage.WorkPackageName                       as WorkPackageName,
  _EngagementProjFinancialPlan.EngagementProjectUUID as EngagementProjectUUID,
  _WorkPackage,
  _EngagementProjFinancialPlan,
  _EngagementProjFinancialPlan._EngagementProject,
  _EngagementProjectPlanData,
  _MyProjects

}

Learn More