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