I_PROJECTBILLINGREQUESTITEM
Items for Project Billing Request
I_PROJECTBILLINGREQUESTITEM is a CDS View in S/4HANA. Items for Project Billing Request. It contains 57 fields. 10 CDS views read from this table.
CDS Views using this table (10)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_ProjBillingReqDetsForWrkflw | view_entity | from | CONSUMPTION | Aggregation for PBRI details |
| I_ProjectBillingRequestItemTP | view_entity | from | TRANSACTIONAL | Item Details of Project Billing Request |
| P_PrjBlgElmBillingReqRevnAmt | view_entity | from | COMPOSITE | Billing Requested Amt for Billing Elmnt |
| P_PrjBlgElmBillingReqRevnAmt | view_entity | union_all | COMPOSITE | Billing Requested Amt for Billing Elmnt |
| P_PrjBlgElmntEntrMnlSeldToBill | view_entity | inner | COMPOSITE | PrjBlgElmntEntr manually sel. for Billg |
| P_ProjBillgReqDetails | view_entity | inner | TRANSACTIONAL | P view for Proj Billing Request details |
| P_ProjBillgRequestItemDueDate | view_entity | from | COMPOSITE | Project Billing Request Item Billing Date |
| P_ProjBillgRequestItemWithErr | view_entity | from | CONSUMPTION | P-View for excluded posting item |
| P_ProjBillingInProcessDetails | view_entity | inner | TRANSACTIONAL | P view for Billing in Process details |
| R_ProjectBillingRequestItemTP | view_entity | from | TRANSACTIONAL | Project Billing Request Item TP |
Fields (57)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | ProjBillgElmntEntrItmUUID | ProjBillgElmntEntrItmUUID | 4 |
| KEY | ProjectBillingRequestItemUUID | ProjectBillingRequestItemUUID | 4 |
| KEY | ProjectBillingRequestUUID | ProjectBillingRequestUUID | 4 |
| _DocumentCurrency | _DocumentCurrency | 1 | |
| _DocumentCurrencyText | _DocumentCurrencyText | 1 | |
| _GlobalCurrency | _GlobalCurrency | 1 | |
| _GlobalCurrencyText | _GlobalCurrencyText | 1 | |
| _Material | _Material | 1 | |
| _ProjBillgReqItmSrceType | _ProjBillgReqItmSrceType | 1 | |
| _ProjBillgReqItmSrceTypeText | _ProjBillgReqItmSrceTypeText | 1 | |
| _ProjectBillingRequest | _ProjectBillingRequest | 3 | |
| _ProjectCurrency | _ProjectCurrency | 1 | |
| _ProjectCurrencyText | _ProjectCurrencyText | 1 | |
| _TransactionCurrency | _TransactionCurrency | 1 | |
| _TransactionCurrencyText | _TransactionCurrencyText | 1 | |
| BillableRevenueAmtInDocCrcy | BillableRevenueAmtInDocCrcy | 3 | |
| BillingPlan | BillingPlan | 1 | |
| BillingPlanItem | BillingPlanItem | 1 | |
| DocumentCurrency | DocumentCurrency | 7 | |
| GlobalCurrency | GlobalCurrency | 4 | |
| ManualBillgSelForPrjBlgReqItem | ManualBillgSelForPrjBlgReqItem | 3 | |
| Material | Material | 3 | |
| NetPriceAmountInDocCrcy | NetPriceAmountInDocCrcy | 3 | |
| NetPriceQuantity | NetPriceQuantity | 1 | |
| NetPriceQuantityUnit | NetPriceQuantityUnit | 1 | |
| OpenAmountInGlobalCurrency | OpenAmountInGlobalCurrency | 2 | |
| OpenAmountInProjectCurrency | OpenAmountInProjectCurrency | 2 | |
| OpenAmountInTransCrcy | OpenAmountInTransCrcy | 3 | |
| OpenQuantity | OpenQuantity | 3 | |
| OpenRevenueAmtInDocCrcy | OpenRevenueAmtInDocCrcy | 2 | |
| ProjBillgItmValIsNotActualCost | ProjBillgItmValIsNotActualCost | 2 | |
| ProjBillgReqItmCrtedAtDteTme | ProjBillgReqItmCrtedAtDteTme | 2 | |
| ProjBillgReqItmCrtedByUser | ProjBillgReqItmCrtedByUser | 2 | |
| ProjBillgReqItmLastChgdBy | ProjBillgReqItmLastChgdBy | 2 | |
| ProjBillgReqItmLastChgdDteTme | ProjBillgReqItmLastChgdDteTme | 2 | |
| ProjBillgReqItmSourceType | ProjBillgReqItmSourceType | 1 | |
| ProjBillgTransfCostQtyCode | ProjBillgTransfCostQtyCode | 2 | |
| ProjBillingRequestItemLongText | ProjBillingRequestItemLongText | 2 | |
| ProjectBillingElementUUID | ProjectBillingElementUUID | 4 | |
| ProjectBillingRequestItemDesc | ProjectBillingRequestItemDesc | 1 | |
| ProjectCurrency | ProjectCurrency | 4 | |
| QuantityUnit | QuantityUnit | 3 | |
| SalesDocumentItem | SalesDocumentItem | 2 | |
| ServicesRenderedDate | ServicesRenderedDate | 2 | |
| ToBeBilledAmtInGlobCurrency | ToBeBilledAmtInGlobCurrency | 2 | |
| ToBeBilledAmtInProjCurrency | ToBeBilledAmtInProjCurrency | 2 | |
| ToBeBilledAmtInTransCrcy | ToBeBilledAmtInTransCrcy | 3 | |
| ToBeBilledQuantity | ToBeBilledQuantity | 3 | |
| ToBePostponedAmtInGlobalCrcy | ToBePostponedAmtInGlobalCrcy | 2 | |
| ToBePostponedAmtInProjectCrcy | ToBePostponedAmtInProjectCrcy | 2 | |
| ToBePostponedAmtInTransacCrcy | ToBePostponedAmtInTransacCrcy | 2 | |
| ToBePostponedQuantity | ToBePostponedQuantity | 2 | |
| ToBeWrittenOffAmtInGlobalCrcy | ToBeWrittenOffAmtInGlobalCrcy | 2 | |
| ToBeWrittenOffAmtInProjectCrcy | ToBeWrittenOffAmtInProjectCrcy | 2 | |
| ToBeWrittenOffAmtInTransCrcy | ToBeWrittenOffAmtInTransCrcy | 2 | |
| ToBeWrittenOffQuantity | ToBeWrittenOffQuantity | 2 | |
| TransactionCurrency | TransactionCurrency | 2 |
@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,#UI_PROVIDER_PROJECTION_SOURCE],
usageType:{
sizeCategory: #XL,
dataClass: #TRANSACTIONAL,
serviceQuality: #B
},
representativeKey: 'ProjectBillingRequestItemUUID'
}
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.sapObjectNodeType.name: 'ProjectBillingRequestItem'
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_ProjBillgTransfCostQtyCode as _ProjBillgTransfCostQtyCode on $projection.ProjBillgTransfCostQtyCode = _ProjBillgTransfCostQtyCode.ProjBillgTransfCostQtyCode
association [1..*] to I_PrjBillgTransfCostQtyCodeTxt as _PrjBillgTransfCostQtyCodeTxt on $projection.ProjBillgTransfCostQtyCode = _PrjBillgTransfCostQtyCodeTxt.ProjBillgTransfCostQtyCode
association [1..1] to I_Currency as _TransactionCurrency on $projection.TransactionCurrency = _TransactionCurrency.Currency
association [1..*] to I_CurrencyText as _TransactionCurrencyText on $projection.TransactionCurrency = _TransactionCurrencyText.Currency
association [1..1] to I_Currency as _ProjectCurrency on $projection.ProjectCurrency = _ProjectCurrency.Currency
association [1..*] to I_CurrencyText as _ProjectCurrencyText on $projection.ProjectCurrency = _ProjectCurrencyText.Currency
association [1..1] to I_Currency as _GlobalCurrency on $projection.GlobalCurrency = _GlobalCurrency.Currency
association [1..*] to I_CurrencyText as _GlobalCurrencyText on $projection.GlobalCurrency = _GlobalCurrencyText.Currency
association [1..1] to I_Currency as _DocumentCurrency on $projection.DocumentCurrency = _DocumentCurrency.Currency
association [1..*] to I_CurrencyText as _DocumentCurrencyText on $projection.DocumentCurrency = _DocumentCurrencyText.Currency
association [0..1] to I_UnitOfMeasure as _QuantityUnit on $projection.QuantityUnit = _QuantityUnit.UnitOfMeasure
association [0..1] to I_ProjBillgReqItmSrceType as _ProjBillgReqItmSrceType on $projection.ProjBillgReqItmSourceType = _ProjBillgReqItmSrceType.ProjBillgReqItmSourceType
association [1..*] to I_ProjBillgReqItmSrceTypeText as _ProjBillgReqItmSrceTypeText on $projection.ProjBillgReqItmSourceType = _ProjBillgReqItmSrceTypeText.ProjBillgReqItmSourceType
// 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,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_ProjBillgReqItmSrceType',
element: 'ProjBillgReqItmSourceType' }
}]
@ObjectModel.foreignKey.association: '_ProjBillgReqItmSrceType'
projbillgreqitmsourcetype as ProjBillgReqItmSourceType,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_ProjBillgTransfCostQtyCode',
element: 'ProjBillgTransfCostQtyCode' }
}]
@ObjectModel.foreignKey.association: '_ProjBillgTransfCostQtyCode'
projbillgtransfcostqtycode as ProjBillgTransfCostQtyCode,
@Semantics.booleanIndicator: true
projbillgitmvalisnotactualcost as ProjBillgItmValIsNotActualCost,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_CurrencyStdVH',
element: 'Currency' }
}]
@ObjectModel.foreignKey.association: '_TransactionCurrency'
//_ProjectBillingElementEntry.TransactionCurrency as TransactionCurrency,
transactioncurrency as TransactionCurrency,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_CurrencyStdVH',
element: 'Currency' }
}]
@ObjectModel.foreignKey.association: '_GlobalCurrency'
//_ProjectBillingElementEntry.GlobalCurrency as GlobalCurrency,
globalcurrency as GlobalCurrency,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_CurrencyStdVH',
element: 'Currency' }
}]
@ObjectModel.foreignKey.association: '_ProjectCurrency'
//_ProjectBillingElementEntry.ProjectCurrency as ProjectCurrency,
projectcurrency as ProjectCurrency,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_CurrencyStdVH',
element: 'Currency' }
}]
@ObjectModel.foreignKey.association: '_DocumentCurrency'
//_ProjectBillingElementEntry.DocumentCurrency as DocumentCurrency,
documentcurrency as DocumentCurrency,
@Consumption.valueHelpDefinition: [
{ entity: { name: 'I_UnitOfMeasureStdVH',
element: 'UnitOfMeasure' }
}]
@ObjectModel.foreignKey.association: '_QuantityUnit'
//_ProjectBillingElementEntry.QuantityUnit as QuantityUnit,
quantityunit as QuantityUnit,
_ProjectBillingRequest,
_ProjBillingDueDate,
_Material,
_ProjBillgReqItmMnlBillgSel,
_ProjBillgReqItmSrceType,
_QuantityUnit,
_TransactionCurrency,
_DocumentCurrency,
_GlobalCurrency,
_ProjectCurrency,
_ProjBillgTransfCostQtyCode,
@Consumption.hidden: true
_TransactionCurrencyText,
@Consumption.hidden: true
_ProjectCurrencyText,
@Consumption.hidden: true
_GlobalCurrencyText,
@Consumption.hidden: true
_DocumentCurrencyText,
@Consumption.hidden: true
_ProjBillgReqItmSrceTypeText,
@Consumption.hidden: true
_PrjBillgTransfCostQtyCodeTxt
// _SDBillingPlanItem,
// _SDBillingPlan
}