SAP ABAP Table LOYS_MEMB_DETAIL (Member structure)

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_MEMB_DETAIL	Table Relationship Diagram
Short Description	Member structure

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

History

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