C_CustomerProjectBilling

DDL: C_CUSTOMERPROJECTBILLING SQL: CCUSTPROJBIL Type: view CONSUMPTION

Customer Project Billing Document

C_CustomerProjectBilling is a Consumption CDS View that provides data about "Customer Project Billing Document" in SAP S/4HANA. It reads from 1 data source (I_CustomerProject) and exposes 8 fields with key fields CustomerProject, CustomerProjectItem. It has 2 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_CustomerProject CustomerProject inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_BillingDocumentItem _BillingDocumentItem CustomerProjectItem.CustomerProjectItem = _BillingDocumentItem.SalesDocument
[1..1] I_BillingDocument _BillingDocument $projection.BillingDocument = _BillingDocument.BillingDocument

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CCUSTPROJBIL view
EndUserText.label Customer Project Billing Document view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CustomerProject I_CustomerProject CustomerProject
KEY CustomerProjectItem CustomerProjectItem CustomerProjectItem
BillingDocument BillingDocumentItem BillingDocument
CustomerProjectType I_CustomerProject CustomerProjectType
CustomerProjectServiceOrg I_CustomerProject CustomerProjectServiceOrg
EngagementProjectCategory I_CustomerProject ProjectType
_BillingDocumentItem _BillingDocumentItem
_BillingDocument _BillingDocument 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CCUSTPROJBIL'
@EndUserText.label: 'Customer Project Billing Document'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.authorizationCheck: #CHECK
define view C_CustomerProjectBilling
  as select distinct from  I_CustomerProjectItem as CustomerProjectItem
    inner join             I_CustomerProject     as CustomerProject     on  CustomerProject.CustomerProjectUUID         = CustomerProjectItem.CustomerProjectUUID
                                                                        and CustomerProjectItem.CustomerProjectItemType = '0SOH'
    left outer to one join I_BillingDocumentItem as BillingDocumentItem on CustomerProjectItem.CustomerProjectItem = BillingDocumentItem.SalesDocument


  association [1..1] to I_BillingDocumentItem as _BillingDocumentItem on CustomerProjectItem.CustomerProjectItem = _BillingDocumentItem.SalesDocument
  association [1..1] to I_BillingDocument     as _BillingDocument     on $projection.BillingDocument = _BillingDocument.BillingDocument
{
  key CustomerProject.CustomerProject,
  key CustomerProjectItem.CustomerProjectItem as CustomerProjectItem,
      BillingDocumentItem.BillingDocument     as BillingDocument,
      CustomerProject.CustomerProjectType,
      CustomerProject.CustomerProjectServiceOrg,
      CustomerProject.ProjectType             as EngagementProjectCategory,
      _BillingDocumentItem,
      _BillingDocument
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENTITEM",
"I_CUSTOMERPROJECT",
"I_CUSTOMERPROJECTITEM"
],
"ASSOCIATED":
[
"I_BILLINGDOCUMENT",
"I_BILLINGDOCUMENTITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More