SAP Table RF140

Work Fields for Correspondence (SAPF140*)

RF140 (Work Fields for Correspondence (SAPF140*)) 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 RF140 to other SAP tables.

RF140 table fields

Field Data element Checktable Datatype Length Decimals
ZALBT Payment Amount DZALBT_F15 CURR 15 2
ZANBT Payment Amount Excluding Bank Charges DZANBT_F15 CURR 15 2
AUGBT Clearing Amount AUGBT_F152 CURR 15 2
BRTBT Gross Amount of Payment (Cleared Items and Partial Payment) BRTBT_F152 CURR 13 2
BSPBT Bank Charges BSPBT_F152 CURR 15 2
DFBBT Unauthorized Deduction DFBBT_F152 CURR 13 2
DFGBT Credited Difference DFGBT_F152 CURR 13 2
UMBBT Other Transfer Postings UMBBT_F152 CURR 13 2
DIFBT Difference Amount DIFBT_F152 CURR 15 2
SKTBT Cash Discount Amount SKTBT_F152 CURR 15 2
TLZBT Partial Payment Amount TLZBT_F152 CURR 15 2
WRSHB Foreign Currency Amount with Signs (+/-) WRSHB CURR 13 2
DMSHB Amount in Local Currency with +/- Signs DMSHB CURR 13 2
WSSHB Cash discount amount (+/-) in document currency WSSHB_F152 CURR 13 2
SKSHB Cash Discount Amount (+/-) in Local Currency SKSHB_F152 CURR 13 2
WSSHV Cash discount amnt in doc.currency with opposite (+/-) sign WSSHB_F140 CURR 13 2
SKSHV Cash Discount Amount in Local Curr.with Opposite (+/-) Sign SKSHB_F140 CURR 13 2
ZLSHB Payment Amount (+/-) DZLSHB_F15 CURR 13 2
RFSHB Signed ( +/- ) Invoice Amount in Document Currency RFSHB_F152 CURR 13 2
RHSHB Invoice Amount (+/-) in Local Currency RHSHB_F152 CURR 13 2
WAERS Currency Key WAERS CUKY 5 0
AUSDT Dunning date AUSDT_F150 DATS 8 0
EVENT Event EVENT_001E CHAR 5 0
BELEGNUM Ref.document number, if available, otherwise document number F130BELN1 CHAR 16 0
OPBETRAG Open Item Amount in Document Currency F130OPBT CURR 15 2
GSALDD Total Balance in Local Currency GSALD CURR 15 2
GSALDB Total Balance in Local Currency GSALD CURR 15 2
SALDO Balance in document currency SALDO CURR 15 2
SALDOHW Balance in Local Currency HWSALDO CURR 15 2
HWAER Currency Key WAERS CUKY 5 0
EMPFG Payee code EMPFG CHAR 16 0
BLDAT Document Date in Document BLDAT DATS 8 0
BUDAT Posting Date in the Document BUDAT DATS 8 0
KONTO Customer or Vendor Account Number F130KONT CHAR 10 0
REPID ABAP Program: Current Main Program SYREPID CHAR 40 0
GSALDO Total Balance in Local Currency without Decimal Places GSALDO DEC 15 0
FORNR Form FORNR_001F CHAR 16 0
ELEMENT Text Element in a SAPscript Form F130ELEM CHAR 4 0
ELEMEN2 Text Element in a SAPscript Form F130ELEM CHAR 4 0
WINDOW SAPscript Form Window F130WIND CHAR 8 0
BUSAB Accounting clerk BUSAB CHAR 2 0
SPRAS Language Key SPRAS T002 LANG 1 0
SPRAS2 Language Key SPRAS T002 LANG 1 0
SPRAS3 Language Key SPRAS T002 LANG 1 0
RPOBT Difference Amount DIFBT_F152 CURR 15 2
ACOBT Difference Amount DIFBT_F152 CURR 15 2
BLART Document Type BLART CHAR 2 0
KOART_F140 Account Type KOART_F130 CHAR 1 0
D Customer
K Vendor
DATU1 Date Specification for Correspondence DATUM_KORR DATS 8 0
DATU2 Date Specification for Correspondence DATUM_KORR DATS 8 0
STIDA Open Items at Key Date ALLGSTID DATS 8 0
PSSHB Foreign Currency Amount with Signs (+/-) WRSHB CURR 13 2
PSWSL Update Currency for General Ledger Transaction Figures PSWSL CUKY 5 0
VZTAS Days in arrears at key date VZTAS DEC 7 0
VSTID Key date for due dates VSTID DATS 8 0
NETDT Due Date for Net Payment NETDT DATS 8 0
DATUM Date Specification for Correspondence DATUM_KORR DATS 8 0
DISKT Discount Days DISKT DEC 3 0
DISKP Percentage Rate for Bill of Exch. Disc. with Passed-On Chrgs DISKP DEC 7 5
WSSHD Bill of exchange tax in local currency WSTHW_F140 CURR 13 2
WSSHW Bill of exchange tax in foreign currency WSTFW_F140 CURR 13 2
WISHD Charge for collection of bills of exchange (in local curr.) WINHW_F140 CURR 13 2
WISHW Charge for collection of bill of exchange in document curr. WINFW_F140 CURR 13 2
GSALDF Total Balance in Document Currency GSALDF CURR 15 2
WDSHD Bill of exchange discount (in local currency) WDIHW_F140 CURR 13 2
WDSHW Bill of exchange discount (in document currency) WDIFW_F140 CURR 13 2
MDSHB Tax on Sales/Purchases amount in Local Curr. with +/- Sign MDSHB CURR 13 2
MWSHB Tax on Sales/Purchases Amount in Foreign Curr. with +/- Sign MWSHB CURR 13 2
MSATZ Tax rate MSATZ_F05L DEC 7 3
VTEXT Name VTXTK CHAR 20 0
XPROL Display bill of exchange renewal XPROL CHAR 1 0
X Yes
NULL No
ZFBDT Baseline Date for Due Date Calculation DZFBDT DATS 8 0
ZBDTA Period for Terms of Payment DZBDTA_F14 DEC 3 0
ZBDPR Cash Discount Percent DZBDPR_F14 DEC 5 3
USNAM User name USNAM CHAR 12 0
TITLE Additional Heading ALLGLIN1 CHAR 40 0
ADATE Date DATUM DATS 8 0
AZEIT Time UZEIT TIMS 6 0
BEZBLPOS Long Text for Text Number LTEXT_050T CHAR 70 0
BEZKOART Long Text for Text Number LTEXT_050T CHAR 70 0
BEZSHKZG Long Text for Text Number LTEXT_050T CHAR 70 0
BEZXAUTO Long Text for Text Number LTEXT_050T CHAR 70 0
BEZXCPDD Long Text for Text Number LTEXT_050T CHAR 70 0
BEZBSTAT Long Text for Text Number LTEXT_050T CHAR 70 0
BEZMWSKZ Name for value-added tax TEXT1_007S CHAR 50 0
BEZMWSK1 Name for value-added tax TEXT1_007S CHAR 50 0
BEZMWSK2 Name for value-added tax TEXT1_007S CHAR 50 0
BEZMWSK3 Name for value-added tax TEXT1_007S CHAR 50 0
BEZWMWKZ Name for value-added tax TEXT1_007S CHAR 50 0
WAERS2 Currency Key WAERS CUKY 5 0
WAERS3 Currency Key WAERS CUKY 5 0
WAERS4 Currency Key WAERS CUKY 5 0
WAERS5 Currency Key WAERS CUKY 5 0
WAERS6 Currency Key WAERS CUKY 5 0
WAERS7 Currency Key WAERS CUKY 5 0
WAERS8 Currency Key WAERS CUKY 5 0
HWAER2 Currency Key WAERS CUKY 5 0
HWAER3 Currency Key WAERS CUKY 5 0
HWAER4 Currency Key WAERS CUKY 5 0
HWAER5 Currency Key WAERS CUKY 5 0
HWAER6 Currency Key WAERS CUKY 5 0
HWAER7 Currency Key WAERS CUKY 5 0
HWAER8 Currency Key WAERS CUKY 5 0
HWAER9 Currency Key WAERS CUKY 5 0
HWAER10 Currency Key WAERS CUKY 5 0
HWAER11 Currency Key WAERS CUKY 5 0
HWAER12 Currency Key WAERS CUKY 5 0
HWAER13 Currency Key WAERS CUKY 5 0
HWAER14 Currency Key WAERS CUKY 5 0
HWAER15 Currency Key WAERS CUKY 5 0
HWAER16 Currency Key WAERS CUKY 5 0
HWAER17 Currency Key WAERS CUKY 5 0
HWAER18 Currency Key WAERS CUKY 5 0
REGUL Indicator: Individual Payee in Document REGUL CHAR 1 0
X Yes
NULL No
BANKS Bank country key BANKS T005 CHAR 3 0
BANKL Bank Keys BANKK CHAR 15 0
ERDAT Date on which the Record Was Created ERDAT_RF DATS 8 0
ERNAM Name of Person who Created the Object ERNAM_RF CHAR 12 0
BANKA Name of bank BANKA CHAR 60 0
PROVZ Region PROVZ CHAR 2 0
STRAS House number and street STRAS_GP CHAR 35 0
ORT01 City ORT01_GP CHAR 35 0
SWIFT SWIFT/BIC for International Payments SWIFT CHAR 11 0
IBAN IBAN (International Bank Account Number) IBAN CHAR 34 0
CPDIBAN IBAN (International Bank Account Number) IBAN CHAR 34 0
BGRUP Bank group (bank network) BGRUP CHAR 2 0
XPGRO Post Office Bank Current Account XPGRO CHAR 1 0
X Yes
NULL No
LOEVM Deletion Indicator LOEVM CHAR 1 0
X Yes
NULL No
BNKLZ Bank number BANKL CHAR 15 0
TDNAME Name TDOBNAME CHAR 70 0
TDID Text ID TDID CHAR 4 0
TDSPRAS Language Key SPRAS LANG 1 0
TDOBJECT Texts: Application Object TDOBJECT CHAR 10 0
BANKS2 Bank country key BANKS T005 CHAR 3 0
BANKL2 Bank Keys BANKK CHAR 15 0
BANKN2 Bank account number BANKN CHAR 18 0
BKONT2 Bank Control Key BKONT CHAR 2 0
ERDAT2 Date on which the Record Was Created ERDAT_RF DATS 8 0
ERNAM2 Name of Person who Created the Object ERNAM_RF CHAR 12 0
BANKA2 Name of bank BANKA CHAR 60 0
PROVZ2 Region PROVZ CHAR 2 0
STRAS2 House number and street STRAS_GP CHAR 35 0
ORT012 City ORT01_GP CHAR 35 0
SWIFT2 SWIFT/BIC for International Payments SWIFT CHAR 11 0
BGRUP2 Bank group (bank network) BGRUP CHAR 2 0
XPGRO2 Post Office Bank Current Account XPGRO CHAR 1 0
X Yes
NULL No
LOEVM2 Deletion Indicator LOEVM CHAR 1 0
X Yes
NULL No
BNKLZ2 Bank number BANKL CHAR 15 0
SRTF1 Sort Sequence SRTFO_F140 NUMC 1 0
1
SRTF2 Sort Sequence SRTFO_F140 NUMC 1 0
1
SRTF3 Sort Sequence SRTFO_F140 NUMC 1 0
1
SRTF4 Sort Sequence SRTFO_F140 NUMC 1 0
1
SRTF5 Sort Sequence SRTFO_F140 NUMC 1 0
1
SRTF6 Sort Sequence SRTFO_F140 NUMC 1 0
1
SRTF7 Sort Sequence SRTFO_F140 NUMC 1 0
1
SRTF8 Sort Sequence SRTFO_F140 NUMC 1 0
1
SRTF9 Sort Sequence SRTFO_F140 NUMC 1 0
1
XDESC Indicator: Sort in descending order XDESC_XPO CHAR 1 0
X Yes
NULL No
ZFBDW Baseline Date for Due Date Calculation DZFBDT DATS 8 0
ZFBDA Baseline Date for Due Date Calculation DZFBDT DATS 8 0
BUKRS Company Code BUKRS CHAR 4 0
BELNR Accounting Document Number BELNR_D CHAR 10 0
GJAHR Fiscal Year GJAHR NUMC 4 0
TDNAM Text Name TDNAM_F140 CHAR 70 0
RPT01 Sorted List Upper Limit in Days RPKTO CHAR 3 0
RPT02 Sorted List Upper Limit in Days RPKTO CHAR 3 0
RPT03 Sorted List Upper Limit in Days RPKTO CHAR 3 0
RPT04 Sorted List Upper Limit in Days RPKTO CHAR 3 0
RPT05 Sorted List Upper Limit in Days RPKTO CHAR 3 0
RPT06 Sorted List Lower Limit in Days RPKTU CHAR 3 0
RPT07 Sorted List Lower Limit in Days RPKTU CHAR 3 0
RPT08 Sorted List Lower Limit in Days RPKTU CHAR 3 0
RPT09 Sorted List Lower Limit in Days RPKTU CHAR 3 0
RPT10 Sorted List Lower Limit in Days RPKTU CHAR 3 0
RAST1 Amount Assigned to a Sorted List Interval RASTB CURR 15 2
RAST2 Amount Assigned to a Sorted List Interval RASTB CURR 15 2
RAST3 Amount Assigned to a Sorted List Interval RASTB CURR 15 2
RAST4 Amount Assigned to a Sorted List Interval RASTB CURR 15 2
RAST5 Amount Assigned to a Sorted List Interval RASTB CURR 15 2
RAST6 Amount Assigned to a Sorted List Interval RASTB CURR 15 2
MEMID Memory ID for EXPORT/IMPORT MEMID CHAR 32 0
XPRIN Indicator: Printout required XPRIN CHAR 1 0
X Yes
NULL No
XNLID Indicator: New spool request required XNLID CHAR 1 0
X Yes
NULL No
XDIAL Indicator: Online required XDIAL_KORR CHAR 1 0
X Yes
NULL No
BEZCURT1 Exchange Rate Type 1. Local Currency Name BEZCURT1 CHAR 60 0
BEZCURT2 Exchange Rate Type 2. Local Currency Name BEZCURT2 CHAR 60 0
BEZCURT3 Exchange Rate Type 3. Local Currency Name BEZCURT3 CHAR 60 0
TXTCURT2 Amount Text for 2nd Local Currency TXTCURT2 CHAR 12 0
TXTCURT3 Amount Text for 3rd Local Currency TXTCURT3 CHAR 12 0
BEZBASW2 Short Description of Repository Objects AS4TEXT CHAR 60 0
BEZBASW3 Short Description of Repository Objects AS4TEXT CHAR 60 0
BEZUMRD2 Short Description of Repository Objects AS4TEXT CHAR 60 0
BEZUMRD3 Short Description of Repository Objects AS4TEXT CHAR 60 0
BEZWGBKZ Short Description of Repository Objects AS4TEXT CHAR 60 0
OPEN Indicator for Opening the Form Output F140OPEN CHAR 1 0
START Indicator for Starting the Form Output F140STAR CHAR 1 0
PARVW Partner Function PARVW CHAR 2 0
SALDS Balance in document currency SALDO CURR 15 2
SALDH Balance in document currency SALDO CURR 15 2
WSKTA Current Cash Discount in Document Currency SKTAK CURR 13 2
WRSHN Amount in document currency minus current cash discount WRSHN CURR 13 2
SALSK Balance of Current Cash Discount SALSK CURR 15 2
SALDN Balance Minus Current Cash Discount SALDN CURR 15 2
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
AVSID Payment Advice Number AVSID CHAR 16 0
DEDATE Date DATUM DATS 8 0
DECADE Factory calendar: Factory date FACDATE DEC 5 0
DECADE2 Factory calendar: Factory date FACDATE DEC 5 0
GKONT Offsetting Account Number GKONT CHAR 10 0
QBUIHB Enter withholding tax amount in document currency manually WT_QBUIHB CURR 15 2
QSSHB Withholding tax base amount in document currency WT_BS1 CURR 15 2
QBSHB Withholding tax amount in document currency WT_WT1 CURR 15 2
RAART Sorted List Type RAART CHAR 1 0
1 Net Due Date
2 Discount1 Due Date
3 Discount2 Due Date
4 Incoming Payments
5 Document Age
6 Arrears
ANZBTHW Down Payment Amount ANZBT CURR 15 2
KUMUMHW Annual Sales KUMUM CURR 15 2
STENR Tax Number at Responsible Tax Authority STENR CHAR 18 0

RF140 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RF140 BANKS SYST MANDT T005 Countries MANDT
RF140 BANKS RF140 BANKS T005 Countries LAND1
RF140 BANKS2 SYST MANDT T005 Countries MANDT
RF140 BANKS2 RF140 BANKS2 T005 Countries LAND1
RF140 SPRAS RF140 SPRAS T002 Language Keys (Component BC-I18) SPRAS
RF140 SPRAS2 RF140 SPRAS2 T002 Language Keys (Component BC-I18) SPRAS
RF140 SPRAS3 RF140 SPRAS3 T002 Language Keys (Component BC-I18) SPRAS