VZGPO SAP (Partner/role object relationship) Table details

Dictionary Type: Table
Description: Partner/role object relationship




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




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

VZGPO is a standard SAP Table which is used to store Partner/role object relationship data and is available within R/3 SAP systems depending on the version and release level.

The VZGPO table consists of various fields, each holding specific information or linking keys about Partner/role object relationship data available in SAP. These include MANDT (Client), SNUMOBJ (Key for number range object), SOBJEKT (Internal key for object for business partner table), PARTNR (Business Partner Number).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VZGPO 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
SNUMOBJKey for number range object VVNUMOBJCHAR2VVNUMOBJ
SOBJEKTInternal key for object for business partner table VVSOBJGPOCHAR13CHAR13
PARTNRBusiness Partner Number BP_PARTNRCHAR10BP000ALPHABP_PARTNRBPN
ROLETYPBusiness Partner Role Category BP_ROLETYPCHAR4TPZ3BP_ROLETYPBPR
DTRANSFlow data key: System date VVDTRANSDATS8DATUM
DBEBEZDate of start of relationship DBEBEZDATS8DATUM
DENBEZDate of end of relationship DENBEZDATS8DATUM
APPLApplication Category BP_APPLCHAR4TPZ12BP_APPLH_TPZ12
ADR_REFAddress ID BP_ADR_REFCHAR10Assigned to domainBP_ADR_REFADK
ROLEBusiness Partner Role Type BP_ROLECHAR4TPZ6BP_ROLE
PBEZPercentage rate of relationship PBEZDEC10(7) DEC3_7
BBEZRelationship amount BBEZCURR13(2) WERTV7
SBBEZCurrency Key WAERSCUKY5TCURCWAERSFWS
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
GZLSCHPayment method for credit memos VVGZLSCHCHAR1Assigned to domainZLSCH
BVTYPPartner Bank Type BVTYPCHAR4BVTYP
ZLSCHPayment Method DZLSCHCHAR1Assigned to domainZLSCH
SDUNNDOCType of Dunning Letter SDUNNDOCCHAR1SDUNNDOC
SDUNNBUCPost Dunning Charges and Interest to This Partner SDUNNBUCCHAR1XFELD
NORDEROrder Number NORDERNUMC8NUM8ORD

Key field Non-key field



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

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

SELECT SINGLE *
FROM VZGPO
INTO CORRESPONDING FIELDS OF WA_VZGPO
WHERE...

How to access SAP table VZGPO

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