TPZ7U SAP (BP: Business Partner - Relationship Category) Table details

Dictionary Type: Table
Description: BP: Business Partner - Relationship Category




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




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

TPZ7U is a standard SAP Table which is used to store BP: Business Partner - Relationship Category data and is available within R/3 SAP systems depending on the version and release level.

The TPZ7U table consists of various fields, each holding specific information or linking keys about BP: Business Partner - Relationship Category data available in SAP. These include REL_TYP (Business Partner Relationship Category), KARDINAL (Cardinality of BP Relationship Category), TYPE_P1 (Category of Business Partner 1), TYPE_P2 (Category of Business Partner 2).. 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


SAP TPZ7U 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
REL_TYPBusiness Partner Relationship Category BP_REL_TYP_OLDCHAR4TPZ7BP_REL_TYP
KARDINALCardinality of BP Relationship Category BP_KARDINCHAR2BP_KARDIN
TYPE_P1Category of Business Partner 1 BP_TYPE_P1CHAR1BP_TYPE
TYPE_P2Category of Business Partner 2 BP_TYPE_P2CHAR1BP_TYPE
COMPNYCCompany Code Relevance Indicator BP_COMPNYCCHAR1XFELD
RELTYPBusiness Partner Relationship Category BU_RELTYPCHAR6TBZ9BU_RELTYP
ORDER_CHANGEChange Sequence BU_ORDERCHAR1BU_ORDER
REL_MAINBusiness Partner: Leading Relationship Category BU_REL_MAINCHAR1XFELD
REL_GRPBusiness Partner: Convert to Group BU_REL_GRPCHAR1XFELD

Key field Non-key field



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

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

SELECT SINGLE *
FROM TPZ7U
INTO CORRESPONDING FIELDS OF WA_TPZ7U
WHERE...

How to access SAP table TPZ7U

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