1. Home
  2. Resources
  3. SAP Tables
  4. RFITEMGL_NO_ITEM - Item wise detail for the GL Account Transactions

SAP Table RFITEMGL_NO_ITEM

Item wise detail for the GL Account Transactions

RFITEMGL_NO_ITEM (Item wise detail for the GL Account Transactions) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RFITEMGL_NO_ITEM to other SAP tables.

RFITEMGL_NO_ITEM table fields

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

RFITEMGL_NO_ITEM foreign key relationships

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