P_EvtBasedRevnRecgnEvalArea

DDL: P_EVTBASEDREVNRECGNEVALAREA SQL: PEVTBSDRRECEVAL Type: view COMPOSITE
15 Fields 3 Data Sources

P_EvtBasedRevnRecgnEvalArea is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_EvtBsdRevnRecgnEvalScp, I_EvtBsdRevnRecgnLifecycleObj, P_EvtBasedRevnRecgnEvalAreaUse) and exposes 15 fields.

Data Sources (3)

SourceAliasJoin Type
I_EvtBsdRevnRecgnEvalScp eva from
I_EvtBsdRevnRecgnLifecycleObj obadm left_outer
P_EvtBasedRevnRecgnEvalAreaUse use left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PEVTBSDRRECEVAL view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (15)

KeyFieldSource TableSource FieldDescription
Ledger I_EvtBsdRevnRecgnEvalScp Ledger Ledger
EvaluationArea P_EvtBasedRevnRecgnEvalAreaUse EVAL_AREA Evaluation area EBRR
CompanyCode I_EvtBsdRevnRecgnEvalScp CompanyCode Receiver Company Code
GLAccountHierarchy I_EvtBsdRevnRecgnEvalScp GLAccountHierarchy
WBSElementInternalID I_EvtBsdRevnRecgnLifecycleObj WBSElement WBS Internal ID
InternalOrder I_EvtBsdRevnRecgnLifecycleObj InternalOrder Order
SalesDocument I_EvtBsdRevnRecgnLifecycleObj SDDocument SD Document
SalesDocumentItem I_EvtBsdRevnRecgnLifecycleObj SDDocumentItem WBS Element
ServiceDocumentType I_EvtBsdRevnRecgnLifecycleObj ServiceDocumentType Transaction Type
ServiceDocument I_EvtBsdRevnRecgnLifecycleObj ServiceDocument Transaction ID
ServiceDocumentItem I_EvtBsdRevnRecgnLifecycleObj ServiceDocumentItem Service Document
ProviderContract I_EvtBsdRevnRecgnLifecycleObj ProviderContract Contract
ProviderContractItem I_EvtBsdRevnRecgnLifecycleObj ProviderContractItem Contract Item
PostingFiscalPeriod
PostingDate I_EvtBsdRevnRecgnLifecycleObj EvtBsdRevnRecgnLastEvalDate Last evaluation

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_EvtBasedRevnRecgnEvalArea.
-- 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: PEVTBSDRRECEVAL

CREATE VIEW P_EvtBasedRevnRecgnEvalArea AS
SELECT
  eva.Ledger AS Ledger,
  use.EVAL_AREA AS EvaluationArea,
  eva.CompanyCode AS CompanyCode,
  eva.GLAccountHierarchy AS GLAccountHierarchy,
  obadm.WBSElement AS WBSElementInternalID,
  obadm.InternalOrder AS InternalOrder,
  obadm.SDDocument AS SalesDocument,
  obadm.SDDocumentItem AS SalesDocumentItem,
  obadm.ServiceDocumentType AS ServiceDocumentType,
  obadm.ServiceDocument AS ServiceDocument,
  obadm.ServiceDocumentItem AS ServiceDocumentItem,
  obadm.ProviderContract AS ProviderContract,
  obadm.ProviderContractItem AS ProviderContractItem,
  cast ( obadm.EvtBsdRevnRecgnLastEvalYrPerd as fis_jahrper_conv preserving type ) AS PostingFiscalPeriod,
  obadm.EvtBsdRevnRecgnLastEvalDate AS PostingDate
FROM I_EvtBsdRevnRecgnEvalScp AS eva
LEFT OUTER JOIN P_EvtBasedRevnRecgnEvalAreaUse AS use ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EvtBsdRevnRecgnLifecycleObj AS obadm ON /* join condition not captured in parsed metadata */
;

Learn More