Home > Default > No Data from SAP R/3 to SAP BW

No Data from SAP R/3 to SAP BW

October 11Hits:0
Advertisement
Hi there,
  I am attempting to activate the standard BW Business Content for <b>HR | Personnel Administration</b>
  I have activated <b>InfoSource | Personnel Adminstration(PA-PA)</b> as well as <b>InfoArea | Personnel Adminstration(0PAPA)</b>
  Hence, managed to map :-
  InfoSource <b>EMPLOYEE | 0HR_PA_0</b> to DataSource <b>0HR_PA_0-Employee</b>
  InfoSource <b>PERSONNEL ACTIONS | 0HR_PA_1</b> to DataSource <b>0HR_PA_1-Personnel Actions</b>
  InfoSource <b>'Headcount' | (0HR_PA_PA_1)</b> has NOT been assigned to any data source
  Hence, when I preview my InfoCube <b>Headcount and Personnel Actions | (0PA_C01)</b> I can see only the values for <b>0EMPLOYEE</b> . I <b><u>cannot</u></b> <b>see</b> the other values such as 0PERSON, 0ACTIONAREA, 0ORGUNIT, 0PERS_AREA, 0AGE, 0COMP_CODE or the other standard fields
I have checked the InfoType's in SAP R/3 and there are values in the respective tables.
Please advice on this ! Appreciate a quick responce
P/S: We're on BW 3.5

Answers

Hi guys,
  Made reference to SAP Note 336229.
  Maintained my Transfer Rules of <b>Data Source 0HR_PA_PA_1</b> to <b>Info Source 0HR_PA_PA_1</b> and all is green! Unfortunately, still <b>NO</b> data and error IDOC message is " <i>The data request was a full update. In this case, the corresponding table in the source system does not contain any data." </i>
  <i>The extractor of the DataSource reads the master data tables of the Employee (0EMPLOYEE) and person (0PERSON) InfoObjects and makes changes to these time-dependent attributes available as headcount changes</i>...<b>says SAP</b>
  Info Object <b>person (0PERSON)</b> works!!!, however Info Object(0EMPLOYEE) is giving me problem whereby in SAP R/3 <b>Data Source (Employee - Education and Training) 0EMPLOYEE_0022_ATTR</b> <u>allows</u> time overlapping of records, BUT BW generates an <u>error</u> " <i>The time interval ['99991231'/'19930104'] & (from/to) for the data records 46 and 47 overlaps in characteristic 0EMPLOYEE</i> "
For example, lets assume there is Employee X with the following entry in SAP R/3.
   Begin Date    End Date        SubType
   01.09.2003   01.09.2004      Professional Cert.
   01.09.2003   01.09.2006      Degree
    SAP R/3 allows this overlapping of time records however, BW does NOT. How can I tackle this overlapping issue in SAP BW?
With much appreciate,
-<b>John Mcluskey</b>-

Read other 4 answers

Tags:

Related Articles

  • Sending data from SAP-BW ODS to R/3 database table/ viewOctober 11

    I need to store data in an ODS in BW from an oracle view & then send this data to SAP R/3 so that the same data can be used by SAP-ABAP for making a BDC program ( i.e. finally storing it in some database tables in R/3). Is it possible to do that?? if

  • Upload data from SAP R/3 to BPCOctober 11

    Hi Expert We need to upload data from SAP R/3 Payroll to BPC into to use in a butget process. We actived 0HR_PY_1 extractor and we have data at PCA area. My question is how i can to load this data into a appset in BCP. Please give any idea to do that

  • How to get purchasing data from SAP R/3 to OWB (Oracle warehouse builder).October 11

    Hi, My name is Pavan Tata. I work as a SAP BW developer. Here is the situation at my client place. Client decided to retire BW system and wants to replace with OWB(Oracle warehouse). In all this currently we have purhchasing application in BW product

  • How to extract Inventory data from SAP R/3  systemOctober 11

    Hi friends How to extract Inventory data from SAP R/3  system? What are report we may expect from the Inventory?Hi, Inventory management https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/documents/a1-8-4/how%20to%20handle%20in

  • How to extract PS data from sap r/3 to bwOctober 11

    Hi, How to extract PS data from sap r/3 to bw PS data like plans,budget,accurals&commitmnets can any one help me regarding this.. Thanks in Advance, Shankar.HI sankar, you can refer the belkow link to find the details on the relevant extractors and i

  • Help Required -- Can we use SQL Query to READ data from SAP MDM TablesOctober 11

    Hi All, Please help......... Can we use SQL Query to READ(No Creation/Updation/Deletion  just Read) Data from SAP MDM tables directly, without using MDM Syndicator. Or direct SQL access to SAP MDM tables is not possible. Only through MDM Syndicator c

  • Erasing Sales data from SAPOctober 11

    Hello everyone, We are going to give the SAP server to another company from inside our organization and we are 'cleaning' up the data they won't need. For instance, we will use transaction code OBR1 to clean up some credit movements, etc.. I know tha

  • Loading of transaction data from SAP ECC system failedOctober 11

    Hi! I successfully connected SAP ECC system to SAP BI system. The following steps have been executed: - user ALEREMOTE with max. authorization - RFC destination - Distributing Data model - Generated Partner profile - Maintaining message types in WE20

  • How to derive month/year from date in SAP BW 3.5 data flowOctober 11

    Hi How we can derive cal year/month and fiscal month/year from date in SAP BW 3.5 data flow (we're using transfer and update rule).. Thanks, PKHi, if you have any date filed in source side you can just map to any time char system will automatically c

  • How to extract data from SAP in FDM 11121October 11

    I came across some documents from version 11113, says there is a SAP adapter, however ,when I check 11121 there's no such adapter, does anyone know how to extract data from SAP in FDM 11121?I download a package from Bristlecone, but I dont see any xm

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 15 q. 0.941 s.