TZV01 SAP (Form-of-Address Key) Pooled Table details

Dictionary Type: Pooled Table
Description: Form-of-Address Key




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




Pooled Table field list including key, data, relationships and ABAP select examples

TZV01 is a standard SAP Pooled Table which is used to store Form-of-Address Key data and is available within R/3 SAP systems depending on the version and release level.

The TZV01 table consists of various fields, each holding specific information or linking keys about Form-of-Address Key data available in SAP. These include ANRED (Form-of-Address Key), SPATYP (Partner category), TITLE (Form of Address (Key)), SEX (Gender of business partner).. 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: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

Text table = TXV01


SAP TZV01 pooled 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
ANREDForm-of-Address Key SANREDNUMC2SANRED
SPATYPPartner category SPATYPCHAR1SPATYP
TITLEForm of Address (Key) BP_TITLENUMC2TP01BP_TITLE
SEXGender of business partner BP_SEXCHAR1BP_SEX

Key field Non-key field



How do I retrieve data from SAP table TZV01 using ABAP code

The following ABAP code Example will allow you to do a basic selection on TZV01 to SELECT all data from the table
DATA: WA_TZV01 TYPE TZV01.

SELECT SINGLE *
FROM TZV01
INTO CORRESPONDING FIELDS OF WA_TZV01
WHERE...

How to access SAP table TZV01

Within an ECC or HANA version of SAP you can also view further information about TZV01 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!