SAP table RSCRMKYFDETAIL (Key Figure Details)

Field Description Data Type Length Decimals Checktable Data Element
MES_UID UUID in character form CHAR 32 0 SYSUUID_C
MES_CAP Description CHAR 60 0 RRTDSCRPTN
MES_AGGREGATOR Aggregational behaviour for key figure NUMC 3 0 RRTAGGREGATOR
000 MEASURE_AGGR_UNKNOWN
001 MEASURE_AGGR_SUM
002 MEASURE_AGGR_COUNT
003 MEASURE_AGGR_MIN
004 MEASURE_AGGR_MAX
005 MEASURE_AGGR_AVG
006 MEASURE_AGGR_VAR
007 MEASURE_AGGR_STD
008 MEASURE_AGGR_AVG_NOT_ZERO
009 MEASURE_AGGR_AVG_CALENDAR_DAYS
010 MEASURE_AGGR_AVG_PERIOD
011 MEASURE_AGGR_COUNT_NOT_ZERO
012 MEASURE_AGGR_FIRST
013 MEASURE_AGGR_LAST
014 MEASURE_AGGR_NOP
127 MEASURE_AGGR_CALCULATED
DATA_TYPE Data Type in ABAP Dictionary CHAR 4 0 DATATYPE_D
NUM_PREC Maximum precision (only given if data type is numeric) CHAR 1 0 RRTPRECISION
NUM_SCALE Display factor (if applicable) CHAR 1 0 RRTSCALE
MES_UNITS Unit of measurement (dollars, item, if applicable) CHAR 60 0 RRTUNITS
IOBJNM InfoObject CHAR 30 0 RSIOBJNM
OBJCAP Description CHAR 60 0 RRTDSCRPTN
FIELDNM Field Name InfoObject In Structures (Not in database table) CHAR 30 0 * RSDIOBJFIELDNM
DTELNM Data element (semantic domain) CHAR 30 0 DD04L ROLLNAME
DTELNM_DB Data element (semantic domain) CHAR 30 0 ROLLNAME
CHKTAB View of master data tables CHAR 30 0 * RSDCHKVIEW
DATATP Data Type in ABAP Dictionary CHAR 4 0 DATATYPE_D
INTLEN Internal Length of InfoObjects in BW - see Docu NUMC 6 0 RSDINTLEN
OUTPUTLEN Output Length NUMC 6 0 OUTPUTLEN
CONVEXIT Conversion Routine CHAR 5 0 CONVEXIT
FVALEX Domain fixed values exist (flag) CHAR 1 0 RSFVALEX
LOWERCASE Lowercase letters allowed/not allowed CHAR 1 0 LOWERCASE
INTTP ABAP data type (C,D,N,...) CHAR 1 0 INTTYPE
8 Whole Number (8-Byte Integer with Sign)
a Decimal Floating Point Number, 16 Digits
b 1-byte integer, whole number <= 254
C Character String
D Date (YYYYMMDD)
e Decimal Floating Point Number, 34 Digits
F Floating point number to accuracy of 8 bytes
g Character string with variable length (ABAP type STRING)
h Table type
I Integer number (4-byte integer with sign)
j Static Boxed Components
k Generic Boxed Components
l Reference to data object
N Character String with Digits Only
P Packed number
p Time stamp 'yyyy-mm-dd hh:mm:ss[.nnnnnnn]'
r Reference to class/interface
s 2-byte integer, only for length field before LCHR or LRAW
T Time (HHMMSS)
u Structured type, flat
V Character string (old dictionary type VARC)
v Structured type, deep
X Byte string (hexadecimal), in DDIC metadata also INT1/2/4
y Byte string with variable length (ABAP type XSTRING)
z Node Line for Stuctured Objects
DECIMALS Number of Decimal Places NUMC 6 0 DECIMALS
DIGITS Number of Characters in Field NUMC 6 0 RSDIGITS
POSIT Position of the Field in the Structure / Table NUMC 4 0 RSPOSIT
MASK Template (not used) CHAR 20 0 AS4MASK
MASKLEN Template length (not used) NUMC 4 0 MASKLEN
BYTELENG Internal Length in Bytes NUMC 6 0 INTLEN
KYFTP Key figure type CHAR 3 0 RSKYFTP
AMO Amount
DAT Date
FLO Floating point number (without unit)
INT Whole number
NUM Number (without unit)
QUA Quantity
TIM Time
NCUMFL Non-cumulative value (flag) CHAR 1 0 RSNCUMFL
Cumulative value
1 Stock with change involving stocks
2 Stock with inward and outward movement
FIXCUKY Fixed currency CUKY 5 0 TCURC RSFIXCUKY
FIXUNIT Fixed Unit of Measure UNIT 3 0 T006 RSFIXUNIT
AGGRGEN Usual Aggregation CHAR 3 0 RSDAGGRGEN
MAX Maximum
MIN Minimum
NO1 No Longer Used
NO2 No Longer Used
NOP No Longer Used
SUM Summation
AGGREXC Exception Aggregation CHAR 3 0 RSDAGGREXC
AV0 Average (Values Not Equal to Zero)
AV1 Average (Weighted with Number of Days)
AV2 Average (Weighted with No. of Working Days; Factory Calcul.)
AVG Average (All Values)
CN0 Counter (Values Unequal to Zero )
CNT Counter (All Values)
FIR First Value
LAS Last Value
MAX Maximum
MED Median
MIN Minimum
NGA No Aggregation of Postable Nodes Along Hierarchy
NHA No Aggregation Along Hierarchy
NO1 No Aggregation (X, If More Than One Record Occurs)
NO2 No Aggregation (X, If More Than One Value Occurs)
NOP No Aggregation (X, If More Than One Value Uneq. to 0 Occurs)
SLC Simple Linear Regression: Correlation Coefficient
SLI Simple Linear Regression: Y-Intercept
SLS Simple Linear Regression: Slope
STD Standard Deviation
SUM Summation
VAR Variance
AGGRCHA Reference characteristic for exception aggregation CHAR 30 0 RSDIOBJ RSAGGRCHA
KYFDECIM Decimal places (of a key figure) CHAR 1 0 RSKYFDECIM
Not defined
0 0
1 0.0
2 0.00
3 0.000
4 0.0000
5 0.00000
6 0.000000
7 0.0000000
8 0.00000000
9 0.000000000
KYFPRSNT Display (of a key figure) CHAR 1 0 RSKYFPRSNT
Not defined
0 in 1
1 in 10
2 in 100
3 in 1,000
4 in 10,000
5 in 100,000
6 in 1,000,000
7 in 10,000,000
8 in 100,000,000
9 in 1,000,000,000
KYFNAV Navigation indicator for key figures CHAR 1 0 RSKYFNAV
Not assigned
0 Permitted without restrictions
1 Must be selected
2 Not allowed
UNINM Unit InfoObject (currency/unit) CHAR 30 0 RSDUNI RSUNINM
DOMANM Domain name CHAR 30 0 DOMNAME
PACKFL Process Key Figure with High Precision CHAR 1 0 RSDHIGHPRECFL
KYFSEMANTIC Semantic of a Key Figure CHAR 1 0 RSDKYFSEMANTIC
Standard Keyfigure
S Stock Cover Keyfigure
STOCK_COVER_CALCTYPE Type of Stock used by Stock Coverage Calculation CHAR 1 0 RSDSTOCK_COVER_CALCTYPE
No Stock Cover Key Figure
B Begin
D Derived from Referenced Key Figure
E End
STOCK_COVER_PERIODS Number of Stock Cover Periods to be calculated INT4 10 0 RSDSTOCK_COVER_PERIODS

RSCRMKYFDETAIL foreign key relationships

Table Field Check Table Check Field
0 RSCRMKYFDETAIL AGGRCHA RSDIOBJ Directory of all InfoObjects OBJVERS
1 RSCRMKYFDETAIL DTELNM DD04L Data elements ROLLNAME
1 RSCRMKYFDETAIL DTELNM DD04L Data elements AS4LOCAL
1 RSCRMKYFDETAIL DTELNM DD04L Data elements AS4VERS
0 RSCRMKYFDETAIL FIXCUKY TCURC Currency Codes MANDT
0 RSCRMKYFDETAIL FIXCUKY TCURC Currency Codes WAERS
1 RSCRMKYFDETAIL FIXUNIT T006 Units of Measurement MSEHI
0 RSCRMKYFDETAIL UNINM RSDUNI Units OBJVERS