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

Help regarding Vendor master data.

Hi

I have a requirement to get VENDOR mobile number and email address in the report but these fields are not avilable in table LFA1 and LFB1 but it is in a structure " SZA1_D0100 " . Can any one please let me know how to load this data to 0VENDOR_ATTR ? The fiels names are Email address = SMTP_ADDR and mobile no = MOB_NUMBER.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2012 at 09:29 AM

    Hi,

    This might be the case that this field are coming from different table not from LFA1 and LFb1 so firts check fields email add and mubile number coming from exactly which table then find out any common key fields from that table to table on vendor_ATTR is based and then create a look up logic by writing a cmod code to populate that fields in )vendor_ATTR extractor.

    Thanks,

    gaurav

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2012 at 09:38 AM

    Hi ,

    We can not load data from a structure SZA1_D0100 because structure don't have data .you can go to where user list of structure and you can find the transparent table for the fields that your looking in SZA1_D0100 . you find data only in transparent table. Hope this will help you.

    M Kumar.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 02, 2012 at 10:12 AM

    Email address is from table ARD6 ie ADR6-SMTP_ADDR but this table does not have any common key .

    Please help me on how to get data ?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 05, 2012 at 10:47 AM

    If its not available, try remodelling your d/source & replicate metadata. If still you don't find it in the structure, goto extractor checker in RSA3 in source system & check. Enhance your data source to populate in case via CMOD. That must solve the issue.

    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.