P_EvtBsdRevnRecgnProjWIPNpi

DDL: P_EVTBSDREVNRECGNPROJWIPNPI SQL: PEBRRPROJWIPNPI Type: view COMPOSITE
29 Fields 3 Data Sources

P_EvtBsdRevnRecgnProjWIPNpi is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (P_EvtBsdRevnRecgnProjWIPBeeFlw, I_GLAccountLineItemRawData, I_PrjBlgElmEntrJrnlEntrLink) and exposes 29 fields with key fields Ledger, CompanyCode, FiscalYear, AccountingDocument, LedgerGLLineItem.

Data Sources (3)

SourceAliasJoin Type
P_EvtBsdRevnRecgnProjWIPBeeFlw EvtBsdRevnRecgnProjWIPBeeFlw from
I_GLAccountLineItemRawData GLAccountLineItemRawData inner
I_PrjBlgElmEntrJrnlEntrLink PrjBlgElmEntrJrnlEntrLink inner

Parameters (1)

NameTypeDefault
P_Ledger fins_ledger

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PEBRRPROJWIPNPI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY Ledger Ledger Ledger
KEY CompanyCode I_PrjBlgElmEntrJrnlEntrLink CompanyCode Receiver Company Code
KEY FiscalYear I_PrjBlgElmEntrJrnlEntrLink FiscalYear G/L Fiscal Year
KEY AccountingDocument I_PrjBlgElmEntrJrnlEntrLink AccountingDocument Journal Entry
KEY LedgerGLLineItem I_PrjBlgElmEntrJrnlEntrLink LedgerGLLineItem Journal Entry Item
ProjBillgElmntEntrItmUUID P_EvtBsdRevnRecgnProjWIPBeeFlw ProjBillgElmntEntrItmUUID PBE Entry UUID
BillingWBSElementInternalID BillingWBSElementInternalID WBS Internal ID
WBSElementInternalID P_EvtBsdRevnRecgnProjWIPBeeFlw WBSElementInternalID WBS Internal ID
Material Material Vehicle Model
ServicesRenderedDate P_EvtBsdRevnRecgnProjWIPBeeFlw ServicesRenderedDate Services Rendered Date
DocumentCurrency DocumentCurrency Document Currency
QuantityUnit QuantityUnit Unit of measure
OpenAmountInTransCrcy OpenAmountInTransCrcy Open Amt Trans Crcy
BilledRevenueAmtInDocCrcy BilledRevenueAmtInDocCrcy Billed Revenue
BilledQuantity BilledQuantity
BillgReqdRevenueAmtInDocCrcy BillgReqdRevenueAmtInDocCrcy Billg Reqd Revn
BillingRequestedQuantity BillingRequestedQuantity Billg Reqd Quantity
PrjBlgElmEntryLongText PrjBlgElmEntryLongText long text
BillableControl I_GLAccountLineItemRawData BillableControl Billable Control
WorkItem I_GLAccountLineItemRawData WorkItem Work Item ID
Customer I_GLAccountLineItemRawData Customer Sold-to Party
FiscalYearPeriod I_GLAccountLineItemRawData FiscalYearPeriod Period/Year
PostingDate I_GLAccountLineItemRawData PostingDate Posting Date for GR
GLAccount I_GLAccountLineItemRawData GLAccount General Ledger
PersonnelNumber I_GLAccountLineItemRawData PersonnelNumber Personnel No.
TimeSheetOvertimeCategory I_GLAccountLineItemRawData TimeSheetOvertimeCategory Overtime Category
ReferenceDocumentType I_GLAccountLineItemRawData ReferenceDocumentType Reference Document Type
DocumentItemText I_GLAccountLineItemRawData DocumentItemText Text
PartnerCostCenter I_GLAccountLineItemRawData PartnerCostCenter Sender Cost Ctr

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_EvtBsdRevnRecgnProjWIPNpi.
-- 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.
-- SQL view name: PEBRRPROJWIPNPI
-- Parameters: P_Ledger : fins_ledger

CREATE VIEW P_EvtBsdRevnRecgnProjWIPNpi AS
SELECT
  Ledger,
  PrjBlgElmEntrJrnlEntrLink.CompanyCode AS CompanyCode,
  PrjBlgElmEntrJrnlEntrLink.FiscalYear AS FiscalYear,
  PrjBlgElmEntrJrnlEntrLink.AccountingDocument AS AccountingDocument,
  PrjBlgElmEntrJrnlEntrLink.LedgerGLLineItem AS LedgerGLLineItem,
  EvtBsdRevnRecgnProjWIPBeeFlw.ProjBillgElmntEntrItmUUID AS ProjBillgElmntEntrItmUUID,
  BillingWBSElementInternalID,
  EvtBsdRevnRecgnProjWIPBeeFlw.WBSElementInternalID AS WBSElementInternalID,
  Material,
  EvtBsdRevnRecgnProjWIPBeeFlw.ServicesRenderedDate AS ServicesRenderedDate,
  DocumentCurrency,
  QuantityUnit,
  OpenAmountInTransCrcy,
  BilledRevenueAmtInDocCrcy,
  BilledQuantity,
  BillgReqdRevenueAmtInDocCrcy,
  BillingRequestedQuantity,
  PrjBlgElmEntryLongText,
  GLAccountLineItemRawData.BillableControl AS BillableControl,
  GLAccountLineItemRawData.WorkItem AS WorkItem,
  GLAccountLineItemRawData.Customer AS Customer,
  GLAccountLineItemRawData.FiscalYearPeriod AS FiscalYearPeriod,
  GLAccountLineItemRawData.PostingDate AS PostingDate,
  GLAccountLineItemRawData.GLAccount AS GLAccount,
  GLAccountLineItemRawData.PersonnelNumber AS PersonnelNumber,
  GLAccountLineItemRawData.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  GLAccountLineItemRawData.ReferenceDocumentType AS ReferenceDocumentType,
  GLAccountLineItemRawData.DocumentItemText AS DocumentItemText,
  GLAccountLineItemRawData.PartnerCostCenter AS PartnerCostCenter
FROM P_EvtBsdRevnRecgnProjWIPBeeFlw AS EvtBsdRevnRecgnProjWIPBeeFlw
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 */
;

Learn More