I have created an generic extractor on Table -- CSKB in R/3 and checked through RSA3 by extraction and listing the data. There is no any time duplication and date overlaping for cost element.
Replicated the DataSource in BI and created Infosource to uppload to the datatarget. Data uploaded to PSA successfully but gave error when it tried to load into the characteracteristic: Date overlapping. I checked the data in PSA there is not date overlaping or duplication.
Please help for the problem. Points will be given for sure.
*More Detail Is given Below:*
==============
Created the Generic Data Source in ECC6.0 on the Table -- CSKB by creating the following view
Table/Join Conditions: Nothing
View Fields:
MANDT CLNT 3 Client
KOKRS CHAR 4 Controlling Area
KSTAR CHAR 10 Cost Element
DATBI DATS 8 Valid To Date
DATAB DATS 8 Valid-From Date
KATYP CHAR 2 Cost element category
EIGEN CHAR 8 Cost element attributes
MSEHI UNIT 3 Unit of Measurement
Selection Conditions: None
Created Data Source on the above mention View.
Selected following fields:
KOKRS Controlling Area
KATYP Cost element category
Activated - > RSA3 ->Extractor Name
>Extraction
>Display List-->DataPackage List->Displayed Package->Record displayed Successfully
BI 7.0: RSA1OLD
Replicated DataSource in BI7.0 --> Created Info Source -->Created Update Rule with chracteristic --> Created Info Package on DataSource --> Start
Data Extracted successfully in PSA But gave an Time Overlapping Error in almost every record. I checled in PSA but there was not duplication or time overlaping in CostElements fromDtae and ToDate