J_1AFRID

Transparent Table Customizing Table
4 Fields 1 CDS Views

Tax Code for Foreign Nationals

J_1AFRID is an SAP database table in S/4HANA. Tax Code for Foreign Nationals. It contains 4 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_Ar_FrgnNatlTxCode view from BASIC Unique Tax Identification Number for Foreign Nationals

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY land1 land1 Country/Reg.
KEY stkzn stkzn Natural person
j_1afpid j_1afpid F nat. tax 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.

-- Tax Code for Foreign Nationals
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1AFRID (
    MANDT,     -- Client [mandt]
    LAND1,     -- Country/Reg. [land1]
    STKZN,     -- Natural person [stkzn]
    J_1AFPID,  -- F nat. tax code [j_1afpid]
    PRIMARY KEY (MANDT, LAND1, STKZN)
);

Learn More