Set date in BDC

[Former Member]

hi all,

in bdc, when i wl execute the program, it should set the date in format 'dd.mm.yyyy' automatically.

but it wl not transfer from flat file, in stead it should set auto matially the current date. may be through variable.

Like in tcode QS21,

In first screen fields are :

plant

master insp character

valid from

so, both the first two fields wl fill from flat file. last field whould fill automatically the current date in format 'dd.mm.yyyy'.

how ?

[Former Member]

Hi,

While performing BDC recording,

and passing the data to the BDCDATA table, Pass the value of the date(converted into DD.MM.YYYY).

There are function modules to convert the date to DD.MM.YYYY as listed:

CONVERSION_EXIT_PDATE_OUTPUT

Eg: input = 24012008 and output = 24.01.2008

CONVERT_DATE_FORMAT

Eg: input = 20080201 and output = 01.02.2008

CONVERSION_EXIT_SDATE_OUTPUT

Eg: input = 20070201 and output = 01.FEB.2007

CONVERSION_EXIT_IDATE_INPUT

Eg: input = 01.02.2008 and Output = 20080201

CONVERSION_EXIT_LDATE_OUTPUT

Eg: input = 20070301 and output = 01. March 2007

CONVERSION_EXIT_PDATE_OUTPUT

Eg: input = 20070301 and output = 03.01.2007

Regards

Shiva

[Former Member]

hi,

thanks shiva. this is the easiest way to convert date in said format.

tahnks a lot.

[Former Member]

Hi,

Make the necessary changes in the bdc table before doing the call transaction.

bdc-Field = 'QPMK-GUELTIGAB'
bdc-Value = sy-datum . 
append bdc.

...

Call transaction QS21

regards,

Advait

Edited by: Advait Gode on Feb 12, 2009 1:15 PM

[Former Member]

you can use WRITE statement..