Form settings using SDK

[Former Member]

Hi Friends

I am doing on Purchase order form.i need to set visible some column of matrix visible and active (in table Format and RowFormat) with out using form setting inter face , means through code using SDK.Is it possible

Thanks

[Nussi · Accepted solution]

Hi Muna,

it's like Roberto told you in the other thread.

the information is in the CPRF table.

there you can chance the order, active and visibility !

but the problem is - you can only change it when the business one is closed.

the reason: sap loads the settings in memory (from table) when you start the business one

and saves it back when you close it.

lg David

[Former Member · Accepted solution]

ibut i change position of my userfileld in table CPRF.Change cvalue of my userfield's 'ExapandIndx' and 'VisualIndx' but its not chane in form dispaly.

and we can also see same value in multiple row for example

"SELECT * FROM CPRF WHERE FormId='142' andColID ='12' and ItemID='38'"

but its getting 3 row . which one is actuall value

[Nussi · Accepted solution]

Hi Muna,

thats what i meant - you can't change the columns properties (order, visible, active) "on the fly"

as long as the business one is closed the changes are not recognized.

you are right that it is already in database - but not in memory !

lg David

[Former Member · Accepted solution]

sorry, i haven't yet get a solution.

actually i need to position my userfield in between Quandity and UnitPrice. In Table CPRF I Changed its 'VisualIndx' and 'ExpandIndx'

Now in Table CPRF Record is Like below

ColID VisualIndx ExtendIndx

Quantity(Coulumn11) 13 13

UnitPrice(Coulnn 14) 17 257

UserField - 14 14

But still dispalying my UserField on last Column.

I did all the process after SAPB1 Application stoped

Edited by: Muna on Jul 24, 2008 12:03 PM

Edited by: Muna on Jul 24, 2008 12:05 PM

[Former Member · Accepted solution]

Check the related UserSign value of this record with the UserSign of the User which you logon (Sorry for my english )

[Former Member · Accepted solution]

all userSign Values are 1 means same

[Former Member · Accepted solution]

Muna,

I used the following query and it worked at my end:

update cprf set visualindx = 14 , expandindx = 14 where colid = 'U_SerialNo' and FormId='142' and ItemID='38'

and yes, give the filter for usersign if u want to make it user-specific.

also, as everyone here said, when you execute this query, your SAP B1 should be closed, as well as any other user should not be logged in the same company, to be on safe side.

Binita

[Former Member · Accepted solution]

i Think its not possible. please confirm it friends

[Former Member · Accepted solution]

Hi Muna,

So From SDK we have written down everything I think.

By the way I am suggesting the following:

1. Make the column order by normal way (open from settings, and move with mouse) for manager

2. Log off for everybody

3. Copy settings from manager to every user using SQL.

Regards,

J.

[Former Member]

Hi Muna,

Because of the settings by user, you have to include the usersing into your query. This will give you row by users.

See SDK documentation where CPRF table structure and fields are described very good.

-- for manager

SELECT * FROM CPRF WHERE FormId='142' andColID ='12' and ItemID='38' and UserSign = '1'

Please log off, now change the fields and log on again. as David described, B1 overwrites fields values at log off procedure.

Regards,

J.

[Former Member]

i don't know what happend .At last i got.Thanks every body

Edited by: Muna on Jul 24, 2008 1:41 PM