P_BalShtIncomeStatementItem

DDL: P_BALSHTINCOMESTATEMENTITEM Type: view_entity COMPOSITE Package: FIN_GL_FS_REVIEW_BOOKLET

Balance Sheet Item

P_BalShtIncomeStatementItem is a Composite CDS View that provides data about "Balance Sheet Item" in SAP S/4HANA. It reads from 5 data sources (I_BalShtIncStmntSpecialItem, I_FunctionalArea, I_GLAccountInChartOfAccounts, I_GLAccountInChartOfAccounts, I_GLAccountInChartOfAccounts) and exposes 7 fields with key fields ChartOfAccounts, BalSheetIncomeStatementItem, BalSheetIncomeStatementItem, BalSheetIncomeStatementItem, BalSheetIncomeStatementItem. Part of development package FIN_GL_FS_REVIEW_BOOKLET.

5 data source(s) 7 fields

Data Sources (5)

SourceAliasJoin Type
I_BalShtIncStmntSpecialItem I_BalShtIncStmntSpecialItem union
I_FunctionalArea I_FunctionalArea union
I_GLAccountInChartOfAccounts I_GLAccountInChartOfAccounts from
I_GLAccountInChartOfAccounts I_GLAccountInChartOfAccounts union
I_GLAccountInChartOfAccounts I_GLAccountInChartOfAccounts union

Annotations (4)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ChartOfAccounts ChartOfAccounts
KEY BalSheetIncomeStatementItem
KEY BalSheetIncomeStatementItem
KEY BalSheetIncomeStatementItem
KEY BalSheetIncomeStatementItem
KEY BalSheetIncomeStatementItem BalSheetIncomeStatementItem
KEY BalShtIncStatementItemSuffix BalShtIncStatementItemSuffix 
@VDM.private:true
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true 
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view entity P_BalShtIncomeStatementItem
  as select from I_GLAccountInChartOfAccounts

{


  key ChartOfAccounts,

  key cast( GLAccount as bsis_item )    as BalSheetIncomeStatementItem,

  key cast( '0A' as bsis_item_suffix ) as BalShtIncStatementItemSuffix

}

union

select from I_GLAccountInChartOfAccounts

{

  key ChartOfAccounts,

  key cast( GLAccount as bsis_item )    as BalSheetIncomeStatementItem,

  key cast( '1A' as bsis_item_suffix ) as BalShtIncStatementItemSuffix

}

union

select from I_GLAccountInChartOfAccounts

{

  key ChartOfAccounts,

  key cast( GLAccount as bsis_item )    as BalSheetIncomeStatementItem,

  key cast( '2A' as bsis_item_suffix ) as BalShtIncStatementItemSuffix

}

union

select from I_FunctionalArea

{

  key cast( '' as ktopl )           as ChartOfAccounts,

  key cast( FunctionalArea as bsis_item )   as BalSheetIncomeStatementItem,


  key cast( 'F' as bsis_item_suffix ) as BalShtIncStatementItemSuffix

}

union

select from I_BalShtIncStmntSpecialItem

{

  key ChartOfAccounts,

  key BalSheetIncomeStatementItem,

  key BalShtIncStatementItemSuffix

}

Learn More