1. Home
  2. Resources
  3. SAP Tables
  4. ESCHS - Billing Schema Steps

SAP Table ESCHS

Billing Schema Steps

ESCHS (Billing Schema Steps) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ESCHS to other SAP tables.

ESCHS table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SCHEMANR Number of the billing schema SCHEMANR ESCH CHAR 10 0
SNO Sequence number of schema step in billing schema SNO NUMC 4 0
LRATESTEP Logical Number of Rate Step LRATESTEP ETRFV NUMC 10 0
TARIFNR Rate key TARIFNR ETRF CHAR 10 0
STEPINACT Indicator: schema step not active STEPINACT CHAR 1 0
NULL Step is active
X Step is inactive
BUCHREL Billing Line Item Relevant to Posting BUCHREL CHAR 1 0
NULL Field inactive
X Field active
BETRSTREL Amount of billing line item is statistically relevant BETRSTREL CHAR 1 0
NULL Field inactive
X Field active
MENGESTREL Quantity (billed value) is statistically relevant MENGESTREL CHAR 1 0
NULL Billed quantity is not statistically relevant
X Billed quantity is statistically relevant
STGRAMT Amount statistics group STGRAMT TE541 CHAR 6 0
STGRQNT Quantity statistics group STGRQNT TE540 CHAR 6 0
ERCHV_BW_REL Not Relevant for Consumption History in BW ERCHV_BW_REL CHAR 1 0
NULL Field inactive
X Field active
DISCON_FREE Disconnection Periods Not Valuated DISCON_FREE CHAR 1 0
NULL Field inactive
X Field active
PREISZUS Indicator: Price Summary PREISZUS CHAR 4 0
GROSSGROUP Gross group GROSSGROUP CHAR 4 0
GROSSPRICE Gross Price GROSSPRICE CHAR 1 0
NULL Field inactive
X Field active
BRUTTOZEILE Blling line item is a gross line item BRUTTOZEILE CHAR 1 0
NULL Field inactive
X Field active
TAXGROUP Categorize Amounts for Tax Determination TAXGROUP CHAR 4 0
LINE_CLASS Classification Criteria for Billing Line LINE_CLASS TE552 CHAR 4 0
LINESORT1 Presorting of billing line items in billing schema LINESORT1 TE530 CHAR 4 0
LINESORT2 Presorting of billing line items in billing schema LINESORT2 TE530 CHAR 4 0
LINESORT3 Presorting of billing line items in billing schema LINESORT3 TE530 CHAR 4 0
LINESORT4 Presorting of billing line items in billing schema LINESORT4 TE530 CHAR 4 0
LINESORT5 Presorting of billing line items in billing schema LINESORT5 TE530 CHAR 4 0
BACKSTART Indicator: execute backbilling BACKSTART TE301 CHAR 4 0
BACKONLY Indicator: execute schema step for backbilling only BACKONLY CHAR 1 0
BACKEXEC01 Indicator: Allocate Backbilling BACKEXEC01 TE301 CHAR 4 0
BACKEXEC02 Indicator: allocate backbilling BACKEXEC02 TE301 CHAR 4 0
BACKEXEC03 Indicator: allocate backbilling BACKEXEC03 TE301 CHAR 4 0
BACKEXEC04 Indicator: allocate backbilling BACKEXEC04 TE301 CHAR 4 0
BACKEXEC05 Indicator: allocate backbilling BACKEXEC05 TE301 CHAR 4 0
BACKCANC01 Indicator: reverse backbilling BACKCANC01 TE301 CHAR 4 0
BACKCANC02 Indicator: reverse backbilling BACKCANC02 TE301 CHAR 4 0
BACKCANC03 Indicator: reverse backbilling BACKCANC03 TE301 CHAR 4 0
BACKCANC04 Indicator: reverse backbilling BACKCANC04 TE301 CHAR 4 0
BACKCANC05 Indicator: reverse backbilling BACKCANC05 TE301 CHAR 4 0
DYNSTART Execute dynamic period control DYNSTART TE659 CHAR 4 0
DYNEXEC01 Schema step for execution in dynamic period control 1 DYNEXEC01 TE659 CHAR 4 0
DYNEXEC02 Schema step for execution in dyn. period control 2 DYNEXEC02 TE659 CHAR 4 0
DYNEXEC03 Schema step for execution in dyn. period control 3 DYNEXEC03 TE659 CHAR 4 0
DYNEXEC04 Schema step for execution in dyn. period control 4 DYNEXEC04 TE659 CHAR 4 0
DYNEXEC05 Schema step for execution in dyn. period control 5 DYNEXEC05 TE659 CHAR 4 0
DYNCANC01 Schema steps for reversal in dynamic period control 1 DYNCANC01 TE659 CHAR 4 0
DYNCANC02 Reversal indicator, dynamic period control 2 DYNCANC02 TE659 CHAR 4 0
DYNCANC03 Reversal indicator, dynamic period control 3 DYNCANC03 TE659 CHAR 4 0
DYNCANC04 Reversal Indicator, Dynamic Period Control 4 DYNCANC04 TE659 CHAR 4 0
DYNCANC05 Reversal indicator, dynamic period control 5 DYNCANC05 TE659 CHAR 4 0
TIMESLICEGEN Time slice generator TIMESLICEGEN TE543 CHAR 4 0
BBINFOLINES Write Info Lines for Backbilling BBINFOLINES CHAR 1 0
NULL Field inactive
X Field active
DELOPERAND Deletion operand DELOPERAND TE221 CHAR 10 0
ADVCONTROL Control of Advance Billing ADVCONTROL CHAR 1 0
NULL Schema step performed in periodic billing period
1 Schema step performed in advance billing period
2 Schema step performed in periodic and advance billing period

ESCHS foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ESCHS BACKCANC01 ESCHD MANDT TE301 Backbilling Groups MANDT
ESCHS BACKCANC01 ESCHS BACKCANC01 TE301 Backbilling Groups BACKGROUP
ESCHS BACKCANC02 ESCHS BACKCANC02 TE301 Backbilling Groups BACKGROUP
ESCHS BACKCANC02 ESCHD MANDT TE301 Backbilling Groups MANDT
ESCHS BACKCANC03 ESCHD MANDT TE301 Backbilling Groups MANDT
ESCHS BACKCANC03 ESCHS BACKCANC03 TE301 Backbilling Groups BACKGROUP
ESCHS BACKCANC04 ESCHD MANDT TE301 Backbilling Groups MANDT
ESCHS BACKCANC04 ESCHS BACKCANC04 TE301 Backbilling Groups BACKGROUP
ESCHS BACKCANC05 ESCHS BACKCANC05 TE301 Backbilling Groups BACKGROUP
ESCHS BACKCANC05 ESCHD MANDT TE301 Backbilling Groups MANDT
ESCHS BACKEXEC01 ESCHD MANDT TE301 Backbilling Groups MANDT
ESCHS BACKEXEC01 ESCHS BACKEXEC01 TE301 Backbilling Groups BACKGROUP
ESCHS BACKEXEC02 ESCHD MANDT TE301 Backbilling Groups MANDT
ESCHS BACKEXEC02 ESCHS BACKEXEC02 TE301 Backbilling Groups BACKGROUP
ESCHS BACKEXEC03 ESCHD MANDT TE301 Backbilling Groups MANDT
ESCHS BACKEXEC03 ESCHS BACKEXEC03 TE301 Backbilling Groups BACKGROUP
ESCHS BACKEXEC04 ESCHD MANDT TE301 Backbilling Groups MANDT
ESCHS BACKEXEC04 ESCHS BACKEXEC04 TE301 Backbilling Groups BACKGROUP
ESCHS BACKEXEC05 ESCHS BACKEXEC05 TE301 Backbilling Groups BACKGROUP
ESCHS BACKEXEC05 ESCHD MANDT TE301 Backbilling Groups MANDT
ESCHS BACKSTART ESCHD MANDT TE301 Backbilling Groups MANDT
ESCHS BACKSTART ESCHS BACKSTART TE301 Backbilling Groups BACKGROUP
ESCHS DELOPERAND SY MANDT TE221 Operands MANDT
ESCHS DELOPERAND ESCHS DELOPERAND TE221 Operands OPERAND
ESCHS DYNCANC01 ESCHS DYNCANC01 TE659 Dynamic backbilling groups DYNGROUP
ESCHS DYNCANC01 SYST MANDT TE659 Dynamic backbilling groups MANDT
ESCHS DYNCANC02 SYST MANDT TE659 Dynamic backbilling groups MANDT
ESCHS DYNCANC02 ESCHS DYNCANC02 TE659 Dynamic backbilling groups DYNGROUP
ESCHS DYNCANC03 SYST MANDT TE659 Dynamic backbilling groups MANDT
ESCHS DYNCANC03 ESCHS DYNCANC03 TE659 Dynamic backbilling groups DYNGROUP
ESCHS DYNCANC04 SYST MANDT TE659 Dynamic backbilling groups MANDT
ESCHS DYNCANC04 ESCHS DYNCANC04 TE659 Dynamic backbilling groups DYNGROUP
ESCHS DYNCANC05 SYST MANDT TE659 Dynamic backbilling groups MANDT
ESCHS DYNCANC05 ESCHS DYNCANC05 TE659 Dynamic backbilling groups DYNGROUP
ESCHS DYNEXEC01 ESCHS DYNEXEC01 TE659 Dynamic backbilling groups DYNGROUP
ESCHS DYNEXEC01 SYST MANDT TE659 Dynamic backbilling groups MANDT
ESCHS DYNEXEC02 SYST MANDT TE659 Dynamic backbilling groups MANDT
ESCHS DYNEXEC02 ESCHS DYNEXEC02 TE659 Dynamic backbilling groups DYNGROUP
ESCHS DYNEXEC03 SYST MANDT TE659 Dynamic backbilling groups MANDT
ESCHS DYNEXEC03 ESCHS DYNEXEC03 TE659 Dynamic backbilling groups DYNGROUP
ESCHS DYNEXEC04 ESCHS DYNEXEC04 TE659 Dynamic backbilling groups DYNGROUP
ESCHS DYNEXEC04 SYST MANDT TE659 Dynamic backbilling groups MANDT
ESCHS DYNEXEC05 SYST MANDT TE659 Dynamic backbilling groups MANDT
ESCHS DYNEXEC05 ESCHS DYNEXEC05 TE659 Dynamic backbilling groups DYNGROUP
ESCHS DYNSTART SYST MANDT TE659 Dynamic backbilling groups MANDT
ESCHS DYNSTART ESCHS DYNSTART TE659 Dynamic backbilling groups DYNGROUP
ESCHS LINESORT1 SY MANDT TE530 Sort Criteria for Bill Printout MANDT
ESCHS LINESORT1 ESCHS LINESORT1 TE530 Sort Criteria for Bill Printout LINESORT
ESCHS LINESORT2 ESCHS LINESORT2 TE530 Sort Criteria for Bill Printout LINESORT
ESCHS LINESORT2 ESCHD MANDT TE530 Sort Criteria for Bill Printout MANDT
ESCHS LINESORT3 ESCHD MANDT TE530 Sort Criteria for Bill Printout MANDT
ESCHS LINESORT3 ESCHS LINESORT3 TE530 Sort Criteria for Bill Printout LINESORT
ESCHS LINESORT4 ESCHD MANDT TE530 Sort Criteria for Bill Printout MANDT
ESCHS LINESORT4 ESCHS LINESORT4 TE530 Sort Criteria for Bill Printout LINESORT
ESCHS LINESORT5 ESCHD MANDT TE530 Sort Criteria for Bill Printout MANDT
ESCHS LINESORT5 ESCHS LINESORT5 TE530 Sort Criteria for Bill Printout LINESORT
ESCHS LINE_CLASS SYST MANDT TE552 Classification Indicator for Billing Line MANDT
ESCHS LINE_CLASS ESCHS LINE_CLASS TE552 Classification Indicator for Billing Line LINE_CLASS
ESCHS LRATESTEP ESCHS MANDT ETRFV Rate Steps MANDT
ESCHS LRATESTEP ESCHS LRATESTEP ETRFV Rate Steps LRATESTEP
ESCHS MANDT ESCHS MANDT T000 Clients MANDT
ESCHS SCHEMANR ESCHS MANDT ESCH Billing Schema (Header Data) MANDT
ESCHS SCHEMANR ESCHS SCHEMANR ESCH Billing Schema (Header Data) SCHEMANR
ESCHS STGRAMT ESCHS STGRAMT TE541 Amount Statistics Group STGRAMT
ESCHS STGRAMT SYST MANDT TE541 Amount Statistics Group MANDT
ESCHS STGRQNT SYST MANDT TE540 Quantity Statistics Group MANDT
ESCHS STGRQNT ESCHS STGRQNT TE540 Quantity Statistics Group STGRQNT
ESCHS TARIFNR ESCHS MANDT ETRF Rate (Head. Data) MANDT
ESCHS TARIFNR ESCHS TARIFNR ETRF Rate (Head. Data) TARIFNR
ESCHS TIMESLICEGEN ESCHD MANDT TE543 Time slice generator MANDT
ESCHS TIMESLICEGEN ESCHS TIMESLICEGEN TE543 Time slice generator TIMESLICEGEN