C_ProjectBillingRequestItem_AI

DDL: C_PROJECTBILLINGREQUESTITEM_AI Type: view_entity CONSUMPTION Package: VDM_PROJECTBILLINGREQITEM
17 Fields 1 Associations 1 OData Services

Project Billing Request Items for AI

C_ProjectBillingRequestItem_AI is a Consumption CDS View that provides data about "Project Billing Request Items for AI" in SAP S/4HANA. It has 1 association to related views. It is exposed through 1 OData service (PROJECTBILLINGREQUEST_SD). Part of development package VDM_PROJECTBILLINGREQITEM.

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_MaterialText _Text $projection.Material = _Text.Material and _Text.Language = 'E'

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Project Billing Request Items for AI view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view

OData Services (1)

ServiceBindingVersionContractRelease
PROJECTBILLINGREQUEST_SD UI_PROJBILLGREQUEST_SB_V2 V2 C1 NOT_TO_BE_RELEASED_STABLE

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingRequestItemUUID ProjectBillingRequestItem ProjectBillingRequestItemUUID Item ID
PersonFullName Performed By
Material Material Vehicle Model
MaterialName _Text MaterialName Product
BillingWBSElementDescription Billing Element Description
WBSDescription Work Package Name
BillingWBSElementExternalID Billing Element
PricingDate _ProjectBillingElementEntryTP PricingDate Pricing Date
WBSElement Work Package
WorkItem ProjectBillingRequestItem WorkItem Work Item
CostCtrActivityTypeDesc ProjectBillingRequestItem CostCtrActivityTypeDesc Activity Type
DocumentCurrency ProjectBillingRequestItem DocumentCurrency Document Currency
NetPriceAmountInDocCrcy NetPriceAmountInDocCrcy Net Rate
NetPriceQuantityUnit ProjectBillingRequestItem NetPriceQuantityUnit SettlmtPrcUnit
ProjectBillingRequestUUID ProjectBillingRequestItem ProjectBillingRequestUUID Proj Billg Req UUID
_ProjectBillingRequest ProjectBillingRequestItem _ProjectBillingRequest
EngagementProjectServiceOrg _EngmntPrjSrvcOrgDets EngagementProjectServiceOrg Service Org.

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_ProjectBillingRequestItem_AI.
-- 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_ProjectBillingRequestItem_AI AS
SELECT
  ProjectBillingRequestItem.ProjectBillingRequestItemUUID AS ProjectBillingRequestItemUUID,
  ProjectBillingRequestItem._PersonWorkAgreement_1.PersonFullName AS PersonFullName,
  Material,
  _Text.MaterialName AS MaterialName,
  _ProjectBillingElementEntryTP._ProjectBillingElement._WBSElement.WBSDescription AS BillingWBSElementDescription,
  _ProjectBillingElementEntryTP._WBSElement.WBSDescription AS WBSDescription,
  _ProjectBillingElementEntryTP._ProjectBillingElement._WBSElement.WBSElementExternalID AS BillingWBSElementExternalID,
  _ProjectBillingElementEntryTP.PricingDate AS PricingDate,
  _ProjectBillingElementEntryTP._WBSElement.WBSElementExternalID AS WBSElement,
  ProjectBillingRequestItem.WorkItem AS WorkItem,
  ProjectBillingRequestItem.CostCtrActivityTypeDesc AS CostCtrActivityTypeDesc,
  ProjectBillingRequestItem.DocumentCurrency AS DocumentCurrency,
  NetPriceAmountInDocCrcy,
  ProjectBillingRequestItem.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  ProjectBillingRequestItem.ProjectBillingRequestUUID AS ProjectBillingRequestUUID,
  ProjectBillingRequestItem._ProjectBillingRequest AS _ProjectBillingRequest,
  _EngmntPrjSrvcOrgDets.EngagementProjectServiceOrg AS EngagementProjectServiceOrg
LEFT OUTER JOIN I_MaterialText AS _Text ON Material = _Text.Material AND _Text.Language = 'E'  -- association [0..*]
;

Learn More