drop table bsid;
CREATE TABLE bsid (
mandt text,
bukrs text,
kunnr text,
umsks text,
umskz text,
augdt timestamp,
augbl text,
zuonr text,
gjahr integer,
belnr text,
buzei integer,

blart text,
waers text,
wrbtr numeric(13,2),
shkzg text,
PRIMARY KEY (mandt, bukrs, kunnr, umsks, umskz, augdt, augbl, zuonr, gjahr, belnr, buzei)
)
Distributed by (mandt, bukrs, kunnr, umsks, umskz, augdt, augbl, zuonr, gjahr, belnr, buzei);

alter table bsid add column budat timestamp;

alter table bsid add column zfbdt timestamp;
alter table bsid add column dqsjc timestamp;
alter table bsid add column budatc text;
alter table bsid add column vbeln text;
alter table bsid add column zterm text;

alter table bsid add column budatd text;

alter table bsid add column hashResult text;
alter table bsid add column rowNum serial;

alter table bsid add column augdts text;
alter table bsid add column buzeis text;
alter table bsid add column pernr text;
