C_EvtBsdRevnRecgnProjectWlItm

DDL: C_EVTBSDREVNRECGNPROJECTWLITM SQL: CEBRRPROJRSLTJ Type: view CONSUMPTION
13 Fields 3 Data Sources

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 3 data sources (I_RevnRecgnConstcyLdgrEvalArea, tkkaa, I_WBSElement) and exposes 13 fields with key fields ProjectInternalID, WBSElementInternalID, WBSElement, CompanyCode, Ledger.

Data Sources (3)

SourceAliasJoin Type
I_RevnRecgnConstcyLdgrEvalArea ConstcyLdgrEvalArea inner
tkkaa tkkaa inner
I_WBSElement WBSElement from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CEBRRPROJRSLTJ view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE 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 I_WBSElement ProjectInternalID Project Def.
KEY WBSElementInternalID I_WBSElement WBSElementInternalID WBS Internal ID
KEY WBSElement I_WBSElement WBSElement WBS Internal ID
KEY CompanyCode I_WBSElement CompanyCode Receiver Company Code
KEY Ledger I_RevnRecgnConstcyLdgrEvalArea Ledger Ledger
WBSElementObject I_WBSElement WBSElementObject Object number
Project I_WBSElement Project WBS Element
FiscalYearVariant
ResultAnalysisInternalID I_WBSElement ResultAnalysisInternalID Results Analysis Key
ProjectResponsiblePerson
ResponsiblePersonIsBlocked
IsBusinessPurposeCompleted
AuthorizationGroup

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.
-- SQL view name: CEBRRPROJRSLTJ

CREATE VIEW C_EvtBsdRevnRecgnProjectWlItm AS
SELECT
  WBSElement.ProjectInternalID AS ProjectInternalID,
  WBSElement.WBSElementInternalID AS WBSElementInternalID,
  WBSElement.WBSElement AS WBSElement,
  WBSElement.CompanyCode AS CompanyCode,
  ConstcyLdgrEvalArea.Ledger AS Ledger,
  WBSElement.WBSElementObject AS WBSElementObject,
  WBSElement.Project AS Project,
  WBSElement._CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  WBSElement.ResultAnalysisInternalID AS ResultAnalysisInternalID,
  WBSElement._ResponsiblePerson.ResponsiblePerson AS ProjectResponsiblePerson,
  WBSElement._ResponsiblePerson.ResponsiblePersonIsBlocked AS ResponsiblePersonIsBlocked,
  WBSElement._EntProjectResponsiblePerson._BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  WBSElement._EntProjectResponsiblePerson._WorkforcePerson.AuthorizationGroup AS AuthorizationGroup
FROM I_WBSElement AS WBSElement
INNER JOIN tkkaa ON /* join condition not captured in parsed metadata */
INNER JOIN I_RevnRecgnConstcyLdgrEvalArea AS ConstcyLdgrEvalArea ON /* join condition not captured in parsed metadata */
;

Learn More