1
Programación ABAP / Re: DUMP por entrada masiva en un select
« en: 10 de Marzo de 2011, 08:15:50 pm »
tengo el mismo problema, alguien me puede ayudar con esto!!!
SELECT c~werks c~matnr c~bwscl m~matkl m~meins m~mtart m~bstme e~lifnr e~relif
e~lifbi e~infnr e~ltsnr t~zone1 t~name1
INTO CORRESPONDING FIELDS OF TABLE t_output
FROM ( wlk1 AS w INNER JOIN marc AS c ON c~mandt = w~mandt
AND c~matnr = w~artnr
AND c~werks = p_werks
INNER JOIN mara AS m ON m~mandt = c~mandt
AND m~matnr = c~matnr
INNER JOIN eina AS e ON e~mandt = c~mandt
AND e~matnr = c~matnr
**** INNER JOIN mean AS n ON n~mandt = c~mandt
**** AND n~matnr = c~matnr
**** AND n~meinh = m~meins
INNER JOIN t001w AS t ON t~mandt = c~mandt
AND t~werks = p_werks
) CLIENT SPECIFIED
WHERE w~mandt = g_mandt
AND w~filia IN r_filia "EQ g_filia "p_werks
AND w~artnr IN s_matnr
AND w~datbi GE sy-datum
AND w~datab LE sy-datum
AND m~matkl IN r_matkl
and m~ersda in s_ersda
and m~mtart in s_mtart
AND c~bwscl IN s_bwscl
AND e~lifnr IN s_lifnr
AND e~relif IN r_relif
**** AND n~hpean = 'X'
**** AND ( ( e~lifbi GE sy-datum AND e~lifab LE sy-datum ) OR
**** ( e~lifbi = xfec ) )
AND c~mmsta IN r_mmsta
AND m~mstae IN r_mstae.
SELECT c~werks c~matnr c~bwscl m~matkl m~meins m~mtart m~bstme e~lifnr e~relif
e~lifbi e~infnr e~ltsnr t~zone1 t~name1
INTO CORRESPONDING FIELDS OF TABLE t_output
FROM ( wlk1 AS w INNER JOIN marc AS c ON c~mandt = w~mandt
AND c~matnr = w~artnr
AND c~werks = p_werks
INNER JOIN mara AS m ON m~mandt = c~mandt
AND m~matnr = c~matnr
INNER JOIN eina AS e ON e~mandt = c~mandt
AND e~matnr = c~matnr
**** INNER JOIN mean AS n ON n~mandt = c~mandt
**** AND n~matnr = c~matnr
**** AND n~meinh = m~meins
INNER JOIN t001w AS t ON t~mandt = c~mandt
AND t~werks = p_werks
) CLIENT SPECIFIED
WHERE w~mandt = g_mandt
AND w~filia IN r_filia "EQ g_filia "p_werks
AND w~artnr IN s_matnr
AND w~datbi GE sy-datum
AND w~datab LE sy-datum
AND m~matkl IN r_matkl
and m~ersda in s_ersda
and m~mtart in s_mtart
AND c~bwscl IN s_bwscl
AND e~lifnr IN s_lifnr
AND e~relif IN r_relif
**** AND n~hpean = 'X'
**** AND ( ( e~lifbi GE sy-datum AND e~lifab LE sy-datum ) OR
**** ( e~lifbi = xfec ) )
AND c~mmsta IN r_mmsta
AND m~mstae IN r_mstae.