Delivery report output for'Ship-to party address and Sold-to party address'

[Former Member]

Hi Experts,

We have an report output generated upon delivery creation.

We need print following fields:

-

---

Ship-to party #

Ship-to party Name

Ship-to Party Address

Sold-to party #

Sold-to party Name

Sold-to Party Address

-

---

As per i understand, we could get those field according to partner function....

So experts, could please advise me from which table and field and logic to get above information....

Thank you very much!!

[Former Member · Accepted solution]

Thanks everyone.

As i know i could get the ship-to details like following:

Address is taken from Customer master using Ship-to customer from delivery document (LIKP-KUNNR = KNA1-KUNNR) Get KNA1-NAME1, KNA1-NAME2, KNA1-STRAS, KNA1-PSTLZ, KNA1-ORT01)

But now my questions is how to get corresponding address of Sold-to party or Payer...according to delivery document...etc As what exact partner function code like RE/SH..etc for sold-to party/payer...

Thank you very much!!!

[Former Member · Accepted solution]

Hi,

Are you changing partner details in delivery document?

This partner address details will be updated in VBPA table.

E.g change the partner street no. in delivery document manually.

Now goto VBPA table, enter correspondence sales document number for that delivery and execute.

Click on partner function AG / WE get the address number (ADRNR) .

Now goto ADRC table, enter this address number in ADRNR field and execute. you will get partner details.

Regards,

Chandra

[Former Member · Accepted solution]

Dear Chandra,

You provide 2 solutions...what if i use your first way like find sold-to and ship-to number from LIKP table, then get corresponding details from KNA1 table...

What will be the possible issue if i dont use your second way??

Thanks.

[Former Member · Accepted solution]

Hi,

We can change partner address data manually in delivery document, that is applicable only for that document. It will not be updated in KNA1 table.

So second option is useful.

If you are not changing any partner address data in delivery document, so you can use LIKP and KNA1 tables.

Regards,

Chandra

[Former Member · Accepted solution]

Hi

From KNA1 you will not get the full address i.e. you will get following

Street, City, Postal code, Region, country, etc

whereas using ADRNR and passing it to ADRC table you will get full address fields i.e.

Street2, street3, street4, Building code, Floor,

As per your address requirements you can use the above tables.

Regards,

Nimit

[former_member217082]

Hi

Get the data from KNA1 & VBAP tables for ship to party and sold to party data but check in LIPS & VEPO tables at delivery level as the ship to party may change at delivery level also .

Regards

Srinath

[Former Member]

Hi,

Use LIKP table, sold to party and ship to party fields are available in this table.

Get the customer numbers from there, and retrieve the data from KNA1 table.

Regards,

Chandra

[Former Member]

Hi,

Partner function details exists in VBPA table.

Use Sales Order or Delivery Order number as reference key (field VBELN) to read VBPA table.

After that, take address number (field ADRNR) in VBPA table for getting address details by calling function module "ADDR_GET".

Put your address number (value of field VBPA-ADRNR) into field ADDRNUMBER of ADDRESS_SELECTION part.

Hope this help.

Cheers,

[Former Member]

table kna1---->customer master.....(just pass customer no and get other fields as below)

fields name1

ort01

etc.....

otherwise u can go to table knvk based on patner function.......