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