Difference between revisions of "SAP SD Transporte"

From SapWiki
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
== Programa y formulario impresión ==
 +
programa: RV56TD00
 +
 +
FORM: SHIPMENT_DOC
 +
 +
==Actualizar clase de mensaje ==
 +
trn. V/82
 +
 
==Códigos Varios Transporte==
 
==Códigos Varios Transporte==
 
===Ejemplo 01===
 
===Ejemplo 01===
 
  <nowiki>FORM get_data.
 
  <nowiki>FORM get_data.
+
  SELECT * INTO TABLE gt_tvko FROM tvko.
  SELECT * INTO TABLE gt_tvko FROM tvko.
+
 
+
  SELECT i~fkart
  SELECT i~fkart
+
        p~bukrs
          p~bukrs
+
        p~tdlnr
          p~tdlnr
+
        p~exti1
          p~exti1
+
        p~fknum
          p~fknum
+
        p~fkpos
          p~fkpos
+
        p~rebel
          p~rebel
+
        p~waers INTO CORRESPONDING FIELDS OF TABLE gt_header FROM vfkk AS i
          p~waers INTO CORRESPONDING FIELDS OF TABLE gt_header FROM vfkk AS i
+
                                        INNER JOIN vfkp AS p
                                        INNER JOIN vfkp AS p
+
                                                ON i~fknum = p~fknum
                                                ON i~fknum = p~fknum
+
                                            WHERE i~erdat IN s_erdat
                                            WHERE i~erdat IN s_erdat
+
                                              AND p~exti1 IN s_exti1
                                                AND p~exti1 IN s_exti1
+
                                              AND p~exti1 <> space
                                                AND p~exti1 <> space
+
                                              AND p~tdlnr = p_tdlnr.
                                                AND p~tdlnr = p_tdlnr.
+
 
+
  SELECT SINGLE name1 INTO g_name1 FROM lfa1 WHERE lifnr = p_tdlnr.
  SELECT SINGLE name1 INTO g_name1 FROM lfa1 WHERE lifnr = p_tdlnr.
+
 
+
  LOOP AT gt_header INTO wa_data.
  LOOP AT gt_header INTO wa_data.
+
    wa_data-name1 = g_name1.
    wa_data-name1 = g_name1.
 
 
    SELECT SINGLE tknum shtyp route signi vsart bfart vsbed sdabw
 
                          INTO wa_vttk FROM vttk  WHERE tknum = wa_data-rebel.
 
    IF sy-subrc = 0.
 
      wa_data-shtyp = wa_vttk-shtyp.
 
      wa_data-route = wa_vttk-route.
 
      wa_data-signi = wa_vttk-signi.
 
      wa_data-vsart = wa_vttk-vsart.
 
      wa_data-bfart = wa_vttk-bfart.
 
 
      l_domv = wa_data-bfart.
 
 
      CALL FUNCTION 'DOMAIN_VALUE_GET'
 
        EXPORTING
 
          i_domname  = 'BFART'
 
          i_domvalue = l_domv
 
        IMPORTING
 
          e_ddtext  = l_ddt
 
        EXCEPTIONS
 
          not_exist  = 1
 
          OTHERS    = 2.
 
      MOVE l_ddt TO wa_data-stext.
 
      wa_data-vsbed = wa_vttk-vsbed.
 
      wa_data-sdabw = wa_vttk-sdabw.
 
 
      SELECT SINGLE bezei INTO wa_data-bezei FROM  t173t
 
              WHERE  spras  = sy-langu
 
              AND    vsart  = wa_data-vsart.
 
 
      SELECT SINGLE vtext INTO wa_data-vtext FROM  tvsbt
 
              WHERE  spras  = sy-langu
 
              AND    vsbed  = wa_data-vsbed.
 
 
      SELECT SINGLE bezei INTO wa_data-bezei2  FROM  tvsakt
 
              WHERE  spras  = sy-langu
 
              AND    sdabw  = wa_data-sdabw.
 
 
      SELECT * INTO TABLE gt_vttp FROM vttp WHERE tknum = wa_vttk-tknum.
 
 
      IF gt_vttp[] IS NOT INITIAL.
 
        SELECT i~vkorg
 
                p~vbeln
 
                p~posnr
 
                p~matnr INTO TABLE gt_lips FROM likp AS i
 
                                    INNER JOIN lips AS p
 
                                            ON i~vbeln = p~vbeln FOR ALL ENTRIES IN gt_vttp
 
                                          WHERE i~vbeln = gt_vttp-vbeln.
 
 
        SELECT * INTO CORRESPONDING FIELDS OF TABLE gt_vfkn FROM vfkn WHERE fknum = wa_data-fknum
 
                                                                        AND fkpos = wa_data-fkpos.
 
 
        LOOP AT gt_lips INTO wa_lips.
 
          READ TABLE gt_tvko WITH TABLE KEY vkorg = wa_lips-vkorg.
 
          wa_data-bukrs = gt_tvko-bukrs.
 
 
          wa_data-vbeln = wa_lips-vbeln.
 
          wa_data-posnr = wa_lips-posnr.
 
          wa_data-matnr = wa_lips-matnr.
 
          wa_data-netwr_pro = p_monto / 100.
 
 
          READ TABLE gt_vfkn INTO wa_vfkn WITH KEY retyp = 'J'  "entrega
 
                                          fknum = wa_data-fknum
 
                                          fkpos = wa_data-fkpos
 
                                          rebel = wa_lips-vbeln
 
                                          repos = wa_lips-posnr.
 
          IF sy-subrc = 0.
 
            wa_data-netwr = wa_vfkn-netwr.
 
          ENDIF.
 
        ENDLOOP.
 
      ENDIF.
 
    ENDIF.
 
  ENDLOOP.
 
 
ENDFORM.</nowiki>
 
  
== Obtener icono de Camioncito en reportes ALV ==
+
    SELECT SINGLE tknum shtyp route signi vsart bfart vsbed sdabw
<nowiki> form get_vsart_text USING p_vsart CHANGING p_txt.
+
                        INTO wa_vttk FROM vttk  WHERE tknum = wa_data-rebel.
  data l_bezei type T173T-bezei.
+
    IF sy-subrc = 0.
  data  l_icon_shipping_type(100) TYPE c.
+
      wa_data-shtyp = wa_vttk-shtyp.
 +
      wa_data-route = wa_vttk-route.
 +
      wa_data-signi = wa_vttk-signi.
 +
      wa_data-vsart = wa_vttk-vsart.
 +
      wa_data-bfart = wa_vttk-bfart.
  
  if p_VSART is not INITIAL.
+
      l_domv = wa_data-bfart.
    SELECT  single bezei into l_bezei FROM  T173T
 
          WHERE  SPRAS  = sy-langu
 
          AND    VSART  = p_VSART.
 
    if sy-subrc = 0.
 
      move l_BEZEI to p_TXT.
 
  
      clear l_ICON_SHIPPING_TYPE.
+
       CALL FUNCTION 'DOMAIN_VALUE_GET'
       CALL FUNCTION 'ST_STAGE_ICON_SHIPPING_TYPE'
 
 
         EXPORTING
 
         EXPORTING
           I_SHIPPING_TYPE = p_VSART
+
           i_domname  = 'BFART'
         CHANGING
+
          i_domvalue = l_domv
           C_ICON          = l_ICON_SHIPPING_TYPE
+
         IMPORTING
 +
           e_ddtext  = l_ddt
 
         EXCEPTIONS
 
         EXCEPTIONS
           OTHERS         = 0.
+
          not_exist  = 1
 +
           OTHERS     = 2.
 +
      MOVE l_ddt TO wa_data-stext.
 +
      wa_data-vsbed = wa_vttk-vsbed.
 +
      wa_data-sdabw = wa_vttk-sdabw.
  
  * add the icons for the shipping types
+
      SELECT SINGLE bezei INTO wa_data-bezei FROM  t173t
       IF not l_icon_shipping_type is initial.
+
            WHERE  spras  = sy-langu
         CONCATENATE l_icon_shipping_type p_txt
+
            AND    vsart  = wa_data-vsart.
                    INTO p_txt SEPARATED BY space.
+
 
 +
      SELECT SINGLE vtext INTO wa_data-vtext FROM  tvsbt
 +
            WHERE spras  = sy-langu
 +
            AND    vsbed  = wa_data-vsbed.
 +
 
 +
      SELECT SINGLE bezei INTO wa_data-bezei2  FROM  tvsakt
 +
            WHERE  spras  = sy-langu
 +
            AND    sdabw  = wa_data-sdabw.
 +
 
 +
      SELECT * INTO TABLE gt_vttp FROM vttp WHERE tknum = wa_vttk-tknum.
 +
 
 +
       IF gt_vttp[] IS NOT INITIAL.
 +
         SELECT i~vkorg
 +
              p~vbeln
 +
              p~posnr
 +
              p~matnr INTO TABLE gt_lips FROM likp AS i
 +
                                    INNER JOIN lips AS p
 +
                                            ON i~vbeln = p~vbeln FOR ALL ENTRIES IN gt_vttp
 +
                                        WHERE i~vbeln = gt_vttp-vbeln.
 +
 
 +
        SELECT * INTO CORRESPONDING FIELDS OF TABLE gt_vfkn FROM vfkn WHERE fknum = wa_data-fknum
 +
                                                                        AND fkpos = wa_data-fkpos.
 +
 
 +
        LOOP AT gt_lips INTO wa_lips.
 +
          READ TABLE gt_tvko WITH TABLE KEY vkorg = wa_lips-vkorg.
 +
          wa_data-bukrs = gt_tvko-bukrs.
 +
 
 +
          wa_data-vbeln = wa_lips-vbeln.
 +
          wa_data-posnr = wa_lips-posnr.
 +
          wa_data-matnr = wa_lips-matnr.
 +
          wa_data-netwr_pro = p_monto / 100.
 +
 
 +
          READ TABLE gt_vfkn INTO wa_vfkn WITH KEY retyp = 'J'  "entrega
 +
                                        fknum = wa_data-fknum
 +
                                        fkpos = wa_data-fkpos
 +
                                        rebel = wa_lips-vbeln
 +
                                        repos = wa_lips-posnr.
 +
          IF sy-subrc = 0.
 +
            wa_data-netwr = wa_vfkn-netwr.
 +
          ENDIF.
 +
        ENDLOOP.
 
       ENDIF.
 
       ENDIF.
     endif.
+
     ENDIF.
  else.
+
  ENDLOOP.
    clear p_txt.
+
 
  endif.
+
ENDFORM.</nowiki>
 +
 
 +
===Obtener icono de Camioncito en reportes ALV ===
 +
<nowiki>form get_vsart_text USING p_vsart CHANGING p_txt.
 +
data l_bezei type T173T-bezei.
 +
data  l_icon_shipping_type(100) TYPE c.
 +
 
 +
if p_VSART is not INITIAL.
 +
  SELECT  single bezei into l_bezei FROM  T173T
 +
          WHERE  SPRAS  = sy-langu
 +
          AND    VSART  = p_VSART.
 +
  if sy-subrc = 0.
 +
    move l_BEZEI to p_TXT.
 +
 
 +
    clear l_ICON_SHIPPING_TYPE.
 +
    CALL FUNCTION 'ST_STAGE_ICON_SHIPPING_TYPE'
 +
      EXPORTING
 +
        I_SHIPPING_TYPE = p_VSART
 +
      CHANGING
 +
        C_ICON          = l_ICON_SHIPPING_TYPE
 +
      EXCEPTIONS
 +
        OTHERS          = 0.
 +
 
 +
* add the icons for the shipping types
 +
    IF not l_icon_shipping_type is initial.
 +
      CONCATENATE l_icon_shipping_type p_txt
 +
                  INTO p_txt SEPARATED BY space.
 +
    ENDIF.
 +
  endif.
 +
else.
 +
  clear p_txt.
 +
endif.
  
ENDFORM.</nowiki>
+
ENDFORM.</nowiki>

Latest revision as of 20:42, 5 April 2020

Programa y formulario impresión

programa: RV56TD00

FORM: SHIPMENT_DOC

Actualizar clase de mensaje

trn. V/82

Códigos Varios Transporte

Ejemplo 01

FORM get_data.
  SELECT * INTO TABLE gt_tvko FROM tvko.

  SELECT i~fkart
         p~bukrs
         p~tdlnr
         p~exti1
         p~fknum
         p~fkpos
         p~rebel
         p~waers INTO CORRESPONDING FIELDS OF TABLE gt_header FROM vfkk AS i
                                        INNER JOIN vfkp AS p
                                                ON i~fknum = p~fknum
                                            WHERE i~erdat IN s_erdat
                                               AND p~exti1 IN s_exti1
                                               AND p~exti1 <> space
                                               AND p~tdlnr = p_tdlnr.

  SELECT SINGLE name1 INTO g_name1 FROM lfa1 WHERE lifnr = p_tdlnr.

  LOOP AT gt_header INTO wa_data.
    wa_data-name1 = g_name1.

    SELECT SINGLE tknum shtyp route signi vsart bfart vsbed sdabw
                         INTO wa_vttk FROM vttk  WHERE tknum = wa_data-rebel.
    IF sy-subrc = 0.
      wa_data-shtyp = wa_vttk-shtyp.
      wa_data-route = wa_vttk-route.
      wa_data-signi = wa_vttk-signi.
      wa_data-vsart = wa_vttk-vsart.
      wa_data-bfart = wa_vttk-bfart.

      l_domv = wa_data-bfart.

      CALL FUNCTION 'DOMAIN_VALUE_GET'
        EXPORTING
          i_domname  = 'BFART'
          i_domvalue = l_domv
        IMPORTING
          e_ddtext   = l_ddt
        EXCEPTIONS
          not_exist  = 1
          OTHERS     = 2.
      MOVE l_ddt TO wa_data-stext.
      wa_data-vsbed = wa_vttk-vsbed.
      wa_data-sdabw = wa_vttk-sdabw.

      SELECT SINGLE bezei INTO wa_data-bezei FROM  t173t
             WHERE  spras  = sy-langu
             AND    vsart  = wa_data-vsart.

      SELECT SINGLE vtext INTO wa_data-vtext FROM  tvsbt
             WHERE  spras  = sy-langu
             AND    vsbed  = wa_data-vsbed.

      SELECT SINGLE bezei INTO wa_data-bezei2  FROM  tvsakt
             WHERE  spras  = sy-langu
             AND    sdabw  = wa_data-sdabw.

      SELECT * INTO TABLE gt_vttp FROM vttp WHERE tknum = wa_vttk-tknum.

      IF gt_vttp[] IS NOT INITIAL.
        SELECT i~vkorg
               p~vbeln
               p~posnr
               p~matnr INTO TABLE gt_lips FROM likp AS i
                                    INNER JOIN lips AS p
                                            ON i~vbeln = p~vbeln FOR ALL ENTRIES IN gt_vttp
                                         WHERE i~vbeln = gt_vttp-vbeln.

        SELECT * INTO CORRESPONDING FIELDS OF TABLE gt_vfkn FROM vfkn WHERE fknum = wa_data-fknum
                                                                        AND fkpos = wa_data-fkpos.

        LOOP AT gt_lips INTO wa_lips.
          READ TABLE gt_tvko WITH TABLE KEY vkorg = wa_lips-vkorg.
          wa_data-bukrs = gt_tvko-bukrs.

          wa_data-vbeln = wa_lips-vbeln.
          wa_data-posnr = wa_lips-posnr.
          wa_data-matnr = wa_lips-matnr.
          wa_data-netwr_pro = p_monto / 100.

          READ TABLE gt_vfkn INTO wa_vfkn WITH KEY retyp = 'J'   "entrega
                                         fknum = wa_data-fknum
                                         fkpos = wa_data-fkpos
                                         rebel = wa_lips-vbeln
                                         repos = wa_lips-posnr.
          IF sy-subrc = 0.
            wa_data-netwr = wa_vfkn-netwr.
          ENDIF.
        ENDLOOP.
      ENDIF.
    ENDIF.
  ENDLOOP.

ENDFORM.

Obtener icono de Camioncito en reportes ALV

form get_vsart_text USING p_vsart CHANGING p_txt.
 data l_bezei type T173T-bezei.
 data  l_icon_shipping_type(100) TYPE c.

 if p_VSART is not INITIAL.
   SELECT   single bezei into l_bezei FROM  T173T
          WHERE  SPRAS  = sy-langu
          AND    VSART  = p_VSART.
   if sy-subrc = 0.
     move l_BEZEI to p_TXT.

     clear l_ICON_SHIPPING_TYPE.
     CALL FUNCTION 'ST_STAGE_ICON_SHIPPING_TYPE'
       EXPORTING
         I_SHIPPING_TYPE = p_VSART
       CHANGING
         C_ICON          = l_ICON_SHIPPING_TYPE
       EXCEPTIONS
         OTHERS          = 0.

* add the icons for the shipping types
     IF not l_icon_shipping_type is initial.
       CONCATENATE l_icon_shipping_type p_txt
                   INTO p_txt SEPARATED BY space.
     ENDIF.
   endif.
 else.
   clear p_txt.
 endif.

ENDFORM.