1. Home
  2. Resources
  3. SAP Tables
  4. V_TFK047B - Generated Table for View

SAP Table V_TFK047B

Generated Table for View

V_TFK047B (Generated Table for View) 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 V_TFK047B to other SAP tables.

Source: V_TFK047B (Generated Table for View)

V_TFK047B table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MAHNV Dunning Procedure MAHNV_KK TFK047A CHAR 2 0
MAHNS Dunning Level MAHNS_KK NUMC 2 0
VERTG Number Of Days in Arrears VERTG_KK NUMC 4 0
RHYTH Dunning frequency in days RHYTH_KK NUMC 3 0
FRIST Payment Deadline in Days FRIST_KK NUMC 3 0
XPOST Print All Items XPOST_KK CHAR 1 0
X Yes
NULL No
XAEND Always Dun Dunning Level XAEND_KK CHAR 1 0
X Yes
NULL No
BONIG Creditworthiness number BONIZ_KK NUMC 2 0
XMFAK Dunning Level is Optional XMFAK_KK CHAR 1 0
X Yes
NULL No
XMSUS Entry in Dunning History only Technically Conditional XMSUS_KK CHAR 1 0
X Yes
NULL No
XEXTM Set Dunning Level XEXTM_KK CHAR 1 0
NULL No Restriction
1 Dunning Level Set Only by Dunning Run
2 Dunning Level Set Only by Invoicing
3 Do Not Consider Dunning Level for Broker Dunning Status
IKEY Interest Key IKEY_KK TFK056A CHAR 2 0
ICALC Determine Interest ICALC_KK CHAR 1 0
X Yes
NULL No
IPOST Posting Key for Dunning Interest IPOST_KK CHAR 1 0
NULL Do not update
1 Statistical update
2 Update related to G/L
CHGID Charges Schedule CHGID_KK TFK047E CHAR 2 0
MSTYP Dunning Level Category MSTYP_KK TFK047G CHAR 2 0
CHGT1 Field Not to be Used (Previously Charge Type) UNUSED_CHGTY_KK TFK047H CHAR 2 0
CHGT2 Field Not to be Used (Previously Charge Type) UNUSED_CHGTY_KK TFK047H CHAR 2 0
CHGT3 Field Not to be Used (Previously Charge Type) UNUSED_CHGTY_KK TFK047H CHAR 2 0
AVERT Number of days in arrears for external program AVERT_KK NUMC 4 0
ARHYT Dunning frequency in days for external program ARHYT_KK NUMC 3 0
XNBGM Only Items from Previous Dunning Level XNBGM_KK CHAR 1 0
X Yes
NULL No
MTEXT Name of Dunning Level TX010_KK CHAR 50 0
MVTXT Dunning procedure text TX007_KK CHAR 50 0
MSTXT Text for Dunning Level Type MSTXT_KK CHAR 50 0
MEMPF Control for Dunning Recipient MEMPF_KK CHAR 1 0
NULL Control from contract account
1 Dunning recipient gets dunning notice
2 Business partner gets dunning notice
3 Business partner and dunning recipient get dunning notice
INTFIRST Calculation of Interest before Charges in Dunning Program INTFIRST_KK CHAR 1 0
X Yes
NULL No
MINPZ Dunning Proposal: Limit Percentage Rate MINPZ_KK DEC 3 1
NEWDC Dun New Documents Immediately NEWDC_KK CHAR 1 0
X Yes
NULL No
XDSUC Subsequent Success Valuation of Dunning XDSUC_KK CHAR 1 0
X Yes
NULL No

V_TFK047B foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
V_TFK047B CHGID V_TFK047B MANDT TFK047E Charges Schedule MANDT
V_TFK047B CHGID V_TFK047B CHGID TFK047E Charges Schedule CHGID
V_TFK047B CHGT1 V_TFK047B MANDT TFK047H Charges Categories MANDT
V_TFK047B CHGT1 V_TFK047B CHGT1 TFK047H Charges Categories CHGTY
V_TFK047B CHGT2 V_TFK047B MANDT TFK047H Charges Categories MANDT
V_TFK047B CHGT2 V_TFK047B CHGT2 TFK047H Charges Categories CHGTY
V_TFK047B CHGT3 V_TFK047B MANDT TFK047H Charges Categories MANDT
V_TFK047B CHGT3 V_TFK047B CHGT3 TFK047H Charges Categories CHGTY
V_TFK047B IKEY V_TFK047B MANDT TFK056A Interest Key Table for FI-CA MANDT
V_TFK047B IKEY V_TFK047B IKEY TFK056A Interest Key Table for FI-CA IKEY
V_TFK047B MAHNV V_TFK047B MANDT TFK047A Dunning procedure MANDT
V_TFK047B MAHNV V_TFK047B MAHNV TFK047A Dunning procedure MAHNV
V_TFK047B MANDT V_TFK047B MANDT T000 Clients MANDT
V_TFK047B MSTYP V_TFK047B MANDT TFK047G Dunning Level Categories MANDT
V_TFK047B MSTYP V_TFK047B MSTYP TFK047G Dunning Level Categories MSTYP