1. Home
  2. Resources
  3. SAP Tables
  4. RFOPS - Open Item Data for Clearing Transactions

SAP Table RFOPS

Open Item Data for Clearing Transactions

RFOPS (Open Item Data for Clearing Transactions) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RFOPS to other SAP tables.

Source: RFOPS (Open Item Data for Clearing Transactions)

RFOPS table fields

Field Data element Checktable Datatype Length Decimals
BELNR Accounting Document Number BELNR_D CHAR 10 0
BUKRS Company Code BUKRS CHAR 4 0
GJAHR Fiscal Year GJAHR NUMC 4 0
BUZEI Number of Line Item Within Accounting Document BUZEI NUMC 3 0
WAERS Currency Key WAERS CUKY 5 0
XBLNR Reference Document Number XBLNR1 CHAR 16 0
BLART Document Type BLART CHAR 2 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
XNETB Indicator: Document posted net ? XNETB CHAR 1 0
X Yes
NULL No
BSTAT Document Status BSTAT_D CHAR 1 0
NULL Normal document
A Clearing Document
B Reset clearing document
D Recurring entry document
L Posting Not in Leading Ledger
M Sample document
S Noted items
V Parked document
W Parked document with change of document ID
Z Parked document which was deleted
C Balance Carryforward Line Items
BSCHL Posting Key BSCHL CHAR 2 0
UMSKZ Special G/L Indicator UMSKZ CHAR 1 0
UMSKS Special G/L Transaction Type UMSKS CHAR 1 0
KOART Account Type KOART CHAR 1 0
A Assets
D Customers
K Vendors
M Material
S G/L accounts
HKONT General Ledger Account HKONT CHAR 10 0
SAKNR G/L Account Number SAKNR CHAR 10 0
FILKD Account Number of the Branch FILKD CHAR 10 0
PARGB Trading partner's business area PARGB CHAR 4 0
GSBER Business Area GSBER CHAR 4 0
MABER Dunning Area MABER CHAR 2 0
SHKZG Debit/Credit Indicator SHKZG CHAR 1 0
H Credit
S Debit
XANET Indicator: Down payment in net procedure ? XANET CHAR 1 0
X Yes
NULL No
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
MWSTS Tax Amount in Local Currency MWSTS CURR 13 2
WMWST Tax amount in document currency WMWST CURR 13 2
QSSKZ Withholding Tax Code QSSKZ CHAR 2 0
QSSHB Withholding Tax Base Amount QSSHB CURR 13 2
QSSHH Withholding Tax Base Amount (Local Currency) QSSHH CURR 13 2
QBSHB Withholding Tax Amount (in Document Currency) QBSHB CURR 13 2
QBSHH Withholding Tax Amount (in Local Currency) QBSHH CURR 13 2
QSZNR Certificate Number of the Withholding Tax Exemption QSZNR CHAR 10 0
BDIFF Valuation Difference BDIFF CURR 13 2
PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) PPDIFF CURR 13 2
PPDIF2 Realized Exchange Rate Gain/Loss 2.Loc. Curr.(Part Payments) PPDIF2 CURR 13 2
PPDIF3 Realized Exchange Rate Gain/Loss 3.Loc.Curr.(Part Payments) PPDIF3 CURR 13 2
ZUONR Assignment Number DZUONR CHAR 18 0
DMBTR Amount in Local Currency DMBTR CURR 13 2
WRBTR Amount in document currency WRBTR CURR 13 2
SKNTO Cash discount amount in local currency SKNTO CURR 13 2
WSKTO Cash discount amount in document currency WSKTO CURR 13 2
SKFBT Amount Eligible for Cash Discount in Document Currency SKFBT CURR 13 2
ZTERM Terms of Payment Key DZTERM CHAR 4 0
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
ZBD1T Cash discount days 1 DZBD1T DEC 3 0
ZBD2T Cash discount days 2 DZBD2T DEC 3 0
ZBD3T Net Payment Terms Period DZBD3T DEC 3 0
ZBD1P Cash Discount Percentage 1 DZBD1P DEC 5 3
ZBD2P Cash Discount Percentage 2 DZBD2P DEC 5 3
REBZG Number of the Invoice the Transaction Belongs to REBZG CHAR 10 0
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) REBZJ NUMC 4 0
REBZZ Line Item in the Relevant Invoice REBZZ NUMC 3 0
ZBFIX Fixed Payment Terms DZBFIX CHAR 1 0
NULL No fixing
1 1st cash disc.percentage rate or cash disc.amount is fixed
2 2nd cash discount percentage rate is fixed
SAMNR Invoice List Number SAMNR NUMC 8 0
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 New asset subnumber, 4 characters ANLN2_4 CHAR 4 0
AUFNR Order Number AUFNR CHAR 12 0
VBELN Billing Document VBELN_VF CHAR 10 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
KOSTL Cost Center KOSTL CHAR 10 0
WERKS Plant WERKS_D CHAR 4 0
PROJK Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
NPLNR Network Number for Account Assignment NPLNR CHAR 12 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZL Internal counter CIM_COUNT NUMC 8 0
ANFBN Document Number of the Bill of Exchange Payment Request ANFBN CHAR 10 0
ANFBJ Fiscal Year of the Bill of Exchange Payment Request Document ANFBJ NUMC 4 0
ANFBU Company Code in Which Bill of Exch.Payment Request Is Posted ANFBU CHAR 4 0
KONKO Open item account number KONKO CHAR 10 0
ZBDXT Selected cash discount days DZBDXT DEC 3 0
ZBDXP Selected cash discount percentage rate DZBDXP DEC 5 3
VERZG Calculated Days in Arrears VERZG DEC 5 0
TOLER Grace Days TOLER_043G NUMC 2 0
MWSK1 Tax Code for Distribution MWSKX CHAR 2 0
MWSK2 Tax Code for Distribution MWSKX CHAR 2 0
MWSK3 Tax Code for Distribution MWSKX CHAR 2 0
DMBT1 Amount in Local Currency for Tax Distribution DMBTX CURR 13 2
DMBT2 Amount in Local Currency for Tax Distribution DMBTX CURR 13 2
DMBT3 Amount in Local Currency for Tax Distribution DMBTX CURR 13 2
WRBT1 Amount in foreign currency for tax breakdown WRBTX CURR 13 2
WRBT2 Amount in foreign currency for tax breakdown WRBTX CURR 13 2
WRBT3 Amount in foreign currency for tax breakdown WRBTX CURR 13 2
NETHW Net Amount in Local Currency NETHW CURR 13 2
NETFW Net Amount in Foreign Currency NETFW CURR 13 2
DIFHW Amount Difference in Local Currency DIFHW CURR 13 2
DIFFW Amount Difference in Foreign Currency DIFFW CURR 13 2
SKTFW Cash discount amount in document currency WSKTO CURR 13 2
XAKTP Indicator: Items activated ? XAKTP CHAR 1 0
X Yes
NULL No
XAKTS Indicator: Cash discount activated ? XAKTS CHAR 1 0
X Yes
NULL No
XVORT Indicator: Carryforward residual bal. for pmnt difference ? XVORT CHAR 1 0
X Yes
NULL No
INSEL Indicator: Partial Selection of Postings INSEL NUMC 1 0
ORISO Index Number for Original Sorting ORISO DEC 7 0
XKOMB Indicator: Combined items ? XKOMB CHAR 1 0
X Yes
NULL No
STATU Exception Status for the Open Item STATU_OPS CHAR 1 0
PSWSL Update Currency for General Ledger Transaction Figures PSWSL CUKY 5 0
PSWBT Amount for Updating in General Ledger PSWBT CURR 13 2
XCPDD Indicator: Address and bank data set individually XCPDD CHAR 1 0
X Yes
NULL No
VBUND Company ID of trading partner RASSC CHAR 6 0
ZLSPR Payment Block Key DZLSPR CHAR 1 0
MANSP Dunning block MANSP T040S CHAR 1 0
STCEG VAT Registration Number STCEG CHAR 20 0
EGBLD Country of Destination for Delivery of Goods EGBLD CHAR 3 0
EGLLD Supplying Country for Delivery of Goods EGLLD CHAR 3 0
MANST Dunning level MAHNS_D NUMC 1 0
VERTT Contract Type RANTYP CHAR 1 0
1 Loans
2 Securities
3 Lease-Out - Real Estate
4 Foreign Exchange
5 Money Market
6 Derivatives
7 Open Item Transactions
8 Administration Contract - Real Estate
9 General Contract - Real Estate
A Internal use only
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
V Contract Management - Consumer Products
X External Accounts
E Exposure Position
VERTN Contract Number RANL CHAR 13 0
VBEWA Flow Type SBEWART CHAR 4 0
FIPOS Commitment Item FIPOS CHAR 14 0
RSTGR Reason Code for Payments RSTGR CHAR 3 0
XEGDR Indicator: Triangular deal within the EU ? XEGDR CHAR 1 0
X Yes
NULL No
DMBE2 Amount in Second Local Currency DMBE2 CURR 13 2
DMBE3 Amount in Third Local Currency DMBE3 CURR 13 2
DMB21 Amount in Second Local Currency for Tax Breakdown DMB2X CURR 13 2
DMB22 Amount in Second Local Currency for Tax Breakdown DMB2X CURR 13 2
DMB23 Amount in Second Local Currency for Tax Breakdown DMB2X CURR 13 2
DMB31 Amount in Third Local Currency for Tax Breakdown DMB3X CURR 13 2
DMB32 Amount in Third Local Currency for Tax Breakdown DMB3X CURR 13 2
DMB33 Amount in Third Local Currency for Tax Breakdown DMB3X CURR 13 2
MWST2 Tax Amount in Second Local Currency MWST2 CURR 13 2
MWST3 Tax Amount in Third Local Currency MWST3 CURR 13 2
SKNT2 Cash Discount Amount in Second Local Currency SKNT2 CURR 13 2
SKNT3 Cash Discount Amount in Third Local Currency SKNT3 CURR 13 2
DIFH2 Amount Difference in Second Local Currency DIFH2 CURR 13 2
DIFH3 Amount Difference in Third Local Currency DIFH3 CURR 13 2
NETH2 Net Amount in Second Local Currency NETH2 CURR 13 2
NETH3 Net Amount in Third Local Currency NETH3 CURR 13 2
QBSH2 Withholding Tax Amount in Second Local Currency QBSH2 CURR 13 2
QBSH3 Withholding Tax Amount in Third Local Currency QBSH3 CURR 13 2
QSSH2 Withholding Tax Base Amount in Second Local Currency QSSH2 CURR 13 2
QSSH3 Withholding Tax Base Amount in Third Local Currency QSSH3 CURR 13 2
BDIF2 Valuation Difference for the Second Local Currency BDIF2 CURR 13 2
RDIF2 Exchange Rate Difference Realized for Second Local Currency RDIF2 CURR 13 2
BDIF3 Valuation Difference for the Third Local Currency BDIF3 CURR 13 2
RDIF3 Exchange Rate Difference Realized for Third Local Currency RDIF3 CURR 13 2
HBKID Short Key for a House Bank HBKID CHAR 5 0
HKTID ID for account details HKTID CHAR 5 0
BVTYP Partner Bank Type BVTYP CHAR 4 0
OSKTO Cash discount amount in local currency SKNTO CURR 13 2
XREF1 Business partner reference key XREF1 CHAR 12 0
XREF2 Business partner reference key XREF2 CHAR 12 0
XSKAN Indicator: Only grant partial cash discount ? XSKAN_043G CHAR 1 0
X Yes
NULL No
RSTGN Reason Code for Payments RSTGR CHAR 3 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
AVSID Payment Advice Number AVSID CHAR 16 0
AVSPO Payment Advice Line Item AVSPO NUMC 5 0
TOGRU Tolerance group for the business partner/G/L account TOGRU CHAR 4 0
VBEL2 Sales Document VBELN_VA CHAR 10 0
POSN2 Sales Document Item POSNR_VA NUMC 6 0
ETEN2 Delivery Schedule Line Number ETENR NUMC 4 0
SGTXT Item Text SGTXT CHAR 50 0
FISTL Funds Center FISTL CHAR 16 0
GEBER Fund BP_GEBER CHAR 10 0
GRANT_NBR Grant GM_GRANT_NBR CHAR 20 0
GMVKZ Item is in Execution FM_GMVKZ CHAR 1 0
NULL Item not transferred to execution
I Item for information transferred to execution
X Item must be executed
SRTYPE Type of Additional Receivable FM_SRTYPE CHAR 2 0
01 Dunning Charge
02 Dunning Interest
03 Deferral Interest
04 General Execution Costs
FKBER Functional Area FKBER CHAR 16 0
KBLNR Document Number for Earmarked Funds KBLNR_FI CHAR 10 0
KBLPOS Earmarked Funds: Document Item KBLPOS NUMC 3 0
NETDT Due Date for Net Payment NETDT DATS 8 0
VALUT Value date VALUT DATS 8 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
LANDL Supplying Country LANDL CHAR 3 0
LZBKZ State Central Bank Indicator LZBKZ CHAR 3 0
CCBTC Payment cards: Settlement run CCBTC CHAR 10 0
XNEGP Indicator: Negative posting XNEGP CHAR 1 0
X Yes
NULL No
KKBER Credit control area KKBER T014 CHAR 4 0
EMPFB Payee/Payer EMPFB CHAR 10 0
PRCTR Profit Center PRCTR CHAR 10 0
PPRCT Partner Profit Center PPRCTR CHAR 10 0
REBZT Follow-On Document Type REBZT CHAR 1 0
XREF3 Reference key for line item XREF3 CHAR 20 0
ZUMSK Target Special G/L Indicator DZUMSK CHAR 1 0
DTWS1 Instruction key 1 DTAT16 NUMC 2 0
DTWS2 Instruction key 2 DTAT17 NUMC 2 0
DTWS3 Instruction key 3 DTAT18 NUMC 2 0
DTWS4 Instruction key 4 DTAT19 NUMC 2 0
XPYPR Indicator: Items from Payment Program Blocked XPYPR CHAR 1 0
X Yes
NULL No
KIDNO Payment Reference KIDNO CHAR 30 0
PYORD Payment Order PYORD CHAR 10 0
ZINKZ Exempted from interest calculation DZINKZ CHAR 2 0
A Reasons for block
INTRS Expected Incoming Interest Payment in Local Currency INTRS CURR 13 2
INPGR Expected Payment: Amount + Interest on Arrears in Loc.Curr. INPGR CURR 13 2
DIEKZ Service Indicator (Foreign Payment) DIEKZ CHAR 1 0
ZLSCH Payment Method DZLSCH CHAR 1 0
UZAWE Payment Method Supplement UZAWE CHAR 2 0
KDWBT Difference Amount Due to Payment in Alternative Currency KDWBT CURR 13 2
BUPLA Business Place BUPLA CHAR 4 0
SECCO Section Code SECCO CHAR 4 0
PYCUR Currency for Automatic Payment PYCUR CUKY 5 0
PYAMT Amount in Payment Currency PYAMT CURR 13 2
BEWAR Transaction Type RMVCT CHAR 3 0
LOTKZ Lot Number for Requests PSO_LOTKZ CHAR 10 0
ZBDXP_D Internal: Selected Cash Discount Percentage Rate DZBDXP_INT DEC 5 3
XAKTS_D Internal Indicator: Cash Discount Active? XAKTS_INT CHAR 1 0
X Yes
NULL No
VERZG_D Internal: Calculated Days in Arrears VERZG_INT DEC 5 0
BUZID Identification of the Line Item BUZID CHAR 1 0
XRAGL Indicator: Clearing was Reversed XRAGL CHAR 1 0
X Yes
NULL No
CESSION_KZ Accounts Receivable Pledging Indicator CESSION_KZ CHAR 2 0
XINVE Indicator: Capital Goods Affected? XINVE CHAR 1 0
X Yes
NULL No
RFZEI Payment Card Item RFZEI_CC NUMC 3 0
ABSBT Credit management: Hedged amount ABSBT CURR 13 2
SEGMENT Segment for Segmental Reporting FB_SEGMENT CHAR 10 0
PSEGMENT Partner Segment for Segmental Reporting FB_PSEGMENT CHAR 10 0
BUDGET_PD FM: Budget Period FM_BUDGET_PERIOD CHAR 10 0
PRTFW Partially Paid Amount in Transaction Currency PRTFW CURR 13 2
PRTHW Partially Paid Amount in Local Currency PRTHW CURR 13 2
PPIDX Index Number for Summarization of Items by Invoice Reference PPIDX DEC 5 0
STATE Display Status for Summarization of Items by Invoice Ref. STATE_OPS CHAR 1 0
EXT_KEY Case ID FDM_EXT_KEY CHAR 12 0
PROCESSOR Processor FDM_PROCESSOR CHAR 12 0
PRIORITY_TEXT Priority of Dispute Case FDM_PRIORITY_TEXT CHAR 40 0
STAT_ORDERNO_TEXT Status of Dispute Case FDM_STAT_ORDERNO_TEXT CHAR 40 0
PENLC1 Penalty charge amount in first local currency PENALTY1 CURR 13 2
PENLC2 Penalty charge amount in second local currency PENALTY2 CURR 13 2
PENLC3 Penalty Charge Amount in Third Local Currency PENALTY3 CURR 13 2
PENFC Penalty charge amount in document currency PENALTY CURR 13 2
PENDAYS Number of days for penalty charge calculation PDAYS INT4 10 0
PENRC Reason for late payment PENRC CHAR 2 0
XPENA Penalty Charge Activated (Indicator) XPENA CHAR 1 0
X Yes
NULL No
MINR Monthly Invoice Number ISJPMINR CHAR 10 0
PINR Payer Invoice Number ISJPPINR CHAR 10 0
VNAME Joint Venture JV_NAME T8JV CHAR 6 0
EGRUP Equity group JV_EGROUP T8JF CHAR 3 0
BTYPE Payroll Type JV_BILIND T8JA CHAR 2 0
PRODPER JVA_PROD_MONTH ACCP 6 0

RFOPS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RFOPS BTYPE * T8JA Payroll Type MANDT
RFOPS BTYPE RFOPS BTYPE T8JA Payroll Type BILIND
RFOPS EGRUP * T8JF Investment Group MANDT
RFOPS EGRUP RFOPS BUKRS T8JF Investment Group BUKRS
RFOPS EGRUP RFOPS VNAME T8JF Investment Group VNAME
RFOPS EGRUP RFOPS EGRUP T8JF Investment Group EGRUP
RFOPS KKBER SYST MANDT T014 Credit control areas MANDT
RFOPS KKBER RFOPS KKBER T014 Credit control areas KKBER
RFOPS MANSP SYST MANDT T040S Blocking reasons for dunning notices MANDT
RFOPS MANSP RFOPS MANSP T040S Blocking reasons for dunning notices MANSP
RFOPS VNAME * T8JV Joint Venture MANDT
RFOPS VNAME RFOPS BUKRS T8JV Joint Venture BUKRS
RFOPS VNAME RFOPS VNAME T8JV Joint Venture VNAME