SAP Table UGMD_SCDT_S_FPROP

Description of a Field in Field Catalog

UGMD_SCDT_S_FPROP (Description of a Field in Field Catalog) 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 UGMD_SCDT_S_FPROP to other SAP tables.

UGMD_SCDT_S_FPROP table fields

Field

Data element

Checktable

Datatype

Length

Decimals

TABNAME

Table Name

TABNAME

CHAR

FIELDNAME

Field Name

FIELDNAME

CHAR

ORG_TABNAME

Table Name

TABNAME

CHAR

ORG_FIELDNAME

Field Name

FIELDNAME

CHAR

LANGU

Language Key

DDLANGUAGE

LANG

POSITION

Position of the field in the table

TABFDPOS

NUMC

OFFSET

Offset of a field

DOFFSET

NUMC

DOMNAME

Domain name

DOMNAME

CHAR

ROLLNAME

Data element (semantic domain)

ROLLNAME

CHAR

CHECKTABLE

Table Name

TABNAME

CHAR

LENG

Length (No. of Characters)

DDLENG

NUMC

INTLEN

Internal Length in Bytes

INTLEN

NUMC

OUTPUTLEN

Output Length

OUTPUTLEN

NUMC

DECIMALS

Number of Decimal Places

DECIMALS

NUMC

DATATYPE

ABAP/4 Dictionary: Screen data type for Screen Painter

DYNPTYPE

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

INTTYPE

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

REFTABLE

Table for reference field

REFTABLE

CHAR

REFFIELD

Reference field for currency and qty fields

REFFIELD

CHAR

PRECFIELD

Name of included table

PRECFIELD

CHAR

AUTHORID

Authorization class

AUTHORID

CHAR

MEMORYID

Set/Get parameter ID

MEMORYID

CHAR

LOGFLAG

Indicator for writing change documents

LOGFLAG

CHAR

Possible values

NULL	Do not set flag
X	Set flag

MASK

Template (not used)

AS4MASK

CHAR

MASKLEN

Template length (not used)

MASKLEN

NUMC

CONVEXIT

Conversion Routine

CONVEXIT

CHAR

HEADLEN

Maximum length of heading

HEADLEN

NUMC

SCRLEN1

Max. length for short field label

SCRLEN_S

NUMC

SCRLEN2

Max. length for medium field label

SCRLEN_M

NUMC

SCRLEN3

Max. length for long field label

SCRLEN_L

NUMC

FIELDTEXT

Short Description of Repository Objects

AS4TEXT

CHAR

REPTEXT

Heading

REPTEXT

CHAR

SCRTEXT_S

Short Field Label

SCRTEXT_S

CHAR

SCRTEXT_M

Medium Field Label

SCRTEXT_M

CHAR

SCRTEXT_L

Long Field Label

SCRTEXT_L

CHAR

KEYFLAG

Identifies a key field of a table

KEYFLAG

CHAR

Possible values

NULL	No key field
X	Key field

LOWERCASE

Lowercase letters allowed/not allowed

LOWERCASE

CHAR

Possible values

NULL	Do not set flag
X	Set flag

MAC

Flag if search help is attached to the field

DDSHATTACH

CHAR

Possible values

NULL	FALSE
X	TRUE

GENKEY

Flag (X or Blank)

AS4FLAG

CHAR

Possible values

NULL	Do not set flag
X	Set flag

NOFORKEY

Flag (X or Blank)

AS4FLAG

CHAR

Possible values

NULL	Do not set flag
X	Set flag

VALEXI

Existence of fixed values

VALEXI

CHAR

Possible values

NULL	Do not set flag
X	Set flag

NOAUTHCH

Flag (X or Blank)

AS4FLAG

CHAR

Possible values

NULL	Do not set flag
X	Set flag

SIGN

Flag for sign in numerical fields

SIGNFLAG

CHAR

Possible values

NULL	Do not set flag
X	Set flag

DYNPFLD

Flag: field to be displayed on the screen

DYNPROFLD

CHAR

Possible values

NULL	Do not set flag
X	Set flag

F4AVAILABL

Does the field have an input help

DDF4AVAIL

CHAR

Possible values

NULL	FALSE
X	TRUE

COMPTYPE

DD: Component Type

COMPTYPE

CHAR

Possible values

E	Data element
NULL	Built-in type
S	Structured type (possibly as INCLUDE)
L	Table type
N	Reference to non-active type

LFIELDNAME

Field name

FNAM_____4

CHAR

132