You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Create tables(DDL) from PVO metadata provided by REST API

edited Sep 9, 2024 2:11AM in Reporting and Analytics for SCM 1 comment

We are retrieving the columns details such as datatype, precision and scale using the following endpoint(REST API metadata)

Url: https://{server_name}/biacm/rest/meta/datastores/{data_store}

We intend to use this information to create tables in Snowflake. However, we are encountering an issue where some numeric columns have a precision 0 and a scale -127. Based on this information: . It seems that these values would be rounded to 10^-127, resulting in a value of 0.

Could someone assist us in understanding the appropriate precision and scale that should be applied in this case?

Example:

DataStore: FscmTopModelAM.PrcExtractAM.PoBiccExtractAM.PurchasingDocumentLineExtractPVO

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!