CE PLUS - Nota 005568

Módulo: DOC. EXPORTAÇÃO

Funcionalidade: CE Reports

Data/Hora da Publicação: 07/01/2008 00:00:00

Data/Hora Última Alteração: 04/03/2010 17:05:16

Descrição da Nota: INTEGRAÇÃO DO REPORTS EXCEL COM O BDS

Sintoma

 

Não era possível armazenar os documentos gerados (arquivos .xls) no sistema.

 

Solução

 

Foi incluída a possibilidade de se armazenar o arquivo gerado no sistema, usando o BDS.

Versões Tratadas

7.0

Informações Complementares

 

----------------------------------------------------------------------------------------------------

Nota Número 05568 Data: 07/01/2008 Hora: 07:58:34

----------------------------------------------------------------------------------------------------

 

----------------------------------------------------------------------------------------------------

Nota Número              : 05568

Categoria                : Melhoria

Prioridade               : Baixa

Versão PW.CE             : 7.0

Pacote                   : 00004

Agrupamento              : 00028

----------------------------------------------------------------------------------------------------

Referência às notas relacionadas:

Número - Ordem - Descrição Breve

 

----------------------------------------------------------------------------------------------------

INTEGRAÇÃO DO REPORTS EXCEL COM O BDS

----------------------------------------------------------------------------------------------------

Palavras Chave:

INTEGRAÇÃO REPORTS EXCEL BDS

 

----------------------------------------------------------------------------------------------------

Objetos da nota:

CUAD /PWS/SAPLZYCRGF4

CUAD /PWS/SAPMZYCR003

DOMA /PWS/ZYCRD007

DTEL /PWS/ZYCRL022

DTEL /PWS/ZYCRL023

DTEL /PWS/ZYCRL024

DTEL /PWS/ZYCRL026

DYNP /PWS/SAPMZYCR003                        0231

DYNP /PWS/SAPMZYCR003                        0235

FUGR /PWS/ZYCRGF1

MESS /PWS/ZYCRM046

MESS /PWS/ZYCRM047

MESS /PWS/ZYCRM048

REPS /PWS/LZYCRGF4F01

REPS /PWS/LZYCRGF4I01

REPS /PWS/MZYCR003F02

REPS /PWS/MZYCR003I01

REPS /PWS/MZYCR003O01

REPS /PWS/MZYCR003TOP

REPS /PWS/ZYCRI003

REPS /PWS/ZYCRI005

REPS /PWS/ZYCRR003

REPS /PWS/ZYCRR010

REPS /PWS/ZYCRR011

REPS /PWS/ZYCRR013

REPS /PWS/ZYCRR014

REPS /PWS/ZYCRR015

REPS /PWS/ZYCRR016

REPS /PWS/ZYCRR017

REPS /PWS/ZYCRR018

REPS /PWS/ZYCRR020

REPS /PWS/ZYCRR021

REPS /PWS/ZYCRR023

REPS /PWS/ZYCRR024

REPS /PWS/ZYCRR026

REPS /PWS/ZYCRR027

REPS /PWS/ZYCRR033

REPS /PWS/ZYCRR100

REPT /PWS/ZYCRR003

REPT /PWS/ZYCRR010

REPT /PWS/ZYCRR011

REPT /PWS/ZYCRR013

REPT /PWS/ZYCRR014

REPT /PWS/ZYCRR015

REPT /PWS/ZYCRR016

REPT /PWS/ZYCRR017

REPT /PWS/ZYCRR018

REPT /PWS/ZYCRR020

REPT /PWS/ZYCRR021

REPT /PWS/ZYCRR023

REPT /PWS/ZYCRR024

REPT /PWS/ZYCRR026

REPT /PWS/ZYCRR027

REPT /PWS/ZYCRR033

TABD /PWS/ZYCRT013

TOBJ /PWS/ZYCRT013S

TRAN /PWS/ZYCRR100

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em CUAD /PWS/SAPLZYCRGF4

 

Criar no status-gui 5000 um nova tecla de função:

Código: REP_LIST

Tecla de Atalho: F5

Descrição: Listar documentos já gerados

Ícone: ICON_STORE

Descrição para ícone: Documentos armazenados no BDS

 

Incluir um separador de itens na barra de botões, após o botão cancelar.

Incluir a tecla criada na barra de botões, após o separador criado.

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em CUAD /PWS/SAPMZYCR003

 

Criar um novo status-gui para diálogo:

Número: 0235

Descrição: Editar parâmetros do BDS

 

Para este status-gui, criar as seguintes teclas de função:

 

Atalho: ENTER

Código de função: OK

Texto: Avançar

Descrição para ícone: <nenhuma>

 

Atalho: F12

Código de função: CANCEL

Texto: Cancelar

Descrição para ícone: <nenhuma>

 

Atalho: Shift-F2

Código de função: DELETE_BDS

Texto: Excluir parâmetros

Ícone: ICON_DELETE

Descrição para ícone: <nenhuma>

 

Incluir na barra de botões os seguintes itens:

1º: ENTER

2º: F12

3º: <separador>

4º: Shift-F2

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em DOMA /PWS/ZYCRD007

 

Domínio criado: /PWS/ZYCRD007

 

Descrição breve incluída (45 caracteres), idioma: PT

"CR - Opções de carregamento de arquivo no BDS"

 

Classe de desenvolvimento: /PWS/ZYGL

Idioma original: PT

 

Categoria de dados: CHAR

Número de posições: 1

Comprimento de saída: 1

Letras minúsculas: NÃO

 

-Valores individuais

 

Incluído valor fixo "N"

Texto incluído, idioma: PT (18 caracteres):

"Criar novo arquivo"

 

Incluído valor fixo "A"

Texto incluído, idioma: PT (28 caracteres):

"Substituir arquivo existente"

 

Incluído valor fixo "V"

Texto incluído, idioma: PT (17 caracteres):

"Criar nova versão"

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em DTEL /PWS/ZYCRL022

 

Elemento de dados criado: /PWS/ZYCRL022

 

Classe de desenvolvimento: /PWS/ZYGL

Idioma original: PT

 

Descrição breve incluída: (28 caracteres), idioma: PT

"CR - Carregar arquivo no BDS"

 

Categoria de dados: Domínio

Domínio: XFELD

 

Documentar modificações: NÃO

 

Comprimento máximo do denominador breve: 05

Denominador breve incluído (3 caracteres), idioma: PT

"BDS"

 

Comprimento máximo do denominador médio: 10

Denominador médio incluído (10 caracteres), idioma: PT

"Carrg. BDS"

 

Comprimento máximo do denominador longo: 15

Denominador longo incluído (15 caracteres), idioma: PT

"Carregar no BDS"

 

Comprimento máximo do título: 25

Título incluído (23 caracteres), idioma: PT

"Carregar arquivo no BDS"

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em DTEL /PWS/ZYCRL023

 

Elemento de dados criado: /PWS/ZYCRL023

 

Classe de desenvolvimento: /PWS/ZYGL

Idioma original: PT

 

Descrição breve incluída: (39 caracteres), idioma: PT

"CR - Opção de criação de arquivo no BDS"

 

Categoria de dados: Domínio

Domínio: /PWS/ZYCRD007

Documentar modificações: NÃO

 

Comprimento máximo do denominador breve: 10

Denominador breve incluído (7 caracteres), idioma: PT

"Criação"

 

Comprimento máximo do denominador médio: 15

Denominador médio incluído (11 caracteres), idioma: PT

"Criação BDS"

 

Comprimento máximo do denominador longo: 20

Denominador longo incluído (14 caracteres), idioma: PT

"Criação no BDS"

 

Comprimento máximo do título: 25

Título incluído (23 caracteres), idioma: PT

"Opção de criação no BDS"

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em DTEL /PWS/ZYCRL024

 

Elemento de dados criado: /PWS/ZYCRL024

 

Classe de desenvolvimento: /PWS/ZYCR

Idioma original: PT

 

Descrição breve incluída: (42 caracteres), idioma: EN

"Business Document Service: Attribute value"

 

Descrição breve incluída: (49 caracteres), idioma: PT

"CR - Descrição do report para arquivamento no BDS"

 

Descrição breve incluída: (44 caracteres), idioma: ES

"Business Document Service: Valor de atributo"

 

Categoria de dados: Domínio

Domínio: CHAR64

Nome componente default: PROP_VALUE

Documentar modificações: NÃO

 

Comprimento máximo do denominador breve: 10

Denominador breve incluído (5 caracteres), idioma: EN

"Value"

 

Denominador breve incluído (4 caracteres), idioma: PT

"Desc"

 

Denominador breve incluído (5 caracteres), idioma: ES

"Valor"

 

Comprimento máximo do denominador médio: 15

Denominador médio incluído (15 caracteres), idioma: EN

"Attribute value"

 

Denominador médio incluído (9 caracteres), idioma: PT

"Descrição"

 

Denominador médio incluído (14 caracteres), idioma: ES

"Valor atributo"

 

Comprimento máximo do denominador longo: 20

Denominador longo incluído (15 caracteres), idioma: EN

"Attribute value"

 

Denominador longo incluído (11 caracteres), idioma: PT

"Descr. Rep."

 

Denominador longo incluído (17 caracteres), idioma: ES

"Valor de atributo"

 

Comprimento máximo do título: 25

Título incluído (15 caracteres), idioma: EN

"Attribute value"

 

Título incluído (19 caracteres), idioma: PT

"Descrição do Report"

 

Título incluído (17 caracteres), idioma: ES

"Valor de atributo"

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em DTEL /PWS/ZYCRL026

 

Elemento de dados criado: /PWS/ZYCRL026

 

Classe de desenvolvimento: /PWS/ZYCR

Idioma original: PT

 

Descrição breve incluída: (52 caracteres), idioma: PT

"CR - Palavra-chave para pesquisa do documento no BDS"

 

Categoria de dados: Domínio

Domínio: TEXT64

Documentar modificações: NÃO

 

Comprimento máximo do denominador breve: 10

Denominador breve incluído (6 caracteres), idioma: PT

"P.Chv."

 

Comprimento máximo do denominador médio: 15

Denominador médio incluído (10 caracteres), idioma: PT

"Pal.Chave."

 

Comprimento máximo do denominador longo: 30

Denominador longo incluído (29 caracteres), idioma: PT

"Palavra-chave p/ pesq. no BDS"

 

Comprimento máximo do título: 55

Título incluído (47 caracteres), idioma: PT

"Palavra-chave para pesquisa do documento no BDS"

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em DYNP /PWS/SAPMZYCR003                        0231

 

Aumentar a altura do quadro FRM_VALUES para 6 linhas.

 

Criar botão BTN_BDS_CONFIG:

Linha: 15

Coluna: 2

Comprimento(def. e vis.): 30

Texto: Configurar arquivamento no BDS

Código de função: BTN_BDS_CONFIG

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em DYNP /PWS/SAPMZYCR003                        0235

 

Criar a tela 0235 como "Caixa de diálogo modal"

Descrição: Diálogo de parâmetros do BDS

Linhas: 6

Colunas: 50

 

-Lista de elementos:

 

Nome do campo                  Tipo   Lin Col  CDef. CVis. Dropdown  Ref.DDIC

-----------------------------------------------------------------------------------------

/PWS/ZYCRT013-BDS_CLASSNAME    Texto  1     1   15     15            X

WA_BDS_CONFIG-BDS_CLASSNAME    I/O    1    17   30     30

/PWS/ZYCRT013-BDS_CLASSTYPE    Texto  2     1   15     15            X

WA_BDS_CONFIG-BDS_CLASSTYPE    I/O    2    17    2     30     L

/PWS/ZYCRT013-BDS_OBJECT_KEY   Texto  3     1   15     15            X

WA_BDS_CONFIG-BDS_OBJECT_KEY   I/O    3    17   70     34

/PWS/ZYCRT013-BDS_DESCRIPTION  Texto  4     1   15     15            X

WA_BDS_CONFIG-BDS_DESCRIPTION  I/O    4    17   64     34

/PWS/ZYCRT013-BDS_DOC_TYPE     Texto  5     1   15     15            X

WA_BDS_CONFIG-BDS_DOC_TYPE     I/O    5    17   10     10

/PWS/ZYCRT013-BDS_CREATION     Texto  6     1   15     15            X

WA_BDS_CONFIG-BDS_CREATION     I/O    6    17    1     30     L

OK_CODE                        OK

 

 

-Lógica de processamento:

 

PROCESS BEFORE OUTPUT.

 

  MODULE status_0235.

 

  MODULE load_data_0235.

 

PROCESS AFTER INPUT.

 

  MODULE user_command_0235.

 

  MODULE user_exit_command_0235 AT EXIT-COMMAND.

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em MESS /PWS/ZYCRM046

 

Criar a mensagem 046 na classe de mensagem /PWS/ZYCRM.

Texto: Não foi encontrado nenhum report configurado para arquivamento no BDS

Auto-explicativa?: Sim.

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em MESS /PWS/ZYCRM047

 

Criar a mensagem 047 na classe de mensagem /PWS/ZYCRM.

Texto: Nenhum arquivo foi encontrado no BDS

Auto-explicativa?: Sim.

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em MESS /PWS/ZYCRM048

 

Criar a mensagem 048 na classe de mensagem /PWS/ZYCRM.

Texto: Report não parametrizado para arquivamento no BDS

Auto-explicativa?: Sim.

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/LZYCRGF4F01

 

...

  CLEAR: it_linha_marcada[], wa_linha_marcada, wa_documento.

  CALL METHOD grid_doc->get_selected_rows

       IMPORTING

         et_row_no = it_linha_marcada[].

  IF NOT it_linha_marcada[] IS INITIAL.

    READ TABLE it_linha_marcada[] INTO wa_linha_marcada INDEX 1.

    READ TABLE itab_reports[] INTO wa_documento

        INDEX wa_linha_marcada-row_id.

  ENDIF.

ENDFORM.

* >> Início da inclusão:

FORM exibe_lista_bds

     USING

       p_report LIKE wa_documento

       p_nrseq  TYPE /pws/zycet001-nrseq.

  IF NOT p_report IS INITIAL.

    SUBMIT /pws/zycrr100

        WITH s_repmod = wa_documento-report_module

        WITH s_repid  = wa_documento-report_id

        WITH s_pchave = p_nrseq

        AND RETURN.

  ELSE.

    MESSAGE i029.

  ENDIF.

ENDFORM.

* << Fim da inclusão

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/LZYCRGF4I01

 

...

  CASE okcode.

    WHEN 'OK'.

      PERFORM obtem_documento_selecionado.

      PERFORM executa_report

              USING

                itab_reports[]

                g_nrseq

                ch_options.

    WHEN 'CANCEL'.

      SET SCREEN 0.

* >> Início da inclusão: MODULE USER_COMMAND_5000

    WHEN 'REP_LIST'.

      PERFORM obtem_documento_selecionado.

      PERFORM exibe_lista_bds

              USING

                wa_documento

                g_nrseq.

* << Fim da inclusão

  ENDCASE.

  CLEAR okcode.

ENDMODULE.

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/MZYCR003F02

 

...

                USING

                   p_t_rep_param[]

                   wa_rep_param_to-rep_param-report_module

                   wa_rep_param_to-rep_param-report_id

                CHANGING

                   wa_rep_param_to-rep_param-matrix.

        wa_rep_param_to-rep_param-file_id

            = p_from_rep_param-file_id.

        wa_rep_param_to-rep_param-commentary

            = p_to_rep_param-commentary.

* >> Início da inclusão: FORM COPY_GRID_MATRIX

        wa_rep_param_to-rep_param-bds_classname

            = p_to_rep_param-bds_classname.

        wa_rep_param_to-rep_param-bds_classtype

            = p_to_rep_param-bds_classtype.

        wa_rep_param_to-rep_param-bds_object_key

            = p_to_rep_param-bds_object_key.

        wa_rep_param_to-rep_param-bds_description

            = p_to_rep_param-bds_description.

        wa_rep_param_to-rep_param-bds_doc_type

            = p_to_rep_param-bds_doc_type.

        wa_rep_param_to-rep_param-bds_creation

            = p_to_rep_param-bds_creation.

* << Fim da inclusão

        IF p_mark = 'X'.

          PERFORM mark_grid

                  USING

                     c_unmark_all

                  CHANGING

                     p_t_rep_param[].

        ENDIF.

        wa_rep_param_to-mark = p_mark.

        wa_rep_param_to-db_op = c_db_update.

        MODIFY p_t_rep_param[] FROM wa_rep_param_to INDEX v_tabix.

...

 

...

              USING

                 p_t_rep_param[]

                 wa_rep_param_to-rep_param-report_module

                 wa_rep_param_to-rep_param-report_id

              CHANGING

                 wa_rep_param_to-rep_param-matrix.

      wa_rep_param_to-rep_param-file_id

          = p_from_rep_param-file_id.

      wa_rep_param_to-rep_param-commentary

          = p_to_rep_param-commentary.

* >> Início da inclusão: FORM COPY_GRID_MATRIX

      wa_rep_param_to-rep_param-bds_classname

          = p_to_rep_param-bds_classname.

      wa_rep_param_to-rep_param-bds_classtype

          = p_to_rep_param-bds_classtype.

      wa_rep_param_to-rep_param-bds_object_key

          = p_to_rep_param-bds_object_key.

      wa_rep_param_to-rep_param-bds_description

          = p_to_rep_param-bds_description.

      wa_rep_param_to-rep_param-bds_doc_type

          = p_to_rep_param-bds_doc_type.

      wa_rep_param_to-rep_param-bds_creation

          = p_to_rep_param-bds_creation.

* << Fim da inclusão

      IF p_mark = 'X'.

        PERFORM mark_grid

                USING

                   c_unmark_all

                CHANGING

                   p_t_rep_param[].

      ENDIF.

      wa_rep_param_to-mark = p_mark.

      wa_rep_param_to-db_op = c_db_insert.

      INSERT wa_rep_param_to INTO p_t_rep_param[] INDEX v_tabix.

...

 

...

  ENDIF.

ENDFORM.

FORM mark_repository

     USING

       p_mark         TYPE xfeld

       p_index        TYPE i

     CHANGING

       p_t_repository TYPE t_repository.

  DATA: wa_repository LIKE LINE OF p_t_repository[].

  IF p_mark = 'X'.

* >> Início da exclusão: FORM MARK_REPOSITORY

    MODIFY it_repository[] FROM wa_repository

* << Fim da exclusão

* >> Início da inclusão: FORM MARK_REPOSITORY

    MODIFY p_t_repository[] FROM wa_repository

* << Fim da inclusão

                           TRANSPORTING mark

                           WHERE mark <> space.

    wa_repository-mark = 'X'.

* >> Início da exclusão: FORM MARK_REPOSITORY

    MODIFY it_repository[] FROM wa_repository

* << Fim da exclusão

* >> Início da inclusão: FORM MARK_REPOSITORY

    MODIFY p_t_repository[] FROM wa_repository

* << Fim da inclusão

                           INDEX p_index

                           TRANSPORTING mark.

  ELSE.

* >> Início da exclusão: FORM MARK_REPOSITORY

    MODIFY it_repository[] FROM wa_repository

* << Fim da exclusão

* >> Início da inclusão: FORM MARK_REPOSITORY

    MODIFY p_t_repository[] FROM wa_repository

* << Fim da inclusão

                           INDEX p_index

                           TRANSPORTING mark.

  ENDIF.

ENDFORM.

* >> Início da inclusão:

FORM set_screen_0235

     USING

       p_op_mode TYPE t_operation_mode.

  DATA: it_exclude_fcodes TYPE STANDARD TABLE OF sy-ucomm.

  APPEND: 'OK'         TO it_exclude_fcodes[],

          'DELETE_BDS' TO it_exclude_fcodes[].

  IF p_op_mode = c_show_mode.

    SET PF-STATUS '0235' EXCLUDING it_exclude_fcodes[].

  ELSE.

    SET PF-STATUS '0235'.

  ENDIF.

  SET TITLEBAR '0235'.

  IF p_op_mode <> 'M'.

    LOOP AT SCREEN.

      IF screen-group1 = 'EDT'.

        screen-input = '0'.

        MODIFY SCREEN.

      ENDIF.

    ENDLOOP.

  ENDIF.

ENDFORM.

* << Fim da inclusão

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/MZYCR003I01

 

...

      LEAVE TO SCREEN 0.

  ENDCASE.

ENDMODULE.

MODULE user_command_0200 INPUT.

  IF NOT v_new_report_module IS INITIAL.

    /pws/zycre010-report_module = v_new_report_module.

    CLEAR v_new_report_module.

  ENDIF.

ENDMODULE.

MODULE update_repository INPUT.

* >> Início da exclusão: MODULE UPDATE_REPOSITORY

  MODIFY it_repository[] FROM wa_repository

                         INDEX tc_files-current_line

                         TRANSPORTING mark.

* << Fim da exclusão

* >> Início da inclusão: MODULE UPDATE_REPOSITORY

  PERFORM mark_repository

          USING

            wa_repository-mark

            tc_files-current_line

          CHANGING

            it_repository[].

* << Fim da inclusão

ENDMODULE.

MODULE update_tree INPUT.

  v_rebuild_reports_tree = abap_true.

  PERFORM mark_report

          USING

               c_unmark_all

          CHANGING

               it_reports[].

  PERFORM mark_grid

          USING

...

 

...

                 it_rep_param[]

                 v_saved.

    WHEN 'BTN_CLEAR_FOLDER'.

      PERFORM clear_rep_folder_shlp

              USING

                 v_text_edit_report_folder

                 /pws/zycrt013

              CHANGING

                 it_rep_param[]

                 v_saved.

* >> Início da inclusão: MODULE USER_COMMAND_0231

    WHEN 'BTN_BDS_CONFIG'.

      CALL SCREEN 0235 STARTING AT 2 1.

* << Fim da inclusão

  ENDCASE.

ENDMODULE.

MODULE update_grid INPUT.

  PERFORM update_grid

          USING

              /pws/zycrt013

          CHANGING

              it_rep_param[]

              v_rebuild_reports_tree

              v_saved.

...

 

...

              CHANGING

                 it_key_priority[].

  ENDCASE.

ENDMODULE.

MODULE user_exit_command_0222 INPUT.

  CASE ok_code.

    WHEN 'CANC'.

      LEAVE TO SCREEN 0.

  ENDCASE.

ENDMODULE.

* >> Início da inclusão:

MODULE user_command_0235 INPUT.

  CASE ok_code.

    WHEN 'OK'.

      IF wa_bds_config-bds_classname <> /pws/zycrt013-bds_classname

          OR wa_bds_config-bds_classtype <> /pws/zycrt013-bds_classtype

          OR wa_bds_config-bds_object_key

              <> /pws/zycrt013-bds_object_key

          OR wa_bds_config-bds_description

              <> /pws/zycrt013-bds_description

          OR wa_bds_config-bds_doc_type <> /pws/zycrt013-bds_doc_type

          OR wa_bds_config-bds_creation <> /pws/zycrt013-bds_creation.

        /pws/zycrt013-bds_classname   = wa_bds_config-bds_classname.

        /pws/zycrt013-bds_classtype   = wa_bds_config-bds_classtype.

        /pws/zycrt013-bds_object_key  = wa_bds_config-bds_object_key.

        /pws/zycrt013-bds_description = wa_bds_config-bds_description.

        /pws/zycrt013-bds_doc_type    = wa_bds_config-bds_doc_type.

        /pws/zycrt013-bds_creation    = wa_bds_config-bds_creation.

        PERFORM update_grid

                USING

                  /pws/zycrt013

                CHANGING

                  it_rep_param[]

                  v_rebuild_reports_tree

                  v_saved.

      ENDIF.

      LEAVE TO SCREEN 0.

  ENDCASE.

ENDMODULE.

MODULE user_exit_command_0235 INPUT.

  CASE ok_code.

    WHEN 'CANCEL'.

      LEAVE TO SCREEN 0.

    WHEN 'DELETE_BDS'.

      CLEAR: /pws/zycrt013-bds_classname,

             /pws/zycrt013-bds_classtype,

             /pws/zycrt013-bds_object_key,

             /pws/zycrt013-bds_description,

             /pws/zycrt013-bds_doc_type,

             /pws/zycrt013-bds_creation.

      PERFORM update_grid

              USING

                /pws/zycrt013

              CHANGING

                it_rep_param[]

                v_rebuild_reports_tree

                v_saved.

      LEAVE TO SCREEN 0.

  ENDCASE.

ENDMODULE.

* << Fim da inclusão

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/MZYCR003O01

 

...

ENDMODULE.

MODULE load_data_0222 OUTPUT.

  IF it_key_priority[] IS INITIAL.

    PERFORM convert_key_priority_to_table

            USING

               /pws/zycre010-key_priority

            CHANGING

               it_key_priority[].

  ENDIF.

ENDMODULE.

* >> Início da inclusão:

MODULE status_0235 OUTPUT.

  PERFORM SET_SCREEN_0235

          USING

            v_op_mode.

ENDMODULE.

MODULE load_data_0235 OUTPUT.

  wa_bds_config-bds_classname   = /pws/zycrt013-bds_classname.

  wa_bds_config-bds_classtype   = /pws/zycrt013-bds_classtype.

  wa_bds_config-bds_object_key  = /pws/zycrt013-bds_object_key.

  wa_bds_config-bds_description = /pws/zycrt013-bds_description.

  wa_bds_config-bds_doc_type    = /pws/zycrt013-bds_doc_type.

  wa_bds_config-bds_creation    = /pws/zycrt013-bds_creation.

ENDMODULE.

* << Fim da inclusão

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/MZYCR003TOP

 

...

       END OF s_key_priority,

       t_key_priority TYPE STANDARD TABLE OF s_key_priority

                           WITH NON-UNIQUE KEY id.

TYPES: BEGIN OF s_report_sheets,

         file_id TYPE /pws/zycrt017-file_id,

         sheet   TYPE /pws/zycrt017-sheet,

       END OF s_report_sheets,

       t_report_sheets TYPE SORTED TABLE OF s_report_sheets

                       WITH NON-UNIQUE KEY file_id.

TYPES: t_sect_height TYPE STANDARD TABLE OF /pws/zycrt017.

* >> Início da inclusão:

TYPES: BEGIN OF s_bds_config,

         bds_classname   TYPE /pws/zycrt013-bds_classname,

         bds_classtype   TYPE /pws/zycrt013-bds_classtype,

         bds_object_key  TYPE /pws/zycrt013-bds_object_key,

         bds_description TYPE /pws/zycrt013-bds_description,

         bds_doc_type    TYPE /pws/zycrt013-bds_doc_type,

         bds_creation    TYPE /pws/zycrt013-bds_creation,

       END OF s_bds_config.

* << Fim da inclusão

CONSTANTS: c_show_mode TYPE t_operation_mode VALUE 'S',

           c_edit_mode TYPE t_operation_mode VALUE 'M'.

CONSTANTS: c_import_mode TYPE t_operation_mode VALUE 'I',

           c_export_mode TYPE t_operation_mode VALUE 'E'.

CONSTANTS: c_db_unmodified TYPE db_op VALUE ' ',

           c_db_delete     TYPE db_op VALUE 'D',

           c_db_insert     TYPE db_op VALUE 'I',

           c_db_update     TYPE db_op VALUE 'M'.

CONSTANTS: c_unmark_all(1) TYPE n VALUE '0'.

CONSTANTS: c_create_new           TYPE t_creation_mode VALUE 'N',

...

 

...

      it_rep_param TYPE t_rep_param,

      it_matrix    TYPE t_matrix.

DATA: it_matrix_selected TYPE t_matrix,

      wa_matrix_selected LIKE LINE OF it_matrix_selected[].

DATA: it_matrix_copied TYPE t_matrix,

      wa_matrix_copied LIKE LINE OF it_matrix_selected[].

DATA: it_reports_nodes TYPE t_nodes.

DATA: it_rep_fields TYPE t_rep_fields.

DATA: it_key_priority TYPE t_key_priority,

      wa_key_priority LIKE LINE OF it_key_priority.

* >> Início da inclusão:

DATA: wa_bds_config TYPE s_bds_config.

* << Fim da inclusão

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRI003

 

...

CONSTANTS: xl_op_create_sheet(1) TYPE x VALUE 2,

           xl_op_new_page(1)     TYPE x VALUE 1,

           xl_op_fill_field(1)   TYPE x VALUE 3.

CONSTANTS: ole_true  TYPE i VALUE -1,

           ole_false TYPE i VALUE 0.

TYPES: generation_option(2) TYPE x.

CONSTANTS:

  xl_print_after_generate TYPE generation_option VALUE 1,

  xl_prn_prev_after_generate TYPE generation_option VALUE 2,

  xl_dont_show_after_generate TYPE generation_option VALUE 3,

* >> Início da exclusão:

  xl_email_file_after_generate TYPE generation_option VALUE 4.

* << Fim da exclusão

* >> Início da inclusão:

  xl_email_file_after_generate TYPE generation_option VALUE 4,

  xl_upload_report_into_bds TYPE generation_option VALUE 5,

  xl_report_key TYPE generation_option VALUE 254,

  xl_process_key TYPE generation_option VALUE 255,

  xl_items_group TYPE generation_option VALUE 256,

  xl_custom_val_1 TYPE generation_option VALUE 257,

  xl_custom_val_2 TYPE generation_option VALUE 258,

  xl_custom_val_3 TYPE generation_option VALUE 259,

  xl_custom_val_4 TYPE generation_option VALUE 260,

  xl_custom_val_5 TYPE generation_option VALUE 261,

  xl_custom_val_6 TYPE generation_option VALUE 262,

  xl_custom_val_7 TYPE generation_option VALUE 263,

  xl_custom_val_8 TYPE generation_option VALUE 264,

  xl_custom_val_9 TYPE generation_option VALUE 265,

  xl_bds_keywords TYPE generation_option VALUE 266.

* << Fim da inclusão

TYPES: BEGIN OF s_generation_options,

         option        TYPE generation_option,

         argument(255) TYPE c,

       END OF s_generation_options.

TYPES: t_generation_options TYPE STANDARD TABLE OF s_generation_options.

TYPES: BEGIN OF s_rep_fields,

         field      TYPE /pws/zycrt015-field,

         curr_field TYPE /pws/zycrt015-curr_field,

         unit_field TYPE /pws/zycrt015-unit_field,

         edit_mask  TYPE /pws/zycrt015-edit_mask,

...

 

...

        posnl        TYPE /PWS/ZYCRE018-posnl,

        vbeln_va     TYPE /PWS/ZYCRE018-vbeln_va,

        aupos        TYPE /PWS/ZYCRE018-aupos,

        matnr        TYPE /PWS/ZYCRE018-matnr,

        vkorg_auft   TYPE /PWS/ZYCRE018-vkorg_auft,

        vtweg_auft   TYPE /PWS/ZYCRE018-vtweg_auft,

        nrseqtr      TYPE /PWS/ZYCET046-nrseqtr,

        nrrota_tr    TYPE /PWS/ZYCRE018-nrrota_tr,

       END OF s_format_codigo,

       t_format_codigo TYPE STANDARD TABLE OF s_format_codigo.

* >> Início da inclusão:

INCLUDE /pws/zycri005.

* << Fim da inclusão

FORM get_occupied_rows                                      "#EC CALLED

     USING

        p_string    TYPE c

        p_width     TYPE i

     CHANGING

        p_row_count TYPE i.

  DATA: string_length    TYPE i,

        string_index     TYPE i,

        current_char(1)  TYPE c,

        line_index       TYPE i,

...

 

...

    wa_excel_content-row = wa_matrix-row_position + displacement.

    wa_excel_content-column = wa_matrix-column_position.

    PERFORM write_field_to_char

            USING

               p_header

               wa_matrix-field

               p_t_rep_fields[]

            CHANGING

               wa_excel_content-value

               subrc.

* >> Início da inclusão: FORM FILL_HEADER_FIELDS

    IF subrc = 0.

* << Fim da inclusão

    APPEND wa_excel_content TO p_t_excel_content[].

* >> Início da inclusão: FORM FILL_HEADER_FIELDS

    ENDIF.

* << Fim da inclusão

  ENDLOOP.

ENDFORM.

FORM build_excel_report                                     "#EC CALLED

     USING

        p_file_name             TYPE c

        p_report_sheet_name     TYPE /pws/zycrl008

        p_report_sheet_password TYPE c

        p_t_excel_content       TYPE t_excel_content

        p_t_sections            TYPE t_sect_height

        p_t_options             TYPE t_generation_options.

  DATA: wa_excel_content LIKE LINE OF p_t_excel_content[],

        wa_options       LIKE LINE OF p_t_options[].

* >> Início da inclusão: FORM BUILD_EXCEL_REPORT

  DATA: wa_bds_upload_info TYPE s_bds_upload_info,

        it_bds_keywords    TYPE TABLE OF s_bds_keywords,

        bds_doc_id         TYPE bds_docid,

        bds_doc_ver_no     TYPE bds_dverno,

        bds_doc_var_id     TYPE bds_dvarid.

* << Fim da inclusão

  STATICS: application   TYPE ole2_object,

           workbook      TYPE ole2_object,

           report_sheet  TYPE ole2_object,

           page_breaks   TYPE ole2_object.

  PERFORM xl_create_and_initialize_excel

          CHANGING

             application.

  PERFORM xl_open_file

          USING

             application

...

 

...

            USING

              report_sheet.

  ENDIF.

  READ TABLE p_t_options TRANSPORTING NO FIELDS

       WITH KEY option = xl_email_file_after_generate.

  IF sy-subrc = 0.

    PERFORM xl_email_workbook

            USING

              application.

  ENDIF.

* >> Início da inclusão: FORM BUILD_EXCEL_REPORT

  PERFORM unpack_single_argument

        USING

          p_t_options[]

          xl_upload_report_into_bds

        CHANGING

          wa_bds_upload_info.

* << Fim da inclusão

* >> Início da exclusão: FORM BUILD_EXCEL_REPORT

  READ TABLE p_t_options TRANSPORTING NO FIELDS

       WITH KEY option = xl_dont_show_after_generate.

* << Fim da exclusão

* >> Início da inclusão: FORM BUILD_EXCEL_REPORT

  PERFORM check_argument_exists

          USING

            p_t_options[]

            xl_dont_show_after_generate.

* << Fim da inclusão

* >> Início da exclusão: FORM BUILD_EXCEL_REPORT

  IF sy-subrc <> 0.

* << Fim da exclusão

* >> Início da inclusão: FORM BUILD_EXCEL_REPORT

  IF sy-subrc <> 0 AND wa_bds_upload_info IS INITIAL.

* << Fim da inclusão

    PERFORM xl_show_report

            USING

               application.

  ELSE.

    CALL METHOD OF application 'QUIT'.

  ENDIF.

  FREE OBJECT: page_breaks   NO FLUSH,

               report_sheet  NO FLUSH,

               workbook      NO FLUSH.

  CALL METHOD cl_gui_cfw=>flush

       EXCEPTIONS

          cntl_system_error = 1

          cntl_error        = 2

          OTHERS            = 3.

  IF sy-subrc <> 0.

    CALL METHOD OF application 'QUIT'.

    FREE OBJECT application.

    MESSAGE e001(/pws/zycrm).

  ENDIF.

  FREE OBJECT application.

* >> Início da inclusão: FORM BUILD_EXCEL_REPORT

  IF NOT wa_bds_upload_info IS INITIAL.

    PERFORM unpack_table_argument

            USING

              p_t_options[]

              xl_bds_keywords

            CHANGING

              it_bds_keywords[].

    PERFORM bds_fill_description_mask

            USING

              wa_bds_upload_info-spras

              p_t_options[]

            CHANGING

              wa_bds_upload_info-description.

    PERFORM bds_upload_file

            USING

              wa_bds_upload_info

              it_bds_keywords[]

              p_file_name

            CHANGING

              bds_doc_id

              bds_doc_ver_no

              bds_doc_var_id.

    PERFORM check_argument_exists

            USING

               p_t_options[]

               xl_dont_show_after_generate.

    IF sy-subrc <> 0.

      PERFORM bds_show_file_in_navigator

              USING

                wa_bds_upload_info

                bds_doc_id

                bds_doc_ver_no

                bds_doc_var_id.

    ENDIF.

  ENDIF.

* << Fim da inclusão

ENDFORM.

FORM xl_create_and_initialize_excel                         "#EC CALLED

     CHANGING

        p_application TYPE ole2_object.

  CREATE OBJECT p_application 'EXCEL.APPLICATION'.

  IF sy-subrc <> 0.

    MESSAGE e027.

  ELSE.

    SET PROPERTY OF p_application 'WINDOWSTATE' = -4140 no flush.

    SET PROPERTY OF p_application 'INTERACTIVE' = ole_false no flush.

...

 

...

    ELSE.

      IF wa_rep_fields-edit_mask IS INITIAL.

        WRITE <fs_field> TO p_excel_field LEFT-JUSTIFIED.

      ELSE.

        WRITE <fs_field> TO p_excel_field LEFT-JUSTIFIED

                         USING EDIT MASK wa_rep_fields-edit_mask.

      ENDIF.

    ENDIF.

  ENDIF.

ENDFORM.

* >> Início da inclusão:

FORM pack_single_argument

     USING

         p_option   TYPE s_generation_options-option

         p_argument TYPE any

     CHANGING

         p_list     TYPE t_generation_options.

  DATA: wa_list LIKE LINE OF p_list.

  READ TABLE p_list[] INTO wa_list WITH KEY option = p_option

       TRANSPORTING argument.

  IF sy-subrc = 0.

    wa_list-argument = p_argument.

    MODIFY p_list[] FROM wa_list INDEX sy-tabix TRANSPORTING argument.

    sy-subrc = 8.

  ELSE.

    wa_list-option   = p_option.

    wa_list-argument = p_argument.

    APPEND wa_list TO p_list[].

    sy-subrc = 0.

  ENDIF.

ENDFORM.

FORM unpack_single_argument

     USING

         p_list     TYPE t_generation_options

         p_option   TYPE s_generation_options-option

     CHANGING

         p_argument TYPE any.

  DATA: wa_list LIKE LINE OF p_list.

  READ TABLE p_list[] INTO wa_list WITH KEY option = p_option

       TRANSPORTING argument.

  IF sy-subrc = 0.

    p_argument = wa_list-argument.

    sy-subrc = 0.

  ELSE.

    CLEAR p_argument.

    sy-subrc = 4.

  ENDIF.

ENDFORM.

FORM unpack_table_argument

     USING

         p_list     TYPE t_generation_options

         p_option   TYPE s_generation_options-option

     CHANGING

         p_t_argument TYPE table.

  DATA: wa_list LIKE LINE OF p_list.

  CLEAR: p_t_argument[].

  LOOP AT p_list[] INTO wa_list WHERE option = p_option.

    APPEND wa_list-argument TO p_t_argument[].

  ENDLOOP.

ENDFORM.

FORM check_argument_exists

     USING

         p_list   TYPE t_generation_options

         p_option TYPE s_generation_options-option.

  READ TABLE p_list[] WITH KEY option = p_option TRANSPORTING NO FIELDS.

ENDFORM.

* << Fim da inclusão

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRI005

 

Criar o include /PWS/ZYCRI005

Classe de desenvolvimento: /PWS/ZYCR

Descrição: Rotinas e declarações comuns ao arquivamento no BDS

Categoria: I-Programa include

Status: K-Programa de clientes produtivo

 

Código-fonte:

 

*----------------------------------------------------------------------*

*   INCLUDE /PWS/ZYCRI005                                              *

*----------------------------------------------------------------------*

 

*------------------------------------------------------------------

* Lista de valores de substituição na máscara

*------------------------------------------------------------------

* Símbolo   Significado                  Observação

*------------------------------------------------------------------

* %%        '%'

* %d ou %D  Data atual                   sy-datlo (AAAAMMDD)

* %t ou %T  Hora atual                   sy-timlo (HHMMSS)

* %r ou %R  Chave do report              /PWS/ZYCRT010-REPORT_KEY

* %u ou %U  Usuário SAP                  sy-uname

* %l ou %L  Idioma utilizado na geração  Depende do report

* %k ou %K  Chave do processo            Depende do report

* %g ou %G  Grupo de itens               Depende do report

* %1        Valor personalizável 1       Depende do report

* %2        Valor personalizável 2       Depende do report

* %3        Valor personalizável 3       Depende do report

* %4        Valor personalizável 4       Depende do report

* %5        Valor personalizável 5       Depende do report

* %6        Valor personalizável 6       Depende do report

* %7        Valor personalizável 7       Depende do report

* %8        Valor personalizável 8       Depende do report

* %9        Valor personalizável 9       Depende do report

*------------------------------------------------------------------

 

TYPE-POOLS: sbdst.

 

TYPES: bds_file_creation_mode(1) TYPE c.

 

TYPES: BEGIN OF s_bds_upload_info,

         classname     TYPE /pws/zycrt013-bds_classname,

         classtype     TYPE /pws/zycrt013-bds_classtype,

         object_key    TYPE /pws/zycrt013-bds_object_key,

         description   TYPE /pws/zycrt013-bds_description,

         document_type TYPE /pws/zycrt013-bds_doc_type,

         creation_mode TYPE /pws/zycrt013-bds_creation,

         spras         TYPE lang,

       END OF s_bds_upload_info.

 

TYPES: BEGIN OF s_bds_keywords,

         keyword_1 TYPE bapibds01-prop_value,

         keyword_2 TYPE bapibds01-prop_value,

         keyword_3 TYPE bapibds01-prop_value,

       END OF s_bds_keywords,

       t_bds_keywords TYPE STANDARD TABLE OF s_bds_keywords.

 

CONSTANTS:

    bds_create_new_document TYPE /pws/zycrl023 VALUE 'N',

    bds_create_new_version  TYPE /pws/zycrl023 VALUE 'V',

    bds_update_document     TYPE /pws/zycrl023 VALUE 'A'.

 

 

* --------------------------------------------------------------------

* Form bds_upload_file

* --------------------------------------------------------------------

* Objetivo: Carregar um arquivo no BDS

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_bds_upload_info  Parâmetros de carregamento

*     p_file_name        Caminho do arquivo a ser carregado

* <-- p_doc_id           ID do arquivo

*     p_doc_ver_no       Número da versão

*     p_doc_var_id       Número da variante

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data       Descrição

* --------------------------------------------------------------------

* 391073   12/09/07   Codificação inicial

* --------------------------------------------------------------------

FORM bds_upload_file                                        "#EC CALLED

     USING

         p_bds_upload_info TYPE s_bds_upload_info

         p_t_bds_keywords  TYPE t_bds_keywords

         p_file_name       TYPE c

     CHANGING

         p_doc_id          TYPE bds_docid

         p_doc_ver_no      TYPE bds_dverno

         p_doc_var_id      TYPE bds_dvarid.

 

  DATA: it_files TYPE sbdst_files,

        wa_files LIKE LINE OF it_files[].

 

  DATA: it_signature TYPE sbdst_signature,

        wa_signature LIKE LINE OF it_signature[].

 

  DATA: wa_bds_keywords LIKE LINE OF p_t_bds_keywords[].

 

  DATA: doc_type TYPE toadv-doc_type.

 

 

* As assinaturas se referem a um único arquivo

  wa_signature-doc_count  = '1'.

 

* Preenche a tabela de assinatura do arquivo: descrição e tipo

  wa_signature-prop_name  = 'DESCRIPTION'.

  wa_signature-prop_value = p_bds_upload_info-description.

 

  APPEND wa_signature TO it_signature[].

 

 

  wa_signature-prop_name  = 'LANGUAGE'.

  wa_signature-prop_value = p_bds_upload_info-spras.

 

  APPEND wa_signature TO it_signature[].

 

 

  wa_signature-prop_name  = 'BDS_DOCUMENTTYPE'.

  wa_signature-prop_value = p_bds_upload_info-document_type.

 

  APPEND wa_signature TO it_signature[].

 

 

  SELECT SINGLE doc_type

      FROM toadv

      INTO doc_type

      WHERE ar_object = p_bds_upload_info-document_type.

 

  IF sy-subrc = 0.

 

    wa_signature-prop_name  = 'BDS_DOCUMENTCLASS'.

    wa_signature-prop_value = doc_type.

 

    APPEND wa_signature TO it_signature[].

 

  ENDIF.

 

  LOOP AT p_t_bds_keywords[] INTO wa_bds_keywords.

 

    IF NOT wa_bds_keywords-keyword_1 IS INITIAL.

 

      wa_signature-prop_name  = 'BDS_KEYWORD'.

      wa_signature-prop_value = wa_bds_keywords-keyword_1.

 

 

      APPEND wa_signature TO it_signature[].

 

    ENDIF.

 

    IF NOT wa_bds_keywords-keyword_2 IS INITIAL.

 

      wa_signature-prop_name  = 'BDS_KEYWORD'.

      wa_signature-prop_value = wa_bds_keywords-keyword_2.

 

      APPEND wa_signature TO it_signature[].

 

    ENDIF.

 

    IF NOT wa_bds_keywords-keyword_3 IS INITIAL.

 

      wa_signature-prop_name  = 'BDS_KEYWORD'.

      wa_signature-prop_value = wa_bds_keywords-keyword_3.

 

      APPEND wa_signature TO it_signature[].

 

    ENDIF.

 

  ENDLOOP.

 

* Preenche a tabela de arquivos: caminho do arquivo

  wa_files-doc_count = '1'.

 

  PERFORM split_file_path

          USING

            p_file_name

          CHANGING

            wa_files-filename

            wa_files-directory.

 

  SELECT SINGLE mimetype

      FROM toadd

      INTO wa_files-mimetype

      WHERE doc_type = doc_type.

 

  APPEND wa_files TO it_files.

 

  CASE p_bds_upload_info-creation_mode.

 

    WHEN bds_create_new_document.

 

      PERFORM bds_create_document

              USING

                p_bds_upload_info-classname

                p_bds_upload_info-classtype

                p_bds_upload_info-object_key

                it_files[]

                it_signature[]

              CHANGING

                p_doc_id

                p_doc_ver_no

                p_doc_var_id.

 

 

    WHEN bds_create_new_version.

 

      PERFORM bds_create_version

              USING

                p_bds_upload_info-classname

                p_bds_upload_info-classtype

                p_bds_upload_info-object_key

                it_files[]

                it_signature[]

              CHANGING

                p_doc_id

                p_doc_ver_no

                p_doc_var_id.

 

 

    WHEN bds_update_document.

 

      PERFORM bds_update_document

              USING

                p_bds_upload_info-classname

                p_bds_upload_info-classtype

                p_bds_upload_info-object_key

                it_files[]

                it_signature[]

              CHANGING

                p_doc_id

                p_doc_ver_no

                p_doc_var_id.

 

 

  ENDCASE.

 

 

ENDFORM.                    " bds_upload_file

 

* --------------------------------------------------------------------

* Form bds_query_newest_document

* --------------------------------------------------------------------

* Objetivo: Buscar a versão do documento mais recente

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_classname           Nome da classe de objetos

*     p_classtype           Tipo da classe de objetos

*     p_object_key          Chave do objeto

*     value(p_t_signature)  Tabela de assinatura do arquivo

* <-- p_doc_id              ID do objeto

*     p_doc_ver_no          Número da versão

*     p_doc_var_id          Número da variante

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data       Descrição

* --------------------------------------------------------------------

* 391073   12/09/07   Codificação inicial

* --------------------------------------------------------------------

FORM bds_query_newest_document                              "#EC CALLED

     USING

         p_classname          TYPE sbdst_classname

         p_classtype          TYPE sbdst_classtype

         p_object_key         TYPE sbdst_object_key

         value(p_t_signature) TYPE sbdst_signature

     CHANGING

         p_doc_id             TYPE bds_docid

         p_doc_ver_no         TYPE bds_dverno

         p_doc_var_id         TYPE bds_dvarid.

 

  DATA: wa_signature LIKE LINE OF p_t_signature[].

 

 

  DELETE p_t_signature[] WHERE prop_name = 'BDS_KEYWORD'.

 

 

  CALL METHOD cl_bds_document_set=>get_info_newest_only

       EXPORTING

         classname       = p_classname

         classtype       = p_classtype

         object_key      = p_object_key

       CHANGING

         signature       = p_t_signature

       EXCEPTIONS

         nothing_found   = 3.

 

  CASE sy-subrc.

 

    WHEN 0.

 

      READ TABLE p_t_signature[] INTO wa_signature

           INDEX 1

           TRANSPORTING doc_id

                        doc_ver_no

                        doc_var_id.

 

      IF sy-subrc = 0.

 

        p_doc_id     = wa_signature-doc_id.

        p_doc_ver_no = wa_signature-doc_ver_no.

        p_doc_var_id = wa_signature-doc_var_id.

 

        sy-subrc = 0.

 

      ELSE.

 

        sy-subrc = 4.

 

      ENDIF.

 

 

    WHEN 3.

 

      sy-subrc = 4.

 

 

    WHEN OTHERS.

 

      sy-subrc = 8.

 

 

  ENDCASE.

 

 

ENDFORM.                    " bds_query_newest_document

 

* --------------------------------------------------------------------

* Form bds_create_document

* --------------------------------------------------------------------

* Objetivo: Cria um novo documento no BDS

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_classname           Nome da classe de objetos

*     p_classtype           Tipo da classe de objetos

*     value(p_object_key)   Chave de objeto

*     value(p_t_files)      Tabela de informações dos arquivos

*     value(p_t_signature)  Tabela de informações dos objetos

* <-- p_doc_id              ID do novo objeto

*     p_doc_ver_no          Número da versão do novo objeto

*     p_doc_var_id          Número da variante do novo objeto

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data       Descrição

* --------------------------------------------------------------------

* 391073   12/09/07   Codificação inicial

* --------------------------------------------------------------------

FORM bds_create_document                                    "#EC CALLED

     USING

         p_classname          TYPE sbdst_classname

         p_classtype          TYPE sbdst_classtype

         value(p_object_key)  TYPE sbdst_object_key

         value(p_t_files)     TYPE sbdst_files

         value(p_t_signature) TYPE sbdst_signature

     CHANGING

         p_doc_id             TYPE bds_docid

         p_doc_ver_no         TYPE bds_dverno

         p_doc_var_id         TYPE bds_dvarid.

 

  DATA: wa_signature LIKE LINE OF p_t_signature[].

 

 

  CALL METHOD cl_bds_document_set=>create_with_files

       EXPORTING

         classname       = p_classname

         classtype       = p_classtype

       CHANGING

         files           = p_t_files[]

         object_key      = p_object_key

         signature       = p_t_signature[].

 

  IF sy-subrc = 0.

 

    READ TABLE p_t_signature[] INTO wa_signature

         INDEX 1

         TRANSPORTING doc_id

                      doc_ver_no

                      doc_var_id.

 

    IF sy-subrc = 0.

 

      p_doc_id     = wa_signature-doc_id.

      p_doc_ver_no = wa_signature-doc_ver_no.

      p_doc_var_id = wa_signature-doc_var_id.

 

    ENDIF.

 

  ELSE.

 

    MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

            WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

 

  ENDIF.

 

 

ENDFORM.                    " bds_create_document

 

* --------------------------------------------------------------------

* Form bds_create_version

* --------------------------------------------------------------------

* Objetivo: Cria uma nova versão de um documento, se já existir, ou

*           cria um novo documento.

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_classname       Nome da classe de objetos

*     p_classtype       Tipo da classe de objetos

*     p_object_key      Chave do objeto

*     value(p_t_files)  Tabela de informações do arquivo

*     p_t_signature     Tabela de informações do documento

* <-- p_doc_id          ID do objeto

*     p_doc_ver_no      Número da versão do objeto

*     p_doc_var_id      Número da variante do objeto

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data       Descrição

* --------------------------------------------------------------------

* 391073   12/09/07   Codificação inicial

* --------------------------------------------------------------------

FORM bds_create_version                                     "#EC CALLED

     USING

         p_classname      TYPE sbdst_classname

         p_classtype      TYPE sbdst_classtype

         p_object_key     TYPE sbdst_object_key

         value(p_t_files) TYPE sbdst_files

         p_t_signature    TYPE sbdst_signature

     CHANGING

         p_doc_id         TYPE bds_docid

         p_doc_ver_no     TYPE bds_dverno

         p_doc_var_id     TYPE bds_dvarid.

 

  DATA: previous_doc_id     TYPE bds_docid,

        previous_doc_ver_no TYPE bds_dverno,

        previous_doc_var_id TYPE bds_dvarid.

 

  DATA: wa_signature LIKE LINE OF p_t_signature.

 

  DATA: it_properties TYPE sbdst_properties,

        wa_properties LIKE LINE OF it_properties[].

 

 

  PERFORM bds_query_newest_document

          USING

            p_classname

            p_classtype

            p_object_key

            p_t_signature

          CHANGING

            previous_doc_id

            previous_doc_ver_no

            previous_doc_var_id.

 

  CASE sy-subrc.

 

    WHEN 0.

 

      LOOP AT p_t_signature INTO wa_signature

        WHERE prop_name = 'BDS_KEYWORD'

           OR prop_name = 'BDS_DOCUMENTCLASS'

           OR prop_name = 'DESCRIPTION'

           OR prop_name = 'LANGUAGE'.

 

        wa_properties-prop_name  = wa_signature-prop_name.

        wa_properties-prop_value = wa_signature-prop_value.

 

        APPEND wa_properties TO it_properties[].

 

      ENDLOOP.

 

      CALL METHOD cl_bds_document_set=>create_version_with_files

           EXPORTING

             classname       = p_classname

             classtype       = p_classtype

             object_key      = p_object_key

             doc_id          = previous_doc_id

             doc_ver_no      = previous_doc_ver_no

             doc_var_id      = previous_doc_var_id

           IMPORTING

             new_doc_ver_no  = p_doc_ver_no

           CHANGING

             files           = p_t_files[]

             properties      = it_properties[]

           EXCEPTIONS

             error_kpro      = 1

             internal_error  = 2

             nothing_found   = 3

             not_authorized  = 4

             not_allowed     = 5

             parameter_error = 6

             OTHERS          = 7.

 

      IF sy-subrc = 0.

 

        p_doc_id     = previous_doc_id.

 

        p_doc_var_id = previous_doc_var_id.

 

      ELSE.

 

        MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

                   WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

 

      ENDIF.

 

 

    WHEN 4.

 

      PERFORM bds_create_document

              USING

                p_classname

                p_classtype

                p_object_key

                p_t_files[]

                p_t_signature[]

              CHANGING

                p_doc_id

                p_doc_ver_no

                p_doc_var_id.

 

 

  ENDCASE.

 

 

ENDFORM.                    " bds_create_version

 

* --------------------------------------------------------------------

* Form bds_update_document

* --------------------------------------------------------------------

* Objetivo: Atauliza um arquivo, se já existir, ou cria um novo

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_classname           Nome da classe de objetos

*     p_classtype           Tipo da classe de objetos

*     p_object_key          Chave do objeto

*     value(p_t_files)      Tabela de informações do arquivo

*     value(p_t_signature)  Tabela de informações do documento

* <-- p_doc_id              ID do objeto

*     p_doc_ver_no          Número da versão do objeto

*     p_doc_var_id          Número da variante do objeto

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data       Descrição

* --------------------------------------------------------------------

* 391073   12/09/07   Codificação inicial

* --------------------------------------------------------------------

FORM bds_update_document                                    "#EC CALLED

     USING

         p_classname          TYPE sbdst_classname

         p_classtype          TYPE sbdst_classtype

         p_object_key         TYPE sbdst_object_key

         value(p_t_files)     TYPE sbdst_files

         value(p_t_signature) TYPE sbdst_signature

     CHANGING

         p_doc_id             TYPE bds_docid

         p_doc_ver_no         TYPE bds_dverno

         p_doc_var_id         TYPE bds_dvarid.

 

  DATA: previous_doc_id     TYPE bds_docid,

        previous_doc_ver_no TYPE bds_dverno,

        previous_doc_var_id TYPE bds_dvarid.

 

  DATA: wa_signature LIKE LINE OF p_t_signature.

 

 

  PERFORM bds_query_newest_document

          USING

             p_classname

             p_classtype

             p_object_key

             p_t_signature

          CHANGING

             previous_doc_id

             previous_doc_ver_no

             previous_doc_var_id.

 

  CASE sy-subrc.

 

    WHEN 0.

 

      CALL METHOD cl_bds_document_set=>update_with_files

           EXPORTING

             classname       = p_classname

             classtype       = p_classtype

             object_key      = p_object_key

             doc_id          = previous_doc_id

             doc_ver_no      = previous_doc_ver_no

             doc_var_id      = previous_doc_var_id

             x_force_update  = 'X'

           CHANGING

             files           = p_t_files[]

             signature       = p_t_signature[].

 

      IF sy-subrc = 0.

 

        READ TABLE p_t_signature[] INTO wa_signature

             INDEX 1

             TRANSPORTING doc_id

                          doc_ver_no

                          doc_var_id.

 

        IF sy-subrc = 0.

 

          p_doc_id     = wa_signature-doc_id.

          p_doc_ver_no = wa_signature-doc_ver_no.

          p_doc_var_id = wa_signature-doc_var_id.

 

        ENDIF.

 

      ELSE.

 

        MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

                   WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

 

      ENDIF.

 

 

    WHEN 4.

 

      PERFORM bds_create_document

           USING

             p_classname

             p_classtype

             p_object_key

             p_t_files[]

             p_t_signature[]

           CHANGING

             p_doc_id

             p_doc_ver_no

             p_doc_var_id.

 

 

  ENDCASE.

 

 

ENDFORM.                    " bds_update_document

 

* --------------------------------------------------------------------

* Form bds_show_file_in_navigator

* --------------------------------------------------------------------

* Objetivo: Exibir um documento no BDN

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_bds_upload_info  Parâmetros do documento

*     p_doc_id           ID do Documento

*     p_doc_ver_no       Número da versão do documento

*     p_doc_var_id       Número da variante do documento

* <-- <nenhum>

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data       Descrição

* --------------------------------------------------------------------

* 391073   12/09/07   Codificação inicial

* --------------------------------------------------------------------

FORM bds_show_file_in_navigator                             "#EC CALLED

     USING

         p_bds_upload_info TYPE s_bds_upload_info

         p_doc_id          TYPE bds_docid

         p_doc_ver_no      TYPE bds_dverno

         p_doc_var_id      TYPE bds_dvarid.

 

  DATA: it_signature TYPE sbdst_signature,

        wa_signature LIKE LINE OF it_signature[].

 

 

  wa_signature-doc_count  = 1.

  wa_signature-doc_id     = p_doc_id.

  wa_signature-doc_ver_no = p_doc_ver_no.

  wa_signature-doc_var_id = p_doc_var_id.

 

  APPEND wa_signature TO it_signature[].

 

 

  CALL METHOD cl_bds_document_set=>call_navigator

       EXPORTING

         classname          = p_bds_upload_info-classname

         classtype          = p_bds_upload_info-classtype

         display_single_doc = 'X'

       CHANGING

         objkey             = p_bds_upload_info-object_key

         signature          = it_signature[].

 

 

ENDFORM.                    " bds_show_file_in_navigator

 

* --------------------------------------------------------------------

* Form bds_fill_description_mask

* --------------------------------------------------------------------

* Objetivo: Preencher o campo de descrição de documento

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_lang         Idioma do documento

*     p_t_arguments  Lista de opções de geração

* <-- p_description  Descrição do documento

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data       Descrição

* --------------------------------------------------------------------

* 391073   12/09/07   Codificação inicial

* --------------------------------------------------------------------

FORM bds_fill_description_mask                              "#EC CALLED

     USING

         p_lang        TYPE lang

         p_t_arguments TYPE t_generation_options

     CHANGING

         p_description TYPE /pws/zycrt013-bds_description.

 

  DATA: report_key   TYPE s_generation_options-argument,

        process_key  TYPE s_generation_options-argument,

        items_group  TYPE s_generation_options-argument,

        custom_var_1 TYPE s_generation_options-argument,

        custom_var_2 TYPE s_generation_options-argument,

        custom_var_3 TYPE s_generation_options-argument,

        custom_var_4 TYPE s_generation_options-argument,

        custom_var_5 TYPE s_generation_options-argument,

        custom_var_6 TYPE s_generation_options-argument,

        custom_var_7 TYPE s_generation_options-argument,

        custom_var_8 TYPE s_generation_options-argument,

        custom_var_9 TYPE s_generation_options-argument.

 

 

  PERFORM unpack_single_argument

          USING

            p_t_arguments[]

            xl_report_key

          CHANGING

            report_key.

 

  PERFORM unpack_single_argument

          USING

            p_t_arguments[]

            xl_process_key

          CHANGING

            process_key.

 

  PERFORM unpack_single_argument

          USING

            p_t_arguments[]

            xl_items_group

          CHANGING

            items_group.

 

  PERFORM unpack_single_argument

          USING

            p_t_arguments[]

            xl_custom_val_1

          CHANGING

            custom_var_1.

 

  PERFORM unpack_single_argument

          USING

            p_t_arguments[]

            xl_custom_val_2

          CHANGING

            custom_var_2.

 

  PERFORM unpack_single_argument

          USING

            p_t_arguments[]

            xl_custom_val_3

          CHANGING

            custom_var_3.

 

  PERFORM unpack_single_argument

          USING

            p_t_arguments[]

            xl_custom_val_4

          CHANGING

            custom_var_4.

 

  PERFORM unpack_single_argument

          USING

            p_t_arguments[]

            xl_custom_val_5

          CHANGING

            custom_var_5.

 

  PERFORM unpack_single_argument

          USING

            p_t_arguments[]

            xl_custom_val_6

          CHANGING

            custom_var_6.

 

  PERFORM unpack_single_argument

          USING

            p_t_arguments[]

            xl_custom_val_7

          CHANGING

            custom_var_7.

 

  PERFORM unpack_single_argument

          USING

            p_t_arguments[]

            xl_custom_val_8

          CHANGING

            custom_var_8.

 

  PERFORM unpack_single_argument

          USING

            p_t_arguments[]

            xl_custom_val_9

          CHANGING

            custom_var_9.

 

  PERFORM bds_replace_descr_symbols

          USING

             p_lang

             report_key

             process_key

             items_group

             custom_var_1

             custom_var_2

             custom_var_3

             custom_var_4

             custom_var_5

             custom_var_6

             custom_var_7

             custom_var_8

             custom_var_9

          CHANGING

             p_description.

 

 

ENDFORM.                    " bds_fill_description_mask

 

* --------------------------------------------------------------------

* Form bds_replace_descr_symbols

* --------------------------------------------------------------------

* Objetivo: Substituir os símbolos na máscara de descrição de

*           documento

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_lang          Idioma do report

*     p_report_key    Chave do report

*     p_process_key   Chave do processo

*     p_custom_var_1  Variável personálizavel 1

*     p_custom_var_2  Variável personálizavel 2

*     p_custom_var_3  Variável personálizavel 3

*     p_custom_var_4  Variável personálizavel 4

*     p_custom_var_5  Variável personálizavel 5

*     p_custom_var_6  Variável personálizavel 6

*     p_custom_var_7  Variável personálizavel 7

*     p_custom_var_8  Variável personálizavel 8

*     p_custom_var_9  Variável personálizavel 9

* <-- p_mask          Descrição do documento

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data       Descrição

* --------------------------------------------------------------------

* 391073   12/09/07   Codificação inicial

* --------------------------------------------------------------------

FORM bds_replace_descr_symbols                              "#EC CALLED

     USING

         p_lang         TYPE lang

         p_report_key   TYPE c

         p_process_key  TYPE c

         p_items_group  TYPE c

         p_custom_var_1 TYPE c

         p_custom_var_2 TYPE c

         p_custom_var_3 TYPE c

         p_custom_var_4 TYPE c

         p_custom_var_5 TYPE c

         p_custom_var_6 TYPE c

         p_custom_var_7 TYPE c

         p_custom_var_8 TYPE c

         p_custom_var_9 TYPE c

     CHANGING

         p_mask TYPE /pws/zycrt013-bds_description.

 

  DATA: len    TYPE i,      " nº caracteres na máscara

        pos    TYPE i,      " posição atualmente lida

        cch(1) TYPE c,      " caractere atual

        sym    TYPE xfeld.  " flag indicativo de símbolo lido

 

  DATA: str    LIKE p_mask, " máscara preenchida

        csz    TYPE i.      " tamanho da máscara já utilizado

 

 

  len = numofchar( p_mask ).

 

  DO len TIMES.

 

    pos = sy-index - 1.

 

    cch = p_mask+pos(1).

 

 

    IF cch = '%' AND sym IS INITIAL. " Símbolo

 

      sym = 'X'.

 

    ELSE.

 

      IF sym = 'X'.

 

        CASE cch.

 

          WHEN '%'.

 

            MOVE '%' TO str+csz.

 

            csz = csz + 1.

 

 

          WHEN 'd' OR 'D'.

 

            MOVE sy-datlo TO str+csz.

 

            csz = csz + NUMOFCHAR( sy-datlo ).

 

 

          WHEN 't' OR 'T'.

 

            MOVE sy-timlo TO str+csz.

 

            csz = csz + NUMOFCHAR( sy-timlo ).

 

 

          WHEN 'r' OR 'R'.

 

            MOVE p_report_key TO str+csz.

 

            csz = csz + NUMOFCHAR( p_report_key ).

 

 

          WHEN 'u' OR 'U'.

 

            MOVE sy-uname TO str+csz.

 

            csz = csz + NUMOFCHAR( sy-uname ).

 

 

          WHEN 'g' OR 'G'.

 

            MOVE p_items_group TO str+csz.

 

            csz = csz + NUMOFCHAR( p_items_group ).

 

 

          WHEN 'l' OR 'L'.

 

            WRITE p_lang TO str+csz.

 

            csz = csz + NUMOFCHAR( str+csz ).

 

 

          WHEN 'k' OR 'K'.

 

            MOVE p_process_key TO str+csz.

 

            csz = csz + NUMOFCHAR( p_process_key ).

 

 

          WHEN '1'.

 

            MOVE p_custom_var_1 TO str+csz.

 

            csz = csz + NUMOFCHAR( p_custom_var_1 ).

 

 

          WHEN '2'.

 

            MOVE p_custom_var_2 TO str+csz.

 

            csz = csz + NUMOFCHAR( p_custom_var_2 ).

 

 

          WHEN '3'.

 

            MOVE p_custom_var_3 TO str+csz.

 

            csz = csz + NUMOFCHAR( p_custom_var_3 ).

 

 

          WHEN '4'.

 

            MOVE p_custom_var_4 TO str+csz.

 

            csz = csz + NUMOFCHAR( p_custom_var_4 ).

 

 

          WHEN '5'.

 

            MOVE p_custom_var_5 TO str+csz.

 

            csz = csz + NUMOFCHAR( p_custom_var_5 ).

 

 

          WHEN '6'.

 

            MOVE p_custom_var_6 TO str+csz.

 

            csz = csz + NUMOFCHAR( p_custom_var_6 ).

 

 

          WHEN '7'.

 

            MOVE p_custom_var_7 TO str+csz.

 

            csz = csz + NUMOFCHAR( p_custom_var_7 ).

 

 

          WHEN '8'.

 

            MOVE p_custom_var_8 TO str+csz.

 

            csz = csz + NUMOFCHAR( p_custom_var_8 ).

 

 

          WHEN '9'.

 

            MOVE p_custom_var_9 TO str+csz.

 

            csz = csz + NUMOFCHAR( p_custom_var_8 ).

 

 

          WHEN OTHERS.

 

            MOVE '%' TO str+csz.

 

            csz = csz + 1.

 

            MOVE cch TO str+csz.

 

            csz = csz + 1.

 

 

        ENDCASE.

 

        CLEAR sym.

 

      ELSE.

 

        MOVE cch TO str+csz.

 

        csz = csz + 1.

 

      ENDIF.

 

    ENDIF.

 

  ENDDO.

 

  p_mask = str.

 

 

ENDFORM.                    " bds_replace_descr_symbols

 

* --------------------------------------------------------------------

* Form split_file_path

* --------------------------------------------------------------------

* Objetivo: Dividir o caminho completo para um arquivo em nome do

*           arquivo e diretório.

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> value(p_full_file_path)  Caminho completo

* <-- p_file_name              Só o nome do arquivo

*     p_folder                 Só o nome do diretório

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data       Descrição

* --------------------------------------------------------------------

* 391073   12/09/07   Codificação inicial

* --------------------------------------------------------------------

FORM split_file_path                                        "#EC CALLED

     USING

         value(p_full_file_path) TYPE c

     CHANGING

         p_file_name             TYPE c

         p_folder                TYPE c.

 

 

  CALL FUNCTION 'STRING_REVERSE'

       EXPORTING

            string  = p_full_file_path

            lang    = sy-langu

       IMPORTING

            rstring = p_full_file_path.

 

  SPLIT p_full_file_path AT '\' INTO p_file_name p_folder.

 

  CALL FUNCTION 'STRING_REVERSE'

       EXPORTING

            string  = p_file_name

            lang    = sy-langu

       IMPORTING

            rstring = p_file_name.

 

  CALL FUNCTION 'STRING_REVERSE'

       EXPORTING

            string  = p_folder

            lang    = sy-langu

       IMPORTING

            rstring = p_folder.

 

 

ENDFORM.                    " split_file_path

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR003

 

...

DATA: wa_gen_param     TYPE /pws/zycrt012,

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq OBLIGATORY

                                              MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

SELECTION-SCREEN END OF BLOCK b6.

SELECTION-SCREEN BEGIN OF BLOCK b4 WITH FRAME TITLE text-005.

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'

                                     MATCHCODE OBJECT h_unit_volume.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura/Cargo 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    IF NOT wa_rep_param-bds_classname IS INITIAL.

      wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

      wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

      wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

      wa_bds_upload_info-spras         = v_langu.

      wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

      wa_bds_upload_info-description   = wa_rep_param-bds_description.

      wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR010

 

...

DATA: wa_gen_param     TYPE /pws/zycrt012,

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq         OBLIGATORY

                                                      MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

SELECTION-SCREEN END OF LINE.

SELECTION-SCREEN END OF BLOCK b6.

SELECTION-SCREEN BEGIN OF BLOCK b4 WITH FRAME TITLE text-005.

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    IF NOT wa_rep_param-bds_classname IS INITIAL.

      wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

      wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

      wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

      wa_bds_upload_info-spras         = v_langu.

      wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

      wa_bds_upload_info-description   = wa_rep_param-bds_description.

      wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR011

 

...

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_waersa TYPE /pws/zycbt007-waersa.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq OBLIGATORY

                                              MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b7 WITH FRAME TITLE text-010.

PARAMETERS: p_agrup TYPE /pws/zycrl025 AS CHECKBOX DEFAULT 'X'.

SELECTION-SCREEN END OF BLOCK b7.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    IF NOT wa_rep_param-bds_classname IS INITIAL.

      wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

      wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

      wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

      wa_bds_upload_info-spras         = v_langu.

      wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

      wa_bds_upload_info-description   = wa_rep_param-bds_description.

      wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR013

 

...

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_waersa TYPE /pws/zycbt007-waersa.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq OBLIGATORY

                                              MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b7 WITH FRAME TITLE text-010.

PARAMETERS: p_agrup TYPE /pws/zycrl025 AS CHECKBOX DEFAULT 'X'.

SELECTION-SCREEN END OF BLOCK b7.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    IF NOT wa_rep_param-bds_classname IS INITIAL.

      wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

      wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

      wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

      wa_bds_upload_info-spras         = v_langu.

      wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

      wa_bds_upload_info-description   = wa_rep_param-bds_description.

      wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR014

 

...

DATA: wa_gen_param     TYPE /pws/zycrt012,

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq OBLIGATORY

                                              MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

SELECTION-SCREEN END OF LINE.

SELECTION-SCREEN END OF BLOCK b6.

SELECTION-SCREEN BEGIN OF BLOCK b4 WITH FRAME TITLE text-005.

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    IF NOT wa_rep_param-bds_classname IS INITIAL.

      wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

      wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

      wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

      wa_bds_upload_info-spras         = v_langu.

      wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

      wa_bds_upload_info-description   = wa_rep_param-bds_description.

      wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR015

 

...

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_waersa TYPE /pws/zycbt007-waersa.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq OBLIGATORY

                                              MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

SELECTION-SCREEN END OF LINE.

SELECTION-SCREEN END OF BLOCK b6.

SELECTION-SCREEN BEGIN OF BLOCK b4 WITH FRAME TITLE text-005.

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    IF NOT wa_rep_param-bds_classname IS INITIAL.

      wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

      wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

      wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

      wa_bds_upload_info-spras         = v_langu.

      wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

      wa_bds_upload_info-description   = wa_rep_param-bds_description.

      wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR016

 

...

DATA: wa_gen_param     TYPE /pws/zycrt012,

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq OBLIGATORY

                                              MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

SELECTION-SCREEN END OF BLOCK b6.

SELECTION-SCREEN BEGIN OF BLOCK b4 WITH FRAME TITLE text-005.

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'

                                     MATCHCODE OBJECT h_unit_volume.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura/Cargo 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    IF NOT wa_rep_param-bds_classname IS INITIAL.

      wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

      wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

      wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

      wa_bds_upload_info-spras         = v_langu.

      wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

      wa_bds_upload_info-description   = wa_rep_param-bds_description.

      wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR017

 

...

DATA: wa_gen_param     TYPE /pws/zycrt012,

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq OBLIGATORY

                                              MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

SELECTION-SCREEN END OF BLOCK b6.

SELECTION-SCREEN BEGIN OF BLOCK b4 WITH FRAME TITLE text-005.

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'

                                     MATCHCODE OBJECT h_unit_volume.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura/Cargo 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    IF NOT wa_rep_param-bds_classname IS INITIAL.

      wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

      wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

      wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

      wa_bds_upload_info-spras         = v_langu.

      wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

      wa_bds_upload_info-description   = wa_rep_param-bds_description.

      wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR018

 

...

DATA: wa_gen_param     TYPE /pws/zycrt012,

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq OBLIGATORY

                                              MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

SELECTION-SCREEN END OF BLOCK b6.

SELECTION-SCREEN BEGIN OF BLOCK b4 WITH FRAME TITLE text-005.

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'

                                     MATCHCODE OBJECT h_unit_volume.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura/Cargo 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    IF NOT wa_rep_param-bds_classname IS INITIAL.

      wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

      wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

      wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

      wa_bds_upload_info-spras         = v_langu.

      wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

      wa_bds_upload_info-description   = wa_rep_param-bds_description.

      wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR020

 

...

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_waersa TYPE /pws/zycbt007-waersa.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq OBLIGATORY

                                              MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

SELECTION-SCREEN END OF BLOCK b6.

SELECTION-SCREEN BEGIN OF BLOCK b4 WITH FRAME TITLE text-005.

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'

                                     MATCHCODE OBJECT h_unit_volume.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura/Cargo 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    IF NOT wa_rep_param-bds_classname IS INITIAL.

      wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

      wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

      wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

      wa_bds_upload_info-spras         = v_langu.

      wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

      wa_bds_upload_info-description   = wa_rep_param-bds_description.

      wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR021

 

...

DATA: wa_gen_param     TYPE /pws/zycrt012,

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq OBLIGATORY

                                              MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

SELECTION-SCREEN END OF BLOCK b6.

SELECTION-SCREEN BEGIN OF BLOCK b4 WITH FRAME TITLE text-005.

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'

                                     MATCHCODE OBJECT h_unit_volume.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura/Cargo 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    IF NOT wa_rep_param-bds_classname IS INITIAL.

      wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

      wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

      wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

      wa_bds_upload_info-spras         = v_langu.

      wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

      wa_bds_upload_info-description   = wa_rep_param-bds_description.

      wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR023

 

...

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_waersa TYPE /pws/zycbt007-waersa.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq OBLIGATORY

                                              MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

SELECTION-SCREEN END OF LINE.

SELECTION-SCREEN END OF BLOCK b6.

SELECTION-SCREEN BEGIN OF BLOCK b4 WITH FRAME TITLE text-005.

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

    wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

    wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

    wa_bds_upload_info-spras         = v_langu.

    wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

    wa_bds_upload_info-description   = wa_rep_param-bds_description.

    wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

    IF NOT wa_bds_upload_info IS INITIAL.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR024

 

...

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_waersa TYPE /pws/zycbt007-waersa.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq OBLIGATORY

                                              MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

SELECTION-SCREEN END OF BLOCK b6.

SELECTION-SCREEN BEGIN OF BLOCK b4 WITH FRAME TITLE text-005.

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'

                                     MATCHCODE OBJECT h_unit_volume.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura/Cargo 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    IF NOT wa_rep_param-bds_classname IS INITIAL.

      wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

      wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

      wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

      wa_bds_upload_info-spras         = v_langu.

      wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

      wa_bds_upload_info-description   = wa_rep_param-bds_description.

      wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR026

 

...

DATA: wa_gen_param     TYPE /pws/zycrt012,

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq OBLIGATORY

                                              MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

SELECTION-SCREEN END OF BLOCK b6.

SELECTION-SCREEN BEGIN OF BLOCK b4 WITH FRAME TITLE text-005.

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'

                                     MATCHCODE OBJECT h_unit_volume.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura/Cargo 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    IF NOT wa_rep_param-bds_classname IS INITIAL.

      wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

      wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

      wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

      wa_bds_upload_info-spras         = v_langu.

      wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

      wa_bds_upload_info-description   = wa_rep_param-bds_description.

      wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR027

 

...

DATA: wa_gen_param     TYPE /pws/zycrt012,

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq OBLIGATORY

                                              MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

SELECTION-SCREEN END OF BLOCK b6.

SELECTION-SCREEN BEGIN OF BLOCK b4 WITH FRAME TITLE text-005.

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'

                                     MATCHCODE OBJECT h_unit_volume.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura/Cargo 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

    wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

    wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

    wa_bds_upload_info-spras         = v_langu.

    wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

    wa_bds_upload_info-description   = wa_rep_param-bds_description.

    wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

    IF NOT wa_bds_upload_info IS INITIAL.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR033

 

...

DATA: wa_gen_param     TYPE /pws/zycrt012,

      wa_rep_param     TYPE /pws/zycrt013,

      it_matrix        TYPE t_matrix,

      it_report_fields TYPE t_rep_fields.

DATA: it_excel_content TYPE t_excel_content,

      it_sect_height   TYPE t_sect_height.

DATA: it_generation_options TYPE t_generation_options,

      wa_generation_options LIKE LINE OF it_generation_options.

DATA: v_grupo            TYPE /pws/zycet002-grupo,

      v_process_key(100) TYPE c.

* >> Início da inclusão:

DATA: wa_bds_upload_info TYPE s_bds_upload_info,

      wa_bds_keywords    TYPE s_bds_keywords.

* << Fim da inclusão

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

PARAMETERS: p_nrseq  TYPE /pws/zycet002-nrseq OBLIGATORY

                                              MODIF ID key.

SELECT-OPTIONS: s_grupos FOR /pws/zycet002-grupo NO INTERVALS.

PARAMETERS: p_repmod TYPE /pws/zycrt010-report_module OBLIGATORY

                                                      MODIF ID key

                                                      VALUE CHECK,

            p_report TYPE /pws/zycrt010-report_id     OBLIGATORY

                                                      MODIF ID key.

SELECTION-SCREEN END OF BLOCK b1.

...

 

...

SELECTION-SCREEN END OF LINE.

SELECTION-SCREEN END OF BLOCK b6.

SELECTION-SCREEN BEGIN OF BLOCK b4 WITH FRAME TITLE text-005.

PARAMETERS: p_un_vol TYPE t006-msehi OBLIGATORY DEFAULT 'M3'.

SELECTION-SCREEN END OF BLOCK b4.

SELECTION-SCREEN BEGIN OF BLOCK b5 WITH FRAME TITLE text-006.

PARAMETERS: p_print       TYPE /pws/zycrl017 AS CHECKBOX,

            p_prev        TYPE /pws/zycrl018 AS CHECKBOX,

            p_email       TYPE /pws/zycrl019 AS CHECKBOX,

            p_noshow      TYPE /pws/zycrl020 AS CHECKBOX,

* >> Início da inclusão:

            p_up_bds      TYPE /pws/zycrl023 AS CHECKBOX,

            p_bds_kw      TYPE /pws/zycrl026,

* << Fim da inclusão

            p_passwd(132) TYPE c LOWER CASE.

SELECTION-SCREEN END OF BLOCK b5.

PARAMETERS: p_option TYPE xfeld NO-DISPLAY.

AT SELECTION-SCREEN.

  IF sscrfields-ucomm = 'ONLI' OR sscrfields-ucomm = 'PRIN'.

    IF ( r_s1_ft = 'X' AND p_s1_ft IS INITIAL )

      OR ( r_s1_db = 'X' AND p_s1_db IS INITIAL ).

      MESSAGE w030 WITH 'Assinatura 1'(001).

    ENDIF.

    IF ( r_s2_ft = 'X' AND p_s2_ft IS INITIAL )

...

 

...

  IF p_prev = 'X'.

    wa_generation_options-option = xl_prn_prev_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_print = 'X'.

    wa_generation_options-option = xl_print_after_generate.

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_noshow = 'X'.

    wa_generation_options-option = xl_dont_show_after_generate.

* >> Início da inclusão:

    APPEND wa_generation_options TO it_generation_options[].

  ENDIF.

  IF p_up_bds = 'X'.

    IF NOT wa_rep_param-bds_classname IS INITIAL.

      wa_bds_upload_info-classname     = wa_rep_param-bds_classname.

      wa_bds_upload_info-classtype     = wa_rep_param-bds_classtype.

      wa_bds_upload_info-object_key    = wa_rep_param-bds_object_key.

      wa_bds_upload_info-spras         = v_langu.

      wa_bds_upload_info-document_type = wa_rep_param-bds_doc_type.

      wa_bds_upload_info-description   = wa_rep_param-bds_description.

      wa_bds_upload_info-creation_mode = wa_rep_param-bds_creation.

      wa_generation_options-option   = xl_upload_report_into_bds.

      wa_generation_options-argument = wa_bds_upload_info.

      APPEND wa_generation_options TO it_generation_options[].

      wa_generation_options-option   = xl_process_key.

      wa_generation_options-argument = wa_cabecalho-zycet001-nrseq.

      APPEND wa_generation_options TO it_generation_options[].

      wa_bds_keywords-keyword_1 = wa_cabecalho-zycet001-nrseq.

      wa_bds_keywords-keyword_2 = wa_cabecalho-zycet001-nremb.

      wa_bds_keywords-keyword_3 = p_bds_kw.

      wa_generation_options-option   = xl_bds_keywords.

      wa_generation_options-argument = wa_bds_keywords.

* << Fim da inclusão

    APPEND wa_generation_options TO it_generation_options[].

* >> Início da inclusão:

    ELSE.

      MESSAGE e048.

    ENDIF.

* << Fim da inclusão

  ENDIF.

  PERFORM create_report

          USING

             wa_gen_param-report_generator

...

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPS /PWS/ZYCRR100

 

Criar o report /PWS/ZYCRR100

 

Classe de desenvolvimento: /PWS/ZYCR

Descrição: Pesquisa de reports arquivados no BDS

Categoria: 1-Programa executável

Status: K-Programa de clientes produtivo

 

-Elementos de texto:

 

Símbolos de texto:

 

nº  Texto                                 ComD ComM

--------------------------------------------------

000 Critérios de pesquisa principais      32   40

001 Critérios de pesquisa secundários     33   40

002 Arquivos encontrados:                 21   60

003 Selecionado reports...                22   50

004 Pesquisando documentos arquivados...  36   50

005 Preparando exibição dos resultados... 37   50

006 P.Ch.1                                 6   10

007 Pal.Chave 1                           11   20

008 Palavra Chave 1                       15   40

009 P.Ch.2                                 6   10

010 Pal.Chave 2                           11   20

011 Palavra Chave 2                       15   40

012 P.Ch.3                                 6   10

013 Pal.Chave 3                           11   20

014 Palavra Chave 3                       15   40

015 Us.Cri.                                7   10

016 Us.Criação                            10   20

017 Usuário de Criação                    18   40

018 Dt.Cri.                                7   10

019 Dt.Criação                            10   20

020 Data de Criação                       15   40

021 Us.Mod.                                7   10

022 Us.Modif.                              9   20

023 Usuário de Modificação                22   40

024 Dt.Mod.                                7   10

025 Dt.Modif.                              9   20

026 Data de Modificação                   19   40

 

Textos de seleção

 

Parâm.   Texto                        Ref.DDIC

----------------------------------------------

S_DH_CH  Data e hora da última modif.

S_DH_CR  Data e hora de criação

S_LANG   Idioma

S_OBJDES Descrição do report

S_PCHAVE Palavra-chave

S_REPID  ID Report                      X

S_REPMOD Código de Módulo               X

S_US_CH  Usuário da últ. modificação

S_US_CR  Usuário de criação

 

 

Código-fonte:

 

* --------------------------------------------------------------------

* PROCWORK Software

* Produto:   pw.CE

* Módulo:    CR - CE Reports

* Descrição: Relatório de pesquisa de documentos arquivados no BDS

* Help Desk: (11) 5504-0270

* --------------------------------------------------------------------

* ESTE PROGRAMA NÃO DEVE SER ALTERADO SEM PRÉVIA CONSULTA

* --------------------------------------------------------------------

* Chamado  Data      Descrição

* --------------------------------------------------------------------

* 371091   31/12/07  Codificação inicial

* --------------------------------------------------------------------

REPORT /pws/zycrr100 MESSAGE-ID /pws/zycrm.

 

 

* ---------------------------------------------------------------------

TYPE-POOLS: slis.

 

 

* ---------------------------------------------------------------------

TABLES: bapibds01,

        /pws/zycrt013.

 

 

* ---------------------------------------------------------------------

TYPES: BEGIN OF s_zycrt013,

         report_module   TYPE /pws/zycrt013-report_module,

         report_id       TYPE /pws/zycrt013-report_id,

         bds_classname   TYPE /pws/zycrt013-bds_classname,

         bds_classtype   TYPE /pws/zycrt013-bds_classtype,

         bds_object_key  TYPE /pws/zycrt013-bds_object_key,

         bds_description TYPE /pws/zycrt013-bds_description,

         bds_doc_type    TYPE /pws/zycrt013-bds_doc_type,

       END OF s_zycrt013,

       t_zycrt013 TYPE STANDARD TABLE OF s_zycrt013

                       WITH DEFAULT KEY.

 

TYPES: BEGIN OF s_arquivos,

         report_module       TYPE /pws/zycrt013-report_module,

         report_id           TYPE /pws/zycrt013-report_id,

         bds_classname       TYPE /pws/zycrt013-bds_classname,

         bds_classtype       TYPE /pws/zycrt013-bds_classtype,

         doc_id              TYPE bapibds01-doc_id,

         doc_ver_no          TYPE bapibds01-doc_ver_no,

         doc_var_id          TYPE bapibds01-doc_var_id,

         doc_var_tg          TYPE bapibds01-doc_var_tg,

         bds_description     TYPE /pws/zycrt013-bds_description,

         bds_object_key      TYPE /pws/zycrt013-bds_object_key,

         idioma              TYPE t002-spras,

         usuario_criacao     TYPE bapibds01-done_by,

         data_criacao        TYPE bapibds01-done_at,

         usuario_modificacao TYPE bapibds01-done_by,

         data_modificacao    TYPE bapibds01-done_at,

         bds_doc_type        TYPE /pws/zycrt013-bds_doc_type,

         nome_arquivo        TYPE bapibds01-filename,

         keyword_1           TYPE bapibds01-prop_value,

         keyword_2           TYPE bapibds01-prop_value,

         keyword_3           TYPE bapibds01-prop_value,

       END OF s_arquivos,

       t_arquivos TYPE STANDARD TABLE OF s_arquivos

                       WITH NON-UNIQUE KEY report_module

                                           report_id

                                           bds_classname

                                           bds_classtype

                                           doc_id

                                           doc_ver_no

                                           doc_var_id.

 

TYPES: t_bapicompon TYPE STANDARD TABLE OF bapicompon WITH DEFAULT KEY,

       t_bapisignat TYPE STANDARD TABLE OF bapisignat WITH DEFAULT KEY,

       t_bapiconnec TYPE STANDARD TABLE OF bapiconnec WITH DEFAULT KEY,

       t_bapiquery  TYPE STANDARD TABLE OF bapiquery  WITH DEFAULT KEY.

 

 

* ---------------------------------------------------------------------

DATA: it_zycrt013 TYPE t_zycrt013,

      it_bds      TYPE t_arquivos.

 

 

* ---------------------------------------------------------------------

SELECTION-SCREEN BEGIN OF BLOCK b1 WITH FRAME TITLE text-000.

 

SELECT-OPTIONS: s_repmod FOR /pws/zycrt013-report_module,

                s_repid  FOR /pws/zycrt013-report_id.

 

SELECTION-SCREEN END OF BLOCK b1.

 

 

SELECTION-SCREEN BEGIN OF BLOCK b2 WITH FRAME TITLE text-001.

 

SELECT-OPTIONS: s_objdes FOR /pws/zycrt013-bds_description LOWER CASE,

                s_pchave FOR bapibds01-key_word LOWER CASE,

                s_lang   FOR /pws/zycrt013-spras,

                s_us_cr  FOR bapibds01-done_by,

                s_dh_cr  FOR bapibds01-done_at,

                s_us_ch  FOR bapibds01-done_by,

                s_dh_ch  FOR bapibds01-done_at.

 

SELECTION-SCREEN END OF BLOCK b2.

 

 

* ---------------------------------------------------------------------

START-OF-SELECTION.

 

  CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR'

       EXPORTING

            percentage = 0

            text       = 'Selecionado reports...'(003).

 

  PERFORM busca_dados_arquivamento

          USING

            s_repmod[]

            s_repid[]

          CHANGING

            it_zycrt013[].

 

  IF it_zycrt013[] IS INITIAL.

 

    MESSAGE i046.

 

    STOP.

 

  ENDIF.

 

  CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR'

       EXPORTING

            percentage = 35

            text       = 'Pesquisando documentos arquivados...'(004).

 

  PERFORM executa_query_bds

          USING

            it_zycrt013[]

            s_objdes[]

            s_pchave[]

            s_lang[]

            s_us_cr[]

            s_dh_cr[]

            s_us_ch[]

            s_dh_ch[]

          CHANGING

            it_bds[].

 

  IF it_bds[] IS INITIAL.

 

    MESSAGE i047.

 

    STOP.

 

  ENDIF.

 

  CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR'

       EXPORTING

            percentage = 99

            text       = 'Preparando exibição dos resultados...'(005).

 

  PERFORM exibe_resultados

          USING

            it_bds[].

 

 

END-OF-SELECTION.

 

 

* --------------------------------------------------------------------

* Form busca_dados_arquivamento

* --------------------------------------------------------------------

* Objetivo:

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_r_repmod

*     p_r_repid

* <-- p_t_zycrt013

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data      Descrição

* --------------------------------------------------------------------

* 371091   31/12/07  Codificação inicial

* --------------------------------------------------------------------

FORM busca_dados_arquivamento

     USING

       p_r_repmod   LIKE s_repmod[]

       p_r_repid    LIKE s_repid[]

     CHANGING

       p_t_zycrt013 TYPE t_zycrt013.

 

 

  SELECT report_module

         report_id

         bds_classname

         bds_classtype

         bds_object_key

         bds_description

         bds_doc_type

      FROM /pws/zycrt013

      INTO TABLE p_t_zycrt013

      WHERE report_module IN p_r_repmod

        AND report_id     IN p_r_repid

        AND bds_classname <> ''.

 

  IF sy-subrc = 0.

 

    SORT p_t_zycrt013[].

 

    DELETE ADJACENT DUPLICATES FROM p_t_zycrt013[].

 

  ELSE.

 

    CLEAR p_t_zycrt013[].

 

  ENDIF.

 

 

ENDFORM.                    " busca_dados_arquivamento

 

 

* --------------------------------------------------------------------

* Form executa_query_bds

* --------------------------------------------------------------------

* Objetivo:

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_t_zycrt013

*     p_r_objdes

*     p_r_pchave

*     p_r_lang

*     p_r_us_cr

*     p_r_dh_cr

*     p_r_us_ch

*     p_r_dh_ch

* <-- p_t_bds

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data      Descrição

* --------------------------------------------------------------------

* 371091   31/12/07  Codificação inicial

* --------------------------------------------------------------------

FORM executa_query_bds

     USING

       p_t_zycrt013 TYPE t_zycrt013

       p_r_objdes   LIKE s_objdes[]

       p_r_pchave   LIKE s_pchave[]

       p_r_lang     LIKE s_lang[]

       p_r_us_cr    LIKE s_us_cr[]

       p_r_dh_cr    LIKE s_dh_cr[]

       p_r_us_ch    LIKE s_us_ch[]

       p_r_dh_ch    LIKE s_dh_ch[]

     CHANGING

       p_t_bds      TYPE t_arquivos.

 

  DATA: it_query         TYPE t_bapiquery,

        it_query_parcial TYPE t_bapiquery.

 

  DATA: wa_zycrt013 LIKE LINE OF p_t_zycrt013[].

 

  DATA: it_components  TYPE t_bapicompon,

        it_signature   TYPE t_bapisignat,

        it_connections TYPE t_bapiconnec.

 

 

  PERFORM monta_query_descricao

          USING

            p_r_objdes[]

          CHANGING

            it_query[].

 

  PERFORM monta_query_palavras_chave

          USING

            p_r_pchave[]

          CHANGING

            it_query[].

 

  PERFORM monta_query_idioma

          USING

            p_r_lang[]

          CHANGING

            it_query[].

 

  PERFORM monta_query_usuario_criacao

          USING

            p_r_us_cr[]

          CHANGING

            it_query[].

 

  PERFORM monta_query_data_criacao

          USING

            p_r_dh_cr[]

          CHANGING

            it_query[].

 

  PERFORM monta_query_usuario_modif

          USING

            p_r_us_ch[]

          CHANGING

            it_query[].

 

  PERFORM monta_query_data_modificacao

          USING

            p_r_dh_ch[]

          CHANGING

            it_query[].

 

 

  LOOP AT it_zycrt013[] INTO wa_zycrt013.

 

    PERFORM monta_query_arquivos

            USING

              wa_zycrt013

            CHANGING

              it_query_parcial[].

 

    APPEND LINES OF it_query[] TO it_query_parcial[].

 

    CALL METHOD cl_bds_document_set=>query_documents

         EXPORTING

           classname       = wa_zycrt013-bds_classname

           classtype       = wa_zycrt013-bds_classtype

           object_key      = wa_zycrt013-bds_object_key

           query           = it_query_parcial[]

         CHANGING

           components      = it_components[]

           connections     = it_connections[]

           signature       = it_signature[]

         EXCEPTIONS

           error_kpro      = 1

           internal_error  = 2

           nothing_found   = 3

           parameter_error = 4

           not_authorized  = 5

           not_allowed     = 6

           OTHERS          = 7.

 

    IF sy-subrc = 0.

 

      PERFORM formata_resultados

              USING

                wa_zycrt013

                it_components[]

                it_signature[]

                it_connections[]

              CHANGING

                p_t_bds[].

 

    ENDIF.

 

    CLEAR: it_query_parcial[],

           it_components[],

           it_signature[],

           it_connections[].

 

  ENDLOOP.

 

 

ENDFORM.                    " executa_query_bds

 

 

* --------------------------------------------------------------------

* Form monta_query_arquivos

* --------------------------------------------------------------------

* Objetivo:

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_zycrt013

* <-- p_t_query

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data      Descrição

* --------------------------------------------------------------------

* 371091   31/12/07  Codificação inicial

* --------------------------------------------------------------------

FORM monta_query_arquivos

     USING

       p_zycrt013 TYPE s_zycrt013

     CHANGING

       p_t_query  TYPE t_bapiquery.

 

  DATA: wa_query LIKE LINE OF p_t_query[].

 

 

  IF NOT p_zycrt013-bds_doc_type IS INITIAL.

 

    wa_query-prop_name = 'BDS_DOCUMENTTYPE'.

    wa_query-sign      = 'I'.

    wa_query-option    = 'EQ'.

    wa_query-low       = p_zycrt013-bds_doc_type.

    wa_query-high      = space.

 

    APPEND wa_query TO p_t_query[].

 

  ENDIF.

 

 

ENDFORM.                    " monta_query_arquivos

 

 

* --------------------------------------------------------------------

* Form monta_query_descricao

* --------------------------------------------------------------------

* Objetivo:

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_r_objdes

* <-- p_t_query

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data      Descrição

* --------------------------------------------------------------------

* 371091   31/12/07  Codificação inicial

* --------------------------------------------------------------------

FORM monta_query_descricao

     USING

       p_r_objdes LIKE s_objdes[]

     CHANGING

       p_t_query  TYPE t_bapiquery.

 

  DATA: wa_objdes LIKE LINE OF p_r_objdes[],

        wa_query  LIKE LINE OF p_t_query[].

 

 

  wa_query-prop_name = 'DESCRIPTION'.

 

  LOOP AT p_r_objdes[] INTO wa_objdes.

 

    wa_query-sign   = wa_objdes-sign.

    wa_query-option = wa_objdes-option.

    wa_query-low    = wa_objdes-low.

    wa_query-high   = wa_objdes-high.

 

    APPEND wa_query TO p_t_query[].

 

  ENDLOOP.

 

 

ENDFORM.                    " monta_query_descricao

 

 

* --------------------------------------------------------------------

* Form monta_query_palavras_chave

* --------------------------------------------------------------------

* Objetivo:

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_r_pchave

* <-- p_t_query

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data      Descrição

* --------------------------------------------------------------------

* 371091   31/12/07  Codificação inicial

* --------------------------------------------------------------------

FORM monta_query_palavras_chave

     USING

       p_r_pchave LIKE s_pchave[]

     CHANGING

       p_t_query  TYPE t_bapiquery.

 

  DATA: wa_pchave LIKE LINE OF p_r_pchave[],

        wa_query  LIKE LINE OF p_t_query[].

 

 

  wa_query-prop_name = 'BDS_KEYWORD'.

 

  LOOP AT p_r_pchave[] INTO wa_pchave.

 

    wa_query-sign   = wa_pchave-sign.

    wa_query-option = wa_pchave-option.

    wa_query-low    = wa_pchave-low.

    wa_query-high   = wa_pchave-high.

 

    APPEND wa_query TO p_t_query[].

 

  ENDLOOP.

 

 

ENDFORM.                    " monta_query_palavras_chave

 

 

* --------------------------------------------------------------------

* Form monta_query_idioma

* --------------------------------------------------------------------

* Objetivo:

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_r_lang

* <-- p_t_query

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data      Descrição

* --------------------------------------------------------------------

* 371091   31/12/07  Codificação inicial

* --------------------------------------------------------------------

FORM monta_query_idioma

     USING

       p_r_lang  LIKE s_lang[]

     CHANGING

       p_t_query TYPE t_bapiquery.

 

  DATA: wa_lang  LIKE LINE OF p_r_lang[],

        wa_query LIKE LINE OF p_t_query[].

 

 

  wa_query-prop_name = 'LANGUAGE'.

 

  LOOP AT p_r_lang[] INTO wa_lang.

 

    wa_query-sign   = wa_lang-sign.

    wa_query-option = wa_lang-option.

    wa_query-low    = wa_lang-low.

    wa_query-high   = wa_lang-high.

 

    APPEND wa_query TO p_t_query[].

 

  ENDLOOP.

 

 

ENDFORM.                    " monta_query_idioma

 

 

* --------------------------------------------------------------------

* Form monta_query_usuario_criacao

* --------------------------------------------------------------------

* Objetivo:

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_r_us_cr

* <-- p_t_query

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data      Descrição

* --------------------------------------------------------------------

* 371091   31/12/07  Codificação inicial

* --------------------------------------------------------------------

FORM monta_query_usuario_criacao

     USING

       p_r_us_cr LIKE s_us_cr[]

     CHANGING

       p_t_query TYPE t_bapiquery.

 

  DATA: wa_us_cr LIKE LINE OF p_r_us_cr[],

        wa_query LIKE LINE OF p_t_query[].

 

 

  wa_query-prop_name = 'CREATED_BY'.

 

  LOOP AT p_r_us_cr[] INTO wa_us_cr.

 

    wa_query-sign   = wa_us_cr-sign.

    wa_query-option = wa_us_cr-option.

    wa_query-low    = wa_us_cr-low.

    wa_query-high   = wa_us_cr-high.

 

    APPEND wa_query TO p_t_query[].

 

  ENDLOOP.

 

 

ENDFORM.                    " monta_query_data_criacao

 

 

* --------------------------------------------------------------------

* Form monta_query_data_criacao

* --------------------------------------------------------------------

* Objetivo:

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_r_dh_cr

* <-- p_t_query

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data      Descrição

* --------------------------------------------------------------------

* 371091   31/12/07  Codificação inicial

* --------------------------------------------------------------------

FORM monta_query_data_criacao

     USING

       p_r_dh_cr LIKE s_dh_cr[]

     CHANGING

       p_t_query TYPE t_bapiquery.

 

  DATA: wa_dh_cr LIKE LINE OF p_r_dh_cr[],

        wa_query LIKE LINE OF p_t_query[].

 

 

  wa_query-prop_name = 'CREATED_AT'.

 

  LOOP AT p_r_dh_cr[] INTO wa_dh_cr.

 

    wa_query-sign   = wa_dh_cr-sign.

    wa_query-option = wa_dh_cr-option.

    wa_query-low    = wa_dh_cr-low.

    wa_query-high   = wa_dh_cr-high.

 

    APPEND wa_query TO p_t_query[].

 

  ENDLOOP.

 

 

ENDFORM.                    " monta_query_data_criacao

 

 

* --------------------------------------------------------------------

* Form monta_query_usuario_modif

* --------------------------------------------------------------------

* Objetivo:

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_r_us_ch

* <-- p_t_query

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data      Descrição

* --------------------------------------------------------------------

* 371091   31/12/07  Codificação inicial

* --------------------------------------------------------------------

FORM monta_query_usuario_modif

     USING

       p_r_us_ch LIKE s_us_ch[]

     CHANGING

       p_t_query TYPE t_bapiquery.

 

  DATA: wa_us_ch LIKE LINE OF p_r_us_ch[],

        wa_query LIKE LINE OF p_t_query[].

 

 

  wa_query-prop_name = 'LAST_CHANGED_BY'.

 

  LOOP AT p_r_us_ch INTO wa_us_ch.

 

    wa_query-sign   = wa_us_ch-sign.

    wa_query-option = wa_us_ch-option.

    wa_query-low    = wa_us_ch-low.

    wa_query-high   = wa_us_ch-high.

 

    APPEND wa_query TO p_t_query[].

 

  ENDLOOP.

 

 

ENDFORM.                    " monta_query_data_modificacao

 

 

* --------------------------------------------------------------------

* Form monta_query_data_modificacao

* --------------------------------------------------------------------

* Objetivo:

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_r_dh_ch

* <-- p_t_query

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data      Descrição

* --------------------------------------------------------------------

* 371091   31/12/07  Codificação inicial

* --------------------------------------------------------------------

FORM monta_query_data_modificacao

     USING

       p_r_dh_ch LIKE s_dh_ch[]

     CHANGING

       p_t_query TYPE t_bapiquery.

 

  DATA: wa_dh_ch LIKE LINE OF p_r_dh_ch[],

        wa_query LIKE LINE OF p_t_query[].

 

 

  wa_query-prop_name = 'LAST_CHANGED_AT'.

 

  LOOP AT p_r_dh_ch INTO wa_dh_ch.

 

    wa_query-sign   = wa_dh_ch-sign.

    wa_query-option = wa_dh_ch-option.

    wa_query-low    = wa_dh_ch-low.

    wa_query-high   = wa_dh_ch-high.

 

    APPEND wa_query TO p_t_query[].

 

  ENDLOOP.

 

 

ENDFORM.                    " monta_query_data_modificacao

 

 

* --------------------------------------------------------------------

* Form formata_resultados

* --------------------------------------------------------------------

* Objetivo:

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_zycrt013

*     p_t_components

*     p_t_signatures

*     p_t_connections

* <-- p_t_bds

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data      Descrição

* --------------------------------------------------------------------

* 371091   31/12/07  Codificação inicial

* --------------------------------------------------------------------

FORM formata_resultados

     USING

       p_zycrt013      TYPE s_zycrt013

       p_t_components  TYPE t_bapicompon

       p_t_signatures  TYPE t_bapisignat

       p_t_connections TYPE t_bapiconnec

     CHANGING

       p_t_bds         TYPE t_arquivos.

 

  DATA: wa_components  LIKE LINE OF p_t_components[],

        wa_signatures  LIKE LINE OF p_t_signatures[],

        wa_connections LIKE LINE OF p_t_connections[],

        wa_bds         LIKE LINE OF p_t_bds[].

 

 

  LOOP AT p_t_connections[] INTO wa_connections.

 

    wa_bds-report_module = p_zycrt013-report_module.

    wa_bds-report_id     = p_zycrt013-report_id.

 

    wa_bds-bds_classname  = wa_connections-classname.

    wa_bds-bds_classtype  = wa_connections-classtype.

    wa_bds-bds_object_key = wa_connections-object_key.

 

    READ TABLE p_t_components[] INTO wa_components INDEX sy-tabix.

 

    wa_bds-nome_arquivo = wa_components-comp_id.

 

 

    LOOP AT p_t_signatures[] INTO wa_signatures

                            WHERE doc_count = wa_components-doc_count.

 

      wa_bds-doc_id = wa_signatures-doc_id.

      wa_bds-doc_ver_no = wa_signatures-doc_ver_no.

      wa_bds-doc_var_id = wa_signatures-doc_var_id.

      wa_bds-doc_var_tg = wa_signatures-doc_var_tg.

 

      CASE wa_signatures-prop_name.

 

        WHEN 'DESCRIPTION'.

 

          wa_bds-bds_description = wa_signatures-prop_value.

 

 

        WHEN 'LANGUAGE'.

 

          wa_bds-idioma = wa_signatures-prop_value.

 

 

        WHEN 'BDS_DOCUMENTTYPE'.

 

          wa_bds-bds_doc_type = wa_signatures-prop_value.

 

 

        WHEN 'CREATED_BY'.

 

          wa_bds-usuario_criacao = wa_signatures-prop_value.

 

 

        WHEN 'CREATED_AT'.

 

          wa_bds-data_criacao = wa_signatures-prop_value.

 

 

        WHEN 'LAST_CHANGED_BY'.

 

          wa_bds-usuario_modificacao = wa_signatures-prop_value.

 

 

        WHEN 'LAST_CHANGED_AT'.

 

          wa_bds-data_modificacao = wa_signatures-prop_value.

 

 

        WHEN 'BDS_KEYWORD'.

 

          IF wa_bds-keyword_1 IS INITIAL.

 

            wa_bds-keyword_1 = wa_signatures-prop_value.

 

          ELSEIF wa_bds-keyword_2 IS INITIAL.

 

            wa_bds-keyword_2 = wa_signatures-prop_value.

 

          ELSEIF wa_bds-keyword_3 IS INITIAL.

 

            wa_bds-keyword_3 = wa_signatures-prop_value.

 

          ENDIF.

 

 

      ENDCASE.

 

    ENDLOOP.

 

    APPEND wa_bds TO p_t_bds[].

 

    CLEAR: wa_bds.

 

  ENDLOOP.

 

 

ENDFORM.                    " formata_resultados

 

 

* --------------------------------------------------------------------

* Form exibe_resultados

* --------------------------------------------------------------------

* Objetivo:

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_t_bds

* <-- <nenhum>

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data      Descrição

* --------------------------------------------------------------------

* 371091   31/12/07  Codificação inicial

* --------------------------------------------------------------------

FORM exibe_resultados

     USING

       p_t_bds TYPE t_arquivos.

 

  DATA: it_fieldcat  TYPE slis_t_fieldcat_alv,

        wa_layout    TYPE slis_layout_alv,

        title        TYPE lvc_title.

 

 

  PERFORM monta_fieldcat

          CHANGING

            it_fieldcat[].

 

 

  wa_layout-zebra             = 'X'.

  wa_layout-colwidth_optimize = 'X'.

 

 

  DESCRIBE TABLE p_t_bds[].

  WRITE sy-tfill TO title LEFT-JUSTIFIED.

  CONCATENATE text-002 title INTO title SEPARATED BY space.

 

 

  CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'

       EXPORTING

            i_callback_program      = '/PWS/ZYCRR100'

            i_callback_user_command = 'ALV_USER_COMMAND'

            i_grid_title            = title

            is_layout               = wa_layout

            it_fieldcat             = it_fieldcat[]

       TABLES

            t_outtab                = p_t_bds[]

       EXCEPTIONS

            program_error           = 1

            OTHERS                  = 2.

 

  IF sy-subrc <> 0.

 

    MESSAGE ID sy-msgid

            TYPE sy-msgty

            NUMBER sy-msgno

            WITH sy-msgv1

                 sy-msgv2

                 sy-msgv3

                 sy-msgv4.

 

  ENDIF.

 

 

ENDFORM.                    " exibe_resultados

 

 

* --------------------------------------------------------------------

* Form monta_fieldcat

* --------------------------------------------------------------------

* Objetivo:

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> <nenhum>

* <-- p_t_fieldcat

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data      Descrição

* --------------------------------------------------------------------

* 371091   31/12/07  Codificação inicial

* --------------------------------------------------------------------

FORM monta_fieldcat

     CHANGING

       p_t_fieldcat TYPE slis_t_fieldcat_alv.

 

  DATA: wa_fieldcat LIKE LINE OF p_t_fieldcat[].

 

 

  wa_fieldcat-fieldname     = 'REPORT_MODULE'.

  wa_fieldcat-ref_fieldname = 'REPORT_MODULE'.

  wa_fieldcat-ref_tabname   = '/PWS/ZYCRT013'.

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'REPORT_ID'.

  wa_fieldcat-ref_fieldname = 'REPORT_ID'.

  wa_fieldcat-ref_tabname   = '/PWS/ZYCRT013'.

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'BDS_OBJECT_KEY'.

  wa_fieldcat-ref_fieldname = 'BDS_OBJECT_KEY'.

  wa_fieldcat-ref_tabname   = '/PWS/ZYCRT013'.

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'BDS_DESCRIPTION'.

  wa_fieldcat-ref_fieldname = 'BDS_DESCRIPTION'.

  wa_fieldcat-ref_tabname   = '/PWS/ZYCRT013'.

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'IDIOMA'.

  wa_fieldcat-ref_fieldname = 'SPRAS'.

  wa_fieldcat-ref_tabname   = 'T002'.

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'USUARIO_CRIACAO'.

  wa_fieldcat-ref_fieldname = 'DONE_BY'.

  wa_fieldcat-ref_tabname   = 'BAPIBDS01'.

  wa_fieldcat-seltext_s     = 'Us.Cri.'(015).

  wa_fieldcat-seltext_m     = 'Us.Criação'(016).

  wa_fieldcat-seltext_l     = 'Usuário de Criação'(017).

  wa_fieldcat-reptext_ddic  = 'Usuário de Criação'(017).

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'DATA_CRIACAO'.

  wa_fieldcat-ref_fieldname = 'DONE_AT'.

  wa_fieldcat-ref_tabname   = 'BAPIBDS01'.

  wa_fieldcat-just          = 'L'.

  wa_fieldcat-seltext_s     = 'Dt.Cri.'(018).

  wa_fieldcat-seltext_m     = 'Dt.Criação'(019).

  wa_fieldcat-seltext_l     = 'Data de Criação'(020).

  wa_fieldcat-reptext_ddic  = 'Data de Criação'(020).

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'USUARIO_MODIFICACAO'.

  wa_fieldcat-ref_fieldname = 'DONE_BY'.

  wa_fieldcat-ref_tabname   = 'BAPIBDS01'.

  wa_fieldcat-seltext_s     = 'Us.Mod.'(021).

  wa_fieldcat-seltext_m     = 'Us.Modif.'(022).

  wa_fieldcat-seltext_l     = 'Usuário de Modificação'(023).

  wa_fieldcat-reptext_ddic  = 'Usuário de Modificação'(023).

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'DATA_MODIFICACAO'.

  wa_fieldcat-ref_fieldname = 'DONE_AT'.

  wa_fieldcat-ref_tabname   = 'BAPIBDS01'.

  wa_fieldcat-just          = 'L'.

  wa_fieldcat-seltext_s     = 'Dt.Mod.'(024).

  wa_fieldcat-seltext_m     = 'Dt.Modif.'(025).

  wa_fieldcat-seltext_l     = 'Data de Modificação'(026).

  wa_fieldcat-reptext_ddic  = 'Data de Modificação'(026).

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'NOME_ARQUIVO'.

  wa_fieldcat-ref_fieldname = 'FILENAME'.

  wa_fieldcat-ref_tabname   = 'BAPIBDS01'.

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'KEYWORD_1'.

  wa_fieldcat-ref_fieldname = 'PROP_VALUE'.

  wa_fieldcat-ref_tabname   = 'BAPIBDS01'.

  wa_fieldcat-seltext_s     = 'P.Ch.1'(006).

  wa_fieldcat-seltext_m     = 'Pal.Chave 1'(007).

  wa_fieldcat-seltext_l     = 'Palavra Chave 1'(008).

  wa_fieldcat-reptext_ddic  = 'Palavra Chave 1'(008).

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'KEYWORD_2'.

  wa_fieldcat-ref_fieldname = 'PROP_VALUE'.

  wa_fieldcat-ref_tabname   = 'BAPIBDS01'.

  wa_fieldcat-seltext_s     = 'P.Ch.2'(009).

  wa_fieldcat-seltext_m     = 'Pal.Chave 2'(010).

  wa_fieldcat-seltext_l     = 'Palavra Chave 2'(011).

  wa_fieldcat-reptext_ddic  = 'Palavra Chave 2'(011).

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'KEYWORD_3'.

  wa_fieldcat-ref_fieldname = 'PROP_VALUE'.

  wa_fieldcat-ref_tabname   = 'BAPIBDS01'.

  wa_fieldcat-seltext_s     = 'P.Ch.3'(012).

  wa_fieldcat-seltext_m     = 'Pal.Chave 3'(013).

  wa_fieldcat-seltext_l     = 'Palavra Chave 3'(014).

  wa_fieldcat-reptext_ddic  = 'Palavra Chave 3'(014).

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'BDS_CLASSNAME'.

  wa_fieldcat-ref_fieldname = 'BDS_CLASSNAME'.

  wa_fieldcat-ref_tabname   = '/PWS/ZYCRT013'.

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'BDS_CLASSTYPE'.

  wa_fieldcat-ref_fieldname = 'BDS_CLASSTYPE'.

  wa_fieldcat-ref_tabname   = '/PWS/ZYCRT013'.

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'DOC_ID'.

  wa_fieldcat-ref_fieldname = 'DOC_ID'.

  wa_fieldcat-ref_tabname   = 'BAPIBDS01'.

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'DOC_VER_NO'.

  wa_fieldcat-ref_fieldname = 'DOC_VER_NO'.

  wa_fieldcat-ref_tabname   = 'BAPIBDS01'.

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'DOC_VAR_ID'.

  wa_fieldcat-ref_fieldname = 'DOC_VAR_ID'.

  wa_fieldcat-ref_tabname   = 'BAPIBDS01'.

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'DOC_VAR_TG'.

  wa_fieldcat-ref_fieldname = 'DOC_VAR_TG'.

  wa_fieldcat-ref_tabname   = 'BAPIBDS01'.

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

  CLEAR wa_fieldcat.

 

  wa_fieldcat-fieldname     = 'BDS_DOC_TYPE'.

  wa_fieldcat-ref_fieldname = 'BDS_DOC_TYPE'.

  wa_fieldcat-ref_tabname   = '/PWS/ZYCRT013'.

 

  APPEND wa_fieldcat TO p_t_fieldcat.

 

 

ENDFORM.                    " monta_fieldcat

 

 

* --------------------------------------------------------------------

* Form alv_user_command

* --------------------------------------------------------------------

* Objetivo:

* --------------------------------------------------------------------

* Parâmetros:   ( --> Entrada ) ( <-- Saída ) ( <-> Tabelas )

* --------------------------------------------------------------------

* --> p_r_ucomm

* --> p_rs_selfield

* <-- <nenhum>

* <-> <nenhum>

* --------------------------------------------------------------------

* Chamado  Data      Descrição

* --------------------------------------------------------------------

* 371091   31/12/07  Codificação inicial

* --------------------------------------------------------------------

FORM alv_user_command

     USING

       p_r_ucomm     LIKE sy-ucomm

       p_rs_selfield TYPE slis_selfield.                    "#EC CALLED

 

  DATA: wa_bds LIKE LINE OF it_bds[].

 

  DATA: it_signature TYPE t_bapisignat,

        wa_signature LIKE LINE OF it_signature.

 

 

  IF p_r_ucomm = '&IC1'.

 

    READ TABLE it_bds[] INTO wa_bds INDEX p_rs_selfield-tabindex.

 

    wa_signature-doc_count  = 1.

    wa_signature-doc_id     = wa_bds-doc_id.

    wa_signature-doc_ver_no = wa_bds-doc_ver_no.

    wa_signature-doc_var_id = wa_bds-doc_var_id.

 

    APPEND wa_signature TO it_signature[].

 

    CALL METHOD cl_bds_document_set=>call_navigator

         EXPORTING

           classname          = wa_bds-bds_classname

           classtype          = wa_bds-bds_classtype

           display_single_doc = 'X'

         CHANGING

           signature          = it_signature[]

         EXCEPTIONS

           parameter_error    = 1

           internal_error     = 2

           nothing_found      = 3

           error_kpro         = 4

           not_allowed        = 5

           not_authorized     = 6

           OTHERS             = 7.

 

    IF sy-subrc <> 0.

 

      MESSAGE ID sy-msgid

              TYPE sy-msgty

              NUMBER sy-msgno

              WITH sy-msgv1

                   sy-msgv2

                   sy-msgv3

                   sy-msgv4.

 

    ENDIF.

 

  ENDIF.

 

 

ENDFORM.                    " alv_user_command

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR003

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: SIM

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR010

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: SIM

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR011

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: SIM

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR013

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: NÃO

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR014

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: NÃO

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR015

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: SIM

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR016

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: SIM

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR017

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: SIM

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR018

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: SIM

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR020

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: SIM

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR021

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: SIM

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR023

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: SIM

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR024

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: SIM

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR026

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: SIM

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR027

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: SIM

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em REPT /PWS/ZYCRR033

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_BDS_KW

 

Texto: (37 caracteres)

"Palavra-chave p/ pesq. no BDS"

 

Referência ao Dictionary: SIM

 

 

Incluído texto de seleção:

 

Idioma: PT

 

Variável (SELECT-OPTION / PARAMETER): P_UP_BDS

 

Texto: (22 caracteres)

"Criação no BDS"

 

Referência ao Dictionary: SIM

 

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em TABD /PWS/ZYCRT013

 

Incluir os campos no final da tabela (após o campo REPORT_FOLDER):

 

Campo            Elemento

-------------------------------

BDS_CLASSNAME    BDS_CLSNAM

BDS_CLASSTYPE    BDS_CLSTYP

BDS_OBJECT_KEY   BDS_TYPEID

BDS_DESCRIPTION  /PWS/ZYCRL024

BDS_DOC_TYPE     SAEOBJART

BDS_CREATION     /PWS/ZYCRL023

 

Para o campo BDS_DOC_TYPE, incluir a seguinte chave externa:

Tabela verificação: TOADV

Chaves de verificação (proposta padrão do sistema):

-TOADV-MANDT = /PWS/ZYCRT013-MANDT

-TOADV-AR_OBJECT = /PWS/ZYCRT013-BDS_DOC_TYPE

Tipo de chave: Campos-chave/candidatos

Cardinalidade: 1:CN

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em TOBJ /PWS/ZYCRT013S

 

Gerar novamente o diálogo de atualização da tabela /PWS/ZYCRT013.

Motivo da modificação: Campo novos não-chave na estrutura.

 

----------------------------------------------------------------------------------------------------

Modificações efetuadas em TRAN /PWS/ZYCRR100

 

Criar a transação /PWS/ZYCRR100

Tipo: Transação de report

Classe de desenvolvimento: /PWS/ZYCR

Texto: Pesquisa de docs. arquivados no BDS

Programa: /PWS/ZYCRR100

Tela de seleção: 1000