Skip to end of metadata
Go to start of metadata

Overview/Summary

There are 2 flavors of Inventory ADSOs(see screenshots below)

  • ADSO with Change Log and special type Inventory
  • InfoCube-like ADSO(All Characteristcs are Key, Reporting on Union of Inbound and Active Table) with special type Inventory

The processing details and views and tables used depend on this flavour. See also DataMart Extraction.

Tables

As described in note 1548125 the following ADSO tables are relevant:

  • /BIC/A'Name'1 -  Inbound Table
  • /BIC/A'Name'2 -  Active Data Table
  • /BIC/A'Name'3 -  Change Log  → only used when ADSO with ChangeLog
  • /BIC/A'Name'4 -  Validity Table
  • /BIC/A'Name'5  - Reference Point Table

When you check the content of the providers you can do this by either using LISTCUBE or by looking at these tables.

Views

In addition to this tables two important views are used in reporting and when data is extracted(See DataMart Extraction). The definition of these views depend on the flavor of the ADSO:

ADSO with ChangeLog
  • /BIC/A'Name'6  -  Data Extraction
    • view is basically a union of the 'Active Data Table'(2) and the 'Reference Point Table'(5)
  • /BIC/A'Name'7 - Reporting: Query and Listcube(in case Hana View is not used) 
    • view is also a union of the  'Active Data Table'(2) and the 'Reference Point Table'(5)
 InfoCube-like ADSO
  • /BIC/A'Name'6  -  Data Extraction
    •  view is basically a union of the 'Inbound Table'(1), the 'Active Data Table'(2) and the 'Reference Point Table'(5) - see View Definition for further details
  • /BIC/A'Name'7 - Reporting: Query and Listcube(in case Hana View is not used) 
    • view is basically a union of the 'Inbound Table'(1), the 'Active Data Table'(2) and the 'Reference Point Table'(5)  - see View Definition for further details
 
Screenshots

The tables can also be accessed by using the button Environment in RSA1→Manage ADSO:

ADSO of type Inventory with Change Log

'Cube-like' ADSO of type Inventory

 

  • No labels