SAP transaction codeObjectRSA6ModuleBW_ANALYTICS

RSA6 — Maintain DataSources in the Source System

RSA6 displays and maintains active DataSources in the source system (ECC or S/4HANA acting as an extraction source): its extract structure, selection fields, hide fields, inversion flags and customer append structures. It is not the BW-side DataSource; changes made here only reach BW after the DataSource is replicated in RSA1, which is the single most common source of confusion when a field appears missing on the BW side.

This page covers RSA6, the source-system transaction for viewing and customizing the field-level behaviour of DataSources used by BW extraction. It focuses on the split between the source-system object and its BW replica, why field or delta changes often fail to show up downstream, and how to prove the cause in the underlying tables.

Reviewed by an ERPClimb SAP consultant on 15 Sept 2026· 1,147 words

Purpose

RSA6 shows the active version of every DataSource generated in the source system: its extract structure, which fields are marked for selection, which are hidden from the extractor, inversion settings for reversal-relevant fields, and any customer append structure used to add fields beyond what SAP delivered. It is a source-system transaction, not a BW transaction, even when the source and BW live in the same client on an embedded S/4HANA setup. The one structural fact that explains most confusion: what a BW consultant sees in the DataSource repository inside RSA1 is a replicated copy of what exists in RSA6, not the live object. Editing field settings in RSA6 changes the source-system definition only; the BW side keeps its old picture until that DataSource is explicitly replicated.

When it is used

A consultant opens RSA6 when a DataSource is not extracting a field that should be available, when a newly added custom field via an append structure needs to be marked for selection or hidden, or when troubleshooting why a delta-relevant field behaves oddly during extraction. It sits upstream of RSA3 (extraction test) and RSA7 (delta queue monitor) in the diagnostic chain: RSA6 confirms what the extractor is structurally capable of sending, RSA3 confirms what it actually sends for given selections, RSA7 confirms what has queued for delta. It is reached instead of RSA1 whenever the question is about the source-system definition itself rather than the BW-side model, and instead of LBWE whenever the DataSource in question is not one of the LO cockpit application-specific extractors.

How to use it in practice

  • Log on to the source client (or the relevant client on an embedded BW/S4 system) and call RSA6
  • Locate the DataSource by application component tree or by direct name search
  • Double-click to display the extract structure, selection fields, hide flags and inversion settings
  • Switch to change mode only if a customer append structure or field attribute genuinely needs adjustment
  • Save, then check generation status; a red or yellow status means the extract structure did not regenerate cleanly
  • Go to RSA1 in the BW system and replicate the DataSource so the metadata change is visible downstream
  • Re-run RSA3 against the DataSource to confirm the field now appears with data

Key data objects

  • ROOSOURCE - header data for each active DataSource in the source system, including extract structure name and delta process
  • ROOSFIELD - one row per field of the DataSource, carrying selection flag, hide flag, inversion flag and field type
  • ROOSGEN - generation status and the name of the function module or structure actually generated for extraction
  • TADIR - transport and package assignment for the generated DataSource objects, relevant when a change will not save due to a transport lock

How to prove it in the data

Pull ROOSFIELD filtered on the DataSource name and check the selection and hide indicators for the field in question; a field flagged as hidden or not selected there will never leave the extractor regardless of what the BW transformation expects. Cross-check ROOSOURCE for the same DataSource to confirm the extract structure name matches what RSA3 reports it is using. If the field was added through a customer append, confirm the append structure actually contains a value by running RSA3 with a small selection and inspecting the raw output before assuming the BW side is at fault.

ECC vs S/4HANA

RSA6 still exists on S/4HANA and behaves the same way for DataSources built on classic extraction (LO cockpit extractors, generic extractors on tables or views). It has no Fiori equivalent because it is a back-office metadata transaction, not an end-user process. Extraction built on the newer CDS-view-based DataSources for embedded analytics scenarios bypasses RSA6 entirely, since those DataSources are generated directly from the CDS annotation rather than maintained as a classic extract structure, so RSA6 is only relevant when the classic extractor path is in play.

Common pitfalls and how to diagnose them

  • Stale replica: a field change is visible and correct in RSA6 but the BW-side DataSource still shows the old structure. Cause is almost always a missed replication step in RSA1; check the last replication timestamp on the BW DataSource before touching anything else.
  • Field flagged hidden or deselected: the field exists in the extract structure but never reaches the extractor output. Check the hide and selection indicators in RSA6 for that exact field before assuming a coding problem in the extractor exit.
  • Append structure with no data: a customer field added via append shows up structurally in RSA6 but is always blank in extraction. This means the append field was never populated, which requires an ABAP enhancement (user exit or BAdI on the extractor) rather than any setting change in RSA6 itself.
  • Change made after delta init: field-level changes to a delta-enabled DataSource that has already run an initialization can leave the delta queue and the new structure out of sync. A structural field change after go-live generally forces a re-init, not just a save in RSA6.
  • Generation failure: saving in RSA6 leaves the DataSource with a non-green generation status. Regenerate and read the generation log rather than repeating the save; a stuck lock entry or an inconsistent append structure is the usual cause.
  • Wrong system context: on an embedded BW/S4 landscape, consultants sometimes edit RSA6 in the wrong client or system, assuming source and BW are the same object. Confirm which system is genuinely acting as the extraction source before editing anything.

Whose problem this is

Ownership is technical BW or extraction-focused functional consultant, with ABAP involvement whenever an append field needs to be populated through a user exit or enhancement spot. A clean handover states the DataSource name, the exact field affected, whether the DataSource is delta-enabled and whether it has already been initialized, and whether the fix requires only a field attribute change or an ABAP enhancement.

Related SAP objects

Reviewed pages this object connects to in the ERPClimb knowledge graph.

Source: ERPClimb — https://erpclimb.com/sap-tcodes/rsa6ERPClimb is an independent platform and is not affiliated with SAP SE. Reference pages are written and reviewed by SAP consultants for learning and troubleshooting.