Purchasing - ITM and SCL

[#1]

Hi,

I was give to enhance the DS and append asset main, account assignment cat, costcenter,glaccount, and order no into 2LIS_02_ITM.

i have done all and replicated and activated TR Ur etc.

my data tragets are 0pur_o01(ods), 0pur_c01 and 0pur_c04

and my IS are 2LIS_02_ITM and 2LIS_02_SCL.

when i run a query i am not able to see th data on costcenter, Gl_ account etc.., except order #.

Please help, is their anything i missed...?

[Former Member · Accepted solution]

Mak Kumar,

let us check step by step

1. check in RSA3 for the new feilds, whether new fields filled with data or not. if you are able to see data move to 2nd step. otherwise check your code in user exit.

2. check the transfer rules and update for your infosource. both are activated and mapped in the UR and TR.

3. if there is any ODS in the data flow. check in the ODS for the new fields and data. if oyu won't find data. check the update rules.

4. check the UR between ODS and Cube. check the data in cube.

let me know where you won't find the data.

All the best.

Regards,

Nagesh Ganisetti.

[Former Member · Accepted solution]

Tyhank you, i have already chked all tht .

Is it any thing like i ahve to add the new fields in both ITM and SCL ? i have dont that know i am able to see the data in the query.

please elobrate.

[Former Member · Accepted solution]

Hi Mak Kumar,

Whenever you are adding any new fields to datasouce by enhancing extract structure, you also need to use userexit to populate data.

So it is not clear from your question whether you have coded in the userexit EXIT_SAPLRSAP_001 for purchasing specific fields by selecting from EKPO for item and EKET for schedule lines.

Let me know..if u need more info.

Thanks,

Venkat

[Former Member · Accepted solution]

Yeah i have done that.

u mean add the code and include the function module.

[Former Member · Accepted solution]

Mak Kumar,

Yes. You need to add the code in the userexit include program ZXRSAU01.

Here is the sample code for Item data source

<b>when '2LIS_02_ITM'.</b>

it_mcekpo[] = c_t_data[].

• Get PO Line item data

select ebeln ebelp afnam

banfn bnfpo gsber bukrs ean11 idnlf

from ekpo into table it_ekpo

for all entries in it_mcekpo

where ebeln = it_mcekpo-ebeln and

ebelp = it_mcekpo-ebelp.

if not it_ekpo[] is initial.

sort it_ekpo by ebeln ebelp .

endif.

loop at it_mcekpo.

read table it_ekpo with key

ebeln = it_mcekpo-ebeln

ebelp = it_mcekpo-ebelp

binary search.

if sy-subrc = 0.

it_mcekpo-zzafnam = it_ekpo-afnam.

it_mcekpo-zzbanfn = it_ekpo-banfn.

it_mcekpo-zzgsber = it_ekpo-gsber.

it_mcekpo-zzbukrs = it_ekpo-bukrs.

it_mcekpo-zzidnlf = it_ekpo-idnlf.

it_mcekpo-zzean11 = it_ekpo-ean11.

endif.

modify it_mcekpo.

endloop.

c_t_data[] = it_mcekpo[].

refresh :it_mcekpo[],it_ekko[].

[Former Member]

Hi, Mak

This might Help you...

you have done everything correctly but you still not able to see that enhanced field in RSA3 T-Code,i think.

for that you have to execute one query.

-- go to T-Code SE38

-- create one Report program and past below Query and Change accordingly.

UPDATE roosfield SET selection = 'X'

WHERE oltpsource = '<Your DS Name Here>' AND

FIELD = '<Enhanced Field 1 Here>' or

FIELD = '<Enhanced Field 2>' or

FIELD = '<Enhanced Field 3>'.

-- Execute this Report Program.

-- Go to T-Code RSA6 and activate your Enhanced DS.,

-- Check your Enhanced Field and Field value in RSA3

if this is useful to you do not forget to give point.

thanks

Kiran Patel

[Former Member]

Hi Problem is i am not able to c the data which is added to the purchasing data in r/3, like if i add a transaction/entry like new po details these details i am not able to c in rsa3, if i give po # and extract and display its 0 records.

what woud be the issue and i can c the data in the PSA(after replication) but not in R/3, ras3, please suggest how to c the data in r/3 in rsa3.

thanks

[Former Member]

Hi Mak,

First please check whether the data is getting populated in R/3 in RSA3 . If no then try finding out why data is not generated in R/3. If yes then check in PSA if you can see the data. If yes then check your mappings and also make sure that there are no routines that are stopping these values.

Hope this helps you,

Bye,

Naga.