DD27S

Transparent Table System Table (transport)
19 Fields 6 CDS Views

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

DD27S is an SAP database table in S/4HANA. Fields in an Aggregate (View, MC Object, Lock Object). It contains 19 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
/dmbe/i_CDS_Field_Name view from Fields in an Aggregate (View, MC Object, Lock Object)
I_BusEvtLogCDSViewDetail view_entity inner BASIC BEL Core Data Services Details
I_EngmntProjFieldMapChgDoc view from BASIC Field Mapping for Engagement Prj Chg Doc
I_EntProjFieldMapChgDoc view from BASIC Field mapping for change document extractor
P_FieldMappingReqdForChangeDoc view from CONSUMPTION Field mapping required for Change documents item extractor
P_ProjectFieldMappingForChgDoc view from BASIC Project/WBS Mapping Fields for Chg Doc

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY viewname VIEWNAME View Name
KEY as4local AS4LOCAL Activation State
KEY objpos MCPOS Position in a repetition group
KEY as4vers VIEWVERS Version
viewfield VIEWFIELD View field
tabname VIBASTAB Basis Table
fieldname VIBASFLD Base field
keyflag VIKEYFLAG Key field
mcfieldid MCFIELDID Field ID
eform FORMROUT Form
rollname ROLLNAME Data Element
enqmode ENQMODE Lock mode
rdonly VFLDROFLAG Maint. flag
rollchange ROLLCHANGE Data el. chang.
dbviewfield DDFIELDNAME_L DD: Concatenated Field Name
exvdatatype DATATYPE_D Data Type
exvflength DDLENG No. of Characters
exvdecimals DECIMALS Decimal Places
sql_passvalue DDSQLPASSVALUE SQL Pass Value

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Fields in an Aggregate (View, MC Object, Lock Object)
-- Category TRANSPARENT · Delivery class W
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DD27S (
    VIEWNAME,       -- View Name [VIEWNAME]
    AS4LOCAL,       -- Activation State [AS4LOCAL]
    OBJPOS,         -- Position in a repetition group [MCPOS]
    AS4VERS,        -- Version [VIEWVERS]
    VIEWFIELD,      -- View field [VIEWFIELD]
    TABNAME,        -- Basis Table [VIBASTAB]
    FIELDNAME,      -- Base field [VIBASFLD]
    KEYFLAG,        -- Key field [VIKEYFLAG]
    MCFIELDID,      -- Field ID [MCFIELDID]
    EFORM,          -- Form [FORMROUT]
    ROLLNAME,       -- Data Element [ROLLNAME]
    ENQMODE,        -- Lock mode [ENQMODE]
    RDONLY,         -- Maint. flag [VFLDROFLAG]
    ROLLCHANGE,     -- Data el. chang. [ROLLCHANGE]
    DBVIEWFIELD,    -- DD: Concatenated Field Name [DDFIELDNAME_L]
    EXVDATATYPE,    -- Data Type [DATATYPE_D]
    EXVFLENGTH,     -- No. of Characters [DDLENG]
    EXVDECIMALS,    -- Decimal Places [DECIMALS]
    SQL_PASSVALUE,  -- SQL Pass Value [DDSQLPASSVALUE]
    PRIMARY KEY (VIEWNAME, AS4LOCAL, OBJPOS, AS4VERS)
);

Learn More