A_ProjectBillingRequest

DDL: A_PROJECTBILLINGREQUEST Type: view_entity COMPOSITE

Project Billing Request

A_ProjectBillingRequest is a Composite CDS View that provides data about "Project Billing Request" in SAP S/4HANA. It reads from 1 data source (R_ProjectBillingRequestTP) and exposes 14 fields with key field ProjectBillingRequestUUID. It has 1 association to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
R_ProjectBillingRequestTP R_ProjectBillingRequestTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_WrittenOffPrjBillgElmEntry _WrittenOffPrjBillgElmEntry ProjectBillingRequest.ProjectBillingRequestUUID = _WrittenOffPrjBillgElmEntry.ProjectBillingRequestUUID

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Project Billing Request view
OData.entitySet.name A_ProjectBillingRequest view
OData.entityType.name ProjectBillingRequest_Type view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingRequestUUID ProjectBillingRequestUUID
ProjectBillingRequest ProjectBillingRequest
ProjectBillingRequestStatus ProjectBillingRequestStatus
ProjBillgReqApprovalStatus ProjBillgReqApprovalStatus
SalesDocument SalesDocument
ProjBillgReqLastChgdBy ProjBillgReqLastChgdBy
ProjBillgReqLastChgdAtDteTme ProjBillgReqLastChgdAtDteTme
ProjBillgReqCreatedBy ProjBillgReqCreatedBy
ProjBillgReqCreatedAtDteTme ProjBillgReqCreatedAtDteTme
ProjectUUID _EnterpriseProject ProjectUUID
ProjectInternalID ProjectBillingRequest ProjectInternalID
ProjectBillingCategory ProjectBillingCategory
_WrittenOffPrjBillgElmEntry _WrittenOffPrjBillgElmEntry
_EnterpriseProject _EnterpriseProject 
@AccessControl: {
    authorizationCheck:     #MANDATORY,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED
}
@VDM.usage.type:[#TRANSACTIONAL_PROCESSING_SERVICE]
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@ObjectModel: {

    usageType: {
      dataClass:       #TRANSACTIONAL,
      serviceQuality:  #C,
      sizeCategory:    #XL
    }
}
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Project Billing Request'
@OData.entitySet.name : 'A_ProjectBillingRequest'
@OData.entityType.name:'ProjectBillingRequest_Type' 
define root view entity A_ProjectBillingRequest 
  provider contract transactional_query
  as projection on R_ProjectBillingRequestTP as ProjectBillingRequest
  
  association [0..*] to A_WrittenOffPrjBillgElmEntry as _WrittenOffPrjBillgElmEntry on ProjectBillingRequest.ProjectBillingRequestUUID = _WrittenOffPrjBillgElmEntry.ProjectBillingRequestUUID
{
  key ProjectBillingRequestUUID,
  ProjectBillingRequest,
  @ObjectModel.sapObjectNodeTypeReference: 'ProjectBillingRequestStatus'
  ProjectBillingRequestStatus,
  @ObjectModel.sapObjectNodeTypeReference: 'ProjBillgReqApprovalStatus'
  ProjBillgReqApprovalStatus,
  SalesDocument,
  ProjBillgReqLastChgdBy,
  ProjBillgReqLastChgdAtDteTme,
  ProjBillgReqCreatedBy,
  ProjBillgReqCreatedAtDteTme,
  _EnterpriseProject.ProjectUUID,
  ProjectBillingRequest.ProjectInternalID,
  @Consumption.hidden: true 
  ProjectBillingCategory,
  
  _WrittenOffPrjBillgElmEntry,
  @Consumption.hidden: true 
  _EnterpriseProject,
  
  _ProjectBillingReqItemTP   : redirected to composition child A_ProjectBillingRequestItem
  
}

where ProjectBillingCategory <> 'ICBL'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENTERPRISEPROJECT",
"R_PROJECTBILLINGREQUESTTP"
],
"ASSOCIATED":
[
"A_PROJECTBILLINGREQUESTITEM",
"A_WRITTENOFFPRJBILLGELMENTRY",
"I_ENTERPRISEPROJECT",
"R_PROJECTBILLINGREQUESTITEMTP"
],
"BASE":
[
"R_PROJECTBILLINGREQUESTTP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More