P_EBRRPrvdrContrRslt

DDL: P_EBRRPRVDRCONTRRSLT SQL: PEBRRPCRSLT Type: view CONSUMPTION

Results Rev. Rec. Issues - Prvd. Contr

P_EBRRPrvdrContrRslt is a Consumption CDS View that provides data about "Results Rev. Rec. Issues - Prvd. Contr" in SAP S/4HANA. It reads from 3 data sources (I_CompanyCode, I_ProviderContractItem, I_EvtBsdRevnRecgnClsgRunRslt) and exposes 29 fields with key fields ClosingTaskUUID, EvtBsdRevnRecgnClsgRunRsltItem.

3 data source(s) 29 fields

Data Sources (3)

SourceAliasJoin Type
I_CompanyCode CompanyCode inner
I_ProviderContractItem ProviderContractItem inner
I_EvtBsdRevnRecgnClsgRunRslt Rslt from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PEBRRPCRSLT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Results Rev. Rec. Issues - Prvd. 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 (29)

KeyFieldSource TableSource FieldDescription
KEY ClosingTaskUUID ClosingTaskUUID
KEY EvtBsdRevnRecgnClsgRunRsltItem EvtBsdRevnRecgnClsgRunRsltItem
ProviderContract I_ProviderContractItem ProviderContract
ProviderContractItem I_ProviderContractItem ProviderContractItem
CompanyCode I_EvtBsdRevnRecgnClsgRunRslt CompanyCode
CompanyCodeName I_CompanyCode CompanyCodeName
ProfitCenter I_EvtBsdRevnRecgnClsgRunRslt ProfitCenter
ControllingObject ControllingObject
FiscalYear FiscalYear
FiscalPeriod FiscalPeriod
Ledger Ledger
ResultAnalysisInternalID I_EvtBsdRevnRecgnClsgRunRslt ResultAnalysisInternalID
FiscalYearVariant I_EvtBsdRevnRecgnClsgRunRslt FiscalYearVariant
NumberOfOpenErrorMessages NumberOfOpenErrorMessages
CreationDateTime CreationDateTime
ApplicationLog ApplicationLog
CompanyCodeCurrency CompanyCodeCurrency
ActlCostAmt ActlCostAmt
ActlRevnAmt ActlRevnAmt
RecognizedCOGSAmount RecognizedCOGSAmount
RecognizedRevenueAmount RecognizedRevenueAmount
RecognizedMarginAmtInCCCrcy RecognizedMarginAmtInCCCrcy
AccruedCOGSAmount AccruedCOGSAmount
AccruedRevenueAmount AccruedRevenueAmount
DeferredCOGSAmount DeferredCOGSAmount
DeferredRevenueAmount DeferredRevenueAmount
RevenueAdjustmentAmount RevenueAdjustmentAmount
COGSAdjustmentAmount COGSAdjustmentAmount
UnbilledRevnInCoCodeCrcy UnbilledRevnInCoCodeCrcy 
@AbapCatalog.sqlViewName: 'PEBRRPCRSLT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Results Rev. Rec. Issues - Prvd. Contr'

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

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

define view P_EBRRPrvdrContrRslt
  as select from I_EvtBsdRevnRecgnClsgRunRslt as Rslt
    inner join   I_ProviderContractItem       as ProviderContractItem on Rslt.ProviderContract = ProviderContractItem.ProviderContract
    inner join   I_CompanyCode                as CompanyCode          on Rslt.CompanyCode = CompanyCode.CompanyCode
{



  key ClosingTaskUUID,
  key EvtBsdRevnRecgnClsgRunRsltItem,

      ProviderContractItem.ProviderContract,
      ProviderContractItem.ProviderContractItem,

      Rslt.CompanyCode,
      CompanyCode.CompanyCodeName,
      
      Rslt.ProfitCenter,        
      ControllingObject, 
      FiscalYear,
      FiscalPeriod,
      Ledger,
      Rslt.ResultAnalysisInternalID,
      Rslt.FiscalYearVariant,
      NumberOfOpenErrorMessages,
      CreationDateTime,
      ApplicationLog,
      CompanyCodeCurrency,

      ActlCostAmt,
      ActlRevnAmt,
      RecognizedCOGSAmount,
      RecognizedRevenueAmount,
      RecognizedMarginAmtInCCCrcy,
      AccruedCOGSAmount,
      AccruedRevenueAmount,
      DeferredCOGSAmount,
      DeferredRevenueAmount,
      RevenueAdjustmentAmount,
      COGSAdjustmentAmount,
      UnbilledRevnInCoCodeCrcy
}

where
      ProviderContractItem.ProviderContract     <> ''
  and ProviderContractItem.ProviderContractItem is not null

Learn More