Changing existing sap query.

[Former Member]

Hi Everyone,

We have requirement to add Customer Hierarchy Number(HKUNNR) on the query selection screen and fetch the 1series customers for the given hierarchy numbers on the selection screen. To achieve this, we have added KNVH to the infoset's join and added the field to a field group. And from SQ01, we have got the field on to the screen in the required position.

Now, in SQ02 code part, we want to access the data entered on the selection screen for HKUNNR. We searched many forums, but couldn't get the correct answer. Please help us in solving this.

Thanks.

[Former Member]

Hi Everyone,

We have requirement to add Customer Hierarchy Number(HKUNNR) on the query selection screen and fetch the 1series customers for the given hierarchy numbers on the selection screen. To achieve this, we have added KNVH to the infoset's join and added the field to a field group. And from SQ01, we have got the field on to the screen in the required position.

Now, in SQ02 code part, we want to access the data entered on the selection screen for HKUNNR. We searched many forums, but couldn't get the correct answer. Please help us in solving this.

Thanks.

[Former Member]

"we want to access the data entered on the selection screen for HKUNNR": You can create a parameter/selection criteria in SQ02 for the user provided value. Access the 'Extras' option then the 'Selections' tab to setup the selection.

[Former Member]

Hi Dennis,

Tried that, but I am not able to give the sequence to that field in SQ01. We want the Hierarchy number where you see now. When I tried adding the field through Selections, it is coming in the top in another block. Please do let us know if you know how can we sequence it and get that into the sequence.

Thanks!