SELECT
"BKPF"."MANDT" AS "클라이언트",
"BKPF"."BUKRS" AS "회사코드",
"BKPF"."BELNR" AS "전표번호",
"BKPF"."GJAHR" AS "회계연도",
"BKPF"."BLART" AS "전표유형",
"BKPF"."BLDAT" AS "증빙일자",
"BKPF"."BUDAT" AS "전기일자",
"BKPF"."CPUDT" AS "작성일자",
"BKPF"."USNAM" AS "작성자ID",
"BKPF"."BKTXT" AS "전표적요",
"BKPF"."XSTOV" AS "역분개구분"
FROM
"SO"."BKPF" "BKPF"
SELECT
"ZBSEG2"."MANDT" AS "클라이언트",
"ZBSEG2"."BUKRS" AS "회사코드",
"ZBSEG2"."BELNR" AS "전표번호",
"ZBSEG2"."GJAHR" AS "회계연도",
"ZBSEG2"."BUZEI" AS "전표행번",
"ZBSEG2"."SHKZG" AS "차변대변구분",
"ZBSEG2"."DMBTR" AS "전표금액통화",
"ZBSEG2"."WRBTR" AS "전표금액원화",
"ZBSEG2"."SGTXT" AS "라인적요",
"ZBSEG2"."KOSTL" AS "KOSTL",
"ZBSEG2"."HKONT" AS "계정코드",
"ZBSEG2"."BUPLA" AS "BUPLA"
FROM
"SO"."ZBSEG2" "BSEG"