RFITEMGL_NO_ITEM - Item wise detail for the GL Account Transactions
Item wise detail for the GL Account Transactions information is stored in SAP table RFITEMGL_NO_ITEM.
It is part of development package ID-FI-SCAND in software component FI-LOC-FI-SCN. This development package consists of objects that can be grouped under "Localisation FI Scandinavia".
It is part of development package ID-FI-SCAND in software component FI-LOC-FI-SCN. This development package consists of objects that can be grouped under "Localisation FI Scandinavia".
Fields for table RFITEMGL_NO_ITEM
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| BUKRS | Company Code | X | BUKRS | CHAR | 8 | T001 |
| KONTO | Account Number | X | KTONR_AV | CHAR | 20 | |
| GJAHR | Fiscal Year | X | GJAHR | NUMC | 8 | |
| SEQNO | Numeric Character Field, Length 10 | X | NUMC10 | NUMC | 20 | |
| UNAME | User Name | UNAME | CHAR | 24 | ||
| ACTIV | List Level in Which the Line Item Is Active | ACTIV | NUMC | 4 | ||
| ANLN1 | Main Asset Number | ANLN1 | CHAR | 24 | ANLH | |
| ANLN2 | New asset subnumber, 4 characters | ANLN2_4 | CHAR | 8 | ||
| AUFNR | Order Number | AUFNR | CHAR | 24 | AUFK | |
| AUGBL | Document Number of the Clearing Document | AUGBL | CHAR | 20 | ||
| AUGDT | Clearing Date | AUGDT | DATS | 16 | ||
| BELNR | Document Number of an Accounting Document | BELNR_D | CHAR | 20 | ||
| BLART | Document Type | BLART | CHAR | 4 | T003 | |
| BLDAT | Document Date in Document | BLDAT | DATS | 16 | ||
| BSCHL | Posting Key | BSCHL | CHAR | 4 | TBSL | |
| BSTAT | Document Status | BSTAT_D | CHAR | 2 | ||
| BUDAT | Posting Date in the Document | BUDAT | DATS | 16 | ||
| BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 6 | ||
| BWWRT | Valuated Amount in Local Currency | BWWRT_X8 | CURR | 12 | ||
| BWWRC | Valuated Amount in Local Currency | BWWRT_X8 | CURR | 12 | ||
| BWWR2 | Amount Valuated in Local Currency 2 | BWWR2_X8 | CURR | 12 | ||
| BWWR3 | Amount Valuated in Local Currency 3 | BWWR3_X8 | CURR | 12 | ||
| DMSHB | Amount in Local Currency with +/- Signs | DMSHB_X8 | CURR | 12 | ||
| HWAER | Local Currency | HWAER | CUKY | 10 | ||
| DMBE2 | Amount in Second Local Currency | DMBE2_X8 | CURR | 12 | ||
| HWAE2 | Currency Key of Second Local Currency | HWAE2 | CUKY | 10 | ||
| DMBE3 | Amount in Third Local Currency | DMBE3_X8 | CURR | 12 | ||
| HWAE3 | Currency Key of Third Local Currency | HWAE3 | CUKY | 10 | ||
| EBELN | Purchasing Document Number | EBELN | CHAR | 20 | EKKO | |
| EBELP | Item Number of Purchasing Document | EBELP | NUMC | 10 | EKPO | |
| ETEN2 | Schedule Line Number | ETENR | NUMC | 8 | VBEP | |
| FAEDT | Net Due Date | FAEDT_FPOS | DATS | 16 | ||
| FILKD | Account Number of the Branch | FILKD | CHAR | 20 | ||
| GSBER | Business Area | GSBER | CHAR | 8 | TGSB | |
| JAMON | Fiscal Year/Posting Period from Posting Date | JAMON_XPO | CHAR | 14 | ||
| KOART | Account type | KOART | CHAR | 2 | ||
| KOSTL | Cost Center | KOSTL | CHAR | 20 | ||
| MABER | Dunning Area | MABER | CHAR | 4 | T047M | |
| MADAT | Date of Last Dunning Notice | MADAT | DATS | 16 | ||
| MANSP | Dunning Block | MANSP | CHAR | 2 | T040S | |
| MANST | Dunning Level | MAHNS_D | NUMC | 2 | ||
| MONAT | Fiscal period | MONAT | NUMC | 4 | ||
| MSCHL | Dunning Key | MSCHL | CHAR | 2 | T040 | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 4 | T007A | |
| POSN2 | Sales Document Item | POSNR_VA | NUMC | 12 | ||
| PRCTR | Profit Center | PRCTR | CHAR | 20 | ||
| QBSHB | Withholding Tax Amount in Document Currency | QBSHB_X8 | CURR | 12 | ||
| QSFBT | Withholding Tax Exempt Amount in Document Currency | QSFBT_X8 | CURR | 12 | ||
| QSSHB | Withholding Tax Base Amount in Document Currency | QSSHB_X8 | CURR | 12 | ||
| REBZG | Document No. of the Invoice to Which the Transaction Belongs | REBZG | CHAR | 20 | ||
| SAMNR | Invoice List Number | SAMNR | NUMC | 16 | ||
| SGTXT | Item Text | SGTXT | CHAR | 100 | ||
| SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 2 | ||
| SKFBT | Amount Eligible for Cash Discount in Document Currency | SKFBT_X8 | CURR | 12 | ||
| WSKTO | Cash Discount Amount in Document Currency | WSKTO_X8 | CURR | 12 | ||
| SKNTO | Cash Discount Amount in Local Currency | SKNTO_X8 | CURR | 12 | ||
| STAKZ | Indicator: Statistical Document? | XSTKZ | CHAR | 2 | ||
| UMSKS | Special G/L Transaction Type | UMSKS | CHAR | 2 | ||
| UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 2 | T074U | |
| UZAWE | Payment method supplement | UZAWE | CHAR | 4 | T042F | |
| VALUT | Value date | VALUT | DATS | 16 | ||
| VBEL2 | Sales Document | VBELN_VA | CHAR | 20 | ||
| VBELN | Billing Document | VBELN_VF | CHAR | 20 | ||
| VBEWA | Flow Type | SBEWART | CHAR | 8 | ||
| VBUND | Company ID of Trading Partner | RASSC | CHAR | 12 | T880 | |
| VERTN | Contract Number | RANL | CHAR | 26 | ||
| VERTT | Contract Type | RANTYP | CHAR | 2 | ||
| VERZ1 | Days in Arrears for Cash Discount Terms 1 | VERZ1 | DEC | 3 | ||
| VERZN | Days in Arrears by Net Due Date | VERZN | DEC | 3 | ||
| WERKS | Plant | WERKS_D | CHAR | 8 | T001W | |
| WRSHB | Amount in Document Currency (Foreign Currency) | WRSHB_X8 | CURR | 12 | ||
| WRSHC | Amount in Document Currency (Foreign Currency) | WRSHB_X8 | CURR | 12 | ||
| WAERS | Document Currency (Key) | WAER_DOC | CUKY | 10 | ||
| WVERW | Bill of Exchange Usage Type | WVERW | CHAR | 2 | ||
| XBLNR | Reference Document Number | XBLNR1 | CHAR | 32 | ||
| XSTRP | Indicator: Disputed Item? | XSTRP | CHAR | 2 | ||
| XZAHL | Indicator: Is Posting Key Used in a Payment Transaction? | XZAHL | CHAR | 2 | ||
| XREF1 | Business Partner Reference Key | XREF1 | CHAR | 24 | ||
| XREF2 | Business Partner Reference Key | XREF2 | CHAR | 24 | ||
| XARCH | Indicator: Document Already Archived? | XARCH | CHAR | 2 | ||
| RSTGR | Reason Code for Payments | RSTGR | CHAR | 6 | T053R | |
| ASKTO | Current Cash Discount Amount in Document Currency | ASKTO_X8 | CURR | 12 | ||
| KURSE | Effective Exchange Rate in the Line Item | KURSE | DEC | 5 | ||
| REBZT | Follow-On Document Type | REBZT | CHAR | 2 | ||
| PSWSL | Update Currency for General Ledger Transaction Figures | PSWSL | CUKY | 10 | TCURC | |
| PSWBT | Amount for General Ledger Update (Absolute) | PSWBT_X8 | CURR | 12 | ||
| HKONT | General Ledger Account | HKONT | CHAR | 20 | SKA1 | |
| XNEGP | Indicator: Negative Posting | XNEGP | CHAR | 2 | ||
| RFZEI | Payment Card Item | RFZEI_CC | NUMC | 6 | ||
| CCBTC | Payment cards: Settlement run | CCBTC | CHAR | 20 | ||
| KKBER | Credit control area | KKBER | CHAR | 8 | T014 | |
| XREF3 | Reference key for line item | XREF3 | CHAR | 40 | ||
| DTWS1 | Instruction Key 1 | DTAT16 | NUMC | 4 | ||
| DTWS2 | Instruction Key 2 | DTAT17 | NUMC | 4 | ||
| DTWS3 | Instruction key 3 | DTAT18 | NUMC | 4 | ||
| DTWS4 | Instruction key 4 | DTAT19 | NUMC | 4 | ||
| ABSBT | Credit Management: Hedged Amount (Absolute) | ABSBT_X8 | CURR | 12 | ||
| KKBWR | Currency of Credit Control Area | KKBWR | CUKY | 10 | ||
| PROJK | Individual Structural Element (WBS Element) in Ext. Format | PROJK_EXT | CHAR | 48 | ||
| XPYPR | Indicator: Items from Payment Program Blocked | XPYPR | CHAR | 2 | ||
| KIDNO | Payment Reference | KIDNO | CHAR | 60 | ||
| XAUGP | Indicator: Item Has Been Cleared? | XAUGP | CHAR | 2 | ||
| BUPLA | Business Place | BUPLA | CHAR | 8 | J_1BBRANCH | |
| SECCO | Section Code | SECCO | CHAR | 8 | ||
| GKART | Offsetting Account Type | GKART | CHAR | 2 | ||
| GKONT | Offsetting Account Number | GKONT | CHAR | 20 | ||
| PYCUR | Currency for Automatic Payment | PYCUR | CUKY | 10 | TCURC | |
| PYAMT | Amount in Automatic Payment Currency (Absolute) | PYAMT_X8 | CURR | 12 | ||
| PYORD | Payment Order | PYORD | CHAR | 20 | ||
| XTEXT | Indicator: Texts Exist? | XTEXT_F02L | CHAR | 2 | ||
| TDID | Text ID | TDID | CHAR | 8 | ||
| XDUEN | Indicator: Item Is Due Net? | XDUEN | CHAR | 2 | ||
| XDUE1 | Indicator: Cash Discount Term 1 Is Due on Item? | XDUE1 | CHAR | 2 | ||
| XRAGL | Indicator: Clearing Was Reversed | XRAGL | CHAR | 2 | ||
| XSELP | Item selected (selected, chosen, ...) | XSELP | CHAR | 2 | ||
| COLOR | Color of Line Item in the List | COL_ITEM | CHAR | 6 | ||
| CESSION_KZ | Accounts Receivable Pledging Indicator | CESSION_KZ | CHAR | 4 | TCESSION | |
| BUZID | Identification of the Line Item | BUZID | CHAR | 2 | ||
| AUGGJ | Fiscal Year of Clearing Document | AUGGJ | NUMC | 8 | ||
| AGZEI | Clearing Item | AGZEI | DEC | 3 | ||
| SYM_AUGP | Item Status Symbol | SYM_AUGP | CHAR | 4 | ||
| ICO_AUGP | Cleared/Open Items Symbol | ICO_AUGP | CHAR | 68 | ||
| ICO_DUE | Net Due Date Symbol | ICO_DUE | CHAR | 68 | ||
| ICO_DUE1 | Discount 1 Due Date Symbol | ICO_DUE1 | CHAR | 68 | ||
| SORT | Sort Key for Line Item Report | ITEMSORT | INT4 | 4 | ||
| U_STBLG | Reverse Document Number | STBLG | CHAR | 20 | ||
| U_BWSHB1 | Valuation Difference for Line Item Display | BWSHB_V | CURR | 12 | ||
| U_PSTLZ | Postal Code | PSTLZ | CHAR | 20 | ||
| U_FWBAS | Tax Base Amount in Document Currency | FWBAS | CURR | 12 | ||
| U_REBZG | Document No. of the Invoice to Which the Transaction Belongs | REBZG | CHAR | 20 | ||
| U_CHECF | Check Number From | CHECF | CHAR | 26 | ||
| STCEG | VAT Registration Number | STCEG | CHAR | 40 | ||
| ACNAM | G/L Account Long Text | TXT50_SKAT | CHAR | 100 |