standard SD tables

[Former Member]

Hello,

Where could we find these tables: T005T, T005U, T009, and T009B ?

We need them for generating time series in Hana Studio according to here: http://scn.sap.com/docs/DOC-25977.

Thank you,

Ana

[Former Member · Accepted solution]

Hello,

If i am not wrong you are asking in ABAP correct.

Then Try thr Tcode /nSE11    or        /nSE12       or /nSE16.

In SE11 you will got each and everything related table means what filed and column is there.
in SE16 you will be able to see data of that table only.

Lemme know if you have some other Question

BR

Chandra

[Former Member · Accepted solution]

Hello Chandra,

Actually, I'm working directly in SAP Hana Studio. I don't have ABAP installed, or anything related to it.

I tried to find those tables with the "Find table" wizard, but it doesn't find them.

The reason why I need them is to generate a time series with the "Generate Time Data" wizard. From what I could find out:

While using this option you need to replicate the standard table into SAP HANA that is T005T, T005U, T009, and T009B. If these standard tables are not available then you will not be able use the “Generate Time Data” function.

Thank you for your help,

Ana

[Former Member · Accepted solution]

Hello Ana,

If it's not related to SAP setups/ ABAP then in that case you need to import the table from SAP system.

The main reason behind it your Hana studio may be not linked with the SAP HANA DB exp. your backend can be SQL etc. if you linked it with the HANA DB then all table will be there automatically otherwise you need to Import the table and Data Provisioning.

BR

Chandra

[Former Member]

Hi,

Check we  SE16 and put your table and check the fields available in that table.

Then check your available data like what is available and what you need from that table.

Like here if you have country code "DE" then you can put to T005T table to find the description of the country like that.

Hope it will help you to understand.

Regards

Pitabash

[former_member186385]

Hi ,

You can get them from SE16

call the transaction code SE16 and insert the tables

T005T =  Country Names

                Transaction code = OY01

T005U =  Region Keys

                Transaction code - OVk2

T009   =  Fiscal year variant

                Transaction code -  OB29

T009B  = Fiscal Year variant period

                Transaction code - OB29

let us know if you need more details

regards,

santosh

[Former Member]

Hey,

Thank you for answering.

Indeed, I do need more details. How do you call that transaction from Hana Studio?

Thank you,

Ana

[Former Member]

There you can't call the Transaction.

Use the following Snap shot it will help you.

Now give the table name it will open all the table with that name. use the table T005T(SAP_SID), Expl for Table T005T.. use for the all..

SID means your System name.

BR

Chandra