AFWKFRA_KB0_H

Transparent Table Customizing Table
8 Fields 2 CDS Views

Key Figures: NPV with Currency

AFWKFRA_KB0_H is an SAP database table in S/4HANA. Key Figures: NPV with Currency. It contains 8 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_MRKFGeneralNPV view inner BASIC
P_MRKFGeneralNPV view left_outer BASIC

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY keyfigure AFWKF_DEFINITION Key Figure
KEY valdate AFW_VALDATE Valid From
basefigure AFWKF_BASEDEFINITION Basic key fig.
currency AFW_EVAL_CURRENCY Evaluation Currency
mdscenario AFWKFRA_SCENARIO Scenario
horizont AFWKFRA_HOFFSET Horizon offset
mdsrule JBRREGID Shift Rule

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.

-- Key Figures: NPV with Currency
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE AFWKFRA_KB0_H (
    MANDT,       -- Client [MANDT]
    KEYFIGURE,   -- Key Figure [AFWKF_DEFINITION]
    VALDATE,     -- Valid From [AFW_VALDATE]
    BASEFIGURE,  -- Basic key fig. [AFWKF_BASEDEFINITION]
    CURRENCY,    -- Evaluation Currency [AFW_EVAL_CURRENCY]
    MDSCENARIO,  -- Scenario [AFWKFRA_SCENARIO]
    HORIZONT,    -- Horizon offset [AFWKFRA_HOFFSET]
    MDSRULE,     -- Shift Rule [JBRREGID]
    PRIMARY KEY (MANDT, KEYFIGURE, VALDATE)
);

Learn More