@EndUserText.label: 'Entries for Project Billing Element'
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@Analytics.dataExtraction.enabled: true
@Analytics.dataExtraction.delta.changeDataCapture.mapping: [{
table: 'PROJBLGELMNTENTR',
role: #MAIN,
viewElement: ['ProjBillgElmntEntrItmUUID'],
tableElement: ['projbillgelmntentritmuuid']
}]
@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: 'ProjBillgElmntEntrItmUUID'
}
@Metadata.ignorePropagatedAnnotations: true
define view entity I_ProjectBillingElementEntry
as select from projblgelmntentr as ProjectBillingElementEntry
association [0..1] to I_Material as _Material on $projection.Material = _Material.Material
association [1..1] to I_ProjectBillingElement as _ProjectBillingElement on $projection.ProjectBillingElementUUID = _ProjectBillingElement.ProjectBillingElementUUID
association [0..*] to I_ProjectBillingElementEntrFlw as _ProjectBillingElementEntrFlw on $projection.ProjBillgElmntEntrItmUUID = _ProjectBillingElementEntrFlw.ProjBillgElmntEntrItmUUID
association [0..1] to I_PrjBlgElmEntrJrnlEntrLink as _PrjBlgElmEntrJrnlEntrLink on $projection.ProjBillgElmntEntrItmUUID = _PrjBlgElmEntrJrnlEntrLink.ProjBillgElmntEntrItmUUID
association [0..1] to I_PrjBlgElmEntrBillgPlnLink as _PrjBlgElmEntrBillgPlnLink on $projection.ProjBillgElmntEntrItmUUID = _PrjBlgElmEntrBillgPlnLink.ProjBillgElmntEntrItmUUID
association [0..1] to I_WBSElementBasicData as _WBSElement on $projection.WBSElementInternalID = _WBSElement.WBSElementInternalID
{
key ProjectBillingElementEntry.projbillgelmntentritmuuid as ProjBillgElmntEntrItmUUID,
ProjectBillingElementEntry.projectbillingelementuuid as ProjectBillingElementUUID,
ProjectBillingElementEntry.projbillgelmntentrsourcetype as ProjBillgElmntEntrSourceType,
ProjectBillingElementEntry.wbselementinternalid as WBSElementInternalID,
ProjectBillingElementEntry.material as Material,
ProjectBillingElementEntry.quantityunit as QuantityUnit,
ProjectBillingElementEntry.projbillgelmntentriscancelled as ProjBillgElmntEntrIsCancelled,
ProjectBillingElementEntry.pricingdate as PricingDate,
ProjectBillingElementEntry.netpriceamountismanual as NetPriceAmountIsManual,
ProjectBillingElementEntry.transactioncurrency as TransactionCurrency,
ProjectBillingElementEntry.projectcurrency as ProjectCurrency,
ProjectBillingElementEntry.globalcurrency as GlobalCurrency,
_ProjectBillingElement.DocumentCurrency as DocumentCurrency,
ProjectBillingElementEntry.servicesrendereddate as ServicesRenderedDate,
@Semantics.quantity.unitOfMeasure: 'QuantityUnit'
ProjectBillingElementEntry.originaltotalquantity as OriginalTotalQuantity,
@Semantics.amount.currencyCode: 'TransactionCurrency'
ProjectBillingElementEntry.originalamountintransaccrcy as OriginalAmountInTransacCrcy,
@Semantics.amount.currencyCode: 'ProjectCurrency'
ProjectBillingElementEntry.originalamountinprojectcrcy as OriginalAmountInProjectCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
ProjectBillingElementEntry.originalamountinglobalcurrency as OriginalAmountInGlobalCurrency,
@Semantics.quantity.unitOfMeasure: 'QuantityUnit'
ProjectBillingElementEntry.openquantity as OpenQuantity,
@Semantics.amount.currencyCode: 'TransactionCurrency'
ProjectBillingElementEntry.openamountintranscrcy as OpenAmountInTransCrcy,
@Semantics.amount.currencyCode: 'ProjectCurrency'
ProjectBillingElementEntry.openamountinprojectcurrency as OpenAmountInProjectCurrency,
@Semantics.amount.currencyCode: 'GlobalCurrency'
ProjectBillingElementEntry.openamountinglobalcurrency as OpenAmountInGlobalCurrency,
@Semantics.quantity.unitOfMeasure: 'QuantityUnit'
ProjectBillingElementEntry.tobebilledquantity as ToBeBilledQuantity,
@Semantics.amount.currencyCode: 'TransactionCurrency'
ProjectBillingElementEntry.tobebilledamtintranscrcy as ToBeBilledAmtInTransCrcy,
@Semantics.amount.currencyCode: 'ProjectCurrency'
ProjectBillingElementEntry.tobebilledamtinprojcurrency as ToBeBilledAmtInProjCurrency,
@Semantics.amount.currencyCode: 'GlobalCurrency'
ProjectBillingElementEntry.tobebilledamtinglobcurrency as ToBeBilledAmtInGlobCurrency,
@Semantics.quantity.unitOfMeasure: 'QuantityUnit'
ProjectBillingElementEntry.tobewrittenoffquantity as ToBeWrittenOffQuantity,
@Semantics.amount.currencyCode: 'TransactionCurrency'
ProjectBillingElementEntry.tobewrittenoffamtintranscrcy as ToBeWrittenOffAmtInTransCrcy,
@Semantics.amount.currencyCode: 'ProjectCurrency'
ProjectBillingElementEntry.tobewrittenoffamtinprojectcrcy as ToBeWrittenOffAmtInProjectCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
ProjectBillingElementEntry.tobewrittenoffamtinglobalcrcy as ToBeWrittenOffAmtInGlobalCrcy,
@Semantics.quantity.unitOfMeasure: 'QuantityUnit'
ProjectBillingElementEntry.tobepostponedquantity as ToBePostponedQuantity,
@Semantics.amount.currencyCode: 'TransactionCurrency'
ProjectBillingElementEntry.tobepostponedamtintransaccrcy as ToBePostponedAmtInTransacCrcy,
@Semantics.amount.currencyCode: 'ProjectCurrency'
ProjectBillingElementEntry.tobepostponedamtinprojectcrcy as ToBePostponedAmtInProjectCrcy,
@Semantics.amount.currencyCode: 'GlobalCurrency'
ProjectBillingElementEntry.tobepostponedamtinglobalcrcy as ToBePostponedAmtInGlobalCrcy,
@Semantics.amount.currencyCode: 'DocumentCurrency'
ProjectBillingElementEntry.billablerevenueamtindoccrcy as BillableRevenueAmtInDocCrcy,
@Semantics.amount.currencyCode: 'DocumentCurrency'
ProjectBillingElementEntry.manualnetpriceamtindoccrcy as ManualNetPriceAmtInDocCrcy,
@Semantics.amount.currencyCode: 'DocumentCurrency'
ProjectBillingElementEntry.netpriceamountindoccrcy as NetPriceAmountInDocCrcy,
@Semantics.quantity.unitOfMeasure: 'NetPriceQuantityUnit'
ProjectBillingElementEntry.netpricequantity as NetPriceQuantity,
ProjectBillingElementEntry.netpricequantityunit as NetPriceQuantityUnit,
@Semantics.amount.currencyCode: 'DocumentCurrency'
ProjectBillingElementEntry.originalrevenueamtindoccrcy as OriginalRevenueAmtInDocCrcy,
@Semantics.amount.currencyCode: 'DocumentCurrency'
ProjectBillingElementEntry.openrevenueamtindoccrcy as OpenRevenueAmtInDocCrcy,
ProjectBillingElementEntry.projbillgelmntentrisreversed as ProjBillgElmntEntrIsReversed,
ProjectBillingElementEntry.projbillgelmntentrisreversal as ProjBillgElmntEntrIsReversal,
ProjectBillingElementEntry.prjblgelmentrcanclnsrcecode as PrjBlgElmEntrCanclnSrceCode,
@Semantics.user.createdBy: true
ProjectBillingElementEntry.prjblgelmentrcreatedbyuser as PrjBlgElmEntrCreatedByUser,
@Semantics.systemDateTime.createdAt: true
ProjectBillingElementEntry.prjblgelmentrcreatedatdtetme as PrjBlgElmEntrCreatedAtDteTme,
@Semantics.user.lastChangedBy: true
ProjectBillingElementEntry.prjblgelmentrlastchgdbyuser as PrjBlgElmEntrLastChgdByUser,
@Semantics.systemDateTime.lastChangedAt: true
ProjectBillingElementEntry.prjblgelmentrlastchgdatdtetme as PrjBlgElmEntrLastChgdAtDteTme,
ProjectBillingElementEntry.prjblgelmentrylongtext as PrjBlgElmEntryLongText,
ProjectBillingElementEntry.projectbillingelemententrydesc as ProjectBillingElementEntryDesc,
ProjectBillingElementEntry.projbillgtransfcostqtycode as ProjBillgTransfCostQtyCode,
ProjectBillingElementEntry.projbillgitmvalisnotactualcost as ProjBillgItmValIsNotActualCost,
ProjectBillingElementEntry.projbillgelemententryobject as ProjBillgElementEntryObject,
ProjectBillingElementEntry.postingdate as PostingDate,
_ProjectBillingElement,
_ProjectBillingElementEntrFlw,
_PrjBlgElmEntrJrnlEntrLink,
_PrjBlgElmEntrBillgPlnLink,
_Material,
_WBSElement
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECTBILLINGELEMENT",
"PROJBLGELMNTENTR"
],
"ASSOCIATED":
[
"I_MATERIAL",
"I_PRJBLGELMENTRBILLGPLNLINK",
"I_PRJBLGELMENTRJRNLENTRLINK",
"I_PROJECTBILLINGELEMENT",
"I_PROJECTBILLINGELEMENTENTRFLW",
"I_WBSELEMENTBASICDATA"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/