Pivoting in MDM

[Former Member]

Can someone tell me about the concept Pivot in SAPMDM

[Former Member · Accepted solution]

Hi Shifali,

Pivoting is an important concept of SAP-MDM.

It is used in situation where you need to restructure you source data virtually so as to facilitate correct mapping and importing of master data into SAP-MDM.

Some times the master dat sourec is stacked vertically,this increases the number of rows and reduces the number of fields.

The field information is present as meta data and value pair,which is difficult to map and inconvienent to use.

So we use MDM pivoting to create a new pivot table which will transform the field values as field names.

PART NO QTY PRICE

101 50 $70

101 250 $60

101 500 $50

102 50 $80

102 250 $70

102 500 $60

103 50 $90

103 250 $75

103 500 $60

After Pivoting

PART NO 50 250 500

101 $70 $60 $50

102 $80 $70 $60

103 $90 $75 $60

An efficient useof PIvoting in multilingual data:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/90e42521-0645-2b10-d1b2-e9f6fab3...

Rverse Pivoting:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/a0a9cee4-9cd1-2a10-62b6-ea2acb06...

Hope It Helped

Thanks & Regards

Simona Pinto

[Former Member]

Hi Shifali,

Kindly mark the thread as answered if your Query is addressed ,So that others can refer to it for similar queries.

Thanks & Regards

Simona

[former_member182007]

Hi,

Pivotingu201D what we call in MDM is reconstructing data or rotating data .

Note: pivoting can only b done on sources which are appendable or which provides the privilege of modifying the structure. Thus sources like XML, MS Access , ORACLE provides this facility coz this is a feature in which (unlike hierarchy , joins , multiple fields) this feature on implementing make a permanent impact on the source.

Hope it helps.

Rgds

Deepak

[Former Member]

Hi,

you can Refer

http://help.sap.com/saphelp_mdm550/helpdata/en/43/12036df94c3e92e10000000a1553f6/frameset.htm

Regards

Nisha

[former_member201266]

Hi Shifali,

Pivoting is the concept of interchanging rows into columns and vise versa, In MDM we achieve this through Import Manager.

Generally when we import Updateable files(Access, XML...) and the format of the files does not meet your requirement, where in you have an column which you want as an row, then you use the option of pivot to change that column into row, and then proceed with importing the file into MDM Repository.. Similarly you can do with Reverse Pivot, for changing a row into column.

Cheers,

Cherry.