2LIS_02_ITM and Cost center

[Former Member]

Hello,

I'm trying to enhance 2LIS_02_ITM to bring cost center data. The problem is that for each PO item there might be several cost centers.... Should i duplicate the records in 2LIS_02_ITM for every cost center? Is there any other way of doing it?

Please Advice,

Amir

[Former Member]

You can reproduce 2LIS_02_ACC by looking at the docs and using a view on ekko, ekpo, ekkn.

[Former Member]

Hi,

I'm writing a blue print and not sure which tables should i use for this DataSource. All the fields i need exist in the table EKKN but for the Delta update i need also the field AEDAT from EKPO.

Did i forget anyhing (i dont use EKKO at all...).

[Former Member]

Hi,

you need 2LIS_02_ACC for the extraction of account assignments which include assignments to cost center.

Rgds.

Jürgen

[Former Member]

hi Jürgen ,

There is no dataSource 2LIS_02_ACC in 3.1

Amir

[Former Member]

I had to load each PO position with all their price conditions (1:N too) and i duplicated each PO item by each price condition.

[Former Member]

Hi Oscar,

Can you please tell me more. Which Data Source did you used for EKKN data? how did you cobine the data?

[Former Member]

I did an enhance to 2LIS_02_ITM to extract delivery date from EKET, but in my case I only had one delivery for each PO position. I did not look for cost center, maybe any busuness content extractor exist for that.

In all case one soluton can be...

Load data into an ODS with key ebeln ebelp and costcenter, the data will be combined.

In your case do something like the following, create a entry for each delivery in eket.

• Select all coscenter in deliverys for your POs

select * from eket into t_eket for all entries in t_2lis_itm

where ebeln = t_2lis_itm.

• fro avoid to create infinite loop

describe c_t_data lines ilines.

loop at c_t_data into 2lis_02_itm.

ini = 'X'.

loop at t_eket where ebeln = 2lis_02_itm-ebeln

and ebelp = 2lis_02_itm-ebelp.

move-corresponding t_eket to 2lis_02_itm.

if ini = 'X'.

• first one is modified

modify c_t_data from 2lis_02_itm.

clear ini.

else.

• others are appended

appent 2lis_02_itm to c_t_data.

endif.

endloop.

if sy-tabix = ilines.

exit.

endif.

endloop.

[Former Member]

Thank you Oskar,

I will try it!