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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_SAIS_DOBJ_FLD_F4 | view | union | Generic Audit Filter - Fields in Data Object |
Fields (41)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA