SAP Table SADD

SAPaccess: data for DDIC structures

SADD (SAPaccess: data for DDIC structures) 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 SADD to other SAP tables.

SADD table fields

Field

Data element

Checktable

Datatype

Length

Decimals

Possible values

FLDNAM

SAPaccess: field name of a DDIC structure

SA_FLDNAM

CHAR

FLDKEY

Identifies a key field of a table

KEYFLAG

CHAR

Value	Description
NULL	No key field
X	Key field

FLDETP

Data Type in ABAP Dictionary

DATATYPE_D

CHAR

Value	Description
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

FLDITP

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

INTTYPE

CHAR

Value	Description
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

FLDLNG

SAPaccess: internal length of a field

SA_INTLNG

CHAR

DDTEXT

Short Description of Repository Objects

AS4TEXT

CHAR