J_3RSCCDITEM

Transparent Table Application Table
39 Fields 1 CDS Views

Export GTD Item

J_3RSCCDITEM is an SAP database table in S/4HANA. Export GTD Item. It contains 39 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RU_CustomsDeclarationItem view from BASIC CCD Item

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY ccd j_3rs_ccd_beln Cus. Decl. No.
KEY item j_3rs_ccditemid CDec Item No.
page_num j_3rs_pgnum Page Number
src_ccd j_3rs_src_ccd Reference CDec
src_item j_3rs_src_ccditem Ref. CDec Item
stawn stawn Commodity Code
herkl herkl C/R of Origin
netwr j_3rs_netwr Net Value
lsmeng j_3rs_lsmeng CDec Item Qty
edatu edatu Delivery Date
brgew brgew Gross Weight
ntgew ntgew Net Weight
gewei gewei Unit of Weight
transp_obj1 j_3rs_transp_obj1 Packgng Data 1
transp_obj2 j_3rs_transp_obj2 Packgng Data 2
add_info j_3rs_add_info Additional Info
matnr matnr Material
cntr_bln j_3rs_cntrbeln Contract Number
cntr_psnr j_3rs_cntrpsnr Contract Item
ord_bln j_3rs_ordbeln Order Number
ord_psnr j_3rs_ordpsnr Order Item
export_allowed j_3rs_expal Exp. Appr. Date
meins meins Base Unit
vrkme vrkme Sales Unit
waers waers Currency
lwaers j_3rs_lwaers Local Currency
kursk kursk Exchange Rate
umziz j_3rs_umziz Conv. F. Num.
umzin j_3rs_umzin Conv. F. Denom.
sd1_rate j_3rs_sd1rate Duty Rate 1
sd1_amount j_3rs_sd1am Duty Amount 1
sd1_type j_3rs_sd1type Duty Type 1
sd2_amount j_3rs_sd2am Duty Amount 2
sd2_type j_3rs_sd2type Duty Type 2
sd3_amount j_3rs_sd3am Duty Amount 3
sd3_type j_3rs_sd3type Duty Type 3
add_txt1 j_3rs_addtxt1 Add. Text 1
add_txt2 j_3rs_addtxt2 Add. Text 2

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 Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_3RSCCDITEM (
    MANDT,           -- Client [mandt]
    CCD,             -- Cus. Decl. No. [j_3rs_ccd_beln]
    ITEM,            -- CDec Item No. [j_3rs_ccditemid]
    PAGE_NUM,        -- Page Number [j_3rs_pgnum]
    SRC_CCD,         -- Reference CDec [j_3rs_src_ccd]
    SRC_ITEM,        -- Ref. CDec Item [j_3rs_src_ccditem]
    STAWN,           -- Commodity Code [stawn]
    HERKL,           -- C/R of Origin [herkl]
    NETWR,           -- Net Value [j_3rs_netwr]
    LSMENG,          -- CDec Item Qty [j_3rs_lsmeng]
    EDATU,           -- Delivery Date [edatu]
    BRGEW,           -- Gross Weight [brgew]
    NTGEW,           -- Net Weight [ntgew]
    GEWEI,           -- Unit of Weight [gewei]
    TRANSP_OBJ1,     -- Packgng Data 1 [j_3rs_transp_obj1]
    TRANSP_OBJ2,     -- Packgng Data 2 [j_3rs_transp_obj2]
    ADD_INFO,        -- Additional Info [j_3rs_add_info]
    MATNR,           -- Material [matnr]
    CNTR_BLN,        -- Contract Number [j_3rs_cntrbeln]
    CNTR_PSNR,       -- Contract Item [j_3rs_cntrpsnr]
    ORD_BLN,         -- Order Number [j_3rs_ordbeln]
    ORD_PSNR,        -- Order Item [j_3rs_ordpsnr]
    EXPORT_ALLOWED,  -- Exp. Appr. Date [j_3rs_expal]
    MEINS,           -- Base Unit [meins]
    VRKME,           -- Sales Unit [vrkme]
    WAERS,           -- Currency [waers]
    LWAERS,          -- Local Currency [j_3rs_lwaers]
    KURSK,           -- Exchange Rate [kursk]
    UMZIZ,           -- Conv. F. Num. [j_3rs_umziz]
    UMZIN,           -- Conv. F. Denom. [j_3rs_umzin]
    SD1_RATE,        -- Duty Rate 1 [j_3rs_sd1rate]
    SD1_AMOUNT,      -- Duty Amount 1 [j_3rs_sd1am]
    SD1_TYPE,        -- Duty Type 1 [j_3rs_sd1type]
    SD2_AMOUNT,      -- Duty Amount 2 [j_3rs_sd2am]
    SD2_TYPE,        -- Duty Type 2 [j_3rs_sd2type]
    SD3_AMOUNT,      -- Duty Amount 3 [j_3rs_sd3am]
    SD3_TYPE,        -- Duty Type 3 [j_3rs_sd3type]
    ADD_TXT1,        -- Add. Text 1 [j_3rs_addtxt1]
    ADD_TXT2,        -- Add. Text 2 [j_3rs_addtxt2]
    PRIMARY KEY (MANDT, CCD, ITEM)
);

Learn More