Getting GRdate in 2LIS_02_SCL using Processkey

[Former Member]

Hi, I have a question about datasource 2LIS_02_SCL.

there are two FILEDS: 1. BUDAT: Posting Date of Goods Receipt or Invoice Receipt for the Purchase Order

2.BWVORG: SAP BW - Transaction Key

I want to seperate BUDAT into two field: GRdate and Invoicedate using BWVORG. Just as following:

I have the following data:

EBELN EBELP BUDAT BWVORG BWGEOO

1000000608 10 001 800

1000000608 10 20080101 002 600

1000000608 10 20080201 003 500

1000000608 10 20080215 003 -500

1000000608 10 20080305 003 600

My problem is about the GRdate, I have the following transformation routine code:

If SOURCE_FIELDS-BWVORG = 002. RESULT = SOURCE_FIELDS-BUDAT.

ENDIF.

When I extract the data into DSO which the key is EBELN and EBELP, the GRdate is 00000000.

Because when BWVORG is 003, it will overwrite the GRdate using BUDAT. I want to not update the GRdate when

BWVORG is 003.

But I don't know how to write the ROUTINE CODE. Could anyone help me?

I have checked the BW 3.5 routine, it use RETURNCODE to control this.

• if the returncode is not equal zero, the result will not be updated

RETURNCODE = 0.

else.

RETURNCODE = 4.

endif.

But in BW 7.0 it's not work.

Can anyone help me? Thanks a lot!

[Former Member]

Hello Larry,

Did you get how to update GRdate using BUDAT ?

Even I am stuck in the same situation as you.

Will appreciate any help.

I checked raise exception option available in BI7, but it doesn't work in the scenario described by you.

Thanks and Regards

Shilpa

[Former Member]

no, I still don't know how to do it. If you have a suggestion pls let me know, thx!

[Former Member]

Even I am not able to find any solution yet.

Thanks for the reply.

Let me know if you get any clue.

Thanks and Regards

Shilpa