The ELACCZ table in SAP ERP or S/4HANA stores Loyalty Account Line Item data. There are total 23 fields in ELACCZ table. The Loyalty Account Line Item table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ELACCZ table. It is in IS-U Master Data (EE01) ABAP package and is part of the Master Data (IS-U-MD) module.
SAP ELACCZ Table Fields
Following is the list of fields that are available in SAP ELACCZ table. The primary key fields of the table are MANDT (Client), VKONT (Contract Account Number), LP_CODE (Loyalty program code), LP_ACCLNBR (Consecutive Number for Loyalty Account Item).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| VKONT | Contract Account Number | VKONT_KK | FKKVK | CHAR (12) |
| LP_CODE | Loyalty program code | LP_CODE | ELOYALPRG | CHAR (10) |
| LP_ACCLNBR | Consecutive Number for Loyalty Account Item | LP_ACCLNBR | NUMC (6) | |
| LP_CDFL | Credit/Debit for Loyalty Account Line Item | LP_CDFL | CHAR (2) | |
| LP_RDMFL | Redemption/Allocation Line | LP_RDMFL | CHAR (1) | |
| LP_CANCFL | Cancellation indicator | LP_CANCFL | CHAR (1) | |
| LP_ACCLN_PT | Points at line item level | LP_ACCLN_PT | DEC (10) | |
| LP_CRT_DATE | Line Item Creation Date | LP_CRT_DATE | DATS (8) | |
| LP_REFOBJTYP | Object Type | SWO_OBJTYP | TOJTB | CHAR (10) |
| LP_REFOBJNBR | Key field | SWO_KEYFLD | CHAR (32) | |
| LP_RDMNBR | Redemption Document Number for Loyalty Account | LP_RDMNBR | * | CHAR (12) |
| ALT_VKONT | Contract Account Number | VKONT_KK | FKKVK | CHAR (12) |
| ALT_LP_CODE | Loyalty program code | LP_CODE | ELOYALPRG | CHAR (10) |
| VERTRAG | Contract | VERTRAG | EVER | CHAR (10) |
| BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| SPARTE | Division | SPARTE | TSPA | CHAR (2) |
| PARTNER | Business Partner Number | BU_PARTNER | BUT000 | CHAR (10) |
| LP_PTEXP_DATE | Point expiration date | LP_PTEXP_DATE | DATS (8) | |
| LP_EVENT | Business Event | LP_EVENT | * | CHAR (10) |
| LP_CRMD | Loyalty Account Line Item Creation Mode | LP_CRMD | CHAR (1) | |
| LP_UNIT | Unit of Measurement | E_MASS | * | UNIT (3) |
| LP_RWRD | Reward Code | LP_RWRD | EREWARD | CHAR (10) |
