The EKON table in SAP ERP or S/4HANA stores Franchise Contract MasterData data. There are total 25 fields in EKON table. The Franchise Contract MasterData 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 EKON table. It is in IS-U Master Data (EE01) ABAP package and is part of the Master Data (IS-U-MD) module.
SAP EKON Table Fields
Following is the list of fields that are available in SAP EKON table. The primary key fields of the table are MANDT (Client), KONZVER (Franchise contract).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| KONZVER | Franchise contract | KONZVER | CHAR (10) | |
| BUKRS | Company Code | BUKRS | T001 | CHAR (4) |
| SPARTE | Division | SPARTE | TSPA | CHAR (2) |
| KUNDE | Business Partner Number | BU_PARTNER | BUT000 | CHAR (10) |
| KAVERF | Franchise Fee Procedure | KAVERF | CHAR (1) | |
| KAVERF_EA16 | Franchise Fee Procedure | KAVERF | CHAR (1) | |
| BEARKZ | Processing status | BEARKZ | TE643 | CHAR (2) |
| VERTART | Franchise contract type | VERTART | TE645 | CHAR (4) |
| VERLZEIT | Renewal date of franchise tax contract | VERLZEIT | DATS (8) | |
| VERWGEM | Administrative community | VERWGEM | CHAR (20) | |
| ERDAT | Date on which the record was created | ERDAT | DATS (8) | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR (12) | |
| AEDAT | Date of Last Change | AEDAT | DATS (8) | |
| AENAM | Name of person who changed object | AENAM | CHAR (12) | |
| BEGRU | Authorization Group | BEGRU | CHAR (4) | |
| LOEVM | Deletion Indicator | LOEVM | CHAR (1) | |
| VBEGINN | Start of contract | E_VBEGINN | DATS (8) | |
| VENDE | End of contract | E_VENDE | DATS (8) | |
| VERLDAT | Renewal date of contract | E_VBISDAT | DATS (8) | |
| KUENDAT | Cancellation date of contract | KUENDAT | DATS (8) | |
| ANZVERL | Number of time units for renewal | VERZEIT | NUMC (3) | |
| VERLEINH | Time unit for renewal | VERPER | CHAR (1) | |
| ANZKUEN | Number of time units for cancellation | KUENZEIT | NUMC (3) | |
| KUENEINH | Time unit for cancellation | KUENPER | CHAR (1) |
