Monday 23 October 2017

Easy way to create the bulk records of value mapping in SAP HCI/HCP

As I faced the issue when creating the value mapping in the WEBUI, created manually some of them. Then I had a 300 value mapping, so manually creating all takes huge time. So we can achieve this by adding that in the value_mapping.xml file as per below structure.

<vm>
    <group id="1">
        <entry>
            <agency>ORACLEID</agency>
            <schema>Nationality</schema>
            <value>101</value>
        </entry>
        <entry>
            <agency>C4CID</agency>
            <schema>Nationality</schema>
            <value>AF</value>
        </entry>
    </group>
    <group id="2">
        <entry>
            <agency>ORACLEID</agency>
            <schema>Nationality</schema>
            <value>172</value>
        </entry>
        <entry>
            <agency>C4CID</agency>
            <schema>Nationality</schema>
            <value>AX</value>
        </entry>
For placing the 300 entries in the above structure, I have created one more Iflow which will give the table to this above xml stucture.


IMG 0006

Then copy all the output file and remove the entry1 as entry and append this in the earlier value mapping file which is deployed. Then again deploy it.




No comments:

Post a Comment