DD03VT
Generated Table for View
DD03VT is an SAP database table in S/4HANA. Generated Table for View. It contains 33 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ChangeDocFieldDDIC | view | from | Texte für Tabellenfelder aus dem DDIC | |
| I_ChangeDocFieldNames | view | from | BASIC | Feldnamen |
| I_ChangeDocFieldNamesT | view | from | BASIC | Text für Feldnamen |
| I_PubSecSplitRuleFldNameText | view | from | BASIC | Distribution Rule Field Name - Text |
Fields (33)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | tabname | TABNAME | Table Name | |||
| KEY | fieldname | FIELDNAME | Field Name | |||
| KEY | as4local | AS4LOCAL | Activation State | |||
| KEY | tabclass | TABCLASS | Table Category | |||
| KEY | sqltab | SQLAPPDTAB | Pool/Cluster | |||
| KEY | position | TABFDPOS | Table position | |||
| KEY | keyflag | KEYFLAG | Key field | |||
| KEY | mandatory | MANDATORY | Required Field | |||
| KEY | rollname | ROLLNAME | Data Element | |||
| KEY | domname | DOMNAME | Domain | |||
| KEY | checktable | CHECKTABLE | Check table | |||
| KEY | adminfield | ADMINFIELD | Admin. field | |||
| KEY | inttype | INTTYPE | ABAP type | |||
| KEY | intlen | INTLEN | Internal Length | |||
| KEY | reftable | REFTABLE | Reference table | |||
| KEY | precfield | PRECFIELD | Name of include | |||
| KEY | reffield | REFFIELD | Ref. field | |||
| KEY | conrout | CONROUT | Check module | |||
| KEY | notnull | NOTNULL | NOT NULL forced | |||
| KEY | leng | DDLENG | No. of Characters | |||
| KEY | datatype | DATATYPE_D | Data Type | |||
| KEY | comptype | COMPTYPE | CompTyp | |||
| KEY | tabletype | DDTABTYPE | Table | |||
| KEY | depth | TYPEDEPTH | Depth | |||
| KEY | as4user | AS4USER | Last Changed By | |||
| KEY | as4date | AS4DATE | Date | |||
| KEY | masterlang | MASTERLANG | Original Lang. | |||
| KEY | ddlanguage | DDLANGUAGE | Lang. | |||
| 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 DD03VT (
TABNAME, -- Table Name [TABNAME]
FIELDNAME, -- Field Name [FIELDNAME]
AS4LOCAL, -- Activation State [AS4LOCAL]
TABCLASS, -- Table Category [TABCLASS]
SQLTAB, -- Pool/Cluster [SQLAPPDTAB]
POSITION, -- Table position [TABFDPOS]
KEYFLAG, -- Key field [KEYFLAG]
MANDATORY, -- Required Field [MANDATORY]
ROLLNAME, -- Data Element [ROLLNAME]
DOMNAME, -- Domain [DOMNAME]
CHECKTABLE, -- Check table [CHECKTABLE]
ADMINFIELD, -- Admin. field [ADMINFIELD]
INTTYPE, -- ABAP type [INTTYPE]
INTLEN, -- Internal Length [INTLEN]
REFTABLE, -- Reference table [REFTABLE]
PRECFIELD, -- Name of include [PRECFIELD]
REFFIELD, -- Ref. field [REFFIELD]
CONROUT, -- Check module [CONROUT]
NOTNULL, -- NOT NULL forced [NOTNULL]
LENG, -- No. of Characters [DDLENG]
DATATYPE, -- Data Type [DATATYPE_D]
COMPTYPE, -- CompTyp [COMPTYPE]
TABLETYPE, -- Table [DDTABTYPE]
DEPTH, -- Depth [TYPEDEPTH]
AS4USER, -- Last Changed By [AS4USER]
AS4DATE, -- Date [AS4DATE]
MASTERLANG, -- Original Lang. [MASTERLANG]
DDLANGUAGE, -- Lang. [DDLANGUAGE]
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 (TABNAME, FIELDNAME, AS4LOCAL, TABCLASS, SQLTAB, POSITION, KEYFLAG, MANDATORY, ROLLNAME, DOMNAME, CHECKTABLE, ADMINFIELD, INTTYPE, INTLEN, REFTABLE, PRECFIELD, REFFIELD, CONROUT, NOTNULL, LENG, DATATYPE, COMPTYPE, TABLETYPE, DEPTH, AS4USER, AS4DATE, MASTERLANG, DDLANGUAGE, 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