cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

sample data file download

ganesh_borase2
Participant

on ‎05-24-2012 12:02 PM

0 Kudos

Hello everybody,

I need following files

Tutorial_Prod_Attr.csv

Tutorial_Prod_Texts.csv

Tutorial_Trans.csv

please suggest the path to download the same

Thanks

Ganesh

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
‎06-11-2012 10:44 AM
0 Kudos

Hi,

Did you managed to find the following files?, if so, could you please send me the link?

Tutorial_Prod_Attr.csv

Tutorial_Prod_Texts.csv

Tutorial_Trans.csv

Thanks in advance...

regards

suresh

Show replies
Show replies
gunesbt
Active Contributor
‎06-12-2012 9:50 AM
0 Kudos

Hi,

In this thread, someone pasted comma delimited format(csv) of all3 files( consider the sample data headings having first columns as PROD ID for texts and attributes; ZD PROD for transactionals )

http://scn.sap.com/thread/1987752

You can copy and paste it to notepad and save.Then turn this notepad to excel and then csv in my opinion.(Didn't try it)

By the way, I did this exercise before so have PSA data of all 3 files in my company's IDES.I can export to excel if needed and send them to you (how to share?) but this must work.

Regards

michaellamberts
Discoverer
‎06-20-2012 1:49 PM
0 Kudos

Hi,

just tried to build the files from the link you posted, unfortunately not very successful, because I'm not familiar with csv-files. Could you upload/post the 3 files? Or has anybody found the original files on the SAP website?

Regards

gunesbt
Active Contributor
‎06-22-2012 11:40 AM
0 Kudos

Hi,

csv file is nothing but just the format of the excel file.I downloaded the data from my datasource(PSA) as excel and copy-paste here :

This is for PROD_Attribute:





ProdIDPG_IDCURRENCYPRICE
PDS01DS10USD549,99
PDS02DS10USD650,99
PDS03DS10USD600,99
PDS04DS20USD8,88
PDS05DS20USD234,99
PDS06DS20USD39,98
PDS07DS20USD15,99
PDS08DS30USD22,99

This is prod_text:

ProdIDProd DescLanguage
PDS01Notebook Speedy IEN
PDS02Notebook Speedy IIEN
PDS03PC Thinkbox IEN
PDS04USB AdaptorEN
PDS05iPhones PX2EN
PDS06 Stereo KitEN
PDS07Camera ConnectorEN
PDS08USB StorageEN

This is tutorial_trans(I did not download it from PSA, I found it in my PC but could not find others unfortunately):

ProductSales Doc Calendar DayChannelQuantityUnitRevenueCurrency
ZD_PROD0DOC_NUMBER0CALDAYZD_CHANZD_QTY0UNITZD_REV0CURRENCY
PDS07738920070705395EA1519,05USD
PDS0873892007070531EA2643,85USD
PDS02747320070706255EA35804,45USD
PDS017472200707061110EA60498,9USD
PDS02747220070706143EA27992,57USD
PDS03747220070706175EA45074,25USD
PDS047472200707063339EA3010,32USD
PDS067472200707063120EA4797,6USD
PDS01747320070718455EA30249,45USD
PDS02684520070806230EA19529,7USD
PDS076877200708071800EA12792USD
PDS0868772007080711EA5747,5USD
PDS036912200708121250EA150247,5USD
PDS04690020070812270EA621,6USD
PDS01689920070812112EA6599,88USD
PDS04689920070812455EA488,4USD
PDS04747920070815180EA710,4USD
PDS057479200708151300EA70497USD
PDS0568092007081831000EA234990USD
PDS066809200708183130EA5197,4USD
PDS03683120070822115EA9014,85USD
PDS046831200708221500EA4440USD
PDS036830200708221125EA75123,75USD
PDS066830200708221400EA15992USD
PDS04684120070825153EA470,64USD
PDS056841200708251350EA82246,5USD
PDS076854200708271675EA10793,25USD
PDS0868542007082711EA24139,5USD
PDS025431200709023120EA78118,8USD
PDS045431200709023700EA6216USD
PDS075431200709023425EA6795,75USD
PDS065073200709021300EA11994USD
PDS0850732007090211EA6897USD
PDS02560020070903215EA9764,85USD
PDS015527200709151100EA54999USD
PDS02552720070915190EA58589,1USD
PDS03552720070915180EA48079,2USD
PDS05552720070915160EA14099,4USD
PDS065527200709151775EA30984,5USD
PDS048221200709171100EA888USD
PDS058221200709171250EA58747,5USD
PDS058735200709181600EA140994USD
PDS068735200709181145EA5797,1USD
PDS03891120070922125EA15024,75USD
PDS048911200709221250EA2220USD
PDS038956200709223100EA60099USD
PDS068956200709223150EA5997USD
PDS04912320070925175EA666USD
PDS059123200709251350EA82246,5USD
PDS079444200709271900EA14391USD
PDS0894442007092711EA20691USD

All you have to do is just copying them from notepad to excel and apply the following:

http://www.softinterface.com/Convert-Text-To-Excel%5CText-To-Excel.HTM

OR you can copy paste the data in the link that I sent before and turn the comma delimited to excel similarly.

Note that there might be some very small differences between the original file and those pasted data.For example I think there is one more row under column headings row in the original files for prod for the technical name of the characteristics(see tutorial_trans) But not so sure about it.

michaellamberts
Discoverer
‎06-25-2012 7:55 AM
0 Kudos

Thank you very much! Works fine

gunesbt
Active Contributor
‎06-25-2012 12:07 PM
0 Kudos

Hi,

An edit: You don't need to follow the converter link or run some converters etc.Just copy paste the data to txt document.Then open an excel, click open (on top left), find your txt.click next next..

Loed
Active Contributor
‎07-25-2012 8:21 AM
0 Kudos

thanks a lot mate!

Former Member
‎12-20-2015 7:38 AM
0 Kudos

Thank You Güneş Büyüktanır

Former Member
‎05-24-2012 12:14 PM
0 Kudos

Hi Ganesh,

Please check the below link.......

http://help.sap.com/erp2005_ehp_04/helpdata/en/46/8df2e4ebf268e5e10000000a1553f7/content.htm

Hope it will answer your question....

Thanks,

Chandra.

Show replies
Show replies
ganesh_borase2
Participant
‎05-24-2012 12:26 PM
0 Kudos

Dear Chandra,

Thanks for reply,

I have check the same but not found.That's why I post in forum

Thanks

Ganesh

Former Member
‎05-24-2012 12:33 PM
0 Kudos

Ganesh,

Did you check the Prerequisites......? Everything is fine? Still you are not able to get the data?

I guess if the prerequisites are fine then you should be able to get the file....:-O

ganesh_borase2
Participant
‎05-25-2012 11:29 AM
0 Kudos

Dear Chandra,

I need file not data.

I need to download the said files.

Ask a Question