Skip to main content
Glama
abap0917

abap-adt-mcp

by abap0917

adt_create_table

Create an ABAP Dictionary transparent table using DDL, defining fields with data elements or built-in types, keys, foreign keys, and technical attributes, then optionally activate it.

Instructions

Create a DDIC transparent table (TABL) using ABAP Dictionary DDL. Each field references a data element (e.g. MANDT, YTSTDE2_192637) or a built-in type (CHAR/NUMC/DEC/CURR/QUAN/INT4/DATS/TIMS/... with optional length/decimals). Technical attributes use SAP-recommended defaults (enhancement category, delivery class, data maintenance). By default a key MANDT field (data element MANDT, foreign key to check table T000) is auto-prepended as the first key; disable via autoClient=false or supply your own MANDT. Fields may carry a foreignKey. Created in the given package (default $TMP, local/no transport) and optionally activated. Name must match Z*/Y* prefix. Returns the object URI, field count, the generated DDL source and activation status.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
nameNoTable name, e.g. YTSTTBL_192637. Must match Z*/Y* prefix. ADT create limit is 16 chars.
fieldsNoTable fields (at least one; transparent tables need >=1 key field). Each field may carry a 'foreignKey' (checkTable, optional keyType/cardinality/label/screenCheck) to emit a `with foreign key` clause.
packageNoTarget devclass. Omit to be asked (create new package | use $TMP).
activateNoActivate after creation. Default true.
transportNoTransport request. Omit + non-$TMP package -> asked to create one.
autoClientNoAuto-prepend the client field MANDT (data element MANDT, foreign key to check table T000) as the first key. Default true. Set false to omit it or to supply your own MANDT.
descriptionNoTable description, e.g. 'AI测试用透明表'.
deliveryClassNoDelivery class. A=application table (default), C=customizing, G=customizing+custom, L=transaction data, S=system table, E=control table, W=system copy, X=handover.
dataMaintenanceNoData maintenance allowed in SM30/SE16. Default ALLOWED.
enhancementCategoryNoEnhancement category. Default NOT_EXTENSIBLE for data-element-only tables; auto-upgraded to EXTENSIBLE_ANY when the table uses built-in types.
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description carries full disclosure burden. It transparently discloses auto-prepend of MANDT, default technical attributes (delivery class, enhancement category), field foreign key support, and naming constraints. Minor omissions around error handling and side effects are acceptable for a creation tool of this complexity.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single coherent paragraph that front-loads the primary action and progressively adds details. Every sentence adds value, covering core functionality, defaults, exceptions (autoClient), constraints, and return values. No redundant or filler content.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity (10 parameters, no output schema), the description is remarkably complete. It explains the creation process, field types, foreign keys, default behaviors, naming rules, optional activation, and return information (URI, field count, DDL source, activation status). Only minor details like error scenarios are omitted, which is acceptable.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema description coverage is 100%, so the baseline is 3. The description adds significant value beyond the schema by explaining autoClient behavior ('Auto-prepend... disable via autoClient=false'), naming convention, and default technical attributes. This extra context compensates well for the schema's already complete descriptions.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description states 'Create a DDIC transparent table (TABL) using ABAP Dictionary DDL' – a specific verb and resource, distinguishing it from siblings like adt_create_domain and adt_create_dataelement. It also clarifies key behaviors such as auto-prepending MANDT and naming constraints, leaving no ambiguity.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides clear context on when to use the tool (creating transparent tables) and covers default behaviors (auto-client, package, activation), naming requirements (Z*/Y* prefix), and optional features. While it does not explicitly list when not to use or compare with siblings, the detail is sufficient for appropriate selection.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/abap0917/abap-adt-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server