master data text are missing for 0matl_grp

[Former Member]

hi gurus,

              when user run report few material group text data is missing... i checked in system in rsa1 on 0matl_text and i found text data is missing for few material groups so now what i need to do?? as user need the text data to be appear in query output..

if i need to load missing data for master data object... can anyone please tell me the detailed procedure for this as i never come across a situation to load missing data in masted data object.. thanks in advance gurus...

note: please respond as it is very urgent work...

[former_member182470 · Accepted solution]

Hi,

You can directly maintain text for them by running Maintain master data on your infoobject in RSA1. You can edit those records in Maintain master data screen and save those records. You need not to load them from source again.

Regards,

Suman

[Former Member · Accepted solution]

hi chakravarthy,

actually there are10 material group which  are missing and in query out put there are few records with this 10 material group.. for suppose if we maintain this text data manually in maintain master data...is that ok or else we need to load the data from ecc to bi??

what are the step we need to take care after maintaining data manually?? thanks in advance,,,,

[former_member182470 · Accepted solution]

You can maintain them directly in BW. This will be optimistic solution. No issues will be there further..

[Former Member · Accepted solution]

thanks alot suman...

[anshu_lilhori]

Hi,

If you have data flow in place for 0mat_grp then you just need to run the infopackage---and then DTP to load the text data if you flow is 7.X.

In case of 3.X flow only infopackgae.

I hope you are aware of it.

If the flow is not in place then steps are already shared by Raman.

Regards,

AL

[Former Member]

hi lihori,

ya we are having data flow... so know i need to run info package with selection of those missed material groups?? and then dtp so that data will be uploaded... so after that when user runs query he can see the desired data...correct me if i am wrong..

[anshu_lilhori]

Yes this seems to be correct...What is the update mode in infopackage if its deltaa then run it so it may pick all the text for new material groups.

If not then run for the selected material group.

Regards,

AL

[RamanKorrapati]

Hi,

You can load full data, its master data, so no problem, its over writes.

Or as you said missing txt for  for 10 records only then you can directly maintain at info object level. save and activate master data (0MATL_GROUP).No issues/impacts.

Check at your reports.

Thanks

[Former Member]

ok and one thing data was loaded last year from then it was left untouched.... yes update mode of ip is delta... 

so now i need to run ip  and then dtp  after that attribute change run so that my issue will get solved... is this what you are saying me??? thanks alot 🙂

[Former Member]

thanks alot ramanjaneyulu...

[anshu_lilhori]

Hi,

No need to run ACR in case of text that only needs to be run for attributes.

Regards,

AL

[former_member182470]

The simplest solution is to manitain directly. Why unnecessarily getting into infopackage, dtp all this stuff. Anyway it is up to you..

[Former Member]

ya suman will try the way you suggested... thanks

[former_member182470]

All the best..

[Former Member]

hi lilhori,

             thanks man... finally i did the way you suggested as we are not allowed to add manually.

thanks a lot for all who helped me...

[Former Member]

hi lilhori,

             thanks man... finally i did the way you suggested as we are not allowed to add manually.

thanks a lot for all who helped me...

[anshu_lilhori]

Hi,

Great....good to know that.

Regards,

AL

[RamanKorrapati]

Hi Veera,

If data flow not exist, follow the below steps.

You need to activate data source and replicate into bw side.

Follow this points.

1. From ECC Side, Activate data source form RSA5, 0MATL_GROUP_TEXT - select data source and click on activate data source.

2. Check for your data source.

3. at T code - RSA3, enter your data source and execute it. check data pulls are not.

once it pulls data at ecc side RSA3.

4. Replicate data source into bw side and activate data source.

5. Create transformations to info object 0MATL_GROUP.

6. Create a info pack and dtp.

7. trigger info pack and later trigger dtp to move data from psa to target.

You need to above steps at dev system check it once. once its was fine then move all design to quality and production.

If data flow was exist, missing data for some fields, then reload info package and later respective dtp. run Attribute change run(T- code  - RSATTR)

Thanks

[Former Member]

hi ramanjaneyulu,

thanks a lot for your reply...