Loading Text Masterdata T151T to BI7

[Former Member]

Hi Experts,

I'm trying to load the contents of Text Masterdata table in ECC (Table name T151T) to BW.

I have only done creating Transaction data via LBWE and then replicating it to BW.

I'm not yet familiar in creating source systems for Text and Masterdata.

Is there a SAP Standard extractor for this Text Data?

I found a similar Discussion thread but there's currently no correct answer...

Thank you for your time.

[RamanKorrapati · Accepted solution]

There is no standard data source. As stated by Anshu, go with generic data source based on view or table.

follow below steps.

1. Create generic text data source based on table T151T. Use above t code

2. Do the test case at RSA3, if you see the require data, its fine.

3. in general text data source need to have primary info object, language, short/medium/long descriptions.

4. once your data source works as you need, then replicate into bw side.

5. migrate to 7.x data source and create transformations between data source and primary info object

6. at bw side primary info object need be insert as info provider then only you can create transformations.

7. create info pack and dtp. do the test load and check it.

8. at dtp level you can choose handle duplicate record key.

Thanks

[Former Member · Accepted solution]

Thank you AL and RK,

When I try to create Generic Data Source in RSO2 I get the following error.

Do you know what this means?

"Entry T151T does not exist in DD02L"

[RamanKorrapati · Accepted solution]

Hi,

At your source system, Go to SE11 - Table name - DD02L, try to see the contents.

TABNAME - T151T and see the results. you may get 0. if 0 then you may need to maintain T151T table entry at table DD02L.

Take functional help and check about required changes.

Thanks

[Former Member · Accepted solution]

Hi Juan,

Can you check if this table actually exists in SAP datadictionary? Go to SE11 and try to display table T151T. please check if this is in Active status.

Also try to activate it again in SE11.

There is no explicit way to update DD02L. If you have this error it means that this table does not exist in active state.

In extreme cases you may update the table DD02L via ABAP program.

You need to write a single statement in ABAP program. But this is not the standard practice and should be only used in extreme cases.

Thanks

Amit

[Former Member · Accepted solution]

Hi RK,

Yes the Table T151T exists in the Source System (ECC)

But in the BW system, the T151T table does not exist (which is correct right?)

it doesnt need to be in BW right because in BW we use DataSources correct?

[RamanKorrapati · Accepted solution]

But in the BW system, the T151T table does not exist (which is correct right?)

it doesnt need to be in BW right because in BW we use DataSources correct?

Yes, at BW side not required.

I assumed that your are creating data source at ECC side Tx - RSO2.

[Former Member · Accepted solution]

Sorry for the confusion. I thought I need to create the Object in BW side.

Thank you very much. I will do this now on ECC. Then replicate it to BW after testing in RSA3.

[anshu_lilhori · Accepted solution]

Yes that table is in ECC only and you need to create the datasource in ECC only based on that table.

Then pull the data in BW with the help of infoopackage and then other steps are already given by raman in sequence.

Regards,

AL

[Former Member · Accepted solution]

Thank you everyone for your help. Here are the complete steps that I did I also included the transactions and how to create the Objects and Transformations within BW.

1. Go to Source System/ECC: Go to RSo2 -> Create Generic Data Source -> enter View/Table = T151T and SAVE

2. Go to Transaction RSA3 to test the Datasource, Enter the DataSource Name and execute, check if all data are correct.

3. Go to BW System: In RSA1 -> Go to DataSources -> Rightclick and click Replicate Metadata.

4. A prompt will appear "How do you want to create the object in BI" -> choose "as Datasource (RSDS)"

5. The Datasource will now appear. Right Click on it and click "Change" and then Activate Datasource (CTRL+F3)

6. Right Click the activated Datasource and choose "Create Transformation"

7. In Create Transformation: Select Object Type = InfoObject and Subtype Object = Texts, and the name of target infoobject.

8. Connect the Fields from source fields to target fields in the Transformation then Activate.

9. Right click the InfoSource and Create Infopackage. Then Execute the Infopackage. Check the Result (in PSA).

10. In RSA1 go to InfoProvider Tab -> Search for the Target InfoObject

11. right click target InfoOjbect -> "Create Data Transfer Process" -> Activate the DTP -> Execute DTP.

12. Check if the DTP finishes successfully. Open the Target Master Data info object if the Text Data is now available.

[RamanKorrapati · Accepted solution]

Thanks for your approach in detailed.

Small info about:

point 6- in your case you have target info object as info provider, so directly you created transformations.

Point 9 - Once data source was in RSDS then there is no info source exist in bw. ecc and bw side we call it as data source.

[Former Member · Accepted solution]

Thank you RK for the additional information

[anshu_lilhori]

Hi, You can create generic datasource based on that table with the help of tcode RSO2. Enter tcode RSO2--Choose Texts-Give the meaningful name..In view/table give the table name as T151T. Save the datasource. Replicate the same in BW..Follow the other modeling steps. Regards, AL