P_EBRRPrvdrContrIss

DDL: P_EBRRPRVDRCONTRISS SQL: PEBRRPCISS Type: view CONSUMPTION
21 Fields 5 Data Sources

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.

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 Log Number
ApplicationLogHandle P_EBRRPrvdrContrApplLog ApplicationLogHandle Log Handle
ProviderContract I_ProviderContractItem ProviderContract Contract
ProviderContractItem I_ProviderContractItem ProviderContractItem Contract Item
CAProviderContractItemText I_ProviderContractItem CAProviderContractItemText Ctr.Item Text
ControllingObjectLong P_EBRRPrvdrContrApplLog ControllingObjectLong
OrganizationDivision I_ProviderContractItem Division Internal Division ID
DistributionChannel I_ProviderContractItem DistributionChannel RefDistCh-Cust/Mat.
SalesOrganization I_ProviderContractItem SalesOrganization Sales Organization
ResultAnalysisInternalID I_ProviderContractItem RevenueRecognitionKey Recognition key
ProfitCenter I_ProviderContractItem ProfitCenter Profit Center
CompanyCode I_CompanyCode CompanyCode Receiver Company Code
CompanyCodeName I_CompanyCode CompanyCodeName Company Name
FiscalYearVariant I_CompanyCode FiscalYearVariant FY Variant
Ledger I_EvtBasedRevnRecgnEvalArea Ledger Ledger
AccountingPrinciple P_Trrmonaccprin acc_principle Evaluation area EBRR
NumberOfOpenErrorMessages P_EBRRPrvdrContrApplLog NumberOfOpenErrorMessages
FiscalPeriod P_EBRRPrvdrContrApplLog FiscalPeriod Tax period
FiscalYear P_EBRRPrvdrContrApplLog FiscalYear G/L Fiscal Year
ToFiscalYearPeriod
FiscalYearPeriod

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_EBRRPrvdrContrIss.
-- 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: PEBRRPCISS

CREATE VIEW P_EBRRPrvdrContrIss AS
SELECT
  AppLog.ApplicationLog AS ApplicationLog,
  AppLog.ApplicationLogHandle AS ApplicationLogHandle,
  ProviderContractItem.ProviderContract AS ProviderContract,
  ProviderContractItem.ProviderContractItem AS ProviderContractItem,
  ProviderContractItem.CAProviderContractItemText AS CAProviderContractItemText,
  AppLog.ControllingObjectLong AS ControllingObjectLong,
  ProviderContractItem.Division AS OrganizationDivision,
  ProviderContractItem.DistributionChannel AS DistributionChannel,
  ProviderContractItem.SalesOrganization AS SalesOrganization,
  ProviderContractItem.RevenueRecognitionKey AS ResultAnalysisInternalID,
  ProviderContractItem.ProfitCenter AS ProfitCenter,
  CompanyCode.CompanyCode AS CompanyCode,
  CompanyCode.CompanyCodeName AS CompanyCodeName,
  CompanyCode.FiscalYearVariant AS FiscalYearVariant,
  EvalAreaUse.Ledger AS Ledger,
  Trrmonaccprin.acc_principle AS AccountingPrinciple,
  AppLog.NumberOfOpenErrorMessages AS NumberOfOpenErrorMessages,
  AppLog.FiscalPeriod AS FiscalPeriod,
  AppLog.FiscalYear AS FiscalYear,
  concat(AppLog.FiscalPeriod, concat('.', AppLog.FiscalYear) ) AS ToFiscalYearPeriod,
  concat(AppLog.FiscalYear, AppLog.FiscalPeriod) AS FiscalYearPeriod
FROM P_EBRRPrvdrContrApplLog AS AppLog
INNER JOIN I_ProviderContractItem AS ProviderContractItem 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 */
INNER JOIN I_CompanyCode AS CompanyCode ON /* join condition not captured in parsed metadata */
;

Learn More