Skip to Content
avatar image
Former Member

How to extract Quantities and Unit of Measurement MS Excel from Business Configuration

Hello,

I wanted to extract Quantities and Unit of Measurement from Business Configuration. Please provide steps and help on how to extract to MS Excel. Please see attached pictures for reference. Thanks. 1.png2.png3.png

1.png (70.7 kB)
2.png (66.0 kB)
3.png (57.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 31 at 01:17 PM

    Hi Mick,

    did you already consider extracting the UoMs using web service QueryCodeListIn?
    I described the web service in a blog post some time ago: How to get ByDesign Code Lists via Web Service QueryCodeListIn

    Alternatively you can get code lists using OData. Just expose a business object that contains the code list via OData using work center "Application and User Management - OData Services" and select the checkbox "Include Code Descriptions". As result you get a collection to read the corresponding code list incl. the description.

    Regards, Knut

    Add comment
    10|10000 characters needed characters exceeded