P_CN_FinancialStatementVersion

DDL: P_CN_FINANCIALSTATEMENTVERSION Type: view CONSUMPTION

Financial Statement Version for China

P_CN_FinancialStatementVersion is a Consumption CDS View that provides data about "Financial Statement Version for China" in SAP S/4HANA. It reads from 1 data source (I_FinancialStatementHier) and exposes 12 fields with key field FinancialStatementVariant.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_FinancialStatementHier I_FinancialStatementHier from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCNFSVERSION view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
VDM.private true view
ObjectModel.representativeKey FinancialStatementVariant view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Financial Statement Version for China view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY FinancialStatementVariant FinancialStatementHierarchy
MaintenanceLanguage
ChartOfAccounts ChartOfAccounts
GroupChartOfAccountIsUsed GroupChartOfAccountIsUsed
FunctionalAreaIsUsed FunctionalAreaIsUsed
FinStmntAssetItem FinancialStatementAssetsItem
FinStmntLiabilityItem FinStatementLiabilitiesItem
NotAssgdAccountNode FinancialStatementOrphansItem
FinancialStatementNetLossItem FinancialStatementNetLossItem
FinStatementNetProfitItem FinStatementNetProfitItem
FinStatementProfitAndLossItem FinStatementProfitAndLossItem
FinancialStatementNotesItem FinancialStatementNotesItem 
@AbapCatalog:{
  sqlViewName: 'PCNFSVERSION',
  preserveKey:true,
  compiler: { compareFilter:true }
}
@VDM:{
  viewType: #CONSUMPTION,
  private:true
}
@ObjectModel: {
   representativeKey: 'FinancialStatementVariant'
//   usageType: {

//   dataClass: #MIXED,

//   sizeCategory: #L,

//   serviceQuality: #C

//   }

}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Financial Statement Version for China'

define view P_CN_FinancialStatementVersion
  //as select from I_FinancialStatementVersion_2

  as select from I_FinancialStatementHier 
{
  key  FinancialStatementHierarchy                             as FinancialStatementVariant,
       _Text[1:Language=$session.system_language].Language     as MaintenanceLanguage,
       ChartOfAccounts, 
       GroupChartOfAccountIsUsed,
       FunctionalAreaIsUsed,
       FinancialStatementAssetsItem                            as FinStmntAssetItem,
       FinStatementLiabilitiesItem                             as FinStmntLiabilityItem,
       FinancialStatementOrphansItem                           as NotAssgdAccountNode,

       FinancialStatementNetLossItem,
       FinStatementNetProfitItem,
       FinStatementProfitAndLossItem,
       FinancialStatementNotesItem
  }
    where not FinancialStatementHierarchy like 'H102/%'
       and  not FinancialStatementHierarchy like '%_DRAFT'


/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FINANCIALSTATEMENTHIER",
"I_FINANCIALSTATEMENTHIERT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More