SAP ABAP Table RFOPS (Open Item Data for Clearing Transactions)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBAS (Package) Financial accounting 'Basis'
Basic Data
Table Category INTTAB    Structure 
Structure RFOPS   Table Relationship Diagram
Short Description Open Item Data for Clearing Transactions    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
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 BELNR BELNR_D BELNR CHAR 10   0   Accounting Document Number  
2 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
3 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
4 BUZEI BUZEI BUZEI NUMC 3   0   Number of Line Item Within Accounting Document  
5 WAERS WAERS WAERS CUKY 5   0   Currency Key *
6 XBLNR XBLNR1 XBLNR1 CHAR 16   0   Reference Document Number  
7 BLART BLART BLART CHAR 2   0   Document type *
8 BUDAT BUDAT DATUM DATS 8   0   Posting Date in the Document  
9 BLDAT BLDAT DATUM DATS 8   0   Document Date in Document  
10 XNETB XNETB XFELD CHAR 1   0   Indicator: Document posted net ?  
11 BSTAT BSTAT_D BSTAT CHAR 1   0   Document Status  
12 BSCHL BSCHL BSCHL CHAR 2   0   Posting Key *
13 UMSKZ UMSKZ UMSKZ CHAR 1   0   Special G/L Indicator *
14 UMSKS UMSKS UMSKS CHAR 1   0   Special G/L Transaction Type  
15 KOART KOART KOART CHAR 1   0   Account type  
16 HKONT HKONT SAKNR CHAR 10   0   General Ledger Account *
17 SAKNR SAKNR SAKNR CHAR 10   0   G/L Account Number *
18 FILKD FILKD MAXKK CHAR 10   0   Account Number of the Branch  
19 PARGB PARGB GSBER CHAR 4   0   Trading partner's business area *
20 GSBER GSBER GSBER CHAR 4   0   Business Area *
21 MABER MABER MABER CHAR 2   0   Dunning Area *
22 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
23 XANET XANET XFELD CHAR 1   0   Indicator: Down Payment in Net Procedure?  
24 MWSKZ MWSKZ MWSKZ CHAR 2   0   Tax on sales/purchases code *
25 MWSTS MWSTS WERT7 CURR 13   2   Tax Amount in Local Currency  
26 WMWST WMWST WERT7 CURR 13   2   Tax amount in document currency  
27 QSSKZ QSSKZ QSSKZ CHAR 2   0   Withholding Tax Code *
28 QSSHB QSSHB WERT7 CURR 13   2   Withholding Tax Base Amount  
29 QSSHH QSSHH WERT7 CURR 13   2   Withholding Tax Base Amount (Local Currency)  
30 QBSHB QBSHB WERT7 CURR 13   2   Withholding Tax Amount (in Document Currency)  
31 QBSHH QBSHH WERT7 CURR 13   2   Withholding Tax Amount (in Local Currency)  
32 QSZNR QSZNR CHAR10 CHAR 10   0   Certificate Number of the Withholding Tax Exemption  
33 BDIFF BDIFF WRTV7 CURR 13   2   Valuation Difference  
34 PPDIFF PPDIFF WRTV7 CURR 13   2   Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments)  
35 PPDIF2 PPDIF2 WRTV7 CURR 13   2   Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments)  
36 PPDIF3 PPDIF3 WRTV7 CURR 13   2   Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments)  
37 ZUONR DZUONR ZUONR CHAR 18   0   Assignment number  
38 DMBTR DMBTR WERT7 CURR 13   2   Amount in local currency  
39 WRBTR WRBTR WERT7 CURR 13   2   Amount in document currency  
40 SKNTO SKNTO WERT7 CURR 13   2   Cash discount amount in local currency  
41 WSKTO WSKTO WERT7 CURR 13   2   Cash Discount Amount in Document Currency  
42 SKFBT SKFBT WERT7 CURR 13   2   Amount Eligible for Cash Discount in Document Currency  
43 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
44 ZFBDT DZFBDT DATUM DATS 8   0   Baseline date for due date calculation  
45 ZBD1T DZBD1T ZBDXT DEC 3   0   Cash discount days 1  
46 ZBD2T DZBD2T ZBDXT DEC 3   0   Cash discount days 2  
47 ZBD3T DZBD3T ZBDXT DEC 3   0   Net Payment Terms Period  
48 ZBD1P DZBD1P PRZ23 DEC 5   3   Cash discount percentage 1  
49 ZBD2P DZBD2P PRZ23 DEC 5   3   Cash Discount Percentage 2  
50 REBZG REBZG BELNR CHAR 10   0   Number of the Invoice the Transaction Belongs to  
51 REBZJ REBZJ GJAHR NUMC 4   0   Fiscal Year of the Relevant Invoice (for Credit Memo)  
52 REBZZ REBZZ BUZEI NUMC 3   0   Line Item in the Relevant Invoice  
53 ZBFIX DZBFIX ZBFIX CHAR 1   0   Fixed Payment Terms  
54 SAMNR SAMNR SAMNR NUMC 8   0   Invoice List Number  
55 ANLN1 ANLN1 ANLN1 CHAR 12   0   Main Asset Number *
56 ANLN2 ANLN2_4 ANLN2_4 CHAR 4   0   New asset subnumber, 4 characters  
57 AUFNR AUFNR AUFNR CHAR 12   0   Order Number *
58 VBELN VBELN_VF VBELN CHAR 10   0   Billing document *
59 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number *
60 EBELP EBELP EBELP NUMC 5   0   Item Number of Purchasing Document *
61 ZEKKN DZEKKN NUM02 NUMC 2   0   Sequential Number of Account Assignment  
62 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
63 WERKS WERKS_D WERKS CHAR 4   0   Plant *
64 PROJK PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
65 NPLNR NPLNR AUFNR CHAR 12   0   Network Number for Account Assignment *
66 AUFPL CO_AUFPL AUFPL NUMC 10   0   Routing number of operations in the order  
67 APLZL CIM_COUNT CIM_COUNT NUMC 8   0   Internal counter  
68 ANFBN ANFBN BELNR CHAR 10   0   Document Number of the Bill of Exchange Payment Request  
69 ANFBJ ANFBJ GJAHR NUMC 4   0   Fiscal Year of the Bill of Exchange Payment Request Document  
70 ANFBU ANFBU BUKRS CHAR 4   0   Company Code in Which Bill of Exch.Payment Request Is Posted *
71 KONKO KONKO MAXKK CHAR 10   0   Open item account number  
72 ZBDXT DZBDXT ZBDXT DEC 3   0   Selected cash discount days  
73 ZBDXP DZBDXP PRZ23 DEC 5   3   Selected cash discount percentage rate  
74 VERZG VERZG WRTV3 DEC 5   0   Calculated Days in Arrears  
75 TOLER TOLER_043G TOLER_043G NUMC 2   0   Grace Days  
76 MWSK1 MWSKX MWSKZ CHAR 2   0   Tax Code for Distribution *
77 MWSK2 MWSKX MWSKZ CHAR 2   0   Tax Code for Distribution *
78 MWSK3 MWSKX MWSKZ CHAR 2   0   Tax Code for Distribution *
79 DMBT1 DMBTX WRTV7 CURR 13   2   Amount in Local Currency for Tax Distribution  
80 DMBT2 DMBTX WRTV7 CURR 13   2   Amount in Local Currency for Tax Distribution  
81 DMBT3 DMBTX WRTV7 CURR 13   2   Amount in Local Currency for Tax Distribution  
82 WRBT1 WRBTX WRTV7 CURR 13   2   Amount in foreign currency for tax breakdown  
83 WRBT2 WRBTX WRTV7 CURR 13   2   Amount in foreign currency for tax breakdown  
84 WRBT3 WRBTX WRTV7 CURR 13   2   Amount in foreign currency for tax breakdown  
85 NETHW NETHW WERT7 CURR 13   2   Net Amount in Local Currency  
86 NETFW NETFW WERT7 CURR 13   2   Net Amount in Foreign Currency  
87 DIFHW DIFHW WERT7 CURR 13   2   Amount Difference in Local Currency  
88 DIFFW DIFFW WRTV7 CURR 13   2   Amount Difference in Foreign Currency  
89 SKTFW WSKTO WERT7 CURR 13   2   Cash Discount Amount in Document Currency  
90 XAKTP XAKTP XFELD CHAR 1   0   Indicator: Items activated ?  
91 XAKTS XAKTS XFELD CHAR 1   0   Indicator: Cash discount activated ?  
92 XVORT XVORT XFELD CHAR 1   0   Indicator: Carryforward residual bal. for pmnt difference ?  
93 INSEL INSEL NUM01 NUMC 1   0   Indicator: Partial Selection of Postings  
94 ORISO ORISO PACK4 DEC 7   0   Index Number for Original Sorting  
95 XKOMB XKOMB XFELD CHAR 1   0   Indicator: Combined items ?  
96 STATU STATU_OPS CHAR1 CHAR 1   0   Exception Status for the Open Item  
97 PSWSL PSWSL WAERS CUKY 5   0   Update Currency for General Ledger Transaction Figures *
98 PSWBT PSWBT WERT7 CURR 13   2   Amount for Updating in General Ledger  
99 XCPDD XCPDD XFELD CHAR 1   0   Indicator: Address and Bank Data Set Individually  
100 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner *
101 ZLSPR DZLSPR ZAHLS CHAR 1   0   Payment Block Key *
102 MANSP MANSP MANSP CHAR 1   0   Dunning block T040S
103 STCEG STCEG STCEG CHAR 20   0   VAT Registration Number  
104 EGBLD EGBLD LAND1 CHAR 3   0   Country of Destination for Delivery of Goods *
105 EGLLD EGLLD LAND1 CHAR 3   0   Supplying Country for Delivery of Goods *
106 MANST MAHNS_D MAHNS NUMC 1   0   Dunning Level  
107 VERTT RANTYP RANTYP CHAR 1   0   Contract Type  
108 VERTN RANL RANL CHAR 13   0   Contract Number  
109 VBEWA SBEWART SBEWART CHAR 4   0   Flow Type *
110 FIPOS FIPOS FIPOS CHAR 14   0   Commitment Item *
111 RSTGR RSTGR RSTGR CHAR 3   0   Reason Code for Payments *
112 XEGDR XEGDR XFELD CHAR 1   0   Indicator: Triangular deal within the EU ?  
113 DMBE2 DMBE2 WERT7 CURR 13   2   Amount in Second Local Currency  
114 DMBE3 DMBE3 WERT7 CURR 13   2   Amount in Third Local Currency  
115 DMB21 DMB2X WRTV7 CURR 13   2   Amount in Second Local Currency for Tax Breakdown  
116 DMB22 DMB2X WRTV7 CURR 13   2   Amount in Second Local Currency for Tax Breakdown  
117 DMB23 DMB2X WRTV7 CURR 13   2   Amount in Second Local Currency for Tax Breakdown  
118 DMB31 DMB3X WRTV7 CURR 13   2   Amount in Third Local Currency for Tax Breakdown  
119 DMB32 DMB3X WRTV7 CURR 13   2   Amount in Third Local Currency for Tax Breakdown  
120 DMB33 DMB3X WRTV7 CURR 13   2   Amount in Third Local Currency for Tax Breakdown  
121 MWST2 MWST2 WERT7 CURR 13   2   Tax Amount in Second Local Currency  
122 MWST3 MWST3 WERT7 CURR 13   2   Tax Amount in Third Local Currency  
123 SKNT2 SKNT2 WERT7 CURR 13   2   Cash Discount Amount in Second Local Currency  
124 SKNT3 SKNT3 WERT7 CURR 13   2   Cash Discount Amount in Third Local Currency  
125 DIFH2 DIFH2 WERT7 CURR 13   2   Amount Difference in Second Local Currency  
126 DIFH3 DIFH3 WERT7 CURR 13   2   Amount Difference in Third Local Currency  
127 NETH2 NETH2 WERT7 CURR 13   2   Net Amount in Second Local Currency  
128 NETH3 NETH3 WERT7 CURR 13   2   Net Amount in Third Local Currency  
129 QBSH2 QBSH2 WERT7 CURR 13   2   Withholding Tax Amount in Second Local Currency  
130 QBSH3 QBSH3 WERT7 CURR 13   2   Withholding Tax Amount in Third Local Currency  
131 QSSH2 QSSH2 WERT7 CURR 13   2   Withholding Tax Base Amount in Second Local Currency  
132 QSSH3 QSSH3 WERT7 CURR 13   2   Withholding Tax Base Amount in Third Local Currency  
133 BDIF2 BDIF2 WRTV7 CURR 13   2   Valuation Difference for the Second Local Currency  
134 RDIF2 RDIF2 WRTV7 CURR 13   2   Exchange Rate Difference Realized for Second Local Currency  
135 BDIF3 BDIF3 WRTV7 CURR 13   2   Valuation Difference for the Third Local Currency  
136 RDIF3 RDIF3 WRTV7 CURR 13   2   Exchange Rate Difference Realized for Third Local Currency  
137 HBKID HBKID HBKID CHAR 5   0   Short key for a house bank *
138 HKTID HKTID HKTID CHAR 5   0   ID for account details *
139 BVTYP BVTYP BVTYP CHAR 4   0   Partner bank type  
140 OSKTO SKNTO WERT7 CURR 13   2   Cash discount amount in local currency  
141 XREF1 XREF1 CHAR12 CHAR 12   0   Business partner reference key  
142 XREF2 XREF2 CHAR12 CHAR 12   0   Business partner reference key  
143 XSKAN XSKAN_043G XFELD CHAR 1   0   Indicator: Only grant partial cash discount ?  
144 RSTGN RSTGR RSTGR CHAR 3   0   Reason Code for Payments *
145 IMKEY IMKEY IMKEY CHAR 8   0   Internal Key for Real Estate Object  
146 AVSID AVSID AVSID CHAR 16   0   Payment Advice Number  
147 AVSPO AVSPO AVSPO NUMC 5   0   Payment Advice Line Item  
148 TOGRU TOGRU TOGRU CHAR 4   0   Tolerance group for the business partner/G/L account *
149 VBEL2 VBELN_VA VBELN CHAR 10   0   Sales Document *
150 POSN2 POSNR_VA POSNR NUMC 6   0   Sales Document Item *
151 ETEN2 ETENR ETENR NUMC 4   0   Schedule line *
152 SGTXT SGTXT TEXT50 CHAR 50   0   Item Text  
153 FISTL FISTL FISTL CHAR 16   0   Funds Center *
154 GEBER BP_GEBER BP_GEBER CHAR 10   0   Fund *
155 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
156 GMVKZ FM_GMVKZ FM_GMVKZ CHAR 1   0   Item is in Execution  
157 SRTYPE FM_SRTYPE FM_SRTYPE CHAR 2   0   Type of Additional Receivable  
158 FKBER FKBER FKBER CHAR 16   0   Functional Area *
159 KBLNR KBLNR_FI KBLNR CHAR 10   0   Document number for earmarked funds *
160 KBLPOS KBLPOS KBLPOS NUMC 3   0   Earmarked Funds: Document Item *
161 NETDT NETDT DATUM DATS 8   0   Due Date for Net Payment  
162 VALUT VALUT DATUM DATS 8   0   Fixed Value Date  
163 DABRZ DABRBEZ DDAT DATS 8   0   Reference date for settlement  
164 LANDL LANDL LAND1 CHAR 3   0   Supplying Country *
165 LZBKZ LZBKZ LZBKZ CHAR 3   0   State central bank indicator *
166 CCBTC CCBTC CCBTC CHAR 10   0   Payment cards: Settlement run  
167 XNEGP XNEGP XFELD CHAR 1   0   Indicator: Negative posting  
168 KKBER KKBER KKBER CHAR 4   0   Credit control area T014
169 EMPFB EMPFB MAXKK CHAR 10   0   Payee/Payer  
170 PRCTR PRCTR PRCTR CHAR 10   0   Profit Center *
171 PPRCT PPRCTR PRCTR CHAR 10   0   Partner Profit Center *
172 REBZT REBZT REBZT CHAR 1   0   Follow-On Document Type  
173 XREF3 XREF3 CHAR20 CHAR 20   0   Reference key for line item  
174 ZUMSK DZUMSK UMSKZ CHAR 1   0   Target Special G/L Indicator *
175 DTWS1 DTAT16 DTWSX NUMC 2   0   Instruction key 1 *
176 DTWS2 DTAT17 DTWSX NUMC 2   0   Instruction key 2 *
177 DTWS3 DTAT18 DTWSX NUMC 2   0   Instruction key 3 *
178 DTWS4 DTAT19 DTWSX NUMC 2   0   Instruction key 4 *
179 XPYPR XPYPR XFELD CHAR 1   0   Indicator: Items from Payment Program Blocked  
180 KIDNO KIDNO CHAR30 CHAR 30   0   Payment Reference  
181 PYORD PYORD PYORD CHAR 10   0   Payment Order  
182 ZINKZ DZINKZ ZINKZ CHAR 2   0   Exempted from Interest Calculation  
183 INTRS INTRS WRTV7 CURR 13   2   Expected Incoming Interest Payment in Local Currency  
184 INPGR INPGR WRTV7 CURR 13   2   Expected Payment: Amount + Interest on Arrears in Loc.Curr.  
185 DIEKZ DIEKZ DIEKZ CHAR 1   0   Service indicator (foreign payment)  
186 ZLSCH DZLSCH ZLSCH CHAR 1   0   Payment method *
187 UZAWE UZAWE UZAWE CHAR 2   0   Payment method supplement *
188 KDWBT KDWBT WERT7 CURR 13   2   Difference Amount Due to Payment in Alternative Currency  
189 BUPLA BUPLA J_1BBRANCH CHAR 4   0   Business Place *
190 SECCO SECCO SECCO CHAR 4   0   Section Code *
191 PYCUR PYCUR WAERS CUKY 5   0   Currency for Automatic Payment *
192 PYAMT PYAMT WERT7 CURR 13   2   Amount in Payment Currency  
193 BEWAR RMVCT RMVCT CHAR 3   0   Transaction type *
194 LOTKZ PSO_LOTKZ LOTKZ CHAR 10   0   Lot Number for Requests  
195 ZBDXP_D DZBDXP_INT PRZ23 DEC 5   3   Internal: Selected Cash Discount Percentage Rate  
196 XAKTS_D XAKTS_INT XFELD CHAR 1   0   Internal Indicator: Cash Discount Active?  
197 VERZG_D VERZG_INT WRTV3 DEC 5   0   Internal: Calculated Days in Arrears  
198 BUZID BUZID CHAR1 CHAR 1   0   Identification of the Line Item  
199 XRAGL XRAGL XFELD CHAR 1   0   Indicator: Clearing was Reversed  
200 CESSION_KZ CESSION_KZ CESSION_KZ CHAR 2   0   Accounts Receivable Pledging Indicator *
201 XINVE XINVE XFELD CHAR 1   0   Indicator: Capital Goods Affected?  
202 RFZEI RFZEI_CC NUM03 NUMC 3   0   Payment Card Item  
203 ABSBT ABSBT WERT7 CURR 13   2   Credit Management: Hedged Amount  
204 SEGMENT FB_SEGMENT FB_SEGMENT CHAR 10   0   Segment for Segmental Reporting *
205 PSEGMENT FB_PSEGMENT FB_SEGMENT CHAR 10   0   Partner Segment for Segmental Reporting *
206 BUDGET_PD FM_BUDGET_PERIOD FM_BUDGET_PERIOD CHAR 10   0   FM: Budget Period *
207 .INCLUDE       0   0    
208 PRTFW PRTFW WRTV7 CURR 13   2   Partially Paid Amount in Transaction Currency  
209 PRTHW PRTHW WRTV7 CURR 13   2   Partially Paid Amount in Local Currency  
210 PPIDX PPIDX PACK3 DEC 5   0   Index Number for Summarization of Items by Invoice Reference  
211 STATE STATE_OPS CHAR1 CHAR 1   0   Display Status for Summarization of Items by Invoice Ref.  
212 .INCLU--AP       0   0   FSCM DM:  
213 .INCLUDE       0   0   FSCM: DM  
214 EXT_KEY FDM_EXT_KEY FDM_EXT_KEY CHAR 12   0   Case ID  
215 PROCESSOR FDM_PROCESSOR XUBNAME CHAR 12   0   Processor *
216 PRIORITY_TEXT FDM_PRIORITY_TEXT TEXT40 CHAR 40   0   Priority of Dispute Case  
217 STAT_ORDERNO_TEXT FDM_STAT_ORDERNO_TEXT TEXT40 CHAR 40   0   Status of Dispute Case  
218 .INCLU--AP       0   0   FMFG Additional fields for RFOPS  
219 FMFGUS_KEY FMFG_US_KEY SYSUUID_22 CHAR 22   0   United States Federal Government Fields  
220 .INCLU--AP       0   0   Fields for Prompt Payment Act (PPA)  
221 PENLC1 PENALTY1 WERT13 CURR 13   2   Penalty Charge Amount in First Local Currency  
222 PENLC2 PENALTY2 WERT13 CURR 13   2   Penalty Charge Amount in Second Local Currency  
223 PENLC3 PENALTY3 WERT13 CURR 13   2   Penalty Charge Amount in Third Local Currency  
224 PENFC PENALTY WERT13 CURR 13   2   Penalty Charge Amount in Document Currency  
225 PENDAYS PDAYS INT4 INT4 10   0   Number of Days for Penalty Charge Calculation  
226 PENRC PENRC CHAR2 CHAR 2   0   Reason for Late Payment  
227 XPENA XPENA XFELD CHAR 1   0   Penalty Charge Activated (Indicator)  
228 .INCLU--AP       0   0   Append for Invoice Summary  
229 MINR ISJPMINR ISJPMINR CHAR 10   0   Monthly Invoice Number  
230 PINR ISJPPINR ISJPPINR CHAR 10   0   Payer Invoice Number  
231 .INCLU--AP       0   0   Joint Venture Fields  
232 VNAME JV_NAME JV_NAME CHAR 6   0   Joint venture T8JV
233 EGRUP JV_EGROUP JV_EGROUP CHAR 3   0   Equity group T8JF
234 BTYPE JV_BILIND JV_BILIND CHAR 2   0   Payroll Type T8JA
235 PRODPER JVA_PROD_MONTH BUPER ACCP 6   0   Produktionsmonat  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RFOPS BTYPE T8JA BILIND REF C CN
2 RFOPS EGRUP T8JF EGRUP REF C CN
3 RFOPS KKBER T014 KKBER REF 1 CN
4 RFOPS MANSP T040S MANSP    
5 RFOPS VNAME T8JV VNAME REF C CN
History
Last changed by/on SAP  20140121 
SAP Release Created in