FSV

29 Fields

FSV is an SAP database table in S/4HANA. It contains 29 fields.

Fields (29)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY ChartOfAccounts ChartOfAccounts 7
KEY CompanyCode CompanyCode 7
KEY FinancialStatementHierarchy FinancialStatementHierarchy,FinancialStatementVariant 4
KEY FinancialStatementVariant FinancialStatementVariant 4
KEY FiscalYear FiscalYear 1
KEY GLAccount GLAccount 8
KEY HierarchyNode HierarchyNodeUniqueID 3
KEY HierarchyNodeUniqueID HierarchyNodeUniqueID 3
KEY HierarchyNodeVal COAChangeListTargetNumber 1
KEY Ledger Ledger 1
KEY StatryRptCategory StatryRptCategory 2
KEY StatryRptgEntity StatryRptgEntity 2
KEY StatryRptRunID StatryRptRunID 2
KEY ValidityEndDate ValidityEndDate 5
_FiscalYear _FiscalYear 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 4
_JournalEntry _JournalEntry 1
_Ledger _Ledger 1
FinancialStatementItem FinancialStatementItem,MX_SATGLAccountGrouping 4
FinancialStatementNodeType FinancialStatementNodeType 2
GLAccountGroup GLAccountGroup 5
GLAccountInfo GLAccountInfo 6
GLAccountType GLAccountType 6
MX_SATGLAccountGrouping MX_SATGLAccountGrouping 2
OperationalChartOfAccounts OperationalChartOfAccounts 4
OperationalGLAccount OperationalGLAccount 4
ValidityStartDate ValidityStartDate 5
VATRegistration VATRegistration 5

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 FSV (
    ACCOUNTINGDOCUMENT,
    CHARTOFACCOUNTS,
    COMPANYCODE,
    FINANCIALSTATEMENTHIERARCHY,
    FINANCIALSTATEMENTVARIANT,
    FISCALYEAR,
    GLACCOUNT,
    HIERARCHYNODE,
    HIERARCHYNODEUNIQUEID,
    HIERARCHYNODEVAL,
    LEDGER,
    STATRYRPTCATEGORY,
    STATRYRPTGENTITY,
    STATRYRPTRUNID,
    VALIDITYENDDATE,
    _FISCALYEAR,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _JOURNALENTRY,
    _LEDGER,
    FINANCIALSTATEMENTITEM,
    FINANCIALSTATEMENTNODETYPE,
    GLACCOUNTGROUP,
    GLACCOUNTINFO,
    GLACCOUNTTYPE,
    MX_SATGLACCOUNTGROUPING,
    OPERATIONALCHARTOFACCOUNTS,
    OPERATIONALGLACCOUNT,
    VALIDITYSTARTDATE,
    VATREGISTRATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, CHARTOFACCOUNTS, COMPANYCODE, FINANCIALSTATEMENTHIERARCHY, FINANCIALSTATEMENTVARIANT, FISCALYEAR, GLACCOUNT, HIERARCHYNODE, HIERARCHYNODEUNIQUEID, HIERARCHYNODEVAL, LEDGER, STATRYRPTCATEGORY, STATRYRPTGENTITY, STATRYRPTRUNID, VALIDITYENDDATE)
);

Learn More