According to Item Property,get the ItemCode.Is it Possible ?

[Former Member]

Hi,

I am not getting my solution through Query . I want the Report through Item Property ,

which start from 1 to 64 in Sap Item Master Data - Property Tab.

I want to display the Report according to client ,that was like this .

They want that when we select any of the Item Property ,

we get the Item Code according to its property ,which we select it.

But i am not able to get it.

Is it possible or not ? Can u help me to find out the solution of this question?

[former_member218051]

Hi Jyotasna,

Through query manager i tried this ,

SELECT T0.[ItemCode], T0.[QryGroup1], T0.[QryGroup2], T0.[QryGroup3], T0.[QryGroup4] FROM OITM T0 WHERE (T0.[QryGroup1] =[%0] and ( T0.[QryGroup2] = 'N' or T0.[QryGroup3] = 'N' or T0.[QryGroup4] = 'N'))

or ( T0.[QryGroup2] =[%1] and ( T0.[QryGroup3] = 'N' or T0.[QryGroup4] = 'N' )) or

( T0.[QryGroup3] =[%2] and ( T0.[QryGroup4] = 'N')) ORDER BY T0.[QryGroup1], T0.[QryGroup2], T0.[QryGroup3], T0.[QryGroup4]

But i'm afraid whether SAP will allow to put all 64 properties as paramaeters. And if at all it allows then how will it behave ?

You can skip the properties which are not assigned.

Thanking you

Malhaar

[Former Member]

Sir,

This query is showing all the three property but if i want to choose 12th item Property

than it will show all 1-12 item property list .

Edited by: jyotasna on Oct 17, 2011 11:57 AM

Edited by: jyotasna on Oct 17, 2011 12:00 PM

[Former Member]

Hi,

An easier way would be to concatenate fileds then do a global compareason with LIKE

Regards,

Eric