DDTBFDCHK SAP (Control String for Table Checks (Fields)) Structure details
Description: Control String for Table Checks (Fields)
Structure field list including key, data, relationships and ABAP select examples
DDTBFDCHK is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Control String for Table Checks (Fields)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_DDTBFDCHK TYPE DDTBFDCHK.
The DDTBFDCHK table consists of various fields, each holding specific information or linking keys about Control String for Table Checks (Fields) data available in SAP. These include SAA_SPACE (Test: Does name exist?), SAA_LENGTH (Test: Is name too long?), SAA_CSPACE (Test: Does name contain blanks?), SAA_HYPHEN (Test: Does name contain '-'?).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP DDTBFDCHK structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
FIELDEX | Test: Does the table contain any fields? | DCTBFD0012 | CHAR | 6 | DD_CHECK | ||||
SAA_SPACE | Test: Does name exist? | DCSAAN0001 | CHAR | 6 | DD_CHECK | ||||
SAA_LENGTH | Test: Is name too long? | DCSAAN0002 | CHAR | 6 | DD_CHECK | ||||
SAA_CSPACE | Test: Does name contain blanks? | DCSAAN0003 | CHAR | 6 | DD_CHECK | ||||
SAA_HYPHEN | Test: Does name contain '-'? | DCSAAN0004 | CHAR | 6 | DD_CHECK | ||||
SAA_1CHBAZ | Test: Does name start with a letter? | DCSAAN0005 | CHAR | 6 | DD_CHECK | ||||
SAA_1CHUYZ | Open | DCSAAN0006 | CHAR | 6 | DD_CHECK | ||||
SAA_ALPHAN | Test: Does name contain only allowed characters? | DCSAAN0007 | CHAR | 6 | DD_CHECK | ||||
SAA_2O3PC_ | Test: Is 2nd or 3rd char. of name an underscore? | DCSAAN0008 | CHAR | 6 | DD_CHECK | ||||
SAA_TRESE | Test: Is name reserved? | DCSAAN0009 | CHAR | 6 | DD_CHECK | ||||
NOCUSTFLD | Test: Is SAP field in customer namespace? | DCTBFD0013 | CHAR | 6 | DD_CHECK | ||||
NOBRANCHN | Test: Is field from special development in SAP table ? | DCTBFD0015 | CHAR | 6 | DD_CHECK | ||||
NOSAPFLD | Test: Is customer field in SAP namespace? | DCTBFD0014 | CHAR | 6 | DD_CHECK | ||||
KEY_EXIST | Test: Does key field exist? | DCKEYC0001 | CHAR | 6 | DD_CHECK | ||||
KEY_NUMBER | Test: Are there too many key fields? | DCKEYC0002 | CHAR | 6 | DD_CHECK | ||||
KEY_CON | Test: Do key fields belong together ? | DCKEYC0003 | CHAR | 6 | DD_CHECK | ||||
KEY_BEGIN | Test: Is key located at the start? | DCKEYC0004 | CHAR | 6 | DD_CHECK | ||||
KEY_LEN | Test: Is the key too long? | DCKEYC0005 | CHAR | 6 | DD_CHECK | ||||
KEY_TRANS | Test: Does key have a maximum of 120 bytes ? | DCKEYC0006 | CHAR | 6 | DD_CHECK | ||||
DUPFIELD | Test: Duplicate field names | DCTBFD0001 | CHAR | 6 | DD_CHECK | ||||
EXISTDODE | Test: Do fields use active data elements? | DCTBFD0002 | CHAR | 6 | DD_CHECK | ||||
MANDANT | Test: Is client field (if it exists) in first position? | DCTBFD0003 | CHAR | 6 | DD_CHECK | ||||
DATATYPE | Test: Is data type correct? | DCTBFD0004 | CHAR | 6 | DD_CHECK | ||||
KEYCHANGE | Test: Are key fields unchanged? | DCTBFD0005 | CHAR | 6 | DD_CHECK | ||||
EXISTVARC | Test: Is data type VARC used? | DCTBFD0006 | CHAR | 6 | DD_CHECK | ||||
TYPE_VARC | Test: Is use of type VARC correct? | DCILTY0001 | CHAR | 6 | DD_CHECK | ||||
TYPE_LCHR | Test: Is use of type LCHR correct? | DCILTY0003 | CHAR | 6 | DD_CHECK | ||||
TYPE_LRAW | Test: Is use of type LRAW correct? | DCILTY0004 | CHAR | 6 | DD_CHECK | ||||
LONGTYPENR | Test: Does more than one LONG field exist? | DCILTY0005 | CHAR | 6 | DD_CHECK | ||||
TABLENGTH | Test: Is table too long for the database ? | DCTBFD0007 | CHAR | 6 | DD_CHECK | ||||
DOMALENGTH | Test: Are fields of types CHAR and DEC too long? | DCTBFD0008 | CHAR | 6 | DD_CHECK | ||||
EXISTREF | Test: Do reference table and reference field exist? | DCIREF0001 | CHAR | 6 | DD_CHECK | ||||
INTREF | Reference table is table to be activated | DCIREF0002 | CHAR | 6 | DD_CHECK | ||||
OUTREF | Reference table is a different table | DCIREF0003 | CHAR | 6 | DD_CHECK | ||||
CHECKREF | Test: Are fields to be deleted reference fields? | DCIDEL0001 | CHAR | 6 | DD_CHECK | ||||
CHECKAGGR | Test: Are fields to be deleted used in aggregate? | DCIDEL0002 | CHAR | 6 | DD_CHECK | ||||
KEYFLAG | Test: Does the KEYFLAG have an allowed value? | DCIVAL0001 | CHAR | 6 | DD_CHECK | ||||
MANDATORY | Test: Does the MANDATORY flag have an allowed value? | DCIVAL0002 | CHAR | 6 | DD_CHECK | ||||
ADMINFIELD | Test: Is the value for the INCLUDE level allowed? | DCIVAL0003 | CHAR | 6 | DD_CHECK | ||||
NOTNULLFLG | Test: Does the NOT NULL flag have an allowed value? | DCIVAL0004 | CHAR | 6 | DD_CHECK | ||||
KEYTYPE | Test: Do pooled tables have keys of an allowed data type ? | DCIPOO0001 | CHAR | 6 | DD_CHECK | ||||
KEYLENGTH | Test: Is key of a pooled table too long? | DCIPOO0002 | CHAR | 6 | DD_CHECK | ||||
DATALENGTH | Test: Are the fields of a pooled table too long? | DCIPOO0003 | CHAR | 6 | DD_CHECK | ||||
MAXPLENG | Length check for special logical pooled tables | DCIPOO0004 | CHAR | 6 | DD_CHECK | ||||
CLUSTERCHK | Cluster table test: Is key correct? | DCTBFD0009 | CHAR | 6 | DD_CHECK | ||||
GENBUFFER | Test: Is key field number OK for generic buffering? | DCITES0001 | CHAR | 6 | DD_CHECK | ||||
LOGWRITE | Test: Is the table to be logged too long? | DCITES0002 | CHAR | 6 | DD_CHECK | ||||
TRANSPFLG | Open | DCTBFD0010 | CHAR | 6 | DD_CHECK | ||||
TRANSLATE | Test: Is translation-relevance meaningful ? | DCTBFD0011 | CHAR | 6 | DD_CHECK | ||||
FNOT_NULL | Authorization check for the not null flag | DCINNU0001 | CHAR | 6 | DD_CHECK | ||||
NNLONGFLD | Test of the length restriction of NOT NULL fields | DCINNU0002 | CHAR | 6 | DD_CHECK |
Key field | Non-key field |
How do I retrieve data from SAP structure DDTBFDCHK using ABAP code?
As DDTBFDCHK is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DDTBFDCHK as there is no data to select.How to access SAP table DDTBFDCHK
Within an ECC or HANA version of SAP you can also view further information about DDTBFDCHK and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects