Error in UJFS

[Former Member]

Hi all.

When I try to download a file in UJFS transaction this don't work and displayed a message

"SAP BPC cannot find generated document content in DB table".

The file is in \ROOT\WEBFOLDERS\APSHELL\PLANNING\DATAMANAGER\TRANSFORMATIONFILES\EXAMPLES\IMPORT.XLS

How I can resolve the problem?

Marco

[former_member591016]

Hello Everyone,

I am also facing same error ie Cannot find generated document content in DB Table when I am running package to upload master data from flat file. I am automatically uploading master data flat file using following code in backend

TYPES:BEGIN OF ty_data,

           text(125),

           END OF ty_data.

     DATA : hex(1) TYPE x VALUE '0A'. "Tab Space

      DATA: target TYPE char255

."VALUE '\ROOT\WEBFOLDERS\SIL\sales_planning_sil_2\DATAMANAGER\DATAFILES\EXAMPLES\ZCUST_LOC.CSV' .
*\ROOT\WEBFOLDERS\SIL\SALES_PLANNING_SIL_2\DATAMANAGER\DATAFILES\gt_saknr.xls
     DATA: it_data TYPE STANDARD TABLE OF ty_data,
           wa_data TYPE ty_data,
           flag(1) .

     DATA: p_file TYPE string ," VALUE '/usr/sap/BID/DVEBMGS02/work/ZCUST_LOC.CSV',
           text(125) ,
           string TYPE string .

     CASE sy-slset.
       WHEN 'FILE_LOC' OR 'FILE_SG'.
         target =  '\ROOT\WEBFOLDERS\SIL\SALES_PLANNING_SIL_2\DATAMANAGER\DATAFILES\MASTER DATA\' && p_target.
       WHEN 'FILE_SG1' OR 'FILE_SG2' OR 'FILE_SG3' OR 'FILE_SGC' .
          target =  '\ROOT\WEBFOLDERS\SIL\SALES_PLANNING_SIL\DATAMANAGER\DATAFILES\EXAMPLES\CUSTOMER MASTER DATA\' && p_target.
     ENDCASE.


**    if p_target = 'ZCUST_SG' OR p_target = 'ZCUST_LOC' .
**      target =  '\ROOT\WEBFOLDERS\SIL\SALES_PLANNING_SIL_2\DATAMANAGER\DATAFILES\MASTER DATA\' && p_target && '.CSV' .
**    ELSE.
**      target =  '\ROOT\WEBFOLDERS\SIL\SALES_PLANNING_SIL\DATAMANAGER\DATAFILES\EXAMPLES\CUSTOMER MASTER DATA\' && p_target && '.CSV'.
**    ENDIF .


     p_file = '/usr/sap/BIP/DVEBMGS02/work/' && p_source.
*      p_file = target .
*START-OF-SELECTION.
     OPEN DATASET p_file FOR INPUT IN TEXT MODE ENCODING DEFAULT .
      IF sy-subrc = 0.
       DO .
         READ DATASET p_file INTO text .
         IF sy-subrc = 0.
           wa_data-text = text .
           APPEND wa_data TO it_data.
         ELSE.
           EXIT.
         ENDIF.
       ENDDO.
     ENDIF.


     CLOSE DATASET p_file .

     DATA: lv_content_string TYPE xstring.
     CALL FUNCTION 'SCMS_TEXT_TO_XSTRING'
       IMPORTING
         buffer   = lv_content_string
       TABLES
         text_tab = it_data.
     DATA: p_docnam TYPE ujf_doc-docname.
     p_docnam = target.
*    TRY.
     lo_file_service_mgr->put_document(
                   EXPORTING i_docname     = p_docnam"lv_docname
                             i_compression = abap_true
                             i_splice_zip  = ' '"lv_splice
                             i_doc_content = lv_content_string ).

If I am directly uploading flat file through excel then it is working fine.

Kindly help me resolving the issue.