topic Re: ABAP help for start routine. in Application Development and Automation Discussions

ABAP help for start routine.

Former Member — Wed, 29 Aug 2007 18:31:14 GMT

Hi ,

We have two Sales ODSs. The first ODS has a key Sales Order, Sales Order item.

The second, sales order, sales order item, fiscal period. ODS1 feeds ODS2.

sample data :

2LIS_11_VAITM

SO SOITEM OCALDAY AMOUNT RECORDMODE

ABC 10 07/03/07 100

ABC 10 08/05/07 -100 X

ABC 10 08/05/07 110 Y

ODS1 (KEY : SALESORDER, SALESORDERITEM)

SO SOITEM OCALDAY AMOUNT

ABC 10 08/05/07 110

ODS2 (KEY: SALESORDER, SALESORDERITEM, FISCPER)

SO SOITEM OFISCPER AMOUNT

ABC 10 07/07 100

ABC 10 08/07 10

To achieve this, in the update rules from ODS1 to ODS2, we convert the ocalday into fiscal period and then sum records with record mode X and record more Y , by key sales order, sales order item and fisc per.

How to write this in ABAP?

Message was edited by:

Re: ABAP help for start routine.

Former Member — Wed, 29 Aug 2007 18:37:17 GMT

Hi,

I am not clear with your question.. You want to build the same logic in the start routine in the transformation on ODS2 infosource??

Or if you have already bulit it, then where you want to code it in ABAP now?

Thanks and Best Regards,

Vikas Bittera.

**Points for useful answers**

Re: ABAP help for start routine.

Former Member — Wed, 29 Aug 2007 18:40:16 GMT

Hi Vikas,

The logic needs to be applied when we feed data from ODS1 to ODS2.

I dont know how to convert calday to fiscal period and all in ABAP.

Thanks!

Re: ABAP help for start routine.

Former Member — Wed, 29 Aug 2007 18:54:06 GMT

use function module

DATE_TO_PERIOD_CONVERT

value for parameter i_periv is stored in table t001 for each company code.

Re: ABAP help for start routine.

Former Member — Wed, 29 Aug 2007 18:55:19 GMT

HI,

SO SOITEM OCALDAY AMOUNT RECORDMODE

ABC 10 07/03/07 100

ABC 10 08/05/07 -100 X

ABC 10 08/05/07 110 Y

ODS1 (KEY : SALESORDER, SALESORDERITEM)

SO SOITEM OCALDAY AMOUNT

ABC 10 08/05/07 110

ODS2 (KEY: SALESORDER, SALESORDERITEM, FISCPER)

SO SOITEM OFISCPER AMOUNT

ABC 10 07/07 100 fiscal period is not the calender month

ABC 10 08/07 10

you can do this..

data : lv_fiscper(5) type c.

lv_fiscper = 0calday+4(2).

if lv_fiscper >= 4.

lv_fiscper = lv_fiscper - 3.

else.

lv_fisper = lv_fiscper + 9.

endif.

this will give you the fiscal month then just do this.

concatenate lv_fiscper '/' 0calday+2(2) into lv_fiscper..

Re: ABAP help for start routine.

Former Member — Wed, 29 Aug 2007 20:27:47 GMT

Thank you Mahesh and Amandeep. Will try to write the routine will more research & learning.

points assigned

Re: ABAP help for start routine.

Former Member — Fri, 07 Dec 2007 17:26:12 GMT

Answered. Thanks.