SAP table TE417 (Sched. Recs: Portions)
SAP table TE417 has 3 primary key fields being MANDT,TERMSCHL,TERMTDAT.
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
Client
CLNT
3
0
T000
MANDT
Portion
CHAR
8
0
PORTION_TS
Date of schedule record
DATS
8
0
TERMTDAT
TERMPDAT
Date on which the schedule record was created
DATS
8
0
TERMPDAT
ZUORDDAT
Allocation date for billing
DATS
8
0
E_ZUORDDATABR
ABRDATS
Scheduled Billing Date
DATS
8
0
ABRDATS
ABSCHLE
Date of first budget billing amount of the period
DATS
8
0
ABSCHLE
ABSCHLL
Date of last budget billing amount of the period
DATS
8
0
ABSCHLL
ABRVORG
Billing Transaction
CHAR
2
0
ABRVORG
Possible values
01
Periodic Billing (01)
02
Interim Billing (02)
03
Final Billing for Move-Out (03)
04
Period-End Billing (04)
05
Service Territory Transfer (05)
06
Manual Credit Memo/Backbilling (06)
07
Contract Change (07)
08
Customer change (08)
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
PTERMSCHL
Parameter Record
CHAR
8
0
P_TERMSCHL
ENDVOPER
End of the previous period
DATS
8
0
ENDVOPER
ERDAT
Date on which the record was created
DATS
8
0
ERDAT
ERNAM
Name of Person Responsible for Creating the Object
CHAR
12
0
ERNAM
AEDAT
Last Changed On
DATS
8
0
AEDAT
AENAM
Name of Person Who Changed Object
CHAR
12
0
AENAM
SAPKAL
Correct Non-Workday
CHAR
1
0
CORR_OPT
IDENT
Factory Calendar
CHAR
2
0
TFACD
WFCID
TS_DYN
Dynamic scheduling
CHAR
1
0
TS_DYN
Possible values
No dynamic scheduling
1
Dynamic scheduling, without budget billing amounts
2
Dynamic scheduling, with budget billing amounts