Buffering is available under Technical Settings in SE11.
Buffering has 3 options.
SAP buffering can be permitted for a database table as follows:
Buffering not allowed
SAP buffering is not performed for the table. Open SQL always accesses the current data of the data table directly. This setting also dictates that SAP buffering should also not be activated for this table in any other systems due to the way it is used.
Buffering allowed, but switched off
SAP buffering is not performed for the table when delivered. This setting dictates, however, that buffering is possible in principle and can be activated in other systems depending on how the table is used.
Buffering switched on
SAP buffering is performed for the table. If possible, Open SQL statements access the SAP buffer in the shared memory instead of accessing the table directly.
We can create APPEND structure in DB tables from SE11 Tcode and add the fields in it
No
Append structure is used to append the structure to the standard table where as Include structure is used to include the structure in the custom table. Same APPEND structure cannot be used in more than one standard tables. Same Include structure can be added to any number of custom tables.
"Check Table:
1. It contains valid entries of a particular foreign key.
2. Check table is validation at field level.
3. It is part of table definition.
Value Table:
1. It is part of domain definition.
2. Value table is validation at domain level.
3. It is used to provide values on F4 help for all the fields which refer to that domain."
1. It contains valid entries of a particular foreign key.
2. Check table is validation at field level.
3. It is part of table definition.
Value Table:
1. It is part of domain definition.
2. Value table is validation at domain level.
3. It is used to provide values on F4 help for all the fields which refer to that domain."
"According to the Release 7.53:
1. For a database table that is not part of SAP_BASIS, total of all field lengths is no longer checked in ABAP Dictionary.
2. For a database table that is not part of SAP_BASIS, total of all field lengths is restricted to 4030."
1. For a database table that is not part of SAP_BASIS, total of all field lengths is no longer checked in ABAP Dictionary.
2. For a database table that is not part of SAP_BASIS, total of all field lengths is restricted to 4030."
According to the Release 7.53:
1. A database table that is not part of SAP_BASIS can contain 1000 fields for Row Storage Type and 1500 fields for Column Storage Type.
2. A database table that is part of SAP_BASIS can contain 749 fields.
1. A database table that is not part of SAP_BASIS can contain 1000 fields for Row Storage Type and 1500 fields for Column Storage Type.
2. A database table that is part of SAP_BASIS can contain 749 fields.
We need to create a Parameter Transaction type Tcode in SE93 for the TMG
16
It defines the initial size of the table and extends automatically as and when the number of records exceeds