RFITEMAR_NO_ITEM SAP table for – Item wise detail for the Customer Transactions

Here we would like to draw your attention to RFITEMAR_NO_ITEM table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). RFITEMAR_NO_ITEM is a SAP standard transp table used for storing Item wise detail for the Customer Transactions related data in SAP. It comes under the package ID-FI-SCAND.

SAP RFITEMAR_NO_ITEM table

Table RFITEMAR_NO_ITEM technical data

TableRFITEMAR_NO_ITEM
Data storingItem wise detail for the Customer Transactions
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-FI-SCAND
Delivery ClassL – Table for storing temporary data
ComponentSAP_FIN
Table CategoryTRANSP

SAP RFITEMAR_NO_ITEM Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in RFITEMAR_NO_ITEM table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • KONTO : Account Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • SEQNO : Numeric Character Field, Length 10
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • UNAME : User Name
    Its data type is CHAR (Character String) with field length 12
  • ACTIV : List Level in which the Line Item is Active
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • ANLN1 : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • ANLN2 : New asset subnumber, 4 characters
    Its data type is CHAR (Character String) with field length 4
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • AUGBL : Document Number of the Clearing Document
    Its data type is CHAR (Character String) with field length 10
  • AUGDT : Clearing Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BELNR : Accounting Document Number
    Its data type is CHAR (Character String) with field length 10
  • BLART : Document type
    Its data type is CHAR (Character String) with field length 2
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BSCHL : Posting Key
    Its data type is CHAR (Character String) with field length 2
  • BSTAT : Document Status
    Its data type is CHAR (Character String) with field length 1
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUZEI : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • BWWRT : Valuated Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • BWWRC : Valuated Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • BWWR2 : Amount Valuated in Local Currency 2
    Its data type is CURR (Currency Field) with field length 15
  • BWWR3 : Amount Valuated in Local Currency 3
    Its data type is CURR (Currency Field) with field length 15
  • DMSHB : Amount in Local Currency with +/- Signs
    Its data type is CURR (Currency Field) with field length 15
  • HWAER : Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DMBE2 : Amount in Second Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWAE2 : Currency Key of Second Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • DMBE3 : Amount in Third Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • HWAE3 : Currency Key of Third Local Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • EBELN : Purchasing Document Number
    Its data type is CHAR (Character String) with field length 10
  • EBELP : Item Number of Purchasing Document
    Its data type is NUMC (Character String with Digits Only) with field length 5
  • ETEN2 : Schedule line
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • FAEDT : Net Due Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • FILKD : Account Number of the Branch
    Its data type is CHAR (Character String) with field length 10
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • JAMON : Fiscal Year/Posting Period from Posting Date
    Its data type is CHAR (Character String) with field length 7
  • KOART : Account type
    Its data type is CHAR (Character String) with field length 1
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • MABER : Dunning Area
    Its data type is CHAR (Character String) with field length 2
  • MADAT : Date of Last Dunning Notice
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MANSP : Dunning block
    Its data type is CHAR (Character String) with field length 1
  • MANST : Dunning Level
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • MONAT : Fiscal period
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • MSCHL : Dunning key
    Its data type is CHAR (Character String) with field length 1
  • MWSKZ : Tax on sales/purchases code
    Its data type is CHAR (Character String) with field length 2
  • POSN2 : Sales Document Item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • QBSHB : Withholding Tax Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • QSFBT : Withholding Tax Exempt Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • QSSHB : Withholding Tax Base Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • REBZG : Number of the Invoice the Transaction Belongs to
    Its data type is CHAR (Character String) with field length 10
  • SAMNR : Invoice List Number
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • SGTXT : Item Text
    Its data type is CHAR (Character String) with field length 50
  • SHKZG : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • SKFBT : Amount Eligible for Cash Discount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • WSKTO : Cash Discount Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • SKNTO : Cash Discount Amount in Local Currency
    Its data type is CURR (Currency Field) with field length 15
  • STAKZ : Indicator: Statistical document ?
    Its data type is CHAR (Character String) with field length 1
  • UMSKS : Special G/L Transaction Type
    Its data type is CHAR (Character String) with field length 1
  • UMSKZ : Special G/L Indicator
    Its data type is CHAR (Character String) with field length 1
  • UZAWE : Payment method supplement
    Its data type is CHAR (Character String) with field length 2
  • VALUT : Fixed Value Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VBEL2 : Sales Document
    Its data type is CHAR (Character String) with field length 10
  • VBELN : Billing document
    Its data type is CHAR (Character String) with field length 10
  • VBEWA : Flow Type
    Its data type is CHAR (Character String) with field length 4
  • VBUND : Company ID of trading partner
    Its data type is CHAR (Character String) with field length 6
  • VERTN : Contract Number
    Its data type is CHAR (Character String) with field length 13
  • VERTT : Contract Type
    Its data type is CHAR (Character String) with field length 1
  • VERZ1 : Days in Arrears for Cash Discount Terms 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • VERZN : Days in Arrears by Net Due Date
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • WRSHB : Amount in Document Currency (Foreign Currency)
    Its data type is CURR (Currency Field) with field length 15
  • WRSHC : Amount in Document Currency (Foreign Currency)
    Its data type is CURR (Currency Field) with field length 15
  • WAERS : Document Currency (Key)
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • WVERW : Bill of Exchange Usage Type
    Its data type is CHAR (Character String) with field length 1
  • XBLNR : Reference Document Number
    Its data type is CHAR (Character String) with field length 16
  • XSTRP : Indicator: Disputed item?
    Its data type is CHAR (Character String) with field length 1
  • XZAHL : Indicator: Is Posting Key Used in a Payment Transaction?
    Its data type is CHAR (Character String) with field length 1
  • ZALDT : Probable Payment Date (Cash Discount 1 Due)
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ZBD1P : Cash discount percentage 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ZBD1T : Cash discount days 1
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • ZBD2P : Cash Discount Percentage 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • ZBD2T : Cash discount days 2
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • ZBD3T : Net Payment Terms Period
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3
  • ZFBDT : Baseline date for due date calculation
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ZINSZ : Interest Calculation Numerator (Days in Arrears * Amount)
    Its data type is CURR (Currency Field) with field length 15
  • ZLSCH : Payment method
    Its data type is CHAR (Character String) with field length 1
  • ZLSPR : Payment Block Key
    Its data type is CHAR (Character String) with field length 1
  • ZTERM : Terms of payment key
    Its data type is CHAR (Character String) with field length 4
  • ZUONR : Assignment number
    Its data type is CHAR (Character String) with field length 18
  • XREF1 : Business partner reference key
    Its data type is CHAR (Character String) with field length 12
  • XREF2 : Business partner reference key
    Its data type is CHAR (Character String) with field length 12
  • XARCH : Indicator: Document already archived ?
    Its data type is CHAR (Character String) with field length 1
  • RSTGR : Reason Code for Payments
    Its data type is CHAR (Character String) with field length 3
  • ASKTO : Current Cash Discount Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 15
  • KURSE : Effective Exchange Rate in the Line Item
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • REBZT : Follow-On Document Type
    Its data type is CHAR (Character String) with field length 1
  • PSWSL : Update Currency for General Ledger Transaction Figures
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PSWBT : Amount for General Ledger Update (Absolute)
    Its data type is CURR (Currency Field) with field length 15
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • XNEGP : Indicator: Negative posting
    Its data type is CHAR (Character String) with field length 1
  • ZBFIX : Fixed Payment Terms
    Its data type is CHAR (Character String) with field length 1
  • RFZEI : Payment Card Item
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • CCBTC : Payment cards: Settlement run
    Its data type is CHAR (Character String) with field length 10
  • KKBER : Credit control area
    Its data type is CHAR (Character String) with field length 4
  • XREF3 : Reference key for line item
    Its data type is CHAR (Character String) with field length 20
  • DTWS1 : Instruction key 1
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DTWS2 : Instruction key 2
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DTWS3 : Instruction key 3
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • DTWS4 : Instruction key 4
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • ABSBT : Credit Management: Hedged Amount (Absolute)
    Its data type is CURR (Currency Field) with field length 15
  • KKBWR : Currency of Credit Control Area
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PROJK : Individual Structural Element (WBS Element) in Ext. Format
    Its data type is CHAR (Character String) with field length 24
  • XPYPR : Indicator: Items from Payment Program Blocked
    Its data type is CHAR (Character String) with field length 1
  • KIDNO : Payment Reference
    Its data type is CHAR (Character String) with field length 30
  • XAUGP : Indicator: Item has been cleared?
    Its data type is CHAR (Character String) with field length 1
  • BUPLA : Business Place
    Its data type is CHAR (Character String) with field length 4
  • SECCO : Section Code
    Its data type is CHAR (Character String) with field length 4
  • GKART : Offsetting Account Type
    Its data type is CHAR (Character String) with field length 1
  • GKONT : Offsetting Account Number
    Its data type is CHAR (Character String) with field length 10
  • PYCUR : Currency for Automatic Payment
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PYAMT : Amount in Automatic Payment Currency (Absolute)
    Its data type is CURR (Currency Field) with field length 15
  • PYORD : Payment Order
    Its data type is CHAR (Character String) with field length 10
  • XTEXT : Indicator: Texts exist ?
    Its data type is CHAR (Character String) with field length 1
  • TDID : Text ID
    Its data type is CHAR (Character String) with field length 4
  • XDUEN : Indicator: Item is due net?
    Its data type is CHAR (Character String) with field length 1
  • XDUE1 : Indicator: Cash discount term 1 is due on item?
    Its data type is CHAR (Character String) with field length 1
  • XRAGL : Indicator: Clearing was Reversed
    Its data type is CHAR (Character String) with field length 1
  • XSELP : Item selected (selected, chosen, …)
    Its data type is CHAR (Character String) with field length 1
  • COLOR : Color of Line Item in the List
    Its data type is CHAR (Character String) with field length 3
  • CESSION_KZ : Accounts Receivable Pledging Indicator
    Its data type is CHAR (Character String) with field length 2
  • BUZID : Identification of the Line Item
    Its data type is CHAR (Character String) with field length 1
  • AUGGJ : Fiscal Year of Clearing Document
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • AGZEI : Clearing Item
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
  • SYM_AUGP : Item Status Symbol
    Its data type is CHAR (Character String) with field length 2
  • ICO_AUGP : Cleared/Open Items Symbol
    Its data type is CHAR (Character String) with field length 34
  • ICO_DUE : Net Due Date Symbol
    Its data type is CHAR (Character String) with field length 34
  • ICO_DUE1 : Discount 1 Due Date Symbol
    Its data type is CHAR (Character String) with field length 34
  • SORT : Sort Key for Line Item Report
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • U_STBLG : Reverse Document Number
    Its data type is CHAR (Character String) with field length 10
  • U_BWSHB1 : Valuation Difference for Line Item Display
    Its data type is CURR (Currency Field) with field length 15
  • U_PSTLZ : Postal Code
    Its data type is CHAR (Character String) with field length 10
  • U_FWBAS : Tax Base Amount in Document Currency
    Its data type is CURR (Currency Field) with field length 13
  • U_REBZG : Number of the Invoice the Transaction Belongs to
    Its data type is CHAR (Character String) with field length 10
  • U_CHECF : Check Number From
    Its data type is CHAR (Character String) with field length 13
  • STCEG : VAT Registration Number
    Its data type is CHAR (Character String) with field length 20
  • ACNAM : G/L Account Long Text
    Its data type is CHAR (Character String) with field length 50