J_3RSCCDHEADER

Transparent Table Application Table
44 Fields 1 CDS Views

Export GTD Header

J_3RSCCDHEADER is an SAP database table in S/4HANA. Export GTD Header. It contains 44 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RU_CustomsDeclarationHeader view from BASIC CCD Header

Fields (44)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ccd j_3rs_ccd_beln Cus. Decl. No.
bukrs bukrs Company Code
type j_3rs_ccd_type Cus. Decl. Type
pod j_3rs_podint Int.Exp/Imp.Cont.No.
status j_3rs_ccd_status CDec Status
destcntry j_3rs_destcntry Trnst Cntry/Reg
tradcntry j_3rs_tradcntry Trad. Cntry/Reg
declrtcod j_3rs_declarantcode Declarant
aland_dep j_3rs_aland_dep Dep. Cntry/Reg.
aland_dest j_3rs_aland_dest Dest. Cntry/Reg
aland_trans j_3rs_aland_trans Vehicle Ctry/Rg
idtransp j_3rs_idtransp Vehicle ID
kursk kursk Exchange Rate
custcode j_3rs_custom_code Customs Office
goodlctn j_3rs_goodsloctn Goods Location
kunwe j_3rs_kunwe Ship-to Party
kunag kunag Sold-to Party
waers waers Currency
lwaers j_3rs_lwaers Local Currency
behoe_p1 j_3rs_behoe Reg. Cust. Off.
date_p2 j_3rs_date CDec Reg. Date
extn_p3 j_3rs_extnum CDec Ext. No.
crbdr j_3rs_crbrder Cross Border Date
knumv j_3rs_knumv Doc. Condition
add_txt1 j_3rs_addtxt1 Add. Text 1
add_txt2 j_3rs_addtxt2 Add. Text 2
fee_rate j_3rs_feerate Fee Rate
fee_am j_3rs_feeam Fee Amount
fee_type j_3rs_feetype Fee Type
subtotal3 j_3rs_subtot3 Subtotal 3
subtotal4 j_3rs_subtot4 Subtotal 4
subtotal5 j_3rs_subtot5 Subtotal 5
subtotal6 j_3rs_subtot6 Subtotal 6
vehicle_tp j_3rs_vehtyp_brd Shp Type Border
expconfdate j_3rs_reg_expconfdate Export Confirm. Date
transporttype j_3rs_reg_tr_type Transportation Type
typtransportdoc j_3rs_reg_tr_doc_type Type of Transp. Doc.
issue_date j_3rs_issue_date Issue Allowed Date
goods_issue_date j_3rs_excd_goods_issue_date Goods Issue Date CCD
created_by usnam User Name
changed_by usnam User Name
created_at timestamp Time Stamp
changed_at timestamp Time Stamp

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.

-- Export GTD Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_3RSCCDHEADER (
    MANDT,             -- Client [mandt]
    CCD,               -- Cus. Decl. No. [j_3rs_ccd_beln]
    BUKRS,             -- Company Code [bukrs]
    TYPE,              -- Cus. Decl. Type [j_3rs_ccd_type]
    POD,               -- Int.Exp/Imp.Cont.No. [j_3rs_podint]
    STATUS,            -- CDec Status [j_3rs_ccd_status]
    DESTCNTRY,         -- Trnst Cntry/Reg [j_3rs_destcntry]
    TRADCNTRY,         -- Trad. Cntry/Reg [j_3rs_tradcntry]
    DECLRTCOD,         -- Declarant [j_3rs_declarantcode]
    ALAND_DEP,         -- Dep. Cntry/Reg. [j_3rs_aland_dep]
    ALAND_DEST,        -- Dest. Cntry/Reg [j_3rs_aland_dest]
    ALAND_TRANS,       -- Vehicle Ctry/Rg [j_3rs_aland_trans]
    IDTRANSP,          -- Vehicle ID [j_3rs_idtransp]
    KURSK,             -- Exchange Rate [kursk]
    CUSTCODE,          -- Customs Office [j_3rs_custom_code]
    GOODLCTN,          -- Goods Location [j_3rs_goodsloctn]
    KUNWE,             -- Ship-to Party [j_3rs_kunwe]
    KUNAG,             -- Sold-to Party [kunag]
    WAERS,             -- Currency [waers]
    LWAERS,            -- Local Currency [j_3rs_lwaers]
    BEHOE_P1,          -- Reg. Cust. Off. [j_3rs_behoe]
    DATE_P2,           -- CDec Reg. Date [j_3rs_date]
    EXTN_P3,           -- CDec Ext. No. [j_3rs_extnum]
    CRBDR,             -- Cross Border Date [j_3rs_crbrder]
    KNUMV,             -- Doc. Condition [j_3rs_knumv]
    ADD_TXT1,          -- Add. Text 1 [j_3rs_addtxt1]
    ADD_TXT2,          -- Add. Text 2 [j_3rs_addtxt2]
    FEE_RATE,          -- Fee Rate [j_3rs_feerate]
    FEE_AM,            -- Fee Amount [j_3rs_feeam]
    FEE_TYPE,          -- Fee Type [j_3rs_feetype]
    SUBTOTAL3,         -- Subtotal 3 [j_3rs_subtot3]
    SUBTOTAL4,         -- Subtotal 4 [j_3rs_subtot4]
    SUBTOTAL5,         -- Subtotal 5 [j_3rs_subtot5]
    SUBTOTAL6,         -- Subtotal 6 [j_3rs_subtot6]
    VEHICLE_TP,        -- Shp Type Border [j_3rs_vehtyp_brd]
    EXPCONFDATE,       -- Export Confirm. Date [j_3rs_reg_expconfdate]
    TRANSPORTTYPE,     -- Transportation Type [j_3rs_reg_tr_type]
    TYPTRANSPORTDOC,   -- Type of Transp. Doc. [j_3rs_reg_tr_doc_type]
    ISSUE_DATE,        -- Issue Allowed Date [j_3rs_issue_date]
    GOODS_ISSUE_DATE,  -- Goods Issue Date CCD [j_3rs_excd_goods_issue_date]
    CREATED_BY,        -- User Name [usnam]
    CHANGED_BY,        -- User Name [usnam]
    CREATED_AT,        -- Time Stamp [timestamp]
    CHANGED_AT,        -- Time Stamp [timestamp]
    PRIMARY KEY (MANDT, CCD)
);

Learn More