P_EBRRRevContrWLITM

DDL: P_EBRRREVCONTRWLITM Type: view_entity CONSUMPTION

PECRun: Revenue Contract Worklist item

P_EBRRRevContrWLITM is a Consumption CDS View that provides data about "PECRun: Revenue Contract Worklist item" in SAP S/4HANA. It reads from 4 data sources (I_CompanyCode, I_RevnRecgnConstcyLdgrEvalArea, P_RAIntegObjEBRR, I_RAPerformanceObligation) and exposes 16 fields with key fields RevenueAccountingContract, PerformanceObligation.

4 data source(s) 16 fields

Data Sources (4)

SourceAliasJoin Type
I_CompanyCode CompanyCode inner
I_RevnRecgnConstcyLdgrEvalArea ConsEvalArea inner
P_RAIntegObjEBRR objects inner
I_RAPerformanceObligation PerformanceObligation from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label PECRun: Revenue Contract Worklist item view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY RevenueAccountingContract I_RAPerformanceObligation RevenueAccountingContract
KEY PerformanceObligation I_RAPerformanceObligation PerformanceObligation
CompanyCode I_RAPerformanceObligation CompanyCode
Ledger I_RevnRecgnConstcyLdgrEvalArea Ledger
FiscalYearVariant I_CompanyCode FiscalYearVariant
ProfitCenter I_RAPerformanceObligation ProfitCenter
RAUnivRevnRecgnIntegType I_RAPerformanceObligation RAUnivRevnRecgnIntegType
AccountingPrinciple I_RAPerformanceObligation AccountingPrinciple
ResultAnalysisInternalID P_RAIntegObjEBRR ResultAnalysisInternalID
SalesDocument P_RAIntegObjEBRR SalesDocument
SalesDocumentItem P_RAIntegObjEBRR SalesDocumentItem
ServiceDocumentType P_RAIntegObjEBRR ServiceDocumentType
ServiceDocument P_RAIntegObjEBRR ServiceDocument
ServiceDocumentItem P_RAIntegObjEBRR ServiceDocumentItem
WBSElementInternalID P_RAIntegObjEBRR WBSElementInternalID
WBSElement P_RAIntegObjEBRR WBSElement 
@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'PECRun: Revenue Contract Worklist item'

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED

@VDM.viewType: #CONSUMPTION
//@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.private: true

define view entity P_EBRRRevContrWLITM
  as select from I_RAPerformanceObligation  as PerformanceObligation
    inner join   P_RAIntegObjEBRR           as objects
          on objects.PerformanceObligation = PerformanceObligation.PerformanceObligation


    inner join   I_RevnRecgnConstcyLdgrEvalArea as ConsEvalArea on  ConsEvalArea.CompanyCode         = PerformanceObligation.CompanyCode
                                                                and ConsEvalArea.AccountingPrinciple = PerformanceObligation.AccountingPrinciple

    inner join   I_CompanyCode                  as CompanyCode  on CompanyCode.CompanyCode = PerformanceObligation.CompanyCode
{
  key PerformanceObligation.RevenueAccountingContract,
  key PerformanceObligation.PerformanceObligation,

      PerformanceObligation.CompanyCode,
      ConsEvalArea.Ledger,
      CompanyCode.FiscalYearVariant,
      //so.abgsl    as ResultAnalysisInternalID,

      PerformanceObligation.ProfitCenter,
      PerformanceObligation.RAUnivRevnRecgnIntegType,
      PerformanceObligation.AccountingPrinciple,
      objects.ResultAnalysisInternalID,        
      objects.SalesDocument,
      objects.SalesDocumentItem,      
      objects.ServiceDocumentType,
      objects.ServiceDocument,
      objects.ServiceDocumentItem,
      objects.WBSElementInternalID,
      objects.WBSElement

}
where PerformanceObligation.RAUnivRevnRecgnIntegType <> ' ' 
   or objects.ResultAnalysisInternalID <> ' '
group by
  PerformanceObligation.RevenueAccountingContract,
  PerformanceObligation.PerformanceObligation,
  PerformanceObligation.CompanyCode,
  PerformanceObligation.AccountingPrinciple,
  ConsEvalArea.Ledger,
  CompanyCode.FiscalYearVariant,
  objects.ResultAnalysisInternalID,
  objects.SalesDocument,
  objects.SalesDocumentItem,
  objects.ServiceDocumentType,
  objects.ServiceDocument,
  objects.ServiceDocumentItem,
  objects.ResultAnalysisInternalID,
  PerformanceObligation.RAUnivRevnRecgnIntegType,
  PerformanceObligation.ProfitCenter,
  objects.WBSElementInternalID,
  objects.WBSElement

Learn More