Sales quatation problem

[Former Member]

hello friends,

All of you well known about the sales quatation form in SAP-B1. my problem is i want to take owner item from that form for the purpose of where condition in my coding. In status bar it display as owner code.but form visible is owner first name and last name. so their is no possible to take first name and lastname in my condition. is any other possible to get the particular owener ID or else..

help me to solve this problem

with regards

shamuga kumar

[Former Member · Accepted solution]

Well,

I think, you just have to join your Query with OHEM.

"... OQUT T0 LEFT OUTER JOIN OHEM T1 ON T0.Owner = T1.empID"

Now you can add:

"WHERE T1.firstName = '...' " etc.

Kind regards

Christian

[Former Member]

"Item=232" stores OwnerCode you need.

oItem = oForm.Items.Item("232");

string sOwnerCode = ((SAPbouiCOM.EditText)(oItem.Specific)).Value;