TDWA
Document Types
TDWA is an SAP database table in S/4HANA. Document Types. It contains 36 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FCLM_BAM_DM_ATTR | view | inner | Active Company Code List of FI | |
| I_DocInfoRecdDocumentType | view | from | BASIC | Document Type Value Help |
| I_DocumentInfoRecordDocType | view | from | BASIC | Document Info Record Document Type |
| I_DocumentInfoRecordDocTypeVH | view | from | BASIC | Document Info Record Document Type VH |
| SHSM_TDWA | view | from |
Fields (36)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | dokar | DOKAR | Document Type | |||
| fldsl | FLDSL | Field selection | ||||
| staen | STAEN | Status Change | ||||
| projb | RLVFLAG | Rev. Assgmt | ||||
| alphn | ALPHN | VersNumIncr. | ||||
| vervg | VERVG | Version Assgmt | ||||
| numvg | NUMVG | Number Assgmt | ||||
| inumnr | INUMNR | IntNum range | ||||
| enumnr | ENUMNR | Ext.No.range | ||||
| aenbl | AENBL | Change Docs | ||||
| archf | ARCHF | ArchAuth | ||||
| altdy | ALTDY | Alt screen | ||||
| adyprog | ADYPROG | AScEx. | ||||
| znrprog | DZNRPROG | NumExit | ||||
| fhmdk | FHMDK | PRT | ||||
| filelen | FILELEN | File size | ||||
| klasse | KLASSE_D | Class | ||||
| klassenart | KLASSENART | Class Type | ||||
| orig_del | ORIG_DEL | Delete Original | ||||
| orig_dstrb | ORIG_DSTRB | Transport origin. | ||||
| kpro_use | DMS_KPRO_USE | Use KPro | ||||
| def_application | DMS_DEFAULT_APPLICATION | Default Appl. | ||||
| dist_application | DMS_DIST_APPLICATION | Dis. WS applic. | ||||
| new_vers_ignore | DMS_FILE_NEW_VERSION_IGNORE | Ignore originals | ||||
| cm_relevance | DE_CM_RELEVANCE_FLAG | CM Relevant | ||||
| dokvr_inc | DMS_VERSION_INCREMENT | VersionSequence | ||||
| acm_use | DMS_ACM_USE | Use ACM | ||||
| acm_enable_objec | DMS_ACM_ENABLE_OBJECT_LINKS | Displ. ObjLinks | ||||
| ds_use | DMS_DS_USE | Use DS Package | ||||
| isrestricedtoonemainfile | DMS_ISRESTRICEDTOONEMAINFILE | One Main File | ||||
| set_lck_sts | SET_LCK_STS | Set Lock Status | ||||
| version_limit | DMS_VERSION_LIMIT | Ver. Limit | ||||
| ver_limit_msg | DMS_VER_LIMIT_MSG | Display Message | ||||
| new_ver_cntrl | DMS_NEW_VER_CNTRL | Block new version | ||||
| configdeprecationcode | CONFIG_DEPRECATION_CODE | Validity |
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.
-- Document Types
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TDWA (
MANDT, -- Client [MANDT]
DOKAR, -- Document Type [DOKAR]
FLDSL, -- Field selection [FLDSL]
STAEN, -- Status Change [STAEN]
PROJB, -- Rev. Assgmt [RLVFLAG]
ALPHN, -- VersNumIncr. [ALPHN]
VERVG, -- Version Assgmt [VERVG]
NUMVG, -- Number Assgmt [NUMVG]
INUMNR, -- IntNum range [INUMNR]
ENUMNR, -- Ext.No.range [ENUMNR]
AENBL, -- Change Docs [AENBL]
ARCHF, -- ArchAuth [ARCHF]
ALTDY, -- Alt screen [ALTDY]
ADYPROG, -- AScEx. [ADYPROG]
ZNRPROG, -- NumExit [DZNRPROG]
FHMDK, -- PRT [FHMDK]
FILELEN, -- File size [FILELEN]
KLASSE, -- Class [KLASSE_D]
KLASSENART, -- Class Type [KLASSENART]
ORIG_DEL, -- Delete Original [ORIG_DEL]
ORIG_DSTRB, -- Transport origin. [ORIG_DSTRB]
KPRO_USE, -- Use KPro [DMS_KPRO_USE]
DEF_APPLICATION, -- Default Appl. [DMS_DEFAULT_APPLICATION]
DIST_APPLICATION, -- Dis. WS applic. [DMS_DIST_APPLICATION]
NEW_VERS_IGNORE, -- Ignore originals [DMS_FILE_NEW_VERSION_IGNORE]
CM_RELEVANCE, -- CM Relevant [DE_CM_RELEVANCE_FLAG]
DOKVR_INC, -- VersionSequence [DMS_VERSION_INCREMENT]
ACM_USE, -- Use ACM [DMS_ACM_USE]
ACM_ENABLE_OBJEC, -- Displ. ObjLinks [DMS_ACM_ENABLE_OBJECT_LINKS]
DS_USE, -- Use DS Package [DMS_DS_USE]
ISRESTRICEDTOONEMAINFILE, -- One Main File [DMS_ISRESTRICEDTOONEMAINFILE]
SET_LCK_STS, -- Set Lock Status [SET_LCK_STS]
VERSION_LIMIT, -- Ver. Limit [DMS_VERSION_LIMIT]
VER_LIMIT_MSG, -- Display Message [DMS_VER_LIMIT_MSG]
NEW_VER_CNTRL, -- Block new version [DMS_NEW_VER_CNTRL]
CONFIGDEPRECATIONCODE, -- Validity [CONFIG_DEPRECATION_CODE]
PRIMARY KEY (MANDT, DOKAR)
);
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