SAP ABAP Table SPBB1 (Partner-Bank 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	SPBB1	Table Relationship Diagram
Short Description	Partner-Bank 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	BANKS	☑	BANKS	LAND1	CHAR	3	0	Bank country key	T005
4	BANKL	☑	BANKL	BANKL	CHAR	15	0	Bank number
5	BANKN	☑	BANKN	BANKN	CHAR	18	0	Bank account number
6	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
7	BVTYP	☐	BVTYP	BVTYP	CHAR	4	0	Partner bank type
8	XEZER	☐	XEZER	XFELD	CHAR	1	0	Indicator: Is there collection authorization ?
9	KZ_LV	☐	KZ_LV	XFELD	CHAR	1	0	Deletion flag indicator (partner management)
10	NAMLV	☐	NAM_LV	USNAM	CHAR	12	0	User name deletion indicator (partner management)
11	DATLV	☐	DAT_LV	DATUM	DATS	8	0	Deletion flag date (partner management)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SPBB1	BANKS	T005	LAND1	KEY	1	CN
2	SPBB1	MANDT	T000	MANDT	KEY	1	CN
3	SPBB1	PARTNR	SPRT1	PARTNR	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in