P_MX_FINANCIALSTMNTSTRUCTURE

CDS View
14 Fields 1 CDS Views

P_MX_FINANCIALSTMNTSTRUCTURE is a CDS View in S/4HANA. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_MX_FinancialStmntStructure2 view from COMPOSITE

Fields (14)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccounts 1
KEY CompanyCode CompanyCode 1
KEY FinancialStatementHierarchy FinancialStatementHierarchy 1
KEY HierarchyNode HierarchyNode 1
KEY HierarchyVersion HierarchyVersion 1
KEY ValidityEndDate ValidityEndDate 1
CountryChartOfAccounts CountryChartOfAccounts 1
FinancialStatementNodeType FinancialStatementNodeType 1
GLAccount GLAccount 1
MaintenanceLanguage MaintenanceLanguage 1
OperationalChartOfAccounts OperationalChartOfAccounts 1
OperationalGLAccount OperationalGLAccount 1
ValidityStartDate ValidityStartDate 1
VATRegistration VATRegistration 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MX_FINANCIALSTMNTSTRUCTURE (
    CHARTOFACCOUNTS,
    COMPANYCODE,
    FINANCIALSTATEMENTHIERARCHY,
    HIERARCHYNODE,
    HIERARCHYVERSION,
    VALIDITYENDDATE,
    COUNTRYCHARTOFACCOUNTS,
    FINANCIALSTATEMENTNODETYPE,
    GLACCOUNT,
    MAINTENANCELANGUAGE,
    OPERATIONALCHARTOFACCOUNTS,
    OPERATIONALGLACCOUNT,
    VALIDITYSTARTDATE,
    VATREGISTRATION,
    PRIMARY KEY (CHARTOFACCOUNTS, COMPANYCODE, FINANCIALSTATEMENTHIERARCHY, HIERARCHYNODE, HIERARCHYVERSION, VALIDITYENDDATE)
);

Learn More