I_ProjectBillingRequest

@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@EndUserText.label: 'Project Billing Request'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #MANDATORY
@Analytics.dataExtraction.enabled: true
@Analytics.dataExtraction.delta.changeDataCapture.automatic: true
@ObjectModel: {
    modelingPattern: #ANALYTICAL_DIMENSION,
    supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #ANALYTICAL_DIMENSION, #EXTRACTION_DATA_SOURCE ],
    usageType: {
        sizeCategory: #L,
        dataClass:  #TRANSACTIONAL,
        serviceQuality: #A
    },
    representativeKey: 'ProjectBillingRequestUUID'
}
@Metadata.ignorePropagatedAnnotations: true

define view entity I_ProjectBillingRequest
  as select from projbillgreq
  association [0..*] to I_ProjectBillingRequestItem   as _ProjectBillingRequestItem   on $projection.ProjectBillingRequestUUID = _ProjectBillingRequestItem.ProjectBillingRequestUUID
  association [0..1] to I_ProjectBillingRequestStatus as _ProjectBillingRequestStatus on $projection.ProjectBillingRequestStatus = _ProjectBillingRequestStatus.ProjectBillingRequestStatus
  association [0..1] to I_ProjBillgReqApprovalStatus  as _ProjBillgReqApprovalStatus  on $projection.ProjBillgReqApprovalStatus = _ProjBillgReqApprovalStatus.ProjBillgReqApprovalStatus
  association [0..1] to I_ProjectBillingCategory      as _ProjectBillingCategory      on $projection.ProjectBillingCategory = _ProjectBillingCategory.ProjectBillingCategory

  association [0..1] to I_SalesDocument               as _SalesDocument               on $projection.SalesDocument = _SalesDocument.SalesDocument
  association [1..1] to I_EnterpriseProject           as _EnterpriseProject           on $projection.ProjectInternalID = _EnterpriseProject.ProjectInternalID  
{
  key projectbillingrequestuuid    as ProjectBillingRequestUUID,
      projectbillingrequest        as ProjectBillingRequest,
      @ObjectModel.foreignKey.association: '_ProjectBillingRequestStatus'
      projectbillingrequeststatus  as ProjectBillingRequestStatus,
      @ObjectModel.foreignKey.association: '_ProjBillgReqApprovalStatus'
      projbillgreqapprovalstatus   as ProjBillgReqApprovalStatus,
      projectbillingrequesttype    as ProjectBillingRequestType,
      @ObjectModel.foreignKey.association: '_SalesDocument'
      salesdocument                as SalesDocument,
//      salesdocumenttype            as SalesDocumentType,

      @ObjectModel.foreignKey.association: '_ProjectBillingCategory'
      projectbillingcategory       as ProjectBillingCategory,
      @Semantics.user.lastChangedBy: true
      projbillgreqlastchgdby       as ProjBillgReqLastChgdBy,
      @Semantics.systemDateTime.lastChangedAt: true
      projbillgreqlastchgdatdtetme as ProjBillgReqLastChgdAtDteTme,
      @Semantics.user.createdBy: true
      projbillgreqcreatedby        as ProjBillgReqCreatedBy,
      @Semantics.systemDateTime.createdAt: true
      projbillgreqcreatedatdtetme  as ProjBillgReqCreatedAtDteTme,
      projectinternalid            as ProjectInternalID,

      _ProjectBillingRequestItem,
      _ProjectBillingRequestStatus,
      _ProjBillgReqApprovalStatus,
      _ProjectBillingCategory,

      _SalesDocument,
      _EnterpriseProject
}