Reg Line items.

[Former Member]

Hi,

This below info is at Infoprovider level.

Doc No:    Line Item   Blocked

101                1               X

101                2               X

101                3

101                4          

102                1

102                2

103                1               X

103                2 

The Client requires the output of doc numbers which have atleast one X in their document numbers to be displayed, like below,

whether its possible to show at Bex.

Doc No:    Line Item   Blocked

101                1               X

101                2               X

101                3

103                1               X

103                2  

Can anyone let me know the logic because as far as i know we go for RKF against Doc number to Amount with selects X for restriction of Blocked

indicator, and in turn it shows only values which have X but how could we achieve the above.

Regards

Srinivas M

[BernhardE · Accepted solution]

Hi Srinivas,

You could try realizing this scenario using a prequery:

- In the main query you restrict your Docnumber by a variable with values from a prequery
- In the prequery you select all Docnumber where Blocked is X.

Best regards,
Bernhard

[Loed · Accepted solution]

Hi,

I agree with bernard..You may create two (2) queries..

1st query contains these:

FILTER TAB = blocked filter with X

ROWS = doc no

2nd query contains these:

ROWS = doc no, line item, and blocked

COLUMNS = amount

FILTER TAB = doc no and filter with variable having replacement path as its processing by (see pictures below)

Regards,

Loed

[Former Member]

Thanks for the help..and its working has per subquery call.

[Loed]

Hi,

How about doing this in tranformation level?

I tried to do this in BEx level but I don't know why it is not working when I applied CONDITION in FORMULA15 so that all values having 1 will only be shown..

Amount (with "X") contains the AMOUNT KF with filter to "X" values..

Amount (ALL) contains the AMOUNT KF only..

FORMULA 15 contains this argument:

SUMCT(Amount (with "X") > 0

I also tried adding FORMULA 14 which contains:

( SUMCT(Amount (with "X") > 0 ) * Amount (ALL) + 0

But after applying CONDITION in either FORMULA 14 or FORMULA 15 this is the result for both:

I think SUMCT can't be applied here since it is only a representation or virtual figure and NOT really a "real value"..

Maybe others have solution for this..

Regards,

Loed

[former_member186053]

Hi Srinivas,

Requirement is not clear, i have few questions.

1) why you displayed 101 doc with line item 3 even though 'blocked' is balnk. same case with 103 with line item 2.

2) If 1st point is true, why do not you want to get the doc 101 with line item 4.

Regards,

Vengal.

[Loed]

Hi,

I think he just forgot to include the line item 4..

Regards,

Loed