on 09-27-2007 1:20 PM
Hi All,
I wnat to know when we run any Datasouce in RSA3 in R/3 side for e.g ( 2LIS_13_VDITM) <b>form where it fetch the data and show as out put ?</b>
and How to use RSA3 to check what data is comming form source to BW ?
Please see the senario : (Environment is BW 3.5)
>>2LIS_13_VDITM is active datasource and is already functinal/rurrning for delta load.
>>suppose data is loaded and up to date till yesterday. and new delta is genrated in source system for today and now our infopakage will load delta records in today'a delta load.
>> Now I want see what data record is comming with <b>this load</b>. How can I take the help of RSA3 ?
or is there any other way to see and debug the comming records.
Regards
Ashutosh
Hi,
Check weather that record is there in RSA3 or not for your extractor.
If it is there it means that record is coming Up.
Regards
Karthik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
In rsa3 u have many option regarding the update mode (full, init, delta etc).
for LO - extractors , full or init will pull data from the setup tables.
for extracting delta - u have to give Update mode as D and u have to give the BW system so that it will pull delta records for that system.U can also check in RSA7 for the queued data.
if u want to check the last delta loaded in BW u can use update mode R and BW sys name so tat it will show the records in Repeat delta table.same thing u can check in RSA7 also.
Hi
If it pull data from set-up table for LO Extractors, Then How can we check data for comming delta.. ?
as we fill set up table only once. right ? so we may not get uptodate data from set up table right ?
I guess puting D in update mode but you said .. also put BW system ... I guess but we have newly cretaed delta records are get store in R/3 side only in delta Q.
So please confirm which system we need to put ?
can we say when we put update mode as D . it will pull data from Delta Q. ?
Setup table is done only once. the data lies in the setup table as long as u dont delete it. If u do a full or init load data will be picked from setup tables.
for Delta update u said that delta is gettin loaded to ur BW system (say BW1).
the latest records to be loaded to the target system BW1 will be available if u use update mode D and the target system as BW1
We are using Queued delta. delta records in R3 queue (LBWQ) is pulled to BW queue (RSA7) by doing job control in LBWE. after the job is done all the delta records in r3 queue comes to bw queue .so this is my delta records and this is loaded to bw system BW1.
u can see the delta records directly from RSA7 also.
Hi Biyaz,
Your information was help full to see delta records coming form R/3.
But why it is not helping me in my situation please advice.
Here is scenario :
I have to check delta record form data source 2LIS_11_VAITM, which is enhanced with 4 other Z fields. when I check this data source in RSA7 , I am not able to see data being populated for that 4 fields (which is appened in std 2LIS_11_VAITM).
I have wrriten ABAP routine in "zxrsau01" Program data population logic is correct.
even more confusing thing is that if we load that delta in ODS, that 4 fields contain data. so it is clear my enhancement routine is correct..
But Please tell me <b>why I am not able to see data in that 4 field (which is appended in std 2LIS_11_VAITM)</b> in RSA7.
Regards
Ashutosh
Hi
In RSA7 u will have only the data from the deltaQ (before any append) .when u pull it thru an extractor 2LIS_11_VAITM , Data in BW queue will go tru ur CMOD and go thru the routines and fill the appended fields . this occur only at runtime.U can check it in RSA3 check the debug mode check box and execute it.Before that u can put a break point in ur zxrsau01 where the 2LIS_11_VAITM is appended so that when u execute in debug mode it will stop at this break point ( u have to execute the code manually F7 till this break point is reached ) and u can analyse how the appended fields are gettin populated. The records in RSA3 will have the appended fields filled.
HI Biyaz,
I guess there lots of probmes in my way.... Now I am Not able to change update mode from F to D in RSA3 for Data Source 2LIS_13_VDITM even though I am Putting right BW system in Target.
could you Please let me know where we can change the property of data source which may enable us to choose "D" in RSA3.
Thakns
Ashutosh D
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.