regarding field names

[Former Member]

i need to develop Interactive ALV report to display monthly detail sales report based on Salesman Number, Sales Name, Customer Code, Activity, Description, and Total Amount. Upon clicking the Sales man Number gives sales report of the particular Sales Man every month.

can any tell in which table can i search for the fields

rewards for sure

[Former Member]

i need to develop Interactive ALV report to display monthly detail sales report based on Salesman Number, Sales Name, Customer Code, Activity, Description, and Total Amount. Upon clicking the Sales man Number gives sales report of the particular Sales Man every month.

can any tell in which table can i search for the fields

rewards for sure

[Former Member]

Hi,

Check View,

MASSEKKO Purchasing Order Header and table,

EKKO Purchasing Document Header

LFM1 Vendor master record purchasing organization data

LFM2 Vendor Master Record: Purchasing Data

WBHD Trading Contract: Commercial Data

The Dataelement is EVERK (Responsible salesperson at vendor's office). Goto Transaction SE11 and use this dataelement and find tables using Where used List. You can get lot of Tables and Views but i have listed only few from there.

Hope this might Help you.

Thanks and Regards,

Prashanth

[Former Member]

Hi,

You can find any type of field in SAP using this table in SE12.

<b>Table-DD03L</b>.

Regards,

Pradhan.

[Former Member]

Thanks Prashanth

But i am unable to find out salesman number activity and description.

Interactive ALV report to display monthly detail sales report based on Salesman Number, Sales Name, Customer Code, Activity, Description, and Total Amount. Upon clicking the Sales man Number gives sales report of the particular Sales Man every month.if any body has previosly done it plz send me the code

points for sure

[Former Member]

U would be able to find the sales person responsible information in customer master. If you check the Sales Area Data, it has the tab for partner functions and in that you would get the contact person information.

I am not sure of what do you mean by activity and description ?

But as you can get the customer code and sales person information...you can read the sales order table to get the total amount for that customer.

[Former Member]

U can check the below tables and it has the required information..

VBPA - Sales document partner function

(here u will get information about the customer and sales person)

VBKOF - you would be able to get the activity and description

VAKPA - sales information for the particular partner function.

[Former Member]

can any please give the code for this