04-12-2009 4:49 PM
First time I need to write code for BI/BW and first of all can't understand why TEXT_CONVERT_XLS_TO_SAP is not in BI system and second of all what the workaround is. I need the functionality. Please advise. Thanks.
04-12-2009 5:55 PM
Possible reasons why this FM is not included in BI system would be:
In BI you have a procedure to upload a data from the flat file into the PSA and from PSA to DSO and then to cube. You can also update the database table from these data. Hence it is not included.
Regards,
Lalit Mohan Gupta.
04-12-2009 5:38 PM
04-12-2009 5:42 PM
04-12-2009 5:55 PM
Possible reasons why this FM is not included in BI system would be:
In BI you have a procedure to upload a data from the flat file into the PSA and from PSA to DSO and then to cube. You can also update the database table from these data. Hence it is not included.
Regards,
Lalit Mohan Gupta.
04-12-2009 7:00 PM
Thanks Lalit Mohan Gupta. It is not a comprehensive answer, but I'll look into it later this week. Got spec yesterday, dev must be done tomorrow. Regards, Adrian
04-12-2009 8:03 PM
The function module is not a basis function module - it is an ECC (R/3) function module. Therefore it will not exist in a non-ECC system.
If the program has to be finished tomorrow, I'd tell the requester he has a choice - either upload only text based excel files (i.e. CSV, TAB Delimited) - or be wait a little longer while you copy the FM from an ECC system into BI, or you develop some OLE to read the excel files directly.
matt