cancel
Showing results for 
Search instead for 
Did you mean: 

CP-DS Data Transformation without input file

willsuus
Participant
0 Kudos
215

Is there a way to set up the population of a MDT without using an input file?

I have a master data type that is two fields and is fed by one entry in a file that never changes. Can you just set the fields in the MDT to the values needed and not worry about having a datastore set up in the transform as the input data?

MDT: ZSMDT

Fields: ZID; ZAAKF

Values: 1; <null>

My understanding is that this MDT needs to be updated daily (with a REPLACE operation).

Accepted Solutions (1)

Accepted Solutions (1)

peter_casper
Contributor
0 Kudos

Hi Susan,


you can either do it the way Jorge suggests or create the particular entry directly in CI-DS in case you are anyway connecting to it. I would recommend to have one single source for data integration, i.e. CI-DS.

The creation of a static entries on a daily basis (I assume in order to feed values for attribute as a key figure) can be set up pretty easily in CI-DS using the row generation functionality within a data flow. There you specify the number of records to be generated. The Query and Filter Step gives you the opportunity to define as much fields as you need. In your case it will be ZID and ZAAKF. Last step would be to put the constant values 1 and NULL into the mapping section of the respective fields.

That's it. I hope this helps.

BR, Peter

willsuus
Participant
0 Kudos

Thank you, Peter. This is exactly what I was looking for. It was very simple to implement.

Answers (1)

Answers (1)

0 Kudos

Hi Susan, this can be achievable through the new Fiori APP "Manage Rules for Master Data Maintenance".