SAP ABAP Table SPRT1 (Partner table)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVV (Package) R/3 application development for Financial Assets Management

Basic Data

Table Category	INTTAB	Structure
Structure	SPRT1	Table Relationship Diagram
Short Description	Partner table

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	PARTNR	☑	SPARTNR	SPARTNR	CHAR	10	0	Partner number
3	KZPTP	☐	KZPTP	XFELD	CHAR	1	0	Person type indicator (legal or natural)
4	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
5	CNTRY_H	☐	CNTRY_H	LAND1	CHAR	3	0	Country of origin	T005
6	SPRSL	☐	SPRSL	SPRAS	LANG	1	0	Language Key	T002
7	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
8	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
9	ANRED	☐	SANRED	SANRED	NUMC	2	0	Form-of-Address Key	*
10	XANRED	☐	XANRED	TEXT50	CHAR	50	0	Form of address text
11	ANRBF	☐	SANRBF	SANRBF	NUMC	2	0	Salutation key	*
12	XANRBF	☐	XANRBF	TEXT50	CHAR	50	0	Translation for saluation key
13	SORTL	☐	PARTID	CHAR10	CHAR	10	0	Partner ID
14	PHSRT	☐	PHSRT	CHAR20	CHAR	20	0	Phonetic search term
15	PARTID	☐	VVXPARTID	CHAR15	CHAR	15	0	IS-IS: Partner identification
16	NAME1_MC	☐	VVXNAME1MC	CHAR16	CHAR	16	0	IS-IS: Name 1 in upper case characters for matchcode search
17	FLG_ANRBF	☐	VVSABWBA	XFELD	CHAR	1	0	ID for alternative salutations
18	FLG_MITARB	☐	VVSMITARB	XFELD	CHAR	1	0	IS-IS: Indicator, partner is employee

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SPRT1	CNTRY_H	T005	LAND1	KEY	1	1
2	SPRT1	MANDT	T000	MANDT	KEY	1	1
3	SPRT1	SPRSL	T002	SPRAS	KEY	1	1

History

Last changed by/on	SAP	20130529
SAP Release Created in