Amicuk Programming Answers

Data Missing in InfoObject

-0001-11-30   Views:0


Hello Everyone, I extracted text data from an r/3 DataSource into BW. In the InfoPackage, under processing i chose 'Only PSA'. Update Subsequently in Data Targets. Ignore Double data records. The schedule was successful. I can see the data in PSA. Bu

Hello Everyone,
I extracted text data from an r/3 DataSource into BW. In the InfoPackage, under processing i chose
'Only PSA'. Update Subsequently in Data Targets.
Ignore Double data records.
The schedule was successful. I can see the data in PSA. But, in the InfoObject i cannot see even a single record.
It displays 'EN' in language column and 'Created By' in description column.
Could someone help.

The replay answer
Hi SSree,
Thanks for the reply. I tried all options. Now, it is acting strange.  Let me expain clearly. The table name is TPART. The key fields are PARVW and SPRAS. There are 10 values in PARVW. There are 500 records. when extracted in RSA3, i get all records. But,not all records are coming into BW.
I checked Transfer structure to to see, if there are any transfer rules written. But, i don't find any. I don't understand why can't i see all records in BW. Before i was getting all records in R/3 into BW. I don't rem. making any changes to it.
The records of a value in PARVW (X - 50 records) are not appearing in PSA. Also, in DataStr/Transfer Rules tab in BW, i see both SPRAS and PARVW are selected. But, in Infopackage selection, only PARVW appears. I donno if this makes any difference.
Case 1 - In processing tab, when i choose 'only PSA' and 'ignore duplicate records', 450 records go into PSA. they are successful. when i update them into IO manually, i don't see any values in IO. As i said in my earlier post,
In IO: (since EN is default in selection screen)
IO Lang Desc.
   EN created by
Case 2 - In Processing tab, when i choose even 'Update Targets subseq.' option along with other 2 options, i get 20 errors in PSA (2 records for each value of PARVW have some junk char. Though these junk char. appear in Case 1 i do not get any errors in that case).
Could someone help.

Go to See the other 22 answers

The data type of InfoObject 0ORGUNIT is incompatible with field 0ORGUNIT

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

I am trying to create a DataSource in BW to load the organizational hierarchy from HR R/3 to BW.  I get the message "The data type of InfoObject 0ORGUNIT is incompatible with field 0ORGUNIT,"  Our BW version is 3.5; the version of HR R/3 is SAP[More]

Advantage of data  transfer from infoobject to ODS

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

Hi, 1)what is the advantage of  bringing data first in infoobject and  then moving into DSO ?? why cant we directly bring into DSO?why we need infoobject in between 2) can we use infocube in Infoset? if no then y?Hello, You don't normally feed data f[More]

Query: Data length of InfoObjects

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

Hi all,       I am new to BW. I'll try to put my question as best as I can. Let's say I create a new infoobject(characteristic) and I give its data type as CHAR and length as 12. Now while loading data will it be a problem if the data for this infoob[More]

LANGUAGE dependent TEXT data load to Infoobject

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

Hi, We had Z infoobject with LANGUAGE dependent TEXT data. We had a Z table in ECC in which the Text data of the Z info object is maintained. Table Structure: ZObjects : Lanuage:1-Text : Lanuage:2-Text Now i created a data on the Z table and extracte[More]

Error: Data element for InfoObject AUFNR 0PM_ORDER could not be created(QA)

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

Hi Experts, I am trying to Transport a request from DEV to QA,which consists Transaction Infosources,  afetr the inport the TR is failed with return code 8. and the error message in the log is as follows..... Error when determining a number from obje[More]

Loading Master Data to an InfoObject

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

All, When loading a info provider like an ODS or Cube, there is a 'manage' option where you can see the requests that have loaded and that have failed. Where is the equivalent feature for loads to an InfoObject?  Is there one? Thanks in advance...hi[More]

Loading master data from another infoObject (generate export datasource)

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

Hi All, We are using a 0MATERIAL that is loaded every day, and we would like to use another infoObject that contains data updated every end of last month (and ont daily). For instance, on 15th april, we would like use data from 31th march and not 15t[More]

Problem deleting Master Data from an InfoObject

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

Hello Everyone, We have 0MATERIAL infoobject. There was no Master data in the infoobject. Then, i manually entered the data into the InfoObject. After a day, i tried to delete the Master data to load it from R/3. When i tried to delete the Master dat[More]

How load data from One Infoobject to Another Infoobject?

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

Hi GuRUS Any body has succeded in loading data from One Infoobject to Another Infoobject? Pls Let me kNow Regards DuraiHi Durai, Create export datasource on the info-object and then load the data to the other info-object. Check this link also: Re: Ho[More]

Concatenation of Data from 4 infoobjects into a single cell in Bex Report

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

Hi, I have loaded ODS with the description data. The source system for loading the ODS is the flat file. The ODS data should be a replica of the flat file. In the flat file, there is a description field corresponding to a particular ID. This Descript[More]

How to Change the data type of infoobject from NUMC to CHAR

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

Hi Experts, I have created an infoobject with data type as NUMC, i used in DSO as a key figure and i have loaded data up to PSA. Now i want to change the data type of this Info Object from NUMC to CHAR. Can anyone suggest me the solution for this iss[More]

We are working on project that have to work with 9iAS/OC4J 9.0.2, upgrade to OC4J 9.0.3 in NOT an option. Our J2EE application will only use Servlets/JSP (NO EJBs), we need to do O/R mapping from Servlets to db. How can we install / use TopLink (9.0. [More]
So I'm slowly acclimating to Lion Server, however, I'm not able to determine how to specify the parent folder for Groups.  By default it's the /Groups root directory on the boot volume however I'm trying to change it to an alternate drive on a separa [More]
I am using the Oracle XML parser, and I am finding that some funny things are happening when I try to use the document(object, node-set?) function, as defined in the XSLT specification. For some reason, my xmlns path is being prepended to any file pa [More]
Hi All, Am getting the above error msg from a procedure (packaged or not, doesn't seem to matter), run from a .SQL script through sqlPlus, where I've created a DB link, fired off a bunch of queries against it using dynamic SQL, and then tried to drop [More]
I tried to run a simple ActiveJMS client in VB6 with SUN's broker. All steps have been successful until trying to compile and run the ActiveX in VB6 code. 1) ************************************************************************************ Code fr [More]
I just started my first editing project on iMovie 9. When I imported the footage, the video seem to be in a fast forward mode but the audio was normal. How do I slow down the video to match the audio?Hi You need to supply more info - for us to be abl [More]
Hi, I'm using a white iPhone 4s with 16gb memory and having some problems. Whenever I use earphones the sound will be heated when the volume is at the highest if I turn it down any lower all I hear is static. Can anyone help me with this problem as I [More]
If I want to back up an iCal calendar onto something like a USB flashdrive where would I find it?  Since I am not using Lion, I do not have iCloud capability.Mike, Calendar data for Mac OS X 10.6 is stored in the Macintosh HD/Users/yourusername/Libra [More]
Hi all, My requirement is to validate the IBAN number  (stored in IT 0009) changed by the user via ESS.  Is the IBAN number validation need to be performed based on the employee countr key, BANK key and account number or simply based on the IBAN numb [More]
Hi All, Please update the security differences between BW3.5 & BI 7. Regards, VenuDear Venugopal Iu2019m going to try help you regarding your question, The authorization perspective of 3.X is focused in the authorization object, thatu2019s means that [More]