cancel
Showing results for 
Search instead for 
Did you mean: 

Market datafeeds

hein_nagel
Participant
0 Kudos

Hello

My client does mark to market valuation and they receive security prices on a daily basis (Excel), i would like to upload the excel data into the system without using a program, kindly advise on the configuration steps to do this.

Victor

Accepted Solutions (1)

Accepted Solutions (1)

jitesh_chawla
Participant
0 Kudos

Hi Victor,

When you execute transaction TBEX, you will find an information button on the toolbar. It has all the details you require. It has in detail all the steps and customization.

Regards,

Jitesh

hein_nagel
Participant
0 Kudos

Hi Jitesh

To get the valuation correct, the prices should be loaded per class master on the Exchange table, surely they should be some configuration regarding TBEX, does not give the steps to do that. Note that each price has to be mapped to a class master.

Victor

VishwaGopalkris
Advisor
Advisor
0 Kudos

The price is mapped to the ID Number via the Key.

Take a look at the format description for Report RFTBFF00(execute the report and click on the Blue i symbol): Importing Market Data Via the File Interface as well as for Report RFTBFF01: Output of Requests List. The requirements regarding field length, meaning, etc. are also valid here.

hein_nagel
Participant
0 Kudos

Hi

Transaction codes given do not exist

Victor

Former Member
0 Kudos

Hi,

Those are not transaction codes. Those have to be executed in SE38.

Those report programs are used to upload different market data like security price or exchange rate from a file to the SAP system.

Regards,

Ravi

hein_nagel
Participant
0 Kudos

Thanks got it, now developing the program to upload

Victor

former_member221515
Active Contributor
0 Kudos

Hello Experts.

I followed steps mentioned in Information Icon TBEX.

Proceed as follows if you use existing spreadsheets:

  • Select a file using the input help for the file name field.
  • Select the "Change" function from the toolbar.
  • Go to the title element "Spreadsheet". The contents of the spreadsheet are displayed and the "Import Market Data (F5)" function is activated

Also I checked, program RFTBFF01. It shows

Code conversion has been executed for data provider NCDEX

Message no. T2577

But when i checked FW17, prices were not updated. Please refer attached screenshot and let me know, what is the issue.

Answers (1)

Answers (1)

jitesh_chawla
Participant
0 Kudos

Hi Victor,

I didn't get your point regarding no program.

Though, I would suggest you to use transaction TBEX to load the security prices using excel sheet.

Regards,

Jitesh

hein_nagel
Participant
0 Kudos

Hello

I was referring to an external program.

Victor

hein_nagel
Participant
0 Kudos

Hi

I asume in order for TBEX to work, i need to do some configuration especially in terms of tables, and whats the difference in using TBEX and TBDM, kindly send configuration steps which go with TBEX.

Thanks

Victor