Sitemap

Amicuk Programming Answers

2lis_04_p_matnr - Delta - Data retreival

-0001-11-30   Views:2

Advertisement

Hi Bwians, Part of the processed order was not capture in delta on 20/05/2006. The delta for that day was successful, descrepancy in GR quantiy when compared with R/3. Found there was no data captured for that Processed order. Data from 2lis_04_p_mat

Hi Bwians,
Part of the processed order was not capture in delta on 20/05/2006. The delta for that day was successful, descrepancy in GR quantiy when compared with R/3.
Found there was no data captured for that Processed order.
Data from 2lis_04_p_matnr feeds data to cube 0PP_C10. I am planning to set the QM status of the request from 20/05/2006 to till date and rerun the delta. But I am having doubt whether it can extract all the data from 20/05/2006 to till date. Please advice.
If there is any other way to capture the missed data please let me know.
Thanks & Regards
Srini

The replay answer
Advertisement
Hi Puru
There is another way of capturing the missed data if you know the date/document range which is missed during that period. Let's say that you want to update the missed data from 20/05/2006 till date . Then do the following :-
1.Ensure that you have deleted the setup tables for application 04 otherwise data will be doubled.
2.In R/3 system , Fill the set up tabels for application 04 (since your data source is 2LIS_04_P_MATNR)for missing date range.
3.Create a new Info package with repair full request option ON (For this got to Infopackage Menu -> Scheduler-> Repair Full request -> Check ON .
4.Load the data into data taregts using this new Info package.
Hope this helps
Regards
Pradip

Go to See the other 8 answers

2lis_04_p_matnr - Delta - Data retreival

Category:DefaultRelease time:-0001-11-30Views:130

Hi Bwians, Part of the processed order was not capture in delta on 20/05/2006. The delta for that day was successful, descrepancy in GR quantiy when compared with R/3. Found there was no data captured for that Processed order. Data from 2lis_04_p_mat[More]

2LIS_04_P_MATNR Delta - Actual Start and Finish Dates

Category:DefaultRelease time:-0001-11-30Views:130

My company is experiencing a problem with retrieving the actual start and finish dates and times from the 2LIS_04_P_MATNR data source with delta extraction. The R/3 source system is version 4.6C. The BI system is version 7.0. Specifically, the data s[More]

2LIS_04_P_COMP and 2LIS_04_P_MATNR delta issue

Category:DefaultRelease time:-0001-11-30Views:130

Hi experts, I am having problems with 2LIS_04_P_COMP and 2LIS_04_P_MATNR delta extraction. I run the init, it is ok. I create an order and then I run DELTA expecting to get more record(s). DELTA will bring no records. But if I delete set up tables LB[More]

XEM - Unable to load the initial data or the variances(delta) data into sys

Category:DefaultRelease time:2015-10-11Views:130

I am installing xEM 2.0 SP 10 (SAP xApp Emissions Management) in a windows environment with SQL 5000.  I installed xEM on NW 2004, usage types AS Java and EP 6. I am attempting to load the initial data or the variances (delta) data into the system. [More]

Full and delta Data loads in SAP BI 7.0

Category:DefaultRelease time:2015-10-11Views:130

Hi, Kindly explain me the difference between full and delta data loads in cube and DSO. When do we select change log or active table(with or without archive) with full/delta in DTP for DSO. Please explain the differences in data load for above differ[More]

Delta data in open hub table

Category:DefaultRelease time:2015-10-11Views:130

Hi All, Can we store delta data in infospoke DB table. I created a infospoke by exporting the data of cube in DB table. now i want to export the delta data of cube in the same table. So  Guru's please let me know is this possible in infospoke to stor[More]

Extractor not picking delta data

Category:DefaultRelease time:2015-10-11Views:130

Hi All , I have a very peculiar problem with extractor 2LIS_02_SCN . The Delta data's are not getting captured in BW as well as in the RSA3 .This is happening for few  PO's . I checked the extractor debugger as well (in RSA3) , but it shows only 1 re[More]

BI Statistical data not able to load delta data

Category:DefaultRelease time:-0001-11-30Views:130

Hi Experts, I am working on BI7.0, we are trying to activate the BI Statistical cubes and load Delta data, so in the process , I did all the steps , activated and initialised the Data sources in BI 0TCT_DS03,0TCT_DS02 to the Cubes0TCT_C02 and 0TCT_C0[More]

Delta data migration on SAP upgread from 4.6C to ECC 6.0

Category:DefaultRelease time:-0001-11-30Views:130

Hi, We are planning for SAP upgrade in our Production environment and we are facing the below listed constraints and need your advice on the options to peform ECC Upgrade. 1) Present HW resource is already facing bottleneck and so no additional load[More]

Delta data load for huge table in Data Services XI R3

Category:DefaultRelease time:-0001-11-30Views:130

Hi, We have a project requirement of pulling delta data once in a week from table which has around 44 million records but it doesn't have any last modified column. In such case we have to use table comparison transform, but it will be very time consu[More]

BW 7.3 ,can we extract delta data from mutiproviders using OHD

Category:DefaultRelease time:-0001-11-30Views:130

Hi Gurus, My requirement is to extract the delta data from multiple infocube (more than one IC) using open hub destination to third party system. We thought of implementing BW 7.3 so that we can extract delta data from multiproviders instead of cubes[More]

Hot
Hi all, As reported here http://digital.ni.com/public.nsf/allkb/6BD344ACA4DEE20A8625692700737E16, it is possible to change font color, size or other font properties of a subtext in a string indicator. This can be applied to a caption too. I'd like to [More]
Hi: I have a question about editing a field and I hope you can help me. I need to make a field editable in FB02, but only for one document type and two users. The field is BSEG-ZFBDT, Baseline payment date. I have tried in 'Document Change Rules', ma [More]
Hi,      I have requirement and might be a common one. I have to built an rtf template for Purchase orders to output in pdf.I have a header table and detail table in the template. If there are more detail records the detail table get extended to next [More]
Hi, My scenario is file to soap file with out BPM.I am using a currency converter wsdl. I am getting a time out error in soap receiver channel. Do i need to change the time out parameter?Where do i change that?Please help me to solve it out. Followin [More]
HP wireless all-in-one CN245B Hi to everyone. I just bought this printer and I've got a problem with the scanner software. Can I scan all the document I want and after save them all together? From the sofware it seems that's possible, but when I do a [More]
When previewing clips using the events library, some clips do not playback their audio. I have audio skimming turned on however about half of my clips in my event do not play audio. If I drag to the timeline they playback fine. There is absolutly no [More]
When I boot my G5 mac or my wife's ibook neither will automatically connect to the wireless network we always use (apple airport express network in our house). They have to be pointed to the network even though it is the only one listed in our prefer [More]
Hi, This is urgent............. could u any one please suggest me on this query it returning single row subquey returnin more than one row In this 2nd suquery fails some of the order_numbers returning more than price_list based on dates and in that s [More]
Hi, I am looking for any documentation on the OCI call structure ('Web service') for PO/Requisitions. This it allow accessing external catalog via transaction NME51N using ERP 2005 PR/PO. The only documentation I have seen is related to the SRM EBP a [More]
MODERATOR:  All points have been UNASSIGNED and the thread LOCKED.  Do not share email addresses on these forums.  If you have some information, please consider posting it to the [Wiki|https://wiki.sdn.sap.com/wiki/display/ERPFI/Home] rather than sha [More]