Question:
Hi guys, We have one requirement where I have to retrieve 0CUSTOMER from Customer master data given only 0DBDUNS_NUM. This DUNS ID is coming from flat file and I have to fill 0CUSTOMER into ODS. Can anybody gimme the transfer routine code???? Appreciate your response.
thanks,
merdiz
Answer:
uhh sounds very simple....
select from customer master data table
where duns number = supplied duns number
or am I missing something?
Obviously you may have more than one internal customer number with same duns number then you need to decide what to do
Answer:
look for the keyfields in the customer master data table (tx se11) and add these to the where statement:
...
where dunsnumber eq supplieddunsnumber
and objvers eq 'A' " only active records
and ..... .