SAP table TFK2607 (Billing Cycles)

SAP table TFK2607 has 2 primary key fields being MANDT,CYCLE.

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 MANDT
CYCLE Billing Cycle CHAR 4 0 CYCLE_KK
CYCLE_PERIODCAT Frequency of Billing Periods CHAR 4 0 CYCLE_PERIODCAT_KK
CN Every n Working Days According to Factory Calendar
DN Every n Days
M1 Monthly
M2 Every 2 Months
M3 Every 3 Months
M6 Every Six Months
MN Every n Months
W1 Weekly
W2 Every 2 Weeks
W4 Every 4 Weeks
WN Every n Weeks
Y1 Annually
YN Every n Years
CYCLE_PERIODLENGTH Length of Billing Period NUMC 4 0 CYCLE_PERIODLENGTH_KK
CYCLE_DAY_TYPE Rule for Determinatino of Start Date CHAR 1 0 CYCLE_DAY_TYPE_KK
Start Date According to Customizing
1 Start Date of Billing Cycle in Contract Account
2 Start of Validity of Provider Contract Item
3 External Start Date of Billing Cycle
CYCLE_DAY Day of Period End CHAR 2 0 CYCLE_DAY_KK
Defaulted Using Billing Cycle
01 1st Day of Month
02 2nd Day of Month
03 3rd Day of Month
04 4th Day of Month
05 5th Day of Month
06 6th Day of Month
07 7th Day of Month
08 8th Day of Month
09 9th Day of Month
10 10th Day of Month
11 11th Day of Month
12 12th Day of Month
13 13th Day of Month
14 14th Day of Month
15 15th Day of Month
16 16th Day of Month
17 17th Day of Month
18 18th Day of Month
19 19th Day of Month
20 20th Day of Month
21 21st Day of Month
22 22nd Day of Month
23 23rd Day of Month
24 24th Day of Month
25 25th Day of Month
26 26th Day of Month
27 27th Day of Month
28 28th Day of Month
29 29th Day of Month
30 30th Day of Month
31 31st Day of Month
W1 Monday
W2 Tuesday
W3 Wednesday
W4 Thursday
W5 Friday
W6 Saturday
W7 Sunday
CYCLE_MONTH Month of Period End CHAR 2 0 CYCLE_MONTH_KK
01 First Month
02 Second Month
03 Third Month
04 Fourth Month
05 Fifth Month
06 Sixth Month
07 Seventh Month
08 Eighth Month
09 Ninth Month
10 Tenth Month
11 Eleventh Month
12 Twelfth Month
CYCLE_STARTDATE Start Date of First Billing Period DATS 8 0 CYCLE_STARTDATE_KK
INDIVIDUAL Can Be Individually Overwritten at Contract Account Level CHAR 1 0 CYCLE_INDIVIDUAL_KK
CYCLE_TRUNC Adjustment Rule of First Billing Period CHAR 1 0 CYCLE_TRUNC_KK
1 Reduce Time Period
2 Increase Time Period
3 Reduce to Minimum Length, Otherwise Increase
CYCLE_MINDAYS Minimum Length in Days for Adjustment of Time Period NUMC 3 0 CYCLE_MINDAYS_KK
TERMINATEDATE Date Until Which Use Is Possible DATS 8 0 CYCLE_TERMINATEDATE_KK
CYCLE_MONTH_DAYTO Date Limit to Start Month NUMC 2 0 CYCLE_MONTH_DAYTO_KK
CYCLE_CALENDAR Factory Calendar for Defining Billing Periods CHAR 2 0 TFACD CYCLE_CALENDAR_KK