SoldTo Description

[Former Member]

Hi,

We have an issue that there is an inconsistency between the mdm soldto description vs soldto desciption loaded to SAP.

Where can I check for the soldto description field ?

I tried to find on the soldto infoobjects/infoprovider to see if there is any soldto description attribute,but I did not find any?

I need to verify the data in SAP for the SoldTo description.

Thank you.

[Former Member]

Hi PMR,

0SOLD_TO is  reference of 0customer.  So if you have loaded 0customer then text will come properly..

The datasource for 0customer  text is : 0CUSTOMER_TEXT. try to check  whether for that customer 9 sold to paty) txt is maintained in ecc. KNA1  text table,

regards,

Rajesh

[former_member203104]

check read_text function module in ECC

you will get the text information

[Former Member]

Hi PMR,

You can follow below steps:

1. Get the mismatching sold-to no. from users.

2. Go to sold-to infoobject in your system -> expand that(you should have two datasources one for attributes and other for text)

3. right click the text datasource and check the text data for sold-to.

4. Go to source system -> Go to SE16 and enter table KNA1

5. Display the customers which are present in BW system with mismatching text.

6. Find out the text and capture the snap shots of both.

This way you can pin point the text description issues.

Now to fix the issue:

1. First of all check the data getting extracted in source system RSA3

2. if data is fine this means that issue is in BW system - most probably in the transformations or update rules.

3. go to BW system and expand the text of Sold-to info object and find the rules applied. If there are any special rules applied analyze that.

Please let us know your findings and then we can suggest more.

Thanks

Amit

[Former Member]

Hi PMR,

Please check the source for sold to text.

If you are loading from ECC you can directly load the data into your PSA for any sold through infopackage  and check what values are coming.

If you are loading from Non ECC system that is via XI/PI you may have to contact relevant team.

If you are loading from ECC you can directly check in Tcode XD03 (customer master0, text description will be avaiable.

Thanks

[former_member183012]

Hi PMR,

You need to analyze your issue with following steps

1)Take any set of sold to party

2)infoobject level findout description of that @ BI side

3)same way take similar set of sold to party @ ECC level

4)Comapre both

5)AS you said there is diffrence vetween R/3 and BI

6)Understand the data flow for sold to party from r/3.

7)Load text for some wrong sold to party and activate then check it will match

8)If it is still not match then check any logic will applied while loading.

Hope this will resolve your issue.

Regards,

Ganesh Bothe

[KodandaPani_KV]

Hi,

Please check the SoldTo object text in object level.

go to info object -> select the master/text -> select the short, medium and long text .

Thanks,

Phani.

[Former Member]

Hi,

I see that the medium length texts exists is checked for the SoldTo infoObject.

What exactly does this indicate related to this issue?

Thank you.

[KodandaPani_KV]

check the maintain master data for sold to info object.

select your info object -> right click -> maintain master data -> execute.

[KodandaPani_KV]

Hi,

you can do these setting at info object and BEx designer.

select your info object  -> go to business explorer tab -> select the test type and BEx description.

for your requirement.

In BEx designer select the info object -> go to properties -> select the display as text.

Thanks,

Phani.

[Former Member]

Hi,

Sorry,I think I wasnt clear enough about the issue we have.

This is a data related issue,the data source is not matching with SAP loaded data.

SO the users are seeing different SolTo decription value for a particular record when compared to source.

So I'm trying to track as how this got loaded into the SAP system.

I checked the transformation and I see that it is 0CUST_SALES -> 0TXTMD but how can I check the data under this field?

Thank you.

[KodandaPani_KV]

Hi,

please check the data source for the 0CUST_SALES text in ECC system.

can you share the screen shot.