J_3RM_RN_DOC

Transparent Table Application Table
23 Fields 1 CDS Views

Traceability: RN Movement Documents

J_3RM_RN_DOC is an SAP database table in S/4HANA. Traceability: RN Movement Documents. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RU_TraceabilityMovementDocs view from BASIC Traceability RN Movement Documents

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY rn_reg_id j_3rm_rn_id RNPT Internal Number
KEY rn_reg_year j_3rm_rn_year RNPT Year
KEY rn_reg_movmnt j_3rm_rnmovnr RNPT Item
prim_doc_type j_3rm_primdoctype Assig. Doc. Type
prim_doc_num j_3rm_rn_primdocnr RNPT Assigned Doc
prim_doc_year j_3rm_rn_primdocyr RNPT Assign.Doc Year
prim_doc_pos j_3rm_rn_primdocpos RNPT Assign.Doc Item
mm_invoice_num re_belnr Inv. Doc. No.
mm_invoice_year gjahr Fiscal Year
mm_invoice_pos rblgp Item
fi_invoice_num belnr_d Document Number
fi_invoice_year gjahr Fiscal Year
menge mengev Quantity
tnved j_3rm_tnved TNVED Code
okpd2 j_3rm_rn_okpd2 OKPD2 Code
cancelled_by j_3rm_rn_cancelled_by Cancelled by
created_by xucreated_by Created By
created_on fpfirstdate Date
amount j_3rm_rn_amount RNPT Item Amount
currency waers Currency
operation_date j_3rm_rn_operation_date Operation Date
api_modified j_3rm_rn_by_api Modified by API

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.

-- Traceability: RN Movement Documents
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_3RM_RN_DOC (
    MANDT,            -- Client [mandt]
    RN_REG_ID,        -- RNPT Internal Number [j_3rm_rn_id]
    RN_REG_YEAR,      -- RNPT Year [j_3rm_rn_year]
    RN_REG_MOVMNT,    -- RNPT Item [j_3rm_rnmovnr]
    PRIM_DOC_TYPE,    -- Assig. Doc. Type [j_3rm_primdoctype]
    PRIM_DOC_NUM,     -- RNPT Assigned Doc [j_3rm_rn_primdocnr]
    PRIM_DOC_YEAR,    -- RNPT Assign.Doc Year [j_3rm_rn_primdocyr]
    PRIM_DOC_POS,     -- RNPT Assign.Doc Item [j_3rm_rn_primdocpos]
    MM_INVOICE_NUM,   -- Inv. Doc. No. [re_belnr]
    MM_INVOICE_YEAR,  -- Fiscal Year [gjahr]
    MM_INVOICE_POS,   -- Item [rblgp]
    FI_INVOICE_NUM,   -- Document Number [belnr_d]
    FI_INVOICE_YEAR,  -- Fiscal Year [gjahr]
    MENGE,            -- Quantity [mengev]
    TNVED,            -- TNVED Code [j_3rm_tnved]
    OKPD2,            -- OKPD2 Code [j_3rm_rn_okpd2]
    CANCELLED_BY,     -- Cancelled by [j_3rm_rn_cancelled_by]
    CREATED_BY,       -- Created By [xucreated_by]
    CREATED_ON,       -- Date [fpfirstdate]
    AMOUNT,           -- RNPT Item Amount [j_3rm_rn_amount]
    CURRENCY,         -- Currency [waers]
    OPERATION_DATE,   -- Operation Date [j_3rm_rn_operation_date]
    API_MODIFIED,     -- Modified by API [j_3rm_rn_by_api]
    PRIMARY KEY (MANDT, RN_REG_ID, RN_REG_YEAR, RN_REG_MOVMNT)
);

Learn More