Sorting View output on date - Generic extraction !!!
I created a generic data source based on the view, But my problem is like, for the same slection conditions ( same material in the same site) i may get two records, in that case i need to pick latest record based on the created date.
My approach was like I passed the data from generic data source to DSO and enabled overwrite functionality keeping material and site as key fields, thinking like latest record will overwrite old record, but interestingly old record is replacing the latest record,
i saw in PSA , the record number for latest record is 555. but record number for old record is 1000.
So my question is like, what determing the sequence of records that enter into BW system? Is it View? or the sequence of fields that i defined in the view? or any settings that i ignored at the time of defining view? How can i change the sequence of records entering into BI system, i want to change in sucha a way like record number of latest record should greater than the record number of old record.
You can also do this in start routine of transforamtion from PSA to DSO
Hi All, I created a generic data source based on the view, But my problem is like, for the same slection conditions ( same material in the same site) i may get two records, in that case i need to pick latest record based on the created date. My appro
Hi expert, 1)What report painter -output parameters,Data source,Extract parameter, report mean for and what are the difference? 2)I have create new report painter and transport to Test server using T-code:GCTR and I find that the T-code always point
Hello All I need to do Generic Extraction,for that if anyone has docs., I need docs on how to create table,view,Function module and infoset query ,on that pl forward to my id [email protected] Many Thanks balajihi Amit Thanks for your docs,but this d
hello guys I have some doubts when it comes Generic Extraction of Master Data from a source system(say SAP R3) with possible deltas... 1.I heard from my friend,that while working with Master Data Generic Extraction (involving deltas),we generally do
Hi Experts, Can you please explain when we go for extracting the data using Views and when we got using Function Modules using Generic Extraction from R/3 system to BW with examples. And also can you explain when we go for delta for the above both sc
how to extract data by using function module in generic extraction please give me steps requiredDear Deba, Generic Extraction via Function Module /people/siegfried.szameitat/blog/2005/09/29/generic-extraction-via-function-module If the requirement
Hi, Can anyone clarify me when we should go for generic extraction using view and when we should go for generic extraction using infoset query.... Also what is the difference between view and infoset? I tried but could not find ou
hi every one , iam new to bw and can anyone plz tell me how to extract the data from R/3 to bw using generic extractor by creating function module and a view thank u, kishoreHi Kishore, Check this blog: /people/siegfried.szameitat/blog/2005/09/29/gen
give me details about differrent views in generic extraction give details such as database view, projection view, help view, etc please give detailDear Deba, Projection view - Just retrieves some fields from a single table. Help View - This is used
hi what is the disadvantage with views in generic extraction? thanks in advance, srinivas.Hi , <i>What is disadvantage of generic extraction ? </i> If i am asking this what you will say ......You have only less points to say if any one ask you
hi In generic Extaction when we use table and view and function module and sap qu (scenario) AND plz send some examples Please search the forums before postingHi, when Standard Extractors are not supporting to your requirement then we go with Generic
Hi, in generic extraction in which scenarios you extract data from table,view,infoset query,FM sridharTransparent Table If you're wishing to create a generic DataSource based on a single Transparent Table in the source R3/ECC system, then using that
Hi all, Hope all are having a great day Can any1 tell me the steps, for Generic Extraction. It will be very helpful, if the steps are as much as simpler as posible. I know to create a simple cube in BW. I have this much knowledge, depending on this c
Hi Experts, I am facing problem is I want to extract the data in Generic Extraction in View, Suppose my requirement is I want to delta loads every 1 hour per day, how can i do, Generic Extraction possible are not delta records. Note:- LO Extraction i
how can we set delta updates in generic extraction?can any one help in thisHi Praveen, Please do check the link for step by step for generic extraction https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/84bf4d68-0601-0010-13b5-b
hello EXPERTS I am trying to give one presentation about 'Generic Extraction using View'...I know how to explain the process.But as I donot have project experience,I have never worked with Generic Extraction. Can any one give an example where they us
hi, any one can give the details about the generic extraction loading as well as performance issues. advance thanks regards praveenHi, when there is no suitable business content datasource we go for creating generic data source. by using generi
Hi ya, Could any body tell me the difference between the customer and Generic extractions.what are the extraction steps? Regards. HHi, In Generic extraction we have to fetch the data from table/view/funtion module.T.code RSO2. Replicate the data sour
Hello friends, We have three methods in Generic extraction, as we know. 1. Using view/Table 2. Using FM 3. Using Infoset Query I know pretty well the extraction using View, but when do we use "Table"? Is there a specific method to perform generi
Hello Bi Gurus, Data source:0FI_AR_6 Source Table: KNC1. I want to extract data from KNC1 table - Instead of using 0FI_AR_6 data source.What are steps i need to follow for Generic extraction? What are delta modes i should be using? What are the setti