克米亚sap论坛,中国最好的sap论坛,sap系统,sap培训,kemiya,克米亚,sap账号,sap ides,sap mm,sap hana,sap fico,sap pp

 找回密码
 注册
查看: 2479|回复: 27

SAP HANA Studio 建模

[复制链接]
kmy 发表于 2013-10-27 17:13:57 | 显示全部楼层 |阅读模式
创建表:
Person表:
ID VARCHAR 3
NAME VARCHAR 20
LAST_NAME VARCHAR 30
DOB VARCHAR 8

Create ROW Table Person(
ID VARCHAR(3) PRIMARY KEY,
NAME VARCHAR(20),
LAST_NAME VARCHAR(30),
DOB VARCHAR(8)
)

PROJECT表:
ID VARCHAR 3 Key Field
NAME VARCHAR 20 Key Field
RESOURCES INTEGER
BUDGET DECIMAL 8,2
Create Column Table PROJECT(
ID VARCHAR(3) NOT NULL,
NAME VARCHAR(20) NOT NULL,
RESOURCES integer,
BUDGET decimal(8,2),
PRIMARY KEY(ID,NAME)
)


插入数数据:
insert into "P1526659201"."PERSON" values('001','John','Smith','19750112');
insert into "P1526659201"."PERSON" values('002','John','Doe','19800101');
insert into "P1526659201"."PERSON" values('003','Joe','Page','19760228');
insert into "P1526659201"."PERSON" values('004','Sally','Ryan','19771230');
insert into "P1526659201"."PERSON" values('005','John','Sanders','19451122');
insert into "P1526659201"."PERSON" values('006','Peter','McDonald','19670818');
insert into "P1526659201"."PERSON" values('007','Mike','Melvin','19750812');
insert into "P1526659201"."PERSON" values('008','Chris','Jones','19750813');
insert into "P1526659201"."PERSON" values('009','Daniel','Stone','19720726');
insert into "P1526659201"."PERSON" values('010','Judy','Jones','19701210');
insert into "P1526659201"."PERSON" values('011','Mike','Peters','19810404');
insert into "P1526659201"."PERSON" values('012','Joshua','Reynolds','19750217');
insert into "P1526659201"."PERSON" values('013','Anne','Word','19710310');
insert into "P1526659201"."PERSON" values('014','Jeff','Field','19681215');
insert into "P1526659201"."PERSON" values('015','Megan','Ford','19700909');

insert into "P1526659201"."PROJECT" values('001','ABAP Models',2,10456.34);
insert into "P1526659201"."PROJECT" values('001','ABAP on Eclipse',5,20000.00);
insert into "P1526659201"."PROJECT" values('001','ABAP on HANA',2,45500.00);
insert into "P1526659201"."PROJECT" values('002','SUP Apps',3,3567.12);
insert into "P1526659201"."PROJECT" values('003','Code Refactoring',1,5120.50);
insert into "P1526659201"."PROJECT" values('004','SAPScript convertion',5,567.90);
insert into "P1526659201"."PROJECT" values('004','Adobe Forms Docs',2,345.19);
insert into "P1526659201"."PROJECT" values('004','Smart Forms Docs',6,462.10);
insert into "P1526659201"."PROJECT" values('004','Smart/Adobe Forms',2,234.90);
insert into "P1526659201"."PROJECT" values('005','HANA Apps',2,50000.00);
insert into "P1526659201"."PROJECT" values('005','BW on HANA',4,50000.00);
insert into "P1526659201"."PROJECT" values('006','Flex Apps',7,3500.50);
insert into "P1526659201"."PROJECT" values('006','Dashboards',3,2345.29);
insert into "P1526659201"."PROJECT" values('006','XCelsius',4,5678.10);
insert into "P1526659201"."PROJECT" values('007','ABAP Classes',2,1250.10);
insert into "P1526659201"."PROJECT" values('008','OSS Notes',2,2500.00);
insert into "P1526659201"."PROJECT" values('009','SUP Killer Apps',2,5600.50);
insert into "P1526659201"."PROJECT" values('009','SAP Gateway',7,5800.00);
insert into "P1526659201"."PROJECT" values('009','SUP and Gateway',5,5678.00);
insert into "P1526659201"."PROJECT" values('010','Blue Ruby',6,3500.00);
insert into "P1526659201"."PROJECT" values('010','Blue Python',4,3500.00);
insert into "P1526659201"."PROJECT" values('011','ABAP Editor',5,4000.00);
insert into "P1526659201"."PROJECT" values('011','ABAP Debugger',5,2000.00);
insert into "P1526659201"."PROJECT" values('012','EP',5,8500.50);
insert into "P1526659201"."PROJECT" values('012','KM',5,6500.50);
insert into "P1526659201"."PROJECT" values('012','MI',3,4500.50);
insert into "P1526659201"."PROJECT" values('013','SAP Education',6,5000.00);
insert into "P1526659201"."PROJECT" values('013','Certifications',3,3000.00);
insert into "P1526659201"."PROJECT" values('014','SAP FI',4,500.50);
insert into "P1526659201"."PROJECT" values('014','SAP SD',6,400.50);
insert into "P1526659201"."PROJECT" values('014','SAP CO',3,500.40);
insert into "P1526659201"."PROJECT" values('014','SAP MM',7,400.50);
insert into "P1526659201"."PROJECT" values('014','SAP WM',2,300.99);
insert into "P1526659201"."PROJECT" values('015','Research',1,5000.00);
insert into "P1526659201"."PROJECT" values('015','Development',4,8000.00);

创建Area表:
ID VARCHAR 3 Key field
AREA VARCHAR 20
create column table area (
id varchar(3) primary key,
area varchar(20)
);
获取连接SAP HANA服务器的FTP账号的相关信息:
SELECT * FROM SYSTEM.FTP_SERVER


创建文件Area.ctl,并把Area.ctl上传到 /BLOG,Area.ctl文件内容为
import data into table P1526659201."AREA"
from 'Area.csv'
record delimited by '\n'
fields delimited by ','
optionally enclosed by '"'
error log 'Area.err'
打开SQL Edit执行导入数据语句:
IMPORT FROM '/dropbox/Blag/Area.ctl';
danielanlin 发表于 2013-11-22 09:53:55 | 显示全部楼层
good example!
hitech 发表于 2014-3-5 11:21:08 | 显示全部楼层
文件:  Area.csv ?
leocodg 发表于 2014-3-5 13:35:22 | 显示全部楼层
good example!
hongjer 发表于 2015-10-22 11:28:44 | 显示全部楼层
看不懂ㄟ
要實際操作過程
cp8086 发表于 2015-12-4 12:24:42 | 显示全部楼层
非常好,赞一个!
sapguru123 发表于 2017-7-13 17:14:10 | 显示全部楼层
kemiya
hk612186 发表于 2017-7-14 05:10:48 | 显示全部楼层
sap hana
all01 发表于 2017-7-14 08:14:31 | 显示全部楼层
sap mm
sapguru123 发表于 2017-7-14 09:39:28 | 显示全部楼层
SAP资料下载
hk612186 发表于 2017-7-14 16:44:39 | 显示全部楼层
SAP学习文档
linhai 发表于 2017-9-4 16:42:08 | 显示全部楼层
克米亚
psalty 发表于 2017-9-4 22:06:03 | 显示全部楼层
为SAP最终用户,咨询伙伴, 人才猎头,资深顾问以及第三方产品供应商等提供综合性服务。
autostate 发表于 2017-9-5 02:44:20 | 显示全部楼层
SAP论坛
kingsley 发表于 2017-9-5 05:24:32 | 显示全部楼层
SAP公司面试
您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|克米亚sap论坛,sap账号,sap系统,sap ides,sap学习机,sap练习环境 ( 渝ICP备18002525号-5 )

GMT+8, 2019-1-18 18:33

Powered by Discuz! X3.4

© 2001-2017 Comsenz Inc.

快速回复 返回顶部 返回列表