Skip to Content
0

Update Contact Persons Current Line

May 11, 2017 at 06:45 AM

57

avatar image

Hello experts ,

I would like to update a specific line from contact persons with di add-on but i cannot find something like linenum in ocpr to plae in the setcurrentline(?).

How can i do this?

Kind regards ,

Ifigenia Koumbarda

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
ANKIT CHAUHAN
May 11, 2017 at 08:31 AM
1

Hi,

Check SAP Note 934829 for the same.

For SQL versions below SAP Business One 9.0 PL09

SELECT * FROM OCPR WHERE CardCode = 'C20000'

For SQL versions SAP Business One 9.1 PL06 and below, SAP Business One 9.0 PL09 and SAP Business One 9.0 PL16.

SELECT * FROM OCPR WHERE CardCode = 'C20000' Order By CardCode, CntctCode

For SQL versions SAP Business One 9.1 PL07 and above , SAP Business One 9.0 PL17 and above.

SELECT * FROM OCPR WHERE CardCode = 'C20000' Order By CardCode, CntctCode

For all HANA version

SELECT * FROM OCPR WHERE "CardCode" = 'C20000' Order By "CardCode", "CntctCode"

The first line returned from the query will get a LineNum of 0, the second line returned gets the LineNum 1 and so on.

Hope it helps.

Kind regards,

ANKIT CHAUHAN

SAP SME Support

Share
10 |10000 characters needed characters left characters exceeded