1. SAP Tutorial
  2. FI Module

RFITEMGL_NO_ITEM SAP table for – Item wise detail for the GL Account Transactions

Here we would like to draw your attention to RFITEMGL_NO_ITEM 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). RFITEMGL_NO_ITEM is a SAP standard transp table used for storing Item wise detail for the GL Account Transactions related data in SAP. It comes under the package ID-FI-SCAND.

SAP RFITEMGL_NO_ITEM table

Table RFITEMGL_NO_ITEM technical data

TableRFITEMGL_NO_ITEM
Data storingItem wise detail for the GL Account Transactions
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-FI-SCAND
Delivery ClassL – Table for storing temporary data
ComponentSAP_FIN
Table CategoryTRANSP

SAP RFITEMGL_NO_ITEM 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 RFITEMGL_NO_ITEM 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
  • KONTO : Account Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • SEQNO : Numeric Character Field, Length 10
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • UNAME : User Name
    Its data type is CHAR (Character String) with field length 12
  • ACTIV : List Level in which the Line Item is Active
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • ANLN1 : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • ANLN2 : New asset subnumber, 4 characters
    Its data type is CHAR (Character String) with field length 4
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • AUGBL : Document Number of the Clearing Document
    Its data type is CHAR (Character String) with field length 10
  • AUGDT : Clearing Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BELNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • BLART : Document type
    Its data type is CHAR (Character String) with field length 2
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BSCHL : Posting Key
    Its data type is CHAR (Character String) with field length 2
  • BSTAT : Document Status
    Its data type is CHAR (Character String) with field length 1
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUZEI : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • BWWRT : Valuated Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • BWWRC : Valuated Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • BWWR2 : Amount Valuated in Local Currency 2
    Its data type is CURR (Currency Field) with field length 15
  • BWWR3 : Amount Valuated in Local Currency 3
    Its data type is CURR (Currency Field) with field length 15
  • DMSHB : Amount in Local Currency with +/- Signs
    Its data type is CURR (Currency Field) with field length 15
  • HWAER : Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DMBE2 : Amount in Second Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWAE2 : Currency Key of Second Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DMBE3 : Amount in Third Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWAE3 : Currency Key of Third Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • EBELN : Purchasing Document Number
    Its data type is CHAR (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • ETEN2 : Schedule line
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FAEDT : Net Due Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FILKD : Account Number of the Branch
    Its data type is CHAR (Character String) with field length 10
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • JAMON : Fiscal Year/Posting Period from Posting Date
    Its data type is CHAR (Character String) with field length 7
  • KOART : Account type
    Its data type is CHAR (Character String) with field length 1
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • MABER : Dunning Area
    Its data type is CHAR (Character String) with field length 2
  • MADAT : Date of Last Dunning Notice
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MANSP : Dunning block
    Its data type is CHAR (Character String) with field length 1
  • MANST : Dunning Level
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • MONAT : Fiscal period
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • MSCHL : Dunning key
    Its data type is CHAR (Character String) with field length 1
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • POSN2 : Sales Document Item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • QBSHB : Withholding Tax Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • QSFBT : Withholding Tax Exempt Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • QSSHB : Withholding Tax Base Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • REBZG : Number of the Invoice the Transaction Belongs to
    Its data type is CHAR (Character String) with field length 10
  • SAMNR : Invoice List Number
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • SHKZG : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • SKFBT : Amount Eligible for Cash Discount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • WSKTO : Cash Discount Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • SKNTO : Cash Discount Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • STAKZ : Indicator: Statistical document ?
    Its data type is CHAR (Character String) with field length 1
  • UMSKS : Special G/L Transaction Type
    Its data type is CHAR (Character String) with field length 1
  • UMSKZ : Special G/L Indicator
    Its data type is CHAR (Character String) with field length 1
  • UZAWE : Payment method supplement
    Its data type is CHAR (Character String) with field length 2
  • VALUT : Fixed Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VBEL2 : Sales Document
    Its data type is CHAR (Character String) with field length 10
  • VBELN : Billing document
    Its data type is CHAR (Character String) with field length 10
  • VBEWA : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • VBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • VERTN : Contract Number
    Its data type is CHAR (Character String) with field length 13
  • VERTT : Contract Type
    Its data type is CHAR (Character String) with field length 1
  • VERZ1 : Days in Arrears for Cash Discount Terms 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • VERZN : Days in Arrears by Net Due Date
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • WRSHB : Amount in Document Currency (Foreign Currency)
    Its data type is CURR (Currency Field) with field length 15
  • WRSHC : Amount in Document Currency (Foreign Currency)
    Its data type is CURR (Currency Field) with field length 15
  • WAERS : Document Currency (Key)
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • WVERW : Bill of Exchange Usage Type
    Its data type is CHAR (Character String) with field length 1
  • XBLNR : Reference Document Number
    Its data type is CHAR (Character String) with field length 16
  • XSTRP : Indicator: Disputed item?
    Its data type is CHAR (Character String) with field length 1
  • XZAHL : Indicator: Is Posting Key Used in a Payment Transaction?
    Its data type is CHAR (Character String) with field length 1
  • ZALDT : Probable Payment Date (Cash Discount 1 Due)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ZBD1P : Cash discount percentage 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ZBD1T : Cash discount days 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • ZBD2P : Cash Discount Percentage 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ZBD2T : Cash discount days 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • ZBD3T : Net Payment Terms Period
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • ZFBDT : Baseline date for due date calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ZINSZ : Interest Calculation Numerator (Days in Arrears * Amount)
    Its data type is CURR (Currency Field) with field length 15
  • ZLSCH : Payment method
    Its data type is CHAR (Character String) with field length 1
  • ZLSPR : Payment Block Key
    Its data type is CHAR (Character String) with field length 1
  • ZTERM : Terms of payment key
    Its data type is CHAR (Character String) with field length 4
  • ZUONR : Assignment number
    Its data type is CHAR (Character String) with field length 18
  • XREF1 : Business partner reference key
    Its data type is CHAR (Character String) with field length 12
  • XREF2 : Business partner reference key
    Its data type is CHAR (Character String) with field length 12
  • XARCH : Indicator: Document already archived ?
    Its data type is CHAR (Character String) with field length 1
  • RSTGR : Reason Code for Payments
    Its data type is CHAR (Character String) with field length 3
  • ASKTO : Current Cash Discount Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • KURSE : Effective Exchange Rate in the Line Item
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • REBZT : Follow-On Document Type
    Its data type is CHAR (Character String) with field length 1
  • PSWSL : Update Currency for General Ledger Transaction Figures
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PSWBT : Amount for General Ledger Update (Absolute)
    Its data type is CURR (Currency Field) with field length 15
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • XNEGP : Indicator: Negative posting
    Its data type is CHAR (Character String) with field length 1
  • ZBFIX : Fixed Payment Terms
    Its data type is CHAR (Character String) with field length 1
  • RFZEI : Payment Card Item
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CCBTC : Payment cards: Settlement run
    Its data type is CHAR (Character String) with field length 10
  • KKBER : Credit control area
    Its data type is CHAR (Character String) with field length 4
  • XREF3 : Reference key for line item
    Its data type is CHAR (Character String) with field length 20
  • DTWS1 : Instruction key 1
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DTWS2 : Instruction key 2
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DTWS3 : Instruction key 3
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DTWS4 : Instruction key 4
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • ABSBT : Credit Management: Hedged Amount (Absolute)
    Its data type is CURR (Currency Field) with field length 15
  • KKBWR : Currency of Credit Control Area
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PROJK : Individual Structural Element (WBS Element) in Ext. Format
    Its data type is CHAR (Character String) with field length 24
  • XPYPR : Indicator: Items from Payment Program Blocked
    Its data type is CHAR (Character String) with field length 1
  • KIDNO : Payment Reference
    Its data type is CHAR (Character String) with field length 30
  • XAUGP : Indicator: Item has been cleared?
    Its data type is CHAR (Character String) with field length 1
  • BUPLA : Business Place
    Its data type is CHAR (Character String) with field length 4
  • SECCO : Section Code
    Its data type is CHAR (Character String) with field length 4
  • GKART : Offsetting Account Type
    Its data type is CHAR (Character String) with field length 1
  • GKONT : Offsetting Account Number
    Its data type is CHAR (Character String) with field length 10
  • PYCUR : Currency for Automatic Payment
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PYAMT : Amount in Automatic Payment Currency (Absolute)
    Its data type is CURR (Currency Field) with field length 15
  • PYORD : Payment Order
    Its data type is CHAR (Character String) with field length 10
  • XTEXT : Indicator: Texts exist ?
    Its data type is CHAR (Character String) with field length 1
  • TDID : Text ID
    Its data type is CHAR (Character String) with field length 4
  • XDUEN : Indicator: Item is due net?
    Its data type is CHAR (Character String) with field length 1
  • XDUE1 : Indicator: Cash discount term 1 is due on item?
    Its data type is CHAR (Character String) with field length 1
  • XRAGL : Indicator: Clearing was Reversed
    Its data type is CHAR (Character String) with field length 1
  • XSELP : Item selected (selected, chosen, …)
    Its data type is CHAR (Character String) with field length 1
  • COLOR : Color of Line Item in the List
    Its data type is CHAR (Character String) with field length 3
  • CESSION_KZ : Accounts Receivable Pledging Indicator
    Its data type is CHAR (Character String) with field length 2
  • BUZID : Identification of the Line Item
    Its data type is CHAR (Character String) with field length 1
  • AUGGJ : Fiscal Year of Clearing Document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • AGZEI : Clearing Item
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • SYM_AUGP : Item Status Symbol
    Its data type is CHAR (Character String) with field length 2
  • ICO_AUGP : Cleared/Open Items Symbol
    Its data type is CHAR (Character String) with field length 34
  • ICO_DUE : Net Due Date Symbol
    Its data type is CHAR (Character String) with field length 34
  • ICO_DUE1 : Discount 1 Due Date Symbol
    Its data type is CHAR (Character String) with field length 34
  • SORT : Sort Key for Line Item Report
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • U_STBLG : Reverse Document Number
    Its data type is CHAR (Character String) with field length 10
  • U_BWSHB1 : Valuation Difference for Line Item Display
    Its data type is CURR (Currency Field) with field length 15
  • U_PSTLZ : Postal Code
    Its data type is CHAR (Character String) with field length 10
  • U_FWBAS : Tax Base Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • U_REBZG : Number of the Invoice the Transaction Belongs to
    Its data type is CHAR (Character String) with field length 10
  • U_CHECF : Check Number From
    Its data type is CHAR (Character String) with field length 13
  • STCEG : VAT Registration Number
    Its data type is CHAR (Character String) with field length 20
  • ACNAM : G/L Account Long Text
    Its data type is CHAR (Character String) with field length 50

    • RFITEMGL_NO_ITEM related tables

    • RFITEMAR_NO_ITEM : Item wise detail for the Customer Transactions
    • RFITEMGL_NO_ITEM : Item wise detail for the GL Account Transactions
    • RFITEMAP_NO_ITEM : Item wise detail for the Vendor Transactions

    RFITEMGL_NO_ITEM related transaction codes under SAP package ID-FI-SCAND

    • VENDORS_BAL_NORWAY : REPORT FOR VENDOR BALANCES
    • CUSTOMERS_BAL_NORWAY : REPORT FOR CUSTOMER BALANCES
    • NOR_GL : Norway: G/L Account Line Items
    • NOR_GLOLD : Norway: G/L Account Line Items

    Related References

    Related Tutorials

    RFITEMAP_NO_ITEM SAP table for – Item wise detail for the Vendor Transactions

    RFITEMAP_NO_ITEM table in SAP FI (Localization in FI) module. This table is used for storing data of Item wise detail...

    RFITEMAR_NO_ITEM SAP table for – Item wise detail for the Customer Transactions

    RFITEMAR_NO_ITEM table in SAP FI (Localization in FI) module. This table is used for storing data of Item wise detail...

    FIEUD_SDINV_I SAP table for – SAFT: Invoices from SD module(Item)

    FIEUD_SDINV_I table in SAP FI (Localization in FI) module. This table is used for storing data of SAFT: Invoices from...

    J_3RFTAX_EXTRD SAP table for – Tax Extract Detail Lines

    J_3RFTAX_EXTRD table in SAP FI (Localization in FI) module. This table is used for storing data of Tax Extract Detail...

    FIEUD_FIDOC_I SAP table for – SAFT: FI Transaction Document Item

    FIEUD_FIDOC_I table in SAP FI (Localization in FI) module. This table is used for storing data of SAFT: FI Transaction...

    J_3RKKRS SAP table for – Account correspondence line items

    J_3RKKRS table in SAP FI (Localization in FI) module. This table is used for storing data of Account correspondence line...

    DFKKREPMP SAP table for – Report Item

    DFKKREPMP table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    «
    »