On time delivery - SD

[Former Member]

Hi Experts,

I am facing an issue with delivery number, as I am unable to find a direct relation I asked to many persons in SD and MMbut they are also unable to answer my question.
What I want is i need to find out is, In table VBEP we will get some delivery number expected delivery date and its quantity. (See the below pic)

If we pass the same scheduling order number in table LIPS we will get the list of orders but there is no direct 1-1 link with delivery items. So I need make a link between these values.

In short, my requirement is, in my report I have to display the scheduling order date, Qty, Delivery date & Qty.

<<Point offer removed>>

Thanks,

Anoop Satheesan

Message was edited by: Kesavadas Thekkillath

[Former Member]

HI,

I am not getting your post i.e  "In table VBEP we will get some delivery number expected delivery date and its quantity". How come you get the delivery number in the VBEP table.

Any way for your report you can pass your order number with VBEP-VBELN and pick the value from the VBEP-BMENG for confirm qty and VBEP-EDATU for confirm schedule delivery date.

Again for delivery date and Qty ,pass the same order number to table VBFA-VBELV and pick the value for qty from VBFA-RFMNG and date from VBFA-ERDAT whare the VBTYP_N value is "J" ( J= Delivery)

Hope this will solve your problem..

Thanks

Pitabash

Bangalore

[Former Member]

Hi Pitabash,

I am psting the screen shot of my VBEP table and VBFA table.

In that VBFA table see the first entry qty is 85 and it iis giving the date is 10.01.2011. Now check the VBEP table and see the first two line item qty one is 25 and next is 60. What is the relation between these two ? How can I determine that in which order they deliver these goods ?

[Former Member]

Dear,

My requirement is, in my report I have to display the scheduling order date, Qty, Delivery date & Qty.

If your requirement is above the you can get in two tables as in VBEP and LIPS .

Actually ,what happened b/w VBEP and LIPS is ,If any customer ordered 100 quantity the again he said as I dont want 100 quantity ,now I want only 50 quantity .So in this case ,Order has been created with 100 but when comes to delivery level then there will be total different to Sales Order Quantity to Delivery Quantity thats why system will be showing some variance b/w VBEP and LIPS Table Level .You can compare with table level as difference quantity clearly .

Now ,come to the point is ,If you know how to get Data from Table Level with SE16 or SE16N then only you can get whatever you required data If not its very difficult . When ever execute SE16 and enter Table what ever you want data and again enter and check -> "Settings" ( above ) and again click on "Fields for selection" ,so here you have to tick as what fields of data you want .

Thanks,

Naren

[Former Member]

Hi Naren,

I knows how to display data through se16N. That is not my problem, actually i am unable to match VBEP values with LIPS entries.
I think you didn't understand my question clearly, please read my first reply to Pitabash in that I clearly mentioned my problem.

Thanks,

Anoop

[former_member491621]

Hi Anoop,

Maybe the fields can help you to answer your question

VBEP-ETDAT : Delivery Date

VBEP-WADAT : Goods Issue Date

Hope this helps

[Former Member]

Hi Anoop,

The VBEP Table seems that multiple schedule line for the same item. where as it may happen where,there is not enough stock and the order is confirming based on incoming PO,and  PIR's.

The first two line of VBEP shows on 10.01.2011 confirmed qty is 25 and

                                                       15.01.2011 confirmed qty is 60

So according the system if we create the delivery on 10.01.2011 then system should allow only 25 qty. because only 25 qty will be available on that day.

But it may happen if some one have entered the input /PGR/ material receipt for the 15.01.2011 date material. So when you are creating delivery document on the selection date ( VL01n) if you are putt in the date after 15.01.2011 then the delivery document pick both the schedule line. . where as the material is available then if made single delivery (i.e 80006209) which have the qty as 85.

It means the delivery document have created for 85 qty. and some one do it manually..

Some tips for giving suggestion to client:-

It could not happen if we can avoid these things..

1:- put the selection date as actual ( i.e not beyond the actual) So it could not take the future deliveries.

2:- Put the material entry like MIGO for Purchase order of incoming order on date . so the material will not be available before the said dates.

3:- If do the manual material entry before the desired date then run the availability so that the order's will update the schedule line with new availability.

Hope it ll help you..

Comments and suggestions are always welcome....

Regards

Pitabash

Bangalore

[Former Member]

Hi Pitabash,

Thanks for the reply. Whatever you are saying is correct only. But here I cannot tell the user to follow these many steps. They need a report on this,. Thats it.
In such situation I need a technical solution other than this. Anyway your answers are helpful..

We have a function module [RV_SCHEDULE_CHECK_DELIVERIES], by using this we will get the delivery date & Delivery Qty, But in my report what i need to display is ,

Sceduling Order No | S. Order Date | S. Order Qty | Delivery Num | Dlivery Date | Deli Qty

Based on this date and qty , I will get advance and delay delivery details.

Thanks,

Anoop Satheesan

[Former Member]

Dear,

How ,VBEP Table Values match with LIPS Table  If there was variance quantities and dates or whatever ?

Note : Its ,very difficult to match .already me and Bihera has explained on this query with examples also .

If you have any doubts please let me know .

Thanks,

Naren

[Former Member]

Hi Naren,

I know it is difficult to match this values, logically also its is difficult. But there should be some soluion in SAP for this. If it is easy, then why we are posting in SCN. I asked the same to many people but they are unable to answer me.

If there is no solution for this , then how the compaies are taking report on On time Delivery of goods ?

Thanks,

Anoop

[Former Member]

Dear,

you can get Data based on your required Fields through Creation of Report based on " SQVI " .

I have created one report for you to get required fields of data in SQVI .You can get very well data by using SQ01 also .Please check below screen shot .

Note :1. Please Join the Tables as VBAK,VBEP,LIKP and LIPS .Now ,you have select the Fields what do you want from above Tables .

2. If you know ,How to create Report though SQVI the you can accomplish with in minutes If not then you have to take help of another guys or else take Google Help to get data by using SQVI and SQ01 .

3. You are very Intelligent man .

If you have any doubts please let me know .

Thanks,

Naren

[Former Member]

Hello Anoop,

You problem does not seem to be so technical, than business oriented. Actually On-time delivery businesswise should mean "All deliveries that are created (or maybe as someone above proposed - "goods issued") on time". This practically should mean that you care only about schedule lines that are delivered on-time, and schedule lines that are either delayed or not yet shipped. If you can verify with the client to use this as a starting point, then your task should not seem so difficult. In this case the answer of your question in the post on Jan 29, 2013 6:35 AM should be:

Delivery 80006209 has delivered on time: maybe 60 EA (comparing the dates of delivery 80006209 and Sales Order 30000286 Item 10 Schedule line 2) - I am saying "maybe" because in the screenshot you have not shown the date in VBFA.

On the other hand with this same delivery 80006209 was shipped also schedule line 1, which unless was NOT on time, so in the report for the planned delivery date you should have quantity of 0.

Then the report whould seem like:

1. Based on VBEP

2. Select on LIPS by  VBEP-EDATU = ERDAT and VBEP-VBELN = VGBEL VBEP-POSNR = VGPOS.

3. If the select returns a delivery number take the compare the quantities and if "delivery quantity" >= "Schedule line quantity" then the schdule line has been deliverred on time, everything else should mean that the "on-time" requirement has not been met for the schedule line.

this end up in the fact that entries in all fields: Sceduling Order No | S. Order Date | S. Order Qty | Delivery Num | Dlivery Date | Deli Qty you shall have only in case of on-time delivery, otherwise Delivery Num | Dlivery Date | Deli Qty are going to be empty - this means "Not on time".

Of course you can go even further, going back from the current schedule line to the last known delivered schedule line and collecting all undelivered schedule lines inbetween, then compare quantities, to determine virtually with which delivery they have been shipped etc. but in my opinion the business should be reasonable enough to avoid such complex logic and be happy with the requirement "on-time or not".

Regards,

Sken

[Jelena_Perfiljeva]

Unfortunately it's not possible to link the delivery item to the schedule line because the delivery item is only linked to the order item. And I agree with Stilian that this is more of a business process issue than technical. Definitions of "on time" tend to differ, sometimes even within the same organization.

In one of our organizations we even had to create a separate table to track the "customer requested delivery date" on the schedule line level because in standard it's only available at the line item level. I was suggesting against it, but the users insisted because that's what their definition was of "on time" (actual GI date vs. customer's requested).

By the way, the preceding order number/line is most likely stored in LIPS-VGBEL/VGPOS fields, so there might be no need to get VBFA involved.