SAP ABAP Table LOYS_MSH_MEMB_DETAIL (Loyalty Membership Details with address data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOY (Application Component) Loyalty
     ⤷ LOY_ESOA (Package) ESOA enablement for Loyalty Management

Basic Data

Table Category	INTTAB	Structure
Structure	LOYS_MSH_MEMB_DETAIL	Table Relationship Diagram
Short Description	Loyalty Membership Details with address data

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	MEMB_ID	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
2	MC_NAME1	☐	BU_MCNAME1	CHAR35	CHAR	35	0	Search Help Field 1 (Name 1/Last Name)
3	MC_NAME2	☐	BU_MCNAME2	CHAR35	CHAR	35	0	Search Help Field 2 (Name 2/First Name)
4	MAIN_MEMBER	☐			CHAR	1	0
5	START_DATE	☐	LOY_MSH_MS_MEMB_DATE	DATS	DATS	8	0	Link Object Date Element
6	END_DATE	☐	LOY_MSH_MS_MEMB_DATE	DATS	DATS	8	0	Link Object Date Element
7	STREET_NAME	☐	AD_STREET	TEXT60	CHAR	60	0	Street
8	CITY_NAME	☐	AD_CITY1	TEXT40	CHAR	40	0	City
9	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
10	REGION_NAME	☐	BEZEI20	TEXT20	CHAR	20	0	Description
11	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
12	COUNTRY_NAME	☐	LANDX50	TEXT50	CHAR	50	0	Country Name (Max. 50 Characters)
13	POSTAL_CODE	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
14	EMAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
15	PHONE	☐	AD_TELNRCL	CHAR30	CHAR	30	0	Telephone number for determining caller
16	EXTENSION_ID	☐	AD_TLXTNS	CHAR10	CHAR	10	0	Telephone no.: Extension
17	COUNTRY_CODE	☐	AD_COMCTRY	LAND1	CHAR	3	0	Country for telephone/fax number	*
18	TEL_COUNTRY_NAME	☐	LANDX50	TEXT50	CHAR	50	0	Country Name (Max. 50 Characters)
19	AREA_ID	☐	SP_TELNO	TDTELENUM	CHAR	30	0	Telephone number
20	COUNTRY_DIALLING_CODE	☐	SKTELFTO	CHAR4	CHAR	4	0	Country telephone/fax dialling code
21	LANGUAGE	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
22	NAME	☐	BU_NAME1TX	TEXT80	CHAR	80	0	Full Name

History

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