SAP Community Network Forums » Business Process Expert » Business Process Expert General Discussion

Thread: Excel reports for Sales

This question is not answered.


Permlink Replies: 2 - Pages: 1 - Last Post: Nov 7, 2009 3:22 PM Last Post By: Carlos Salazar
Carlos Salazar

Posts: 20
Registered: 10/24/09
Forum Points: 0
 
Excel reports for Sales  
Posted: Nov 6, 2009 8:05 PM
Click to report abuse...   Click to reply to this thread Reply
I want to make an excel graphic with 3 values:

Sales Order Date (The date sales enters the sales order)
Requirement Date (The date the customer wants this order)
Closed Sales Order Date (When sales closes the order)

This will be used to measure the service of our plant against completed delivered sales orders monthly.

I already found the first 2 data cells on table VBMTV, anyone has an idea where can I get the information regarding as the date sales close the order once it has been delivered to the customer?

Regards,
Lakshmipathi  Moderator

Posts: 13,666
Registered: 8/9/07
Forum Points: 26,862
 
Re: Excel reports for Sales   Very helpful
Posted: Nov 7, 2009 7:04 AM   in response to: Carlos Salazar in response to: Carlos Salazar
Click to report abuse...   Click to reply to this thread Reply
can I get the information regarding as the date sales close
     the order once it has been delivered to the customer?

Normally, once we do PGI and generate an invoice, that will be considered as sales. So in that sense, standard SAP works in such a way that once you do PGI, system will propose field WADAT_IST from LIKP as billing date which will flow into billing in VF01 which you can see in field FKDAT from VBRK table. Of course, we can also manually key in the billing date in field FKDAT while executing VF01.

So you can consider the above two fields.

thanks
G. Lakshmipathi

Carlos Salazar

Posts: 20
Registered: 10/24/09
Forum Points: 0
 
Re: Excel reports for Sales  
Posted: Nov 7, 2009 2:56 PM   in response to: Lakshmipathi in response to: Lakshmipathi
Click to report abuse...   Click to reply to this thread Reply
That will work for some deliveries, but the problem would be on partial deliveries, I want to measure the date the order its completed or closed, so the service is done totally.

Regards
Carlos

Edited by: Carlos Salazar on Nov 7, 2009 3:13 PM

Point your RSS reader here for a feed of the latest messages in all forums