SAP Table T7PIQSCALE

Academic Scales

T7PIQSCALE (Academic Scales) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T7PIQSCALE to other SAP tables.

Source: T7PIQSCALE (Academic Scales)

T7PIQSCALE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SCALEID Academic Scale Identification (ID) PIQSCALE_ID CHAR 4 0
TYPE Scale Type PIQSCALE_TYPE CHAR 1 0
NULL Quality scale
L Linear quantity scale
D Partially linear quantity scale
F Quantity scale FM
DIRECTION Display Direction of Scale Values PIQSCALE_DIRECTION CHAR 1 0
NULL Highest -> Lowest
U Lowest -> Highest
LOW Lowest Value of a Quantity Scale PIQSCALE_LOW DEC 10 4
HIGH Highest Value of a Quantity Scale PIQSCALE_HIGH DEC 10 4
BASE Base Value for Conversion to Standard Scale PIQSCALE_BASE DEC 8 2
DIST Interval of a Quantity Scale PIQSCALE_DIST DEC 10 4
USEREXIT User Exit - Function Module for Scale Conversion PIQSCALE_USEREXIT TFDIR CHAR 30 0

T7PIQSCALE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T7PIQSCALE MANDT T7PIQSCALE MANDT T000 Clients MANDT
T7PIQSCALE USEREXIT T7PIQSCALE USEREXIT TFDIR Function Module FUNCNAME