FICODIANC_VAT

Transparent Table Customizing Table
9 Fields 1 CDS Views

DIAN Tax Codes

FICODIANC_VAT is an SAP database table in S/4HANA. DIAN Tax Codes. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CO_DIANTaxCode view from BASIC DIAN Tax Code

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 vat_tax_procedure kalsm_d Procedure
KEY vat_code mwskz Tax Code
KEY account_key kvsl1 Account Key
KEY valid_from ficodian_valid_from Valid From
valid_to ficodian_valid_to Valid 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.

-- DIAN Tax Codes
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FICODIANC_VAT (
    MANDT,              -- Client [mandt]
    RPT_FORMAT,         -- Report Format [ficodian_report_format]
    CPT_CODE,           -- Item Type [ficodian_concept_code]
    VAT_TAX_PROCEDURE,  -- Procedure [kalsm_d]
    VAT_CODE,           -- Tax Code [mwskz]
    ACCOUNT_KEY,        -- Account Key [kvsl1]
    VALID_FROM,         -- Valid From [ficodian_valid_from]
    VALID_TO,           -- Valid To [ficodian_valid_to]
    CLF_CODE,           -- Amount Classif. [ficodian_clsfctn_id]
    PRIMARY KEY (MANDT, RPT_FORMAT, CPT_CODE, VAT_TAX_PROCEDURE, VAT_CODE, ACCOUNT_KEY, VALID_FROM)
);

Learn More