cancel
Showing results for 
Search instead for 
Did you mean: 

How to bring VRGNG field in BI

Former Member
0 Kudos

Hello All,

I am trying to extract Cost Center Actual data using 0CO_OM_CCA_9 datasource.

I need to have VRGNG (CO Business Transaction) field shown in my report.The above standard extractor doesn't bring this field directly.

Can anyone tell me how do solve this?As the VRGNG field is present in the source table of this extractor, do I have to write any code to bring this value to BI or not necessary ?

I have read some links and got to know that there are some BI characteristics (Info objects)like 0METYPE,0VTYPE,0VTDETL,0VTSTAT . With these four characters , i can fulfill my requirement.

Please tell me how to take VRGNG in BI

Thanks

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

There are two ways, both suggested above:

1. go for your datasource enhancement, or

2. use the datasource for text to bring the additional field. However, this will come at a cost of managing one more datasource, transformation, load etc.

I'll suggest to enhance your datasource 0CO_OM_CCA_9.

Thanks...

Shambhu

Former Member
0 Kudos

Quick Update:

SAP Delivered Datasource 0FM_TRANSAC_PU_TEXT will get you the Texts for Bussiness Transaction. No need to create a Custom Text Datasource.

Former Member
0 Kudos

Hello All,

I am trying to extract Cost Center Actual data using 0CO_OM_CCA_9 datasource.

I need to have VRGNG (CO Business Transaction) field shown in my report.The above standard extractor doesn't bring this field directly.

Can anyone tell me how do solve this?As the VRGNG field is present in the source table of this extractor, do I have to write any code to bring this value to BI or not necessary ?

I have read some links and got to know that there are some BI characteristics (Info objects)like 0METYPE,0VTYPE,0VTDETL,0VTSTAT . With these four characters , i can fulfill my requirement.

Please tell me how to take VRGNG in BI

Thanks

1) Create a append Structure in the Extract Structure of the Data Source 0CO_OM_CCA_9.

2) Add Field "VRGNG" to the append structure and Activate.

3) Create a User Exit for your Datasource.

Function Module: EXIT_SAPLRSAP_001

Main Include: ZXRSAU01

case i_datasource.

when '0CO_OM_CCA_9'.

perform 0co_om_cca_9_exit tables i_t_data.

4) FORM 0co_om_cca_9_exit tables i_t_data structure <EXTRACT STRUCTURE>

Here you write the code to populate the field "VRGNG" based on where you want to fetch the value of this field.

Example: Table COEP

I am assuming this is where you want to extract the value

types:

begin of typ_coep_key,

kokrs type coep-kokrs,

belnr type coep-belnr,

buzei type coep-buzei ,

vrgng type coep-vrgng,

end of typ_coep_key.

data:

t_coep type typ_coep_key occurs 0 with header line,

th_coep type hashed table of typ_coep_key

with unique key kokrs belnr buzei

initial size 0 with header line.

data: l_count type i.

describe table i_t_data lines l_count.

check l_count > 0. "If there are no records - EXIT!!!

loop at i_t_data.

move:

i_t_data-kokrs to t_coep-kokrs,

i_t_data-belnr to t_coep-belnr,

i_t_data-buzei to t_coep-buzei.

collect t_coep.

endloop.

sort t_coep.

select kokrs belnr buzei vrgng

from coep

into table th_coep

for all entries in t_coep

where kokrs = t_coep-kokrs and

belnr = t_coep-belnr and

buzei = t_coep-buzei.

free: t_coep.

loop at i_t_data.

read table th_coep with table key kokrs = i_t_data-kokrs

belnr = i_t_data-belnr

buzei = i_t_data-buzei.

if sy-subrc = 0.

move th_coep-vrgng to i_t_data-vrgng.

modify i_t_data.

endif.

endloop.

free: th_coep.

5) This will populate the Field Value you need into the BW extract structure.

6) Create a custom InfoObject in BW if you cannot find a SAP Delivered Object.

Possible SAP Delivered Objects you can use are

0FI_RACTIV - Business Transaction

0BUS_TRXN - Business Transaction

7) Create a TEXT DataSource for VRGNG based on TABLE TJ01T

TJ01T - Business Transaction Texts

That should do it.

Cheers!

Vasu

Former Member
0 Kudos

First check in the BC if theres an infoobject with your description, then if not you can use another with the same data type o if not you can create one....

Regards