choose from list for Item Master

[Former Member]

hi,

want choose from list for item master .

item should be filter on the basis of whr house.

I am able to find out choose from list for item master but can't filter basis on ware house.

Regards,

Avijit

[former_member186095]

Hi,

How many warehouse do you have ? I am trying to resolve your issue but unable. I consider to you properties of item master data. I will change it to be warehouse name but it is resitrcted by warehouse quantity. This should be able to resolve either by query FMS or using the item properties.

We can't have the warehouse code because it is not in the same table. The warehouse code is on the OITW.

Rgds,

[Former Member]

right jimmy michael ,

even i have also same opinion because i have tried out for this one.

item master comes from oitm table but ware house related information is stored in oitw table.

Regards,

Avijit

[Former Member]

So i guess u need to go for a Userdefined CFL..

Vasu Natari.

[Former Member]

Avijit,

Jimmy is true but, still if it has to be done with CFL only then you can configure your condition for CFL as such that it filter the values from an sql query. but it would be much time taking on both performance and coding part.

regards,

Binita

[Former Member]

Joshi,

right.

because i hope again it will be time consuming , because then i have to create UDO & then i have to link them.

Regards,

avijit

[Former Member]

U have to use a Condictions object and set the conditions for the CFL.

Just serach the forum for CFL Conditions u'll find ur samples.

Regards,

Vasu Natari.

[Former Member]

yha.. that i know that i have to given condition,

but which field?

check my code...

Dim oCFL As SAPbouiCOM.ChooseFromList

Dim oCFLCreationParams As SAPbouiCOM.ChooseFromListCreationParams

oCFLCreationParams = SBO_Application.CreateObject(SAPbouiCOM.BoCreatableObjectType.cot_ChooseFromListCreationParams)

' Adding 2 CFL, one for the button and one for the edit text.

oCFLCreationParams.MultiSelection = False

oCFLCreationParams.ObjectType = "4"

oCFLCreationParams.UniqueID = "CFL3"

oCFL = oCFLs.Add(oCFLCreationParams)

' Adding Conditions to CFL1

oCons = oCFL.GetConditions()

oCon = oCons.Add()

oCon.Alias = "WhsCode"

oCon.Operation = SAPbouiCOM.BoConditionOperation.co_EQUAL

oCon.CondVal = "finish good whr house code"

oCFL.SetConditions(oCons)