I_ProjectBillingRequestItem

DDL: I_PROJECTBILLINGREQUESTITEM Type: view_entity BASIC

Items for Project Billing Request

I_ProjectBillingRequestItem is a Basic CDS View that provides data about "Items for Project Billing Request" in SAP S/4HANA. It reads from 1 data source (projbillgreqitem) and exposes 55 fields with key field ProjectBillingRequestItemUUID. It has 11 associations to related views.

1 data source(s) 55 fields

Data Sources (1)

SourceAliasJoin Type
projbillgreqitem projbillgreqitem from

Associations (11)

CardinalityTargetAliasCondition
[1..1] I_ProjectBillingRequest _ProjectBillingRequest $projection.ProjectBillingRequestUUID = _ProjectBillingRequest.ProjectBillingRequestUUID
[0..1] I_ProjectBillingElementEntry _ProjectBillingElementEntry $projection.ProjBillgElmntEntrItmUUID = _ProjectBillingElementEntry.ProjBillgElmntEntrItmUUID
[0..1] I_ProjectBillingElmntDueDate _ProjBillingDueDate $projection.ProjectBillingElementUUID = _ProjBillingDueDate.ProjectBillingElementUUID
[0..1] I_Material _Material $projection.Material = _Material.Material
[0..1] I_ProjBillgReqItmMnlBillgSel _ProjBillgReqItmMnlBillgSel $projection.ManualBillgSelForPrjBlgReqItem = _ProjBillgReqItmMnlBillgSel.ManualBillgSelForPrjBlgReqItem
[0..1] I_ProjBillgReqItmSrceType _ProjBillgReqItmSrceType $projection.ProjBillgReqItmSourceType = _ProjBillgReqItmSrceType.ProjBillgReqItmSourceType
[0..1] I_UnitOfMeasure _QuantityUnit $projection.QuantityUnit = _QuantityUnit.UnitOfMeasure
[0..1] I_Currency _TransactionCurrency $projection.TransactionCurrency = _TransactionCurrency.Currency
[0..1] I_Currency _ProjectCurrency $projection.ProjectCurrency = _ProjectCurrency.Currency
[0..1] I_Currency _GlobalCurrency $projection.GlobalCurrency = _GlobalCurrency.Currency
[0..1] I_Currency _DocumentCurrency $projection.DocumentCurrency = _DocumentCurrency.Currency

Annotations (11)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Items for Project Billing Request view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #MANDATORY view
Analytics.dataExtraction.enabled true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey ProjectBillingRequestItemUUID view
Metadata.ignorePropagatedAnnotations true view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingRequestItemUUID projectbillingrequestitemuuid
ProjectBillingRequestUUID projectbillingrequestuuid
ProjBillgElmntEntrItmUUID projbillgelmntentritmuuid
ProjectBillingElementUUID projectbillingelementuuid
SalesDocumentItem salesdocumentitem
BillingPlan billingplan
BillingPlanItem billingplanitem
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
ManualBillgSelForPrjBlgReqItem manualbillgselforprjblgreqitem
ProjBillingRequestItemLongText projbillingrequestitemlongtext
ProjectBillingRequestItemDesc projectbillingrequestitemdesc
ProjBillgReqItmSourceType projbillgreqitmsourcetype
ProjBillgTransfCostQtyCode projbillgtransfcostqtycode
ProjBillgItmValIsNotActualCost projbillgitmvalisnotactualcost
TransactionCurrency _ProjectBillingElementEntry TransactionCurrency
GlobalCurrency _ProjectBillingElementEntry GlobalCurrency
ProjectCurrency _ProjectBillingElementEntry ProjectCurrency
DocumentCurrency _ProjectBillingElementEntry DocumentCurrency
QuantityUnit _ProjectBillingElementEntry QuantityUnit
_ProjectBillingRequest _ProjectBillingRequest
_ProjBillingDueDate _ProjBillingDueDate
_Material _Material
_ProjBillgReqItmMnlBillgSel _ProjBillgReqItmMnlBillgSel
_ProjBillgReqItmSrceType _ProjBillgReqItmSrceType
_QuantityUnit _QuantityUnit
_TransactionCurrency _TransactionCurrency
_DocumentCurrency _DocumentCurrency
_GlobalCurrency _GlobalCurrency
_ProjectCurrency _ProjectCurrency 
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@EndUserText.label: 'Items for Project Billing Request'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #MANDATORY
@Analytics.dataExtraction.enabled: true
@Analytics.dataExtraction.delta.changeDataCapture.mapping: [{
                                                        table: 'PROJBILLGREQITEM',
                                                        role: #MAIN,
                                                        viewElement: ['ProjectBillingRequestItemUUID'],
                                                        tableElement: ['projectbillingrequestitemuuid']
}]
@ObjectModel: {
    modelingPattern: #ANALYTICAL_DIMENSION,
    supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET, #ANALYTICAL_DIMENSION, #EXTRACTION_DATA_SOURCE ],
    usageType:{
       sizeCategory: #XL,
       dataClass:  #TRANSACTIONAL,
       serviceQuality: #B
    },
    representativeKey: 'ProjectBillingRequestItemUUID'
}
@Metadata.ignorePropagatedAnnotations: true

define view entity I_ProjectBillingRequestItem
  as select from projbillgreqitem
  association [1..1] to I_ProjectBillingRequest       as _ProjectBillingRequest       on  $projection.ProjectBillingRequestUUID = _ProjectBillingRequest.ProjectBillingRequestUUID
  association [0..1] to I_ProjectBillingElementEntry  as _ProjectBillingElementEntry  on  $projection.ProjBillgElmntEntrItmUUID = _ProjectBillingElementEntry.ProjBillgElmntEntrItmUUID
  association [0..1] to I_ProjectBillingElmntDueDate  as _ProjBillingDueDate          on  $projection.ProjectBillingElementUUID = _ProjBillingDueDate.ProjectBillingElementUUID
  association [0..1] to I_Material                    as _Material                    on  $projection.Material = _Material.Material
  association [0..1] to I_ProjBillgReqItmMnlBillgSel  as _ProjBillgReqItmMnlBillgSel  on  $projection.ManualBillgSelForPrjBlgReqItem = _ProjBillgReqItmMnlBillgSel.ManualBillgSelForPrjBlgReqItem
  association [0..1] to I_ProjBillgReqItmSrceType     as _ProjBillgReqItmSrceType     on  $projection.ProjBillgReqItmSourceType = _ProjBillgReqItmSrceType.ProjBillgReqItmSourceType

  association [0..1] to I_UnitOfMeasure               as _QuantityUnit                on  $projection.QuantityUnit = _QuantityUnit.UnitOfMeasure
  association [0..1] to I_Currency                    as _TransactionCurrency         on  $projection.TransactionCurrency = _TransactionCurrency.Currency
  association [0..1] to I_Currency                    as _ProjectCurrency             on  $projection.ProjectCurrency = _ProjectCurrency.Currency
  association [0..1] to I_Currency                    as _GlobalCurrency              on  $projection.GlobalCurrency = _GlobalCurrency.Currency
  association [0..1] to I_Currency                    as _DocumentCurrency            on  $projection.DocumentCurrency = _DocumentCurrency.Currency

//  association [0..1] to I_SDBillingPlan               as _SDBillingPlan               on  $projection.BillingPlan = _SDBillingPlan.BillingPlan

//  association [0..1] to I_SDBillingPlanItem           as _SDBillingPlanItem           on  $projection.BillingPlan     = _SDBillingPlanItem.BillingPlan

//                                                                                      and $projection.BillingPlanItem = _SDBillingPlanItem.BillingPlanItem

                                                                                      
{
  key projectbillingrequestitemuuid                   as ProjectBillingRequestItemUUID,
      projectbillingrequestuuid                       as ProjectBillingRequestUUID,
      projbillgelmntentritmuuid                       as ProjBillgElmntEntrItmUUID,
      projectbillingelementuuid                       as ProjectBillingElementUUID,
      salesdocumentitem                               as SalesDocumentItem,
//      @ObjectModel.foreignKey.association: '_SDBillingPlan'

      billingplan                                     as BillingPlan,
//      @ObjectModel.foreignKey.association: '_SDBillingPlanItem'

      billingplanitem                                 as BillingPlanItem,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      tobepostponedquantity                           as ToBePostponedQuantity,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      tobepostponedamtintransaccrcy                   as ToBePostponedAmtInTransacCrcy,
      @Semantics.amount.currencyCode: 'ProjectCurrency'
      tobepostponedamtinprojectcrcy                   as ToBePostponedAmtInProjectCrcy,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      tobepostponedamtinglobalcrcy                    as ToBePostponedAmtInGlobalCrcy,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      tobewrittenoffquantity                          as ToBeWrittenOffQuantity,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      tobewrittenoffamtintranscrcy                    as ToBeWrittenOffAmtInTransCrcy,
      @Semantics.amount.currencyCode: 'ProjectCurrency'
      tobewrittenoffamtinprojectcrcy                  as ToBeWrittenOffAmtInProjectCrcy,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      tobewrittenoffamtinglobalcrcy                   as ToBeWrittenOffAmtInGlobalCrcy,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      billablerevenueamtindoccrcy                     as BillableRevenueAmtInDocCrcy,
      @Semantics.user.createdBy: true
      projbillgreqitmcrtedbyuser                      as ProjBillgReqItmCrtedByUser,
      @Semantics.systemDateTime.createdAt: true
      projbillgreqitmcrtedatdtetme                    as ProjBillgReqItmCrtedAtDteTme,
      @Semantics.user.lastChangedBy: true
      projbillgreqitmlastchgdby                       as ProjBillgReqItmLastChgdBy,
      @Semantics.systemDateTime.lastChangedAt: true
      projbillgreqitmlastchgddtetme                   as ProjBillgReqItmLastChgdDteTme,
      servicesrendereddate                            as ServicesRenderedDate,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      tobebilledquantity                              as ToBeBilledQuantity,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      tobebilledamtintranscrcy                        as ToBeBilledAmtInTransCrcy,
      @Semantics.amount.currencyCode: 'ProjectCurrency'
      tobebilledamtinprojcurrency                     as ToBeBilledAmtInProjCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      tobebilledamtinglobcurrency                     as ToBeBilledAmtInGlobCurrency,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      openquantity                                    as OpenQuantity,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      openamountintranscrcy                           as OpenAmountInTransCrcy,
      @Semantics.amount.currencyCode: 'ProjectCurrency'
      openamountinprojectcurrency                     as OpenAmountInProjectCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      openamountinglobalcurrency                      as OpenAmountInGlobalCurrency,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      openrevenueamtindoccrcy                         as OpenRevenueAmtInDocCrcy,
      @Semantics.amount.currencyCode: 'DocumentCurrency'
      netpriceamountindoccrcy                         as NetPriceAmountInDocCrcy,
      @Semantics.quantity.unitOfMeasure: 'NetPriceQuantityUnit'
      netpricequantity                                as NetPriceQuantity,
      netpricequantityunit                            as NetPriceQuantityUnit,
      @ObjectModel.foreignKey.association: '_Material'
      material                                        as Material,
      @ObjectModel.foreignKey.association: '_ProjBillgReqItmMnlBillgSel'
      manualbillgselforprjblgreqitem                  as ManualBillgSelForPrjBlgReqItem,
      @Semantics.text: true
      projbillingrequestitemlongtext                  as ProjBillingRequestItemLongText,
      @Semantics.text: true
      projectbillingrequestitemdesc                   as ProjectBillingRequestItemDesc,
      @ObjectModel.foreignKey.association: '_ProjBillgReqItmSrceType'
      projbillgreqitmsourcetype                       as ProjBillgReqItmSourceType,
      projbillgtransfcostqtycode                      as ProjBillgTransfCostQtyCode,
      @Semantics.booleanIndicator: true
      projbillgitmvalisnotactualcost                  as ProjBillgItmValIsNotActualCost,
      @ObjectModel.foreignKey.association: '_TransactionCurrency'
      _ProjectBillingElementEntry.TransactionCurrency as TransactionCurrency,
      @ObjectModel.foreignKey.association: '_GlobalCurrency'
      _ProjectBillingElementEntry.GlobalCurrency      as GlobalCurrency,
      @ObjectModel.foreignKey.association: '_ProjectCurrency'
      _ProjectBillingElementEntry.ProjectCurrency     as ProjectCurrency,
      @ObjectModel.foreignKey.association: '_DocumentCurrency'
      _ProjectBillingElementEntry.DocumentCurrency    as DocumentCurrency,
      @ObjectModel.foreignKey.association: '_QuantityUnit'
      _ProjectBillingElementEntry.QuantityUnit        as QuantityUnit,

      _ProjectBillingRequest,
      _ProjBillingDueDate,
      _Material,
      _ProjBillgReqItmMnlBillgSel,
      _ProjBillgReqItmSrceType,
      _QuantityUnit,
      _TransactionCurrency,
      _DocumentCurrency,
      _GlobalCurrency,
      _ProjectCurrency

//      _SDBillingPlanItem,

//      _SDBillingPlan

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECTBILLINGELEMENTENTRY",
"PROJBILLGREQITEM"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_MATERIAL",
"I_PROJBILLGREQITMMNLBILLGSEL",
"I_PROJBILLGREQITMSRCETYPE",
"I_PROJECTBILLINGELMNTDUEDATE",
"I_PROJECTBILLINGREQUEST",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More