Business Content Usage - InfoProviders (Transactional Data)

Technical Name: 0BCTCBC01_Q0002

Use

This query enables the user to determine in which InfoAreas Business Content InfoProviders are used, and where customer-defined InfoProviders are used. Both the number of InfoProviders and the actual names are available.

This query demonstrates some of the functionality of the InfoCube 0BCTCBC01, and provides a template to use as a basis for designing queries with this InfoCube.

The InfoCube 0BCTCBC01 relates to objects used for Transactional Data (not Master Data).

Filter

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0CB_OV

The object version is restricted to active objects.

Free Characteristics

InfoObject

Description

0CB_IP__DVE

This flag divides InfoProviders defined in the Business Content from those that are not.

0CB_IPT

This characteristic divides the types of InfoProviders.

Rows

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0CB_IP

InfoProviders organized according to the InfoArea Hierarchy.

Columns

InfoObject

Description of the InfoObject (and restriction or calculation formula)

0CB_IPCT

Counts the InfoProviders (which have already been restricted to active).

Additionally, a selection of 0CB_IPCT restricted by 0CB_IP__DVE = ‘X’ results in the total of active InfoProviders which are defined in the content. Subtracting this figure from 0CB_IPCT gives the total of InfoProviders which are customer-defined.