I_RETAINEDEARNINGSGLACCOUNT

CDS View

Retained Earnings G/L Account

I_RETAINEDEARNINGSGLACCOUNT is a CDS View in S/4HANA. Retained Earnings G/L Account. It contains 1 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 1 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MY_JournalEntryItemCube view left_outer COMPOSITE Journal Entry Item Cube for MY GAF
I_ProfitLossAccountType_Vh view from BASIC Profit/Loss Account Type

Fields (1)

KeyField CDS FieldsUsed in Views
ChartOfAccounts OperationalChartOfAccounts 1 
@EndUserText.label: 'Retained Earnings G/L Account'
@AbapCatalog.sqlViewName: 'IFIRetnEarnGLAcc'
@VDM.viewType: #BASIC
@Analytics: {dataCategory: #DIMENSION, dataExtraction.enabled: true}
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'ProfitLossAccountType'
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #CUSTOMIZING

define view I_RetainedEarningsGLAccount 
as select from t030 
association [0..1] to I_ChartOfAccounts as _ChartOfAccounts 
  on $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
association [0..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts
  on  $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts
  and $projection.RetainedEarningsGLAccount = _GLAccountInChartOfAccounts.GLAccount
{
  @ObjectModel.foreignKey.association: '_ChartOfAccounts'
  key cast( ktopl as fis_ktopl ) as ChartOfAccounts, 
  key cast (komok as gvtyp) as ProfitLossAccountType, // Generates CAST("T030"."KOMOK" AS NVARCHAR(000002))

  @ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
  t030.konts as RetainedEarningsGLAccount,
  _ChartOfAccounts,
  _GLAccountInChartOfAccounts
}
where ktosl = 'BIL'
and   bklas = ''
and   bwmod = ''                               
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"T030"
],
"ASSOCIATED":
[
"I_CHARTOFACCOUNTS",
"I_GLACCOUNTINCHARTOFACCOUNTS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More