Controlling Data source

[Former Member]

Hi All,

I need some clarification regarding the data source “0CO_OM_WBS_6”.

This data source has a Extract structure : ICWBSCSTA1.

I just want to know in this structure the fields SMEG, SMEV, SWV are fetching data from which TABLE?

Thanks,

Bobby.

[RamanKorrapati · Accepted solution]

hi bobby,

these are from structures.

at ecc side go to SE11, choose Data type, SMEGR(data element), select whr used lsit, it choose as below, its displays.

Field        Data element

SMEG,  - SMEGR  - Str - BIW_EVA_WBS, lot str are there, pls check it once

SMEV,  - SMEVR    From str -  ICCTRCSTA1 here also lot of str as source for this field

SWV  - SWKVR   - str RCOOM

Thanks

[Former Member · Accepted solution]

Hi Raman,

Thanks for the reply!!!

I have the understand that this fields are coming from different structures but my question is for this fields there should be a source table ..i want to know the respective tables.

Thanks,

Bobby

[Former Member · Accepted solution]

Hi Bobby,

The fields that you are looking for are calculated based on multiple fields of the view COVP.

Refer the link below.

http://help.sap.com/saphelp_bw33/helpdata/en/27/3d4acd8ae7574f8de1f72e100d16f6/content.htm

SMEF

Fixed Consumption Quantity

Value fields MEF* of the totals record

SMEG	Consumption Quantity	Value fields MEG* of the totals record
SMEV	Variable Consumed Quantity	= SMEG – SMEF

Regards,

Sujit.

[Former Member · Accepted solution]

Hi All,

I want to understand how the Keyfigure "SWG"(Amount) is fetching data from "WKG" "WOG" "WTG".

Is SWG the total of values "WKG" "WOG" "WTG" ?

For example:

"WKG= 10,000.00

"WOG=13,529.00

"WTG"= 13,529.00.

The value should be 37058 but it is taking only "13,529.00". from table COVP

http://help.sap.com/saphelp_bw33/helpdata/en/27/3d4acd8ae7574f8de1f72e100d16f6/content.htm

Please let me know what is the calculation behind it ...

Thanks,

Bobby.

[Former Member · Accepted solution]

Hi All,

Please try to give some information on this.Its pretty urgent

Input will be really helpful...

Thanks,

Bobby

[Former Member · Accepted solution]

Hi Bobby,

The value of SWG can be any one of them but not the total. The three fields you have mentioned, are the same figure but in different currencies.

WTG* = Transaction Curr.

WKG* = Controlling Area curr

WOG* = Object curr

In your case Object currency and Transaction currency are the same. It depends on what currency you select, accordingly you will get the output. If you need to change the output value then refer the below link.

http://help.sap.com/saphelp_bw33/helpdata/en/37/ffc98b356a5744a4121ee5348c4c88/content.htm

Regards,

Sujit.

[Former Member · Accepted solution]

Hi,

Thanks for the reply!!

We are building a new data source as same as the standard one. I’m able to fetch all the data same as Standard datasoucre but Key Figure out is different.

I agree with the currency thing which you have mentioned in the previous note, even I have found the same but the output is like below..

Standard data source:

    Amount Vbl                 Val.amount       Currency

11,529                         11,529                         USD

9,245                            9,245                             EUR

New Datasoucre:

Amount Vbl        T,Curry         Val.amount     Object curry

11,259          USD               9,245                   EUR.

The difference between both outputs would be in Standard data source there are 2 rows as per the currency and for New Data source only in single row both values are available.

I need the out put as :

Amount Vbl                 Val.amount       Currency

11,529                         11,529                         USD

9,245                            9,245                             EUR

Please let me know if you find any relevant input.

Thanks,

Bobby

[Former Member · Accepted solution]

Hi ALL,

Is there any way to get the required out put..

Please let me know..its running out of hands!!

Thanks,

Bobby

[Former Member · Accepted solution]

Hi Bobby,

I am not sure about your design of new datasource. Still suggesting how you can get two rows out of single row in your datasource. There is a step by step how to guide for this. Read it thoroughly to understand it. Then you will be able to apply the logic.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90754b76-bcf1-2a10-3ba7-b299b2be0...

Regards,

Sujit.

[Former Member · Accepted solution]

Hi Sujit,

Thanks the Document,it is really helpful.

As per the document it has been differentiate with the help of “Version”  (10, 20).

But in my case ,data has been differentiated with the help of Currency (example:USD,EUR,PHP)

New Datasoucre:

Amount Vbl T,Curry Val.amount     Object curry

11,259        USD       9,245          EUR.

This should be get as :

Amount Vbl Val.amount       Currency

11,529            11,529              USD

9,245              9,245                 EUR.

In my case we need to differentiate with CURRENCY, we are having many currency so please let me know if any way out.

Thanks,

Bobby

[Former Member · Accepted solution]

Hi Bobby,

I didn't suggest you to follow the document to split the data for different currencies. Currency conversion will do the same. Can you explain what is the problem u r facing with only one record having two amounts in two currencies ?

[Former Member · Accepted solution]

Hi Sujit,

We are building a new data source as same as the standard one(0CO_OM_WBS_6). I’m able to fetch all the data same as Standard datasoucre but Key Figure out is different.

Standard Data source:

   Amount  Vbl            Val.amount               Currency

11,529                           11,529                        USD

9,245                              9,245                            EUR

New Data source:

Amount Vbl    T,Curry             Val.amount                Object curry

11,259             USD             9,245                 EUR.

I want to split this “11,259    USD        9,245 EUR”. To

   Amount Vbl             Val.amount       Currency

11,529                        11,529                    USD

9,245                             9,245                  EUR.

Two rows should come as per the currency ,USD in one row and EUR in other row.

Thanks,

Bobby

[Former Member · Accepted solution]

HI,

let me explain in details :

In Data source "0CO_OM_WBS_6" Key figure "0AMOUNT" is SWG .

SWG is the combination of fields Values  WKG*, WOG* and WTG* from table COVP.

NOW

WTG* = Transaction Curr.

WKG* = Controlling Area curr

WOG* = Object curr

This are the same key figure but different currency.

now in table data is like

WTG*   Trans curr     WKG*      Object curr  WOG*  Co area curr

1000    USD           1200          EUR       1000         USD

When we check this values in "0CO_OM_WBS_6" it shows like :

Amount Vbl                 Val.amount       Currency

11,529                         11,529         USD

9,245                           9,245         EUR

but i'm are able to get like :

Amount Vbl             val Amount         Currecy

11,529                         11,529          USD..

Only a single currency we are able to get and missing other currency ..

Moreover i wanna differenate the values with the help of currecny ...

Please let me know if any details needed..

Thanks All !!

Bobby