P_ProjBillgRequestItemWithErr

DDL: P_PROJBILLGREQUESTITEMWITHERR Type: view_entity CONSUMPTION Package: VDM_PROJBILLINGELEMENTENTRY
28 Fields 3 Data Sources 2 Associations

P-View for excluded posting item

P_ProjBillgRequestItemWithErr is a Consumption CDS View that provides data about "P-View for excluded posting item" in SAP S/4HANA. It reads from 3 data sources (I_GLAccountLineItemRawData, I_PrjBlgElmEntrJrnlEntrLink, I_ProjectBillingRequestItem) and exposes 28 fields with key fields ProjectBillingRequestUUID, ProjectBillingRequestItemUUID. It has 2 associations to related views. Part of development package VDM_PROJBILLINGELEMENTENTRY.

Data Sources (3)

SourceAliasJoin Type
I_GLAccountLineItemRawData _GLAccountLineItemRawData inner
I_PrjBlgElmEntrJrnlEntrLink _PrjBlgElmEntrJrnlEntrLink inner
I_ProjectBillingRequestItem _ProjectBillingRequestItem from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_WorkItemText _WorkItemText _WorkItemText.WorkItem = $projection.WorkItem and _WorkItemText.Language = $session.system_language
[0..1] I_WorkPackageWorkItem _CustomWorkItemText _CustomWorkItemText.WorkItem = $projection.WorkItem and $projection.WorkPackage = _CustomWorkItemText.WorkPackage

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label P-View for excluded posting item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY ProjectBillingRequestUUID I_ProjectBillingRequestItem ProjectBillingRequestUUID Proj Billg Req UUID
KEY ProjectBillingRequestItemUUID I_ProjectBillingRequestItem ProjectBillingRequestItemUUID Item UUID
Material I_ProjectBillingRequestItem Material Vehicle Model
NetPriceAmountInDocCrcy I_ProjectBillingRequestItem NetPriceAmountInDocCrcy Net Price
ProjBillgElmntEntrItmUUID I_ProjectBillingRequestItem ProjBillgElmntEntrItmUUID PBE Entry UUID
ProjectBillingElementUUID I_ProjectBillingRequestItem ProjectBillingElementUUID PBE UUID
OpenQuantity I_ProjectBillingRequestItem OpenQuantity PBE Entry Open Qty
ToBeBilledQuantity I_ProjectBillingRequestItem ToBeBilledQuantity To Be Blld Qty
ServicesRenderedDate
ProjectCurrency I_ProjectBillingRequestItem ProjectCurrency Project Currency
OriginalAmountInProjectCrcy
DocumentCurrency I_ProjectBillingRequestItem DocumentCurrency Document Currency
QuantityUnit I_ProjectBillingRequestItem QuantityUnit Unit of measure
GlobalCurrency I_ProjectBillingRequestItem GlobalCurrency GM Billing Element: Global Currency
OpenAmountInTransCrcy I_ProjectBillingRequestItem OpenAmountInTransCrcy Open Amt Trans Crcy
ToBeBilledAmtInTransCrcy I_ProjectBillingRequestItem ToBeBilledAmtInTransCrcy To Be Blld Trans Cur
BillableRevenueAmtInDocCrcy I_ProjectBillingRequestItem BillableRevenueAmtInDocCrcy Billable Revenue
WorkItemNameendasWorkItemName
Ledger I_PrjBlgElmEntrJrnlEntrLink Ledger Ledger
CompanyCode I_PrjBlgElmEntrJrnlEntrLink CompanyCode Receiver Company Code
FiscalYear I_PrjBlgElmEntrJrnlEntrLink FiscalYear G/L Fiscal Year
AccountingDocument I_PrjBlgElmEntrJrnlEntrLink AccountingDocument Journal Entry
LedgerGLLineItem I_PrjBlgElmEntrJrnlEntrLink LedgerGLLineItem Journal Entry Item
WorkItem I_GLAccountLineItemRawData WorkItem Work Item ID
WorkPackage I_GLAccountLineItemRawData WorkPackage Plan Item
PersonnelNumber I_GLAccountLineItemRawData PersonnelNumber Personnel No.
_WorkItemText _WorkItemText
_CustomWorkItemText _CustomWorkItemText

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 P_ProjBillgRequestItemWithErr.
-- 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 P_ProjBillgRequestItemWithErr AS
SELECT
  _ProjectBillingRequestItem.ProjectBillingRequestUUID AS ProjectBillingRequestUUID,
  _ProjectBillingRequestItem.ProjectBillingRequestItemUUID AS ProjectBillingRequestItemUUID,
  _ProjectBillingRequestItem.Material AS Material,
  _ProjectBillingRequestItem.NetPriceAmountInDocCrcy AS NetPriceAmountInDocCrcy,
  _ProjectBillingRequestItem.ProjBillgElmntEntrItmUUID AS ProjBillgElmntEntrItmUUID,
  _ProjectBillingRequestItem.ProjectBillingElementUUID AS ProjectBillingElementUUID,
  _ProjectBillingRequestItem.OpenQuantity AS OpenQuantity,
  _ProjectBillingRequestItem.ToBeBilledQuantity AS ToBeBilledQuantity,
  _PrjBlgElmEntrJrnlEntrLink._ProjectBillingElementEntry.ServicesRenderedDate AS ServicesRenderedDate,
  _ProjectBillingRequestItem.ProjectCurrency AS ProjectCurrency,
  _PrjBlgElmEntrJrnlEntrLink._ProjectBillingElementEntry.OriginalAmountInProjectCrcy AS OriginalAmountInProjectCrcy,
  _ProjectBillingRequestItem.DocumentCurrency AS DocumentCurrency,
  _ProjectBillingRequestItem.QuantityUnit AS QuantityUnit,
  _ProjectBillingRequestItem.GlobalCurrency AS GlobalCurrency,
  _ProjectBillingRequestItem.OpenAmountInTransCrcy AS OpenAmountInTransCrcy,
  _ProjectBillingRequestItem.ToBeBilledAmtInTransCrcy AS ToBeBilledAmtInTransCrcy,
  _ProjectBillingRequestItem.BillableRevenueAmtInDocCrcy AS BillableRevenueAmtInDocCrcy,
  case when _WorkItemText.WorkItemName is null then _CustomWorkItemText.WorkItemName else _WorkItemText.WorkItemName end as WorkItemName AS WorkItemNameendasWorkItemName,
  _PrjBlgElmEntrJrnlEntrLink.Ledger AS Ledger,
  _PrjBlgElmEntrJrnlEntrLink.CompanyCode AS CompanyCode,
  _PrjBlgElmEntrJrnlEntrLink.FiscalYear AS FiscalYear,
  _PrjBlgElmEntrJrnlEntrLink.AccountingDocument AS AccountingDocument,
  _PrjBlgElmEntrJrnlEntrLink.LedgerGLLineItem AS LedgerGLLineItem,
  _GLAccountLineItemRawData.WorkItem AS WorkItem,
  _GLAccountLineItemRawData.WorkPackage AS WorkPackage,
  _GLAccountLineItemRawData.PersonnelNumber AS PersonnelNumber
FROM I_ProjectBillingRequestItem AS _ProjectBillingRequestItem
INNER JOIN I_PrjBlgElmEntrJrnlEntrLink AS _PrjBlgElmEntrJrnlEntrLink ON /* join condition not captured in parsed metadata */
INNER JOIN I_GLAccountLineItemRawData AS _GLAccountLineItemRawData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkItemText AS _WorkItemText ON _WorkItemText.WorkItem = WorkItem AND _WorkItemText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_WorkPackageWorkItem AS _CustomWorkItemText ON _CustomWorkItemText.WorkItem = WorkItem AND WorkPackage = _CustomWorkItemText.WorkPackage  -- association [0..1]
;

Learn More