SAP table TMZR (Settlement Process Types)

SAP table TMZR has 2 primary key fields being MANDT,WRART.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
WRART Settlement Process Type CHAR 4 0 WRART
WBTYP Settlement Process Category CHAR 1 0 WBTYPE
Settlement Document
A Supplier Settlement List
B Document Parking
WRTYP Entry Category for Logistics Data CHAR 1 0 WRTYP
A Without Logistics Data
B With Logistics Data
C Material-Related With Logistics Data
D Material-Related Without Logistics Data
KAPPL Application CHAR 2 0 T681A KAPPL
LFART Settlement Document Type CHAR 4 0 TMFK WFART
LFART_RG Settlement Document Type for Supplier Settlement List CHAR 4 0 TMFK WFART_RG
LFART_BL Settlement Document Type for Customer Settlement List CHAR 4 0 TMFK WFART_BL
LFART_BD Settlement Document Type for Customer Settlement CHAR 4 0 TMFK WFART_BD
LFART_VS Settlement Document Type for Supplier Settlement CHAR 4 0 TMFK WFART_VS
IDENT1 Settlement Calendar CHAR 2 0 TFACD WRKAL
WZKRL Customer Credit Limit Check CHAR 1 0 WZKRL
WZAHL Default for Payment Terms of Customer CHAR 1 0 WZAHL
A Copy from Supplier 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)
G Copy from Customer Master for Credit Memos (Payer)
H Copy from Customer Master for Credit Memos (Invoice Recip.)
WSTBU Post Tax Amounts CHAR 1 0 WSTBU
WZAHLK Default for Payment Terms of Supplier CHAR 1 0 WZAHLK
A Copy from Supplier Master
B Copy from Invoice (Data Entered)
C Copy Condition(s) Determined
D No Terms of Payment
E Copy from Supplier Master for Credit Memos
WRLPAR Recipient of a Settlement Document List CHAR 1 0 WRLPAR
Supplier
A Customer
WKOPAR Price Determination on Supplier and/or Customer Side CHAR 1 0 WKOPAR
Supplier Side
A Customer Side
B Supplier and Customer Side
WDOPZ Check Document for Duplicate Entry CHAR 1 0 WDOPZ
WVOLP Post Business Volume in Accounting Document CHAR 1 0 WVOLP
No Business Volume Posting
B Gross
M Material
P Using Pricing
X Net
WBUVE Basis for Settlement Document List Date CHAR 1 0 WBUVE
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 Post Conditions with Accruals Indicator CHAR 1 0 WBART
WTAXCAL Calculate Tax Amount for Tax Code CHAR 1 0 WSTRE
WUNVO Incompleteness Check CHAR 1 0 WUNVO
No Check
A Check at Document Level
B Check at Document and Accounting Level
WTAXD Different Input/Output Tax Amounts are Allowed CHAR 1 0 WTAXD
WPAYD Method for Determining Term of Pyt for Supplier Sett. List CHAR 1 0 WPAYD
A Calculation of an Average Due Date
B Interest Calculation for Early Payment
C Copy from Supplier Settlement 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 CHAR 1 0 SZBMETHSKT
WPRAN Profit Analysis Type CHAR 4 0 TMPA WPRAN
STGRP Status Group for Settlement Management Documents CHAR 4 0 TMPA4 WSTATG
DEFAULTST Default Application Status for Settlement Management Doc. CHAR 4 0 TMPA5 WLF_DEFAULT_ESTATUS
WKALS Pricing Procedure Determination Type Supplier/Customer-Side CHAR 1 0 WKALS
Without Customer Schema
A With Customer Schema
B Separate Schema Determination for Supplier and Customer Side
C Separate Schema Determination (with Schema Group PurchOrg)
D Only Document Schema Group
E Document Schema Group and Schema Group Purchasing Org.
F Document Schema Group and Customer Schema
PROFOK Application Status for a Settlement Management Document CHAR 4 0 TMPA5 WSTATE
PROFFAIL Default Application Status if an Error Occurs CHAR 4 0 TMPA5 WLF_WSTATE_ERR
SETBRTWR Determine Gross Value Automatically CHAR 1 0 SETBRTWR
Manual Entry
A Automatically for Single Documents
B Automatically for List Documents
C Automatically for List and Single Documents
SPLITT Separate FI Documents for Customer/Supplier from Settl. Docs CHAR 1 0 WLF_SPLITT
For Deferred Tax Only
1 Always
2 Never
9 Customer-Specific Method (BAdI)
TAX_CODE_DETERM Tax Code Determination CHAR 1 0 WLF_TAX_CODE_DETERMINATION
Manual Entry
1 Supplier: Manual Entry; Customer: from Price Determination
2 Customer: Manual Entry; Supplier: from Price Determination
3 From Price Determination
REMU_COND_CHECK Check Settlement Docum. List Conditions for Existence in Doc CHAR 1 0 WLF_REMU_COND_CHECK
Checked for Existence
1 Not Checked for Existence
CROSS_COMPANY Cross-Company Settlement Category CHAR 1 0 WLF_CROSS_COMPANY
Inactive
1 Cross-Company-Code Sales
2 Intercompany Billing
SETTL_PARTY Settlement Partner Category CHAR 1 0 WLF_SETTLEMENT_PARTY
Standard
1 Only Supplier Side
2 Only Customer Side
3 None
4 Personnel Number
5 Only Supplier Side - Customer for Information
6 Only Customer Side - Supplier for Information
SETTL_METHOD Settlement Procedure CHAR 1 0 WLF_SETTLEMENT_METHOD
Direct Settlement
1 Settlement using Follow-On Documents
2 Collective Settlement
DEF_SBLOCK_V Reason for Supplier Settlement Block CHAR 2 0 TMSB WLF_SETTLEMENT_BLOCK_V
DEF_SBLOCK_C Reason for Customer Settlement Block CHAR 2 0 TMSB WLF_SETTLEMENT_BLOCK_C
DEF_SBLOCK_I_V Reason for Supplier Settlement Block at Item CHAR 2 0 TMSB WLF_SETTLEMENT_BLOCK_ITEM_V
DEF_SBLOCK_I_C Reason for Customer Settlement Block at Item CHAR 2 0 TMSB WLF_SETTLEMENT_BLOCK_ITEM_C
SETTL_VIA_SR_V Supplier Settlement Based Directly on Settlement Documents CHAR 1 0 WLF_SETTLEMENT_VIA_SR_V
SETTL_VIA_SR_C Settlement for Customer Based Directly on Settlement Docs CHAR 1 0 WLF_SETTLEMENT_VIA_SR_C
VS_DOC_CREATION Generation of Supplier Settlement CHAR 1 0 WLF_VENDOR_SETTLEMENT_CREATION
CS_DOC_CREATION Generation of Customer Settlement CHAR 1 0 WLF_CUST_SETTLEMENT_CREATION
On Header Level (Standard)
1 On Item Level
2 On Item Level without Header Partner
UI_SCOPE Maintenance Scope for Online Transactions CHAR 1 0 WLF_UI_MAINTENANCE_SCOPE
Documents Can Be Maintained Without Any Restrictions
1 Documents Cannot Be Created Using Online Transactions
PRICING_SEQUENCE Pricing Sequence CHAR 1 0 WLF_PRICING_SEQUENCE
First Supplier and then Customer Pricing
1 First Customer and then Supplier Pricing
SCENARIO_SUBTYP FSL: Scenario Subtype for Contract Determination CHAR 3 0 FSL_SCENARIO_SUBTYP
No Leasing
BIL Leasing Without Contract Determination
CUS Leasing with Customer-Specific Contract Determination
INT Leasing with Internal Contract Determination
XIF Leasing with External Contract Determination
XIF_KIDNO_CHECK General Flag CHAR 1 0 FLAG
Flag is not set
X Flag set (event raised)
XIF_ACTIVE General Flag CHAR 1 0 FLAG
Flag is not set
X Flag set (event raised)
XIF_FN_MAPSEND Function name CHAR 30 0 TFDIR FUNCNAME
XIF_FN_MAPSAVE Function name CHAR 30 0 TFDIR FUNCNAME
STATUS_OUT Application Status for a Settlement Management Document CHAR 4 0 TMPA5 WSTATE
STATUS_IN_ERR Default Application Status if an Error Occurs CHAR 4 0 TMPA5 WLF_WSTATE_ERR
STATUS_IN_REL Application Status for a Settlement Management Document CHAR 4 0 TMPA5 WSTATE
KUNRE_DUM Bill-to Party CHAR 10 0 KNA1 KUNRE
LIFRE_DUM Different Invoicing Party CHAR 10 0 LFA1 LIFRE
STATUS_ERR Application Status for a Settlement Management Document CHAR 4 0 TMPA5 WSTATE
USE_CRMBILLING General Flag CHAR 1 0 FLAG
Flag is not set
X Flag set (event raised)
IV_REL Check-Relevant CHAR 1 0 WLF_IV_REL
Not Relevant (Standard Setting)
1 Invoice Entry
2 Balance Carryforward
3 Definition According to Customizing (Settlem. Doc List Type)
FIELDSTATUSGROUP Field Status Group CHAR 4 0 TMFSG WLF_FIELDSTATUSGROUP
COLSORTGROUP Column Sorting Group CHAR 4 0 TMCSGR WLF_COLSORTGROUP
CHECK_LFART Check Allowed Comb. Settlement Proc. Type / Settl. Doc. Type CHAR 1 0 WLF_CHECK_WRART_LFART
SHOW_ORG_DATA Entry of Organizational Data CHAR 1 0 WLF_SHOW_ORG_DATA_SCREEN
Only if Necessary
1 Always
FULL_ORG_DATA Enter Organizational Data for Settlement Partners Completely CHAR 1 0 WLF_FULL_ORG_DATA
CAT_PROF Cost allocation profile CHAR 4 0 WCAT_PROF
CO_DATA_CUST Alternative Account Assignment Fields for Customer/Clearing CHAR 1 0 WLF_CO_DATA_CUSTOMER
TAX_CODE_MISSING Handling of Missing Tax Code CHAR 1 0 WLF_HANDLE_TAX_CODE_MISSING
Error Message
1 Pricing Error
2 No Error
PROCESS_TYPE Settlement Management Process Category CHAR 4 0 WLF_C_PROCTYPE WLF_PROCESS_TYPE
WRART_COLL Settlement Process Type for Collective Settlement CHAR 4 0 TMZR WLF_WRART_COLLECTION
LFART_COLL Settlement Doc. Type for Collective Settlement CHAR 4 0 TMFK WLF_LFART_COLLECTION
COLL_TYPE Collection Category for Settlement CHAR 1 0 WLF_COLLECTION_TYPE
Inactive
1 Active at Header Level
2 Active at Item Level
3 Active at Item Level with Customer on Item Level
DEF_COLL_BLOCK Default Collective Settlement Block of Settlement Documents CHAR 2 0 TMSB WLF_DEFAULT_COLLECTION_BLOCK
DEF_COLL_BLOCK_I Default Collective Settlement Block Item of Settlement Doc CHAR 2 0 TMSB WLF_DEFAULT_COLLECTION_BLOCK_I
CHECK_AGREL_VEND Check that Supplier is Relevant for Settlement Management CHAR 1 0 WLF_CHECK_AGREL_VENDOR
CHECK_AGREL_CUST Check that Customer is Relevant for Settlement Management CHAR 1 0 WLF_CHECK_AGREL_CUSTOMER

TMZR foreign key relationships

Table Field Check Table Check Field
0 TMZR COLSORTGROUP TMCSGR Column Sorting Group COLSORTGROUP
1 TMZR DEFAULTST TMPA5 Assignment Status Group - Application Status MANDT
1 TMZR DEFAULTST TMPA5 Assignment Status Group - Application Status STATGRP
1 TMZR DEFAULTST TMPA5 Assignment Status Group - Application Status ESTATUS
0 TMZR DEF_COLL_BLOCK TMSB Settlement Blocks MANDT
0 TMZR DEF_COLL_BLOCK TMSB Settlement Blocks SETTLEMENT_BLOCK
1 TMZR DEF_COLL_BLOCK_I TMSB Settlement Blocks MANDT
1 TMZR DEF_COLL_BLOCK_I TMSB Settlement Blocks SETTLEMENT_BLOCK
0 TMZR DEF_SBLOCK_C TMSB Settlement Blocks MANDT
0 TMZR DEF_SBLOCK_C TMSB Settlement Blocks SETTLEMENT_BLOCK
1 TMZR DEF_SBLOCK_I_C TMSB Settlement Blocks MANDT
1 TMZR DEF_SBLOCK_I_C TMSB Settlement Blocks SETTLEMENT_BLOCK
0 TMZR DEF_SBLOCK_I_V TMSB Settlement Blocks MANDT
0 TMZR DEF_SBLOCK_I_V TMSB Settlement Blocks SETTLEMENT_BLOCK
1 TMZR DEF_SBLOCK_V TMSB Settlement Blocks MANDT
1 TMZR DEF_SBLOCK_V TMSB Settlement Blocks SETTLEMENT_BLOCK
0 TMZR FIELDSTATUSGROUP TMFSG Field Status Groups MANDT
1 TMZR KAPPL T681A Conditions: Applications KAPPL
0 TMZR KUNRE_DUM KNA1 General Data in Customer Master MANDT
0 TMZR KUNRE_DUM KNA1 General Data in Customer Master KUNNR
1 TMZR LFART TMFK Settlement Document Types LFART
0 TMZR LFART_BD TMFK Settlement Document Types LFART
1 TMZR LFART_BL TMFK Settlement Document Types LFART
0 TMZR LFART_COLL TMFK Settlement Document Types LFART
1 TMZR LFART_RG TMFK Settlement Document Types LFART
0 TMZR LFART_VS TMFK Settlement Document Types LFART
1 TMZR LIFRE_DUM LFA1 Supplier Master (General Section) MANDT
1 TMZR LIFRE_DUM LFA1 Supplier Master (General Section) LIFNR
0 TMZR PROCESS_TYPE WLF_C_PROCTYPE Process Categories MANDT
1 TMZR PROFFAIL TMPA5 Assignment Status Group - Application Status MANDT
1 TMZR PROFFAIL TMPA5 Assignment Status Group - Application Status STATGRP
1 TMZR PROFFAIL TMPA5 Assignment Status Group - Application Status ESTATUS
0 TMZR PROFOK TMPA5 Assignment Status Group - Application Status MANDT
0 TMZR PROFOK TMPA5 Assignment Status Group - Application Status STATGRP
0 TMZR PROFOK TMPA5 Assignment Status Group - Application Status ESTATUS
1 TMZR STATUS_ERR TMPA5 Assignment Status Group - Application Status MANDT
1 TMZR STATUS_ERR TMPA5 Assignment Status Group - Application Status STATGRP
1 TMZR STATUS_ERR TMPA5 Assignment Status Group - Application Status ESTATUS
0 TMZR STATUS_IN_ERR TMPA5 Assignment Status Group - Application Status MANDT
0 TMZR STATUS_IN_ERR TMPA5 Assignment Status Group - Application Status STATGRP
0 TMZR STATUS_IN_ERR TMPA5 Assignment Status Group - Application Status ESTATUS
1 TMZR STATUS_IN_REL TMPA5 Assignment Status Group - Application Status MANDT
1 TMZR STATUS_IN_REL TMPA5 Assignment Status Group - Application Status STATGRP
1 TMZR STATUS_IN_REL TMPA5 Assignment Status Group - Application Status ESTATUS
0 TMZR STATUS_OUT TMPA5 Assignment Status Group - Application Status MANDT
0 TMZR STATUS_OUT TMPA5 Assignment Status Group - Application Status STATGRP
0 TMZR STATUS_OUT TMPA5 Assignment Status Group - Application Status ESTATUS
1 TMZR STGRP TMPA4 Status Group MANDT
0 TMZR WPRAN TMPA Control Data Profit Simulation MANDT
1 TMZR WRART_COLL TMZR Settlement Process Types MANDT
0 TMZR XIF_FN_MAPSAVE TFDIR Function Module FUNCNAME
1 TMZR XIF_FN_MAPSEND TFDIR Function Module FUNCNAME