Partner Functions report

[Former Member]

Dear Gurus,

I want to obtain a list of all the ship to party customers assigned to a sold to party along with their address and VAT registration numbers. Please guide me.

Thank You

Kumar

[Former Member · Accepted solution]

Hi Kumar,

In standard there is no such report readily available.But you can develop a Z report.

I will provide you the logic.

Goto SE11/SE16.

Enter the table name as "KNVP".

Enter your sold-to-party.Execute.

Fetch all the customer numbers having partner type as "WE".

Pass the same into KNA1 to get the VAT registration number from the field "STCEG".

From the same table you will get the address also.

Regards,

Krishna.

[Former Member]

Hi

Ther is no standard report available as per your requirement. My suggestion would be in SAP QUICK VIEWER USING SQVI AND use the table join condition with the following tables

KNVV customer partner functions

KNA1 customer general data

you will get the desired report

regards