J_3RS_EXP_ITM_D

Transparent Table Application Table
34 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 34 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 (34)

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
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
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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]
    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]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, CUSTOMSDECLARATION, RU_EXPRTCUSTOMSDECLARATIONITEM, CUSTOMSDECLARATIONSUBITEM)
);

Learn More