Skip to Content
avatar image
Former Member

Update Contact Persons Current Line

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 11, 2017 at 08:31 AM

    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

    Add comment
    10|10000 characters needed characters exceeded