1. Home
  2. Resources
  3. SAP Tables
  4. DD27S - Fields in an Aggregate (View, MC Object, Lock Object)

SAP Table DD27S

Fields in an Aggregate (View, MC Object, Lock Object)

DD27S (Fields in an Aggregate (View, MC Object, Lock Object)) 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 DD27S to other SAP tables.

DD27S table fields

Field Data element Checktable Datatype Length Decimals
VIEWNAME Name of SAP table view VIEWNAME DD25L CHAR 30 0
AS4LOCAL Activation Status of a Repository Object AS4LOCAL CHAR 1 0
A Entry activated or generated in this form
L Lock entry (first N version)
N Entry edited, but not activated
S Previously active entry, backup copy
T Temporary version when editing
OBJPOS Position in a repetition group MCPOS NUMC 4 0
AS4VERS Version of view VIEWVERS NUMC 4 0
VIEWFIELD ABAP Dictionary: Name of view field VIEWFIELD CHAR 30 0
TABNAME Base table of a view VIBASTAB CHAR 30 0
FIELDNAME Base field VIBASFLD CHAR 30 0
KEYFLAG Flag for field belonging to key area VIKEYFLAG CHAR 1 0
NULL No key field
X Key field
MCFIELDID Matchcode field ID MCFIELDID CHAR 3 0
EFORM Name of ABAP form FORMROUT CHAR 16 0
ROLLNAME Data element (semantic domain) ROLLNAME DD04L CHAR 30 0
ENQMODE Lock mode ENQMODE CHAR 1 0
E Write Lock
S Read Lock
X Exclusive, not cumulative
O Set Optimistic Lock
R Promote Optimistic Lock; Conversion from '0' to 'E'
U Only Collision Check Extended Write Lock, as with 'X'
V Only Collision Check Write Lock, as with 'E'
W Only Collision Check Read Lock, as with 'S'
C Only Promotion Check Opt. Lock, as with 'R'
T Reserved
+ Reserved
RDONLY Maintenance attribute for view field VFLDROFLAG CHAR 1 0
NULL View field is available as normal
R View field can only be read
S View field is used to form subsets
H View field is not transferred to the maintenance screens
ROLLCHANGE Indicator for change to data element ROLLCHANGE CHAR 1 0
X Yes / TRUE
NULL No / FALSE
DBVIEWFIELD DD: Concatenated Field Name DDFIELDNAME_L CHAR 256 0
EXVDATATYPE 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
EXVFLENGTH Length (No. of Characters) DDLENG NUMC 6 0
EXVDECIMALS Number of Decimal Places DECIMALS NUMC 6 0

DD27S foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DD27S ROLLNAME DD27S ROLLNAME DD04L Data elements ROLLNAME
DD27S ROLLNAME * DD04L Data elements AS4LOCAL
DD27S ROLLNAME * DD04L Data elements AS4VERS
DD27S VIEWNAME DD27S VIEWNAME DD25L Aggregate Header (Views, MC Objects, Lock Objects) VIEWNAME
DD27S VIEWNAME * DD25L Aggregate Header (Views, MC Objects, Lock Objects) AS4LOCAL
DD27S VIEWNAME * DD25L Aggregate Header (Views, MC Objects, Lock Objects) AS4VERS