SAP TABLES | Financial Accounting | Localization(FI-LOC) SAP FI

RFITEMAR_NO_ITEM SAP Item wise detail for the Customer Transactions Table and data







RFITEMAR_NO_ITEM is a standard SAP Table which is used to store Item wise detail for the Customer Transactions data and is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about SAP RFITEMAR_NO_ITEM Table and the data within it using relevant transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: L - Table for storing temporary data, delivered empty

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)
See here for more information about this and other SAP enhancement categories


SAP RFITEMAR_NO_ITEM Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
BUKRSBUKRSCHAR4 T001Company Code
KONTOKTONR_AVCHAR10 Account NumberALPHA
GJAHRGJAHRNUMC4 Fiscal YearGJAHR
SEQNONUMC10NUMC10 Numeric Character Field, Length 10
UNAMEUNAMECHAR12 User Name
ACTIVACTIVNUMC2 List Level in which the Line Item is Active
ANLN1ANLN1CHAR12 ANLHMain Asset NumberALPHA
ANLN2ANLN2_4CHAR4 New asset subnumber, 4 charactersALPHA
AUFNRAUFNRCHAR12 AUFKOrder NumberALPHA
AUGBLAUGBLCHAR10 Document Number of the Clearing DocumentALPHA
AUGDTAUGDTDATS8 Clearing Date
BELNRBELNR_DCHAR10 Accounting Document NumberALPHA
BLARTBLARTCHAR2 T003Document Type
BLDATBLDATDATS8 Document Date in Document
BSCHLBSCHLCHAR2 TBSLPosting Key
BSTATBSTAT_DCHAR1 Document Status
BUDATBUDATDATS8 Posting Date in the Document
BUZEIBUZEINUMC3 Number of Line Item Within Accounting Document
BWWRTBWWRT_X8CURR15(2) Valuated Amount in Local Currency
BWWRCBWWRT_X8CURR15(2) Valuated Amount in Local Currency
BWWR2BWWR2_X8CURR15(2) Amount Valuated in Local Currency 2
BWWR3BWWR3_X8CURR15(2) Amount Valuated in Local Currency 3
DMSHBDMSHB_X8CURR15(2) Amount in Local Currency with +/- Signs
HWAERHWAERCUKY5
*
Local Currency
DMBE2DMBE2_X8CURR15(2) Amount in Second Local Currency
HWAE2HWAE2CUKY5
*
Currency Key of Second Local Currency
DMBE3DMBE3_X8CURR15(2) Amount in Third Local Currency
HWAE3HWAE3CUKY5
*
Currency Key of Third Local Currency
EBELNEBELNCHAR10 EKKOPurchasing Document NumberALPHA
EBELPEBELPNUMC5 EKPOItem Number of Purchasing Document
ETEN2ETENRNUMC4 VBEPDelivery Schedule Line Number
FAEDTFAEDT_FPOSDATS8 Net Due Date
FILKDFILKDCHAR10 Account Number of the BranchALPHA
GSBERGSBERCHAR4 TGSBBusiness Area
JAMONJAMON_XPOCHAR7 Fiscal Year/Posting Period from Posting Date
KOARTKOARTCHAR1 Account Type
KOSTLKOSTLCHAR10
*
Cost CenterALPHA
MABERMABERCHAR2 T047MDunning Area


MADATMADATDATS8 Last dunned on
MANSPMANSPCHAR1 T040SDunning block
MANSTMAHNS_DNUMC1 Dunning level
MONATMONATNUMC2 Fiscal Period
MSCHLMSCHLCHAR1 T040Dunning key
MWSKZMWSKZCHAR2 T007ATax on sales/purchases code
POSN2POSNR_VANUMC6 VBUPSales Document Item
PRCTRPRCTRCHAR10
*
Profit CenterALPHA
QBSHBQBSHB_X8CURR15(2) Withholding Tax Amount in Document Currency
QSFBTQSFBT_X8CURR15(2) Withholding Tax Exempt Amount in Document Currency
QSSHBQSSHB_X8CURR15(2) Withholding Tax Base Amount in Document Currency
REBZGREBZGCHAR10 Number of the Invoice the Transaction Belongs toALPHA
SAMNRSAMNRNUMC8 Invoice List Number
SGTXTSGTXTCHAR50 Item Text
SHKZGSHKZGCHAR1 Debit/Credit Indicator
SKFBTSKFBT_X8CURR15(2) Amount Eligible for Cash Discount in Document Currency
WSKTOWSKTO_X8CURR15(2) Cash Discount Amount in Document Currency
SKNTOSKNTO_X8CURR15(2) Cash Discount Amount in Local Currency
STAKZXSTKZCHAR1 Indicator: Statistical document ?
UMSKSUMSKSCHAR1 Special G/L Transaction Type
UMSKZUMSKZCHAR1 T074USpecial G/L Indicator
UZAWEUZAWECHAR2 T042FPayment Method Supplement
VALUTVALUTDATS8 Value date
VBEL2VBELN_VACHAR10 VBUKSales DocumentALPHA
VBELNVBELN_VFCHAR10 VBUKBilling DocumentALPHA
VBEWASBEWARTCHAR4
*
Flow Type
VBUNDRASSCCHAR6 T880Company ID of trading partnerALPHA
VERTNRANLCHAR13 Contract NumberALPHA
VERTTRANTYPCHAR1 Contract Type
VERZ1VERZ1DEC5 Days in Arrears for Cash Discount Terms 1
VERZNVERZNDEC5 Days in Arrears by Net Due Date
WERKSWERKS_DCHAR4 T001WPlant
WRSHBWRSHB_X8CURR15(2) Amount in Document Currency (Foreign Currency)
WRSHCWRSHB_X8CURR15(2) Amount in Document Currency (Foreign Currency)
WAERSWAER_DOCCUKY5
*
Document Currency (Key)
WVERWWVERWCHAR1 Bill of exchange usage type
XBLNRXBLNR1CHAR16 Reference Document Number
XSTRPXSTRPCHAR1 Indicator: Disputed item?
XZAHLXZAHLCHAR1 Indicator: Is the posting key used in a payment transaction?


ZALDTDZALDTDATS8 Probable Payment Date (Cash Discount 1 Due)
ZBD1PDZBD1PDEC5(3) Cash Discount Percentage 1
ZBD1TDZBD1TDEC3 Cash discount days 1
ZBD2PDZBD2PDEC5(3) Cash Discount Percentage 2
ZBD2TDZBD2TDEC3 Cash discount days 2
ZBD3TDZBD3TDEC3 Net Payment Terms Period
ZFBDTDZFBDTDATS8 Baseline Date for Due Date Calculation
ZINSZDZINSZCURR15(2) Interest Calculation Numerator (Days in Arrears * Amount)
ZLSCHDZLSCHCHAR1 T042ZPayment Method
ZLSPRDZLSPRCHAR1 T008Payment Block Key
ZTERMDZTERMCHAR4 Terms of Payment Key
ZUONRDZUONRCHAR18 Assignment Number
XREF1XREF1CHAR12 Business partner reference key
XREF2XREF2CHAR12 Business partner reference key
XARCHXARCHCHAR1 Indicator: Document already archived ?
RSTGRRSTGRCHAR3 T053RReason Code for Payments
ASKTOASKTO_X8CURR15(2) Current Cash Discount Amount in Document Currency
KURSEKURSEDEC9(5) Effective Exchange Rate in the Line ItemEXCRT
REBZTREBZTCHAR1 Follow-On Document Type
PSWSLPSWSLCUKY5 TCURCUpdate Currency for General Ledger Transaction Figures
PSWBTPSWBT_X8CURR15(2) Amount for General Ledger Update (Absolute)
HKONTHKONTCHAR10 SKA1General Ledger AccountALPHA
XNEGPXNEGPCHAR1 Indicator: Negative posting
ZBFIXDZBFIXCHAR1 Fixed Payment Terms
RFZEIRFZEI_CCNUMC3 Payment Card Item
CCBTCCCBTCCHAR10 Payment cards: Settlement runALPHA
KKBERKKBERCHAR4 T014Credit control area
XREF3XREF3CHAR20 Reference key for line item
DTWS1DTAT16NUMC2
*
Instruction key 1
DTWS2DTAT17NUMC2
*
Instruction key 2
DTWS3DTAT18NUMC2
*
Instruction key 3
DTWS4DTAT19NUMC2
*
Instruction key 4
ABSBTABSBT_X8CURR15(2) Credit Management: Hedged Amount (Absolute)
KKBWRKKBWRCUKY5
*
Currency of Credit Control Area
PROJKPROJK_EXTCHAR24 Individual Structural Element (WBS Element) in Ext. Format
XPYPRXPYPRCHAR1 Indicator: Items from Payment Program Blocked
KIDNOKIDNOCHAR30 Payment Reference
XAUGPXAUGPCHAR1 Indicator: Item has been cleared?
BUPLABUPLACHAR4 J_1BBRANCHBusiness Place

SECCOSECCOCHAR4
*
Section Code
GKARTGKARTCHAR1 Offsetting Account Type
GKONTGKONTCHAR10 Offsetting Account NumberALPHA
PYCURPYCURCUKY5 TCURCCurrency for Automatic Payment
PYAMTPYAMT_X8CURR15(2) Amount in Automatic Payment Currency (Absolute)
PYORDPYORDCHAR10 Payment OrderALPHA
XTEXTXTEXT_F02LCHAR1 Indicator: Texts exist ?
TDIDTDIDCHAR4
*
Text ID
XDUENXDUENCHAR1 Indicator: Item is due net?
XDUE1XDUE1CHAR1 Indicator: Cash discount term 1 is due on item?
XRAGLXRAGLCHAR1 Indicator: Clearing was Reversed
XSELPXSELPCHAR1 Item selected (selected, chosen, ...)
COLORCOL_ITEMCHAR3 Color of Line Item in the List
CESSION_KZCESSION_KZCHAR2 TCESSIONAccounts Receivable Pledging Indicator
BUZIDBUZIDCHAR1 Identification of the Line Item
AUGGJAUGGJNUMC4 Fiscal Year of Clearing DocumentGJAHR
AGZEIAGZEIDEC5 Clearing Item
SYM_AUGPSYM_AUGPCHAR2 Item Status Symbol
ICO_AUGPICO_AUGPCHAR34 Cleared/Open Items Symbol
ICO_DUEICO_DUECHAR34 Net Due Date Symbol
ICO_DUE1ICO_DUE1CHAR34 Discount 1 Due Date Symbol
SORTITEMSORTINT410 Sort Key for Line Item Report
U_STBLGSTBLGCHAR10 Reverse Document NumberALPHA
U_BWSHB1BWSHB_VCURR15(2) Valuation Difference for Line Item Display
U_PSTLZPSTLZCHAR10 Postal Code
U_FWBASFWBASCURR13(2) Tax Base Amount in Document Currency
U_REBZGREBZGCHAR10 Number of the Invoice the Transaction Belongs toALPHA
U_CHECFCHECFCHAR13 Check Number From
STCEGSTCEGCHAR20 VAT Registration Number
ACNAMTXT50_SKATCHAR50 G/L Account Long Text



Key field
Non-key field