J_1ATXOFF

Transparent Table Customizing Table
6 Fields 1 CDS Views

Official Codes per tax

J_1ATXOFF is an SAP database table in S/4HANA. Official Codes per tax. It contains 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_AR_NationalTaxCode view_entity from BASIC National Tax Code

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY land1 land1 Country/Reg.
KEY j_1ataxcod j_1ataxcod Off. Code
text40 fiwtgen_text40 Name
j_1anatxcd j_1anatxcd Nat. Tax Code
def_cond_code fiwtar_defcondcode Def Condition Code

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.

-- Official Codes per tax
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1ATXOFF (
    MANDT,          -- Client [mandt]
    LAND1,          -- Country/Reg. [land1]
    J_1ATAXCOD,     -- Off. Code [j_1ataxcod]
    TEXT40,         -- Name [fiwtgen_text40]
    J_1ANATXCD,     -- Nat. Tax Code [j_1anatxcd]
    DEF_COND_CODE,  -- Def Condition Code [fiwtar_defcondcode]
    PRIMARY KEY (MANDT, LAND1, J_1ATAXCOD)
);

Learn More