RFITEMGL_NO_ITEM SAP (Item wise detail for the GL Account Transactions) Table details
Dictionary Type: Table
Description: Item wise detail for the GL Account Transactions
Description: Item wise detail for the GL Account Transactions
ABAP Code to SELECT data from RFITEMGL_NO_ITEM
Related tables to RFITEMGL_NO_ITEM
Access table RFITEMGL_NO_ITEM
Related tables to RFITEMGL_NO_ITEM
Access table RFITEMGL_NO_ITEM
Table field list including key, data, relationships and ABAP select examples
RFITEMGL_NO_ITEM is a standard SAP Table which is used to store Item wise detail for the GL Account Transactions data and is available within R/3 SAP systems depending on the version and release level.
The RFITEMGL_NO_ITEM table consists of various fields, each holding specific information or linking keys about Item wise detail for the GL Account Transactions data available in SAP. These include BUKRS (Company Code), KONTO (Account Number), GJAHR (Fiscal Year), SEQNO (Numeric Character Field, Length 10).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: L - Table for storing temporary data, is delivered emptyDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP RFITEMGL_NO_ITEM table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
KONTO | Account Number | KTONR_AV | CHAR | 10 | ALPHA | KTONR | |||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
SEQNO | Numeric Character Field, Length 10 | NUMC10 | NUMC | 10 | NUMC10 | ||||
UNAME | User Name | UNAME | CHAR | 12 | UNAME | ||||
ACTIV | List Level in which the Line Item is Active | ACTIV | NUMC | 2 | NUM02 | ||||
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
ANLN2 | New asset subnumber, 4 characters | ANLN2_4 | CHAR | 4 | ALPHA | ANLN2_4 | AN2 | ||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 10 | ALPHA | BELNR | |||
AUGDT | Clearing Date | AUGDT | DATS | 8 | DATUM | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
BLART | Document Type | BLART | CHAR | 2 | T003 | BLART | BAR | ||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BSCHL | Posting Key | BSCHL | CHAR | 2 | TBSL | BSCHL | |||
BSTAT | Document Status | BSTAT_D | CHAR | 1 | BSTAT | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | BUZEI | BUZ | |||
BWWRT | Valuated Amount in Local Currency | BWWRT_X8 | CURR | 15(2) | WRTV8 | ||||
BWWRC | Valuated Amount in Local Currency | BWWRT_X8 | CURR | 15(2) | WRTV8 | ||||
BWWR2 | Amount Valuated in Local Currency 2 | BWWR2_X8 | CURR | 15(2) | WRTV8 | ||||
BWWR3 | Amount Valuated in Local Currency 3 | BWWR3_X8 | CURR | 15(2) | WRTV8 | ||||
DMSHB | Amount in Local Currency with +/- Signs | DMSHB_X8 | CURR | 15(2) | WRTV8 | ||||
HWAER | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
DMBE2 | Amount in Second Local Currency | DMBE2_X8 | CURR | 15(2) | WRTV8 | ||||
HWAE2 | Currency Key of Second Local Currency | HWAE2 | CUKY | 5 | Assigned to domain | WAERS | |||
DMBE3 | Amount in Third Local Currency | DMBE3_X8 | CURR | 15(2) | WRTV8 | ||||
HWAE3 | Currency Key of Third Local Currency | HWAE3 | CUKY | 5 | Assigned to domain | WAERS | |||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EKPO | EBELP | BSP | ||
ETEN2 | Delivery Schedule Line Number | ETENR | NUMC | 4 | VBEP | ETENR | |||
FAEDT | Net Due Date | FAEDT_FPOS | DATS | 8 | DATUM | ||||
FILKD | Account Number of the Branch | FILKD | CHAR | 10 | ALPHA | MAXKK | |||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
JAMON | Fiscal Year/Posting Period from Posting Date | JAMON_XPO | CHAR | 7 | JAMON_XPO | ||||
KOART | Account Type | KOART | CHAR | 1 | KOART | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
MABER | Dunning Area | MABER | CHAR | 2 | T047M | MABER | |||
MADAT | Last dunned on | MADAT | DATS | 8 | DATUM | ||||
MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
MANST | Dunning level | MAHNS_D | NUMC | 1 | MAHNS | ||||
MONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
MSCHL | Dunning key | MSCHL | CHAR | 1 | T040 | MSCHL | |||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
POSN2 | Sales Document Item | POSNR_VA | NUMC | 6 | VBUP | POSNR | APO | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
QBSHB | Withholding Tax Amount in Document Currency | QBSHB_X8 | CURR | 15(2) | WRTV8 | ||||
QSFBT | Withholding Tax Exempt Amount in Document Currency | QSFBT_X8 | CURR | 15(2) | WRTV8 | ||||
QSSHB | Withholding Tax Base Amount in Document Currency | QSSHB_X8 | CURR | 15(2) | WRTV8 | ||||
REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
SAMNR | Invoice List Number | SAMNR | NUMC | 8 | SAMNR | ||||
SGTXT | Item Text | SGTXT | CHAR | 50 | TEXT50 | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT_X8 | CURR | 15(2) | WRTV8 | ||||
WSKTO | Cash Discount Amount in Document Currency | WSKTO_X8 | CURR | 15(2) | WRTV8 | ||||
SKNTO | Cash Discount Amount in Local Currency | SKNTO_X8 | CURR | 15(2) | WRTV8 | ||||
STAKZ | Indicator: Statistical document ? | XSTKZ | CHAR | 1 | XFELD | ||||
UMSKS | Special G/L Transaction Type | UMSKS | CHAR | 1 | UMSKS | ||||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | T074U | UMSKZ | |||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | T042F | UZAWE | |||
VALUT | Value date | VALUT | DATS | 8 | DATUM | ||||
VBEL2 | Sales Document | VBELN_VA | CHAR | 10 | VBUK | ALPHA | VBELN | AUN | |
VBELN | Billing Document | VBELN_VF | CHAR | 10 | VBUK | ALPHA | VBELN | VF | |
VBEWA | Flow Type | SBEWART | CHAR | 4 | Assigned to domain | SBEWART | |||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | T880 | ALPHA | RCOMP | PGS | |
VERTN | Contract Number | RANL | CHAR | 13 | ALPHA | RANL | RAN | ||
VERTT | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
VERZ1 | Days in Arrears for Cash Discount Terms 1 | VERZ1 | DEC | 5 | WRTV3 | ||||
VERZN | Days in Arrears by Net Due Date | VERZN | DEC | 5 | WRTV3 | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
WRSHB | Amount in Document Currency (Foreign Currency) | WRSHB_X8 | CURR | 15(2) | WRTV8 | ||||
WRSHC | Amount in Document Currency (Foreign Currency) | WRSHB_X8 | CURR | 15(2) | WRTV8 | ||||
WAERS | Document Currency (Key) | WAER_DOC | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
WVERW | Bill of exchange usage type | WVERW | CHAR | 1 | WVERW | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
XSTRP | Indicator: Disputed item? | XSTRP | CHAR | 1 | XFELD | ||||
XZAHL | Indicator: Is the posting key used in a payment transaction? | XZAHL | CHAR | 1 | XFELD | ||||
ZALDT | Probable Payment Date (Cash Discount 1 Due) | DZALDT | DATS | 8 | DATUM | ||||
ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
ZBD1T | Cash discount days 1 | DZBD1T | DEC | 3 | ZBDXT | ||||
ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
ZINSZ | Interest Calculation Numerator (Days in Arrears * Amount) | DZINSZ | CURR | 15(2) | WRTV8 | ||||
ZLSCH | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
ZLSPR | Payment Block Key | DZLSPR | CHAR | 1 | T008 | ZAHLS | SPE | ||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
XREF1 | Business partner reference key | XREF1 | CHAR | 12 | CHAR12 | ||||
XREF2 | Business partner reference key | XREF2 | CHAR | 12 | CHAR12 | ||||
XARCH | Indicator: Document already archived ? | XARCH | CHAR | 1 | XFELD | ||||
RSTGR | Reason Code for Payments | RSTGR | CHAR | 3 | T053R | RSTGR | |||
ASKTO | Current Cash Discount Amount in Document Currency | ASKTO_X8 | CURR | 15(2) | WRTV8 | ||||
KURSE | Effective Exchange Rate in the Line Item | KURSE | DEC | 9(5) | EXCRT | KURSF | |||
REBZT | Follow-On Document Type | REBZT | CHAR | 1 | REBZT | ||||
PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL | CUKY | 5 | TCURC | WAERS | |||
PSWBT | Amount for General Ledger Update (Absolute) | PSWBT_X8 | CURR | 15(2) | WERT8 | ||||
HKONT | General Ledger Account | HKONT | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
XNEGP | Indicator: Negative posting | XNEGP | CHAR | 1 | XFELD | ||||
ZBFIX | Fixed Payment Terms | DZBFIX | CHAR | 1 | ZBFIX | ||||
RFZEI | Payment Card Item | RFZEI_CC | NUMC | 3 | NUM03 | ||||
CCBTC | Payment cards: Settlement run | CCBTC | CHAR | 10 | ALPHA | CCBTC | |||
KKBER | Credit control area | KKBER | CHAR | 4 | T014 | KKBER | KKB | ||
XREF3 | Reference key for line item | XREF3 | CHAR | 20 | CHAR20 | ||||
DTWS1 | Instruction key 1 | DTAT16 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS2 | Instruction key 2 | DTAT17 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS3 | Instruction key 3 | DTAT18 | NUMC | 2 | Assigned to domain | DTWSX | |||
DTWS4 | Instruction key 4 | DTAT19 | NUMC | 2 | Assigned to domain | DTWSX | |||
ABSBT | Credit Management: Hedged Amount (Absolute) | ABSBT_X8 | CURR | 15(2) | WERT8 | ||||
KKBWR | Currency of Credit Control Area | KKBWR | CUKY | 5 | Assigned to domain | WAERS | |||
PROJK | Individual Structural Element (WBS Element) in Ext. Format | PROJK_EXT | CHAR | 24 | CHAR24 | ||||
XPYPR | Indicator: Items from Payment Program Blocked | XPYPR | CHAR | 1 | XFELD | ||||
KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
XAUGP | Indicator: Item has been cleared? | XAUGP | CHAR | 1 | XFELD | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | J_1BBRANCH | J_1BBRANCH | |||
SECCO | Section Code | SECCO | CHAR | 4 | Assigned to domain | SECCO | SECCO_ABA | ||
GKART | Offsetting Account Type | GKART | CHAR | 1 | GKART | ||||
GKONT | Offsetting Account Number | GKONT | CHAR | 10 | ALPHA | GKONT | GKONT | ||
PYCUR | Currency for Automatic Payment | PYCUR | CUKY | 5 | TCURC | WAERS | |||
PYAMT | Amount in Automatic Payment Currency (Absolute) | PYAMT_X8 | CURR | 15(2) | WERT8 | ||||
PYORD | Payment Order | PYORD | CHAR | 10 | ALPHA | PYORD | |||
XTEXT | Indicator: Texts exist ? | XTEXT_F02L | CHAR | 1 | XFELD | ||||
TDID | Text ID | TDID | CHAR | 4 | Assigned to domain | TDID | |||
XDUEN | Indicator: Item is due net? | XDUEN | CHAR | 1 | XFELD | ||||
XDUE1 | Indicator: Cash discount term 1 is due on item? | XDUE1 | CHAR | 1 | XFELD | ||||
XRAGL | Indicator: Clearing was Reversed | XRAGL | CHAR | 1 | XFELD | ||||
XSELP | Item selected (selected, chosen, ...) | XSELP | CHAR | 1 | XFELD | ||||
COLOR | Color of Line Item in the List | COL_ITEM | CHAR | 3 | COL_ITEM | ||||
CESSION_KZ | Accounts Receivable Pledging Indicator | CESSION_KZ | CHAR | 2 | TCESSION | CESSION_KZ | |||
BUZID | Identification of the Line Item | BUZID | CHAR | 1 | CHAR1 | ||||
AUGGJ | Fiscal Year of Clearing Document | AUGGJ | NUMC | 4 | GJAHR | GJAHR | |||
AGZEI | Clearing Item | AGZEI | DEC | 5 | AGZEI | ||||
SYM_AUGP | Item Status Symbol | SYM_AUGP | CHAR | 2 | SYM_2 | ||||
ICO_AUGP | Cleared/Open Items Symbol | ICO_AUGP | CHAR | 34 | ICON_34_2 | ||||
ICO_DUE | Net Due Date Symbol | ICO_DUE | CHAR | 34 | ICON_34_2 | ||||
ICO_DUE1 | Discount 1 Due Date Symbol | ICO_DUE1 | CHAR | 34 | ICON_34_2 | ||||
SORT | Sort Key for Line Item Report | ITEMSORT | INT4 | 10 | |||||
U_STBLG | Reverse Document Number | STBLG | CHAR | 10 | ALPHA | BELNR | |||
U_BWSHB1 | Valuation Difference for Line Item Display | BWSHB_V | CURR | 15(2) | WRTV8 | ||||
U_PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
U_FWBAS | Tax Base Amount in Document Currency | FWBAS | CURR | 13(2) | WERT7 | ||||
U_REBZG | Number of the Invoice the Transaction Belongs to | REBZG | CHAR | 10 | ALPHA | BELNR | |||
U_CHECF | Check Number From | CHECF | CHAR | 13 | CHCKN | CHK | |||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
ACNAM | G/L Account Long Text | TXT50_SKAT | CHAR | 50 | TEXT50 |
Key field | Non-key field |
How do I retrieve data from SAP table RFITEMGL_NO_ITEM using ABAP code
The following ABAP code Example will allow you to do a basic selection on RFITEMGL_NO_ITEM to SELECT all data from the tableDATA: WA_RFITEMGL_NO_ITEM TYPE RFITEMGL_NO_ITEM.
SELECT SINGLE *
FROM RFITEMGL_NO_ITEM
INTO CORRESPONDING FIELDS OF WA_RFITEMGL_NO_ITEM
WHERE...
How to access SAP table RFITEMGL_NO_ITEM
Within an ECC or HANA version of SAP you can also view further information about RFITEMGL_NO_ITEM and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects