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