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]

hi , please tell a bapi for customer scheduling agreement(va31). Thanks, sridharHi Reddy , what happend ? u told that u got the BAPI ? i already seen that FM ,Do one thing ? search for COMMIT WORK in VA31 program , i think u will get some idea. regar [More]
I recently bought an iMac G4 (1Ghz, 17") on eBay and am having problems getting the Airport Extreme card to connect to any network. It came with 10.5.1 installed and I've updated it to Leopard 10.5.8 I'm a bit of newbie with this Mac, but am learning [More]
Hi, I'm using SQL Developer to test a migration between Sybase and Oracle and it doesn't work (both online and offline) I've create a dedicated user account and connection, with the roles and privileges required (as seen in [More]
Hi, I want to use LSMW to upload longtexts to SAP. Source file is an excel spreadsheet with two columns containing the material no and the longtext. If the longtext contains more lines each line is separated by an LF (word wrap within cell in excel)! [More]
Hi, I have an Adaptec AVA-2906, is this the PCI card needed to connect internal HD's? It has a socket on the board that looks like the type of plug used to connect hard drives. On the backplate it has a socket with 25 pin connecter with screw holes l [More]
Hi Expert, I am using RSRV and trying to compare the content of P table to X table. But it seems that the X table was deleted while comparing it to P. And while doing it, I experience a "runtime error". Can I recover the X table and how? JanetHi [More]
Hi, I am currently trying to implememnt a Singleton Class in order to store a ArrayCollection of items that I can then access and manipulate across the lifecycle of my app. I have created the below Singleton Class that is designed to hold the ArrayCo [More]
I created a website for a friend, published the site and then backed up the HTML files to an external disk. I've since re-formatted my iMac and installed 10.5 Now I need to remove pages from the site and have to edit a few areas of the pages but i ca [More]
Hi, I tried to change the meta-data repository of the ESB from the Oracle Lite to the OracleXE. I changed the ESBPool connection pool in JDBC resources of the "home" instance application server, as well as the ESBDataSource to make it work with [More]
Hi there. I have just finished one of my project, and now I notice, that when the person talks, starting at 1:05, the sound is not that good. Why is it? It sounds perfect on my computer when I play it. So what is wrong?? [More]