What is the function of DET_LEVEL ?

[Former Member]

Hi experts ,

Can any of you please explain the functionality of DET_LEVEL in the macros ?

Kindly help

regards

Ashwin

[Former Member · Accepted solution]

Hello Ashwin -

Read the following explanation.

DET_LEVEL( 'IOBJNM' ) returns 0 if you are planning on an aggregate level

with respect to the InfoObject IOBJNM, where IOBJNM is the technical name

of the InfoObject. For example, if your selection contains product 11 and product 12, and if 9AMATNR is the InfoObject name of products, DET_LEVEL ( '9AMATNR' ) returns 0. DET_LEVEL( 'IOBJNM' ) returns 1 if you are planning

on the detailed level with respect to the InfoObject IOBJNM;

Syntax

DET_LEVEL('characteristic' [; EXCLUDE_IMP] [GRID=2] )

Characteristic = Technical name of the characteristic that is to be analyzed

EXCLUDE_IMP: If you set this optional indicator ('X'), implicitly strong characteristics are not taken into account in the analysis.

GRID=2: If you set this optional parameter, the analysis is applied to the planning object of the second grid.

Description

The DET_LEVEL() function analyzes whether the planning object being currently processed is detailed or aggregated with regards to the characteristic characteristic. If detailed, the return value is ‘1’; if aggregated, the value is ‘0’.

Examples

Example 1:

You have selected the products P1 and P2 (characteristic 9AMATNR). DET_LEVEL( '9AMATNR' ) will provide the return value '0' for this planning object because you are at aggregated level with regards to the characteristic 9AMATNR.

Example 2:

The products P1 and P2 are only in location L1 (characteristic 9ALOCNO) due to the characteristics combinations maintained (in DP) or location products (in SNP). You have selected the products P1 and P2 (characteristic 9AMATNR). DET_LEVEL( '9ALOCNO' ) will provide the return value '1' for this planning object because you are at detailed level with regards to the characteristic 9ALOCNO. The 9ALOCNO characteristic is implicitly strong in this case (namely location L1) due to the selection of products P1 and P2 and it is used in the analysis. DET_LEVEL( '9ALOCNO' ; 'X' ) will deliver the return value '0' for this planning object because implicitly strong characteristics are not used for the analysis. A drilldown to the characteristic ‘location’ would characterize it explicitly.

Hope this helps.

Regards,

Suresh Garg

[Former Member]

Thanks a ton for the replies.

regards

Ashwin

[srinivas_krishnamoorthy]

Basically it helps you interrogate a level on characteristic in DP. It can help you to define neat logical calculations around the level at which planning/managing data is being done. The complemantary is AGG_LEVEL