TMZR SAP (Agency Business: Payment Types) Table details
Dictionary Type: Table
Description: Agency Business: Payment Types
Description: Agency Business: Payment Types
Table field list including key, data, relationships and ABAP select examples
TMZR is a standard SAP Table which is used to store Agency Business: Payment Types data and is available within R/3 SAP systems depending on the version and release level.
The TMZR table consists of various fields, each holding specific information or linking keys about Agency Business: Payment Types data available in SAP. These include WRART (Agency business: Payment type), WBTYP (Settlement request: Payment type), WRTYP (Entry category: payment), KAPPL (Application).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: G - Customising table which is protected against SAP UpdateDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = TMZRT
SAP TMZR table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
WRART | Agency business: Payment type | WRART | CHAR | 4 | WRART | WRA | |||
WBTYP | Settlement request: Payment type | WBTYPE | CHAR | 1 | WBTYPE | ||||
WRTYP | Entry category: payment | WRTYP | CHAR | 1 | WRTYP | ||||
KAPPL | Application | KAPPL | CHAR | 2 | T681A | KAPPL | KAP | ||
LFART | Agency business: Billing document type | WFART | CHAR | 4 | TMFK | WFART | WFA | ||
LFART_RG | Agency Business: Billing Doc. Type - Settlement Req. List | WFART_RG | CHAR | 4 | TMFK | WFART | |||
LFART_BL | Settlement request: Billing doc. category - posting list | WFART_BL | CHAR | 4 | TMFK | WFART | |||
LFART_BD | Agency Business: Billing Type for Customer Settlement | WFART_BD | CHAR | 4 | TMFK | WFART | |||
LFART_VS | Agency Business: Billing Doc. Type - Vendor Settlement | WFART_VS | CHAR | 4 | TMFK | WFART | |||
IDENT1 | Settlement calendar | WRKAL | CHAR | 2 | TFACD | WFCID | |||
WZKRL | Agency Business: Customer Credit Limit Check | WZKRL | CHAR | 1 | XFELD | ||||
WZAHL | Agency Business: Customer Terms of Payment | WZAHL | CHAR | 1 | WZAHL | ||||
WSTBU | Agency Business: Post Tax Amounts | WSTBU | CHAR | 1 | XFELD | ||||
WZAHLK | Settlement request: vendor payment terms | WZAHLK | CHAR | 1 | WZAHLK | ||||
WRLPAR | Agency Business: Remuneration List Recipient | WRLPAR | CHAR | 1 | WRLPAR | ||||
WKOPAR | Agency Business: Condition Determin. Level, Payment Docs | WKOPAR | CHAR | 1 | WKOPAR | ||||
WDOPZ | Check document for duplicate entry (payment processing) | WDOPZ | CHAR | 1 | XFELD | ||||
WVOLP | Set sales volume values in accounting document | WVOLP | CHAR | 1 | WVOLP | ||||
WBUVE | Agency Business: Basis for Remuneration List Date | WBUVE | CHAR | 1 | WBUVE | ||||
WBART | Only include condition data (provisions) | WBART | CHAR | 1 | XFELD | ||||
WTAXCAL | Payment document: Calculate tax for tax code | WSTRE | CHAR | 1 | XFELD | ||||
WUNVO | Payment document: Incompleteness permitted | WUNVO | CHAR | 1 | WUNVO | ||||
WTAXD | Settlement request: Different tax allowed | WTAXD | CHAR | 1 | XFELD | ||||
WPAYD | Method for determining term of payment for settlm. req. list | WPAYD | CHAR | 1 | WPAYD | ||||
SZBMETH | Method of calculating interest for additional cash discount | SZBMETHSKT | CHAR | 1 | SZBMETH | ||||
WPRAN | Agency business: Profit analysis type | WPRAN | CHAR | 4 | TMPA | CHAR4 | |||
STGRP | Agency business: Status group | WSTATG | CHAR | 4 | TMPA4 | CHAR4 | |||
DEFAULTST | Agency business: Application status | WSTATE | CHAR | 4 | TMPA5 | WSTATE | |||
WKALS | Agency Business: Schema determination vendor/custmr | WKALS | CHAR | 1 | WKALS | ||||
PROFOK | Agency business: Application status | WSTATE | CHAR | 4 | TMPA5 | WSTATE | |||
PROFFAIL | Agency business: Application status | WSTATE | CHAR | 4 | TMPA5 | WSTATE | |||
SETBRTWR | Agency Business: Set Gross Value Automatically | SETBRTWR | CHAR | 1 | SETBRTWR | ||||
SPLITT | Split FI Documents from Single Settlement Requests | WLF_SPLITT | CHAR | 1 | WLF_SPLITT | ||||
TAX_CODE_DETERM | Tax Code Determination | WLF_TAX_CODE_DETERMINATION | CHAR | 1 | WLF_TAX_CODE_DETERMINATION | ||||
REMU_COND_CHECK | Check Remuneration List Conditions for Existence in Document | WLF_REMU_COND_CHECK | CHAR | 1 | WLF_REMU_COND_CHECK | ||||
CROSS_COMPANY | AB: Cross-Company Code Payment Documents | WLF_CROSS_COMPANY | CHAR | 1 | WLF_CROSS_COMPANY | ||||
SETTL_PARTY | AB: Settlement Partner | WLF_SETTLEMENT_PARTY | CHAR | 1 | WLF_POST_PARTY | ||||
SETTL_METHOD | AB: Settlement Procedure | WLF_SETTLEMENT_METHOD | CHAR | 1 | WLF_SETTLEMENT_METHOD | ||||
DEF_SBLOCK_V | AB: Settlement Block - Vendor | WLF_SETTLEMENT_BLOCK_V | CHAR | 2 | TMSB | WLF_SETTLEMENT_BLOCK | |||
DEF_SBLOCK_C | AB: Settlement Block - Customer | WLF_SETTLEMENT_BLOCK_C | CHAR | 2 | TMSB | WLF_SETTLEMENT_BLOCK | |||
DEF_SBLOCK_I_V | AB: Settlement Block - Item - Vendor | WLF_SETTLEMENT_BLOCK_ITEM_V | CHAR | 2 | TMSB | WLF_SETTLEMENT_BLOCK | |||
DEF_SBLOCK_I_C | AB: Settlement Block - Item - Customer | WLF_SETTLEMENT_BLOCK_ITEM_C | CHAR | 2 | TMSB | WLF_SETTLEMENT_BLOCK | |||
SETTL_VIA_SR_V | AB: Settlement Vendor Using Settlement Request | WLF_SETTLEMENT_VIA_SR_V | CHAR | 1 | XFELD | ||||
SETTL_VIA_SR_C | AB: Settlement Customer Using Settlement Request | WLF_SETTLEMENT_VIA_SR_C | CHAR | 1 | XFELD | ||||
VS_DOC_CREATION | AB: Generation of Vendor Settlement | WLF_VENDOR_SETTLEMENT_CREATION | CHAR | 1 | WLF_SETTLEMENT_CREATION | ||||
CS_DOC_CREATION | AB: Customer-Settlement Generation | WLF_CUST_SETTLEMENT_CREATION | CHAR | 1 | WLF_SETTLEMENT_CREATION | ||||
.INCLU--AP | 0 | ||||||||
SCENARIO_SUBTYP | FSL: Scenario Subtype for Contract Determination | FSL_SCENARIO_SUBTYP | CHAR | 3 | FSL_SCENARIO_SUBTYP | ||||
XIF_KIDNO_CHECK | General Flag | FLAG | CHAR | 1 | FLAG | ||||
XIF_ACTIVE | General Flag | FLAG | CHAR | 1 | FLAG | ||||
XIF_FN_MAPSEND | Function name | FUNCNAME | CHAR | 30 | TFDIR | FUNCNAME | LIB | ||
XIF_FN_MAPSAVE | Function name | FUNCNAME | CHAR | 30 | TFDIR | FUNCNAME | LIB | ||
STATUS_OUT | Agency business: Application status | WSTATE | CHAR | 4 | TMPA5 | WSTATE | |||
STATUS_IN_ERR | Agency business: Application status | WSTATE | CHAR | 4 | TMPA5 | WSTATE | |||
STATUS_IN_REL | Agency business: Application status | WSTATE | CHAR | 4 | TMPA5 | WSTATE | |||
KUNRE_DUM | Bill-to party | KUNRE | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
LIFRE_DUM | Different Invoicing Party | LIFRE | CHAR | 10 | LFA1 | ALPHA | LIFNR | LRE | |
STATUS_ERR | Agency business: Application status | WSTATE | CHAR | 4 | TMPA5 | WSTATE | |||
USE_CRMBILLING | General Flag | FLAG | CHAR | 1 | FLAG | ||||
.INCLU--AP | 0 | ||||||||
IV_REL | Check-Relevant | WLF_IV_REL | CHAR | 1 | WLF_IV_REL | ||||
.INCLU--AP | 0 | ||||||||
FIELDSTATUSGROUP | Field Status Group | WLF_FIELDSTATUSGROUP | CHAR | 4 | TMFSG | WLF_FIELDSTATUSGROUP | |||
COLSORTGROUP | Column Sorting Group | WLF_COLSORTGROUP | CHAR | 4 | TMCSGR | WLF_COLSORTGROUP | |||
CHECK_LFART | Check Allowed Combinations Payment Type / Billing Type | WLF_CHECK_WRART_LFART | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
SHOW_ORG_DATA | Recording of Organizational Data | WLF_SHOW_ORG_DATA_SCREEN | CHAR | 1 | WLF_SHOW_ORG_DATA_SCREEN | ||||
FULL_ORG_DATA | Complete Organizational Data - Settlement Partner | WLF_FULL_ORG_DATA | CHAR | 1 | XFELD | ||||
CAT_PROF | Cost allocation profile | WCAT_PROF | CHAR | 4 | WCAT_PROFILE | WCAT_PROF | |||
.INCLU--AP | 0 | ||||||||
CO_DATA_CUST | Own CO Account Assingment Field for Customer | WLF_CO_DATA_CUSTOMER | CHAR | 1 | XFELD | ||||
TAX_CODE_MISSING | AB: Handling of Missing Tax Code | WLF_HANDLE_TAX_CODE_MISSING | CHAR | 1 | WLF_HANDLE_TAX_CODE_MISSING | ||||
PROCESS_TYPE | Process Category | WLF_PROCESS_TYPE | CHAR | 4 | WLF_C_PROCTYPE | WLF_PROCESS_TYPE | |||
.INCLU--AP | 0 | ||||||||
WRART_COLL | AD: Payment Type for Collection of Settlement Requests | WLF_WRART_COLLECTION | CHAR | 4 | TMZR | WRART | |||
LFART_COLL | AD: Billing Type for Collection of Settlement Requests | WLF_LFART_COLLECTION | CHAR | 4 | TMFK | WFART | |||
COLL_TYPE | AD: Collection of Settlement Requests | WLF_COLLECTION_TYPE | CHAR | 1 | WLF_COLLECTION_TYPE | ||||
DEF_COLL_BLOCK | AB: Block for Collection of Settlement Requests | WLF_COLLECTION_BLOCK | CHAR | 2 | TMSB | WLF_SETTLEMENT_BLOCK | |||
DEF_COLL_BLOCK_I | AB: Block Item for Collection of Settlement Requests | WLF_COLLECTION_BLOCK_ITEM | CHAR | 2 | TMSB | WLF_SETTLEMENT_BLOCK |
Key field | Non-key field |
How do I retrieve data from SAP table TMZR using ABAP code
The following ABAP code Example will allow you to do a basic selection on TMZR to SELECT all data from the tableDATA: WA_TMZR TYPE TMZR.
SELECT SINGLE *
FROM TMZR
INTO CORRESPONDING FIELDS OF WA_TMZR
WHERE...
How to access SAP table TMZR
Within an ECC or HANA version of SAP you can also view further information about TMZR and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects