Skip to Content
avatar image
Former Member

Problems with load transaction data without movementtype

Dear Experts,

we have some problems with load transaction data via Data Manager from BW.

The problem is, when I load a transaction data from BW f.e. for one

ITEM: 10130320 which has

INTERCO: PG1220 and value on

MOVEMENTTPE: 100 : 725.110,58 EUR and

NO MOVEMENTTYPE: -725.110,58 EUR.

I have in a transformation file mapping:

MOVEMENTTYPES = *IF ( *STR() + 0MOVE_TYPE = *STR() then *STR(END); 0MOVE_TYPE)

So BPC should take both values put it on MOVEMENTTYPE: END

But here is the Problem, BPC takes only the value of 725.110,58 EUR which is on the MOVEMENTTYPE 100 and ignore the value which is without movementtype. So I have a difference.

How can I say BPC to take both values and not just the one with the MOVEMENTTYPES.

My script logic for the MOVEMENTTYPES in DEFAULT, which write me the value on MOVEMENTTYPE 100 to END is

:

//Write Movementtype's on END
*XDIM_MEMBERSET MOVEMENTTYPES=BAS(A),BAS(699),BAS(599)
*XDIM_ADDMEMBERSET MOVEMENTTYPES=BAS(A),BAS(699),BAS(599)
*WHEN MOVEMENTTYPES
*IS *
*REC(FACTOR=1, MOVEMENTTYPES = END)
*ENDWHEN
*COMMIT

The Report from BW on the source InfoObject and then on the BPC InfoObject see attachement.

Hope you can help here to get all values to BPC

Thanks

Daniel

source-infoobj.png (354.9 kB)
bpc-infoobj.png (879.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 23, 2017 at 01:06 PM

    Strange line:

    MOVEMENTTYPES = *IF ( *STR() + 0MOVE_TYPE = *STR() then *STR(END); 0MOVE_TYPE)

    Has to be:

    MOVEMENTTYPES = *IF(0MOVE_TYPE = *STR() then *STR(END); 0MOVE_TYPE)

    Empty will go to END, Non empty - to the required movementtype

    Not clear what do you want to do with default logic...

    First test without default.lgf

    Add comment
    10|10000 characters needed characters exceeded