SAP ABAP Table SPKR1 (Partner-Vendor 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	TRANSP	Transparent table
Transparent table	SPKR1	Table Relationship Diagram
Short Description	Partner-Vendor relationship

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	RANTYP	☑	RANTYP	RANTYP	CHAR	1	0	Contract Type
6	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in