Skip to Content
author's profile photo Former Member
Former Member

SoldTo Description

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Posted on Apr 25, 2014 at 02:39 PM

    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.


    pastedImage_1.png (33.0 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 25, 2014 at 02:45 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 25, 2014 at 04:37 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2014 at 06:11 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 25, 2014 at 07:22 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 26, 2014 at 01:53 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.