Skip to Content
avatar image
Former Member

Getting GRdate in 2LIS_02_SCL using Processkey

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!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 15, 2008 at 11:12 AM

    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

    Add comment
    10|10000 characters needed characters exceeded