Issues with extraction

[Former Member]

Hi,

I have some issues while extracting the data from R/3.

How to copy the data from standard tables to generic table(Ztable). I need data to be displayed in the Ztable

How to avoid duplicate records from view?? Is there any way to create Primary keys in Views??

Also, another question in reporting

How to format the reports which should display 000 as prefix eg: sold to should be 000323002 but it is displaying 323002??

Please can you provide me the solution.

Thanks & Regards

[Former Member]

Hi,,

This issue has been solved by creating staging ODS. Reporting issue has been resolved by using the display text.