FIRUD_TROP_RPITM

Transparent Table Application Table
28 Fields 1 CDS Views

ACR Log Table for Traceability Operations

FIRUD_TROP_RPITM is an SAP database table in S/4HANA. ACR Log Table for Traceability Operations. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RU_TraceabilityOpsRptgItem view from BASIC ACR Log Table for Traceability Operations

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY statryrptgentity SRF_REPORTING_ENTITY Reporting Entity
KEY statryrptcategory SRF_REP_CAT_ID Report ID
KEY statryrptrunid SRF_REPORT_RUN_ID Report Run ID
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
KEY companycode BUKRS Company Code
operation_date J_3RM_RN_OPERATION_DATE Operation Date
rn_oper J_3RM_RN_OPERCODE Code of Operation
legaldocumenttype FIRU_LEGALDOCUMENTTYPE External Doc. Type
legaldocumentnum FIRU_LEGALDOCUMENTNUMBER External Doc. Number
legaldocumentdate FIRU_LEGALDOCUMENTDATE External Doc. Date
businesspartnername FIRU_PARTNER_NAME BP Name
ru_partnerorganizationinn FIRU_PARTNER_INN BP INN
ru_partnerorganizationkpp FIRU_PARTNER_KPP BP KPP
lastname FIRU_PARTNER_PERS_LAST_NAME BP Pers. Last Nm
firstname FIRU_PARTNER_PERS_FIRST_NAME BP Pers. Frst Nm
middlename FIRU_PARTNER_PERS_MIDDLE_NAME BP Pers. Mid Nm
ru_partnerpersoninn FIRU_PARTNER_PERS_INN BP Pers. INN
rn_ext_num J_3RM_RN_EXT_NUM RNPT External No.
baseunitofmeasure MEINS Base Unit
quantity MENGEV Quantity
totalamountinlocalcurrency J_3RM_RN_AMOUNT RNPT Item Amount
currency WAERS Currency
goodsmovementtype BWART Movement Type
assettransactiontype ANBWA Ast Transaction Type
taxcode FIS_MWSKZ Tax 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.

-- ACR Log Table for Traceability Operations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIRUD_TROP_RPITM (
    MANDT,                       -- Client [MANDT]
    STATRYRPTGENTITY,            -- Reporting Entity [SRF_REPORTING_ENTITY]
    STATRYRPTCATEGORY,           -- Report ID [SRF_REP_CAT_ID]
    STATRYRPTRUNID,              -- Report Run ID [SRF_REPORT_RUN_ID]
    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]
    COMPANYCODE,                 -- Company Code [BUKRS]
    OPERATION_DATE,              -- Operation Date [J_3RM_RN_OPERATION_DATE]
    RN_OPER,                     -- Code of Operation [J_3RM_RN_OPERCODE]
    LEGALDOCUMENTTYPE,           -- External Doc. Type [FIRU_LEGALDOCUMENTTYPE]
    LEGALDOCUMENTNUM,            -- External Doc. Number [FIRU_LEGALDOCUMENTNUMBER]
    LEGALDOCUMENTDATE,           -- External Doc. Date [FIRU_LEGALDOCUMENTDATE]
    BUSINESSPARTNERNAME,         -- BP Name [FIRU_PARTNER_NAME]
    RU_PARTNERORGANIZATIONINN,   -- BP INN [FIRU_PARTNER_INN]
    RU_PARTNERORGANIZATIONKPP,   -- BP KPP [FIRU_PARTNER_KPP]
    LASTNAME,                    -- BP Pers. Last Nm [FIRU_PARTNER_PERS_LAST_NAME]
    FIRSTNAME,                   -- BP Pers. Frst Nm [FIRU_PARTNER_PERS_FIRST_NAME]
    MIDDLENAME,                  -- BP Pers. Mid Nm [FIRU_PARTNER_PERS_MIDDLE_NAME]
    RU_PARTNERPERSONINN,         -- BP Pers. INN [FIRU_PARTNER_PERS_INN]
    RN_EXT_NUM,                  -- RNPT External No. [J_3RM_RN_EXT_NUM]
    BASEUNITOFMEASURE,           -- Base Unit [MEINS]
    QUANTITY,                    -- Quantity [MENGEV]
    TOTALAMOUNTINLOCALCURRENCY,  -- RNPT Item Amount [J_3RM_RN_AMOUNT]
    CURRENCY,                    -- Currency [WAERS]
    GOODSMOVEMENTTYPE,           -- Movement Type [BWART]
    ASSETTRANSACTIONTYPE,        -- Ast Transaction Type [ANBWA]
    TAXCODE,                     -- Tax Code [FIS_MWSKZ]
    PRIMARY KEY (MANDT, STATRYRPTGENTITY, STATRYRPTCATEGORY, STATRYRPTRUNID, RN_REG_ID, RN_REG_YEAR, RN_REG_MOVMNT, COMPANYCODE)
);

Learn More