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