1. Home
  2. Resources
  3. SAP Tables
  4. UGMD2040 - FIN Master Data: Definition of BW Info Objects

SAP Table UGMD2040

FIN Master Data: Definition of BW Info Objects

UGMD2040 (FIN Master Data: Definition of BW Info Objects) 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 UGMD2040 to other SAP tables.

UGMD2040 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
RFCDEST Logical Destination (Specified in Function Call) RFCDEST CHAR 32 0
INFOOBJECT InfoObject RSIOBJNM CHAR 30 0
TIMESTMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15 0
TYPE Type of an InfoObject RSIOBJTP CHAR 3 0
CHA Characteristic
KYF Key figure
TIM Time characteristic
DPA Data packet characteristic
UNI Unit of measurement
TEXTSHORT Short description RSTXTSH CHAR 20 0
TEXTLONG Long description RSTXTLG CHAR 60 0
CHABASNM Reference characteristic RSCHABASNM CHAR 30 0
NOVALFL Characteristic does not have a check table RSNOVALFL CHAR 1 0
X Yes
NULL No
TIMDEPFL Flag: Master data is time-dependent RSTIMDEPFL CHAR 1 0
X Yes
NULL No
NOLANGU Master data texts are language independent (flag) RSNOLANGU CHAR 1 0
X Yes
NULL No
TXTSHFL Short text exists (flag) RSTXTSHFL CHAR 1 0
X Yes
NULL No
TXTMDFL Medium length text exists (flag) RSTXTMDFL CHAR 1 0
X Yes
NULL No
TXTLGFL Long text exists (flag) RSTXTLGFL CHAR 1 0
X Yes
NULL No
HIETABFL Characteristic with hierarchies RSHIETABFL CHAR 1 0
X Yes
NULL No
HIEVERFL Hierarchies can have several versions RSHIEVERFL CHAR 1 0
X Yes
NULL No
HIENMTFL Complete Hierarchy Is Time-Dependent UG_HIENMTFL CHAR 1 0
X Yes
NULL No
HIENDTFL Hierarchy structure is time-dependent RSHIENDTFL CHAR 1 0
X Yes
NULL No
DATATP Data Type in ABAP Dictionary DATATYPE_D CHAR 4 0
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 in Bytes INTLEN NUMC 6 0
CONVEXIT Conversion Routine CONVEXIT CHAR 5 0
FVALEX Fixed Values for Domains Exist (indicator) UG_FVALEX CHAR 1 0
X Yes
NULL No
LOWERCASE Lowercase letters allowed/not allowed LOWERCASE CHAR 1 0
NULL Do not set flag
X Set flag
KYFTP Key figure type RSKYFTP CHAR 3 0
AMO Amount
QUA Quantity
NUM Number (without unit)
INT Whole number
FLO Floating point number (without unit)
DAT Date
TIM Time
FIXCUKY Fixed currency RSFIXCUKY CUKY 5 0
FIXUNIT Fixed Unit of Measure RSFIXUNIT UNIT 3 0
DECIMALS Number of Decimal Places DECIMALS NUMC 6 0
UNINM Unit InfoObject (currency/unit) RSUNINM CHAR 30 0
TXTTIMFL Indicator: Texts Are Time-Dependent UG_TXTTIMFL CHAR 1 0
NULL Undefined
0 No
1 Yes
TXTTABFL Single-Character Indicator CHAR1 CHAR 1 0
OUTPUTLEN Output Length OUTPUTLEN NUMC 6 0
ATRONLYFL InfoObject is Exclusively an Attribute (Not Used in ICs) UG_RSATRONLYFL CHAR 1 0
X Yes
NULL No
CHNTAB Table Name TABNAME CHAR 30 0
CHTTAB Table Name TABNAME CHAR 30 0
TXTTAB Table Name TABNAME CHAR 30 0
AGGRGEN Usual aggregation RSAGGRGEN CHAR 3 0
MAX Maximum
MIN Minimum
MIN Minimum
NGA No Hierarchy Aggregation (Only to be Used Internally)
NHA No Hierarchy Aggregation (Only to be Used Internally)
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)
AGGREXC Exception aggregation RSAGGREXC CHAR 3 0
AV0 Average (values not equal to zero)
AV1 Average (weighted with the 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
AGGRCHA Reference characteristic for exception aggregation RSAGGRCHA CHAR 30 0