Store custom data in SAP DM

[Private_Member_221638]

Hi

Is it possible to store custom data in SAP DM? Like you can create MDO tables in SAP MII?

Thanks

[ManoelCosta · Accepted solution]

Hi Pieter,

You can store Custom Data against several Master Data Objects, like Materials and Orders, which can also be integrated from ERP, see this example for more details.

For something like SAP MII MDOs, you must use BTP. See this example using mssql and Kyma.

Hope it helps,

Manoel

[Private_Member_221638 · Accepted solution]

Hi Manoel

On the roadmap I notice the following for Q1 2024:

Ability to read manufacturing data objects (MDO) data from enterprise SAP Analytics Cloud or SAP Datasphere

Is Datasphere something we could use for this? It would be nice if that's plug and play where you can do direct queries in production processes to tables on Datasphere.

[celanoalberto · Accepted solution]

Hi Manoel,

there is also some specific API in DM to get/set the custom data against a Master Data Object ?

Thank you!

Alberto

[ManoelCosta · Accepted solution]

Hi Alberto,

You should be able to read/write Custom Data using Production Process Services and Public APIs specific for each specific Master Data Object type.

Br,

Manoel

[celanoalberto · Accepted solution]

Hi Manoel,

I already tried to find how to retrieve Custom data for Operation

but even in the documentation about APIs https://api.sap.com/package/SAPDigitalManufacturingCloud/rest

I was not able to find anything. Are you able to suggest something to be tested ?

Thanks!

Alberto

[ManoelCosta · Accepted solution]

Hi Alberto,

Have you tried GET /masterOperation which returns:

  "customValues": [
    {
      "attribute": "string",
      "value": "string"
    }

See: https://api.sap.com/api/sapdme_operation/path/findMasterOperationUsingGET_1

Or GET/routings which returns:

              "routingOperation": {
 ..........
                "customValues": [
                  {
                    "attribute": "string",
                    "value": "string"
                  }

See https://api.sap.com/api/sapdme_routing/path/findRoutingByPlantAndNameAndTypeUsingGET_1

?

Br,

Manoel

[ManoelCosta]

Hi Pieter,

This roadmap item is on Datasphere querying DM MDOs only, not the other way around.

Although Datasphere can definitely support a vast amount of use cases, to store extra Master / Transactional data for DM, which I understood is your requirement, I highly suggest you use BTP as previously stated.

Br,

Manoel