Table fields download to excel !

[Former Member]

Guys,

i have two questions;

1. In SE 11, data dictionary, I want to download all the fields details like Field,Data element,Data type, length to an excel sheet. How to download to excel?

2. I want to know the table or any source name, where I can get the details of customer Id and Ship-to-party mapping.

In other words, for example customer 123 has, 123 as billtoparty, soldtoparty and payer and 789 as SHIPTOPARTY in the Partner function tab of customer master.

Where or How can I find from the table that customer 123 has the shiptoparty 789?

Thanks

[former_member1249468 · Accepted solution]

Hi ,

Please pass the customer no (KUNNR) to VBPA:KUNNR and get the details of all partner functions.Select the partner function PARVW as SP for sold-to-party ,SH as for ship-to-party ,PY as for Payer and BP as for bill-to party.

Hope it helps.

Regards,

Pasapula.

[Former Member]

Hi

For your second question go to table KNVP and give your customer number. It will show all your partner functions for all sales area the customer has been maintained.

Regards

Indranil