Skip to main content
Glama
dnic-dev

bw-modeling-mcp

by dnic-dev

bw_update_transformation

Map a source field to a target InfoObject or convert existing rules in a BW Transformation to direct, routine, formula, constant, lookup, or no_update types.

Instructions

Map a source field to a target InfoObject in a Transformation, or convert an existing rule to a field routine (StepRoutine) or formula rule (StepFormula). rule_type="direct" (default): changes a StepNoUpdate/StepInitial rule to StepDirect. rule_type="routine": converts an existing StepDirect, StepInitial, or StepNoUpdate rule to StepRoutine (AMDP field routine). rule_type="formula": converts an existing rule to StepFormula — no ABAP class generated, BW evaluates the formula natively. rule_type="constant": sets a fixed constant value on the target field — no source field needed. For routine/formula on StepNoUpdate rules, source_field is required. For routine/formula on StepDirect/StepInitial rules, source_field is ignored (field is already mapped). source_field is always ignored for rule_type="constant". Returns a lock_handle for bw_activate.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
transformation_nameYesTransformation name (UUID-like key).
source_fieldNoSource field name in the source segment (e.g. "FIELD_NAME"). Required for rule_type="direct" if the existing rule has no source mapping. Also required for routine/formula when the target has no source mapping yet (StepNoUpdate). Required for rule_type="lookup".
target_infoobjectYesTarget InfoObject name in the target segment (e.g. "IOBJ_NAME").
rule_typeNoRule type to assign. "direct" (default): maps source field directly (StepDirect). "routine": converts the rule to an AMDP field routine (StepRoutine) — the server generates the ABAP class automatically. "formula": converts the rule to a formula rule (StepFormula) — requires the formula parameter. "constant": sets a fixed constant value (StepConstant) — requires the constant_value parameter, source_field is ignored. "lookup": converts the rule to a StepRead (Lookup) rule — requires lookup_object and lookup_object_type. "no_update": reverts any existing mapping back to StepNoUpdate (no mapping, field stays empty). IMPORTANT: AMDP SQLSCRIPT methods only allow ASCII 7-bit characters — no German umlauts or special symbols in code or comments.
formulaNoFormula expression for rule_type="formula" (required). Source fields are referenced by their technical field name: use /BIC/FIELDNAME for custom InfoObjects (e.g. "/BIC/FIELD_NAME + 10"), or the direct field name for standard InfoObjects. Operators: +, -, *, /. Functions: IF, ABS, CONCATENATE, DATE_YEAR, etc. Comparison operators < > <= >= <> are supported (will be XML-escaped automatically).
constant_valueNoConstant value for rule_type="constant" (required). The value is written as-is into the target field during data loading. Example: "X" for a flag field, "USD" for a currency field.
lookup_objectNoName of the InfoObject or aDSO to read from (Nachlese-Objekt). Required for rule_type="lookup".
lookup_object_typeNoType of the lookup object. "IOBJ" for InfoObject, "ADSO" for aDSO. Required for rule_type="lookup".
additional_source_fieldsNoAdditional source fields for rule_type="formula" when the formula references more than one source field. Combined with source_field, all listed fields are registered as inputs on the StepFormula rule. Example: ["QUANTITY_SOLD", "COST_PER_UNIT"].
transportNoTransport request number (e.g. DEVK900123). Only required if the BW system requires transport assignment.
Behavior4/5

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

No annotations are provided, so the description carries full burden. It discloses that the tool returns a lock_handle for activation, that routine generates ABAP class automatically, that formula is natively evaluated, and that constant ignores source_field. It also notes ASCII-only constraint for AMDP. However, it doesn't explicitly state permissions needed or that the tool modifies an existing transformation (implied), and doesn't indicate if it is destructive (likely yes).

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 well-structured and front-loaded with the main action. It uses clear bullet-like prose for rule types. However, it is somewhat long (over 500 words) and could be more concise by using a list format. Still, every sentence adds value, and the structure aids readability.

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

Completeness4/5

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

Given 10 parameters, 100% schema coverage, no output schema, and no annotations, the description is fairly complete. It covers all rule types, parameter interactions, and the return value (lock_handle). It could mention that the transformation must already exist (implied by 'update') and that activation is required, but overall it provides sufficient context for correct invocation.

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

Parameters5/5

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

Schema coverage is 100%, baseline 3. The description adds substantial meaning beyond the schema: for each rule_type it explains behavioral implications, source_field requirements, and formula syntax with operators. It also clarifies the role of additional_source_fields and constant_value usage. This adds significant value for parameter understanding.

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 clearly states it maps a source field to a target InfoObject or converts existing rules, with specific rule types like direct, routine, formula, constant. This distinguishes it from sibling tools like bw_create_transformation (creation) and bw_set_transformation_routine (which only sets routines). The verb 'update' and resource 'transformation' are explicit.

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 detailed when-to-use guidance for each rule type, including source_field requirements per type (e.g., required for routine/formula on StepNoUpdate, ignored for constant). It also gives context on when source_field is needed or ignored. However, it does not explicitly state when NOT to use this tool versus alternatives like bw_set_transformation_routine, though the sibling list implies differentiation.

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/dnic-dev/bw-modeling-mcp'

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