1. SAP Tutorial
  2. FI Module

J_3RNDSINV SAP table for – Target use of ingoing invoice positions for AuC

Here we would like to draw your attention to J_3RNDSINV 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_3RNDSINV is a SAP standard transp table used for storing Target use of ingoing invoice positions for AuC related data in SAP. It comes under the package J3RF.

SAP J_3RNDSINV table

Table J_3RNDSINV technical data

TableJ_3RNDSINV
Data storingTarget use of ingoing invoice positions for AuC
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ3RF
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP J_3RNDSINV 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_3RNDSINV table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRSP : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BELNRP : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • BUZEIP : Number of Line Item Within Accounting Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • GJAHRP : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUKRSF : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BELNRF : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • BUZEIF : Number of Line Item Within Accounting Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • GJAHRF : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • CHARG : Batch Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • OBJNR : Object number
    Its a key field. Its data type is CHAR (Character String) with field length 22
  • DOBJNR : Second Object number
    Its data type is CHAR (Character String) with field length 22
  • POSID : Work Breakdown Structure Element (WBS Element)
    Its data type is CHAR (Character String) with field length 24
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • NPLNR : Network Number for Account Assignment
    Its data type is CHAR (Character String) with field length 12
  • NKS_ANLN1 : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • NKS_ANLN2 : Asset Subnumber
    Its data type is CHAR (Character String) with field length 4
  • KOKRSP : Controlling Area
    Its data type is CHAR (Character String) with field length 4
  • KSTAR : Cost Element
    Its data type is CHAR (Character String) with field length 10
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • OBART : Object Type
    Its data type is CHAR (Character String) with field length 2
  • CODEOBJ : Controlling object code
    Its data type is CHAR (Character String) with field length 20
  • MONATP : Fiscal period
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • XBLNRP : Reference Document Number
    Its data type is CHAR (Character String) with field length 16
  • BUDATP : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DMBTRP : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • MENGEP : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • NDSPOSP : The VAT on an item of the invoice
    Its data type is CURR (Currency Field) with field length 13
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • MWSKZP : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • FIRST_BELNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • MONATF : Fiscal period
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • BUDATF : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DMBTRF : Amount in local currency
    Its data type is CURR (Currency Field) with field length 13
  • MENGEF : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • NDSPOSF : The VAT on an item of the invoice
    Its data type is CURR (Currency Field) with field length 13
  • BWARTF : Movement type (inventory management)
    Its data type is CHAR (Character String) with field length 3
  • GRUNDF : Reason for movement
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • POSEND : The item is processed
    Its data type is CHAR (Character String) with field length 1
  • ERRCODE : Error Code
    Its data type is CHAR (Character String) with field length 2
  • RUNDATE : Run date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • RUNID : Run identificator
    Its data type is CHAR (Character String) with field length 6

    • J_3RNDSINV related tables

    • J_3RFCNTSET : Define Rules for Automatic Contract Number Filling
    • J_3RNEGPAFABE : Permit Negative Posting for Depr. Area and Chart of Depr.
    • J_3RT095B : Additional accounts for revaluation
    • J_3RF_PAYTT : Payment reason setting for CIS text table
    • J_3RF_TP_COCATTT : Transfer pricing text table for company category codes
    • J_3RFANKA : FI-AA class settings for CIS
    • J_3RBUE_BK_TXT : Text POOL for EXCTRACT
    • J_3RFOKATOREG : Relation OKATO -> Region, District
    • J_3RFPRTEXEMP : Exemption codes from property tax payment
    • J_3RFOKATOT : Classifier of the administrative and territorial division
    • J_3RSL_BK_HTABL : Table head for EXTRACT
    • J_3RF_TP_PMT : Transfer pricing: pricing method codes text table
    • J_3RF_TP_SCR : Transfer pricing selection criteria definition
    • J_3RF_BK_TOTALS : Incoming Totals for Add. Sheets of Sales/ Purchase Ledgers
    • J_3RF_ATTRTYP_TT : Attribute types text table
    • J_3RNDSINV : Target use of ingoing invoice positions for AuC
    • J_3RTAXOPC : Operation Codes for VAT Declaration (RU)
    • J_3RFBS_XMLDELT : Balance sheet forms: XML-tags to be removed:Text table
    • J_3RFDEPB_CHART : Depreciation bonus: Chart of depreciation level
    • J_3RF_DI_CCCUST : Assign Operator to Company Code and Customer

    J_3RNDSINV related transaction codes under SAP package J3RF

    • J3RFPCR : Vendor Payment Analysis (Russia)
    • J3RFPROPTAX : Property Tax Report (Russia)
    • J3RFF2 : P&L Statement, Main Section (Russia)
    • J3RFNEGP : Negative posting partial payment(RU)
    • J3RFTRPRV : Transfer Pricing Configuration
    • J3RFCNTI : Contract Numbers Maintenance
    • J3RFPVEND : Assign Electronic IDs to Vendors
    • J3RFVATEXP : Export Data Analysis for VAT
    • J3RFTAXFINREZLIST : Gains and Losses (Russia)
    • J3RSSEPINCVAT : Separate Input VAT
    • J3RFCCOP : Maintain Electronic IDs
    • J3RF_F3S2 : References (was received)
    • J3RFOS6 : Asset Inventory Cards (Russia)
    • J3RFNKSPIR : Verification of Costs (Russia)
    • J3RFTPPMV : Pricing methods
    • J3RFT53A : Form T-53A
    • J3RFF2RS : P&L Statement, Explanations (Russia)
    • J3RFSTRDIV : Structural divisions customizing
    • J3RTAX21 : VAT Return (Russia)
    • S_EBS_44000455 : J_3RF_ACCOUNTING_STATEMENT

    Related References

    Related Tutorials

    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_3RNDSNKS SAP table for – Tax categories for AuC

    J_3RNDSNKS table in SAP FI (Localization in FI) module. This table is used for storing data of Tax categories for...

    J_3RF_REGINV_IN SAP table for – Incoming Invoice Registration Journal

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

    J_3RKSORTP SAP table for – Sorting rule positions

    J_3RKSORTP table in SAP FI (Localization in FI) module. This table is used for storing data of Sorting rule positions....

    VIXCCORRVIIR SAP table for – Invoice Item Reference for Corr/Rev Invoices

    VIXCCORRVIIR table in SAP FI (Localization in FI) module. This table is used for storing data of Invoice Item Reference...

    J_3RF_REGINV_DE SAP table for – Outgoing invoice journal transp tab for IBOOK ver 2

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

    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...

    «
    »