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