I_EVTBSDREVNRECGNCLSGRUNRSLT

CDS View

EBRR Periodic Closing Run Results

I_EVTBSDREVNRECGNCLSGRUNRSLT is a CDS View in S/4HANA. EBRR Periodic Closing Run Results. It contains 11 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 11 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_EBRRPrvdrContrRslt view from CONSUMPTION Results Rev. Rec. Issues - Prvd. Contr
P_EvtBsdRevnRecgnProjectRslt view from CONSUMPTION Results Rev. Rec. Issues - Projects
P_EvtBsdRevnRecgnSalesOrdRslt view from CONSUMPTION Results Rev. Rec. Issues - Sales Orders
P_EvtBsdRevnRecgnSrvcDocRslt view from CONSUMPTION Results Rev. Rec. Issues - Service Documents

Fields (11)

KeyField CDS FieldsUsed in Views
CompanyCode CompanyCode 4
FiscalYearVariant FiscalYearVariant 4
ProfitCenter ProfitCenter 2
Project Project 1
ResultAnalysisInternalID ResultAnalysisInternalID 2
SalesDocument SalesDocument 1
SalesDocumentItem SalesDocumentItem 1
SalesDocumentType SalesDocumentType 1
ServiceDocument ServiceDocument 1
ServiceDocumentItem ServiceDocumentItem 1
ServiceDocumentType ServiceDocumentType 1 
@AbapCatalog.sqlViewName: 'IEBRRCLSGRUNRSLT'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE

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

@EndUserText.label: 'EBRR Periodic Closing Run Results'

define view I_EvtBsdRevnRecgnClsgRunRslt as select from fins_trr_pecrslt {
    key guid as ClosingTaskUUID,
    key rsltln as EvtBsdRevnRecgnClsgRunRsltItem,
    
    //info

      lognumber           as ApplicationLog,
      acc_principle       as AccountingPrinciple,
      pspid               as Project,      
      pspnr               as WBSElementInternalID,
      vbeln               as SalesDocument,
      posnr               as SalesDocumentItem,
      auart               as SalesDocumentType,
      service_doc_type    as ServiceDocumentType,
      service_doc_id      as ServiceDocument,
      service_doc_item_id as ServiceDocumentItem,
      vtkey               as ProviderContract,
      vtpos               as ProviderContractItem,
      bukrs               as CompanyCode,
      objnr               as ControllingObject,
      gjahr               as FiscalYear,
      perio               as FiscalPeriod,
      ledger              as Ledger,
      abgsl               as ResultAnalysisInternalID,
      periv               as FiscalYearVariant,
      prctr               as ProfitCenter,
      msg_cnt_e           as NumberOfOpenErrorMessages,
      timestamp           as CreationDateTime,
  
  //amounts 

  @Semantics.currencyCode: true
  rhcur                   as CompanyCodeCurrency,
  
  @Semantics.amount.currencyCode : 'CompanyCodeCurrency'
  actualcostamount        as  ActlCostAmt,
  
  @Semantics.amount.currencyCode : 'CompanyCodeCurrency'
  actualrevenueamount     as ActlRevnAmt,
  
  @Semantics.amount.currencyCode : 'CompanyCodeCurrency'
  recognizedcogsamount    as RecognizedCOGSAmount,
  
  @Semantics.amount.currencyCode : 'CompanyCodeCurrency'
  recognizedrevenueamount as RecognizedRevenueAmount,
  
  @Semantics.amount.currencyCode : 'CompanyCodeCurrency'
  recognizedmarginamt     as RecognizedMarginAmtInCCCrcy,
  
  @Semantics.amount.currencyCode : 'CompanyCodeCurrency'
  accruedcogsamount       as AccruedCOGSAmount,
  
  @Semantics.amount.currencyCode : 'CompanyCodeCurrency'
  accruedrevenueamount    as AccruedRevenueAmount,
  
  @Semantics.amount.currencyCode : 'CompanyCodeCurrency'
  deferredcogsamount      as DeferredCOGSAmount,
  
  @Semantics.amount.currencyCode : 'CompanyCodeCurrency'
  deferredrevenueamount   as DeferredRevenueAmount,
  
  @Semantics.amount.currencyCode : 'CompanyCodeCurrency'
  revenueadjustmentamount as RevenueAdjustmentAmount,
  
  @Semantics.amount.currencyCode : 'CompanyCodeCurrency'
  cogsadjustmentamount    as COGSAdjustmentAmount,
  
  @Semantics.amount.currencyCode : 'CompanyCodeCurrency'
  unbilledrevenueamount   as UnbilledRevnInCoCodeCrcy,
  
  @Semantics.amount.currencyCode : 'CompanyCodeCurrency'
  accruedrevenuecapamount as AccruedRevenueCapAmtInCCCrcy,
  
  @Semantics.amount.currencyCode : 'CompanyCodeCurrency'
  downpaymentamount       as DownPaymentAmtInCCCrcy 
    
}

Learn More