Standard Edition

Data Lineage at Object level for BW DDIC Entities.
We export two files: one file with all the relations of BW DDC Entities (“Relations”) and one file with more details (e.g. Technical Name and descriptions) (“Details”) of the entities.

In the “Relations” file only entities are included that have a connection in a the data flowlineage. E.g. an Advanced DSO without an incoming or outgoing transformation or an Composite or Open ODS View on top is not listed in the dataView with it’s base tables.

In the Details file we identify CDS Data Definition.

The supported entities for the standard edition are the following:

• BW Queries

• Restricted Key Figures

• Calculated Key Figures

• Composite Providers

• Advanced Data Store Objects (ADSO)

• Open ODS Views

• InfoSources

• DataSources

• InfoObjects as InfoProviders

• Open Hub Destinations

• Aggregation Levels

• AfO Workbooks stored in BW

• MultiProvider

• Data Store Objects

• InfoCubes

• InfoSets

• HybridProvider

• HANA Artifacts consumed by Composite Providers and Open ODS Views

• Tables

• Views

• CDS Data Definitions

Premium Edition

Data Lineage at Field /InfoObject level for BW DDIC Entities.

Every origin of and between Fields and InfoObjects will be part of the premium edition.

Which mappings are supported:

• Mappings in Composite Providers

  • Direct Assignment

  • Formulas

  • Constants

• Mappings in Open ODS Views

• Assignments/rules in Transformations

  • Description of rules in Transformations

  • Type of rules in transformations (Constant, Formula, Field Routine, Lookup, End Routine, Start Routine, Expert Routine Direct Mapping)

  • Value of constants rules

  • Definition of formulas rules

  • Lookup object of lookup rules

All field and InfoObjects Mappings are supported for the BWonHANA entities only. That are the following:

• BW Queries

• Composite Providers

• Advanced Data Store Objects (ADSO)

• Open ODS Views

• InfoSources

• DataSources

• InfoObjects as InfoProviders

• Open Hub Destinations

• Aggregation Levels

• HANA Artifacts consumed by Composite Providers and Open ODS Views

Definition of Key Figures

The Premium edition reads out also the definitions of key figures on Reporting level. The definition of the following entity types are collected:

• Calculated Key Figures

• Restricted Key Figures

• Local Formulas

• Local Selections

Extended Edition

The Extended Edition includes more information about the transformations and rules of Field/InfoObject Data Lineage.

The following information is part of the Extended Edition:

• Lookups and calls of

  • Tables

  • Views

  • Function Modules

  • Methods

  • CDS Entities

  • ABAP Reports or Includes

• in

  • Start Routines (ABAP & AMDP)

  • End Routines (ABAP & AMDP)

  • Expert Routines (ABAP & AMDP)

  • and Field Routines (ABAP & AMDP)

We do not parse code (at the moment) and simply show the 1on1 Mappings of tables and views we get from SAP.

We export 3 more files:

• Buildups - with all buildups of tables, views, and data definitions

• BuildupDescriptions - with the descriptions of the fields

• Mappings - with the 1on1 Mapping of the fields between tables, views, and data definitions

Extended Edition

currently, there is no extended edition for parsing the code