J_1BTCESTDET

Transparent Table Customizing Table

ICMS ST Legal Classification Code Determination

J_1BTCESTDET is an SAP database table in S/4HANA. ICMS ST Legal Classification Code Determination. It contains 5 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BR_CESTDetermination view from BASIC Brazil ICMS ST Legal Classification Code

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY valid_from j_1bdatein Initial Date
KEY ncm steuc Control Code
KEY material matnr Material
cest j_1bcest ICMS ST Lgl.Class.Cd

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.

-- ICMS ST Legal Classification Code Determination
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1BTCESTDET (
    MANDT,       -- Client [mandt]
    VALID_FROM,  -- Initial Date [j_1bdatein]
    NCM,         -- Control Code [steuc]
    MATERIAL,    -- Material [matnr]
    CEST,        -- ICMS ST Lgl.Class.Cd [j_1bcest]
    PRIMARY KEY (MANDT, VALID_FROM, NCM, MATERIAL)
);