SAP Tabel RFOPS (Open Item Data for Clearing Transactions)

Field Description Data Type Length Decimals Checktable Data Element
BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
BUKRS Company Code CHAR 4 0 BUKRS
GJAHR Fiscal Year NUMC 4 0 GJAHR
BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
WAERS Currency Key CUKY 5 0 WAERS
XBLNR Reference Document Number CHAR 16 0 XBLNR1
BLART Document Type CHAR 2 0 BLART
BUDAT Posting Date in the Document DATS 8 0 BUDAT
BLDAT Document Date in Document DATS 8 0 BLDAT
XNETB Indicator: Document posted net ? CHAR 1 0 XNETB
BSTAT Document Status CHAR 1 0 BSTAT_D
BSCHL Posting Key CHAR 2 0 BSCHL
UMSKZ Special G/L Indicator CHAR 1 0 UMSKZ
UMSKS Special G/L Transaction Type CHAR 1 0 UMSKS
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
HKONT General Ledger Account CHAR 10 0 HKONT
SAKNR G/L Account Number CHAR 10 0 SAKNR
FILKD Account Number of the Branch CHAR 10 0 FILKD
PARGB Trading partner's business area CHAR 4 0 PARGB
GSBER Business Area CHAR 4 0 GSBER
MABER Dunning Area CHAR 2 0 MABER
SHKZG Debit/Credit Indicator CHAR 1 0 SHKZG
H Credit
S Debit
XANET Indicator: Down Payment in Net Procedure? CHAR 1 0 XANET
TAX_COUNTRY Tax Reporting Country/Region CHAR 3 0 FOT_TAX_COUNTRY
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
TXDAT Date for Determining Tax Rates DATS 8 0 TXDAT
TXDAT_FROM Valid-From Date of the Tax Rate DATS 8 0 FOT_TXDAT_FROM
TXDAT_FROM1 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack) DATS 8 0 FOT_TXDAT_FROMX
TXDAT_FROM2 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack) DATS 8 0 FOT_TXDAT_FROMX
TXDAT_FROM3 Valid-From Date of Tax Rate for Tax Breakdown(Tax Backpack) DATS 8 0 FOT_TXDAT_FROMX
MWSTS Tax Amount in Local Currency CURR 23 2 MWSTS
WMWST Tax Amount in Document Currency CURR 23 2 WMWST
QSSKZ Withholding Tax Code CHAR 2 0 QSSKZ
QSSHB Withholding Tax Base Amount CURR 23 2 QSSHB
QSSHH Withholding Tax Base Amount (Local Currency) CURR 23 2 QSSHH
QBSHB Withholding Tax Amount (in Document Currency) CURR 23 2 QBSHB
QBSHH Withholding Tax Amount (in Local Currency) CURR 23 2 QBSHH
QSZNR Certificate Number of the Withholding Tax Exemption CHAR 10 0 QSZNR
BDIFF Valuation Difference CURR 23 2 BDIFF
PPDIFF Realized Exchange Rate Gain/Loss 1.Loc.Curr.(Part Payments) CURR 23 2 PPDIFF
PPDIF2 Realized Exch. Rate Gain/Loss Second Local Crcy (Part.Pymts) CURR 23 2 PPDIF2
PPDIF3 Realized Exch. Rate Gain/Loss Third Local Crcy (Part. Pymts) CURR 23 2 PPDIF3
ZUONR Assignment number CHAR 18 0 DZUONR
DMBTR Amount in local currency CURR 23 2 DMBTR
WRBTR Amount in document currency CURR 23 2 WRBTR
SKNTO Cash Discount Amount in Local Currency CURR 23 2 SKNTO
WSKTO Cash Discount Amount in Document Currency CURR 23 2 WSKTO
SKFBT Amount Eligible for Cash Discount in Document Currency CURR 23 2 SKFBT
ZTERM Terms of payment key CHAR 4 0 DZTERM
ZFBDT Baseline Date for Due Date Calculation DATS 8 0 DZFBDT
ZBD1T Cash discount days 1 DEC 3 0 DZBD1T
ZBD2T Cash discount days 2 DEC 3 0 DZBD2T
ZBD3T Net Payment Terms Period DEC 3 0 DZBD3T
ZBD1P Cash discount percentage 1 DEC 5 3 DZBD1P
ZBD2P Cash Discount Percentage 2 DEC 5 3 DZBD2P
REBZG Document No. of the Invoice to Which the Transaction Belongs CHAR 10 0 REBZG
REBZJ Fiscal Year of the Relevant Invoice (for Credit Memo) NUMC 4 0 REBZJ
REBZZ Line Item in the Relevant Invoice NUMC 3 0 REBZZ
ZBFIX Fixed Payment Terms CHAR 1 0 DZBFIX
SAMNR Invoice List Number NUMC 8 0 SAMNR
ANLN1 Main Asset Number CHAR 12 0 ANLN1
ANLN2 New asset subnumber, 4 characters CHAR 4 0 ANLN2_4
AUFNR Order Number CHAR 12 0 AUFNR
VBELN Billing Document CHAR 10 0 VBELN_VF
EBELN Purchasing Document Number CHAR 10 0 EBELN
EBELP Item Number of Purchasing Document NUMC 5 0 EBELP
ZEKKN Sequential Number of Account Assignment NUMC 2 0 DZEKKN
KOSTL Cost Center CHAR 10 0 KOSTL
WERKS Plant CHAR 4 0 WERKS_D
PROJK Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
NPLNR Network Number for Account Assignment CHAR 12 0 NPLNR
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL Internal counter NUMC 8 0 CIM_COUNT
ANFBN Document Number of the Bill of Exchange Payment Request CHAR 10 0 ANFBN
ANFBJ Fiscal Year of the Bill of Exchange Payment Request Document NUMC 4 0 ANFBJ
ANFBU Company Code in Which Bill of Exch.Payment Request Is Posted CHAR 4 0 ANFBU
KONKO Open Item Account Number CHAR 10 0 KONKO
ZBDXT Selected cash discount days DEC 3 0 DZBDXT
ZBDXP Selected Cash Discount Percentage Rate DEC 5 3 DZBDXP
VERZG Calculated Days in Arrears DEC 5 0 VERZG
TOLER Grace Days NUMC 2 0 TOLER_043G
TAX_COUNTRY1 Tax Country or Region for Tax Breakdown CHAR 3 0 FOT_TAX_COUNTRYX
MWSK1 Tax Code for Distribution CHAR 2 0 MWSKX
HIST_TAX_FACTOR1 Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
TAX_COUNTRY2 Tax Country or Region for Tax Breakdown CHAR 3 0 FOT_TAX_COUNTRYX
MWSK2 Tax Code for Distribution CHAR 2 0 MWSKX
HIST_TAX_FACTOR2 Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
TAX_COUNTRY3 Tax Country or Region for Tax Breakdown CHAR 3 0 FOT_TAX_COUNTRYX
MWSK3 Tax Code for Distribution CHAR 2 0 MWSKX
HIST_TAX_FACTOR3 Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
HIST_TAX_FACTOR Historical Factor for calculating Tax Amount D34R 34 0 FOT_HIST_FACTOR_FOR_TAX_AMOUNT
DMBT1 Amount in Local Currency for Tax Distribution CURR 23 2 DMBTX
DMBT2 Amount in Local Currency for Tax Distribution CURR 23 2 DMBTX
DMBT3 Amount in Local Currency for Tax Distribution CURR 23 2 DMBTX
WRBT1 Amount in Foreign Currency for Tax Breakdown CURR 23 2 WRBTX
WRBT2 Amount in Foreign Currency for Tax Breakdown CURR 23 2 WRBTX
WRBT3 Amount in Foreign Currency for Tax Breakdown CURR 23 2 WRBTX
NETHW Net Amount in Local Currency CURR 23 2 NETHW
NETFW Net Amount in Foreign Currency CURR 23 2 NETFW
DIFHW Amount Difference in Local Currency CURR 23 2 DIFHW
DIFFW Amount Difference in Foreign Currency CURR 23 2 DIFFW
SKTFW Cash Discount Amount in Document Currency CURR 23 2 WSKTO
XAKTP Indicator: Items Activated? CHAR 1 0 XAKTP
XAKTS Indicator: Cash Discount Activated? CHAR 1 0 XAKTS
XVORT Indicator: Carryforward Residual Bal. for Payt Difference? CHAR 1 0 XVORT
INSEL Indicator: Item in Partial Selection NUMC 1 0 INSEL
ORISO Index Number for Original Sorting DEC 7 0 ORISO
XKOMB Indicator: Combined Items? CHAR 1 0 XKOMB
STATU Exception Status for the Open Item CHAR 1 0 STATU_OPS
PSWSL Update Currency for General Ledger Transaction Figures CUKY 5 0 PSWSL
PSWBT Amount for Updating in General Ledger CURR 23 2 PSWBT
XCPDD Indicator: Address and Bank Data Set Individually CHAR 1 0 XCPDD
VBUND Company ID of Trading Partner CHAR 6 0 RASSC
ZLSPR Payment Block Key CHAR 1 0 DZLSPR
MANSP Dunning Block CHAR 1 0 T040S MANSP
STCEG VAT Registration Number CHAR 20 0 STCEG
EGBLD Country/Region of Destination for Delivery of Goods CHAR 3 0 EGBLD
EGLLD Supplying Country/Region for Delivery of Goods CHAR 3 0 EGLLD
MANST Dunning Level NUMC 1 0 MAHNS_D
VERTT Contract Type CHAR 1 0 RANTYP
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
B Bank Accounts
E Exposures
T Trade Finance
V Contract Management - Consumer Products
X External Accounts
Y Reserved for Customer Enhancements
Z Reserved for Customer Enhancements
VERTN Contract Number CHAR 13 0 RANL
VBEWA Flow Type CHAR 4 0 SBEWART
FIPOS Commitment Item CHAR 14 0 FIPOS
RSTGR Reason Code for Payments CHAR 3 0 RSTGR
XEGDR Indicator: Triangular Deal Within the EU CHAR 1 0 XEGDR
DMBE2 Amount in Second Local Currency or Global Currency CURR 23 2 DMBE2
DMBE3 Amount in Third Local Currency or First Freely-Def. Currency CURR 23 2 DMBE3
DMB21 Amount in Second Local Currency for Tax Breakdown CURR 23 2 DMB2X
DMB22 Amount in Second Local Currency for Tax Breakdown CURR 23 2 DMB2X
DMB23 Amount in Second Local Currency for Tax Breakdown CURR 23 2 DMB2X
DMB31 Amount in Third Local Currency for Tax Breakdown CURR 23 2 DMB3X
DMB32 Amount in Third Local Currency for Tax Breakdown CURR 23 2 DMB3X
DMB33 Amount in Third Local Currency for Tax Breakdown CURR 23 2 DMB3X
MWST2 Tax Amount in Second Local Currency CURR 23 2 MWST2
MWST3 Tax Amount in Third Local Currency CURR 23 2 MWST3
SKNT2 Cash Discount Amount in Second Local Currency CURR 23 2 SKNT2
SKNT3 Cash Discount Amount in Third Local Currency CURR 23 2 SKNT3
DIFH2 Amount Difference in Second Local Currency CURR 23 2 DIFH2
DIFH3 Amount Difference in Third Local Currency CURR 23 2 DIFH3
NETH2 Net Amount in Second Local Currency CURR 23 2 NETH2
NETH3 Net Amount in Third Local Currency CURR 23 2 NETH3
QBSH2 Withholding Tax Amount in Second Local Currency CURR 23 2 QBSH2
QBSH3 Withholding Tax Amount in Third Local Currency CURR 23 2 QBSH3
QSSH2 Withholding Tax Base Amount in Second Local Currency CURR 23 2 QSSH2
QSSH3 Withholding Tax Base Amount in Third Local Currency CURR 23 2 QSSH3
BDIF2 Valuation Difference for the Second Local Currency CURR 23 2 BDIF2
RDIF2 Exchange Rate Difference Realized for Second Local Currency CURR 23 2 RDIF2
BDIF3 Valuation Difference for the Third Local Currency CURR 23 2 BDIF3
RDIF3 Exchange Rate Difference Realized for Third Local Currency CURR 23 2 RDIF3
HBKID Short Key for a House Bank CHAR 5 0 HBKID
HKTID ID for Account Details CHAR 5 0 HKTID
BVTYP Partner bank type CHAR 4 0 BVTYP
OSKTO Cash Discount Amount in Local Currency CURR 23 2 SKNTO
XREF1 Business Partner Reference Key CHAR 12 0 XREF1
XREF2 Business Partner Reference Key CHAR 12 0 XREF2
XSKAN Indicator: Only Grant Partial Cash Discount? CHAR 1 0 XSKAN_043G
RSTGN Reason Code for Payments CHAR 3 0 RSTGR
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
AVSID Payment Advice Number CHAR 16 0 AVSID
AVSPO Payment Advice Item NUMC 5 0 AVSPO
TOGRU Tolerance Group for Business Partner/G/L Account CHAR 4 0 TOGRU
VBEL2 Sales Document CHAR 10 0 VBELN_VA
POSN2 Sales Document Item NUMC 6 0 POSNR_VA
ETEN2 Schedule Line Number NUMC 4 0 ETENR
SGTXT Item Text CHAR 50 0 SGTXT
FISTL Funds Center CHAR 16 0 FISTL
GEBER Fund CHAR 10 0 BP_GEBER
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
GMVKZ Item is in Execution CHAR 1 0 FM_GMVKZ
Item not transferred to execution
I Item for information transferred to execution
X Item must be executed
SRTYPE Type of Additional Receivable CHAR 2 0 FM_SRTYPE
1 Dunning Charge
2 Dunning Interest
3 Deferral Interest
4 General Execution Costs
FKBER Functional Area CHAR 16 0 FKBER
KBLNR Document Number for Earmarked Funds CHAR 10 0 KBLNR_FI
KBLPOS Earmarked Funds: Document Item NUMC 3 0 KBLPOS
NETDT Net Due Date DATS 8 0 NETDT
VALUT Value date DATS 8 0 VALUT
DABRZ Reference date for settlement DATS 8 0 DABRBEZ
LANDL Supplying Country/Region CHAR 3 0 LANDL
LZBKZ State Central Bank Indicator CHAR 3 0 LZBKZ
CCBTC Payment cards: Settlement run CHAR 10 0 CCBTC
XNEGP Indicator: Negative Posting CHAR 1 0 XNEGP
KKBER Credit control area CHAR 4 0 T014 KKBER
EMPFB Payee/Payer CHAR 10 0 EMPFB
PRCTR Profit Center CHAR 10 0 PRCTR
PPRCT Partner Profit Center CHAR 10 0 PPRCTR
REBZT Follow-On Document Type CHAR 1 0 REBZT
XREF3 Reference key for line item CHAR 20 0 XREF3
ZUMSK Target Special G/L Indicator CHAR 1 0 DZUMSK
DTWS1 Instruction Key 1 NUMC 2 0 DTAT16
DTWS2 Instruction Key 2 NUMC 2 0 DTAT17
DTWS3 Instruction key 3 NUMC 2 0 DTAT18
DTWS4 Instruction key 4 NUMC 2 0 DTAT19
XPYPR Indicator: Items from Payment Program Blocked CHAR 1 0 XPYPR
KIDNO Payment Reference CHAR 30 0 KIDNO
PYORD Payment Order CHAR 10 0 PYORD
ZINKZ Exempted from Interest Calculation CHAR 2 0 DZINKZ
INTRS Expected Incoming Interest Payment in Local Currency CURR 23 2 INTRS
INPGR Expected Payment: Amount + Interest on Arrears in Loc.Curr. CURR 23 2 INPGR
DIEKZ Service Indicator (Foreign Payment) CHAR 1 0 DIEKZ
ZLSCH Payment Method CHAR 1 0 DZLSCH
UZAWE Payment method supplement CHAR 2 0 UZAWE
KDWBT Difference Amount Due to Payment in Alternative Currency CURR 23 2 KDWBT
BUPLA Business Place CHAR 4 0 BUPLA
SECCO Section Code CHAR 4 0 SECCO
PYCUR Currency for Automatic Payment CUKY 5 0 PYCUR
PYAMT Amount in Payment Currency CURR 23 2 PYAMT
BEWAR Transaction type CHAR 3 0 RMVCT
LOTKZ Lot Number for Requests CHAR 10 0 PSO_LOTKZ
ZBDXP_D Internal: Selected Cash Discount Percentage Rate DEC 5 3 DZBDXP_INT
XAKTS_D Internal Indicator: Cash Discount Active? CHAR 1 0 XAKTS_INT
VERZG_D Internal: Calculated Days in Arrears DEC 5 0 VERZG_INT
BUZID Identification of the Line Item CHAR 1 0 BUZID
XRAGL Indicator: Clearing Was Reversed CHAR 1 0 XRAGL
CESSION_KZ Accounts Receivable Pledging Indicator CHAR 2 0 CESSION_KZ
XINVE Indicator: Capital Goods Affected? CHAR 1 0 XINVE
RFZEI Payment Card Item NUMC 3 0 RFZEI_CC
ABSBT Credit Management: Hedged Amount CURR 23 2 ABSBT
SEGMENT Segment for Segmental Reporting CHAR 10 0 FB_SEGMENT
PSEGMENT Partner Segment for Segmental Reporting CHAR 10 0 FB_PSEGMENT
BUDGET_PD Budget Period CHAR 10 0 FM_BUDGET_PERIOD
BDGT_ACCOUNT Budget Account CHAR 10 0 PSM_BDGT_ACCOUNT
PRTFW Partially Paid Amount in Transaction Currency CURR 23 2 PRTFW
PRTHW Partially Paid Amount in Local Currency CURR 23 2 PRTHW
PPIDX Index Number for Summarization of Items by Invoice Reference DEC 5 0 PPIDX
STATE Display Status for Summarization of Items by Invoice Ref. CHAR 1 0 STATE_OPS
XPPIV Invoice Reference: Partial Payment in Invoice Amount CHAR 1 0 XPPIV
EXT_KEY Case ID CHAR 12 0 FDM_EXT_KEY
PROCESSOR Processor CHAR 12 0 FDM_PROCESSOR
PRIORITY_TEXT Priority of Dispute Case CHAR 40 0 FDM_PRIORITY_TEXT
STAT_ORDERNO_TEXT Status of Dispute Case CHAR 40 0 FDM_STAT_ORDERNO_TEXT
FMFGUS_KEY United States Federal Government Fields CHAR 22 0 FMFG_US_KEY
PENLC1 Penalty Charge Amount in First Local Currency CURR 23 2 PENALTY1
PENLC2 Penalty Charge Amount in Second Local Currency CURR 23 2 PENALTY2
PENLC3 Penalty Charge Amount in Third Local Currency CURR 23 2 PENALTY3
PENFC Penalty Charge Amount in Document Currency CURR 23 2 PENALTY
PENDAYS Number of Days for Penalty Charge Calculation INT4 10 0 PDAYS
PENRC Reason for Late Payment CHAR 2 0 PENRC
XPENA Penalty Charge Activated (Indicator) CHAR 1 0 XPENA
MINR Monthly Invoice Number CHAR 10 0 ISJPMINR
PINR Payer Invoice Number CHAR 10 0 ISJPPINR
VIRTACCTNR Virtual Account Number CHAR 10 0 * ISJPVIRTACCTNR
INVSUMPAYER Invoice Summary Payer CHAR 10 0 ISJPINVSUMPAYER
INVSUMRECIP Invoice Summary Recipient CHAR 10 0 ISJPINVSUMRECIP
INVCSMMRYPAYERNAME Invoice Summary Payer Name CHAR 80 0 ISJP_PAYERNAME
INVCSMMRYRECIPIENTNAME Invoice Summary Recipient Name CHAR 80 0 ISJP_RECPTNAME
VNAME Joint venture CHAR 6 0 T8JV JV_NAME
EGRUP Equity group CHAR 3 0 T8JF JV_EGROUP
BTYPE Billing Indicator CHAR 2 0 T8JA JV_BILIND
PRODPER Production Month ACCP 6 0 JVA_PROD_MONTH

RFOPS foreign key relationships

Table Field Check Table Check Field
0 RFOPS BTYPE T8JA Payroll Type MANDT
0 RFOPS BTYPE T8JA Payroll Type BILIND
1 RFOPS EGRUP T8JF Investment Group MANDT
1 RFOPS EGRUP T8JF Investment Group BUKRS
1 RFOPS EGRUP T8JF Investment Group VNAME
1 RFOPS EGRUP T8JF Investment Group EGRUP
0 RFOPS KKBER T014 Credit control areas KKBER
1 RFOPS VNAME T8JV Joint Venture MANDT
1 RFOPS VNAME T8JV Joint Venture BUKRS
1 RFOPS VNAME T8JV Joint Venture VNAME