Master Data

[former_member775194]

Hello Guru's ,

There is a group company with 8-9 company codes and many modules ,  they have sd and mm but not in every company code . Present Issue is on  data extraction of a company code which doesnt have any cross modules (means there are no sd and mm).  Now the client who is buying this company code asking for shipping address and ship to party details.

A program is created for data extraction and for customer master's a program is developed .

In  the Functional spec for the program , mentioned table KNVV or KNVP which is partner function table and the ship-to-party field and the partner number which is actually the customer number only

(Assuming Sales area data is at client level)

(Assuming the customers are same across client) and therefore I can get the shipping info based on the customer number logic .

If KNVV-SHIP TO PARTY = LFA1-KUNNR than get the shipping address (mentioned the fields)   ----  Is this logic Right or Wrong ?

Please help with this .

Thanks and Regards,

Ravi Kiran

Message was edited by: G Lakshmipathi

Please use the subject effectively and avoid adding such texts

[former_member184065 · Accepted solution]

Dear,

Actually,LFA1 -KUNNR will be used in STO ( Intra and Inter process ) and Inter company sales process .If you want Ship to party and shipping details then you can use ,KNVP and update Partner function as SH and pass them in KNA1 table and get the details.

Note: Please dont make query heading as " Hello Gurus ",maintain heading as relevant to Query .This would be very helpful to get details from Google based query heading by someone.

Thanks,

Naren

[moazzam_ali]

Hi

KNVV is customer master sale area data table and LFA1 is vendor master data. Why are you comparing customer from KNVV with LFA1 customer number? I didnt get reason behind this.

If you want to have ship to party addresses then I have one question. Do you have differrent ship to  assigned to different sold to? Like for example normaly we have sold to ship to bill to and payer same but in some casses there can be more than one ship to assigned to one sold to. Is this case with your company? Why dont you just select partner function ship to from KNVP and pass them in KNA1 and get the addresses.

Thank$