SAP table TFK8117 (Discounts/Charges on Billed Items: Basic Settings)

SAP table TFK8117 has 2 primary key fields being MANDT,DISCKEY.

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
DISCKEY Discount/Charge Key CHAR 8 0 DISCKEY_KK
CURRENCY Currency of Discount or Charge CUKY 5 0 DISC_CURR_KK
DISC_ASSGR Assignment Group for Discounts/Charges CHAR 4 0 TFK8117A DISC_ASSGR_KK
CYCLE Cycle of Calculation of Discount/Charge CHAR 4 0 TFK2607 DISC_CYCLE_KK
PROCESSING_LEVEL Processing Level for Discount/Charge in Billing NUMC 4 0 DISC_LEVEL_KK
0000 Interval for Processing Level
NO_BASE_AMNT_ADJ No Adjustment of Base Amount CHAR 1 0 DISC_NO_BASE_AMNT_ADJ_KK
UTILIZATION Use of Discount/Charge CHAR 1 0 DISC_UTILIZATION_KK
C Charge
D Discount
TRACE_OPTION Discount Log Options CHAR 1 0 DISC_TRACE_OPTIONS_KK
Switch Off
1 Switch On
2 Switch on for Individual Processing
3 Switch on for Individual Processing in Expert Mode
VERSION_DET_REF_DATE Reference Date for Determination of Discount Version CHAR 2 0 DISC_VERSION_DET_REF_DATE_KK
Baseline Date for Billing
01 Baseline Date of Billable Item
CALC_EXECUTION Time of Calculation CHAR 1 0 DISC_CALC_EXECUTION_KK
After Billing of Billable Items to Be Discounted
1 During Billing of Billable Items to Be Discounted

TFK8117 foreign key relationships

Table Field Check Table Check Field
0 TFK8117 CYCLE TFK2607 Billing Cycles CYCLE
1 TFK8117 DISC_ASSGR TFK8117A Discounts/Charges on Billed Items: Account Assignment Group MANDT