J_3RM_RN_REG

Transparent Table Application Table
24 Fields 1 CDS Views

Traceability: RN registration entry

J_3RM_RN_REG is an SAP database table in S/4HANA. Traceability: RN registration entry. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RU_TraceabilityRegnNumber view from BASIC Traceability RN registration entry

Fields (24)

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
rn_ext_num J_3RM_RN_EXT_NUM RNPT External No.
rn_reg_date J_3RM_RN_DATE RNPT Creat. Date
src_oper_type J_3RM_RN_SRC_TYPE Source Oper. Type
manually_created J_3RM_RN_MAN RNPT Reg. Man.
matnr MATNR Material
asset_num ANLN1 Asset
asset_subnum ANLN2 Sub-number
company_code BUKRS Company Code
country_of_origin HERKL C/R of Origin
batch CHARG_D Batch
serial_number GERNR Serial Number
wbs_element PS_PSP_PNR WBS Element
invest_order AUFNR Order
meins MEINS Base Unit
avail_quantity J_3RM_RN_AVQUANT Avail. RNPT Quant.
spcl_stock_ind J_3RM_RN_SPECIAL_STOCK_IND RNPT Sp. Stock
status J_3RL_RNSTAT RNPT Validity Status
created_by XUCREATED_BY Created By
created_on FPFIRSTDATE Date
changed_by LAST_USER Last Changed By
changed_on AEDAT Changed On

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 registration entry
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_3RM_RN_REG (
    MANDT,              -- Client [MANDT]
    RN_REG_ID,          -- RNPT Internal Number [J_3RM_RN_ID]
    RN_REG_YEAR,        -- RNPT Year [J_3RM_RN_YEAR]
    RN_EXT_NUM,         -- RNPT External No. [J_3RM_RN_EXT_NUM]
    RN_REG_DATE,        -- RNPT Creat. Date [J_3RM_RN_DATE]
    SRC_OPER_TYPE,      -- Source Oper. Type [J_3RM_RN_SRC_TYPE]
    MANUALLY_CREATED,   -- RNPT Reg. Man. [J_3RM_RN_MAN]
    MATNR,              -- Material [MATNR]
    ASSET_NUM,          -- Asset [ANLN1]
    ASSET_SUBNUM,       -- Sub-number [ANLN2]
    COMPANY_CODE,       -- Company Code [BUKRS]
    COUNTRY_OF_ORIGIN,  -- C/R of Origin [HERKL]
    BATCH,              -- Batch [CHARG_D]
    SERIAL_NUMBER,      -- Serial Number [GERNR]
    WBS_ELEMENT,        -- WBS Element [PS_PSP_PNR]
    INVEST_ORDER,       -- Order [AUFNR]
    MEINS,              -- Base Unit [MEINS]
    AVAIL_QUANTITY,     -- Avail. RNPT Quant. [J_3RM_RN_AVQUANT]
    SPCL_STOCK_IND,     -- RNPT Sp. Stock [J_3RM_RN_SPECIAL_STOCK_IND]
    STATUS,             -- RNPT Validity Status [J_3RL_RNSTAT]
    CREATED_BY,         -- Created By [XUCREATED_BY]
    CREATED_ON,         -- Date [FPFIRSTDATE]
    CHANGED_BY,         -- Last Changed By [LAST_USER]
    CHANGED_ON,         -- Changed On [AEDAT]
    PRIMARY KEY (MANDT, RN_REG_ID, RN_REG_YEAR)
);

Learn More