I_CN_FinancialStatementVersion

DDL: I_CN_FINANCIALSTATEMENTVERSION SQL: ICNFSVERSION Type: view BASIC
10 Fields 1 Data Sources 2 Associations

Financial Statement Version for China

I_CN_FinancialStatementVersion is a Basic CDS View that provides data about "Financial Statement Version for China" in SAP S/4HANA. It reads from 1 data source (t011) and exposes 10 fields with key field FinancialStatementVariant. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
t011 t011 from

Associations (2)

CardinalityTargetAliasCondition
[1..*] I_FinancialStatementVersionT _Text $projection.FinancialStatementVariant = _Text.FinancialStatementVariant
[0..1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICNFSVERSION view
VDM.viewType #BASIC view
ObjectModel.representativeKey FinancialStatementVariant view
EndUserText.label Financial Statement Version for China view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
AccessControl.authorizationCheck #CHECK view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY FinancialStatementVariant versn Version
MaintenanceLanguage dspra Maint. Language
ChartOfAccounts ktopl G/L Chart of Accounts
GroupChartOfAccountIsUsed xergs Group Account Number
FunctionalAreaIsUsed xfber Fun.Area Perm.
FinStmntAssetItem aktva Assets
FinStmntLiabilityItem pssva Liabilities
NotAssgdAccountNode zuord Not Assignable
_Text _Text
_ChartOfAccounts _ChartOfAccounts

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CN_FinancialStatementVersion.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICNFSVERSION

CREATE VIEW I_CN_FinancialStatementVersion AS
SELECT
  versn AS FinancialStatementVariant,
  dspra AS MaintenanceLanguage,
  ktopl AS ChartOfAccounts,
  xergs AS GroupChartOfAccountIsUsed,
  xfber AS FunctionalAreaIsUsed,
  aktva AS FinStmntAssetItem,
  pssva AS FinStmntLiabilityItem,
  zuord AS NotAssgdAccountNode
FROM t011
LEFT OUTER JOIN I_FinancialStatementVersionT AS _Text ON FinancialStatementVariant = _Text.FinancialStatementVariant  -- association [1..*]
LEFT OUTER JOIN I_ChartOfAccounts AS _ChartOfAccounts ON ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts  -- association [0..1]
;

Learn More