T7PIQSCALE

Transparent Table Customizing Table
9 Fields 1 CDS Views

Academic Scales

T7PIQSCALE is an SAP database table in S/4HANA. Academic Scales. It contains 9 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
PiqCdAcademicScale view from Academic Scale

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY scaleid PIQSCALE_ID Scale ID
type PIQSCALE_TYPE Scale Type
direction PIQSCALE_DIRECTION Displ.Direction
low PIQSCALE_LOW Lowest value
high PIQSCALE_HIGH Highest value
base PIQSCALE_BASE Base Value
dist PIQSCALE_DIST Interval
userexit PIQSCALE_USEREXIT FM for conversion

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.

-- Academic Scales
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T7PIQSCALE (
    MANDT,      -- Client [MANDT]
    SCALEID,    -- Scale ID [PIQSCALE_ID]
    TYPE,       -- Scale Type [PIQSCALE_TYPE]
    DIRECTION,  -- Displ.Direction [PIQSCALE_DIRECTION]
    LOW,        -- Lowest value [PIQSCALE_LOW]
    HIGH,       -- Highest value [PIQSCALE_HIGH]
    BASE,       -- Base Value [PIQSCALE_BASE]
    DIST,       -- Interval [PIQSCALE_DIST]
    USEREXIT,   -- FM for conversion [PIQSCALE_USEREXIT]
    PRIMARY KEY (MANDT, SCALEID)
);

Learn More