Originale zu DVS-Dokumenten herunterladen

Code: Alles auswählen.

BEGRU	BEGRU
DOKAR	DOKAR
DOKNR	DOKNR
DOKVR	DOKVR
DOKTL	DOKTL_D
LO_OBJID	SDOK_LOID
LO_CLASS	SDOK_LOCL
STOR_CAT	SDOK_STCAT
LOIO_ID	SDOK_LOID
CHNG_USER	SDOK_CHUSR
CHNG_TIME	SDOK_CHTST
PHIO_ID	SDOK_PHID
FILE_NUM	SDOK_FNUMB
PH_CLASS	SDOK_PHCL
DOC_FORMAT	SDOK_FORM
DOC_FMTVER	SDOK_FMVER
MIMETYPE	W3CONTTYPE
FILE_SIZE	SDOK_FSIZE
FILE_NAME	SDOK_FILNM
FILE_TYPE	SDOK_TRFMD

Code: Alles auswählen.

SELECT draw~begru dms_doc2loio~dokar dms_doc2loio~doknr dms_doc2loio~dokvr dms_doc2loio~doktl dms_doc2loio~lo_objid
       dms_ph_cd1~lo_class dms_ph_cd1~stor_cat dms_ph_cd1~loio_id dms_ph_cd1~chng_user dms_ph_cd1~chng_time
       dms_phf_cd1~phio_id dms_phf_cd1~file_num dms_phf_cd1~ph_class
       dms_phf_cd1~doc_format dms_phf_cd1~doc_fmtver dms_phf_cd1~mimetype dms_phf_cd1~file_size dms_phf_cd1~file_name
       dms_phf_cd1~file_type
FROM ( draw
       INNER JOIN dms_doc2loio
       ON  dms_doc2loio~dokar = draw~dokar
       AND dms_doc2loio~doknr = draw~doknr
       AND dms_doc2loio~doktl = draw~doktl
       AND dms_doc2loio~dokvr = draw~dokvr
       INNER JOIN dms_ph_cd1
       ON  dms_ph_cd1~loio_id = dms_doc2loio~lo_objid
       INNER JOIN dms_phf_cd1
       ON  dms_phf_cd1~phio_id = dms_ph_cd1~phio_id )
       INTO TABLE t_drawx.