Report Customer and all ship-to partners

[Former Member]

Hi Gurus,

I would like to have a report that displays a customer and all ship-to partners...

could you please help me with this, is there a standard report in SD for this or Do i need to combine different tables to achieve this..like a query..

please share your ideas..

Best Regards,

Shree

[former_member184701 · Accepted solution]

dear,

you would try to build a new sap query based on KNA1, KNB1, KNVP, VBPA tables

or request an abaper for new custom rep

regards,

[Former Member · Accepted solution]

Could you please tell me, what is the exact field in these tables that denotes the ship to.. which i could use in the sap query..

[suman_sardar2]

Hi Kumar,

Please take KUNNR,NAME1 from KNA1 and join KNVP with the help of KUNNR (Primary & Foreign Key combination) where PARVW = SH(Conversion value=WE) and fetch all the KUNN2 and fetch the NAME1 from KNA1 where KUNN2=KUNNR.

If you have any issue regarding the Field technical name plz go the SE16N and check the technical name.

Thanks,

Suman

[former_member188027]

Hi Shree,

You can use T Code VC/1 ( Busness Partner Information) here in selection screen you have option

Partner function (SP,SH....). Also you can use RVKUSTA1 execute in SE38, Standard Report S_ALR_87012179 can help you for your requirmnt.

Rgrds,

Anand

[Former Member]

Hi Shreeyath,

Develop a Query by joining KNA1 and KNVP tables.

Regards

Raju