Skip to Content
0
Former Member
Apr 16, 2014 at 08:15 PM

Validation with data file error while validating transformation file.

62 Views

Hi Everyone,

I am getting Validation with data file error while validating transformation file.

Please let me know where i have gone in wrong.

Here is my transformation file:

P.S Click on transformation file to see in big size.

Start routine: I have given name of BADi Implementation name.

RP_TIME dimension is user defined.

Here is Source Flat file data.

ACCOUNT CUSTOMER ENDCLIENT TIME EMPLOYEE SIGNEDDATA BENCH XYZ ABC 2018.01.01 VN 120 BENCH XYZ ABC 2018.01.02 VN BENCH XYZ ABC 2018.01.01 IM 300 BENCH XYZ ABC 2018.01.02 IM BENCH XYZ ABC 2018.01.01 DS 400

Start Routine: The Code we have used to eliminate the NULL values is as follows(In our case second and 4 th records)

method IF_UJD_ROUTINE~RUNROUTINE.

DATA: lo_dataref TYPE REF TO data.

FIELD-SYMBOLS: <lt_data_im> TYPE STANDARD TABLE.

FIELD-SYMBOLS: <lt_data_ex> TYPE STANDARD TABLE.

FIELD-SYMBOLS: <ls_data> TYPE ANY.

FIELD-SYMBOLS: <zsg_data> TYPE string.

*DATA : lv_debug TYPE N VALUE 0.

* Assign importing data reference to field symbol

ASSIGN ir_data->* TO <lt_data_im>.

* Create work area for importing data

CREATE DATA lo_dataref LIKE LINE OF <lt_data_im>.

ASSIGN lo_dataref->* TO <ls_data>.

* Create new internal table for exporting data

CREATE DATA lo_dataref LIKE TABLE OF <ls_data>.

ASSIGN lo_dataref->* TO <lt_data_ex>.

*WHILE lv_debug EQ 0.

*ENDWHILE.

* Remove signed data = Null here

LOOP AT <lt_data_im> ASSIGNING <ls_data>.

ASSIGN COMPONENT `SIGNEDDATA` OF STRUCTURE <ls_data> TO <zsg_data>.

if <zsg_data> <> ' '.

APPEND <ls_data> TO <lt_data_ex>.

Endif.

ENDLOOP.

* Exporting data to exporting data references

GET REFERENCE OF <lt_data_ex> INTO er_data.

endmethod.

Attachments

Untitled.png (177.0 kB)