Output format CURR, QUAN, DATS for extract

[Former Member]

Hey,

i have a problem with the output format from database to a textfile.

I need the original format without the user settings.

Is it possible to deactivate the user settings for extract data?

I need datatype CURR, QUAN, DATS in original-format like YYYYMMDD for DATS.

I use this syntax for extract :

TYPES: 
BEGIN OF type_BKPF,
BLDAT          LIKE BKPF-BLDAT
END OF type_BKPF,
...
BEGIN OF type_file0,
BLDAT(8)
END OF type_file0,
...
DATA: gs_BKPF      TYPE type_BKPF,
T_BKPF      TYPE TABLE OF type_BKPF,
gs_file0    TYPE type_file0,
p_file0    TYPE String,
...
START-OF-SELECTION.
MOVE 'BKPF_p_file0.txt' TO p_file0.
CONCATENATE p_file p_file0 INTO p_file0.
OPEN DATASET p_file0 FOR OUTPUT IN TEXT MODE.
SELECT  BLDAT INTO gs_BKPF FROM BKPF.
CLEAR gs_file0.
MOVE-CORRESPONDING gs_BKPF to gs_file0.
CLEAR: gs_file0-BLDAT.
WRITE gs_BKPF-BLDAT TO gs_file0-BLDAT.
TRANSFER gs_file0 TO p_file0.
ENDSELECT.
CLEAR gs_BKPF.
free: gs_BKPF,
      gs_file0.

Thanks in advance.

Best regards.

[Former Member]

Check below...

START-OF-SELECTION.

MOVE 'BKPF_p_file0.txt' TO p_file0.

CONCATENATE p_file p_file0 INTO p_file0.

OPEN DATASET p_file0 FOR OUTPUT IN TEXT MODE.

SELECT BLDAT INTO gs_BKPF FROM BKPF.

CLEAR gs_file0.

MOVE-CORRESPONDING gs_BKPF to gs_file0.

CLEAR: gs_file0-BLDAT.

*WRITE gs_BKPF-BLDAT TO gs_file0-BLDAT.

Instead of Write use the below code...

concatenate gs_BKPF-BLDAT0(4) gs_bkpf-bldat4(2) gs_bkpf-bldat+6(2) into gs_file0-bldat.

WRITE gs_BKPF-BLDAT TO gs_file0-BLDAT.

[Former Member]

The DATS format was before

concatenate gs_EKKO-AEDAT+0(4) gs_EKKO-AEDAT+4(2) gs_EKKO-AEDAT+6(2) into gs_file2-aedat.

YYYY.MM.DD

and after insert this code:

YYYY.MM.DD

nothing changed through this code-line.

i need this format: YYYYMMDD without points.