Skip to Content
avatar image
Former Member

Table fields download to excel !

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jul 24, 2009 at 04:29 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 24, 2009 at 04:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded