Sales order report

[former_member822355]

I need a report like this:

|Sales Organization | sales order number | Customer Code | Customer descript | Totale Net Weight

The report should be filtered for all thes sales order colletecting in the current day… I need to run this report for ALL sales organization of my installation and to schedule it in order to send email to my sales account....

Any standard solution?

Best regards.

Thanks

[Jelena]

There is no standard report/infoset. By the way, there is no need to add KNA1/ADRC just to get the customer's name. By default the infoset will bring in all the relevant texts. It won't be visible in the infoset itself, but when you go to create a query, you'll see additional group 'Text fields' at the bottom.

VBAK-KUNNR is sufficient for Sold-to but, if definition of "customer" is different, then VBPA table will need to be added. There is no need for extra field if NTGEW can be used "as is" (standard ALV will do the totals). Extra field will only be needed if you need, for example, to subtract returns. By the way, order type should probably also be one of the parameters.

For the date make sure you use Order Date or Creation Date because there is a secondary index available in VBAK. If you use a different date, the report will not have a good performance.

SQVI is user-specific, it can't be used for this purpose. Also it lacks additional functionality for the texts that I mentioned above.

Actually for these requirements a custom infostructure (SIS) might be a great option.

[siva_vasireddy2]

Dear Silvana,

                 you can map this report by yourself directly in SQVI by clubbing the net wieght of all items

in VBAP-NTGEW.

Shiva

[former_member211616]

Hi Silvana ,

|Sales Organization | sales order number | Customer Code | Customer descript | Totale Net Weight

The report should be filtered for all thes sales order colletecting in the current day… I need to run this report for ALL sales organization of my installation and to schedule it in order to send email to my sales account....

Any standard solution?

you can go for ZReport

Header
Sales Organization  VBAK-VKORG

sales order number   VBAK-VBELN

Customer Code           VBPA-KUNNR

Customer descript      ADRC table

Mat Desc              vbap-arktx

Total Net Weight    NTGEW

Period

Regards

Ramesh

[former_member182378]

Ramesh,

Customer Code           VBPA-KUNNR
Customer descript      ADRC table

1.

If you want to extract customer from table VBPA, then you would have to give partner function PARVW too.

Customer in VBPA could be either one of SP, SH, BP, PY.

This information related to PARVW is necessary.

Better option, to get Sold to party is to extract it directly from VBAK-KUNNR.

This way extraction logic does not have to go another table (from same table VBAK - VKORG, VBELN, KUNNR can be extracted)

2.

For customer name, this can be got from KNA1-NAME1

Test point 1 in test system.

Furthermore test KNVP too, partner function information (not at sales document level but) at customer level.

It might be beneficial and interesting.

[former_member822355]

Thank to all for you usefule answer... finally, is there an infoset already available with the necessary information??

[former_member182378]

............t | Totale Net Weight

Silvana,

Why is "Total net weight" a field in your report? Could you please give the business reason for this?

For me, field "Net value" in the report looks more "apt".

Total net weight is at line item level, if needed it would have to be totalized from the line item level to give in your report (which is at sales order / header level).

[former_member822355]

In my business , the total weight is an important key indicator: it give us the ideas of how many kgs (chilos) of order have been collected during the day ...THe net value is not very useful, due to promotion, discounts, etc...  So, is there a standard way?

[Former Member]

Yes. You can do it in standard way.

Use query reports.

SQ02 to create and join those standard tables and fields you mentioned. And for weight, you can add Extra field and do you calculation in codes for this extra field.

For customer code, you should get it from VBAK-KUNNR instead. For Customer descript, you just need to add it in extra field and do your code selection from ADRC table.

Let me know if you need more information. But hope you also do some research on how to do query.

[Former Member]

To send email from query, it is also possible too. Hope you can do some research first. If you are stuck, let me know again.

[Former Member]

Hi,

    No standard report is available for  your requirement, as suggested by krishna you can create a zreport by giving the FS to ABAPer by using the Tables of VBAK, VBAP, KNA1

[former_member204407]

Dear Silvana,

ask your ABAPER create a report with a combination of VBAK,VBAP and KNA1 tables.

Regards,

Krishna.