P_EBRRPrvdrContrIss

DDL: P_EBRRPRVDRCONTRISS SQL: PEBRRPCISS Type: view CONSUMPTION

EBRR: Manage RR Issues – Prov.Contr.

P_EBRRPrvdrContrIss is a Consumption CDS View that provides data about "EBRR: Manage RR Issues – Prov.Contr." in SAP S/4HANA. It reads from 5 data sources (P_EBRRPrvdrContrApplLog, I_CompanyCode, I_EvtBasedRevnRecgnEvalArea, I_ProviderContractItem, P_Trrmonaccprin) and exposes 21 fields with key field ApplicationLog.

5 data source(s) 21 fields

Data Sources (5)

SourceAliasJoin Type
P_EBRRPrvdrContrApplLog AppLog from
I_CompanyCode CompanyCode inner
I_EvtBasedRevnRecgnEvalArea EvalAreaUse inner
I_ProviderContractItem ProviderContractItem inner
P_Trrmonaccprin Trrmonaccprin inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PEBRRPCISS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label EBRR: Manage RR Issues – Prov.Contr. 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 (21)

KeyFieldSource TableSource FieldDescription
KEY ApplicationLog P_EBRRPrvdrContrApplLog ApplicationLog
ApplicationLogHandle P_EBRRPrvdrContrApplLog ApplicationLogHandle
ProviderContract I_ProviderContractItem ProviderContract
ProviderContractItem I_ProviderContractItem ProviderContractItem
CAProviderContractItemText I_ProviderContractItem CAProviderContractItemText
ControllingObjectLong P_EBRRPrvdrContrApplLog ControllingObjectLong
OrganizationDivision I_ProviderContractItem Division
DistributionChannel I_ProviderContractItem DistributionChannel
SalesOrganization I_ProviderContractItem SalesOrganization
ResultAnalysisInternalID I_ProviderContractItem RevenueRecognitionKey
ProfitCenter I_ProviderContractItem ProfitCenter
CompanyCode I_CompanyCode CompanyCode
CompanyCodeName I_CompanyCode CompanyCodeName
FiscalYearVariant I_CompanyCode FiscalYearVariant
Ledger I_EvtBasedRevnRecgnEvalArea Ledger
AccountingPrinciple P_Trrmonaccprin acc_principle
NumberOfOpenErrorMessages P_EBRRPrvdrContrApplLog NumberOfOpenErrorMessages
FiscalPeriod P_EBRRPrvdrContrApplLog FiscalPeriod
FiscalYear P_EBRRPrvdrContrApplLog FiscalYear
ToFiscalYearPeriod
FiscalYearPeriod 
@AbapCatalog.sqlViewName: 'PEBRRPCISS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'EBRR: Manage RR Issues – Prov.Contr.'

@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED

@VDM.viewType: #CONSUMPTION
@VDM.private: true

define view P_EBRRPrvdrContrIss
  as select from P_EBRRPrvdrContrApplLog     as AppLog

    inner join   I_ProviderContractItem      as ProviderContractItem on  ProviderContractItem.ProviderContract     = AppLog.ProviderContract
                                                                     and ProviderContractItem.ProviderContractItem = AppLog.ProviderContractItem

  // AppLog.AccountingPrinciple contains EvaluationArea, in future the field Applog.AccountingPrinciple will contain Ledger only

    inner join   I_EvtBasedRevnRecgnEvalArea as EvalAreaUse          on  EvalAreaUse.CompanyCode        = AppLog.CompanyCode
                                                                     and EvalAreaUse.EvtBsdRevnEvalArea = AppLog.AccountingPrinciple

    inner join   P_Trrmonaccprin             as Trrmonaccprin        on  Trrmonaccprin.rldnr = EvalAreaUse.Ledger
                                                                     and Trrmonaccprin.bukrs = AppLog.CompanyCode
                                                                     and Trrmonaccprin.abgsl = ProviderContractItem.RevenueRecognitionKey

    inner join   I_CompanyCode               as CompanyCode          on CompanyCode.CompanyCode = AppLog.CompanyCode
{
  key AppLog.ApplicationLog,
      AppLog.ApplicationLogHandle,
      ProviderContractItem.ProviderContract,
      ProviderContractItem.ProviderContractItem,
//      ProviderContractItem.CAProviderContractItemText              as ProviderContractDescription,

      ProviderContractItem.CAProviderContractItemText              as CAProviderContractItemText,

      AppLog.ControllingObjectLong,                                
      ProviderContractItem.Division                                as OrganizationDivision,
      ProviderContractItem.DistributionChannel,
      ProviderContractItem.SalesOrganization,
      ProviderContractItem.RevenueRecognitionKey                   as ResultAnalysisInternalID,
      ProviderContractItem.ProfitCenter,

      CompanyCode.CompanyCode,
      CompanyCode.CompanyCodeName,
      CompanyCode.FiscalYearVariant,

      EvalAreaUse.Ledger                                           as Ledger,
      Trrmonaccprin.acc_principle                                  as AccountingPrinciple,

      AppLog.NumberOfOpenErrorMessages,
      AppLog.FiscalPeriod,
      AppLog.FiscalYear,
      concat(AppLog.FiscalPeriod, concat('.', AppLog.FiscalYear) ) as ToFiscalYearPeriod,
      concat(AppLog.FiscalYear, AppLog.FiscalPeriod)               as FiscalYearPeriod
}
where
  AppLog.Prefix = 'PJ'

Learn More