C_EvtBsdRevnRecgnProjectWlItm

DDL: C_EVTBSDREVNRECGNPROJECTWLITM Type: view_entity CONSUMPTION Package: FINS_REV_REC_PECRUN
13 Fields 5 Data Sources 1 Associations

Worklist Rev. Rec. Issues - Projects

C_EvtBsdRevnRecgnProjectWlItm is a Consumption CDS View that provides data about "Worklist Rev. Rec. Issues - Projects" in SAP S/4HANA. It reads from 5 data sources (I_RevnRecgnConstcyLdgrEvalArea, I_FiscalYearPeriodForLedger, P_RAIntegEBRRWBSElement, I_ResultsAnalysisKey, I_WBSElementBasicData) and exposes 13 fields with key fields ProjectInternalID, WBSElementInternalID, WBSElement, CompanyCode, Ledger. It has 1 association to related views. Part of development package FINS_REV_REC_PECRUN.

Data Sources (5)

SourceAliasJoin Type
I_RevnRecgnConstcyLdgrEvalArea ConstcyLdgrEvalArea inner
I_FiscalYearPeriodForLedger FiscalYearPeriod inner
P_RAIntegEBRRWBSElement RAIntegObjEBRR left_outer
I_ResultsAnalysisKey ResultsAnalysisKey inner
I_WBSElementBasicData WBSElement from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EntProjectResponsiblePerson _EntProjectResponsiblePerson $projection.WBSElementInternalID = _EntProjectResponsiblePerson.WBSElementInternalID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Worklist Rev. Rec. Issues - Projects view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID
KEY WBSElementInternalID I_WBSElementBasicData WBSElementInternalID WBS Internal ID
KEY WBSElement I_WBSElementBasicData WBSElementExternalID WBS Element External ID
KEY CompanyCode I_WBSElementBasicData CompanyCode Receiver Company Code
KEY Ledger I_RevnRecgnConstcyLdgrEvalArea Ledger Ledger
WBSElementObject I_WBSElementBasicData WBSElementObject Object number
Project
FiscalYearVariant I_FiscalYearPeriodForLedger FiscalYearVariant FY Variant
ResultAnalysisInternalID I_WBSElementBasicData ResultAnalysisInternalID Results Analysis Key
ResponsiblePerson _EntProjectResponsiblePerson PersonWorkAgreement Personnel No.
PerformanceObligation P_RAIntegEBRRWBSElement PerformanceObligation Performance Obligation
RevenueAccountingContract P_RAIntegEBRRWBSElement RevenueAccountingContract Revenue Contract
_EntProjectResponsiblePerson _EntProjectResponsiblePerson

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_EvtBsdRevnRecgnProjectWlItm.
-- 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_EvtBsdRevnRecgnProjectWlItm AS
SELECT
  cast ( WBSElement.ProjectInternalID as ps_s4_proj_pspnr preserving type ) AS ProjectInternalID,
  WBSElement.WBSElementInternalID AS WBSElementInternalID,
  WBSElement.WBSElementExternalID AS WBSElement,
  WBSElement.CompanyCode AS CompanyCode,
  ConstcyLdgrEvalArea.Ledger AS Ledger,
  WBSElement.WBSElementObject AS WBSElementObject,
  cast( WBSElement._Project.ProjectExternalID as ps_pspid_edit preserving type ) AS Project,
  FiscalYearPeriod.FiscalYearVariant AS FiscalYearVariant,
  WBSElement.ResultAnalysisInternalID AS ResultAnalysisInternalID,
  _EntProjectResponsiblePerson.PersonWorkAgreement AS ResponsiblePerson,
  RAIntegObjEBRR.PerformanceObligation AS PerformanceObligation,
  RAIntegObjEBRR.RevenueAccountingContract AS RevenueAccountingContract
FROM I_WBSElementBasicData AS WBSElement
INNER JOIN I_ResultsAnalysisKey AS ResultsAnalysisKey ON /* join condition not captured in parsed metadata */
INNER JOIN I_RevnRecgnConstcyLdgrEvalArea AS ConstcyLdgrEvalArea ON /* join condition not captured in parsed metadata */
INNER JOIN I_FiscalYearPeriodForLedger AS FiscalYearPeriod ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_RAIntegEBRRWBSElement AS RAIntegObjEBRR ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EntProjectResponsiblePerson AS _EntProjectResponsiblePerson ON WBSElementInternalID = _EntProjectResponsiblePerson.WBSElementInternalID  -- association [0..1]
;

Learn More