SAP ABAP Table CRM_ISU_BASKET_PARTNER (Basket Structure with Partner field)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-S-CI (Application Component) Utilities Industry: Commercial and Industrial Customers
     ⤷ CRM_IU_CI_BASKET (Package) Utilities POD Basket

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_ISU_BASKET_PARTNER	Table Relationship Diagram
Short Description	Basket Structure with Partner field

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	.INCLUDE	☐				0	0	Basket
2	.INCLUDE	☐				0	0	Basket key
3	.INCLUDE	☐				0	0	One Order: Key Fields
4	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
5	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
6	RECORD	☐	GUID_16	SYSUUID	RAW	16	0	GUID in 'RAW' format
7	.INCLUDE	☐				0	0	Basket data part without Key part
8	POD_GUID	☐	CRM_ISU_POD_GUID	CRM_ISU_POD_GUID	CHAR	22	0	Point of Delivery GUID
9	OBJ_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
10	OBJ_TYPE	☐	CRM_ISU_BASKET_OBJECT_TYPE	CRM_ISU_BASKET_OBJECT_TYPE	CHAR	2	0	Set Object Type
11	LBL_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
12	LABEL_ID	☐	CRMT_ISU_LABEL	CRMT_ISU_LABEL	CHAR	10	0	Label
13	HIDDEN	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
14	BUPA_GUID	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
15	BUAG_GUID	☐	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
16	MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
17	DELETED_FLAG	☐	CRMT_DELETED_FLAG	CRM_BOOLEAN	CHAR	1	0	Indicator whether the object is marked for deletion
18	.INCLU-BP	☐				0	0	BUIL: Structure of the Header Object
19	.INCLUDE	☐				0	0	SAP BP: BAPI Structure for Personal Data
20	FIRSTNAMEBP	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
21	LASTNAMEBP	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
22	BIRTHNAMEBP	☐	BU_BIRTHNM	BU_NAME	CHAR	40	0	Name at birth of business partner
23	MIDDLENAMEBP	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
24	SECONDNAMEBP	☐	BU_NAMEPL2	BU_NAME	CHAR	40	0	Other Last Name of a Person
25	TITLE_ACA1BP	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	TSAD2
26	TITLE_ACA2BP	☐	AD_TITLE2	AD_TITLE1	CHAR	4	0	Second academic title (key)	TSAD2
27	TITLE_SPPLBP	☐	AD_TITLES	AD_TITLES	CHAR	4	0	Name supplement, e.g. noble title (key)	TSAD5
28	PREFIX1BP	☐	AD_PREFIX	AD_PREFIX	CHAR	4	0	Name Prefix (Key)	TSAD4
29	PREFIX2BP	☐	AD_PREFIX2	AD_PREFIX	CHAR	4	0	2nd name prefix (key)	TSAD4
30	NICKNAMEBP	☐	BU_NICKNAM	BU_NAME	CHAR	40	0	Nickname of Business Partner (Person)
31	INITIALSBP	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
32	NAMEFORMATBP	☐	AD_FORMAT	AD_NAMFORM	CHAR	2	0	Name format	T005N
33	NAMCOUNTRYBP	☐	AD_NAMCTRY	LAND1	CHAR	3	0	Country for name format rule	T005
34	NAMCOUNTRYISOBP	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
35	SEXBP	☐	BU_SEXID	BU_SEXID	CHAR	1	0	Sex of business partner (person)
36	BIRTHPLACEBP	☐	BU_BIRTHPL	TEXT40	CHAR	40	0	Birthplace of business partner
37	BIRTHDATEBP	☐	BU_BIRTHDT	DATUM	DATS	8	0	Date of Birth of Business Partner
38	DEATHDATEBP	☐	BU_DEATHDT	DATUM	DATS	8	0	Date of death of business partner
39	MARITALSTATUSBP	☐	BU_MARST	BU_MARST	CHAR	1	0	Marital Status of Business Partner	TB027
40	CORRESPONDLANGUAGEBP	☐	BU_LANGU_CORR	SPRAS	LANG	1	0	Business Partner: Correspondence Language	T002
41	CORRESPONDLANGUAGEISOBP	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
42	FULLNAMEBP	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name
43	EMPLOYERBP	☐	BU_EMPLO	BU_EMPLO	CHAR	35	0	Name of Employer of a Natural Person
44	OCCUPATIONBP	☐	BU_JOBGR	BU_JOBGR	CHAR	4	0	Occupation/group	*
45	NATIONALITYBP	☐	BU_NATIO	LAND1	CHAR	3	0	Nationality	*
46	NATIONALITYISOBP	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
47	COUNTRYORIGINBP	☐	BU_CNDSC	LAND1	CHAR	3	0	Ctry of Origin: Non-Res. Companies	*
48	.INCLUDE	☐				0	0	General BP Data, Independent of Business Partner Category
49	SEARCHTERM1BP	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
50	SEARCHTERM2BP	☐	BU_SORT2	BU_SORT1	CHAR	20	0	Search term 2 for business partner
51	PARTNERTYPEBP	☐	BU_BPKIND	BU_KIND	CHAR	4	0	Business Partner Type	TB004
52	AUTHORIZATIONGROUPBP	☐	BU_AUGRP	BU_AUGRP	CHAR	4	0	Authorization Group	*
53	PARTNERLANGUAGEBP	☐	BU_LANGU	SPRAS	LANG	1	0	Business partner: Language	T002
54	PARTNERLANGUAGEISOBP	☐	LAISO	LAISO	CHAR	2	0	2-Character SAP Language Code
55	DATAORIGINTYPEBP	☐	BU_SOURCE	BU_SOURCE	CHAR	4	0	Data Origin Types	TB005
56	CENTRALARCHIVINGFLAGBP	☐	BU_XDELE	XFELD	CHAR	1	0	Central Archiving Flag
57	CENTRALBLOCKBP	☐	BU_XBLCK	XFELD	CHAR	1	0	Central Block for Business Partner
58	TITLE_KEYBP	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	TSAD3
59	CONTACTALLOWANCEBP	☐	BU_CONTACT	BU_CONTACT	CHAR	1	0	Business Partner: Contact Permission
60	PARTNEREXTERNALBP	☐	BU_BPEXT	CHAR20	CHAR	20	0	Business Partner Number in External System
61	TITLELETTERBP	☐	BU_TITLE_LET	TEXT50	CHAR	50	0	Salutation
62	NOTRELEASEDBP	☐	BU_XNOT_RELEASED	XFELD	CHAR	1	0	Indicator: Not Released
63	COMM_TYPEBP	☐	AD_COMM	AD_COMM	CHAR	3	0	Communication Method (Key) (Business Address Services)	*
64	PRINT_MODEBP	☐	BU_PRINT_MODE	BU_PRINT_MODE	CHAR	1	0	Business Partner Print Format
65	.INCLUDE	☐				0	0	SAP BP: BAPI Structure for Organization Data
66	NAME1BP	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
67	NAME2BP	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
68	NAME3BP	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
69	NAME4BP	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization
70	LEGALFORMBP	☐	BU_LEGENTY	BU_LEGENTY	CHAR	2	0	BP: Legal form of organization	TB019
71	INDUSTRYSECTORBP	☐	BU_INDSECT	BU_INDSECT	CHAR	10	0	Industry sector	TB023
72	FOUNDATIONDATEBP	☐	BU_FOUND_DAT	DATUM	DATS	8	0	Date organization founded
73	LIQUIDATIONDATEBP	☐	BU_LIQUID_DAT		DATS	8	0	Liquidation date of organization
74	LOC_NO_1BP	☐	BBBNR	NUM07	NUMC	7	0	International location number (part 1)
75	LOC_NO_2BP	☐	BBSNR	NUM05	NUMC	5	0	International location number (Part 2)
76	CHK_DIGITBP	☐	BUBKZ	NUM01	NUMC	1	0	Check digit for the international location number
77	LEGALORGBP	☐	BU_LEGAL_ORG	BU_LEGAL_ORG	CHAR	2	0	Legal Entity of Organization	*
78	.INCLUDE	☐				0	0	SAP BP: BAPI Structure for Group Data
79	NAMEGROUP1BP	☐	BU_NAMEGR1	BU_NAME	CHAR	40	0	Name 1 (group)
80	NAMEGROUP2BP	☐	BU_NAMEGR2	BU_NAME	CHAR	40	0	Name 2 (group)
81	GROUPTYPEBP	☐	BU_GRPTYP	BU_GRPTYP	CHAR	4	0	Group type	TB025
82	.INCLUDE	☐				0	0	BUIL: Header Data of a Business Partner
83	BP_GUIDBP	☐	BU_PARTNER_GUID	SYSUUID	RAW	16	0	Business Partner GUID
84	BP_NUMBERBP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
85	BP_CATEGORYBP	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
86	BP_ROLEBP	☐	BU_ROLE	BU_RLTYP	CHAR	6	0	BP role	*
87	BP_TYPEBP	☐	BU_BPKIND	BU_KIND	CHAR	4	0	Business Partner Type	*
88	BP_GROUPBP	☐	BU_GROUP	BU_GROUP	CHAR	4	0	Business Partner Grouping	*
89	BP_DESCRIPTIONBP	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
90	.INCLUDE	☐				0	0	SAP BP: BAPI Structure for Central Data
91	CREATIONDATEBP	☐	BU_CRDAT	DATUM	DATS	8	0	Date on which the object was created
92	CREATIONTIMEBP	☐	BU_CRTIM	UZEIT	TIMS	6	0	Time at which the object was created
93	CREATIONUSERBP	☐	BU_CRUSR	USNAM	CHAR	12	0	User who created the object
94	LASTCHANGEDATEBP	☐	BU_CHDAT	DATUM	DATS	8	0	Date when object was last changed
95	LASTCHANGETIMEBP	☐	BU_CHTIM	UZEIT	TIMS	6	0	Time at which object was last changed
96	LASTCHANGEUSERBP	☐	BU_CHUSR	USNAM	CHAR	12	0	Last user to change object
97	PERS_NOBP	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
98	.INCLUDE	☐				0	0	EEW Extension of BUT000 (Contains CI)
99	BP_EEW_DUMMYBP	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
100	.INCLUDE	☐				0	0
101	ACCOUNT_DESCRIPTIONBP	☐	BU_DESCRIP_LONG	CHAR80	CHAR	80	0	Description of a Business Partner
102	ACCOUNT_NAMEBP	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
103	.INCLUDE	☐				0	0	BP: Tax Numbers: General Data
104	NATURAL_PERSONBP	☐	BU_NATURAL_PERSON	BU_NATURAL_PERSON	CHAR	1	0	Business Partner Is a Natural Person Under the Tax Laws
105	SIMILARITYBP	☐	AD_PERCNT3	DEC3_1	DEC	4	1	Percentage: Similarity in Duplicate Check

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRM_ISU_BASKET_PARTNER	CORRESPONDLANGUAGEBP	T002	SPRAS	REF	C	CN
2	CRM_ISU_BASKET_PARTNER	DATAORIGINTYPEBP	TB005	SOURCE	KEY	1	CN
3	CRM_ISU_BASKET_PARTNER	GROUPTYPEBP	TB025	PARTGRPTYP		1	CN
4	CRM_ISU_BASKET_PARTNER	INDUSTRYSECTORBP	TB023	IND_SECTOR	REF	1	CN
5	CRM_ISU_BASKET_PARTNER	LEGALFORMBP	TB019	LEGAL_ENTY	KEY	1	CN
6	CRM_ISU_BASKET_PARTNER	MARITALSTATUSBP	TB027	MARST		1	CN
7	CRM_ISU_BASKET_PARTNER	NAMCOUNTRYBP	T005	LAND1	REF	C	CN
8	CRM_ISU_BASKET_PARTNER	NAMEFORMATBP	T005N	NAMEFORMAT	REF	C	CN
9	CRM_ISU_BASKET_PARTNER	PARTNERLANGUAGEBP	T002	SPRAS	REF	1	CN
10	CRM_ISU_BASKET_PARTNER	PARTNERTYPEBP	TB004	BPKIND	REF	1	CN
11	CRM_ISU_BASKET_PARTNER	PREFIX1BP	TSAD4	PREFIX_KEY
12	CRM_ISU_BASKET_PARTNER	PREFIX2BP	TSAD4	PREFIX_KEY
13	CRM_ISU_BASKET_PARTNER	TITLE_ACA1BP	TSAD2	TITLE_KEY
14	CRM_ISU_BASKET_PARTNER	TITLE_ACA2BP	TSAD2	TITLE_KEY
15	CRM_ISU_BASKET_PARTNER	TITLE_KEYBP	TSAD3	TITLE	REF
16	CRM_ISU_BASKET_PARTNER	TITLE_SPPLBP	TSAD5	TITLE_KEY

History

Last changed by/on	SAP	20140117
SAP Release Created in	701