report for Scheduling agreement and corresponding deliveries and quantites

[Former Member]

Hi Gurus,

our client is having the Scheduling agreements based on that they will create the delivery documents.

Now they are asking a report which contains the Scheduling agreement , corresponding delivery number , the quantity and

the delivery date.

please tell me to get the above values is there any standard report is avilable.

Regards

[Former Member · Accepted solution]

Hello,

having a report that shows sales document number (your case scheduling agreement), subsequent document (delivery) and relative quantity is not so easy and there is not any direct link between.

Of course a similar report can be developped but wth the help of a good "programmer"

Anyway, few tips that you may start looking at:

1. report that list scheduling agreements VA35N (program name: SD_SALES_SCHED_AGREEMNTS_VIEW)

2. scheduling agreements are mainly working by schedule line items, table that gives you status by schedule line item VBEP

3. table that gives you the subsequent documents is VBFA

4. table that contains header information of the delivery LIKP

5. table that contains item information of the delivery LIPS

Combining and joining properly the tables above, you may generate a program that includes different level of details as per your client request.

Remind:

When you look for a delivery number and your original document is a scheduling agreement (document category E in customizing) you need to take a strong assumption: "Keeping as unique key the item in the VBEP, take the assumption that the sorting in VBFA is corresponding to the sorting by schedule line item in VBEP".

Regards,

[Lakshmipathi]

Check in LIPS table. Data required by you can be fetched from this table.

thanks

G. Lakshmipathi