09-09-2008 2:44 PM
hello all,
can any one help me in - how to read xml data file (placed in application server) and placing the same into an internal table (remove the xml tags or say fetching the xml data without xml tags).
09-09-2008 2:52 PM
Hi,
I think you need to perform lot of string operations to achieve this functionality.
Regards,
Sujatha
09-09-2008 4:06 PM
Hi,
Search this forum for statement CALL TRANSFORMATION.
Regards,
Bert
09-09-2008 7:17 PM
As Sujatha suggests....Only the string operations would work to get results...
Thanks,
Santhosh
08-03-2009 8:00 AM
Hi,
*Use the function module TEXT_CONVERT_XML_TO_SAP.
Regards,
Narendra
08-03-2009 8:04 AM
Hi Murashali,
use this.
TYPES: BEGIN OF day,
name TYPE string,
work(1) TYPE c,
END OF day.
DATA: BEGIN OF week,
day1 TYPE day,
day2 TYPE day,
day3 TYPE day,
day4 TYPE day,
day5 TYPE day,
day6 TYPE day,
day7 TYPE day,
END OF week.
DATA xml_string TYPE string.
DATA result LIKE week.
week-day1-name = 'Monday'. week-day1-work = 'X'.
week-day2-name = 'Tuesday'. week-day2-work = 'X'.
week-day3-name = 'Wednesday'. week-day3-work = 'X'.
week-day4-name = 'Thursday'. week-day4-work = 'X'.
week-day5-name = 'Friday'. week-day5-work = 'X'.
week-day6-name = 'Saturday'. week-day6-work = ' '.
week-day7-name = 'Sunday'. week-day7-work = ' '.
CALL TRANSFORMATION ...
SOURCE root = week
RESULT XML xml_string.
CALL TRANSFORMATION ...
SOURCE XML xml_string
RESULT root = result.
Regards,
Vijay
08-03-2009 11:10 AM
Hello,
Try this way:
1. Load XML file using open dataset and read it into string variable.
2. Use identical call transformation to transform xml string into ABAP internal table.
Refer to SAP help on DATASET and CALL TRANSFORMATIONS.
Thanks,
Augustin.