C_FinStmntHierInOperatingCOATP

DDL: C_FINSTMNTHIERINOPERATINGCOATP Type: view_entity CONSUMPTION Package: RAP_FI_GL_COA
32 Fields 1 Data Sources 2 OData Services

Financial Statement in Operating COA

C_FinStmntHierInOperatingCOATP is a Consumption CDS View that provides data about "Financial Statement in Operating COA" in SAP S/4HANA. It reads from 1 data source (R_FinStmntHierInOperatingCOATP) and exposes 32 fields with key fields FinancialStatementHierarchy, ChartOfAccounts, ParentNodeUniqueID, SiblingNode, HierarchyNodeUniqueID. It is exposed through 2 OData services (ASQL_F0763B, SD_GLACCOUNTINOPERATINGCOA). Part of development package RAP_FI_GL_COA.

Data Sources (1)

SourceAliasJoin Type
R_FinStmntHierInOperatingCOATP R_FinStmntHierInOperatingCOATP projection

Annotations (8)

NameValueLevelField
EndUserText.label Financial Statement in Operating COA view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
Search.searchable false view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F0763B ASQL_F0763B C2 NOT_RELEASED
SD_GLACCOUNTINOPERATINGCOA UI_GLACCOUNTINOPERATCOA_02 V2 C1 NOT_RELEASED

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY FinancialStatementHierarchy FinancialStatementHierarchy Financial Statement Version
KEY ChartOfAccounts ChartOfAccounts Node Class
KEY ParentNodeUniqueID ParentNodeUniqueID
KEY SiblingNode SiblingNode Sibling Node
KEY HierarchyNodeUniqueID HierarchyNodeUniqueID
KEY HierarchyNode HierarchyNode Node
KEY ValidityEndDate ValidityEndDate ValidTo
FinStatementItemDescription FinStatementItemDescription G/L Accounts in Hierarchy
GLAccount GLAccount General Ledger
GLAccountType GLAccountType G/L Account Type
GLAccountTypeName GLAccountTypeName G/L Account Type Name
GLAccountGroup GLAccountGroup G/L Account Group
AccountGroupName AccountGroupName G/L Account Group Name
CorporateGroupAccount CorporateGroupAccount Group Account Number
CorporateGroupAccountName CorporateGroupAccountName
GLAccountName GLAccountName G/L Account Short Text
GLAccountLongName GLAccountLongName G/L Account Long Text
AccountIsMarkedForDeletion AccountIsMarkedForDeletion Deletion Flag
GLAccountExternal GLAccountExternal G/L Acct External ID
GLAccountSubtype GLAccountSubtype G/L Account Subtype
BankReconciliationAccount BankReconciliationAccount Reconciliation Acct
ProfitLossAccountType ProfitLossAccountType Profit Loss Account Type
GLAcctCOAImplementStatus GLAcctCOAImplementStatus Implementation Status in Chart of Accounts
GLAcctCOAImplementStatusName GLAcctCOAImplementStatusName
FunctionalArea FunctionalArea Sendr Fctl Area
FinStatementHierarchyLevelVal FinStatementHierarchyLevelVal
NodeType NodeType Object Type
HierarchyDrillState HierarchyDrillState Drill State
_FinancialStatementItem _FinancialStatementItem
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_FunctionalArea _FunctionalArea
_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 C_FinStmntHierInOperatingCOATP.
-- 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.

CREATE VIEW C_FinStmntHierInOperatingCOATP AS
SELECT
  FinancialStatementHierarchy,
  ChartOfAccounts,
  ParentNodeUniqueID,
  SiblingNode,
  HierarchyNodeUniqueID,
  HierarchyNode,
  ValidityEndDate,
  FinStatementItemDescription,
  GLAccount,
  GLAccountType,
  GLAccountTypeName,
  GLAccountGroup,
  AccountGroupName,
  CorporateGroupAccount,
  CorporateGroupAccountName,
  GLAccountName,
  GLAccountLongName,
  AccountIsMarkedForDeletion,
  GLAccountExternal,
  GLAccountSubtype,
  BankReconciliationAccount,
  ProfitLossAccountType,
  GLAcctCOAImplementStatus,
  GLAcctCOAImplementStatusName,
  FunctionalArea,
  FinStatementHierarchyLevelVal,
  NodeType,
  HierarchyDrillState
FROM R_FinStmntHierInOperatingCOATP
;

Learn More