Skip to Content
0
Former Member
May 12, 2008 at 07:09 PM

Problem in scheduling agreement dates with 2LIS_12_VCSCL extractor

73 Views

I am using 2LIS_12_VCSCL extractor to get the order fulfilment report.

I am using ODS as an infprovider and on BW 3.5.

Scenario on Sale Order screen - VA33 [ Scheduling Agreemnent ]

Sales doc Item Line-No Qty Del NO Req-Date Actual GI Date

100 10 1 10 222 5/10/2008 5/10/2008 ( this is the only item that is delivered)

--- -- 2 10 6/10/2008

--- -- 3 10 7/10/2008

This Scenario when we view the data in rsa3 by running 2LIS_12_VCSCL

Sales doc Item Line-No Qty Del NO Req-Date Actual GI Date

100 10 1 10 222 5/10/2008 5/10/2008

-


--- 2 10 222 6/10/2008 5/10/2008

-


--- 3 10 222 7/10/2008 5/10/2008

Note that the delivery no is assigned to the unschedules schedulines(ie; these are open schedulelines that have not been delivered, but the extractor is assigning the first delivery no to all these schedule lines)

We are confused and do not understand if this is how this extractor works . what we actually expected to get is only one recored for which the delivery has been made.

like :

Sales doc Item Line-No Qty Del NO Req-Date Actual GI Date

100 10 1 10 222 5/10/2008 5/10/2008

the other two lines should not get extracted. If this is a bug in the extractor program please point us to the OSS notes or the fix that can be applied.

Else if this is how this extractor works please suggest the fix that can be applied on the BW side to extract only the first record (ie; the schedule line record for which the delivery has been done)

Greatly appreciate help on this issues.

Thank You,

Edited by: Swordfish on May 12, 2008 1:09 PM

Edited by: Swordfish on May 12, 2008 1:21 PM