Report: INFOSET QUERY REPORT

[Former Member]

Dear SAP Guru's ,

I need to design a report on Customers Sales figures for the month alond with the sales person responsible.

The sales person responsible is existing in the PE sales partner Feild: KTONR

and The Tables of KNA1 customer and BSEG for the sales data.

Please tell me whether it can be possible infoset query ...? and How?

As the tables of PE ,KNA1 and Bseg cannot be joined..

please help me out

regards,

SAP SD

[Lakshmipathi · Accepted solution]

Dear SAP SD

I did search for the field KTONR in KNA1 and BSEG but I could find in neither of the tables.

Moreover, for taking sales data, I dont know why you are taking KNA1 instead of VBRP and VBRK.

Probably, if you can explain a little bit more about your requirement, it will be helpful for others to reply in case I am not able to give you a feedback.

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Dear G. Lakshmipathi,

The Reason of using BSEG rather than VBRP and VBRK.

because the customer sales data is uploaded as JV in Finance accounting and not as sales order cylce....

I have assigned sales employee responsible in the partner function which acceses the HR table of employees.

I now need to disply a report in

1. Customer

2. Sales Employee responsible.

3. Sales Data/revenue.

Also the sales employees are county code wise.

Thanks

regards,

Amlan Sarkar

[Former Member · Accepted solution]

Hi....

I have a suggestion...

can u try using infostructure S006....

Pl c the onfostructre in MC23

hope it could help..

regards

krishna

[Lakshmipathi · Accepted solution]

Dear Amlan

In BSEG itself, the field what you are telling (PERNR is the field for Personnel No) is there. You can make use of it and generate the required report.

thanks

G. Lakshmipathi

[Former Member]

No report can be generated through infoset query for this particulat problem....

My ABAPer will have to burn the midnight oil now...

Thanks for you help.

regards,

Amlan Sarkar