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