P_RU_FINANCIALSTATEMENTDC

CDS View

Financial Statement Balance D/C Total

P_RU_FINANCIALSTATEMENTDC is a CDS View in S/4HANA. Financial Statement Balance D/C Total. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_RU_FinancialStatementItem view left_outer CONSUMPTION Financial Statement for Russia 
@AbapCatalog.sqlViewName: 'PRUFINSTMNTDC'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AbapCatalog.compiler.compareFilter: true
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking:#NOT_REQUIRED
@EndUserText.label: 'Financial Statement Balance D/C Total'
define view P_RU_FinancialStatementDC 
    with parameters 
        P_FinancialStatementHierarchy  : hryid, //BRFB

        P_StatryRptgEntity  : srf_reporting_entity,
        P_StatryRptCategory : srf_rep_cat_id,
        P_StatryRptRunID    : srf_report_run_id
as select from I_RU_FinStmntRptgItems as FIRUD
    join I_FinStmntExpandedHierNode as Hierarchy on
    Hierarchy.FinancialStatementLeafItem = FIRUD.FinancialStatementLeafItem
    and Hierarchy.FinancialStatementHierarchy = $parameters.P_FinancialStatementHierarchy                     
{
   key    Hierarchy.ParentNode,
   key    Hierarchy.FinancialStatementLeafItem,

      //FIRUD.CompanyCode,

      //FIRUD.AccountingDocument,

      FIRUD.FiscalYear,
       @Semantics.currencyCode:true
       Currency as Currency,
       
       @Semantics.amount.currencyCode: 'Currency'
       @EndUserText.label: 'Period Balance Amount'
       sum(PeriodBalAmtInDspCrcy) as PeriodBalAmtInDspCrcy, // Period Balance      


       @Semantics.amount.currencyCode: 'Currency'
       @EndUserText.label: 'Period Balance Amount'       
       sum(CreditAmountInDisplayCrcy) as CreditAmountInDisplayCrcy,
       
       @Semantics.amount.currencyCode: 'Currency'
       @EndUserText.label: 'Period Balance Amount'       
       sum(DebitAmountInDisplayCrcy) as DebitAmountInDisplayCrcy,  

       @EndUserText.label: 'Year Opening Balance Amount'       
       @Semantics.amount.currencyCode: 'Currency'
        sum(YearlyBalAmtInDspCrcy) as YearlyBalAmtInDspCrcy, //'Year Opening Balance Amount'

       
       @EndUserText.label: 'Period Opening Balance Amount'
       @Semantics.amount.currencyCode: 'Currency'
        sum(StartingBalAmtInDspCrcy) as StartingBalAmtInDspCrcy,//'Opening Balance Amount'

       
       @EndUserText.label: 'Period Ending Balance Amount'
       @Semantics.amount.currencyCode: 'Currency'
       sum(EndingBalAmtInDspCrcy) as EndingBalAmtInDspCrcy //'Closing Balance Amount'   

              
}
where 
      Hierarchy.FinancialStatementHierarchy = $parameters.P_FinancialStatementHierarchy 
  and Hierarchy.FinancialStatementLeafItem != ' '
  and Hierarchy.ParentNode != '00NOTASSGND'
  and Hierarchy.ValidityEndDate = '99991231' 
  and FIRUD.StatryRptgEntity = $parameters.P_StatryRptgEntity
  and FIRUD.StatryRptCategory = $parameters.P_StatryRptCategory
  and FIRUD.StatryRptRunID = $parameters.P_StatryRptRunID
  and Hierarchy.DebitCreditCode > ' '
  group by Hierarchy.ParentNode, Hierarchy.FinancialStatementLeafItem, Currency,
  // FIRUD.AccountingDocument, FIRUD.CompanyCode, 

   FIRUD.FiscalYear
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FINSTMNTEXPANDEDHIERNODE",
"I_RU_FINSTMNTRPTGITEMS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More