Skip to Content
author's profile photo Former Member
Former Member

Extraction shipment cost 2lis_08trfkz

Hi,

I have a problem with shipment cost. A shipment cost is assigned to a transport.

Datas are updated to BI system. When I delete a shipment cost in order to create an other one and assign it to the same transport, BI system detects changes, but it create 2 register with the same transport number but different shipment cost. I need a DSO to store data, but the KEY FIELD must be transport numer, shipment cost and shipment cost item. Then tha data are update into a cube.

Is there into SAP R/3 a field when I can store deleted shipment costs? The used table is VFKP, but there is no place where I can store deleted shipment cost. Do you know how I can solve this problem?

Thank you very much

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 19, 2009 at 06:03 PM

    we don't have transportation setup here... so can't double check

    what exaclty is sent to BI after your change

    could you post the key fields + values?

    I'm thinking you need to set the key figures to overwrite... but not sure yet

    anyways, I worked with these extractors about 5 years ago... and they worked fine

    Add a comment
    10|10000 characters needed characters exceeded

    • When you delete a shipment cost doc it deleted in the corresponding tables of R3 too.If you want to track I think you can check in CDPOS or CDHDR.

      When the deleted doc comes to BI with it deletes record in ODS and cube too (assuming your 0RECORDMODE is mapped appropriately).

  • author's profile photo Former Member
    Former Member
    Posted on Mar 15, 2009 at 11:45 PM

    Hi,

    I am also having similar requirement and When i want to switch the Datasource 2lis_08trfkz to Delta using ODS, meesage pops up with " No ODS Capable ". But when i checked in SAP Service market Place, i found an OSS note 440166. But the OSS notes Says " Reverse image is not captured". Could you please tell me how to solve thi issue.

    regards,

    Ramesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 27, 2009 at 07:05 PM

    Hi pcamp :

    The solution for you is to add to your DSO the Reversal Indicator (InfoObject 0STORNO), this way you can identify the deleted Shipments/Shipment Cost documents when the 0STORNO = 'R'. If the 0STORNO = '' then the document exists in the ERP.

    You could either make 0STORNO part of the Data Fields or Key Fields of you DSO, depending on your particular needs (overwrite or preserve existing records).

    Hi Ramesh:

    As you mentioned before, the SAP Note 440166 explains that there is ODS Capability for Shipment and Shipment Costs DataSources.

    Depending on the Support Package of your SAP System you may need to apply the corrections, according to the follwoing SAP Note: 440416 - BW OLTP: Correction report for change of delta process.

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 27, 2009 at 07:05 PM

    .

    Edited by: Francisco Milan on Aug 27, 2009 9:12 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 27, 2009 at 07:06 PM

    .

    Edited by: Francisco Milan on Aug 27, 2009 9:12 PM

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.