21 lines
462 B
SQL
21 lines
462 B
SQL
SELECT
|
|
RTRIM(ZWCODE) AS zwcode,
|
|
ZWCOMP AS zwcomp,
|
|
RTRIM(ZWKEY1) AS zwkey1,
|
|
RTRIM(ZWKEY2) AS zwkey2,
|
|
RTRIM(ZWFIL1) AS zwfil1,
|
|
"ZWSAL#" AS "zwsal#",
|
|
"ZWELB#" AS "zwelb#",
|
|
"ZWINV#" AS "zwinv#",
|
|
"ZWDSC#" AS "zwdsc#",
|
|
"ZWEXB#" AS "zwexb#",
|
|
"ZWEXM#" AS "zwexm#",
|
|
"ZWEXO#" AS "zwexo#",
|
|
"ZWFRT#" AS "zwfrt#",
|
|
"ZWDEP#" AS "zwdep#",
|
|
RTRIM(ZWFIL2) AS zwfil2,
|
|
ZWEXBF AS zwexbf,
|
|
ZWWCOS AS zwwcos,
|
|
RTRIM(ZWPLNT) AS zwplnt
|
|
FROM LGDAT.ARMASC
|