A_CnsldtnFSItemT_2

DDL: A_CNSLDTNFSITEMT_2 Type: view COMPOSITE

Financial Statement Item V2 - Text

A_CnsldtnFSItemT_2 is a Composite CDS View that provides data about "Financial Statement Item V2 - Text" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnFSItemText_2) and exposes 9 fields with key fields Language, ConsolidationChartOfAccounts, FinancialStatementItem. It has 3 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnFSItemText_2 I_CnsldtnFSItemText_2 from

Associations (3)

CardinalityTargetAliasCondition
[1..1] A_CnsldtnChartOfAccounts _CnsldtnChartOfAccounts $projection.ConsolidationChartOfAccounts = _CnsldtnChartOfAccounts.ConsolidationChartOfAccounts
[0..*] A_CnsldtnChartOfAccountsT _CnsldtnChartOfAccountsT $projection.ConsolidationChartOfAccounts = _CnsldtnChartOfAccountsT.ConsolidationChartOfAccounts
[1..1] A_CnsldtnFSItem_2 _CnsldtnFSItem $projection.FinancialStatementItem = _CnsldtnFSItem.FinancialStatementItem and $projection.ConsolidationChartOfAccounts = _CnsldtnFSItem.ConsolidationChartOfAccounts

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ACSFSITEMT2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey FinancialStatementItem view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Financial Statement Item V2 - Text view
OData.entitySet.name FinancialStatementItemText_2 view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Language Language
KEY ConsolidationChartOfAccounts ConsolidationChartOfAccounts
KEY FinancialStatementItem
FinancialStatementItemText CnsldtnFSItemText
FinancialStatementItemMdmText CnsldtnFSItemMediumText
FinancialStatementItemLongText CnsldtnFSItemLongText
_CnsldtnChartOfAccounts _CnsldtnChartOfAccounts
_CnsldtnChartOfAccountsT _CnsldtnChartOfAccountsT
_CnsldtnFSItem _CnsldtnFSItem 
@AbapCatalog:{
  sqlViewName: 'ACSFSITEMT2',
  compiler.compareFilter: true,
  preserveKey: true
  }
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel:{
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #C,
    sizeCategory: #L},
  dataCategory: #TEXT,
  representativeKey: 'FinancialStatementItem'
  }
@VDM:{
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
  }
@EndUserText.label: 'Financial Statement Item V2 - Text'
@OData.entitySet.name: 'FinancialStatementItemText_2'

define view A_CnsldtnFSItemT_2
  as select from I_CnsldtnFSItemText_2

  association [1..1] to A_CnsldtnChartOfAccounts  as _CnsldtnChartOfAccounts  on  $projection.ConsolidationChartOfAccounts = _CnsldtnChartOfAccounts.ConsolidationChartOfAccounts

  association [0..*] to A_CnsldtnChartOfAccountsT as _CnsldtnChartOfAccountsT on  $projection.ConsolidationChartOfAccounts = _CnsldtnChartOfAccountsT.ConsolidationChartOfAccounts

  association [1..1] to A_CnsldtnFSItem_2         as _CnsldtnFSItem           on  $projection.FinancialStatementItem       = _CnsldtnFSItem.FinancialStatementItem
                                                                              and $projection.ConsolidationChartOfAccounts = _CnsldtnFSItem.ConsolidationChartOfAccounts
{
         @Semantics.language: true
  key    Language,

         @EndUserText: {
           label: 'Consolidation Chart of Accounts',
           quickInfo: 'Consolidation Chart of Accounts'
         }
         @ObjectModel.foreignKey.association: '_CnsldtnChartOfAccounts'
         @ObjectModel.text.association: '_CnsldtnChartOfAccountsT'
  key    ConsolidationChartOfAccounts,

         @EndUserText: {
           label: 'Financial Statement Item',
           quickInfo: 'Financial Statement Item'
         }
         @ObjectModel.foreignKey.association: '_CnsldtnFSItem'
  key    cast( CnsldtnFinancialStatementItem as fincs_fsi_item preserving type ) as FinancialStatementItem,

         @EndUserText: {
          label: 'FS Item Description',
          quickInfo: 'Financial Statement Item Description'
         }
         CnsldtnFSItemText                                                as FinancialStatementItemText,

         @Semantics.text: true
         @EndUserText: {
           label: 'FS Item Medium Description',
           quickInfo: 'Financial Statement Item Medium Description'
         }
         CnsldtnFSItemMediumText                                          as FinancialStatementItemMdmText,

         @EndUserText: {
           label: 'FS Item Long Description',
           quickInfo: 'Financial Statement Item Long Description'
         }
         CnsldtnFSItemLongText                                            as FinancialStatementItemLongText,


         // associations

         @Consumption.hidden: true
         _CnsldtnChartOfAccounts, // required for value help retrieval


         @Consumption.hidden: true
         _CnsldtnChartOfAccountsT, // required for text retrieval


         _CnsldtnFSItem // required for value help retrieval and navigation

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNFSITEMTEXT_2"
],
"ASSOCIATED":
[
"A_CNSLDTNCHARTOFACCOUNTS",
"A_CNSLDTNCHARTOFACCOUNTST",
"A_CNSLDTNFSITEM_2"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More