SAP Table TMZR

Agency Business: Payment Types

TMZR (Agency Business: Payment Types) 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 TMZR to other SAP tables.

TMZR table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
WRART Agency business: Payment type WRART CHAR 4 0
WBTYP Settlement request: Payment type WBTYPE CHAR 1 0
NULL Single Document
A Settlement Request List
B Document Parking
WRTYP Entry category: payment WRTYP CHAR 1 0
A Without logistics data
B With logistics data
C Material-related
KAPPL Application KAPPL T681A CHAR 2 0
LFART Agency business: Billing document type WFART TMFK CHAR 4 0
LFART_RG Agency Business: Billing Doc. Type - Settlement Req. List WFART_RG TMFK CHAR 4 0
LFART_BL Settlement request: Billing doc. category - posting list WFART_BL TMFK CHAR 4 0
LFART_BD Agency Business: Billing Type for Customer Settlement WFART_BD TMFK CHAR 4 0
LFART_VS Agency Business: Billing Doc. Type - Vendor Settlement WFART_VS TMFK CHAR 4 0
IDENT1 Settlement calendar WRKAL TFACD CHAR 2 0
WZKRL Agency Business: Customer Credit Limit Check WZKRL CHAR 1 0
X Yes
NULL No
WZAHL Agency Business: Customer Terms of Payment WZAHL CHAR 1 0
A Copy from vendor side
B Copy from Customer Master (Payer)
C Copy from invoice (data entered)
D Copy condition(s) determined
E No terms of payment
F Copy from Customer Master (Invoice Recipient)
WSTBU Agency Business: Post Tax Amounts WSTBU CHAR 1 0
X Yes
NULL No
WZAHLK Settlement request: vendor payment terms WZAHLK CHAR 1 0
A Copy from vendor master
B Copy from invoice (data entered)
C Copy condition(s) determined
D No terms of payment
WRLPAR Agency Business: Remuneration List Recipient WRLPAR CHAR 1 0
NULL Vendor
A Customer
WKOPAR Agency Business: Condition Determin. Level, Payment Docs WKOPAR CHAR 1 0
NULL Vendor-side
A Customer-side
B Vendor- and customer-side
WDOPZ Check document for duplicate entry (payment processing) WDOPZ CHAR 1 0
X Yes
NULL No
WVOLP Set sales volume values in accounting document WVOLP CHAR 1 0
NULL No Sales Posting
B Gross
P Using Pricing
X Net
WBUVE Agency Business: Basis for Remuneration List Date WBUVE CHAR 1 0
NULL On the basis of cash discount days 1
1 On the basis of cash discount days 2
2 On the basis of the period for net conditions
3 Document Date
4 Posting Date
5 Created On
6 Value Date
9 Do Not Fill
WBART Only include condition data (provisions) WBART CHAR 1 0
X Yes
NULL No
WTAXCAL Payment document: Calculate tax for tax code WSTRE CHAR 1 0
X Yes
NULL No
WUNVO Payment document: Incompleteness permitted WUNVO CHAR 1 0
NULL No check
A Check at document level
B Check at document and accounting level
WTAXD Settlement request: Different tax allowed WTAXD CHAR 1 0
X Yes
NULL No
WPAYD Method for determining term of payment for settlm. req. list WPAYD CHAR 1 0
A Calculation of an average due date
B Interest calculation for early payment
C Copy from payment list
D Average due date (conditions from customer area)
E Interest calc. f. early payment (conds from customer area)
X Customer-specific method
SZBMETH Method of calculating interest for additional cash discount SZBMETHSKT CHAR 1 0
1 360E/360
B 360E/365
F 360/360 (ISDA)
H 360/365 (ISDA)
7 360/360
2 Act/360
E Act/364
3 Act/365
4 Act/366
5 Act/ActP (ICMA)
6 Act/ActY (ISDA)
G Act/ActE (AFB)
A ActW/252
D 365/360
C 365/365
I 360E/ActY
8 *365/360
9 *365.25/360
P 1/1
J m+act/360
K m+30/360
0 Not Specified
WPRAN Agency business: Profit analysis type WPRAN TMPA CHAR 4 0
STGRP Agency business: Status group WSTATG TMPA4 CHAR 4 0
DEFAULTST Agency business: Application status WSTATE TMPA5 CHAR 4 0
WKALS Agency Business: Schema determination vendor/custmr WKALS CHAR 1 0
NULL Without customer schema
A With customer schema
B Separate schema determination
C Separate Schema Determination (with Schema Group EKORG)
D Only Document Schema
E Only Document Schema and Schema Group EKORG
PROFOK Agency business: Application status WSTATE TMPA5 CHAR 4 0
PROFFAIL Agency business: Application status WSTATE TMPA5 CHAR 4 0
SETBRTWR Agency Business: Set Gross Value Automatically SETBRTWR CHAR 1 0
NULL Manual Entry
A Automatically for Single Documents
B Automatically for List Documents
C Automatically for List and Single Documents
SPLITT Split FI Documents from Single Settlement Requests WLF_SPLITT CHAR 1 0
NULL For Deferred Tax Only
1 Always
2 Never
9 Customer-Specific Method (BAdI)
TAX_CODE_DETERM Tax Code Determination WLF_TAX_CODE_DETERMINATION CHAR 1 0
NULL Manual Entry
1 Vendor: Manual Entry; Customer: from Price Determination
2 Customer: Manual Entry; Vendor: from Price Determination
3 From Price Determination
REMU_COND_CHECK Check Remuneration List Conditions for Existence in Document WLF_REMU_COND_CHECK CHAR 1 0
NULL Checked for Existence
1 Not Checked for Existence
CROSS_COMPANY AB: Cross-Company Code Payment Documents WLF_CROSS_COMPANY CHAR 1 0
NULL Inactive
1 Cross-Company-Code Sales
2 Intercompany Billing
SETTL_PARTY AB: Settlement Partner WLF_SETTLEMENT_PARTY CHAR 1 0
NULL Standard
1 Only Vendor Side
2 Only Customer Side
3 none
SETTL_METHOD AB: Settlement Procedure WLF_SETTLEMENT_METHOD CHAR 1 0
NULL Classic Method (Using Posting Status Single Document)
1 Extended Method (Using Settlement Status)
DEF_SBLOCK_V AB: Settlement Block - Vendor WLF_SETTLEMENT_BLOCK_V TMSB CHAR 2 0
DEF_SBLOCK_C AB: Settlement Block - Customer WLF_SETTLEMENT_BLOCK_C TMSB CHAR 2 0
DEF_SBLOCK_I_V AB: Settlement Block - Item - Vendor WLF_SETTLEMENT_BLOCK_ITEM_V TMSB CHAR 2 0
DEF_SBLOCK_I_C AB: Settlement Block - Item - Customer WLF_SETTLEMENT_BLOCK_ITEM_C TMSB CHAR 2 0
SETTL_VIA_SR_V AB: Settlement Vendor Using Settlement Request WLF_SETTLEMENT_VIA_SR_V CHAR 1 0
X Yes
NULL No
SETTL_VIA_SR_C AB: Settlement Customer Using Settlement Request WLF_SETTLEMENT_VIA_SR_C CHAR 1 0
X Yes
NULL No
VS_DOC_CREATION AB: Generation of Vendor Settlement WLF_VENDOR_SETTLEMENT_CREATION CHAR 1 0
NULL On Header Level (Standard)
1 On Item Level
CS_DOC_CREATION AB: Customer-Settlement Generation WLF_CUST_SETTLEMENT_CREATION CHAR 1 0
NULL On Header Level (Standard)
1 On Item Level
SCENARIO_SUBTYP FSL: Scenario Subtype for Contract Determination FSL_SCENARIO_SUBTYP CHAR 3 0
NULL No Leasing
INT Leasing with Internal Contract Determination
XIF Leasing with External Contract Determination
CUS Leasing with Customer-Specific Contract Determination
BIL Leasing Without Contract Determination
XIF_KIDNO_CHECK General Flag FLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
XIF_ACTIVE General Flag FLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
XIF_FN_MAPSEND Function name FUNCNAME TFDIR CHAR 30 0
XIF_FN_MAPSAVE Function name FUNCNAME TFDIR CHAR 30 0
STATUS_OUT Agency business: Application status WSTATE TMPA5 CHAR 4 0
STATUS_IN_ERR Agency business: Application status WSTATE TMPA5 CHAR 4 0
STATUS_IN_REL Agency business: Application status WSTATE TMPA5 CHAR 4 0
KUNRE_DUM Bill-to party KUNRE KNA1 CHAR 10 0
LIFRE_DUM Different Invoicing Party LIFRE LFA1 CHAR 10 0
STATUS_ERR Agency business: Application status WSTATE TMPA5 CHAR 4 0
USE_CRMBILLING General Flag FLAG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
IV_REL Check-Relevant WLF_IV_REL CHAR 1 0
NULL Not Relevant (Standard Setting)
1 Invoice Entry
2 Balance Carryforward
3 Definition According to Customizing (Condition Type Group)
FIELDSTATUSGROUP Field Status Group WLF_FIELDSTATUSGROUP TMFSG CHAR 4 0
COLSORTGROUP Column Sorting Group WLF_COLSORTGROUP TMCSGR CHAR 4 0
CHECK_LFART Check Allowed Combinations Payment Type / Billing Type WLF_CHECK_WRART_LFART CHAR 1 0
X Yes
NULL No
SHOW_ORG_DATA Recording of Organizational Data WLF_SHOW_ORG_DATA_SCREEN CHAR 1 0
NULL Only if Necessary
1 Always
FULL_ORG_DATA Complete Organizational Data - Settlement Partner WLF_FULL_ORG_DATA CHAR 1 0
X Yes
NULL No
CAT_PROF Cost allocation profile WCAT_PROF WCAT_PROFILE CHAR 4 0
CO_DATA_CUST Own CO Account Assingment Field for Customer WLF_CO_DATA_CUSTOMER CHAR 1 0
X Yes
NULL No
TAX_CODE_MISSING AB: Handling of Missing Tax Code WLF_HANDLE_TAX_CODE_MISSING CHAR 1 0
NULL Error Message
1 Pricing Error
2 No Error
PROCESS_TYPE Process Category WLF_PROCESS_TYPE WLF_C_PROCTYPE CHAR 4 0
WRART_COLL AD: Payment Type for Collection of Settlement Requests WLF_WRART_COLLECTION TMZR CHAR 4 0
LFART_COLL AD: Billing Type for Collection of Settlement Requests WLF_LFART_COLLECTION TMFK CHAR 4 0
COLL_TYPE AD: Collection of Settlement Requests WLF_COLLECTION_TYPE CHAR 1 0
NULL Inactive
1 Active at Header Level
2 Active at Item Level
DEF_COLL_BLOCK AB: Block for Collection of Settlement Requests WLF_COLLECTION_BLOCK TMSB CHAR 2 0
DEF_COLL_BLOCK_I AB: Block Item for Collection of Settlement Requests WLF_COLLECTION_BLOCK_ITEM TMSB CHAR 2 0

TMZR foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TMZR CAT_PROF TMZR MANDT WCAT_PROFILE Cost allocation profile MANDT
TMZR CAT_PROF TMZR CAT_PROF WCAT_PROFILE Cost allocation profile CAT_PROF
TMZR COLSORTGROUP TMZR MANDT TMCSGR Column Sorting Group MANDT
TMZR COLSORTGROUP TMZR COLSORTGROUP TMCSGR Column Sorting Group COLSORTGROUP
TMZR DEFAULTST TMZR STGRP TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status STATGRP
TMZR DEFAULTST TMZR DEFAULTST TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status ESTATUS
TMZR DEFAULTST TMZR MANDT TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status MANDT
TMZR DEF_COLL_BLOCK TMZR DEF_COLL_BLOCK TMSB AB: Settlement Blocks SETTLEMENT_BLOCK
TMZR DEF_COLL_BLOCK TMZR MANDT TMSB AB: Settlement Blocks MANDT
TMZR DEF_COLL_BLOCK_I TMZR MANDT TMSB AB: Settlement Blocks MANDT
TMZR DEF_COLL_BLOCK_I TMZR DEF_COLL_BLOCK_I TMSB AB: Settlement Blocks SETTLEMENT_BLOCK
TMZR DEF_SBLOCK_C TMZR MANDT TMSB AB: Settlement Blocks MANDT
TMZR DEF_SBLOCK_C TMZR DEF_SBLOCK_C TMSB AB: Settlement Blocks SETTLEMENT_BLOCK
TMZR DEF_SBLOCK_I_C TMZR MANDT TMSB AB: Settlement Blocks MANDT
TMZR DEF_SBLOCK_I_C TMZR DEF_SBLOCK_I_C TMSB AB: Settlement Blocks SETTLEMENT_BLOCK
TMZR DEF_SBLOCK_I_V TMZR MANDT TMSB AB: Settlement Blocks MANDT
TMZR DEF_SBLOCK_I_V TMZR DEF_SBLOCK_I_V TMSB AB: Settlement Blocks SETTLEMENT_BLOCK
TMZR DEF_SBLOCK_V TMZR MANDT TMSB AB: Settlement Blocks MANDT
TMZR DEF_SBLOCK_V TMZR DEF_SBLOCK_V TMSB AB: Settlement Blocks SETTLEMENT_BLOCK
TMZR FIELDSTATUSGROUP TMZR FIELDSTATUSGROUP TMFSG Field status groups FIELDSTATUSGROUP
TMZR FIELDSTATUSGROUP TMZR MANDT TMFSG Field status groups MANDT
TMZR IDENT1 TMZR IDENT1 TFACD Factory calendar definition IDENT
TMZR KAPPL TMZR KAPPL T681A Conditions: Applications KAPPL
TMZR KUNRE_DUM SYST MANDT KNA1 General Data in Customer Master MANDT
TMZR KUNRE_DUM TMZR KUNRE_DUM KNA1 General Data in Customer Master KUNNR
TMZR LFART TMZR MANDT TMFK Agency Business: Billing Document Types MANDT
TMZR LFART TMZR LFART TMFK Agency Business: Billing Document Types LFART
TMZR LFART_BD TMZR LFART_BD TMFK Agency Business: Billing Document Types LFART
TMZR LFART_BD TMZR MANDT TMFK Agency Business: Billing Document Types MANDT
TMZR LFART_BL TMZR MANDT TMFK Agency Business: Billing Document Types MANDT
TMZR LFART_BL TMZR LFART_BL TMFK Agency Business: Billing Document Types LFART
TMZR LFART_COLL TMZR MANDT TMFK Agency Business: Billing Document Types MANDT
TMZR LFART_COLL TMZR LFART_COLL TMFK Agency Business: Billing Document Types LFART
TMZR LFART_RG TMZR MANDT TMFK Agency Business: Billing Document Types MANDT
TMZR LFART_RG TMZR LFART_RG TMFK Agency Business: Billing Document Types LFART
TMZR LFART_VS TMZR MANDT TMFK Agency Business: Billing Document Types MANDT
TMZR LFART_VS TMZR LFART_VS TMFK Agency Business: Billing Document Types LFART
TMZR LIFRE_DUM TMZR LIFRE_DUM LFA1 Vendor Master (General Section) LIFNR
TMZR LIFRE_DUM SYST MANDT LFA1 Vendor Master (General Section) MANDT
TMZR MANDT TMZR MANDT T000 Clients MANDT
TMZR PROCESS_TYPE TMZR PROCESS_TYPE WLF_C_PROCTYPE Process Category PROCESS_TYPE
TMZR PROCESS_TYPE TMZR MANDT WLF_C_PROCTYPE Process Category MANDT
TMZR PROFFAIL TMZR MANDT TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status MANDT
TMZR PROFFAIL TMZR STGRP TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status STATGRP
TMZR PROFFAIL TMZR PROFFAIL TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status ESTATUS
TMZR PROFOK TMZR MANDT TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status MANDT
TMZR PROFOK TMZR STGRP TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status STATGRP
TMZR PROFOK TMZR PROFOK TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status ESTATUS
TMZR STATUS_ERR TMZR STATUS_ERR TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status ESTATUS
TMZR STATUS_ERR SYST MANDT TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status MANDT
TMZR STATUS_ERR TMZR STGRP TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status STATGRP
TMZR STATUS_IN_ERR SYST MANDT TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status MANDT
TMZR STATUS_IN_ERR TMZR STGRP TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status STATGRP
TMZR STATUS_IN_ERR TMZR STATUS_IN_ERR TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status ESTATUS
TMZR STATUS_IN_REL TMZR STATUS_IN_REL TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status ESTATUS
TMZR STATUS_IN_REL SYST MANDT TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status MANDT
TMZR STATUS_IN_REL TMZR STGRP TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status STATGRP
TMZR STATUS_OUT SYST MANDT TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status MANDT
TMZR STATUS_OUT TMZR STGRP TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status STATGRP
TMZR STATUS_OUT TMZR STATUS_OUT TMPA5 Agency Business: Profit Analysis Status Group - Appl.Status ESTATUS
TMZR STGRP TMZR MANDT TMPA4 Agency Business: Profit Analysis Status Group MANDT
TMZR STGRP TMZR STGRP TMPA4 Agency Business: Profit Analysis Status Group STATGRP
TMZR WPRAN TMZR MANDT TMPA Agency Business: Control Data Profit Simulation MANDT
TMZR WPRAN TMZR WPRAN TMPA Agency Business: Control Data Profit Simulation WPRAN
TMZR WRART_COLL TMZR MANDT TMZR Agency Business: Payment Types MANDT
TMZR WRART_COLL TMZR WRART_COLL TMZR Agency Business: Payment Types WRART
TMZR XIF_FN_MAPSAVE TMZR XIF_FN_MAPSAVE TFDIR Function Module FUNCNAME
TMZR XIF_FN_MAPSEND TMZR XIF_FN_MAPSEND TFDIR Function Module FUNCNAME