SAP ABAP Table RFITEMAR_NO_ITEM (Item wise detail for the Customer Transactions)
Hierarchy
☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-FI-SCAND (Package) Localisation FI Scandinavia
Basic Data
Table Category TRANSP    Transparent table 
Transparent table RFITEMAR_NO_ITEM   Table Relationship Diagram
Short Description Item wise detail for the Customer Transactions    
Delivery and Maintenance
Pool/cluster      
Delivery Class L   Table for storing temporary data, delivered empty 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T001
3 KONTO KTONR_AV KTONR CHAR 10   0   Account Number  
4 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
5 SEQNO NUMC10 NUMC10 NUMC 10   0   Numeric Character Field, Length 10  
6 UNAME UNAME UNAME CHAR 12   0   User Name  
7 ACTIV ACTIV NUM02 NUMC 2   0   List Level in which the Line Item is Active  
8 ANLN1 ANLN1 ANLN1 CHAR 12   0   Main Asset Number ANLH
9 ANLN2 ANLN2_4 ANLN2_4 CHAR 4   0   New asset subnumber, 4 characters  
10 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
11 AUGBL AUGBL BELNR CHAR 10   0   Document Number of the Clearing Document  
12 AUGDT AUGDT DATUM DATS 8   0   Clearing Date  
13 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
14 BLART BLART BLART CHAR 2   0   Document type T003
15 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
16 BSCHL BSCHL BSCHL CHAR 2   0   Posting Key TBSL
17 BSTAT BSTAT_D BSTAT CHAR 1   0   Document Status  
18 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
19 BUZEI BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
20 BWWRT BWWRT_X8 WRTV8 CURR 15   2   Valuated Amount in Local Currency  
21 BWWRC BWWRT_X8 WRTV8 CURR 15   2   Valuated Amount in Local Currency  
22 BWWR2 BWWR2_X8 WRTV8 CURR 15   2   Amount Valuated in Local Currency 2  
23 BWWR3 BWWR3_X8 WRTV8 CURR 15   2   Amount Valuated in Local Currency 3  
24 DMSHB DMSHB_X8 WRTV8 CURR 15   2   Amount in Local Currency with +/- Signs  
25 HWAER HWAER WAERS CUKY 5   0   Local Currency *
26 DMBE2 DMBE2_X8 WRTV8 CURR 15   2   Amount in Second Local Currency  
27 HWAE2 HWAE2 WAERS CUKY 5   0   Currency Key of Second Local Currency *
28 DMBE3 DMBE3_X8 WRTV8 CURR 15   2   Amount in Third Local Currency  
29 HWAE3 HWAE3 WAERS CUKY 5   0   Currency Key of Third Local Currency *
30 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number EKKO
31 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document EKPO
32 ETEN2 ETENR ETENR NUMC 4   0   Schedule line VBEP
33 FAEDT FAEDT_FPOS DATUM DATS 8   0   Net Due Date  
34 FILKD FILKD MAXKK CHAR 10   0   Account Number of the Branch  
35 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
36 JAMON JAMON_XPO JAMON_XPO CHAR 7   0   Fiscal Year/Posting Period from Posting Date  
37 KOART KOART KOART CHAR 1   0   Account type  
38 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
39 MABER MABER MABER CHAR 2   0   Dunning Area T047M
40 MADAT MADAT DATUM DATS 8   0   Date of Last Dunning Notice  
41 MANSP MANSP MANSP CHAR 1   0   Dunning block T040S
42 MANST MAHNS_D MAHNS NUMC 1   0   Dunning Level  
43 MONAT MONAT MONAT NUMC 2   0   Fiscal period  
44 MSCHL MSCHL MSCHL CHAR 1   0   Dunning key T040
45 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code T007A
46 POSN2 POSNR_VA POSNR NUMC 6   0   Sales Document Item VBUP
47 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
48 QBSHB QBSHB_X8 WRTV8 CURR 15   2   Withholding Tax Amount in Document Currency  
49 QSFBT QSFBT_X8 WRTV8 CURR 15   2   Withholding Tax Exempt Amount in Document Currency  
50 QSSHB QSSHB_X8 WRTV8 CURR 15   2   Withholding Tax Base Amount in Document Currency  
51 REBZG REBZG BELNR CHAR 10   0   Number of the Invoice the Transaction Belongs to  
52 SAMNR SAMNR SAMNR NUMC 8   0   Invoice List Number  
53 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
54 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
55 SKFBT SKFBT_X8 WRTV8 CURR 15   2   Amount Eligible for Cash Discount in Document Currency  
56 WSKTO WSKTO_X8 WRTV8 CURR 15   2   Cash Discount Amount in Document Currency  
57 SKNTO SKNTO_X8 WRTV8 CURR 15   2   Cash Discount Amount in Local Currency  
58 STAKZ XSTKZ XFELD CHAR 1   0   Indicator: Statistical document ?  
59 UMSKS UMSKS UMSKS CHAR 1   0   Special G/L Transaction Type  
60 UMSKZ UMSKZ UMSKZ CHAR 1   0   Special G/L Indicator T074U
61 UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement T042F
62 VALUT VALUT DATUM DATS 8   0   Fixed Value Date  
63 VBEL2 VBELN_VA VBELN CHAR 10   0   Sales Document VBUK
64 VBELN VBELN_VF VBELN CHAR 10   0   Billing document VBUK
65 VBEWA SBEWART SBEWART CHAR 4   0   Flow Type *
66 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner T880
67 VERTN RANL RANL CHAR 13   0   Contract Number  
68 VERTT RANTYP RANTYP CHAR 1   0   Contract Type  
69 VERZ1 VERZ1 WRTV3 DEC 5   0   Days in Arrears for Cash Discount Terms 1  
70 VERZN VERZN WRTV3 DEC 5   0   Days in Arrears by Net Due Date  
71 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
72 WRSHB WRSHB_X8 WRTV8 CURR 15   2   Amount in Document Currency (Foreign Currency)  
73 WRSHC WRSHB_X8 WRTV8 CURR 15   2   Amount in Document Currency (Foreign Currency)  
74 WAERS WAER_DOC WAERS CUKY 5   0   Document Currency (Key) *
75 WVERW WVERW WVERW CHAR 1   0   Bill of Exchange Usage Type  
76 XBLNR XBLNR1 XBLNR1 CHAR 16   0   Reference Document Number  
77 XSTRP XSTRP XFELD CHAR 1   0   Indicator: Disputed item?  
78 XZAHL XZAHL XFELD CHAR 1   0   Indicator: Is Posting Key Used in a Payment Transaction?  
79 ZALDT DZALDT DATUM DATS 8   0   Probable Payment Date (Cash Discount 1 Due)  
80 ZBD1P DZBD1P PRZ23 DEC 5   3   Cash discount percentage 1  
81 ZBD1T DZBD1T ZBDXT DEC 3   0   Cash discount days 1  
82 ZBD2P DZBD2P PRZ23 DEC 5   3   Cash Discount Percentage 2  
83 ZBD2T DZBD2T ZBDXT DEC 3   0   Cash discount days 2  
84 ZBD3T DZBD3T ZBDXT DEC 3   0   Net Payment Terms Period  
85 ZFBDT DZFBDT DATUM DATS 8   0   Baseline date for due date calculation  
86 ZINSZ DZINSZ WRTV8 CURR 15   2   Interest Calculation Numerator (Days in Arrears * Amount)  
87 ZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method T042Z
88 ZLSPR DZLSPR ZAHLS CHAR 1   0   Payment Block Key T008
89 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
90 ZUONR DZUONR ZUONR CHAR 18   0   Assignment number  
91 XREF1 XREF1 CHAR12 CHAR 12   0   Business partner reference key  
92 XREF2 XREF2 CHAR12 CHAR 12   0   Business partner reference key  
93 XARCH XARCH XFELD CHAR 1   0   Indicator: Document already archived ?  
94 RSTGR RSTGR RSTGR CHAR 3   0   Reason Code for Payments T053R
95 ASKTO ASKTO_X8 WRTV8 CURR 15   2   Current Cash Discount Amount in Document Currency  
96 KURSE KURSE KURSF DEC 9   5   Effective Exchange Rate in the Line Item  
97 REBZT REBZT REBZT CHAR 1   0   Follow-On Document Type  
98 PSWSL PSWSL WAERS CUKY 5   0   Update Currency for General Ledger Transaction Figures TCURC
99 PSWBT PSWBT_X8 WERT8 CURR 15   2   Amount for General Ledger Update (Absolute)  
100 HKONT HKONT SAKNR CHAR 10   0   General Ledger Account SKA1
101 XNEGP XNEGP XFELD CHAR 1   0   Indicator: Negative posting  
102 ZBFIX DZBFIX ZBFIX CHAR 1   0   Fixed Payment Terms  
103 RFZEI RFZEI_CC NUM03 NUMC 3   0   Payment Card Item  
104 CCBTC CCBTC CCBTC CHAR 10   0   Payment cards: Settlement run  
105 KKBER KKBER KKBER CHAR 4   0   Credit control area T014
106 XREF3 XREF3 CHAR20 CHAR 20   0   Reference key for line item  
107 DTWS1 DTAT16 DTWSX NUMC 2   0   Instruction key 1 *
108 DTWS2 DTAT17 DTWSX NUMC 2   0   Instruction key 2 *
109 DTWS3 DTAT18 DTWSX NUMC 2   0   Instruction key 3 *
110 DTWS4 DTAT19 DTWSX NUMC 2   0   Instruction key 4 *
111 ABSBT ABSBT_X8 WERT8 CURR 15   2   Credit Management: Hedged Amount (Absolute)  
112 KKBWR KKBWR WAERS CUKY 5   0   Currency of Credit Control Area *
113 PROJK PROJK_EXT CHAR24 CHAR 24   0   Individual Structural Element (WBS Element) in Ext. Format  
114 XPYPR XPYPR XFELD CHAR 1   0   Indicator: Items from Payment Program Blocked  
115 KIDNO KIDNO CHAR30 CHAR 30   0   Payment Reference  
116 XAUGP XAUGP XFELD CHAR 1   0   Indicator: Item has been cleared?  
117 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place J_1BBRANCH
118 SECCO SECCO SECCO CHAR 4   0   Section Code *
119 GKART GKART GKART CHAR 1   0   Offsetting Account Type  
120 GKONT GKONT GKONT CHAR 10   0   Offsetting Account Number  
121 PYCUR PYCUR WAERS CUKY 5   0   Currency for Automatic Payment TCURC
122 PYAMT PYAMT_X8 WERT8 CURR 15   2   Amount in Automatic Payment Currency (Absolute)  
123 PYORD PYORD PYORD CHAR 10   0   Payment Order  
124 XTEXT XTEXT_F02L XFELD CHAR 1   0   Indicator: Texts exist ?  
125 TDID TDID TDID CHAR 4   0   Text ID *
126 XDUEN XDUEN XFELD CHAR 1   0   Indicator: Item is due net?  
127 XDUE1 XDUE1 XFELD CHAR 1   0   Indicator: Cash discount term 1 is due on item?  
128 XRAGL XRAGL XFELD CHAR 1   0   Indicator: Clearing was Reversed  
129 XSELP XSELP XFELD CHAR 1   0   Item selected (selected, chosen, ...)  
130 COLOR COL_ITEM COL_ITEM CHAR 3   0   Color of Line Item in the List  
131 CESSION_KZ CESSION_KZ CESSION_KZ CHAR 2   0   Accounts Receivable Pledging Indicator TCESSION
132 BUZID BUZID CHAR1 CHAR 1   0   Identification of the Line Item  
133 AUGGJ AUGGJ GJAHR NUMC 4   0   Fiscal Year of Clearing Document  
134 AGZEI AGZEI AGZEI DEC 5   0   Clearing Item  
135 SYM_AUGP SYM_AUGP SYM_2 CHAR 2   0   Item Status Symbol  
136 ICO_AUGP ICO_AUGP ICON_34_2 CHAR 34   0   Cleared/Open Items Symbol  
137 ICO_DUE ICO_DUE ICON_34_2 CHAR 34   0   Net Due Date Symbol  
138 ICO_DUE1 ICO_DUE1 ICON_34_2 CHAR 34   0   Discount 1 Due Date Symbol  
139 SORT ITEMSORT   INT4 10   0   Sort Key for Line Item Report  
140 U_STBLG STBLG BELNR CHAR 10   0   Reverse Document Number  
141 U_BWSHB1 BWSHB_V WRTV8 CURR 15   2   Valuation Difference for Line Item Display  
142 U_PSTLZ PSTLZ PSTLZ CHAR 10   0   Postal Code  
143 U_FWBAS FWBAS WERT7 CURR 13   2   Tax Base Amount in Document Currency  
144 U_REBZG REBZG BELNR CHAR 10   0   Number of the Invoice the Transaction Belongs to  
145 U_CHECF CHECF CHCKN CHAR 13   0   Check Number From  
146 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
147 ACNAM TXT50_SKAT TEXT50 CHAR 50   0   G/L Account Long Text  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RFITEMAR_NO_ITEM ANLN1 ANLH ANLN1    
2 RFITEMAR_NO_ITEM AUFNR AUFK AUFNR    
3 RFITEMAR_NO_ITEM BLART T003 BLART    
4 RFITEMAR_NO_ITEM BSCHL TBSL BSCHL    
5 RFITEMAR_NO_ITEM BUKRS T001 BUKRS    
6 RFITEMAR_NO_ITEM BUPLA J_1BBRANCH BRANCH    
7 RFITEMAR_NO_ITEM CESSION_KZ TCESSION CESSION_KZ    
8 RFITEMAR_NO_ITEM EBELN EKKO EBELN    
9 RFITEMAR_NO_ITEM EBELP EKPO EBELP    
10 RFITEMAR_NO_ITEM ETEN2 VBEP ETENR    
11 RFITEMAR_NO_ITEM GSBER TGSB GSBER    
12 RFITEMAR_NO_ITEM HKONT SKA1 SAKNR    
13 RFITEMAR_NO_ITEM KKBER T014 KKBER    
14 RFITEMAR_NO_ITEM MABER T047M MABER    
15 RFITEMAR_NO_ITEM MANDT T000 MANDT    
16 RFITEMAR_NO_ITEM MANSP T040S MANSP    
17 RFITEMAR_NO_ITEM MSCHL T040 MSCHL    
18 RFITEMAR_NO_ITEM MWSKZ T007A MWSKZ    
19 RFITEMAR_NO_ITEM POSN2 VBUP POSNR    
20 RFITEMAR_NO_ITEM PSWSL TCURC WAERS    
21 RFITEMAR_NO_ITEM PYCUR TCURC WAERS    
22 RFITEMAR_NO_ITEM RSTGR T053R RSTGR    
23 RFITEMAR_NO_ITEM UMSKZ T074U UMSKZ    
24 RFITEMAR_NO_ITEM UZAWE T042F UZAWE    
25 RFITEMAR_NO_ITEM VBEL2 VBUK VBELN    
26 RFITEMAR_NO_ITEM VBELN VBUK VBELN    
27 RFITEMAR_NO_ITEM VBUND T880 RCOMP    
28 RFITEMAR_NO_ITEM WERKS T001W WERKS    
29 RFITEMAR_NO_ITEM ZLSCH T042Z ZLSCH    
30 RFITEMAR_NO_ITEM ZLSPR T008 ZAHLS    
History
Last changed by/on SAP  20130529 
SAP Release Created in 605