SAP ABAP Table ELACCZ (Loyalty Account Line Item)

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	TRANSP	Transparent table
Transparent table	ELACCZ	Table Relationship Diagram
Short Description	Loyalty Account Line Item

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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 Line Item: Key
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	LP_ACCLNBR	☑	LP_ACCLNBR	LFDNR6	NUMC	6	0	Consecutive Number for Loyalty Account Item
7	.INCLUDE	☐				0	0	Loyalty Account: Data Fields (Without Key)
8	.INCLUDE	☐				0	0	Loyalty Account Line Item: Data Fields (Without Key)
9	LP_CDFL	☐	LP_CDFL	LP_CDFL	CHAR	2	0	Credit/Debit for Loyalty Account Line Item
10	LP_RDMFL	☐	LP_RDMFL	LP_RDMFL	CHAR	1	0	Redemption/Allocation Line
11	LP_CANCFL	☐	LP_CANCFL	LP_CANCFL	CHAR	1	0	Cancellation indicator
12	LP_ACCLN_PT	☐	LP_ACCLN_PT	LP_POINT10	DEC	10	0	Points at line item level
13	LP_CRT_DATE	☐	LP_CRT_DATE	DATUM	DATS	8	0	Line Item Creation Date
14	LP_REFOBJTYP	☐	SWO_OBJTYP	OJ_NAME	CHAR	10	0	Object Type	TOJTB
15	LP_REFOBJNBR	☐	SWO_KEYFLD	SWC_ELEM	CHAR	32	0	Key field
16	LP_RDMNBR	☐	LP_RDMNBR	LP_RDMNBR	CHAR	12	0	Redemption Document Number for Loyalty Account	*
17	ALT_VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	FKKVK
18	ALT_LP_CODE	☐	LP_CODE	LP_CODE	CHAR	10	0	Loyalty program code	ELOYALPRG
19	VERTRAG	☐	VERTRAG	VERTRAG	CHAR	10	0	Contract	EVER
20	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
21	SPARTE	☐	SPARTE	SPART	CHAR	2	0	Division	TSPA
22	PARTNER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
23	LP_PTEXP_DATE	☐	LP_PTEXP_DATE	DATUM	DATS	8	0	Point expiration date
24	LP_EVENT	☐	LP_EVENT	LP_EVENT	CHAR	10	0	Business Event	*
25	LP_CRMD	☐	LP_CRMD	LP_CRMD	CHAR	1	0	Loyalty Account Line Item Creation Mode
26	LP_UNIT	☐	E_MASS	MEINS	UNIT	3	0	Unit of Measurement	*
27	LP_RWRD	☐	LP_RWRD	LP_RWRD	CHAR	10	0	Reward Code	EREWARD
28	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ELACCZ	ALT_LP_CODE	ELOYALPRG	LP_CODE	REF
2	ELACCZ	ALT_VKONT	FKKVK	VKONT	REF
3	ELACCZ	BUKRS	T001	BUKRS
4	ELACCZ	LP_CODE	ELOYALPRG	LP_CODE	KEY
5	ELACCZ	LP_REFOBJTYP	TOJTB	NAME
6	ELACCZ	LP_RWRD	EREWARD	LP_RWRD	REF
7	ELACCZ	MANDT	T000	MANDT
8	ELACCZ	PARTNER	BUT000	PARTNER	REF
9	ELACCZ	SPARTE	TSPA	SPART
10	ELACCZ	VERTRAG	EVER	VERTRAG	REF
11	ELACCZ	VKONT	FKKVK	VKONT	KEY

History

Last changed by/on	SAP	20110901
SAP Release Created in