SAP ABAP Table CRMS_BSP_SUMMARY_CHM_RELPARTN (Summary Page - Related Channel Partner)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-CHM (Application Component) Channel Management
     ⤷ CRM_BSP_CHP_SUMMARY_PAGE_API (Package) APIs for Data Procurement

Basic Data

Table Category	INTTAB	Structure
Structure	CRMS_BSP_SUMMARY_CHM_RELPARTN	Table Relationship Diagram
Short Description	Summary Page - Related Channel Partner

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	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	LINE_KEY	☐	CRMT_FS_LINE_KEY		CHAR	32	0	Line ID in table used for reference between tables
3	.INCLUDE	☐				0	0	Internet Sales: General Titles
4	TITLE_KEY	☐	AD_TITLE	AD_TITLE	CHAR	4	0	Form-of-Address Key	*
5	TITLE	☐	AD_TITLETX	TEXT30	CHAR	30	0	Title text
6	.INCLUDE	☐				0	0	Internet Sales: Special Person-Related Titles
7	TITLE_ACA1_KEY	☐	AD_TITLE1	AD_TITLE1	CHAR	4	0	Academic Title: Key	*
8	TITLE_ACA1	☐	AD_TITLE1T	TEXT20	CHAR	20	0	Academic Title: Written Form
9	.INCLUDE	☐				0	0	Internet Sales: Name Fields for a Person
10	FIRSTNAME	☐	BU_NAMEP_F	BU_NAME	CHAR	40	0	First name of business partner (person)
11	LASTNAME	☐	BU_NAMEP_L	BU_NAME	CHAR	40	0	Last name of business partner (person)
12	BIRTHNAME	☐	BU_BIRTHNM	BU_NAME	CHAR	40	0	Name at birth of business partner
13	SECONDNAME	☐	BU_NAMEPL2	BU_NAME	CHAR	40	0	Other Last Name of a Person
14	MIDDLENAME	☐	BU_NAMEMID	BU_NAME	CHAR	40	0	Middle name or second forename of a person
15	NICKNAME	☐	BU_NICKNAM	BU_NAME	CHAR	40	0	Nickname of Business Partner (Person)
16	INITIALS	☐	AD_INITS	CHAR10	CHAR	10	0	"Middle Initial" or personal initials
17	.INCLUDE	☐				0	0	Internet Sales: Postal Address
18	C_O_NAME	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
19	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
20	DISTRICT	☐	AD_CITY2	TEXT40	CHAR	40	0	District
21	POSTL_COD1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
22	POSTL_COD2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
23	POSTL_COD3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
24	PCODE1_EXT	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
25	PCODE2_EXT	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
26	PCODE3_EXT	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
27	PO_BOX	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
28	PO_W_O_NO	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
29	PO_BOX_CIT	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
30	PO_BOX_REG	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	*
31	POBOX_CTRY	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	*
32	PO_CTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
33	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
34	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
35	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
36	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
37	LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
38	HOUSE_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
39	HOUSE_NO2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
40	HOUSE_NO3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
41	BUILDING	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
42	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
43	ROOM_NO	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
44	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
45	COUNTRYISO	☐	INTCA	INTCA	CHAR	2	0	Country ISO code
46	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
47	HOME_CITY	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
48	TAXJURCODE	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
49	TEL1_NUMBR	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
50	TEL1_EXT	☐	AD_TLXTNS1	CHAR10	CHAR	10	0	First Telephone No.: Extension
51	FAX_NUMBER	☐	AD_FXNMBR1	CHAR30	CHAR	30	0	First fax no.: dialling code+number
52	FAX_EXTENS	☐	AD_FXXTNS1	CHAR10	CHAR	10	0	First fax no.: extension
53	E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
54	COUNTRYTEXT	☐	BEZEI20	TEXT20	CHAR	20	0	Description
55	REGIONTEXT50	☐	LANDX50	TEXT50	CHAR	50	0	Country Name (Max. 50 Characters)
56	REGIONTEXT15	☐	LANDX	TEXT15	CHAR	15	0	Country Name
57	DATE_TO	☐	CRMT_FS_CHM_VALID_TO	CRM_FS_DATE_TEXT	CHAR	19	0	Fact Sheet: Valid to
58	DATE_FROM	☐	CRMT_FS_CHM_VALID_FROM	CRM_FS_DATE_TEXT	CHAR	19	0	Fact Sheet: Valid from
59	BPARTNER	☐	CRMT_FS_PARTNERID	TEXT10	CHAR	10	0	Fact Sheet: Partner ID
60	BPARTNER_GUID	☐	BU_PARTNER_GUID_BAPI	SYSUUID_C	CHAR	32	0	GUID of a Business Partner in CHAR 32 Format for BAPIs
61	NAME1	☐	CRMT_FS_NAME	BU_NAME	CHAR	40	0	Fact Sheet: Name
62	NAME2	☐	BU_NAMEOR2	BU_NAME	CHAR	40	0	Name 2 of organization
63	NAME3	☐	BU_NAMEOR3	BU_NAME	CHAR	40	0	Name 3 of organization
64	NAME4	☐	BU_NAMEOR4	BU_NAME	CHAR	40	0	Name 4 of organization

History

Last changed by/on	SAP	20130604
SAP Release Created in	500