Saturday, September 14, 2024

SAP Table TFK2607 – Billing Cycles

TFK2607 is a standard SAP table in SAP ECC (or) S/4HANA which stores Billing Cycles data. There are total 12 fields in TFK2607 table.This blog post provides key technical details of SAP table TFK2607, including its availability across SAP S/4HANA versions and the list of CDS views for TFK2607 table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering switched on
Buffering Type Full table is passed to buffer

SAP TFK2607 Table Fields

The following is the list of fields that are available in SAP TFK2607 table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT CLNT (3)
CYCLE Billing Cycle CYCLE_KK CYCLE_KK CHAR (4)
CYCLE_PERIODCAT Frequency of Billing Periods CYCLE_PERIODCAT_KK CYCLE_PERIODCAT_KK CHAR (4)
CYCLE_DAY_TYPE Rule for Determinatino of Start Date CYCLE_DAY_TYPE_KK CYCLE_DAY_TYPE_KK CHAR (1)
CYCLE_DAY Day of Period End CYCLE_DAY_KK CYCLE_DAY_KK CHAR (2)
CYCLE_MONTH Month of Period End CYCLE_MONTH_KK CYCLE_MONTH_KK CHAR (2)
CYCLE_STARTDATE Start Date of First Billing Period CYCLE_STARTDATE_KK DATS DATS (8)
INDIVIDUAL Can Be Individually Overwritten at Contract Account Level CYCLE_INDIVIDUAL_KK XFELD CHAR (1)
CYCLE_TRUNC Adjustment Rule of First Billing Period CYCLE_TRUNC_KK CYCLE_TRUNC_KK CHAR (1)
TERMINATEDATE Date Until Which Use Is Possible CYCLE_TERMINATEDATE_KK DATS DATS (8)
CYCLE_MONTH_DAYTO Date Limit to Start Month CYCLE_MONTH_DAYTO_KK CYCLE_MONTH_DAYTO_KK NUMC (2)
CYCLE_CALENDAR Factory Calendar for Defining Billing Periods CYCLE_CALENDAR_KK WFCID TFACD CHAR (2)

Availability

The SAP table TFK2607 is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for TFK2607 table

The following is the list of CDS views for TFK2607 table, which can also be used instead of TFK2607 table based on your business requirements.

CDS View CDS View Type Description
I_CABILLGCYCLE BASIC Billing Cycle
I_CABILLGCYCLEVH BASIC Billing Cycle (Value Help)
C_CABILLGPLNITEM CONSUMPTION Billing Plan Items
C_CONTRACTACCBPCFO CONSUMPTION Contract Account