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 guys. Hello sony mobile people. My name is Isaiah and I'm from Manila, Philippines. I am a solid sony fan boy for morethan 10 years now (mobile phones). Or maybe was a solid sony fan boy. Not until yesterday happened. 12/17/2013.  I heavily suppor [More]
So, yes I do have an iPhone 3gs and yes it might be me who logs in bla bla bla, point is... I have not used iMessage as I don't know how to. Also, I have not logged into my Apple ID account through it as I have not been asked to log in, nor have I do [More]
Morning. For professional use I do need a script or an automatic workflow to achieve that a file such I have modified in Change Tracking Mode, is »Shared via Email« as (a) a PDF file showing the changes, and (b) jointly with a clean version DOC file [More]
I want to sync only my existing contacts, and not gain all of my facebook friends. Is it possible?If you turned off Contacts wouldnt that mean that the Contacts would no longer be backed up to iCloud as well? That would make it a pain when upgrading [More]
Win XP, itunes 7.0.1, brand new dell c521 with latest drivers, obviously clean install. Italian itunes store. Same issue as with previous pc: imix rating screwed up. If I rate an imix 5 stars, it turns out to be 1. Anything from 4 stars to 1 gives a [More]
Hi,   On Production server, we use window 2008, 32 bit machine, the application is visual studio 2010, sql 2012, what version of crystal report should I install for this production server?   I should install CRforVS_redist_install_32bit_13_0_5 or CRf [More]
Hello: I can get the balance of SECess on Service tax not in J2IUN. How can I do? And the table:J_1IEXCACC new added 3 field are about what kind of account? RG23A AT1-AT3 RG23C AT1-AT3  What kind of account should I assign to these fields? BR, LindaI [More]
Hi All, After spending a lot of time trying to find a good solution for a dynamic drop-down menu, I end up writing my own. The solution is for a list of items, having ITEM as the primary key of the table and ITEMDESCRIPTION as the list of options for [More]
Hi All In one of the reports I have brought a hierarchy from the free characteristic.Although KF values are showing up for the nodes within the hiearchy ,The hiearchy main node shows a * against it. Does any body have any idea on whats going wrong? I [More]
Hello, I have some java code that queries the DB and displays the XML in a browser. I am using the oracle.jbo.ViewObject object with the writeXML() method. Everything works well until I try to process a large XML file, the I get the following error: [More]