Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

0COSTELMNT_0102_HIER with intervals

Component information:
BW 730 Patch 005
SAP ECC 6.0

Hello All,


I am facing issues trying to load 0COSTELMNT_0102_HIER with intervals from ECC 6.0 to BW 730
The datasource 0COSTELMNT_0102_HIER has been migrated. I am able to load PSA with data. But during DTP I am recieving the following error.

Interval node with the ID 4: The from-value is larger than the to-value
Message no. RH214

Diagnosis
The "from" value is larger than the "to" value for the interval node with ID 4 and node name .


Procedure
By swapping the "from" and "to" values you can get a valid hierarchy structure.

In my transformation is as follows..

hierarchy cost element header mapping is
HIENM > 0H_HIENM
OBJECTID > 0OBJECTID

HEADER TEXTS

SIMPLE 1 > 1 MAPPING

HIERARCHY NODES

ONE TO ONE MAPPING AND

NODEID > 0COSTELMNT WITH ROUTINE

DATA wa_seg_5 TYPE ty_seg_5.
    DATA flag.

    WHILE flag EQ space. ENDWHILE.

    READ TABLE t_seg_5 INTO wa_seg_5
      WITH KEY nodeid = SOURCE_FIELDS_3-nodeid.

    IF sy-subrc EQ 0.
      RESULT = wa_seg_5-leaffrom+4(10).
    ENDIF.

NODEID > 0CO_AREA WITH ROUTINE
   DATA wa_seg_5 TYPE ty_seg_5.

    READ TABLE t_seg_5 INTO wa_seg_5
      WITH KEY nodeid = SOURCE_FIELDS_3-nodeid.

    IF sy-subrc EQ 0.
      RESULT = wa_seg_5-leaffrom(4).
    ENDIF.


NODE TEXTS ONE TO ONE MAPPING

INTERVALS

NODEID > 0H_NODEID
LEAFFRMOM >

LEAFTO > 0COSTELMNT WITH ROUTINE
   RESULT = SOURCE_FIELDS_5-leafto+4(10).

LEAFTO > 0CO_AREA WITH ROUTINE
RESULT = SOURCE_FIELDS_5-leafto(4).


OBJECTID > OBJECTID

Please can anyome advise how the mapping should be done or any routines I need to include

Thanks

Tags:
Former Member
Former Member replied

Hi Forhad,

Any particular reason why you have migrated to 7.x flow. Although 7.3 supports transformation and dtps in hierarchy loads I suggest to keep it in 3.x if you don't have a special reason for it.

If you wish to use 7.x flow then you need to use routines to be able to convert the data to right format.

Sap documentation

http://help.sap.com/saphelp_nw73/helpdata/en/ba/45db1795cd41ae83230ae01e882500/frameset.htm

Some more threads

https://scn.sap.com/thread/2127868

http://scn.sap.com/thread/3251605

Regards,

Sujit.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question