1. SAP Tutorial
  2. FI Module

J_3RF_REGINV_IN SAP table for – Incoming Invoice Registration Journal

Here we would like to draw your attention to J_3RF_REGINV_IN table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). J_3RF_REGINV_IN is a SAP standard transp table used for storing Incoming Invoice Registration Journal related data in SAP. It comes under the package J3RF.

SAP J_3RF_REGINV_IN table

Table J_3RF_REGINV_IN technical data

TableJ_3RF_REGINV_IN
Data storingIncoming Invoice Registration Journal
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ3RF
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP J_3RF_REGINV_IN Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in J_3RF_REGINV_IN table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • NUM : 10 digit number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • EXT_ORIG : External Number of Original VAT Invoice
    Its data type is CHAR (Character String) with field length 50
  • EXT_CORR : External Number of Corrective VAT Invoice
    Its data type is CHAR (Character String) with field length 50
  • REVNO : Revision Number
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • LIFNR : Account Number of Vendor or Creditor
    Its data type is CHAR (Character String) with field length 10
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • DATE_RECV : Receipt Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BELNR_ORIG : Number of Original VAT Invoice
    Its data type is CHAR (Character String) with field length 10
  • GJAHR_ORIG : Year of Original VAT Invoice
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BELNR_CORR : Number of Corrective VAT Invoice
    Its data type is CHAR (Character String) with field length 10
  • GJAHR_CORR : Year of Corrective VAT Invoice
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BELNR_REV : Number of Revised VAT Invoice
    Its data type is CHAR (Character String) with field length 10
  • GJAHR_REV : Year of Revised VAT Invoice
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DATE_ORIG : Date of Original VAT Invoice
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATE_CORR : Date of Corrective VAT Invoice
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATE_REV : Revision Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EXCH_TYP : Exchange Format
    Its data type is CHAR (Character String) with field length 1
  • OPER_TYP : Operation Type
    Its data type is CHAR (Character String) with field length 20
  • NAME : Partner Name
    Its data type is CHAR (Character String) with field length 255
  • INN : Partner INN
    Its data type is CHAR (Character String) with field length 16
  • KPP : Partner KPP
    Its data type is CHAR (Character String) with field length 18
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • FWBTR : Gross Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • FWSTE : Tax Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • FWBTR_DIFF : Gross Amount Difference in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • FWSTE_DIFF : Tax Amount Difference in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • NONTAX : Flag: Document Is Nontaxable
    Its data type is CHAR (Character String) with field length 1
  • USNAM : User name
    Its data type is CHAR (Character String) with field length 12
  • TMSTMP : Time Stamp
    Its data type is CHAR (Character String) with field length 14
  • FLAG_DEL : Flag: Entry Is Deleted
    Its data type is CHAR (Character String) with field length 1
  • FLAG_NONREG : Flag: Non-Registered XML Invoice
    Its data type is CHAR (Character String) with field length 1
  • DOC_STATUS : Electronic Invoice Document Status
    Its data type is CHAR (Character String) with field length 2
  • CLARIF_STATUS : Electronic Invoice Clarification Request Status
    Its data type is CHAR (Character String) with field length 2

    • J_3RF_REGINV_IN related tables

    • J_3RFPOFPRIVT : Official property tax privileges (Federal level) texts
    • J_3RF_ATTRTYP_DT : Attribute types
    • J_3RNEGPAFABE : Permit Negative Posting for Depr. Area and Chart of Depr.
    • J_3RFOKATO : Classifier of the administrative and territorial division
    • J_3RTUSERS : User names for legal form printing
    • J_3RF_REGCUS_REV : Customizing for Reversals for Invoice Registration Journal
    • J_3RFPRTXAMTR : Property tax amount reduction
    • J_3RFGTDINVT : Define Billing Types for Customs Declaration Tracking
    • J_3RFRETDB_BWASL : Retirement Transaction Types for Depreciation Bonus Restore
    • J_3RFPOFPRIV : Official property tax privileges (Federal level)
    • J_3RF_TP_PMT : Transfer pricing: pricing method codes text table
    • J_3RF_SURP_PRICE : Market prices for inventory surplus (Russia)
    • J_3RTAXOPC : Operation Codes for VAT Declaration (RU)
    • J_3RF_CORR_INV : Define Correction Invoices (Russia)
    • J_3RF_TP_LIST1A : Information of Notification. List 1A
    • J_3RFPM_RATE_CLC : Downpayments rate calculator for foreign currency – payments
    • J_3RF_DI_PCCODE : Assign Electronic ID to Company Code
    • J_3RFBS_VERVAR : Financial Statement Versions Used in Balance Sheet Forms
    • J_3RFSTOPREASON : Reasons for asset shutdown
    • J_3RF_REGINV_OUT : Outgoing Invoice Registration Journal

    J_3RF_REGINV_IN related transaction codes under SAP package J3RF

    • J3RFKSLD : Vendor Turnover Balance Sheet
    • J3RSSEPINCVAT : Separate Input VAT
    • J3RFACCST : Accounting statement
    • J3RFPROPTAX : Property Tax Report (Russia)
    • J3RFSTRDIV : Structural divisions customizing
    • J3RFF2RS : P&L Statement, Explanations (Russia)
    • J3RFCCCUST : Set Up Multiple Operators
    • J3RFSELB : Sales Ledger (Russia)
    • V_J_3RFREGINVOUT : Register Outgoing Invoices
    • J3RFREVSTOR : FixedAssetRevaluation ReversePosting
    • J3RF_F2 : Profit and loss report Russia (F.2)
    • J3RTAX21 : VAT Return (Russia)
    • J3RFTPFORGV : Foreign organization data
    • J3RFGTDINT : Maintain CDec Data (Russia)
    • J3RFF3 : Changes in Equity, Main Section
    • J3RFPURB : Purchase Ledger (Russia)
    • J3RFASD : Customer Balance Notification
    • J3RF_F2RS : Decoding for some profits and losses
    • J3RFCNTI : Contract Numbers Maintenance
    • J3RFCCOP : Maintain Electronic IDs

    Related References

    Related Tutorials

    J_3RF_REGCUS_IN SAP table for – Customizing for Incoming Invoice Registration Journal

    J_3RF_REGCUS_IN table in SAP FI (Localization in FI) module. This table is used for storing data of Customizing for Incoming...

    J_3RF_REGINV_OUT SAP table for – Outgoing Invoice Registration Journal

    J_3RF_REGINV_OUT table in SAP FI (Localization in FI) module. This table is used for storing data of Outgoing Invoice Registration...

    J_3RF_REGCUSMAT SAP table for – Matching Rules for Invoice Registration Journal

    J_3RF_REGCUSMAT table in SAP FI (Localization in FI) module. This table is used for storing data of Matching Rules for...

    J_3RF_REGCUS_OUT SAP table for – Customizing for Outgoing Invoice Registration Journal

    J_3RF_REGCUS_OUT table in SAP FI (Localization in FI) module. This table is used for storing data of Customizing for Outgoing...

    J_3RF_REGINV_K SAP table for – Incoming invoice journal transp tab for IBOOK

    J_3RF_REGINV_K table in SAP FI (Localization in FI) module. This table is used for storing data of Incoming invoice journal...

    J_3RF_REGCUS_REV SAP table for – Customizing for Reversals for Invoice Registration Journal

    J_3RF_REGCUS_REV table in SAP FI (Localization in FI) module. This table is used for storing data of Customizing for Reversals...

    J_3RF_REGINV_LOG SAP table for – Invoice Journal (Russia): History of Statuses

    J_3RF_REGINV_LOG table in SAP FI (Localization in FI) module. This table is used for storing data of Invoice Journal (Russia):...

    «
    »