TMZR SAP (Agency Business: Payment Types) Table details

Dictionary Type: Table
Description: Agency Business: Payment Types




ABAP Code to SELECT data from TMZR
Related tables to TMZR
Access table TMZR




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 Update
Display/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
MANDTClient MANDTCLNT3T000MANDT
WRARTAgency business: Payment type WRARTCHAR4WRARTWRA
WBTYPSettlement request: Payment type WBTYPECHAR1WBTYPE
WRTYPEntry category: payment WRTYPCHAR1WRTYP
KAPPLApplication KAPPLCHAR2T681AKAPPLKAP
LFARTAgency business: Billing document type WFARTCHAR4TMFKWFARTWFA
LFART_RGAgency Business: Billing Doc. Type - Settlement Req. List WFART_RGCHAR4TMFKWFART
LFART_BLSettlement request: Billing doc. category - posting list WFART_BLCHAR4TMFKWFART
LFART_BDAgency Business: Billing Type for Customer Settlement WFART_BDCHAR4TMFKWFART
LFART_VSAgency Business: Billing Doc. Type - Vendor Settlement WFART_VSCHAR4TMFKWFART
IDENT1Settlement calendar WRKALCHAR2TFACDWFCID
WZKRLAgency Business: Customer Credit Limit Check WZKRLCHAR1XFELD
WZAHLAgency Business: Customer Terms of Payment WZAHLCHAR1WZAHL
WSTBUAgency Business: Post Tax Amounts WSTBUCHAR1XFELD
WZAHLKSettlement request: vendor payment terms WZAHLKCHAR1WZAHLK
WRLPARAgency Business: Remuneration List Recipient WRLPARCHAR1WRLPAR
WKOPARAgency Business: Condition Determin. Level, Payment Docs WKOPARCHAR1WKOPAR
WDOPZCheck document for duplicate entry (payment processing) WDOPZCHAR1XFELD
WVOLPSet sales volume values in accounting document WVOLPCHAR1WVOLP
WBUVEAgency Business: Basis for Remuneration List Date WBUVECHAR1WBUVE
WBARTOnly include condition data (provisions) WBARTCHAR1XFELD
WTAXCALPayment document: Calculate tax for tax code WSTRECHAR1XFELD
WUNVOPayment document: Incompleteness permitted WUNVOCHAR1WUNVO
WTAXDSettlement request: Different tax allowed WTAXDCHAR1XFELD
WPAYDMethod for determining term of payment for settlm. req. list WPAYDCHAR1WPAYD
SZBMETHMethod of calculating interest for additional cash discount SZBMETHSKTCHAR1SZBMETH
WPRANAgency business: Profit analysis type WPRANCHAR4TMPACHAR4
STGRPAgency business: Status group WSTATGCHAR4TMPA4CHAR4
DEFAULTSTAgency business: Application status WSTATECHAR4TMPA5WSTATE
WKALSAgency Business: Schema determination vendor/custmr WKALSCHAR1WKALS
PROFOKAgency business: Application status WSTATECHAR4TMPA5WSTATE
PROFFAILAgency business: Application status WSTATECHAR4TMPA5WSTATE
SETBRTWRAgency Business: Set Gross Value Automatically SETBRTWRCHAR1SETBRTWR
SPLITTSplit FI Documents from Single Settlement Requests WLF_SPLITTCHAR1WLF_SPLITT
TAX_CODE_DETERMTax Code Determination WLF_TAX_CODE_DETERMINATIONCHAR1WLF_TAX_CODE_DETERMINATION
REMU_COND_CHECKCheck Remuneration List Conditions for Existence in Document WLF_REMU_COND_CHECKCHAR1WLF_REMU_COND_CHECK
CROSS_COMPANYAB: Cross-Company Code Payment Documents WLF_CROSS_COMPANYCHAR1WLF_CROSS_COMPANY
SETTL_PARTYAB: Settlement Partner WLF_SETTLEMENT_PARTYCHAR1WLF_POST_PARTY
SETTL_METHODAB: Settlement Procedure WLF_SETTLEMENT_METHODCHAR1WLF_SETTLEMENT_METHOD
DEF_SBLOCK_VAB: Settlement Block - Vendor WLF_SETTLEMENT_BLOCK_VCHAR2TMSBWLF_SETTLEMENT_BLOCK
DEF_SBLOCK_CAB: Settlement Block - Customer WLF_SETTLEMENT_BLOCK_CCHAR2TMSBWLF_SETTLEMENT_BLOCK
DEF_SBLOCK_I_VAB: Settlement Block - Item - Vendor WLF_SETTLEMENT_BLOCK_ITEM_VCHAR2TMSBWLF_SETTLEMENT_BLOCK
DEF_SBLOCK_I_CAB: Settlement Block - Item - Customer WLF_SETTLEMENT_BLOCK_ITEM_CCHAR2TMSBWLF_SETTLEMENT_BLOCK
SETTL_VIA_SR_VAB: Settlement Vendor Using Settlement Request WLF_SETTLEMENT_VIA_SR_VCHAR1XFELD
SETTL_VIA_SR_CAB: Settlement Customer Using Settlement Request WLF_SETTLEMENT_VIA_SR_CCHAR1XFELD
VS_DOC_CREATIONAB: Generation of Vendor Settlement WLF_VENDOR_SETTLEMENT_CREATIONCHAR1WLF_SETTLEMENT_CREATION
CS_DOC_CREATIONAB: Customer-Settlement Generation WLF_CUST_SETTLEMENT_CREATIONCHAR1WLF_SETTLEMENT_CREATION
.INCLU--AP 0
SCENARIO_SUBTYPFSL: Scenario Subtype for Contract Determination FSL_SCENARIO_SUBTYPCHAR3FSL_SCENARIO_SUBTYP
XIF_KIDNO_CHECKGeneral Flag FLAGCHAR1FLAG
XIF_ACTIVEGeneral Flag FLAGCHAR1FLAG
XIF_FN_MAPSENDFunction name FUNCNAMECHAR30TFDIRFUNCNAMELIB
XIF_FN_MAPSAVEFunction name FUNCNAMECHAR30TFDIRFUNCNAMELIB
STATUS_OUTAgency business: Application status WSTATECHAR4TMPA5WSTATE
STATUS_IN_ERRAgency business: Application status WSTATECHAR4TMPA5WSTATE
STATUS_IN_RELAgency business: Application status WSTATECHAR4TMPA5WSTATE
KUNRE_DUMBill-to party KUNRECHAR10KNA1ALPHAKUNNRKUN
LIFRE_DUMDifferent Invoicing Party LIFRECHAR10LFA1ALPHALIFNRLRE
STATUS_ERRAgency business: Application status WSTATECHAR4TMPA5WSTATE
USE_CRMBILLINGGeneral Flag FLAGCHAR1FLAG
.INCLU--AP 0
IV_RELCheck-Relevant WLF_IV_RELCHAR1WLF_IV_REL
.INCLU--AP 0
FIELDSTATUSGROUPField Status Group WLF_FIELDSTATUSGROUPCHAR4TMFSGWLF_FIELDSTATUSGROUP
COLSORTGROUPColumn Sorting Group WLF_COLSORTGROUPCHAR4TMCSGRWLF_COLSORTGROUP
CHECK_LFARTCheck Allowed Combinations Payment Type / Billing Type WLF_CHECK_WRART_LFARTCHAR1XFELD
.INCLU--AP 0
SHOW_ORG_DATARecording of Organizational Data WLF_SHOW_ORG_DATA_SCREENCHAR1WLF_SHOW_ORG_DATA_SCREEN
FULL_ORG_DATAComplete Organizational Data - Settlement Partner WLF_FULL_ORG_DATACHAR1XFELD
CAT_PROFCost allocation profile WCAT_PROFCHAR4WCAT_PROFILEWCAT_PROF
.INCLU--AP 0
CO_DATA_CUSTOwn CO Account Assingment Field for Customer WLF_CO_DATA_CUSTOMERCHAR1XFELD
TAX_CODE_MISSINGAB: Handling of Missing Tax Code WLF_HANDLE_TAX_CODE_MISSINGCHAR1WLF_HANDLE_TAX_CODE_MISSING
PROCESS_TYPEProcess Category WLF_PROCESS_TYPECHAR4WLF_C_PROCTYPEWLF_PROCESS_TYPE
.INCLU--AP 0
WRART_COLLAD: Payment Type for Collection of Settlement Requests WLF_WRART_COLLECTIONCHAR4TMZRWRART
LFART_COLLAD: Billing Type for Collection of Settlement Requests WLF_LFART_COLLECTIONCHAR4TMFKWFART
COLL_TYPEAD: Collection of Settlement Requests WLF_COLLECTION_TYPECHAR1WLF_COLLECTION_TYPE
DEF_COLL_BLOCKAB: Block for Collection of Settlement Requests WLF_COLLECTION_BLOCKCHAR2TMSBWLF_SETTLEMENT_BLOCK
DEF_COLL_BLOCK_IAB: Block Item for Collection of Settlement Requests WLF_COLLECTION_BLOCK_ITEMCHAR2TMSBWLF_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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!