bw_xref
Find which transformations, DTPs, process chains, and aggregation levels reference a given SAP BW object. Returns source, target, and direction to trace data flow.
Instructions
Find where-used / dependencies for a BW object. Returns all objects that reference the given object. Use this to find the Transformation and DTPs that reference an aDSO, or to find which DTPs depend on a Transformation. Every transformation and DTP hit carries its source and target (type and name) and its direction relative to the object: upstream (feeds it) or downstream (fed from it) — follow upstream hits hop by hop to trace a data flow back to its DataSource. On classic SAP BW the analysis processes that write to or read from a provider (ADSO, ODSO, CUBE, MPRO, IOBJ) are listed too, with direction. On every release the aggregation levels built on a provider are listed as upstream (planned values are written into the provider through them), and object_type=ALVL lists the InfoProvider underneath (downstream) and the planning functions on the level (upstream) next to its queries. Use object_type=DTPA to find the process chain(s) a DTP belongs to — this is preferred over bw_get_dtp when only the process chain is needed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| object_name | Yes | Object name (e.g. "ADSO_NAME" or "TRFN_UUID_KEY"). | |
| object_type | Yes | Object type: ADSO, TRFN, DTPA, IOBJ, etc. | |
| source_system | No | Required for object_type "RSDS". Logical source system name (e.g. "LSYS_NAME"). The correct padded objectName is built automatically. |