DD27M

Generated Table for View

DD27M is an SAP database table in S/4HANA. Generated Table for View. It contains 41 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SAIS_DOBJ_FLD_F4 view union Generic Audit Filter - Fields in Data Object

Fields (41)

KeyField Data ElementDescription DomainTypeLength
KEY viewname VIEWNAME View Name
KEY as4local AS4LOCAL Activation State
KEY objpos MCPOS Position in a repetition group
KEY ddlanguage DDLANGUAGE Lang.
KEY viewfield VIEWFIELD View field
KEY tabname VIBASTAB Basis Table
KEY fieldname VIBASFLD Base field
KEY keyflag VIKEYFLAG Key field
KEY mcfieldid MCFIELDID Field ID
KEY eform FORMROUT Form
KEY rollname ROLLNAME Data Element
KEY rollname27 ROLLNAME Data Element
KEY rollchange ROLLCHANGE Data el. chang.
KEY enqmode ENQMODE Lock mode
KEY rdonly VFLDROFLAG Maint. flag
KEY memoryid MEMORYID Parameter ID
KEY domname DOMNAME Domain
KEY datatype DATATYPE_D Data Type
KEY flength DDLENG No. of Characters
KEY checktable CHECKTABLE Check table
KEY reftable REFTABLE Reference table
KEY reffield REFFIELD Ref. field
KEY entitytab ENTITYTAB Value table
KEY inttype INTTYPE ABAP type
KEY intlen INTLEN Internal Length
KEY logflag LOGFLAG Change document
KEY headlen HEADLEN Header
KEY scrlen1 SCRLEN_S ShortFieldLabelLen
KEY scrlen2 SCRLEN_M Med.FieldLabelLen.
KEY scrlen3 SCRLEN_L LongFieldLabelLen.
KEY outputlen OUTPUTLEN Output Length
KEY decimals DECIMALS Decimal Places
KEY lowercase LOWERCASE Case-Sensitive
KEY signflag SIGNFLAG Sign
KEY valexi VALEXI Fixed val. ex.
KEY convexit CONVEXIT Convers. Rout.
KEY ddtext AS4TEXT Short Description
KEY reptext REPTEXT Heading
KEY scrtext_s SCRTEXT_S ShortFieldLabel
KEY scrtext_m SCRTEXT_M Medium Label
KEY scrtext_l SCRTEXT_L Long Fld Label

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DD27M (
    VIEWNAME,    -- View Name [VIEWNAME]
    AS4LOCAL,    -- Activation State [AS4LOCAL]
    OBJPOS,      -- Position in a repetition group [MCPOS]
    DDLANGUAGE,  -- Lang. [DDLANGUAGE]
    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]
    ROLLNAME27,  -- Data Element [ROLLNAME]
    ROLLCHANGE,  -- Data el. chang. [ROLLCHANGE]
    ENQMODE,     -- Lock mode [ENQMODE]
    RDONLY,      -- Maint. flag [VFLDROFLAG]
    MEMORYID,    -- Parameter ID [MEMORYID]
    DOMNAME,     -- Domain [DOMNAME]
    DATATYPE,    -- Data Type [DATATYPE_D]
    FLENGTH,     -- No. of Characters [DDLENG]
    CHECKTABLE,  -- Check table [CHECKTABLE]
    REFTABLE,    -- Reference table [REFTABLE]
    REFFIELD,    -- Ref. field [REFFIELD]
    ENTITYTAB,   -- Value table [ENTITYTAB]
    INTTYPE,     -- ABAP type [INTTYPE]
    INTLEN,      -- Internal Length [INTLEN]
    LOGFLAG,     -- Change document [LOGFLAG]
    HEADLEN,     -- Header [HEADLEN]
    SCRLEN1,     -- ShortFieldLabelLen [SCRLEN_S]
    SCRLEN2,     -- Med.FieldLabelLen. [SCRLEN_M]
    SCRLEN3,     -- LongFieldLabelLen. [SCRLEN_L]
    OUTPUTLEN,   -- Output Length [OUTPUTLEN]
    DECIMALS,    -- Decimal Places [DECIMALS]
    LOWERCASE,   -- Case-Sensitive [LOWERCASE]
    SIGNFLAG,    -- Sign [SIGNFLAG]
    VALEXI,      -- Fixed val. ex. [VALEXI]
    CONVEXIT,    -- Convers. Rout. [CONVEXIT]
    DDTEXT,      -- Short Description [AS4TEXT]
    REPTEXT,     -- Heading [REPTEXT]
    SCRTEXT_S,   -- ShortFieldLabel [SCRTEXT_S]
    SCRTEXT_M,   -- Medium Label [SCRTEXT_M]
    SCRTEXT_L,   -- Long Fld Label [SCRTEXT_L]
    PRIMARY KEY (VIEWNAME, AS4LOCAL, OBJPOS, DDLANGUAGE, VIEWFIELD, TABNAME, FIELDNAME, KEYFLAG, MCFIELDID, EFORM, ROLLNAME, ROLLNAME27, ROLLCHANGE, ENQMODE, RDONLY, MEMORYID, DOMNAME, DATATYPE, FLENGTH, CHECKTABLE, REFTABLE, REFFIELD, ENTITYTAB, INTTYPE, INTLEN, LOGFLAG, HEADLEN, SCRLEN1, SCRLEN2, SCRLEN3, OUTPUTLEN, DECIMALS, LOWERCASE, SIGNFLAG, VALEXI, CONVEXIT, DDTEXT, REPTEXT, SCRTEXT_S, SCRTEXT_M, SCRTEXT_L)
);