SAP table T7PIQSCALE (Academic Scales)

SAP table T7PIQSCALE has 2 primary key fields being MANDT,SCALEID.

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
SCALEID Academic Scale Identification (ID) CHAR 4 0 PIQSCALE_ID
TYPE Scale Type CHAR 1 0 PIQSCALE_TYPE
Quality scale
D Partially linear quantity scale
F Quantity scale FM
L Linear quantity scale
DIRECTION Display Direction of Scale Values CHAR 1 0 PIQSCALE_DIRECTION
Highest -> Lowest
U Lowest -> Highest
LOW Lowest Value of a Quantity Scale DEC 10 4 PIQSCALE_LOW
HIGH Highest Value of a Quantity Scale DEC 10 4 PIQSCALE_HIGH
BASE Base Value for Conversion to Standard Scale DEC 8 2 PIQSCALE_BASE
DIST Interval of a Quantity Scale DEC 10 4 PIQSCALE_DIST
USEREXIT User Exit - Function Module for Scale Conversion CHAR 30 0 TFDIR PIQSCALE_USEREXIT

T7PIQSCALE foreign key relationships

Table Field Check Table Check Field
0 T7PIQSCALE USEREXIT TFDIR Function Module FUNCNAME