cancel
Showing results for 
Search instead for 
Did you mean: 

DI - API Hierarchies and Expansions

Former Member
0 Kudos

Hello,

anybody knows the way to insert a record into the Hierarchies and Expansions ?

The table is the same of Special Prices but i think the object is different.

Thanks in advance

Andrea

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

I have tried, but in the property 'CardCode' i can't insert anything else than a valid CardCode, i need to insert something like "*1" etc..

barend_morkel2
Active Contributor
0 Kudos

Hi Andrea,

If you want to build in a search facility, you'll have to search trhough the valid cardcodes until you find a card code that matches the "search string" the closest. Then you can use that card code with the special prices object.

To search the cardcodes you can use a normal record set object and use the SQL "LIKE" command to search...

Former Member
0 Kudos

Hi Andrea

I also had this issue. I worked around it by inserting a valid CardCode (ZZZLLLPP for example which won't be used elsewhere) and the after generating the new specialprices i've updated them back to "*1" via recordset - query.

hth

Former Member
0 Kudos

*deleted doublepost

Former Member
0 Kudos

Thanks, i'll try ...

bye

Andrea

barend_morkel2
Active Contributor
0 Kudos

Hi Andrea,

There is no Object to access the Hierarchies and expansions directly.

What you can do is this:

Dim sp As SAPbobsCOM.SpecialPrices

'This is to access special prices

sp.SpecialPricesDataAreas

'This will access Price List Item Details by period

sp.SpecialPricesDataAreas.SpecialPricesQuantityAreas

'This will access the special prices hierarchies.

(This will allow you the "same" kind of access you are lloking for)

Hope this helps...