J_3RS_EXP_ITM_D

Transparent Table Application Table
30 Fields 1 CDS Views

Draft table for J_3RSCCDSUBITM

J_3RS_EXP_ITM_D is an SAP database table in S/4HANA. Draft table for J_3RSCCDSUBITM. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_RU_ExprtCstmsDeclnItemDraft view from BASIC Export Customs Declaration Item Draft

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY customsdeclaration j_3rs_ccd_beln Cus. Decl. No.
KEY ru_exprtcustomsdeclarationitem j_3rs_ccditemid CDec Item No.
KEY customsdeclarationsubitem j_3rs_ccdsubid Subitem Number
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
material matnr Material
ru_contractdocument j_3rs_cntrbeln Contract Number
tradingcontractitem j_3rs_cntrpsnr Contract Item
ru_temporarycustomsdeclaration j_3rs_src_ccd Reference CDec
ru_tmpcstmsdeclarationitem j_3rs_src_ccditem Ref. CDec Item
salesorder j_3rs_ordbeln Order Number
salesorderitem j_3rs_ordpsnr Order Item
cstmsdeclnitemquantity j_3rs_lsmeng CDec Item Qty
unitofmeasure vrkme Sales Unit
deliverydocument vbeln_vl Delivery
deliverydocumentitem posnr_vl Item
billingdocument j_3rs_vbeln_vf Billing Doc.
billingdocumentitem j_3rs_posnr_vf Item
billingquantity fkimg Invoiced Qty
billingquantityunit vrkme Sales Unit
exportconfirmationsubitemdate j_3rs_reg_expconfdate Export Confirm. Date
goodsissuedate j_3rs_excd_goods_issue_date Goods Issue Date CCD
cstmsdeclnsubitemquantity j_3rs_lsmeng_sub1 Subitem Qty
cstmsdeclnsubitemsalesunit vrkme Sales Unit
totalconfirmedquantity glo_fin_exprt_cd_ttlcnfq_nocnv Total to Be Confirmed
salesunit vrkme Sales Unit
openquantity glo_fin_exprt_cd_openq_no_conv Open Quantity
cstmsdeclnhasfollowupdocument glo_fin_exprt_cd_followup Follow-Up
companycode bukrs Company Code

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.

-- Draft table for J_3RSCCDSUBITM
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_3RS_EXP_ITM_D (
    MANDT,                           -- Client [mandt]
    CUSTOMSDECLARATION,              -- Cus. Decl. No. [j_3rs_ccd_beln]
    RU_EXPRTCUSTOMSDECLARATIONITEM,  -- CDec Item No. [j_3rs_ccditemid]
    CUSTOMSDECLARATIONSUBITEM,       -- Subitem Number [j_3rs_ccdsubid]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    MATERIAL,                        -- Material [matnr]
    RU_CONTRACTDOCUMENT,             -- Contract Number [j_3rs_cntrbeln]
    TRADINGCONTRACTITEM,             -- Contract Item [j_3rs_cntrpsnr]
    RU_TEMPORARYCUSTOMSDECLARATION,  -- Reference CDec [j_3rs_src_ccd]
    RU_TMPCSTMSDECLARATIONITEM,      -- Ref. CDec Item [j_3rs_src_ccditem]
    SALESORDER,                      -- Order Number [j_3rs_ordbeln]
    SALESORDERITEM,                  -- Order Item [j_3rs_ordpsnr]
    CSTMSDECLNITEMQUANTITY,          -- CDec Item Qty [j_3rs_lsmeng]
    UNITOFMEASURE,                   -- Sales Unit [vrkme]
    DELIVERYDOCUMENT,                -- Delivery [vbeln_vl]
    DELIVERYDOCUMENTITEM,            -- Item [posnr_vl]
    BILLINGDOCUMENT,                 -- Billing Doc. [j_3rs_vbeln_vf]
    BILLINGDOCUMENTITEM,             -- Item [j_3rs_posnr_vf]
    BILLINGQUANTITY,                 -- Invoiced Qty [fkimg]
    BILLINGQUANTITYUNIT,             -- Sales Unit [vrkme]
    EXPORTCONFIRMATIONSUBITEMDATE,   -- Export Confirm. Date [j_3rs_reg_expconfdate]
    GOODSISSUEDATE,                  -- Goods Issue Date CCD [j_3rs_excd_goods_issue_date]
    CSTMSDECLNSUBITEMQUANTITY,       -- Subitem Qty [j_3rs_lsmeng_sub1]
    CSTMSDECLNSUBITEMSALESUNIT,      -- Sales Unit [vrkme]
    TOTALCONFIRMEDQUANTITY,          -- Total to Be Confirmed [glo_fin_exprt_cd_ttlcnfq_nocnv]
    SALESUNIT,                       -- Sales Unit [vrkme]
    OPENQUANTITY,                    -- Open Quantity [glo_fin_exprt_cd_openq_no_conv]
    CSTMSDECLNHASFOLLOWUPDOCUMENT,   -- Follow-Up [glo_fin_exprt_cd_followup]
    COMPANYCODE,                     -- Company Code [bukrs]
    PRIMARY KEY (MANDT, CUSTOMSDECLARATION, RU_EXPRTCUSTOMSDECLARATIONITEM, CUSTOMSDECLARATIONSUBITEM, DRAFTUUID)
);

Learn More