SAP ABAP Table ELACCD (Screen fields: Loyalty Account)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-MD (Application Component) Master Data
     ⤷ EE01 (Package) IS-U Master Data

Basic Data

Table Category	INTTAB	Structure
Structure	ELACCD	Table Relationship Diagram
Short Description	Screen fields: Loyalty Account

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 Account Header
2	.INCLUDE	☐				0	0	Loyalty Account: Key Field
3	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
4	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	FKKVK
5	LP_CODE	☐	LP_CODE	LP_CODE	CHAR	10	0	Loyalty program code	ELOYALPRG
6	.INCLUDE	☐				0	0	Loyalty Account: Data Fields (Without Key)
7	.INCLUDE	☐				0	0	Loyalty Account: Data Fields (Without Key)
8	BU_PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
9	LP_SDATE	☐	LP_SDATE	DATUM	DATS	8	0	Loyalty Program Start Date
10	LP_EDATE	☐	LP_EDATE	DATUM	DATS	8	0	Loyalty Program End Date
11	LP_TOTPT	☐	LP_TOTPT	LP_POINT16	DEC	16	0	Total Points
12	LP_REORG_TOTPT	☐	LP_REORG_TOTPT	LP_POINT16	DEC	16	0	Reorganized Total Points
13	.INCLUDE	☐				0	0
14	.INCLUDE	☐				0	0	Creation and Change Data (Author, Group and Deletion Flag)
15	.INCLUDE	☐				0	0	Creation and Change Data
16	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
17	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
18	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
19	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
20	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
21	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
22	.INCLUDE	☐				0	0	Loyalty Account: Data Fields (Without Key)
23	.INCLUDE	☐				0	0	Loyalty Account Line Item: Data Fields (Without Key)
24	LP_CDFL	☐	LP_CDFL	LP_CDFL	CHAR	2	0	Credit/Debit for Loyalty Account Line Item
25	LP_RDMFL	☐	LP_RDMFL	LP_RDMFL	CHAR	1	0	Redemption/Allocation Line
26	LP_CANCFL	☐	LP_CANCFL	LP_CANCFL	CHAR	1	0	Cancellation indicator
27	LP_ACCLN_PT	☐	LP_ACCLN_PT	LP_POINT10	DEC	10	0	Points at line item level
28	LP_CRT_DATE	☐	LP_CRT_DATE	DATUM	DATS	8	0	Line Item Creation Date
29	LP_REFOBJTYP	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	*
30	LP_REFOBJNBR	☐	SWO_KEYFLD	SWC_ELEM	CHAR	32	0	Key field
31	LP_RDMNBR	☐	LP_RDMNBR	LP_RDMNBR	CHAR	12	0	Redemption Document Number for Loyalty Account	*
32	ALT_VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	*
33	ALT_LP_CODE	☐	LP_CODE	LP_CODE	CHAR	10	0	Loyalty program code	*
34	VERTRAG	☐	VERTRAG	VERTRAG	CHAR	10	0	Contract	*
35	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
36	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	*
37	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
38	LP_PTEXP_DATE	☐	LP_PTEXP_DATE	DATUM	DATS	8	0	Point expiration date
39	LP_EVENT	☐	LP_EVENT	LP_EVENT	CHAR	10	0	Business Event	*
40	LP_CRMD	☐	LP_CRMD	LP_CRMD	CHAR	1	0	Loyalty Account Line Item Creation Mode
41	LP_UNIT	☐	E_MASS	MEINS	UNIT	3	0	Unit of Measurement	*
42	LP_RWRD	☐	LP_RWRD	LP_RWRD	CHAR	10	0	Reward Code	*
43	.INCLUDE	☐				0	0
44	LP_ACCLNBR	☐	LP_ACCLNBR	LFDNR6	NUMC	6	0	Consecutive Number for Loyalty Account Item
45	PARTNAME	☐	TEXT1GP_KK	TEXT132	CHAR	132	0	Text for business partner
46	LPDESC	☐	LP_TXT	TEXT40	CHAR	40	0	Loyalty Program Description
47	LP_EVENTT	☐	LP_EVENTT	TEXT40	CHAR	40	0	Business Event Description
48	ACCNAME	☐	VKBEZ_KK	TEXT35	CHAR	35	0	Contract account name
49	SELECTED	☐	E_SELECTED	KENNZX	CHAR	1	0	Entry selected
50	TABTOT	☐	LP_TOTPT	LP_POINT16	DEC	16	0	Total Points
51	LP_RWRDTT	☐	LP_RWRDTT	TEXT40	CHAR	40	0	Reward Description
52	TOTPT_TXT	☐	LP_CDFL_TXT	LP_CDFL_TXT	CHAR	2	0	Text for Debit/Credit
53	TABPT_TXT	☐	LP_CDFL_TXT	LP_CDFL_TXT	CHAR	2	0	Text for Debit/Credit

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ELACCD	BU_PARTNER	BUT000	PARTNER	REF
2	ELACCD	LP_CODE	ELOYALPRG	LP_CODE	KEY
3	ELACCD	MANDT	T000	MANDT
4	ELACCD	VKONT	FKKVK	VKONT	KEY

History

Last changed by/on	SAP	20110901
SAP Release Created in