Use the column checkboxes to build your query. Header columns sets/unsets all columns
SELECT MANDT, CMSTID, CMPERSL, CMSCID, CMPERYR, CMPERID, CMSCCAT, CMENTYEAR, CMSTAGE, CMPTIME, CMSCLENGTH, CMSCTUNIT, CMSCREGDAT, CMSCCAID, CMSCREGP1, CMSCREGP2, CMSCWDDAT, CMSCWDTYP, CMSCDREGP1, CMSCDREGP2, CMSCORG, CMSCCOCD, CMSCMAIN, CMSCDREGR, CMREGTYPE, CMSCLABSR, CMCANCTYPE, CMCANCREAN, CMCANCDATE, CMPERCT, CMREPSTAGE, CMCPTHD, CMSCCPUNIT, CMFVALTHD, CMSCMVUNIT, CMSCKEYDAT, CMCHOICE, CMCATEG, CMSCDDSHED, CMPROGCLS, CMREGCLS, CMSTATUS, CMSTATE, CMENRCATEG, CMPROGCVAR, CMACST, CMACST_STATUS, CMACSTFA, CMACSTFA_STATUS, CMPRCL, CMPRCL_STATUS, CMPRCLFA, CMPRCLFA_STATUS, CMAWARD, CMAWARD_STATUS, CMCGOBJID, CMSCGRPVAR, CMCGFEECAT, CMCGCATEG FROM TCMAC_SC