Sorting View output on date - Generic extraction !!!

November 30 0
Advertisement
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 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.
Thanks,
Advertisement
before you assign the final values to FM output, sort the internal table by created date descending and delete adjacent duplicates. So you will have only latest record in output .
You can also do this in start routine of transforamtion from PSA to DSO
Sorting View output on date - Generic extraction !!!

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

Report painter -output parameters,Data source,Extract parameter, report

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

Any docs regarding Table/View,Function Module for Generic Extraction

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

Master Data-Generic Delta

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

When we go for Views and Function Modules for Generic Extraction

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

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

When to go for generic extraction using view and infoset query?

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

Generic extraction using function module and view

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

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

What is the disadvantage with views in generic extraction?

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

Generic extraction (table,view,functionmodule)

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

Generic extraction

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

Generic Extraction (or) How to use table in R/3 system as datasource in BW?

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

Generic Extraction Delta Loads

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

Deltas in generic extraction

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

Generic Extraction-example

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

Generic extraction loading and performances issues

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

Customer and Generic extraction difference ?

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

Generic extraction using table

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

Generic extraction for FI_AR

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