RFITEMAR_NO_ITEM - Item wise detail for the Customer Transactions
Item wise detail for the Customer Transactions information is stored in SAP table RFITEMAR_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 RFITEMAR_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 |