SAP table RFITEMGL_NO_ITEM (Item wise detail for the GL Account Transactions)

SAP table RFITEMGL_NO_ITEM has 5 primary key fields being MANDT,BUKRS,KONTO,GJAHR,SEQNO.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
KONTO Account Number CHAR 10 0 KTONR_AV
GJAHR Fiscal Year NUMC 4 0 GJAHR
SEQNO Numeric Character Field, Length 10 NUMC 10 0 NUMC10
UNAME User Name CHAR 12 0 UNAME
ACTIV List Level in Which the Line Item Is Active NUMC 2 0 ACTIV
ANLN1 Main Asset Number CHAR 12 0 ANLH ANLN1
ANLN2 New asset subnumber, 4 characters CHAR 4 0 ANLN2_4
AUFNR Order Number CHAR 12 0 AUFK AUFNR
AUGBL Document Number of the Clearing Document CHAR 10 0 AUGBL
AUGDT Clearing Date DATS 8 0 AUGDT
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
BLART Document Type CHAR 2 0 T003 BLART
BLDAT Document Date in Document DATS 8 0 BLDAT
BSCHL Posting Key CHAR 2 0 TBSL BSCHL
BSTAT Document Status CHAR 1 0 BSTAT_D
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
BWWRT Valuated Amount in Local Currency CURR 23 2 BWWRT_X8
BWWRC Valuated Amount in Local Currency CURR 23 2 BWWRT_X8
BWWR2 Amount Valuated in Local Currency 2 CURR 23 2 BWWR2_X8
BWWR3 Amount Valuated in Local Currency 3 CURR 23 2 BWWR3_X8
DMSHB Amount in Local Currency with +/- Signs CURR 23 2 DMSHB_X8
HWAER Local Currency CUKY 5 0 HWAER
DMBE2 Amount in Second Local Currency CURR 23 2 DMBE2_X8
HWAE2 Currency Key of Second Local Currency CUKY 5 0 HWAE2
DMBE3 Amount in Third Local Currency CURR 23 2 DMBE3_X8
HWAE3 Currency Key of Third Local Currency CUKY 5 0 HWAE3
EBELN Purchasing Document Number CHAR 10 0 EKKO EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EKPO EBELP
ETEN2 Schedule Line Number NUMC 4 0 VBEP ETENR
FAEDT Net Due Date DATS 8 0 FAEDT_FPOS
FILKD Account Number of the Branch CHAR 10 0 FILKD
GSBER Business Area CHAR 4 0 TGSB GSBER
JAMON Fiscal Year/Posting Period from Posting Date CHAR 7 0 JAMON_XPO
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
KOSTL Cost Center CHAR 10 0 KOSTL
MABER Dunning Area CHAR 2 0 T047M MABER
MADAT Date of Last Dunning Notice DATS 8 0 MADAT
MANSP Dunning Block CHAR 1 0 T040S MANSP
MANST Dunning Level NUMC 1 0 MAHNS_D
MONAT Fiscal period NUMC 2 0 MONAT
MSCHL Dunning Key CHAR 1 0 T040 MSCHL
MWSKZ Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
POSN2 Sales Document Item NUMC 6 0 POSNR_VA
PRCTR Profit Center CHAR 10 0 PRCTR
QBSHB Withholding Tax Amount in Document Currency CURR 23 2 QBSHB_X8
QSFBT Withholding Tax Exempt Amount in Document Currency CURR 23 2 QSFBT_X8
QSSHB Withholding Tax Base Amount in Document Currency CURR 23 2 QSSHB_X8
REBZG Document No. of the Invoice to Which the Transaction Belongs CHAR 10 0 REBZG
SAMNR Invoice List Number NUMC 8 0 SAMNR
SGTXT Item Text CHAR 50 0 SGTXT
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
SKFBT Amount Eligible for Cash Discount in Document Currency CURR 23 2 SKFBT_X8
WSKTO Cash Discount Amount in Document Currency CURR 23 2 WSKTO_X8
SKNTO Cash Discount Amount in Local Currency CURR 23 2 SKNTO_X8
STAKZ Indicator: Statistical Document? CHAR 1 0 XSTKZ
UMSKS Special G/L Transaction Type CHAR 1 0 UMSKS
UMSKZ Special G/L Indicator CHAR 1 0 T074U UMSKZ
UZAWE Payment method supplement CHAR 2 0 T042F UZAWE
VALUT Value date DATS 8 0 VALUT
VBEL2 Sales Document CHAR 10 0 VBELN_VA
VBELN Billing Document CHAR 10 0 VBELN_VF
VBEWA Flow Type CHAR 4 0 SBEWART
VBUND Company ID of Trading Partner CHAR 6 0 T880 RASSC
VERTN Contract Number CHAR 13 0 RANL
VERTT Contract Type CHAR 1 0 RANTYP
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
VERZ1 Days in Arrears for Cash Discount Terms 1 DEC 5 0 VERZ1
VERZN Days in Arrears by Net Due Date DEC 5 0 VERZN
WERKS Plant CHAR 4 0 T001W WERKS_D
WRSHB Amount in Document Currency (Foreign Currency) CURR 23 2 WRSHB_X8
WRSHC Amount in Document Currency (Foreign Currency) CURR 23 2 WRSHB_X8
WAERS Document Currency (Key) CUKY 5 0 WAER_DOC
WVERW Bill of Exchange Usage Type CHAR 1 0 WVERW
D Discounting
F Forfeiting
I Collection
XBLNR Reference Document Number CHAR 16 0 XBLNR1
XSTRP Indicator: Disputed Item? CHAR 1 0 XSTRP
XZAHL Indicator: Is Posting Key Used in a Payment Transaction? CHAR 1 0 XZAHL
ZALDT Probable Payment Date (Cash Discount 1 Due) DATS 8 0 DZALDT
ZBD1P Cash discount percentage 1 DEC 5 3 DZBD1P
ZBD1T Cash discount days 1 DEC 3 0 DZBD1T
ZBD2P Cash Discount Percentage 2 DEC 5 3 DZBD2P
ZBD2T Cash discount days 2 DEC 3 0 DZBD2T
ZBD3T Net Payment Terms Period DEC 3 0 DZBD3T
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
ZINSZ Interest Calculation Numerator (Days in Arrears * Amount) CURR 23 2 DZINSZ
ZLSCH Payment Method CHAR 1 0 T042Z DZLSCH
ZLSPR Payment Block Key CHAR 1 0 T008 DZLSPR
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZUONR Assignment number CHAR 18 0 DZUONR
XREF1 Business Partner Reference Key CHAR 12 0 XREF1
XREF2 Business Partner Reference Key CHAR 12 0 XREF2
XARCH Indicator: Document Already Archived? CHAR 1 0 XARCH
RSTGR Reason Code for Payments CHAR 3 0 T053R RSTGR
ASKTO Current Cash Discount Amount in Document Currency CURR 23 2 ASKTO_X8
KURSE Effective Exchange Rate in the Line Item DEC 9 5 KURSE
REBZT Follow-On Document Type CHAR 1 0 REBZT
PSWSL Update Currency for General Ledger Transaction Figures CUKY 5 0 TCURC PSWSL
PSWBT Amount for General Ledger Update (Absolute) CURR 23 2 PSWBT_X8
HKONT General Ledger Account CHAR 10 0 SKA1 HKONT
XNEGP Indicator: Negative Posting CHAR 1 0 XNEGP
ZBFIX Fixed Payment Terms CHAR 1 0 DZBFIX
RFZEI Payment Card Item NUMC 3 0 RFZEI_CC
CCBTC Payment cards: Settlement run CHAR 10 0 CCBTC
KKBER Credit control area CHAR 4 0 T014 KKBER
XREF3 Reference key for line item CHAR 20 0 XREF3
DTWS1 Instruction Key 1 NUMC 2 0 DTAT16
DTWS2 Instruction Key 2 NUMC 2 0 DTAT17
DTWS3 Instruction key 3 NUMC 2 0 DTAT18
DTWS4 Instruction key 4 NUMC 2 0 DTAT19
ABSBT Credit Management: Hedged Amount (Absolute) CURR 23 2 ABSBT_X8
KKBWR Currency of Credit Control Area CUKY 5 0 KKBWR
PROJK Individual Structural Element (WBS Element) in Ext. Format CHAR 24 0 PROJK_EXT
XPYPR Indicator: Items from Payment Program Blocked CHAR 1 0 XPYPR
KIDNO Payment Reference CHAR 30 0 KIDNO
XAUGP Indicator: Item Has Been Cleared? CHAR 1 0 XAUGP
BUPLA Business Place CHAR 4 0 J_1BBRANCH BUPLA
SECCO Section Code CHAR 4 0 SECCO
GKART Offsetting Account Type CHAR 1 0 GKART
GKONT Offsetting Account Number CHAR 10 0 GKONT
PYCUR Currency for Automatic Payment CUKY 5 0 TCURC PYCUR
PYAMT Amount in Automatic Payment Currency (Absolute) CURR 23 2 PYAMT_X8
PYORD Payment Order CHAR 10 0 PYORD
XTEXT Indicator: Texts Exist? CHAR 1 0 XTEXT_F02L
TDID Text ID CHAR 4 0 TDID
XDUEN Indicator: Item Is Due Net? CHAR 1 0 XDUEN
XDUE1 Indicator: Cash Discount Term 1 Is Due on Item? CHAR 1 0 XDUE1
XRAGL Indicator: Clearing Was Reversed CHAR 1 0 XRAGL
XSELP Item selected (selected, chosen, ...) CHAR 1 0 XSELP
COLOR Color of Line Item in the List CHAR 3 0 COL_ITEM
CESSION_KZ Accounts Receivable Pledging Indicator CHAR 2 0 TCESSION CESSION_KZ
BUZID Identification of the Line Item CHAR 1 0 BUZID
AUGGJ Fiscal Year of Clearing Document NUMC 4 0 AUGGJ
AGZEI Clearing Item DEC 5 0 AGZEI
SYM_AUGP Item Status Symbol CHAR 2 0 SYM_AUGP
ICO_AUGP Cleared/Open Items Symbol CHAR 34 0 ICO_AUGP
ICO_DUE Net Due Date Symbol CHAR 34 0 ICO_DUE
ICO_DUE1 Discount 1 Due Date Symbol CHAR 34 0 ICO_DUE1
SORT Sort Key for Line Item Report INT4 10 0 ITEMSORT
U_STBLG Reverse Document Number CHAR 10 0 STBLG
U_BWSHB1 Valuation Difference for Line Item Display CURR 23 2 BWSHB_V
U_PSTLZ Postal Code CHAR 10 0 PSTLZ
U_FWBAS Tax Base Amount in Document Currency CURR 23 2 FWBAS
U_REBZG Document No. of the Invoice to Which the Transaction Belongs CHAR 10 0 REBZG
U_CHECF Check Number From CHAR 13 0 CHECF
STCEG VAT Registration Number CHAR 20 0 STCEG
ACNAM G/L Account Long Text CHAR 50 0 TXT50_SKAT

RFITEMGL_NO_ITEM foreign key relationships

Table Field Check Table Check Field
0 RFITEMGL_NO_ITEM ANLN1 ANLH Main asset number BUKRS
0 RFITEMGL_NO_ITEM ANLN1 ANLH Main asset number ANLN1
1 RFITEMGL_NO_ITEM AUFNR AUFK Order master data AUFNR
0 RFITEMGL_NO_ITEM BLART T003 Document Types MANDT
1 RFITEMGL_NO_ITEM BSCHL TBSL Posting Key MANDT
1 RFITEMGL_NO_ITEM BSCHL TBSL Posting Key BSCHL
0 RFITEMGL_NO_ITEM BUKRS T001 Company Codes BUKRS
1 RFITEMGL_NO_ITEM BUPLA J_1BBRANCH Business Place BUKRS
1 RFITEMGL_NO_ITEM BUPLA J_1BBRANCH Business Place BRANCH
1 RFITEMGL_NO_ITEM BUPLA J_1BBRANCH Business Place BUPLA_TYPE
0 RFITEMGL_NO_ITEM CESSION_KZ TCESSION Accounts Receivable Pledging CLIENT
0 RFITEMGL_NO_ITEM CESSION_KZ TCESSION Accounts Receivable Pledging COMPANY
1 RFITEMGL_NO_ITEM EBELN EKKO Purchasing Document Header EBELN
0 RFITEMGL_NO_ITEM EBELP EKPO Purchasing Document Item MANDT
0 RFITEMGL_NO_ITEM EBELP EKPO Purchasing Document Item EBELN
1 RFITEMGL_NO_ITEM ETEN2 VBEP Sales Document: Schedule Line Data MANDT
1 RFITEMGL_NO_ITEM ETEN2 VBEP Sales Document: Schedule Line Data VBELN
1 RFITEMGL_NO_ITEM ETEN2 VBEP Sales Document: Schedule Line Data POSNR
1 RFITEMGL_NO_ITEM ETEN2 VBEP Sales Document: Schedule Line Data ETENR
0 RFITEMGL_NO_ITEM GSBER TGSB Business Areas MANDT
0 RFITEMGL_NO_ITEM GSBER TGSB Business Areas GSBER
1 RFITEMGL_NO_ITEM HKONT SKA1 G/L Account Master (Chart of Accounts) MANDT
1 RFITEMGL_NO_ITEM HKONT SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 RFITEMGL_NO_ITEM HKONT SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 RFITEMGL_NO_ITEM KKBER T014 Credit control areas KKBER
1 RFITEMGL_NO_ITEM MABER T047M Dunning areas MANDT
1 RFITEMGL_NO_ITEM MABER T047M Dunning areas BUKRS
0 RFITEMGL_NO_ITEM MSCHL T040 Dunning keys MSCHL
1 RFITEMGL_NO_ITEM MWSKZ T007A Tax Keys KALSM
1 RFITEMGL_NO_ITEM MWSKZ T007A Tax Keys MWSKZ
0 RFITEMGL_NO_ITEM PSWSL TCURC Currency Codes MANDT
0 RFITEMGL_NO_ITEM PSWSL TCURC Currency Codes WAERS
1 RFITEMGL_NO_ITEM PYCUR TCURC Currency Codes MANDT
1 RFITEMGL_NO_ITEM PYCUR TCURC Currency Codes WAERS
0 RFITEMGL_NO_ITEM RSTGR T053R Classification of Payment Differences MANDT
0 RFITEMGL_NO_ITEM RSTGR T053R Classification of Payment Differences BUKRS
0 RFITEMGL_NO_ITEM RSTGR T053R Classification of Payment Differences RSTGR
1 RFITEMGL_NO_ITEM UMSKZ T074U Special G/L Indicator Properties MANDT
0 RFITEMGL_NO_ITEM UZAWE T042F Payment method supplements MANDT
0 RFITEMGL_NO_ITEM UZAWE T042F Payment method supplements UZAWE
1 RFITEMGL_NO_ITEM VBUND T880 Global Company Data (for KONS Ledger) MANDT
1 RFITEMGL_NO_ITEM VBUND T880 Global Company Data (for KONS Ledger) RCOMP
0 RFITEMGL_NO_ITEM WERKS T001W Plants/Branches WERKS
1 RFITEMGL_NO_ITEM ZLSCH T042Z Payment Methods for Automatic Payment MANDT
1 RFITEMGL_NO_ITEM ZLSCH T042Z Payment Methods for Automatic Payment LAND1
1 RFITEMGL_NO_ITEM ZLSCH T042Z Payment Methods for Automatic Payment ZLSCH
0 RFITEMGL_NO_ITEM ZLSPR T008 Blocking Reasons for Automatic Payment Transcations MANDT
0 RFITEMGL_NO_ITEM ZLSPR T008 Blocking Reasons for Automatic Payment Transcations ZAHLS