How can I retrieve the document line status value from UI

[former_member244307]

Hi,

Right now I need to do some check with the each document line status in UI, but it seems it doesn't exist in the the matrix. When I try to use code like this:

oEditText = (SAPbouiCOM.EditText)oMatrix.Columns.Item("LineStatus").Cells.Item(i).Specific;

It gives me Invalit Column error, I guess the line status field does not exist in the matrix. Do I have to use DI or SQL query to retrieve the like status value?

Thanks,

Lan

[Former Member · Accepted solution]

If the document is open on the screen, you can of course get line status from the UI.

It is column 40:

oEditText = (SAPbouiCOM.EditText)oMatrix.Columns.Item("40").Cells.Item(i).Specific;

[former_member244307 · Accepted solution]

Hi njmog1,

Yes, you are right. It seems I can get the line status value now. But how you know this trick? I can't find any info in SDK help file, is it how the SAP consultant make money? I am just a little curiois. ^_

Thanks!

Lan

[Former Member · Accepted solution]

Ha I guess you could say it is 😛

Seriously though, if you just turn on "System Information" (Go to View->System Information), when you move your mouse over fields, you will see the information displayed down below so for the line status I could see:

Form=139 Item=38 Column=40

This is how you figure out which column id is for which field.

[former_member244307 · Accepted solution]

I know why i couldn't find the column at the beginning, because this column name is called RowStatus but I was trying to find a column named LineStatus. Thay's why I couldn't find it in the matrix nor in the field list of form setting.

Thanks again!

Lan

[Former Member]

Hi Lan,

Your guess is correct. UI is only for User Interface. If your matrix has data source, you have to use DI or query to get the actual data.

Thanks,

Gordon