A_ProjectBillingRequestItem

DDL: A_PROJECTBILLINGREQUESTITEM Type: view_entity CONSUMPTION

Project Billing Request Item

A_ProjectBillingRequestItem is a Consumption CDS View that provides data about "Project Billing Request Item" in SAP S/4HANA. It reads from 1 data source (R_ProjectBillingRequestItemTP) and exposes 47 fields with key field ProjectBillingRequestItemUUID. It has 1 association to related views. It is exposed through 1 OData service (API_PROJECTBILLINGREQUEST).

1 data source(s) Exposed by 1 service(s) 47 fields

Data Sources (1)

SourceAliasJoin Type
R_ProjectBillingRequestItemTP R_ProjectBillingRequestItemTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] A_PrjBlgReqItemJrnlEntrLink _PrjBlgReqItemJrnlEntrLink ProjectBillingRequestItem.ProjBillgElmntEntrItmUUID = _PrjBlgReqItemJrnlEntrLink.ProjBillgElmntEntrItmUUID

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION 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 Item view
OData.entityType.name ProjectBillingRequestItem_Type view

OData Services (1)

ServiceBindingVersionContractRelease
API_PROJECTBILLINGREQUEST API_PROJECTBILLINGREQUEST V4 C2 C1

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingRequestItemUUID ProjectBillingRequestItemUUID
ProjBillgElmntEntrItmUUID ProjBillgElmntEntrItmUUID
ProjectBillingRequestUUID ProjectBillingRequestUUID
ProjectBillingElementUUID ProjectBillingElementUUID
SalesDocument SalesDocument
SalesDocumentItem SalesDocumentItem
ProjBillingRequestItemLongText ProjBillingRequestItemLongText
ToBePostponedQuantity ToBePostponedQuantity
ToBePostponedAmtInTransacCrcy ToBePostponedAmtInTransacCrcy
ToBePostponedAmtInProjectCrcy ToBePostponedAmtInProjectCrcy
ToBePostponedAmtInGlobalCrcy ToBePostponedAmtInGlobalCrcy
ToBeWrittenOffQuantity ToBeWrittenOffQuantity
ToBeWrittenOffAmtInTransCrcy ToBeWrittenOffAmtInTransCrcy
ToBeWrittenOffAmtInProjectCrcy ToBeWrittenOffAmtInProjectCrcy
ToBeWrittenOffAmtInGlobalCrcy ToBeWrittenOffAmtInGlobalCrcy
BillableRevenueAmtInDocCrcy BillableRevenueAmtInDocCrcy
ProjBillgReqItmCrtedByUser ProjBillgReqItmCrtedByUser
ProjBillgReqItmCrtedAtDteTme ProjBillgReqItmCrtedAtDteTme
ProjBillgReqItmLastChgdBy ProjBillgReqItmLastChgdBy
ProjBillgReqItmLastChgdDteTme ProjBillgReqItmLastChgdDteTme
ServicesRenderedDate ServicesRenderedDate
ToBeBilledQuantity ToBeBilledQuantity
ToBeBilledAmtInTransCrcy ToBeBilledAmtInTransCrcy
ToBeBilledAmtInProjCurrency ToBeBilledAmtInProjCurrency
ToBeBilledAmtInGlobCurrency ToBeBilledAmtInGlobCurrency
OpenQuantity OpenQuantity
OpenAmountInTransCrcy OpenAmountInTransCrcy
OpenAmountInProjectCurrency OpenAmountInProjectCurrency
OpenAmountInGlobalCurrency OpenAmountInGlobalCurrency
OpenRevenueAmtInDocCrcy OpenRevenueAmtInDocCrcy
NetPriceAmountInDocCrcy NetPriceAmountInDocCrcy
NetPriceQuantity NetPriceQuantity
NetPriceQuantityUnit NetPriceQuantityUnit
Material Material
TransactionCurrency TransactionCurrency
GlobalCurrency GlobalCurrency
ProjectCurrency ProjectCurrency
DocumentCurrency DocumentCurrency
QuantityUnit QuantityUnit
ProjBillgReqItmSourceType ProjBillgReqItmSourceType
ProjectBillingRequestItemDesc ProjectBillingRequestItemDesc
BillingPlanUsageCategory
BillingPlanItemUsage
ManualBillgSelForPrjBlgReqItem ManualBillgSelForPrjBlgReqItem
ProjectBillingCategory ProjectBillingCategory
_PrjBlgReqItemJrnlEntrLink _PrjBlgReqItemJrnlEntrLink
_ProjectBillingRequest ProjectBillingRequestItem _ProjectBillingRequest 
@AccessControl: {
    authorizationCheck:     #MANDATORY,
    personalData.blocking:  #BLOCKED_DATA_EXCLUDED
}
@VDM: {
    viewType: #CONSUMPTION,
    lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@ObjectModel.supportedCapabilities: [#TRANSACTIONAL_PROVIDER]
@ObjectModel: {
    
    usageType: {
      dataClass:       #TRANSACTIONAL,
      serviceQuality:  #C,
      sizeCategory:    #XL
    }
}
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Project Billing Request Item'
@OData.entityType.name:'ProjectBillingRequestItem_Type' 

define view entity A_ProjectBillingRequestItem 
  as projection on R_ProjectBillingRequestItemTP as ProjectBillingRequestItem
  
  association [0..1] to A_PrjBlgReqItemJrnlEntrLink as _PrjBlgReqItemJrnlEntrLink on ProjectBillingRequestItem.ProjBillgElmntEntrItmUUID = _PrjBlgReqItemJrnlEntrLink.ProjBillgElmntEntrItmUUID
{
  key ProjectBillingRequestItemUUID,
  ProjBillgElmntEntrItmUUID,
  ProjectBillingRequestUUID,
  ProjectBillingElementUUID,
  SalesDocument,
  SalesDocumentItem,
  ProjBillingRequestItemLongText,
  @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
  ToBePostponedQuantity,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  ToBePostponedAmtInTransacCrcy,
  @Semantics.amount.currencyCode: 'ProjectCurrency'
  ToBePostponedAmtInProjectCrcy,
  @Semantics.amount.currencyCode: 'GlobalCurrency'
  ToBePostponedAmtInGlobalCrcy,
  @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
  ToBeWrittenOffQuantity,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  ToBeWrittenOffAmtInTransCrcy,
  @Semantics.amount.currencyCode: 'ProjectCurrency'
  ToBeWrittenOffAmtInProjectCrcy,
  @Semantics.amount.currencyCode: 'GlobalCurrency'
  ToBeWrittenOffAmtInGlobalCrcy,
  @Semantics.amount.currencyCode: 'DocumentCurrency'
  BillableRevenueAmtInDocCrcy,
  ProjBillgReqItmCrtedByUser,
  ProjBillgReqItmCrtedAtDteTme,
  ProjBillgReqItmLastChgdBy,
  ProjBillgReqItmLastChgdDteTme,
  ServicesRenderedDate,
  @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
  ToBeBilledQuantity,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  ToBeBilledAmtInTransCrcy,
  @Semantics.amount.currencyCode: 'ProjectCurrency'
  ToBeBilledAmtInProjCurrency,
  @Semantics.amount.currencyCode: 'GlobalCurrency'
  ToBeBilledAmtInGlobCurrency,
  @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
  OpenQuantity,
  @Semantics.amount.currencyCode: 'TransactionCurrency'
  OpenAmountInTransCrcy,
  @Semantics.amount.currencyCode: 'ProjectCurrency'
  OpenAmountInProjectCurrency,
  @Semantics.amount.currencyCode: 'GlobalCurrency'
  OpenAmountInGlobalCurrency,
  @Semantics.amount.currencyCode: 'DocumentCurrency'
  OpenRevenueAmtInDocCrcy,
  @Semantics.amount.currencyCode: 'DocumentCurrency'
  NetPriceAmountInDocCrcy,
  @Semantics.quantity.unitOfMeasure: 'NetPriceQuantityUnit'
  NetPriceQuantity,
  NetPriceQuantityUnit,
  Material,
  TransactionCurrency,
  GlobalCurrency,
  ProjectCurrency,
  DocumentCurrency,
  QuantityUnit,
  @ObjectModel.sapObjectNodeTypeReference: 'ProjBillgReqItmSourceType'
  ProjBillgReqItmSourceType,
  ProjectBillingRequestItemDesc,
  
  _ProjectBillingElementEntryTP._ProjectBillingElement._SalesDocItemBillPlan.BillingPlanUsageCategory,
  
  _ProjectBillingElementEntryTP._PrjBlgElmEntrBillgPlnLnk._SalesDocumentBillingPlanItem.BillingPlanItemUsage,
  
  @ObjectModel.sapObjectNodeTypeReference: 'ManualBillgSelForPrjBlgReqItem'
  ManualBillgSelForPrjBlgReqItem,
  
  @Consumption.hidden: true 
  ProjectBillingCategory,
  
  _PrjBlgReqItemJrnlEntrLink,
  @Consumption.hidden: true 
  ProjectBillingRequestItem._ProjectBillingRequest, 
  
  _ProjectBillingRequestTP   : redirected to parent A_ProjectBillingRequest  
  

}

where ProjectBillingCategory <> 'ICBL'

Learn More