SPRT1 SAP (Partner table) Structure details

Dictionary Type: Structure
Description: Partner table




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




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

SPRT1 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Partner table" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_SPRT1 TYPE SPRT1.

The SPRT1 table consists of various fields, each holding specific information or linking keys about Partner table data available in SAP. These include PARTNR (Partner number), KZPTP (Person type indicator (legal or natural)), BEGRU (Authorization Group), CNTRY_H (Country of origin).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP SPRT1 structure 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
PARTNRPartner number SPARTNRCHAR10SPARTNRPNN
KZPTPPerson type indicator (legal or natural) KZPTPCHAR1XFELD
BEGRUAuthorization Group BRGRUCHAR4Assigned to domainBRGRU
CNTRY_HCountry of origin CNTRY_HCHAR3T005LAND1
SPRSLLanguage Key SPRSLLANG1T002ISOLASPRAS
NAME1Name 1 NAME1_GPCHAR35NAME
NAME2Name 2 NAME2_GPCHAR35NAME
ANREDForm-of-Address Key SANREDNUMC2Assigned to domainSANRED
XANREDForm of address text XANREDCHAR50TEXT50
ANRBFSalutation key SANRBFNUMC2Assigned to domainSANRBF
XANRBFTranslation for saluation key XANRBFCHAR50TEXT50
SORTLPartner ID PARTIDCHAR10CHAR10
PHSRTPhonetic search term PHSRTCHAR20CHAR20
PARTIDIS-IS: Partner identification VVXPARTIDCHAR15CHAR15
NAME1_MCIS-IS: Name 1 in upper case characters for matchcode search VVXNAME1MCCHAR16CHAR16
FLG_ANRBFID for alternative salutations VVSABWBACHAR1XFELD
FLG_MITARBIS-IS: Indicator, partner is employee VVSMITARBCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP structure SPRT1 using ABAP code?

As SPRT1 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on SPRT1 as there is no data to select.

How to access SAP table SPRT1

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