C_ProjectBillingElementEntryTP

DDL: C_PROJECTBILLINGELEMENTENTRYTP Type: view_entity CONSUMPTION
46 Fields 1 Data Sources 1 OData Services

Entry Details of Billing Element

C_ProjectBillingElementEntryTP is a Consumption CDS View that provides data about "Entry Details of Billing Element" in SAP S/4HANA. It reads from 1 data source (R_ProjectBillingElementEntryTP) and exposes 46 fields with key field ProjBillgElmntEntrItmUUID. It is exposed through 1 OData service (PROJECTBILLINGELEMENT_SD).

Data Sources (1)

SourceAliasJoin Type
R_ProjectBillingElementEntryTP R_ProjectBillingElementEntryTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Entry Details of Billing Element view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey ProjBillgElmntEntrItmUUID view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
Consumption.semanticObject CustomerProject view

OData Services (1)

ServiceBindingVersionContractRelease
PROJECTBILLINGELEMENT_SD UI_PROJBILLGELMNT_SB_V2 V2 C1 NOT_RELEASED

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY ProjBillgElmntEntrItmUUID ProjBillgElmntEntrItmUUID PBE Entry UUID
ProjectBillingElementUUID ProjectBillingElementUUID PBE UUID
ProjBillgElmntEntrSourceType ProjBillgElmntEntrSourceType PBE Entry SourceType
WBSElementInternalID WBSElementInternalID Billing Element
PrjBlgElmEntrCreatedByUser PrjBlgElmEntrCreatedByUser Performed By
Material Material Vehicle Model
QuantityUnit QuantityUnit Unit of measure
ProjBillgElmntEntrIsCancelled ProjBillgElmntEntrIsCancelled PBE Entry Cancelled
PricingDate PricingDate Pricing Date
NetPriceAmountIsManual NetPriceAmountIsManual Net Price Manual
ServicesRenderedDate ServicesRenderedDate Service Date
TransactionCurrency TransactionCurrency Transaction Currency
ProjectCurrency ProjectCurrency Project Currency
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
DocumentCurrency DocumentCurrency Document Currency
OriginalTotalQuantity OriginalTotalQuantity Original Quantity
OriginalAmountInTransacCrcy OriginalAmountInTransacCrcy Origl Amt Trans Crcy
OriginalAmountInProjectCrcy OriginalAmountInProjectCrcy Origl Amt Proj Crcy
OriginalRevenueAmtInDocCrcy OriginalRevenueAmtInDocCrcy Original Revenue
OriginalAmountInGlobalCurrency OriginalAmountInGlobalCurrency Original Cost
OpenQuantity OpenQuantity PBE Entry Open Qty
OpenAmountInTransCrcy OpenAmountInTransCrcy Open Amt Trans Crcy
OpenAmountInProjectCurrency OpenAmountInProjectCurrency Open Amt Proj Crcy
OpenAmountInGlobalCurrency OpenAmountInGlobalCurrency Open Amt Glob Crcy
OpenRevenueAmtInDocCrcy OpenRevenueAmtInDocCrcy Open Revenue
ToBeWrittenOffQuantity ToBeWrittenOffQuantity Quantity to be Written Off
ToBeWrittenOffAmtInTransCrcy ToBeWrittenOffAmtInTransCrcy Amt ToWrtOff TrCrcy
ToBeWrittenOffAmtInProjectCrcy ToBeWrittenOffAmtInProjectCrcy Amt ToWrtOff PrCrcy
ToBeWrittenOffAmtInGlobalCrcy ToBeWrittenOffAmtInGlobalCrcy Cost to be Written Off
ToBePostponedQuantity ToBePostponedQuantity Quantity to Be Postponed
ToBePostponedAmtInTransacCrcy ToBePostponedAmtInTransacCrcy Amt ToPostpn TrCrcy
ToBePostponedAmtInProjectCrcy ToBePostponedAmtInProjectCrcy Amt ToPostpn PrCrcy
ToBePostponedAmtInGlobalCrcy ToBePostponedAmtInGlobalCrcy Cost to be Postponed
BillableRevenueAmtInDocCrcy BillableRevenueAmtInDocCrcy Billable Revenue
ManualNetPriceAmtInDocCrcy ManualNetPriceAmtInDocCrcy Net Price
NetPriceAmountInDocCrcy NetPriceAmountInDocCrcy Net Price
PrjBlgElmEntrCreatedAtDteTme PrjBlgElmEntrCreatedAtDteTme PBE Entry Created On
PrjBlgElmEntrLastChgdByUser PrjBlgElmEntrLastChgdByUser PBE Entry Changed By
PrjBlgElmEntrLastChgdAtDteTme PrjBlgElmEntrLastChgdAtDteTme PBE Entry Changed On
ToBeBilledAmtInGlobCurrency ToBeBilledAmtInGlobCurrency Cost to be Billed
ToBeBilledQuantity ToBeBilledQuantity Quantity to be Billed
ProjectBillingElementEntryDesc ProjectBillingElementEntryDesc Item Description
ProjBillgElementEntryObject ProjBillgElementEntryObject PBEE Object Number
_WBSElement _WBSElement
BillingWBSElementInternalID BillingWBSElementInternalID WBS Internal ID
PrjBlgElmEntryLongText PrjBlgElmEntryLongText long text

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ProjectBillingElementEntryTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_ProjectBillingElementEntryTP AS
SELECT
  ProjBillgElmntEntrItmUUID,
  ProjectBillingElementUUID,
  ProjBillgElmntEntrSourceType,
  WBSElementInternalID,
  PrjBlgElmEntrCreatedByUser,
  Material,
  QuantityUnit,
  ProjBillgElmntEntrIsCancelled,
  PricingDate,
  NetPriceAmountIsManual,
  ServicesRenderedDate,
  TransactionCurrency,
  ProjectCurrency,
  GlobalCurrency,
  DocumentCurrency,
  OriginalTotalQuantity,
  OriginalAmountInTransacCrcy,
  OriginalAmountInProjectCrcy,
  OriginalRevenueAmtInDocCrcy,
  OriginalAmountInGlobalCurrency,
  OpenQuantity,
  OpenAmountInTransCrcy,
  OpenAmountInProjectCurrency,
  OpenAmountInGlobalCurrency,
  OpenRevenueAmtInDocCrcy,
  ToBeWrittenOffQuantity,
  ToBeWrittenOffAmtInTransCrcy,
  ToBeWrittenOffAmtInProjectCrcy,
  ToBeWrittenOffAmtInGlobalCrcy,
  ToBePostponedQuantity,
  ToBePostponedAmtInTransacCrcy,
  ToBePostponedAmtInProjectCrcy,
  ToBePostponedAmtInGlobalCrcy,
  BillableRevenueAmtInDocCrcy,
  ManualNetPriceAmtInDocCrcy,
  NetPriceAmountInDocCrcy,
  PrjBlgElmEntrCreatedAtDteTme,
  PrjBlgElmEntrLastChgdByUser,
  PrjBlgElmEntrLastChgdAtDteTme,
  ToBeBilledAmtInGlobCurrency,
  ToBeBilledQuantity,
  ProjectBillingElementEntryDesc,
  ProjBillgElementEntryObject,
  BillingWBSElementInternalID,
  PrjBlgElmEntryLongText
FROM R_ProjectBillingElementEntryTP
;

Learn More