Home > > 2LIS_40_REVAL


Hi there,
I'm in a Retail environment.
I'm using 2LIS_03_BX, 2LIS_03_BF, 2LIS_03_UM to fill an InfoCube and have the monthly stocks.
Quantities and valuation at purchase value are correct.
As I want to add to my report the valuation at retail value for each month, I've added 2LIS_40_REVAL.
But now I see this kind of things in the report :
Plant | Material | Month | Quantity | Purchase Value | Sales value
Plant1 | Material1 | Month1 | 0PC | 0EUR | -2EUR
Plant1 | Material1 | Month2 | 1PC | 1EUR | 0EUR
Plant1 | Material1 | Month3 | 1PC | 1EUR | 2EUR
As you see, there is a sales valuation that appears for Month1, although there is no stock.
And this value is actually the opposite of the sales value that should appear for Month2...
I can see this kind of shift for some materials (and only for historical months, not current month).
Can anybody experienced with this extractor tell me where I have done a mistake ?
I would need a piece of advice... Maybe the way we load data with this extractor have to be different than the way we do it with BX, BF and UM.
Thanks in advance and best regards,
I've loaded only 1 article for 1 division, using BX, BF, UM and REVAL.
I've checked my data in the InfoCube.
I've got data for periods 11.2005, 12.2005 and 01.2006 as following :
11.2005 | Quantity | PurchaseValue | SalesValue
12.2005 | Quantity | PurchaseValue | SalesValue
01.2006 | Quantity | PurchaseValue | SalesValue
As you see, no record for 10.2005.
And if I check the validity table via RSDV, the time frame is 11.2005 -> 01.2006 (that's correct).
But the BEx is still giving me an additional record for 10.2005, with no stock and a sales valuation.
The sales valuation for 12.2005 and 01.2006 is correct.
It's like this :
10.2005 | 0        | 0             | SalesValue
11.2005 | Quantity | PurchaseValue | 0
12.2005 | Quantity | PurchaseValue | SalesValue
01.2006 | Quantity | PurchaseValue | SalesValue
Hope you can give me a further help.
Read the other 3 answers
Hi How to populate data for 2LIS_40_REVAL, 2LIS_43_POSCAS and 2LIS_44_POSREC datasources at RSA3? I'm very new to retail BI. I think there is no setup tables for Retail infosources. Any IDoc or BAPI activation is required or other procedure? We are i
Hi ALL, Source: ECC 6 Target: BI 7.3 We are Transferring 2LIS_13_VDITM Datasource---->> 0SD_CO3 Infocube . After Data Replication , 1. Data Transferred to PSA . 2. During Transformation Creation Manuel Mapping is performed . Activated . 3. During DT
Hello everyone, I need some help making a design decision to solve a fairly challenging issue I am facing. I am working with inventory and sales cubes for a retail company. These cubes are pupulated with about 2 years worth of data. Our business is r
Hi.. We have implemented 2LIS_03_BX  for Initial stock( Till day) and 2LIS_03_BF for movements ( from today). So we are not loading any past movements.we are interested only in movements from today. Now, the clients wants to see the weekly(starting f
Hi, I was trying to configure department store & shops. I came across SAP help text that states: Unlike a traditional store, a department store cannot manage inventory of merchandise that is destined for the consumer, as article-based/value-based inv
Hello Gurus,                  We are implementing BI7 and SAP IS retail. I have tried using 0IC_C03 cube but it is not giving correctresults. Can anyone suggest for implementing inventory management in retauk scenario. Regards, Baljit SinghHello OJ,
Hello I'm working with a copy of 0IC_C03 Infocube for inventory,  like a standard process I have loaded: 1.- 2LIS_03_BX  extractor for openning balance 2.- 2LIS_03_BF  extractor for material movements 3.- 2LIS_03_UM extractor for revalorization and a
Hello, I am working on MAP scenario, I found the following data sources as a part of it. Can anybody please tell me how to fill the setup tables for these and what are the base tables for it?? 2LIS_40_REVAL 2LIS_40_S202 2LIS_40_S207 2LIS_40_S208 Your
Dear all, I'm setting up the logistics extraction in a retail environment. For Revaluations, standard BC infosources & data sources are available. Can somebody please tell me what the difference is between 2LIS_03_UM and 2LIS_40_REVAL? Should I use b
Hello gurus Could anyone please send me any documents regarding the BW retail implentation.. i hve the PDF but i need some more if any available. Also could anyone send me the link for 2LIS_40_REVAL from saphelp. regards RamHi Ram,    Have a look: Re
Hi, we are using SAP-Retail and BW 3.3. I´d like to enrich my DataSources 2LIS_02_SCL, 2LIS_02_ITM, 2LIS_03_BF, 2LIS_03_UM and 2LIS_40_REVAL with the Application Component BWAPPLNM "IS-R" and Retail Process Keys. I´ve set the flag in Customizing
Hi BW Gurus, I am loading standard cube 0RT_C37 and trying to activate transformation and the data source feeding to this cube is 2LIS_40_REVAL. I am getting an error " Rule ( target: 0LOC_CURRCY , group: 01 standard group); syntax error in the routi
Hi - what is the difference between POS and POSDM ? There are POS datasources such as 2LIS_40_REVAL etc for POS and then there are 0RT_PA_TRAN_CONTROL for POSDM ? In what ways these are related and how ? Thanks a lot.Hi anu POS datasources are the ol
Hi experts! Iam loading the deltas from 2lis_40_reval into 3 cubes. In one cube the dataload is successful,but in other two cubes deltas are unsuccessful.B'coz a shortdump was occured due to function module was called incorrectly. can any expert give
Hello experts Infosource 2lis_40_reval is uploading into 3 targets. during delta upload, data to 1 data target uploaded successfully where as for other 2 unsuccessfully. There was a problem in update rule. so we corrected that error and uploaded from
Hi All, I have done an enhancement for 2lis_02_itm with few fields. I have successfully completed this work and i can see the records in RSA3. Now the client is asking that during testing they found that the process keys are not enabled in R/3 side.T
I want to find out whats the actual usage of the settings below 1) Determine Industry sector 2) Transaction key maintenance for SAP BW. is this a general global setting or an application specific setting ? When is this setting performed and what infl
Hi gurus- I'm facing a problem,i'm trying to activate Standard extractor 2LIS_02_HDR & 2LIS_02_ITM, after going through the documentation on info source , it's asking me to do some config like industry , maintainance process keys...etc, i want to kno
Hi SDN, We have a few PO for which in BI there are records with processkey 002 and 003 but none with processkey 001. Is it possible? If so, in what circumstances 2LIS_02_ITM may not bring records for processkey 001? Thanks for the help. SMHi oss note