FICODIANC_CNPT_T

Transparent Table Customizing Table

DIAN Item Type (Concept) Text Table

FICODIANC_CNPT_T is an SAP database table in S/4HANA. DIAN Item Type (Concept) Text Table. It contains 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CO_DIANItemTypeText view from BASIC DIAN Item Type Text

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY langu SPRAS Language
KEY rpt_format FICODIAN_REPORT_FORMAT Report Format
KEY cpt_code FICODIAN_CONCEPT_CODE Item Type
KEY valid_from FICODIAN_VALID_FROM Valid From
description FICODIAN_CONCEPT_CODE_DESC Item Type Desc.

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 Item Type (Concept) Text Table
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FICODIANC_CNPT_T (
    MANDT,        -- Client [MANDT]
    LANGU,        -- Language [SPRAS]
    RPT_FORMAT,   -- Report Format [FICODIAN_REPORT_FORMAT]
    CPT_CODE,     -- Item Type [FICODIAN_CONCEPT_CODE]
    VALID_FROM,   -- Valid From [FICODIAN_VALID_FROM]
    DESCRIPTION,  -- Item Type Desc. [FICODIAN_CONCEPT_CODE_DESC]
    PRIMARY KEY (MANDT, LANGU, RPT_FORMAT, CPT_CODE, VALID_FROM)
);