Skip to Content

put these costs of delivery into the SAP system

Hello,

After a delivery is done we receive an invoice from the carrier. So far we are doing the correlation between the costs of the delivery and the delivery note itself manually on an excel sheet. What we would like to do is to put these costs into the SAP system and they should be able to be monitored afterwards ( per query for example ). Do you have any idea or recommondation how to do this?

Many Thanks

Jean

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2007 at 05:40 AM

    Hi,

    after reading below scneario,if i understood correctly the freight cost you received invoice from Vendor or forwarding agent.

    In the above case if you implement Transportation module in SAP,then the cost will be captured and settlement done automatically.

    Regards,

    Chandra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2007 at 05:43 AM

    Hello Jean,

    You could create a new Z table which would contain all the important Feilds. Then you can upload a flat file daily to update this tables.

    The Z table would contain all the important carrier Data which you need.

    Once the data is in SAP then you can keep a track of it by running queries etc.

    Hope this helps

    Thanks

    Murtuza

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Jonathan Zhang

      Hello Jean,

      Designing a Z table is very easy, you would first figure out all the important fields you would want to maintain in SAP.

      Then you would be giving those fields to your ABAPer, who first creates the table with all the important fields you need.

      Once that is done you could again take the help of ABAPer to develop a program which when run would load the flat file from the carrier system and update this fields.You can automate this Program by creating a JOB.

      Once the table is defined you could have this custom fields to be populated in Sales Order (example you could use Additional data A or B tab in Sales Order header or in Delivery Header and place your custom made fields in it.)

      So that once the job is run it would populate the tables and also you would have this data in sales documents.

      Once you have the data in SAP its very easy for you to run the query.

      HOpe this helps.

      Thanks

      Murtuza

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.