SolMan Extraction

[Former Member]

Hello all,

I need an extraction of all S-USER and Business Partner from SolMan' tables. Is it possible ? if yes, which is the transaction name (or number) to perform that action.

Thks

[Former Member]

Hi Laurent,

You can get S-user id information from the transaction code AISUSER

For Business partner infromations , you can browse thru the below tables

BUT000 : BP: General data - Contains Business Partner Number, Partner Category, Partner Type, First Name, Last Name etc.

- BUT020 BP: Addresses

- BUT050 BP relationships/role definitions: General data - Contains Relationship, Partner Number (PARTNER1), Relationship Category

- BUT051 BP Relationship: Contact Person Relationship Similar to

- BUT050 additionally contains Contact Person's Address data

- BUT0BK Business Partner: Bank Data & Details BP Number, Bank Key, Bank Country Key, Bank Account Number

- BNKA Bank Master Data

- BUT100 BP: Roles

- ADR2 Telephone Numbers (Business Address Services)

- ADR6 SMTP Numbers (Business Address Services) - Contains Email - Id of the BP.

- ADRC Addresses (Business Address Services) - BP's Complete Address Details- City, Country, Post Code, District,

Street, Title No Etc

- TSAD3T Table containing the Title text against a Title No.

- COMM_PRODUCT Master Table for Product

- CRMM_BUAG Master table for Business Agreement

- CRMM_BUAG_H Header Data for Business Agreement such as Tax Category, Tax Characteristic, Form key, Business Agreement Class. Data in this table correspond to ISU

- CRMD_OPPORT_H OPPORTUNITY HEADER DATA

- CRMD_ORDERADM_H Contains the Header Information for a Business Transaction.

[Former Member]

Thank you for your reply, is there a way to have in a same result, for instance :s-user/partner number/ partner name...

regards