J_3RF_REGINV_IN

Transparent Table Application Table
71 Fields 1 CDS Views

Incoming Invoice Registration Journal

J_3RF_REGINV_IN is an SAP database table in S/4HANA. Incoming Invoice Registration Journal. It contains 71 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_RU_IncgInvoiceRegnJournal view from BASIC Incoming Invoice Registration Journal

Fields (71)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY gjahr J_3RFINV_YEAR Entry Year
KEY num J_3RFINV_NUM Entry Number
ext_orig J_3RFINV_ORIGE Orig. VAT Inv. Ext.
ext_corr J_3RFINV_CORRE Corr. VAT Inv. Ext.
revno J_3RFINV_REVNO Revision Number
revno_orig J_3RFINV_REVNO_ORIG Original Revision
lifnr J_3RF_LIFNR Vendor
kunnr J_3RF_KUNNR Customer
date_reg J_3RFINV_REG Tax Reporting Date
date_recv J_3RFINV_RECV Receipt Date
belnr_orig J_3RFINV_ORIGS Orig. VAT Inv. No.
gjahr_orig J_3RFINV_ORIGY Orig. VAT Inv. Year
belnr_corr J_3RFINV_CORRS Corr. VAT Inv. No.
gjahr_corr J_3RFINV_CORRY Corr. VAT Inv. Year
belnr_rev J_3RFINV_REVS Revision Invoice No.
gjahr_rev J_3RFINV_REVY RevisionInvoice Year
date_orig J_3RFINV_ORIGD Orig. VAT Inv. Date
date_corr J_3RFINV_CORRD Corr. VAT Inv. Date
date_rev J_3RFINV_REVD Revision Date
date_orig_rev J_3RFINV_ORIG_REVD OrigRevDate
exch_typ J_3RFINV_EXCHTYP Exchange Format
oper_typ J_3RFINV_OPERTYP Operation Type Code
name J_3RFINV_NAME Partner Name
inn J_3RFINV_INN Partner INN
kpp J_3RFINV_KPP Partner KPP
waers WAERS Currency
fwbtr J_3RFINV_FWBTR Gross Amount
fwste J_3RFINV_FWSTE Tax Amount
fwbtr_diff J_3RFINV_FWBTRDIFF Gross Amount Diff.
fwste_diff J_3RFINV_FWSTEDIFF Tax Amount Diff.
nontax J_3RFINV_NONTAX VAT Liability
usnam USNAM User Name
tmstmp J_3RFINV_TMSTMP Time Stamp
flag_del J_3RFINV_DELFLAG Deleted
flag_nonreg J_3RFINV_NONREG Non-Registered XML
doc_status J_3RFINV_DOC_STATUS Operator Status
clarif_status J_3RFINV_CLARIF_STATUS Exchange Status
seqnum J_3RFINV_SEQNUM Entry Number
comm_trade J_3RFINV_COMM_TRADE Trade Type
agent_lifnr J_3RFINV_AGENT_LIFNR Vendor (Agent)
agent_name J_3RFINV_AGENT_NAME Agent Name
agent_inn J_3RFINV_AGENT_INN Agent INN
agent_kpp J_3RFINV_AGENT_KPP Agent KPP
deal_type J_3RFINV_DEAL_TYPE Deal Type
fi_lifnr J_3RFINV_FI_LIFNR Vendor (FI Document)
flag_chng J_3RFINV_CHNG Record Changed
tax_gjahr J_3RVATDYEAR Calendar Year
tax_period J_3RVATDQMPERIOD Tax Period
corrnum J_3RVATDCORRNUM Corr.VAT Ret.Number
vat_sec J_3RVATDSECTION VAT Return Section
mainbuk J_3RF_MAINBUK Main Company Code
annulment_flag J_3RF_ANNULLED Annulment Flag
annulment_seqnum J_3RF_ANLM_SEQNUM Annulment Entry No.
src_type J_3RF_DI_SOURCEDOC_TYP Document Type
torg2_status J_3RF_TGXML_TORG2_STATUS TORG-2 Status
intcnum J_3RF_INTCNTNUM Int. Contract Number
vbeln_dlv VBELN_VL Delivery
mblnr MBLNR Material Doc.
mjahr MJAHR Mat. Doc. Year
belnr_mm RE_BELNR Inv. Doc. No.
gjahr_mm J_3RFTG_DOCMM_YEAR Invoice Document Yr.
po_num EBELN Purchasing Doc.
po_date BLDAT Document Date
belnr_fi J_3RFTG_FI_DOC_NUM FI Document Number
gjahr_fi J_3RFTG_DOCFI_YEAR FI Document Year
attachments J_3RFTG_ATTACHMENT Attachments
dcs_document_id J_3RF_DCS_DOC_ID DCS Document ID
dcs_process_id J_3RF_DI_DCSPRO_ID DCS Process ID
dcs_annuldoc_id J_3RF_DCS_DOC_ID DCS Document ID

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.

-- Incoming Invoice Registration Journal
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_3RF_REGINV_IN (
    MANDT,             -- Client [MANDT]
    BUKRS,             -- Company Code [BUKRS]
    GJAHR,             -- Entry Year [J_3RFINV_YEAR]
    NUM,               -- Entry Number [J_3RFINV_NUM]
    EXT_ORIG,          -- Orig. VAT Inv. Ext. [J_3RFINV_ORIGE]
    EXT_CORR,          -- Corr. VAT Inv. Ext. [J_3RFINV_CORRE]
    REVNO,             -- Revision Number [J_3RFINV_REVNO]
    REVNO_ORIG,        -- Original Revision [J_3RFINV_REVNO_ORIG]
    LIFNR,             -- Vendor [J_3RF_LIFNR]
    KUNNR,             -- Customer [J_3RF_KUNNR]
    DATE_REG,          -- Tax Reporting Date [J_3RFINV_REG]
    DATE_RECV,         -- Receipt Date [J_3RFINV_RECV]
    BELNR_ORIG,        -- Orig. VAT Inv. No. [J_3RFINV_ORIGS]
    GJAHR_ORIG,        -- Orig. VAT Inv. Year [J_3RFINV_ORIGY]
    BELNR_CORR,        -- Corr. VAT Inv. No. [J_3RFINV_CORRS]
    GJAHR_CORR,        -- Corr. VAT Inv. Year [J_3RFINV_CORRY]
    BELNR_REV,         -- Revision Invoice No. [J_3RFINV_REVS]
    GJAHR_REV,         -- RevisionInvoice Year [J_3RFINV_REVY]
    DATE_ORIG,         -- Orig. VAT Inv. Date [J_3RFINV_ORIGD]
    DATE_CORR,         -- Corr. VAT Inv. Date [J_3RFINV_CORRD]
    DATE_REV,          -- Revision Date [J_3RFINV_REVD]
    DATE_ORIG_REV,     -- OrigRevDate [J_3RFINV_ORIG_REVD]
    EXCH_TYP,          -- Exchange Format [J_3RFINV_EXCHTYP]
    OPER_TYP,          -- Operation Type Code [J_3RFINV_OPERTYP]
    NAME,              -- Partner Name [J_3RFINV_NAME]
    INN,               -- Partner INN [J_3RFINV_INN]
    KPP,               -- Partner KPP [J_3RFINV_KPP]
    WAERS,             -- Currency [WAERS]
    FWBTR,             -- Gross Amount [J_3RFINV_FWBTR]
    FWSTE,             -- Tax Amount [J_3RFINV_FWSTE]
    FWBTR_DIFF,        -- Gross Amount Diff. [J_3RFINV_FWBTRDIFF]
    FWSTE_DIFF,        -- Tax Amount Diff. [J_3RFINV_FWSTEDIFF]
    NONTAX,            -- VAT Liability [J_3RFINV_NONTAX]
    USNAM,             -- User Name [USNAM]
    TMSTMP,            -- Time Stamp [J_3RFINV_TMSTMP]
    FLAG_DEL,          -- Deleted [J_3RFINV_DELFLAG]
    FLAG_NONREG,       -- Non-Registered XML [J_3RFINV_NONREG]
    DOC_STATUS,        -- Operator Status [J_3RFINV_DOC_STATUS]
    CLARIF_STATUS,     -- Exchange Status [J_3RFINV_CLARIF_STATUS]
    SEQNUM,            -- Entry Number [J_3RFINV_SEQNUM]
    COMM_TRADE,        -- Trade Type [J_3RFINV_COMM_TRADE]
    AGENT_LIFNR,       -- Vendor (Agent) [J_3RFINV_AGENT_LIFNR]
    AGENT_NAME,        -- Agent Name [J_3RFINV_AGENT_NAME]
    AGENT_INN,         -- Agent INN [J_3RFINV_AGENT_INN]
    AGENT_KPP,         -- Agent KPP [J_3RFINV_AGENT_KPP]
    DEAL_TYPE,         -- Deal Type [J_3RFINV_DEAL_TYPE]
    FI_LIFNR,          -- Vendor (FI Document) [J_3RFINV_FI_LIFNR]
    FLAG_CHNG,         -- Record Changed [J_3RFINV_CHNG]
    TAX_GJAHR,         -- Calendar Year [J_3RVATDYEAR]
    TAX_PERIOD,        -- Tax Period [J_3RVATDQMPERIOD]
    CORRNUM,           -- Corr.VAT Ret.Number [J_3RVATDCORRNUM]
    VAT_SEC,           -- VAT Return Section [J_3RVATDSECTION]
    MAINBUK,           -- Main Company Code [J_3RF_MAINBUK]
    ANNULMENT_FLAG,    -- Annulment Flag [J_3RF_ANNULLED]
    ANNULMENT_SEQNUM,  -- Annulment Entry No. [J_3RF_ANLM_SEQNUM]
    SRC_TYPE,          -- Document Type [J_3RF_DI_SOURCEDOC_TYP]
    TORG2_STATUS,      -- TORG-2 Status [J_3RF_TGXML_TORG2_STATUS]
    INTCNUM,           -- Int. Contract Number [J_3RF_INTCNTNUM]
    VBELN_DLV,         -- Delivery [VBELN_VL]
    MBLNR,             -- Material Doc. [MBLNR]
    MJAHR,             -- Mat. Doc. Year [MJAHR]
    BELNR_MM,          -- Inv. Doc. No. [RE_BELNR]
    GJAHR_MM,          -- Invoice Document Yr. [J_3RFTG_DOCMM_YEAR]
    PO_NUM,            -- Purchasing Doc. [EBELN]
    PO_DATE,           -- Document Date [BLDAT]
    BELNR_FI,          -- FI Document Number [J_3RFTG_FI_DOC_NUM]
    GJAHR_FI,          -- FI Document Year [J_3RFTG_DOCFI_YEAR]
    ATTACHMENTS,       -- Attachments [J_3RFTG_ATTACHMENT]
    DCS_DOCUMENT_ID,   -- DCS Document ID [J_3RF_DCS_DOC_ID]
    DCS_PROCESS_ID,    -- DCS Process ID [J_3RF_DI_DCSPRO_ID]
    DCS_ANNULDOC_ID,   -- DCS Document ID [J_3RF_DCS_DOC_ID]
    PRIMARY KEY (MANDT, BUKRS, GJAHR, NUM)
);

Learn More