How can you check if a Data Source is released for ODP?

Question

Options

• ATable RSOLTPSOURCE in the SAP BW/4HANA system
• BTable ROOSOURCE in the source system
• CTable ROOSATTR in the source system
• DReport BS_ANLY_DS_RELEASE_ODP in the SAP BW/4HANA system

• A
  3% (1)
• C
  94% (29)
• D
  3% (1)

Explanation

ROOSATTR is the correct table because it stores DataSource attributes in the source system - and the ODP release status is one of those attributes, specifically a flag indicating whether the DataSource has been made available for the ODP framework. Since ODP release is a property of the DataSource at its origin, you check it in the source system, not in BW.

Why the distractors are wrong:

• A (RSOLTPSOURCE in BW/4HANA): This table lives in the target BW system and holds replicated DataSource metadata - it doesn't carry the authoritative ODP release flag.
• B (ROOSOURCE in source system): ROOSOURCE holds general DataSource definitions and structural info, but not the specific ODP release indicator.
• D (Report BS_ANLY_DS_RELEASE_ODP in BW/4HANA): This is not a standard SAP report for this purpose; ODP release checking is a source-system concern, not a BW-side report function.

Memory tip: Break it down - ROOSATTR = ROOtSource ATTRibutes. "Attributes" includes the ODP release flag, and since it's a source system property, it stays in the source system. If you remember "attributes live at the source," you'll always pick ROOSATTR over the BW-side tables.

No community discussion yet for this question.