SAP table TE420 (Sch. Mast. Data: Portion)

SAP table TE420 has 2 primary key fields being MANDT,TERMSCHL.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
TERMSCHL Portion CHAR 8 0 PORTION
TERMTEXT Text for schedule master record CHAR 30 0 BEZEICH
TERMERST End of Billing Period DATS 8 0 ENDEABR
ABRDATS Scheduled Billing Date DATS 8 0 ABRDATS
PERIODEW Period length: months DEC 2 0 PERIODEW
PERIODET Period category CHAR 1 0 PERIODET
1 Years
2 Months
ZUORDDAT Allocation date for billing DATS 8 0 E_ZUORDDATABR
ZLEISTE Permissible combinations of billing class/division category CHAR 40 0 E_ZLEISTE
JAHRESZAHL Annual payer CHAR 1 0 JAHRESZAHL
ZULTERM Permissible Budget Billing Date CHAR 40 0 E_ZULTERM
ABSZYK Allowable budget billing cycles CHAR 2 0 ABSZYKTER
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 DATS 8 0 THGDAT
DATUMDF Scheduled date for invoicing printout DATS 8 0 DATUMDF
MSPABPLF Dun last due date of a budget billing plan CHAR 1 0 MSPABPLF
KABSPERA No budget billing in period billing CHAR 1 0 KABSPERA
EROEDAT Creation date DATS 8 0 EROEDAT
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
AENDDATE Change date DATS 8 0 AENDDATE
AENDNAM Last changed by CHAR 12 0 AENDNAM
VERTRKL1 Billing class CHAR 4 0 EAKLASSE E_AKLASSE
SPARTENTY1 Division category NUMC 2 0 E_SPARTYP
VERTRKL2 Billing class CHAR 4 0 EAKLASSE E_AKLASSE
SPARTENTY2 Division category NUMC 2 0 E_SPARTYP
VERTRKL3 Billing class CHAR 4 0 EAKLASSE E_AKLASSE
SPARTENTY3 Division category NUMC 2 0 E_SPARTYP
VERTRKL4 Billing class CHAR 4 0 EAKLASSE E_AKLASSE
SPARTENTY4 Division category NUMC 2 0 E_SPARTYP
VERTRKL5 Billing class CHAR 4 0 EAKLASSE E_AKLASSE
SPARTENTY5 Division category NUMC 2 0 E_SPARTYP
ABSZYKTER1 Budget Billing Cycle (in Months) NUMC 2 0 ABSZYKZT
ANZFAELL1 Number of bud. bill. amts dependent on budget billing cycle CHAR 2 0 ANZFAELL
ABSZYKTER2 Budget Billing Cycle (in Months) NUMC 2 0 ABSZYKZT
ANZFAELL2 Number of bud. bill. amts dependent on budget billing cycle CHAR 2 0 ANZFAELL
ABSZYKTER3 Budget Billing Cycle (in Months) NUMC 2 0 ABSZYKZT
ANZFAELL3 Number of bud. bill. amts dependent on budget billing cycle CHAR 2 0 ANZFAELL
ABSZYKTER4 Budget Billing Cycle (in Months) NUMC 2 0 ABSZYKZT
ANZFAELL4 Number of bud. bill. amts dependent on budget billing cycle CHAR 2 0 ANZFAELL
ABSZYKTER5 Budget Billing Cycle (in Months) NUMC 2 0 ABSZYKZT
ANZFAELL5 Number of bud. bill. amts dependent on budget billing cycle CHAR 2 0 ANZFAELL
PARASATZ Parameter Record CHAR 8 0 P_TERMSCHL
IDENT Factory Calendar CHAR 2 0 TFACD WFCID
SAPKAL Correct Non-Workday CHAR 1 0 CORR_OPT
PTOLERFROM Lower Limit of Interval for Month-Based Billing Period INT4 10 0 PTOLERFROM
PTOLERTO Upper Limit of Interval for Month-Based Billing Period INT4 10 0 PTOLERTO
ABRABS Combine Budget Billing Amount Due Date and Bill CHAR 1 0 ABRABS1
TS_DYN Dynamic scheduling CHAR 1 0 TS_DYN
No dynamic scheduling
1 Dynamic scheduling, without budget billing amounts
2 Dynamic scheduling, with budget billing amounts
PERIODED Period length in days DEC 3 0 PERIODEDAY
WORK_DAY Take factory calendar into account CHAR 1 0 WORK_DAY
BEGRU Authorization Group CHAR 4 0 BEGRU
EXTRAPOLWASTE Category of Waste Disposal Budget Billing Extrapolation CHAR 2 0 EXTRAPOLWASTE
01 Automatically
02 via Service Frequency
03 via Previous Period
04 via Previous Year Period
INTCNTRTYPE Type of Enhanced Interval Procedure CHAR 4 0 TE435 INTCNTRTYPE
ABSZYKTER6 Budget Billing Cycle (in Months) NUMC 2 0 ABSZYKZT
ANZFAELL6 Number of bud. bill. amts dependent on budget billing cycle CHAR 2 0 ANZFAELL

TE420 foreign key relationships

Table Field Check Table Check Field
0 TE420 INTCNTRTYPE TE435 Type of Enhanced Interval Procedure MANDT
0 TE420 INTCNTRTYPE TE435 Type of Enhanced Interval Procedure INTCNTRTYPE
1 TE420 VERTRKL1 EAKLASSE IS-U Billing Classes MANDT
1 TE420 VERTRKL1 EAKLASSE IS-U Billing Classes AKLASSE
0 TE420 VERTRKL2 EAKLASSE IS-U Billing Classes MANDT
0 TE420 VERTRKL2 EAKLASSE IS-U Billing Classes AKLASSE
1 TE420 VERTRKL3 EAKLASSE IS-U Billing Classes MANDT
1 TE420 VERTRKL3 EAKLASSE IS-U Billing Classes AKLASSE
0 TE420 VERTRKL4 EAKLASSE IS-U Billing Classes MANDT
0 TE420 VERTRKL4 EAKLASSE IS-U Billing Classes AKLASSE
1 TE420 VERTRKL5 EAKLASSE IS-U Billing Classes MANDT
1 TE420 VERTRKL5 EAKLASSE IS-U Billing Classes AKLASSE