TFK8117

Transparent Table Customizing Table
11 Fields 3 CDS Views

Discounts/Charges on Billed Items: Basic Settings

TFK8117 is an SAP database table in S/4HANA. Discounts/Charges on Billed Items: Basic Settings. It contains 11 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CABllbleItmDiscountKey view_entity from BASIC Rabatt-/Zuschlagschlüssel für abr. Pos.
I_SubscrpnProdDiscountTP view inner TRANSACTIONAL Transactional view for the Subscription Product Discount
I_SubscrpnProductChargeTP view inner TRANSACTIONAL Transactional view for the Subscription Product Charge

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY disckey DISCKEY_KK Disc./Chg. Key
currency DISC_CURR_KK Disc./Chg. Crcy
disc_assgr DISC_ASSGR_KK Assignment Group
cycle DISC_CYCLE_KK Calc. Cycle
processing_level DISC_LEVEL_KK Process.Level
no_base_amnt_adj DISC_NO_BASE_AMNT_ADJ_KK No Base Amount Adj.
utilization DISC_UTILIZATION_KK Use
trace_option DISC_TRACE_OPTIONS_KK Log
version_det_ref_date DISC_VERSION_DET_REF_DATE_KK Version Ref. Date
calc_execution DISC_CALC_EXECUTION_KK Time of Calculation

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Discounts/Charges on Billed Items: Basic Settings
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TFK8117 (
    MANDT,                 -- Client [MANDT]
    DISCKEY,               -- Disc./Chg. Key [DISCKEY_KK]
    CURRENCY,              -- Disc./Chg. Crcy [DISC_CURR_KK]
    DISC_ASSGR,            -- Assignment Group [DISC_ASSGR_KK]
    CYCLE,                 -- Calc. Cycle [DISC_CYCLE_KK]
    PROCESSING_LEVEL,      -- Process.Level [DISC_LEVEL_KK]
    NO_BASE_AMNT_ADJ,      -- No Base Amount Adj. [DISC_NO_BASE_AMNT_ADJ_KK]
    UTILIZATION,           -- Use [DISC_UTILIZATION_KK]
    TRACE_OPTION,          -- Log [DISC_TRACE_OPTIONS_KK]
    VERSION_DET_REF_DATE,  -- Version Ref. Date [DISC_VERSION_DET_REF_DATE_KK]
    CALC_EXECUTION,        -- Time of Calculation [DISC_CALC_EXECUTION_KK]
    PRIMARY KEY (MANDT, DISCKEY)
);

Learn More