Ver Mensaje Individual
  #4  
Viejo 02/05/13, 13:51:20
nmarquez1974 nmarquez1974 is offline
Member
 
Fecha de Ingreso: abr 2012
Mensajes: 36
leer bkpf y bseg


hola Jarpi, este seria el codigo de la consulta

FORM CONSULTA.
CLEAR: T_DOC, T_BKPF.
REFRESH: T_DOC, T_BKPF.
*----------------------------------------------------------

*"LECTURA DE TABLA BSEG
SELECT BSEG~BELNR AS DOCTO
BSEG~BUZEI AS POS
BSEG~SHKZG AS DEBHAB
BSEG~DMBTR AS VALOR
BSEG~HKONT AS CTA
BSEG~BUKRS AS BUKRS
BSEG~GJAHR AS GJAHR


APPENDING CORRESPONDING FIELDS OF TABLE T_DOC

FROM
BSEG


WHERE BSEG~BUKRS = '1100'.


"*---------------------------------------------------------------------------------
SELECT BKPF~BLDAT AS FECREG
BKPF~BUDAT AS FECONT
BKPF~CPUTM AS HORA
BKPF~USNAM AS USUARIO
BKPF~BELNR AS BELNR
BKPF~BUKRS AS BUKRS
BKPF~GJAHR AS GJAHR

INTO TABLE T_BKPF

FROM
BKPF

FOR ALL ENTRIES IN T_DOC

WHERE BKPF~BUKRS = T_DOC-BUKRS AND
BKPF~BELNR = T_DOC-BELNR AND
BKPF~BSTAT <> 'S' AND
BKPF~BLDAT => FECHA-low AND
BKPF~BLDAT <= FECHA-high.
Responder Con Cita