1. SAP Tutorial
  2. FI Module

J_3RFDI_ARC SAP table for – Table for archiving and logging digital invoices

Here we would like to draw your attention to J_3RFDI_ARC 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_3RFDI_ARC is a SAP standard transp table used for storing Table for archiving and logging digital invoices related data in SAP. It comes under the package J3RF.

SAP J_3RFDI_ARC table

Table J_3RFDI_ARC technical data

TableJ_3RFDI_ARC
Data storingTable for archiving and logging digital invoices
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ3RF
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP J_3RFDI_ARC 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_3RFDI_ARC table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • NUM_ID : Internal number in the electronic invoice archive
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 12
  • .INCLUDE : Digital Invoice Archive Key
  • .INCLUDE : Invoice Journal Key
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • GJAHR_IN : Fiscal Year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • NUM_IN : 10 digit number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • 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
  • REVNO : Revision Number
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • TYPE : Electronic Invoicing Document Type
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DIRECTION : Document direction
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • EXT_ORIG : External Number of Original VAT Invoice
    Its data type is CHAR (Character String) with field length 50
  • COUNTER_KEY : Key for differentiation in XML log table
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • VERS : XML format version
    Its data type is CHAR (Character String) with field length 7
  • STATUS : Electronic invoicing document status
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • DOC_TIMESTAMP : Timestamp of document
    Its data type is CHAR (Character String) with field length 14
  • PARTNER : Counterparty
    Its data type is CHAR (Character String) with field length 10
  • PARTNER_ID : Partner ID (Electronic Invoicing)
    Its data type is CHAR (Character String) with field length 46
  • C_TIMESTAMP : Timestamp of creation
    Its data type is CHAR (Character String) with field length 14
  • C_USER : User who created document
    Its data type is CHAR (Character String) with field length 12
  • M_TIMESTAMP : Timestamp of modification
    Its data type is CHAR (Character String) with field length 14
  • M_USER : User who modified document
    Its data type is CHAR (Character String) with field length 12
  • SIGN_TIMESTAMP : Timestamp of signing
    Its data type is CHAR (Character String) with field length 14
  • SIGN_USER : User who signed document
    Its data type is CHAR (Character String) with field length 12
  • FILENAME : File Name (Electronic Documents Exchange)
    Its data type is CHAR (Character String) with field length 200
  • XMLDATA : XML Data
    Its data type is RSTR (Byte string of variable length – ABAP type XSTRING) with field length 0
  • SXMLDATA : XML Data
    Its data type is RSTR (Byte string of variable length – ABAP type XSTRING) with field length 0
  • SIGNATURE : Digital invoice signature
    Its data type is RSTR (Byte string of variable length – ABAP type XSTRING) with field length 0
  • OPERATOR : Operator of Company Code
    Its data type is CHAR (Character String) with field length 10

    • J_3RFDI_ARC related tables

    • J_3RFBS_PERIOD : Financial statement forms: Fiscal periods
    • J_3RF_REGINV_K : Incoming invoice journal transp tab for IBOOK
    • J_3ROS6_SETTINGS : Settings for inventory card printing (forms OS-6,NMA-1…)
    • J_3RFREGCUSEDI : VAT Invoice Journal: Entry Protection
    • J_3RFGTDMATBOM : BoM for Customs Decl. Tracking
    • J_3RF_ATTRTYP_DT : Attribute types
    • J_3RFTAXRA : Tax Accounting: Actual line item table
    • J_3RFPROPTYPES : Property types
    • J_3RF_REGCUSMAT : Matching Rules for Invoice Registration Journal
    • J_3RF_TAXPERNT : Tax period names text customizing CIS
    • J_3RBUE_BK_TABLE : Transparent table for PurBook (ALV)
    • J_3RFCAPREP : Net book value increase of assets as a result of repairs
    • J_3RF_SALE_BOOK : Purchase book line number for sale book position
    • J_3RF_PRECMET : Define Precious Materials (Metals and Diamonds) for Assets
    • J_3RFBS_EXCODES : Exteranl codes for FSV-items
    • J_3RF_ATTR_VALST : Attribute vallues text table
    • J_3RDOPDEB : Secondary index table for VAT
    • J_3RTUSERS : User names for legal form printing
    • J_3RF_SURP_SW : Customizing for surplus price switching
    • J_3RF_XNEGP_ACT : Activate Negative Posting for Countries

    J_3RFDI_ARC related transaction codes under SAP package J3RF

    • J3RFPURB : Purchase Ledger (Russia)
    • J3RFZKRPDF : Print Payment Orders (Russia)
    • J3RFGTDINTMASS : Maintain Mass CDec Data (Russia)
    • J3RFF3S2 : Changes in Equity, Explanations
    • J3RFCCOP : Maintain Electronic IDs
    • J3RFF3 : Changes in Equity, Main Section
    • J3RFGTDINT : Maintain CDec Data (Russia)
    • J3RFTAXAMTEST : Tax Depreciation Report (Russia)
    • J3RF_DI_ARCLOG : XML data for Electronic Invoices
    • J3RFVATSD : VAT for Goods in Transit
    • J3RFTPCOCATV : Company categories
    • J3RFF2 : P&L Statement, Main Section (Russia)
    • J3RFASD : Customer Balance Notification
    • J3RFRATECALC : Down Payments in Foreign Currency
    • J3RFNKSPIR : Verification of Costs (Russia)
    • S_EBS_44000512 : Goods Import Declaration (Customs Un
    • J3RFDEPRBONUS : Depreciation Bonus Calculation
    • J3RFNKSREGISTR : Asset Registration (Russia)
    • J3RFWWALLOW : Maintain Workwear quaotas
    • J3RFTPDEL : Transfer Pricing Delete Notification

    Related References

    Related Tutorials

    J_3RFDI_DEADLINE SAP table for – Deadline for Digital Invoices

    J_3RFDI_DEADLINE table in SAP FI (Localization in FI) module. This table is used for storing data of Deadline for Digital...

    VIXCPTSIPT SAP table for – Digital Signature for Invoices

    VIXCPTSIPT table in SAP FI (Localization in FI) module. This table is used for storing data of Digital Signature for...

    J_3RSINCINV SAP table for – Incoming Invoices For Separate VAT

    J_3RSINCINV table in SAP FI (Localization in FI) module. This table is used for storing data of Incoming Invoices For...

    J_3RF_DI_TRANF SAP table for – Transformations for digital invoice processing

    J_3RF_DI_TRANF table in SAP FI (Localization in FI) module. This table is used for storing data of Transformations for digital...

    J_3RSINVLNK SAP table for – Links Between Incoming And Outgoing Invoices For Export Oper

    J_3RSINVLNK table in SAP FI (Localization in FI) module. This table is used for storing data of Links Between Incoming...

    J_3RFIN_RATE_CLC SAP table for – Downpayments rate calculator for foreign currency – invoices

    J_3RFIN_RATE_CLC table in SAP FI (Localization in FI) module. This table is used for storing data of Downpayments rate calculator...

    J_3RFDI_DEADJRNL SAP table for – Invoice Journal Deadlines (Electronic Invoices)

    J_3RFDI_DEADJRNL table in SAP FI (Localization in FI) module. This table is used for storing data of Invoice Journal Deadlines...

    «
    »