I_Customerprojectresource

DDL: I_CUSTOMERPROJECTRESOURCE SQL: ICUSTPROJRESC Type: view BASIC

Customer Project Resource

I_Customerprojectresource is a Basic CDS View that provides data about "Customer Project Resource" in SAP S/4HANA. It reads from 2 data sources (I_CostCenterActivityTypeText, I_CustomerProjectExpenseType) and exposes 2 fields.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
I_CostCenterActivityTypeText ActivityTypeText union_all
I_CustomerProjectExpenseType ExpenseTypeText from

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTPROJRESC view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Customer Project Resource view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (2)

KeyFieldSource TableSource FieldDescription
CustomerProjectResource I_CustomerProjectExpenseType CustomerProjectExpenseType
CustomerProjectResourceType 
@AbapCatalog.sqlViewName: 'ICUSTPROJRESC'
@VDM.viewType:#BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Customer Project Resource'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
define view I_Customerprojectresource
  as

  select from I_CustomerProjectExpenseType as ExpenseTypeText
{

  ExpenseTypeText.CustomerProjectExpenseType    as CustomerProjectResource,
  '0EXP'                                        as CustomerProjectResourceType



}

union all

select from I_CostCenterActivityTypeText as ActivityTypeText

{
  ActivityTypeText.CostCtrActivityType          as CustomerProjectResource,
  '0ACT'                                        as CustomerProjectResourceType

}
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COSTCENTERACTIVITYTYPETEXT",
"I_CUSTOMERPROJECTEXPENSETYPE"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More