P_EvtBsdRevnRecProjectIssue

DDL: P_EVTBSDREVNRECPROJECTISSUE SQL: PEBRRPROJECTRSLT Type: view CONSUMPTION
25 Fields 5 Data Sources 1 Associations

Event based rev. rec. project issue

P_EvtBsdRevnRecProjectIssue is a Consumption CDS View that provides data about "Event based rev. rec. project issue" in SAP S/4HANA. It reads from 5 data sources (P_EvtBsdRevnRecProjectAppLog, I_CompanyCode, I_EvtBasedRevnRecgnEvalArea, P_Trrmonaccprin, I_WBSElement) and exposes 25 fields with key field ApplicationLog. It has 1 association to related views.

Data Sources (5)

SourceAliasJoin Type
P_EvtBsdRevnRecProjectAppLog AppLog from
I_CompanyCode CompanyCode inner
I_EvtBasedRevnRecgnEvalArea EvalAreaUse inner
P_Trrmonaccprin Trrmonaccprin inner
I_WBSElement WBSElement inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_EvtBsdRevnRecgnProjectIssDet _ProjectIssDetail _ProjectIssDetail.ApplicationLog = $projection.ApplicationLog

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PEBRRPROJECTRSLT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Event based rev. rec. project issue view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ApplicationLog P_EvtBsdRevnRecProjectAppLog ApplicationLog Log Number
WBSElement I_WBSElement WBSElement WBS Internal ID
ProjectInternalID I_WBSElement ProjectInternalID Project Def.
Project I_WBSElement Project WBS Element
WBSElementInternalID I_WBSElement WBSElementInternalID WBS Internal ID
FiscalPeriod P_EvtBsdRevnRecProjectAppLog FiscalPeriod Tax period
FiscalYear P_EvtBsdRevnRecProjectAppLog FiscalYear G/L Fiscal Year
ApplicationLogHandle P_EvtBsdRevnRecProjectAppLog ApplicationLogHandle Log Handle
NumberOfOpenErrorMessages P_EvtBsdRevnRecProjectAppLog NumberOfOpenErrorMessages
ToFiscalYearPeriod
FiscalYearPeriod
ProfitCenter I_WBSElement ProfitCenter Profit Center
Ledger I_EvtBasedRevnRecgnEvalArea Ledger Ledger
AccountingPrinciple P_Trrmonaccprin acc_principle Evaluation area EBRR
CompanyCode I_CompanyCode CompanyCode Receiver Company Code
CompanyCodeName I_CompanyCode CompanyCodeName Company Name
FiscalYearVariant I_CompanyCode FiscalYearVariant FY Variant
Prefix P_EvtBsdRevnRecProjectAppLog Prefix SerialNo.Prefix
ResultAnalysisInternalID I_WBSElement ResultAnalysisInternalID Results Analysis Key
ExternalNumber P_EvtBsdRevnRecProjectAppLog ExternalNumber External Number
WBSElementObject P_EvtBsdRevnRecProjectAppLog WBSElementObject Object number
_ProjectIssDetail _ProjectIssDetail
_EntProjectResponsiblePerson I_WBSElement _EntProjectResponsiblePerson
_ResponsiblePerson I_WBSElement _ResponsiblePerson
WBSResponsiblePerson I_WBSElement ResponsiblePerson Processor

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_EvtBsdRevnRecProjectIssue.
-- 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: PEBRRPROJECTRSLT

CREATE VIEW P_EvtBsdRevnRecProjectIssue AS
SELECT
  AppLog.ApplicationLog AS ApplicationLog,
  WBSElement.WBSElement AS WBSElement,
  WBSElement.ProjectInternalID AS ProjectInternalID,
  WBSElement.Project AS Project,
  WBSElement.WBSElementInternalID AS WBSElementInternalID,
  AppLog.FiscalPeriod AS FiscalPeriod,
  AppLog.FiscalYear AS FiscalYear,
  AppLog.ApplicationLogHandle AS ApplicationLogHandle,
  AppLog.NumberOfOpenErrorMessages AS NumberOfOpenErrorMessages,
  concat(AppLog.FiscalPeriod, concat('.', AppLog.FiscalYear) ) AS ToFiscalYearPeriod,
  concat(AppLog.FiscalYear, AppLog.FiscalPeriod) AS FiscalYearPeriod,
  WBSElement.ProfitCenter AS ProfitCenter,
  EvalAreaUse.Ledger AS Ledger,
  Trrmonaccprin.acc_principle AS AccountingPrinciple,
  CompanyCode.CompanyCode AS CompanyCode,
  CompanyCode.CompanyCodeName AS CompanyCodeName,
  CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  AppLog.Prefix AS Prefix,
  WBSElement.ResultAnalysisInternalID AS ResultAnalysisInternalID,
  AppLog.ExternalNumber AS ExternalNumber,
  AppLog.WBSElementObject AS WBSElementObject,
  WBSElement._EntProjectResponsiblePerson AS _EntProjectResponsiblePerson,
  WBSElement._ResponsiblePerson AS _ResponsiblePerson,
  WBSElement.ResponsiblePerson AS WBSResponsiblePerson
FROM P_EvtBsdRevnRecProjectAppLog AS AppLog
INNER JOIN I_WBSElement AS WBSElement ON /* join condition not captured in parsed metadata */
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
INNER JOIN I_EvtBasedRevnRecgnEvalArea AS EvalAreaUse ON /* join condition not captured in parsed metadata */
INNER JOIN P_Trrmonaccprin AS Trrmonaccprin ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_EvtBsdRevnRecgnProjectIssDet AS _ProjectIssDetail ON _ProjectIssDetail.ApplicationLog = ApplicationLog  -- association [0..1]
;

Learn More