SELECT
FEBEP~BELNR
PAGO~ZBUKR
PAGO~UBNKS
PAGO~UBNKL
PAGO~ZBNKS
PAGO~ZBNKL
PAGO~ZBNKN
PAGO~ZIBAN
PAGO~RWBTR
PAGO~WAERS
PAGO~ZNME1
PAGO~BKREF
PAGO~ZSTRA
PAGO~ZPSTL
PAGO~ZORT1
PAGO~ZLAND
* PAGO~AUGBL
PAGO~ZBUKR
INTO corresponding FIELDS OF TABLE ST_REGUH
FROM BSEG
INNER JOIN febep
ON febep~BELNR = BSEG~BELNR
INNER JOIN REGUH AS PAGO
ON BSEG~ZUONR = PAGO~VBLNR AND PAGO~ZBUKR = p_bukrs
INNER JOIN T001
ON T001~BUKRS = PAGO~ZBUKR UP TO 1 ROWS
WHERE febep~kukey = r_kukey AND
febep~esnum = r_esnum AND
BSEG~BUKRS = p_bukrs AND
BSEG~BUZEI = 1.
No hay comentarios:
Publicar un comentario
Comenta cualquier duda o recomendatorio.