SAP ABAP Table SPDE1 (Partner-Customer relationship)

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	SPDE1	Table Relationship Diagram
Short Description	Partner-Customer relationship

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	SPRT1
3	ADRNR	☑	SADRNR	SADRNR	CHAR	10	0	Address number	SANS1
4	ADRTYP	☑	ADRTYP	ADRTYP	CHAR	2	0	Type of partner address	TZV10
5	NUMKR	☑	NUMKR	CHAR2	CHAR	2	0	Number range
6	KUNNR	☐	KUNNR_VV	KUNNR_VV	CHAR	10	0	Customer number RF-VV
7	FLG_CONN	☐	VVSCONDEB	XFELD	CHAR	1	0	IS-IS: Indic., FI-Customer is assigned to DARWIN partner

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SPDE1	ADRNR	SANS1	ADRNR	KEY	1	CN
2	SPDE1	ADRTYP	TZV10	ADRTYP	KEY	1	CN
3	SPDE1	MANDT	T000	MANDT	KEY	1	CN
4	SPDE1	PARTNR	SPRT1	PARTNR	KEY	1	CN

History

Last changed by/on	SAP	19980428
SAP Release Created in