J_3RFGTD_ITEM

Transparent Table Application Table
46 Fields 2 CDS Views

Import Customs Declaration Items

J_3RFGTD_ITEM is an SAP database table in S/4HANA. Import Customs Declaration Items. It contains 46 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_RU_ImprtCstmsDecln view inner BASIC FI RU Import Customs Declaration
I_RU_ImprtCstmsDeclnItem view from BASIC Import customs declarations items data

Fields (46)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY gtd_id J_3RF_IMCD_BELN Int. CustDecl No
KEY posnr J_3RF_GTDPOSNR Tech. Line ID
gtdpos J_3RF_GTDITEM Customs Dec. Item No
matnr MATNR Material
menge J_3RF_GTDMENGE Qty in Base UoM
meins LAGME Base Unit
pmenge BSTMG PO Quantity
pmeins BSTME Order Unit
brgew BRGEW Gross Weight
ntgew NTGEW Net Weight
gewei GEWEI Unit of Weight
ordernum EBELN Purchasing Doc.
orderpos EBELP Item
indelnum J_3RF_VBELN_VL Delivery
indelpos J_3RF_POSNR_VL Item
mmdocnum MBLNR Material Doc.
mmdocjahr MJAHR Mat. Doc. Year
mmdocpos MBLPO Mat. Doc.Item
ebeln J_3RF_EBELN Source PurchDoc
ebelp J_3RF_EBELP Item
billref J_3RF_BILLREF Billing Doc. Ref.
incoming_invoice J_3RF_IMCD_INCINV Incoming Invoice
exch_typ J_3RFINV_EXCHTYP Exchange Format
herkl HERKL C/R of Origin
stawn STAWN Commodity Code
netwr J_3RF_INV_COST Invoice Cost
customs_cost J_3RF_CUST_COST Customs Cost
mwskz MWSKZ Tax Code
vat_base J_3RF_VAT_BASE VAT Base
calc_duties_am J_3RF_CALC_DUTY_AM Calc Cust Duty
calc_duties_rate J_3RF_CALC_DUTY_RATE Duty Rate
calc_duties_type J_3RF_CALC_DUTY_TYPE Duty Type
calc_vat J_3RF_CALC_VAT_AM Calc VAT Amount
act_cust_duties J_3RF_DUTY_AM Duty Amount
act_cust_vat J_3RF_VAT_AM VAT Amount
excise_am J_3RF_EXCISE_AM Excise Amount
gtdtstamp J_3RF_GTDTSCRE Cust. Decl. Creation
creuser J_3RF_GTDUSERCRE Created By
chgtstamp J_3RF_GTDTSCHG Date/Time of Change
chguser J_3RF_GTDUSERCHG Last Changed By
umrez UMBSZ Equal To
umren UMBSN Denominator
fl_tracking J_3RF_FL_TRACKING No GTD Tracking
fees_am J_3RS_FEEAM Fee Amount
additional_cost J_3RF_ADDITIONAL_COST Additional Cost

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.

-- Import Customs Declaration Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_3RFGTD_ITEM (
    MANDT,             -- Client [MANDT]
    GTD_ID,            -- Int. CustDecl No [J_3RF_IMCD_BELN]
    POSNR,             -- Tech. Line ID [J_3RF_GTDPOSNR]
    GTDPOS,            -- Customs Dec. Item No [J_3RF_GTDITEM]
    MATNR,             -- Material [MATNR]
    MENGE,             -- Qty in Base UoM [J_3RF_GTDMENGE]
    MEINS,             -- Base Unit [LAGME]
    PMENGE,            -- PO Quantity [BSTMG]
    PMEINS,            -- Order Unit [BSTME]
    BRGEW,             -- Gross Weight [BRGEW]
    NTGEW,             -- Net Weight [NTGEW]
    GEWEI,             -- Unit of Weight [GEWEI]
    ORDERNUM,          -- Purchasing Doc. [EBELN]
    ORDERPOS,          -- Item [EBELP]
    INDELNUM,          -- Delivery [J_3RF_VBELN_VL]
    INDELPOS,          -- Item [J_3RF_POSNR_VL]
    MMDOCNUM,          -- Material Doc. [MBLNR]
    MMDOCJAHR,         -- Mat. Doc. Year [MJAHR]
    MMDOCPOS,          -- Mat. Doc.Item [MBLPO]
    EBELN,             -- Source PurchDoc [J_3RF_EBELN]
    EBELP,             -- Item [J_3RF_EBELP]
    BILLREF,           -- Billing Doc. Ref. [J_3RF_BILLREF]
    INCOMING_INVOICE,  -- Incoming Invoice [J_3RF_IMCD_INCINV]
    EXCH_TYP,          -- Exchange Format [J_3RFINV_EXCHTYP]
    HERKL,             -- C/R of Origin [HERKL]
    STAWN,             -- Commodity Code [STAWN]
    NETWR,             -- Invoice Cost [J_3RF_INV_COST]
    CUSTOMS_COST,      -- Customs Cost [J_3RF_CUST_COST]
    MWSKZ,             -- Tax Code [MWSKZ]
    VAT_BASE,          -- VAT Base [J_3RF_VAT_BASE]
    CALC_DUTIES_AM,    -- Calc Cust Duty [J_3RF_CALC_DUTY_AM]
    CALC_DUTIES_RATE,  -- Duty Rate [J_3RF_CALC_DUTY_RATE]
    CALC_DUTIES_TYPE,  -- Duty Type [J_3RF_CALC_DUTY_TYPE]
    CALC_VAT,          -- Calc VAT Amount [J_3RF_CALC_VAT_AM]
    ACT_CUST_DUTIES,   -- Duty Amount [J_3RF_DUTY_AM]
    ACT_CUST_VAT,      -- VAT Amount [J_3RF_VAT_AM]
    EXCISE_AM,         -- Excise Amount [J_3RF_EXCISE_AM]
    GTDTSTAMP,         -- Cust. Decl. Creation [J_3RF_GTDTSCRE]
    CREUSER,           -- Created By [J_3RF_GTDUSERCRE]
    CHGTSTAMP,         -- Date/Time of Change [J_3RF_GTDTSCHG]
    CHGUSER,           -- Last Changed By [J_3RF_GTDUSERCHG]
    UMREZ,             -- Equal To [UMBSZ]
    UMREN,             -- Denominator [UMBSN]
    FL_TRACKING,       -- No GTD Tracking [J_3RF_FL_TRACKING]
    FEES_AM,           -- Fee Amount [J_3RS_FEEAM]
    ADDITIONAL_COST,   -- Additional Cost [J_3RF_ADDITIONAL_COST]
    PRIMARY KEY (MANDT, GTD_ID, POSNR)
);

Learn More