ƒRƒ“ƒeƒ“ƒcƒtƒŒ[ƒ€‹N“ź

ƒNƒ‰ƒXƒ^ƒf[ƒ^ƒx[ƒX‚ւ̃f[ƒ^ƒIƒuƒWƒFƒNƒg‚ÌŠi”[ •¶‘‚đ SAP ƒ‰ƒCƒuƒ‰ƒŠƒXƒgƒ‰ƒNƒ`ƒƒ‚É‘g‚ʍž‚Ț

ƒf[ƒ^ƒIƒuƒWƒFƒNƒg‚đ ABAP ƒvƒƒOƒ‰ƒ€‚©‚çƒNƒ‰ƒXƒ^ƒf[ƒ^ƒx[ƒX‚ÉŠi”[‚·‚éê‡‚́AˆÈ‰ș‚Ì–œ—ß‚đŽg—p‚”‚Ü‚·B

\•¶

EXPORT <f 1> [FROM <g 1>] <f 2> [FROM <g 2>] ...
TO DATABASE <dbtab>(<ar>) [CLIENT <cli>] ID <key>.

‚±‚Ì–œ—߂ɂæ‚èAˆê——’†‚ÉŽw’è‚ł‚ê‚Ä‚ą‚éƒf[ƒ^ƒIƒuƒWƒFƒNƒg‚̓Nƒ‰ƒXƒ^‚Æ‚”‚āAƒNƒ‰ƒXƒ^ƒf[ƒ^ƒx[ƒX <dbtab> ‚ɕۑ¶‚ł‚ê‚Ü‚·B <dbtab> ‚đ TABLES –œ—ß‚ĆéŒŸ‚”‚Ä‚š‚©‚È‚Ż‚ê‚΂Ȃè‚Ü‚č‚ńBƒIƒvƒVƒ‡ƒ“ FROM <g i> ‚đÈ—Ș‚·‚邯Aƒf[ƒ^ƒIƒuƒWƒFƒNƒg <f i> ‚́A‚»‚̂܂܂̖ŒÌ‚ĆŠi”[‚ł‚ê‚Ü‚·B FROM <g i> ‚đŽw’è‚·‚邯Aƒf[ƒ^ƒIƒuƒWƒFƒNƒg <g i> ‚Ș <f i> ‚Æ‚ą‚€–ŒÌ‚ĆŠi”[‚ł‚ê‚Ü‚·B

<ar> ‚́AƒNƒ‰ƒXƒ^‚đƒf[ƒ^ƒx[ƒX‚ÉŠi”[‚·‚éÛ‚ÉŽg—p‚ł‚ê‚é‚Q•¶Žš‚̗̈æ ID ‚Ć‚·B
i ƒNƒ‰ƒXƒ^ƒf[ƒ^ƒx[ƒX‚̍\‘ą‚Ì‚Q”Ô‚đŽQÆ‚”‚Ä‚­‚Ÿ‚ł‚ąjB

<key> ‚́AĆ‘ć’·‚Ș <dbtab> ‚Ì–ŒÌ€–Ú‚Ì’·‚ł‚É‚æ‚Á‚ĈقȂèAƒf[ƒ^ƒx[ƒX‚̃f[ƒ^‚đŽŻ•Ê‚”‚Ü‚·B
i ƒNƒ‰ƒXƒ^ƒf[ƒ^ƒx[ƒX‚̍\‘ą‚Ì‚R”Ô‚đŽQÆ‚”‚Ä‚­‚Ÿ‚ł‚ąjB

ƒIƒvƒVƒ‡ƒ“‚Ì CLIENT <cli> ‚đŽg—p‚·‚ê‚΁AƒNƒ‰ƒCƒAƒ“ƒg“ÆŽ©‚̃Nƒ‰ƒXƒ^ƒf[ƒ^ƒx[ƒX‚đˆ”‚€Û‚ɁAŽ©“źƒNƒ‰ƒCƒAƒ“ƒgˆ—‚đƒIƒt‚É‚”‚āAŽ©•Ș‚ĆƒNƒ‰ƒCƒAƒ“ƒg‚đŽw’è‚·‚邱‚Æ‚Ș‚Ć‚«‚Ü‚·B‚±‚̃IƒvƒVƒ‡ƒ“‚̓f[ƒ^ƒx[ƒX–Œ‚Ì’ŒŒă‚ÉŽw’è‚”‚È‚Ż‚ê‚΂Ȃè‚Ü‚č‚ńB
i ƒNƒ‰ƒXƒ^ƒf[ƒ^ƒx[ƒX‚̍\‘ą‚Ì‚P”Ô‚đŽQÆ‚”‚Ä‚­‚Ÿ‚ł‚ąjB

EXPORT –œ—߂́Aƒe[ƒuƒ‹ì‹Æ—̈æ <dbtab> ‚̃†[ƒU€–Ú‚Ì“à—e‚àƒf[ƒ^ƒx[ƒXƒe[ƒuƒ‹‚É“]‘—‚”‚Ü‚·B‚±‚ê‚ç‚̍€–Ú‚Í•K—v‚ɉž‚¶‚Đæ‚ɏ‘‚«ž‚ń‚Ć‚š‚­‚±‚Æ‚Ș‰Â”\‚Ć‚·B
i ƒNƒ‰ƒXƒ^ƒf[ƒ^ƒx[ƒX‚̍\‘ą‚Ì‚T”Ô‚đŽQÆ‚”‚Ä‚­‚Ÿ‚ł‚ąjB

EXPORT –œ—߂́Aí‚É“ŻˆêƒNƒ‰ƒCƒAƒ“ƒg <cli> “à‚Ì“Żˆê—̈æ <ar> “à‚É‚ ‚铯ˆê–ŒÌ < ƒL[ > ‚đŽ‚Á‚œŠù‘¶‚̃f[ƒ^ƒNƒ‰ƒXƒ^‚Ì“à—e‚đAŠź‘S‚Éă‘‚«‚”‚Ü‚·B

’‹L

ƒwƒbƒ_s‚đŽ‚Á‚œ“à•”ƒe[ƒuƒ‹‚̏ꍇ‚́Aƒe[ƒuƒ‹–{‘Ì‚”‚©Ši”[‚·‚邱‚Æ‚Ș‚Ć‚«‚žAƒwƒbƒ_s‚đŠi”[‚·‚邱‚Æ‚Í‚Ć‚«‚Ü‚č‚ńB EXPORT –œ—߂̏ꍇ‚̓e[ƒuƒ‹–Œ‚̓e[ƒuƒ‹‚ƉđŽß‚ł‚ê‚Ü‚·B’ʏíA–œ—߂̓e[ƒuƒ‹–Œ‚đƒe[ƒuƒ‹ì‹Æ—Ìˆæ‚Æ‚”‚ĉđŽß‚·‚邯‹K’è‚”‚Ä‚ą‚éˆê”Ê“I‚È‹K‘„‚©‚点‚Š‚ÎA‚±‚ê‚Í—áŠO‚É‚ ‚œ‚è‚Ü‚·i “à•”ƒe[ƒuƒ‹‚Ì‘I‘đ‚đŽQÆ‚”‚Ä‚­‚Ÿ‚ł‚ąjB

—á

PROGRAM SAPMZTS1.

TABLES INDX.

DATA: BEGIN OF ITAB OCCURS 100,
COL1 TYPE I,
COL2 TYPE I,
END OF ITAB.

DO 3000 TIMES.
ITAB-COL1 = SY-INDEX.
ITAB-COL2 = SY-INDEX ** 2.
APPEND ITAB.
ENDDO.

INDX-AEDAT = SY-DATUM.
INDX-USERA = SY-UNAME.
INDX-PGMID = SY-REPID.

EXPORT ITAB TO DATABASE INDX(HK) ID ' ƒe[ƒuƒ‹ '.

WRITE: ' SRTF2',
AT 20 'AEDAT',
AT 35 'USERA',
AT 50 'PGMID'.
ULINE.

SELECT * FROM INDX WHERE RELID = 'HK'
AND SRTFD = '
ƒe[ƒuƒ‹ '.

WRITE: / INDX-SRTF2 UNDER 'SRTF2',
INDX-AEDAT UNDER 'AEDAT',
INDX-USERA UNDER 'USERA',
INDX-PGMID UNDER 'PGMID'.

ENDSELECT.

“à•”ƒe[ƒuƒ‹ ITAB ‚É‚Í 3000 s“ü‚Á‚Ä‚š‚èA’l‚đ INDX ‚̈ꕔ‚̃†[ƒU€–Ú‚ÉŠ„‚è“–‚Ă邯A ITAB ‚Í INDX ‚ɃGƒNƒXƒ|[ƒg‚ł‚ê‚Ü‚·B

INDX ‚ÍƒŠƒŒ[ƒVƒ‡ƒiƒ‹ƒf[ƒ^ƒx[ƒX‚È‚Ì‚ĆAƒI[ƒvƒ“ SQL –œ—ß‚đŽw’è‚”‚čs‚đŒÂ•ʂɃAƒhƒŒƒXŽw’è‚·‚邱‚Æ‚Ș‚Ć‚«‚Ü‚·B SELECT –œ—߂̏ꍇA EXPORT ‚ĆŠi”[‚”‚œs‚đA“K“–‚È WHERE đŒ‚É‚æ‚Á‚Ä‘I‘đ‚”‚Ü‚·B

ƒf[ƒ^ƒx[ƒX€–ڂ̏o—͈͂ȉș‚̂悀‚ɂȂè‚Ü‚·B

‚±‚̃Oƒ‰ƒtƒBƒbƒN‚Í“Y•t‚̃eƒLƒXƒg‚Éà–Ÿ‚ł‚ê‚Ä‚ą‚Ü‚·

‚±‚±‚Ƃ́Ao—Í‚đŒ©‚é‚ÆAƒ†[ƒU€–Ú AEDAT A USERA A PGMID ‚Í EXPORT ‚É‚æ‚Á‚Ä“]‘—‚ł‚êA ITAB ‚Ș“ü‚Á‚Ä‚ą‚éƒf[ƒ^ƒNƒ‰ƒXƒ^‚Í‚Us‚Ÿ‚ŻŠg’Ł‚ł‚ê‚Ä‚ą‚邱‚Æ‚Ș‚í‚©‚è‚Ü‚·B DO –œ—߂̐” 3000 ‚đ•ύX‚·‚邯A‚±‚̃f[ƒ^ƒNƒ‰ƒXƒ^‚ɐè—L‚ł‚ê‚Ä‚ą‚és”‚à•Ï‚í‚è‚Ü‚·B

 

 

 

ƒRƒ“ƒeƒ“ƒcƒtƒŒ[ƒ€I—č