Displaying Documents for a Cell 

A cell in a report has certain selection conditions that you can display using the Key Figure Definition function in the context menu. A document matches a cell or is displayed with values when you select the Documents context menu if the following conditions are fulfilled:

●     The document has the current InfoProvider or no InfoProvider assigned as a property (in the latter case, the document is valid for all InfoProviders).

●     The document has the current query or no query assigned as a property (in the latter case, the document is valid for all queries).

●     The document has the key figure of the cell or no key figure assigned as a property (in the latter case, the document is valid for all key figures). Note here that the system uses the basis key figure for reusable restricted key figures. With reusable calculated key figures, however, the system uses the calculated key figure.

●     The document-relevant characteristics and their restrictions from the selection conditions of the cell match the properties of the document. This means that document has these characteristics defined in its properties and at least one characteristic in the document matches the restrictions of this characteristic in the cell.

In the BEx runtime (ABAP), restrictions on a hierarchy node are removed from all leaves of the node. This means that a document is suitable for a cell when at least one leaf of the hierarchy node appears in the document properties.

In the BEx Web runtime (Java), it is possible to create a document at the level of a non-postable hierarchy node. However, the hierarchy nodes are not removed.

The selection conditions of compounded document-relevant characteristics are also evaluated here:

Region is compounded with the document-relevant characteristic Country. If the Region characteristic is limited to the value California within a cell, the compound country USA is used as the selection for documents, regardless of whether the Region characteristic itself is document-relevant.

●     The document does not have any further characteristic properties defined. Otherwise the document would be too specific for the cell.

For the query ABC based on the InfoProvider XYZ, a cell might have the following selection conditions:

●      Material:            1 to 1000

●      Fiscal year:       2002

●      Customer:   MILLER

●      Sales area: SALES

●      Key figure:   Sales

Of these characteristics, Material, Customer, and Fiscal Year are document-relevant. There would also be the document-relevant characteristic Sales Organization.

The following documents match the cell	The following documents do not match the cell
Document 1 with the document properties: ●     Material         1000 ●     Material         2000 ●     Fiscal year     2002 ●     Customer       MILLER ●     InfoProvider    XYZ ●     Query            ABC ●     Key figure      Sales	Document 3 with the document properties: ●     Material         2000 ●     Fiscal year     2002 ●     Customer       MILLER ●     Query            ABC ●     InfoProvider    XYZ The Material characteristic does not fit here.
Document 2 with the document properties: ●     Material         1000 ●     Fiscal year     2002 ●     Customer       MILLER ●     Query            ABC	Document 4 with the document properties: ●     Material         1000 ●     Fiscal year     2002 ●     Customer       MILLER ●     Query            GHI The query does not fit here.
	Document 5 with the document properties: ●     Material               1000 ●     Fiscal year           2002 ●     Customer             MILLER ●     Sales organization.North ●     Query                  ABC The document-relevant characteristic Sales Organization is too specific here.