Help regarding Vendor master data.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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 ?

[sathiendiran_balu]

HI ,

you can to use the Address number ADRNR from LFA1 in ADDRNUMBER of ADR6 to get the email id

similarly get the mobile number details from table ADR2

Thanks ,

Sathya

[Former Member]

Hi Sathiendiran Balu

Can u please elaborate on how to do that .

Thanks.

[Former Member]

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.

[Former Member]

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