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

Import of Profitcenter not possible

Hello experts,

I would like to import some profitcenter after updating of SAP from 8.8 to 8.81 PL05.

Since 8.81 there are some more fields by profitcenter like the field EffectivFrom. This field need a date format.

Normally DTW needs alwayss the follwing date format: yyyymmtt

I have tried different formats, but nothiing worked. DTW says always that I have a wrong date format.

Can any body help me in this issue???

This is an example which I would like to import:

-


CenterCode CenterName GroupCode InWhichDimension CostCenterType EffectiveFrom EffectiveTo Active

CenterCode CenterName GroupCode InWhichDimension CostCenterType EffectiveFrom EffectiveTo Active

10000 allgemein 10 20110101 Y

-


Best regards,

Vural

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 14, 2011 at 03:45 AM

    Hi Vural,

    I too was having this problem. For some reason the Profit Centre upload requires the date format 'yyyy-mm-dd'

    I discovered this by trial and error after attempting many formats 😊

    Regards,

    Sean

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Darius,

      Hi Sean,

      thank you for your replies.

      For a few days ago I have also solved this problem by trial and error in the way like you have described.

      It was actually the date format which was different to what DTW normally accepts, like Sean has described.

      I have seen this format in SQL Server.

      Best regards,

      Vural

  • author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2011 at 11:13 AM

    Hi Vural,

    Good day! here is a tip on how to determine the format of date in Profit center.

    1. add a sample profit center in your SAP make sure to encode a value for effective date from and to.

    2. after adding the profit center create a query.

    SELECT T0.[ValidFrom], T0.[ValidTo], T0.[PrcCode], T0.[PrcName] FROM OPRC T0

    3. look for your effective 'FROM' and 'TO' field.

    4. copy the format in this field and put it in your dtw template.

    hope this will help you.

    Regards,

    Darius

    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.