Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Pivoting in MDM

Can someone tell me about the concept Pivot in SAPMDM

Tags:
replied

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-e9f6fab39856

Rverse Pivoting:

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

Hope It Helped

Thanks & Regards

Simona Pinto

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question