FICODIANC_GLA

Transparent Table Customizing Table

G/L Account for DIAN

FICODIANC_GLA is an SAP database table in S/4HANA. G/L Account for DIAN. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CO_DIANGeneralLedgerAccount view from BASIC DIAN General Ledger Account

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rpt_format FICODIAN_REPORT_FORMAT Report Format
KEY cpt_code FICODIAN_CONCEPT_CODE Item Type
KEY company_code BUKRS Company Code
KEY valid_from FICODIAN_VALID_FROM Valid From
KEY gl_account_from GACCOUNTFR From G/L Acct
valid_to FICODIAN_VALID_TO Valid To
gl_account_to GACCOUNTTO G/L Account To
clf_code FICODIAN_CLSFCTN_ID Amount Classif.

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.

-- G/L Account for DIAN
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FICODIANC_GLA (
    MANDT,            -- Client [MANDT]
    RPT_FORMAT,       -- Report Format [FICODIAN_REPORT_FORMAT]
    CPT_CODE,         -- Item Type [FICODIAN_CONCEPT_CODE]
    COMPANY_CODE,     -- Company Code [BUKRS]
    VALID_FROM,       -- Valid From [FICODIAN_VALID_FROM]
    GL_ACCOUNT_FROM,  -- From G/L Acct [GACCOUNTFR]
    VALID_TO,         -- Valid To [FICODIAN_VALID_TO]
    GL_ACCOUNT_TO,    -- G/L Account To [GACCOUNTTO]
    CLF_CODE,         -- Amount Classif. [FICODIAN_CLSFCTN_ID]
    PRIMARY KEY (MANDT, RPT_FORMAT, CPT_CODE, COMPANY_CODE, VALID_FROM, GL_ACCOUNT_FROM)
);