We couldn't find anything standard in our system (R3, 4.7) so we built a relatively simple query using tables:
KNA1 Customer Master General Data
KNVV Customer Master Sales Data
KNB1 Customer Master Company Code Data
...which represent the the three main views of the customer master, as accessed via T-Code XD01, joined together with...
KNVP Customer Master Partner Functions
... to allow a relationship between sold-to and ship-to to be more clear.
There are dozens of other tables of customer master data (most notably credit control, VAT, dunning, and bank details, but also tax, shipping, licenses, loading points, etc.) that you could also try to attach but the query would become too unwieldy to operate. You could also try using the logical database VDF but this only contains table KNA1 and KNB1 of those listed above.
Your T-code /SIE/ASP_FI_MASTER is probably specific to your company (as the suggested VCUST T-code is probably to the company of the person who proposed it).
Hope this helps,
ChrisO
| | | ---------------Original Message---------------
From: Elizabeth Long
Sent: Tuesday, October 18, 2011 3:51 AM
Subject: Customer Master Data Report
Hi all,
May I know if there is any T-code that can extract all Customer Master Data for both 'Sold-To-Party' and 'Ship-To-Party'?
I used T-code "/SIE/ASP_FI_MASTER" but it only display those 'Sold-To-Party' customers'.
Please help.
Thanks,
Liz |
| __.____._ Copyright © 2011 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
| |  ChrisO
SAP Logistics Sales and Distribution Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement Popular White Papers
In the Spotlight   _.____.__ |
