The ESCHS table in SAP ERP or S/4HANA stores Billing Schema Steps data. There are total 51 fields in ESCHS table. The Billing Schema Steps 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 ESCHS table. It is in IS-U: Billing (EE20) ABAP package and is part of the Contract Billing (IS-U-BI) module.
SAP ESCHS Table Fields
Following is the list of fields that are available in SAP ESCHS table. The primary key fields of the table are MANDT (Client), SCHEMANR (Number of the billing schema), SNO (Sequence number of schema step in billing schema).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| SCHEMANR | Number of the billing schema | SCHEMANR | ESCH | CHAR (10) |
| SNO | Sequence number of schema step in billing schema | SNO | NUMC (4) | |
| LRATESTEP | Logical Number of Rate Step | LRATESTEP | ETRFV | NUMC (10) |
| TARIFNR | Rate key | TARIFNR | ETRF | CHAR (10) |
| STEPINACT | Indicator: schema step not active | STEPINACT | CHAR (1) | |
| BUCHREL | Billing Line Item Relevant to Posting | BUCHREL | CHAR (1) | |
| BETRSTREL | Amount of billing line item is statistically relevant | BETRSTREL | CHAR (1) | |
| MENGESTREL | Quantity (billed value) is statistically relevant | MENGESTREL | CHAR (1) | |
| STGRAMT | Amount statistics group | STGRAMT | TE541 | CHAR (6) |
| STGRQNT | Quantity statistics group | STGRQNT | TE540 | CHAR (6) |
| ERCHV_BW_REL | Not Relevant for Consumption History in BW | ERCHV_BW_REL | CHAR (1) | |
| DISCON_FREE | Disconnection Periods Not Valuated | DISCON_FREE | CHAR (1) | |
| PREISZUS | Indicator: Price Summary | PREISZUS | CHAR (4) | |
| GROSSGROUP | Gross group | GROSSGROUP | CHAR (4) | |
| GROSSPRICE | Gross Price | GROSSPRICE | CHAR (1) | |
| BRUTTOZEILE | Blling line item is a gross line item | BRUTTOZEILE | CHAR (1) | |
| TAXGROUP | Categorize Amounts for Tax Determination | TAXGROUP | CHAR (4) | |
| LINE_CLASS | Classification Criteria for Billing Line | LINE_CLASS | TE552 | CHAR (4) |
| LINESORT1 | Presorting of billing line items in billing schema | LINESORT1 | TE530 | CHAR (4) |
| LINESORT2 | Presorting of billing line items in billing schema | LINESORT2 | TE530 | CHAR (4) |
| LINESORT3 | Presorting of billing line items in billing schema | LINESORT3 | TE530 | CHAR (4) |
| LINESORT4 | Presorting of billing line items in billing schema | LINESORT4 | TE530 | CHAR (4) |
| LINESORT5 | Presorting of billing line items in billing schema | LINESORT5 | TE530 | CHAR (4) |
| BACKSTART | Indicator: execute backbilling | BACKSTART | TE301 | CHAR (4) |
| BACKONLY | Indicator: execute schema step for backbilling only | BACKONLY | CHAR (1) | |
| BACKEXEC01 | Indicator: Allocate Backbilling | BACKEXEC01 | TE301 | CHAR (4) |
| BACKEXEC02 | Indicator: allocate backbilling | BACKEXEC02 | TE301 | CHAR (4) |
| BACKEXEC03 | Indicator: allocate backbilling | BACKEXEC03 | TE301 | CHAR (4) |
| BACKEXEC04 | Indicator: allocate backbilling | BACKEXEC04 | TE301 | CHAR (4) |
| BACKEXEC05 | Indicator: allocate backbilling | BACKEXEC05 | TE301 | CHAR (4) |
| BACKCANC01 | Indicator: reverse backbilling | BACKCANC01 | TE301 | CHAR (4) |
| BACKCANC02 | Indicator: reverse backbilling | BACKCANC02 | TE301 | CHAR (4) |
| BACKCANC03 | Indicator: reverse backbilling | BACKCANC03 | TE301 | CHAR (4) |
| BACKCANC04 | Indicator: reverse backbilling | BACKCANC04 | TE301 | CHAR (4) |
| BACKCANC05 | Indicator: reverse backbilling | BACKCANC05 | TE301 | CHAR (4) |
| DYNSTART | Execute dynamic period control | DYNSTART | TE659 | CHAR (4) |
| DYNEXEC01 | Schema step for execution in dynamic period control 1 | DYNEXEC01 | TE659 | CHAR (4) |
| DYNEXEC02 | Schema step for execution in dyn. period control 2 | DYNEXEC02 | TE659 | CHAR (4) |
| DYNEXEC03 | Schema step for execution in dyn. period control 3 | DYNEXEC03 | TE659 | CHAR (4) |
| DYNEXEC04 | Schema step for execution in dyn. period control 4 | DYNEXEC04 | TE659 | CHAR (4) |
| DYNEXEC05 | Schema step for execution in dyn. period control 5 | DYNEXEC05 | TE659 | CHAR (4) |
| DYNCANC01 | Schema steps for reversal in dynamic period control 1 | DYNCANC01 | TE659 | CHAR (4) |
| DYNCANC02 | Reversal indicator, dynamic period control 2 | DYNCANC02 | TE659 | CHAR (4) |
| DYNCANC03 | Reversal indicator, dynamic period control 3 | DYNCANC03 | TE659 | CHAR (4) |
| DYNCANC04 | Reversal Indicator, Dynamic Period Control 4 | DYNCANC04 | TE659 | CHAR (4) |
| DYNCANC05 | Reversal indicator, dynamic period control 5 | DYNCANC05 | TE659 | CHAR (4) |
| TIMESLICEGEN | Time slice generator | TIMESLICEGEN | TE543 | CHAR (4) |
| BBINFOLINES | Write Info Lines for Backbilling | BBINFOLINES | CHAR (1) | |
| DELOPERAND | Deletion operand | DELOPERAND | TE221 | CHAR (10) |
| ADVCONTROL | Control of Advance Billing | ADVCONTROL | CHAR (1) |
