Extracting Date & Time values from a SAP Table

[Former Member]

Hi,

I am extracting the Date and Time values from a SAP table. I am getting different values in the output - some date in the past. Its not correct. Can somebody tell me what are the usual mistakes one may make here? Appreciae it.

Regards,

V M.

Edited by: V M on Jul 22, 2008 10:57 PM

[former_member192939]

Check the date format in SAP.

[Former Member]

I got this to work now. But my XML output has 4 columns of which I want to supress 2. I do not want to display them. Can somebody tell me how to do that? All 4 fields are defined in my 'IllumDoc' action block. Appreciate it.

Regards,

V M.

[Former Member]

[dude.....|http://help.sap.com/saphelp_xmii120/helpdata/en/44/351273ba154cc5e10000000a11466f/content.htm]

[Former Member]

In your display applet you can use "DisplayColumns" parameter to show only the desired columns.

[Former Member]

It works now. Thanks for your ideas guys.

Regards,

V M.

[Former Member]

Hi,

1. Don;t define the fields in the Illumdoc..

If functional requirement is not allowing this then

2. Use the desired columns to display template like display columns in iGrid or Value columns in iChart

3. If you want to do this logic in the BLS itself....

xml functions---> Column stripper

you can use this action block to remove the columns..

Regards,

Kishore

[Former Member]

Sounds cool Kishore. I will try the 'Column Stripper' method next time.