No reversal rec in 2LIS_0TRTLP on reassignment of diff shipment to delivery

[Former Member]

Hi all,

We are using datasource 2LIS_08TRTLP to fetch shipment delivery item data into BW. Daily delta is scheduled to fetch records.

We are now facing an issue when a delivery is reassigned to another shipment, there is no reversal record for the original shipment-delivery combination.

e.g. a delivery XXXX is created on 16.10.2008 & is assigned to shipment 'A' on 16.10.2008.

This record got loaded as new record in ODS in daily delta load with gross weight of delivery say 10.

now on 18.10.2008 this delivery XXXX is removed from shipment 'A' & is reassigned to shipment 'B'.

when this fetched in BW, another new record got created with delivery XXXX with shipment 'B" with gross weight of delivery 10.

But this does not create any reversal record for the unassigned shipment 'A'.

Due to this in the report on 18.10.2008 it appears that delivery XXXX is assigned to both shipment 'A' & 'B' which is not the case.

Could you please guide me if any setting is missing or how can we get reversal record when the shipment for a delivery is reassigned.

Thanks & Regards,

Pallavi

[former_member181964 · Accepted solution]

Hi,

I don't think there is no any indicator for reassignment of diff shipment to delivery, we searched for this option, but we are unable to find.

Try with.

The feild ROCANCEL Indicator: Cancel Data Record is there in DataSource, so first you load this data to ODS.

And insert one ZCOUNT1 object in ODS and in update rules you write one formula for this

IF( Reversal indicator = 'R', 0, 1 )

And in Keyfeilds you map only 0DOC_NUM BW: Document Number only

Then you map ODS->Cube here you only map ZCOUNT1 in KeyFigures.

Thanks

Reddy

[Former Member · Accepted solution]

Hi Reddy,

Could you please elaborate the solution suggested. I didn't get it.

The main issue that we are facing is we are not able to find any field in ECC or there is no history for VBFA table which will identify that delivery XXXX has been reassigned from 'A' to 'B'.

We feel that in ECC itself there is no indication telling the delivery has been reassigned to another shipment & it is not splited in two shipments.

Thanks,

Pallavi

[former_member205352]

I think its wrongly done by SD consultants.

Better talk to them how they go about this process.

Usually they need to delete or cancel shipment A, this will pick up delta which will reverse shipment A.

Also check if shipment costs got created, if yes then even shipment costs needs to be reversed by them else shipments cannot be reversed.

But if they donot cancel shipment A then shipment A exists in R3 too, how is it reversed in R3 side ?? You need to check the underlying tables, I think VTTK and VTTS are tables check in these.

Hope this helps.