Difference between revisions of "SAP SD Transporte"
From SapWiki
| Line 2: | Line 2: | ||
===Ejemplo 01=== | ===Ejemplo 01=== | ||
<nowiki>FORM get_data. | <nowiki>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.</nowiki> | |
== Obtener icono de Camioncito en reportes ALV == | == Obtener icono de Camioncito en reportes ALV == | ||
Revision as of 22:01, 4 April 2020
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.