1. Home
  2. Resources
  3. SAP Tables
  4. TE420 - Sch. Mast. Data: Portion

SAP Table TE420

Sch. Mast. Data: Portion

TE420 (Sch. Mast. Data: Portion) 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 TE420 to other SAP tables.

TE420 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
TERMSCHL Portion PORTION CHAR 8 0
TERMTEXT Text for schedule master record BEZEICH CHAR 30 0
TERMERST End of Billing Period ENDEABR DATS 8 0
ABRDATS Scheduled Billing Date ABRDATS DATS 8 0
PERIODEW Period length: months PERIODEW DEC 2 0
1 1 month
2 2 months
3 3 months
4 4 months
6 6 months
12 12 months
PERIODET Period category PERIODET CHAR 1 0
1 Years
2 Months
ZUORDDAT Allocation date for billing E_ZUORDDATABR DATS 8 0
ZLEISTE Permissible combinations of billing class/division category E_ZLEISTE CHAR 40 0
JAHRESZAHL Annual payer JAHRESZAHL CHAR 1 0
NULL Field inactive
X Field active
ZULTERM Permissible Budget Billing Date E_ZULTERM CHAR 40 0
ABSZYK Allowable budget billing cycles ABSZYKTER CHAR 2 0
00 No budget billing amounts are charged
01 Budget billing amounts are charged at monthly intervals
02 Budget billing amounts are charged at two-monthly intervals
03 Bud. billing amounts are charged at three-monthly intervals
04 Bud. billing amounts are charged at four-monthly intervals
06 Bud. billing amounts are charged at six-monthly intervals
12 Annual meter; only one budget billing amount is charged
THGDAT Allocation Date for Gas Billing THGDAT DATS 8 0
DATUMDF Scheduled date for invoicing printout DATUMDF DATS 8 0
MSPABPLF Dun last due date of a budget billing plan MSPABPLF CHAR 1 0
NULL Field inactive
X Field active
KABSPERA No budget billing in period billing KABSPERA CHAR 1 0
NULL Field inactive
X Field active
EROEDAT Creation date EROEDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AENDDATE Change date AENDDATE DATS 8 0
AENDNAM Last changed by AENDNAM CHAR 12 0
VERTRKL1 Billing class E_AKLASSE EAKLASSE CHAR 4 0
SPARTENTY1 Division category E_SPARTYP NUMC 2 0
01 Electricity
02 Gas
03 Water
04 Waste water
05 District heating
06 Waste Management
11 Mutual help
99 For all sectors
VERTRKL2 Billing class E_AKLASSE EAKLASSE CHAR 4 0
SPARTENTY2 Division category E_SPARTYP NUMC 2 0
01 Electricity
02 Gas
03 Water
04 Waste water
05 District heating
06 Waste Management
11 Mutual help
99 For all sectors
VERTRKL3 Billing class E_AKLASSE EAKLASSE CHAR 4 0
SPARTENTY3 Division category E_SPARTYP NUMC 2 0
01 Electricity
02 Gas
03 Water
04 Waste water
05 District heating
06 Waste Management
11 Mutual help
99 For all sectors
VERTRKL4 Billing class E_AKLASSE EAKLASSE CHAR 4 0
SPARTENTY4 Division category E_SPARTYP NUMC 2 0
01 Electricity
02 Gas
03 Water
04 Waste water
05 District heating
06 Waste Management
11 Mutual help
99 For all sectors
VERTRKL5 Billing class E_AKLASSE EAKLASSE CHAR 4 0
SPARTENTY5 Division category E_SPARTYP NUMC 2 0
01 Electricity
02 Gas
03 Water
04 Waste water
05 District heating
06 Waste Management
11 Mutual help
99 For all sectors
ABSZYKTER1 Budget Billing Cycle (in Months) ABSZYKZT NUMC 2 0
00 No budget billing amounts are charged
01 Budget billing amounts are charged at monthly intervals
02 Budget billing amounts are charged at two-monthly intervals
03 Bud. billing amounts are charged at three-monthly intervals
04 Bud. billing amounts are charged at four-monthly intervals
06 Bud. billing amounts are charged at six-monthly intervals
12 Annual meter; only one budget billing amount is requested
ANZFAELL1 Number of bud. bill. amts dependent on budget billing cycle ANZFAELL CHAR 2 0
ABSZYKTER2 Budget Billing Cycle (in Months) ABSZYKZT NUMC 2 0
00 No budget billing amounts are charged
01 Budget billing amounts are charged at monthly intervals
02 Budget billing amounts are charged at two-monthly intervals
03 Bud. billing amounts are charged at three-monthly intervals
04 Bud. billing amounts are charged at four-monthly intervals
06 Bud. billing amounts are charged at six-monthly intervals
12 Annual meter; only one budget billing amount is requested
ANZFAELL2 Number of bud. bill. amts dependent on budget billing cycle ANZFAELL CHAR 2 0
ABSZYKTER3 Budget Billing Cycle (in Months) ABSZYKZT NUMC 2 0
00 No budget billing amounts are charged
01 Budget billing amounts are charged at monthly intervals
02 Budget billing amounts are charged at two-monthly intervals
03 Bud. billing amounts are charged at three-monthly intervals
04 Bud. billing amounts are charged at four-monthly intervals
06 Bud. billing amounts are charged at six-monthly intervals
12 Annual meter; only one budget billing amount is requested
ANZFAELL3 Number of bud. bill. amts dependent on budget billing cycle ANZFAELL CHAR 2 0
ABSZYKTER4 Budget Billing Cycle (in Months) ABSZYKZT NUMC 2 0
00 No budget billing amounts are charged
01 Budget billing amounts are charged at monthly intervals
02 Budget billing amounts are charged at two-monthly intervals
03 Bud. billing amounts are charged at three-monthly intervals
04 Bud. billing amounts are charged at four-monthly intervals
06 Bud. billing amounts are charged at six-monthly intervals
12 Annual meter; only one budget billing amount is requested
ANZFAELL4 Number of bud. bill. amts dependent on budget billing cycle ANZFAELL CHAR 2 0
ABSZYKTER5 Budget Billing Cycle (in Months) ABSZYKZT NUMC 2 0
00 No budget billing amounts are charged
01 Budget billing amounts are charged at monthly intervals
02 Budget billing amounts are charged at two-monthly intervals
03 Bud. billing amounts are charged at three-monthly intervals
04 Bud. billing amounts are charged at four-monthly intervals
06 Bud. billing amounts are charged at six-monthly intervals
12 Annual meter; only one budget billing amount is requested
ANZFAELL5 Number of bud. bill. amts dependent on budget billing cycle ANZFAELL CHAR 2 0
PARASATZ Parameter Record P_TERMSCHL CHAR 8 0
IDENT Factory Calendar WFCID TFACD CHAR 2 0
SAPKAL Correct Non-Workday CORR_OPT CHAR 1 0
NULL Do not correct date
1 Use the workday following the non-workday
2 Use the workday prior to the non-workday
PTOLERFROM Lower Limit of Interval for Month-Based Billing Period PTOLERFROM INT4 10 0
PTOLERTO Upper Limit of Interval for Month-Based Billing Period PTOLERTO INT4 10 0
ABRABS Combine Budget Billing Amount Due Date and Bill ABRABS1 CHAR 1 0
NULL Bill and next budget billing amount have own due dates
1 Bill due with next budget billing amount
2 Next budget billing amount due with bill
TS_DYN Dynamic scheduling TS_DYN CHAR 1 0
NULL No dynamic scheduling
1 Dynamic scheduling, without budget billing amounts
2 Dynamic scheduling, with budget billing amounts
PERIODED Period length in days PERIODEDAY DEC 3 0
WORK_DAY Take factory calendar into account WORK_DAY CHAR 1 0
NULL Field inactive
X Field active
BEGRU Authorization Group BEGRU CHAR 4 0
EXTRAPOLWASTE Category of Waste Disposal Budget Billing Extrapolation EXTRAPOLWASTE CHAR 2 0
01 Automatically
02 via Service Frequency
03 via Previous Period
04 via Previous Year Period
INTCNTRTYPE Type of Enhanced Interval Procedure INTCNTRTYPE TE435 CHAR 4 0

TE420 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TE420 IDENT TE420 IDENT TFACD Factory calendar definition IDENT
TE420 INTCNTRTYPE TE420 MANDT TE435 Type of Enhanced Interval Procedure MANDT
TE420 INTCNTRTYPE TE420 INTCNTRTYPE TE435 Type of Enhanced Interval Procedure INTCNTRTYPE
TE420 MANDT TE420 MANDT T000 Clients MANDT
TE420 VERTRKL1 TE420 MANDT EAKLASSE IS-U Billing Classes MANDT
TE420 VERTRKL1 TE420 VERTRKL1 EAKLASSE IS-U Billing Classes AKLASSE
TE420 VERTRKL2 TE420 MANDT EAKLASSE IS-U Billing Classes MANDT
TE420 VERTRKL2 TE420 VERTRKL2 EAKLASSE IS-U Billing Classes AKLASSE
TE420 VERTRKL3 TE420 VERTRKL3 EAKLASSE IS-U Billing Classes AKLASSE
TE420 VERTRKL3 TE420 MANDT EAKLASSE IS-U Billing Classes MANDT
TE420 VERTRKL4 TE420 MANDT EAKLASSE IS-U Billing Classes MANDT
TE420 VERTRKL4 TE420 VERTRKL4 EAKLASSE IS-U Billing Classes AKLASSE
TE420 VERTRKL5 TE420 MANDT EAKLASSE IS-U Billing Classes MANDT
TE420 VERTRKL5 TE420 VERTRKL5 EAKLASSE IS-U Billing Classes AKLASSE