SAP Table RSCRMKYFDETAIL

Key Figure Details

RSCRMKYFDETAIL (Key Figure Details) 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 RSCRMKYFDETAIL to other SAP tables.

Source: RSCRMKYFDETAIL (Key Figure Details)

RSCRMKYFDETAIL table fields

Field

Data element

Checktable

Datatype

Length

Decimals

MES_UID

UUID in character form

SYSUUID_C

CHAR

MES_CAP

Description

RRTDSCRPTN

CHAR

MES_AGGREGATOR

Aggregational behaviour for key figure

RRTAGGREGATOR

NUMC

Possible values

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

DATATYPE_D

CHAR

Possible values

ACCP	Posting period YYYYMM
CHAR	Character String
CLNT	Client
CUKY	Currency key, referenced by CURR fields
CURR	Currency field, stored as DEC
D16D	Decimal Floating Point, 16 Digits, DEC on Database
D16R	Decimal Floating Point, 16 Digits, RAW on Database
D16S	Decimal Floating Point. 16 Digits, with Scale Field
D34D	Decimal Floating Point, 34 Digits, DEC on Database
D34R	Decimal Floating Point, 34 Digits, RAW on Database
D34S	Decimal Floating Point, 34 Digits, with Scale Field
DATS	Date field (YYYYMMDD) stored as char(8)
DEC	Counter or amount field with comma and sign
FLTP	Floating point number, accurate to 8 bytes
INT1	1-byte integer, integer number <= 255
INT2	2-byte integer, only for length field before LCHR or LRAW
INT4	4-byte integer, integer number with sign
LANG	Language key
LCHR	Long character string, requires preceding INT2 field
LRAW	Long byte string, requires preceding INT2 field
NUMC	Character string with only digits
PREC	Obsolete data type, do not use
QUAN	Quantity field, points to a unit field with format UNIT
RAW	Uninterpreted sequence of bytes
RSTR	Byte String of Variable Length
SSTR	Short Character String of Variable Length
STRG	Character String of Variable Length
TIMS	Time field (hhmmss), stored as char(6)
UNIT	Unit key for QUAN fields
VARC	Long character string, no longer supported from Rel. 3.0

NUM_PREC

Maximum precision (only given if data type is numeric)

RRTPRECISION

CHAR

NUM_SCALE

Display factor (if applicable)

RRTSCALE

CHAR

MES_UNITS

Unit of measurement (dollars, item, if applicable)

RRTUNITS

CHAR

IOBJNM

InfoObject

RSIOBJNM

CHAR

OBJCAP

Description

RRTDSCRPTN

CHAR

FIELDNM

Field Name InfoObject In Structures (Not in database table)

RSDIOBJFIELDNM

CHAR

DTELNM

Data element (semantic domain)

ROLLNAME

DD04L

CHAR

DTELNM_DB

Data element (semantic domain)

ROLLNAME

CHAR

CHKTAB

View of master data tables

RSDCHKVIEW

CHAR

DATATP

Data Type in ABAP Dictionary

DATATYPE_D

CHAR

Possible values

ACCP	Posting period YYYYMM
CHAR	Character String
CLNT	Client
CUKY	Currency key, referenced by CURR fields
CURR	Currency field, stored as DEC
D16D	Decimal Floating Point, 16 Digits, DEC on Database
D16R	Decimal Floating Point, 16 Digits, RAW on Database
D16S	Decimal Floating Point. 16 Digits, with Scale Field
D34D	Decimal Floating Point, 34 Digits, DEC on Database
D34R	Decimal Floating Point, 34 Digits, RAW on Database
D34S	Decimal Floating Point, 34 Digits, with Scale Field
DATS	Date field (YYYYMMDD) stored as char(8)
DEC	Counter or amount field with comma and sign
FLTP	Floating point number, accurate to 8 bytes
INT1	1-byte integer, integer number <= 255
INT2	2-byte integer, only for length field before LCHR or LRAW
INT4	4-byte integer, integer number with sign
LANG	Language key
LCHR	Long character string, requires preceding INT2 field
LRAW	Long byte string, requires preceding INT2 field
NUMC	Character string with only digits
PREC	Obsolete data type, do not use
QUAN	Quantity field, points to a unit field with format UNIT
RAW	Uninterpreted sequence of bytes
RSTR	Byte String of Variable Length
SSTR	Short Character String of Variable Length
STRG	Character String of Variable Length
TIMS	Time field (hhmmss), stored as char(6)
UNIT	Unit key for QUAN fields
VARC	Long character string, no longer supported from Rel. 3.0

INTLEN

Internal Length of InfoObjects in BW - see Docu

RSDINTLEN

NUMC

OUTPUTLEN

Output Length

OUTPUTLEN

NUMC

CONVEXIT

Conversion Routine

CONVEXIT

CHAR

FVALEX

Domain fixed values exist (flag)

RSFVALEX

CHAR

Possible values

X	Yes
NULL	No

LOWERCASE

Lowercase letters allowed/not allowed

LOWERCASE

CHAR

Possible values

NULL	Do not set flag
X	Set flag

INTTP

ABAP data type (C,D,N,...)

INTTYPE

CHAR

Possible values

C	Character String
N	Character String with Digits Only
D	Date (Date: YYYYMMDD)
T	Time (Time: HHMMSS)
X	Byte Seq. (heXadecimal), in DDIC metadata also for INT1/2/4
I	Integer number (4-byte integer with sign)
b	1-byte integer, integer number <= 254
s	2-byte integer, only for length field before LCHR or LRAW
P	Packed number
F	Floating point number to accuracy of 8 bytes
g	Character string with variable length (ABAP type STRING)
y	Byte sequence with variable length (ABAP type XSTRING)
u	Structured type, flat
v	Structured type, deep
h	Table type
V	Character string (old Dictionary type VARC)
r	Reference to class/interface
l	Reference to data object
a	Decimal Floating Point Number, 16 Digits
e	Decimal Floating Point Number, 34 Digits
j	Static Boxed Components
k	Generic Boxed Components

DECIMALS

Number of Decimal Places

DECIMALS

NUMC

DIGITS

Number of Characters in Field

RSDIGITS

NUMC

POSIT

Position of the Field in the Structure / Table

RSPOSIT

NUMC

MASK

Template (not used)

AS4MASK

CHAR

MASKLEN

Template length (not used)

MASKLEN

NUMC

BYTELENG

Internal Length in Bytes

INTLEN

NUMC

KYFTP

Key figure type

RSKYFTP

CHAR

Possible values

AMO	Amount
QUA	Quantity
NUM	Number (without unit)
INT	Whole number
FLO	Floating point number (without unit)
DAT	Date
TIM	Time

NCUMFL

Non-cumulative value (flag)

RSNCUMFL

CHAR

Possible values

NULL	Cumulative value
1	Stock with change involving stocks
2	Stock with inward and outward movement

FIXCUKY

Fixed currency

RSFIXCUKY

TCURC

CUKY

FIXUNIT

Fixed Unit of Measure

RSFIXUNIT

T006

UNIT

AGGRGEN

Usual Aggregation

RSDAGGRGEN

CHAR

Possible values

MAX	Maximum
MIN	Minimum
SUM	Summation
NOP	No Longer Used
NO1	No Longer Used
NO2	No Longer Used

AGGREXC

Exception Aggregation

RSDAGGREXC

CHAR

Possible values

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
MIN	Minimum
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)
STD	Standard Deviation
SUM	Summation
VAR	Variance
NHA	No Aggregation Along Hierarchy
NGA	No Aggregation of Postable Nodes Along Hierarchy

AGGRCHA

Reference characteristic for exception aggregation

RSAGGRCHA

RSDIOBJ

CHAR

KYFDECIM

Decimal places (of a key figure)

RSKYFDECIM

CHAR

Possible values

NULL	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)

RSKYFPRSNT

CHAR

Possible values

NULL	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

RSKYFNAV

CHAR

Possible values

NULL	Not assigned
0	Permitted without restrictions
1	Must be selected
2	Not allowed

UNINM

Unit InfoObject (currency/unit)

RSUNINM

RSDUNI

CHAR

DOMANM

Domain name

DOMNAME

CHAR

PACKFL

Process key figure with high precision

RSDHIGHPRECFL

CHAR

Possible values

NULL	False
X	True

RSCRMKYFDETAIL foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
RSCRMKYFDETAIL	AGGRCHA	RSCRMKYFDETAIL	AGGRCHA	RSDIOBJ	Directory of all InfoObjects	IOBJNM
RSCRMKYFDETAIL	AGGRCHA	*		RSDIOBJ	Directory of all InfoObjects	OBJVERS
RSCRMKYFDETAIL	DTELNM	RSCRMKYFDETAIL	DTELNM	DD04L	Data elements	ROLLNAME
RSCRMKYFDETAIL	DTELNM	*		DD04L	Data elements	AS4LOCAL
RSCRMKYFDETAIL	DTELNM	*		DD04L	Data elements	AS4VERS
RSCRMKYFDETAIL	FIXCUKY	*		TCURC	Currency Codes	MANDT
RSCRMKYFDETAIL	FIXCUKY	RSCRMKYFDETAIL	FIXCUKY	TCURC	Currency Codes	WAERS
RSCRMKYFDETAIL	FIXUNIT	*		T006	Units of Measurement	MANDT
RSCRMKYFDETAIL	FIXUNIT	RSCRMKYFDETAIL	FIXUNIT	T006	Units of Measurement	MSEHI
RSCRMKYFDETAIL	UNINM	RSCRMKYFDETAIL	UNINM	RSDUNI	Units	UNINM
RSCRMKYFDETAIL	UNINM	*		RSDUNI	Units	OBJVERS