HANA
好好学习,努力工作
这个作者很懒,什么都没留下…
展开
-
生产任务清单
SELECT T0."DocEntry",T0."DocNum" "生产订单号",T1."DocEntry" "销售订单号",case when T0."Status"='P' then '已计划' when T0."Status"='R' then '已批准' when T0."Status"='L' then '已结算' end "工单状态", T1."NumAtCard" "合同号", T0."ItemCode",T2."U_EJFL", T2."U_SJFL", T2."U_Z20_SPEC",原创 2021-03-13 08:30:05 · 150 阅读 · 0 评论 -
SBO采购入库单
采购入库单SELECT T0."DocEntry", T0."DocNum",T1."U_Z20_SNAC", T0."CardCode", T0."CardName", T1."ItemCode", T1."Dscription",T2."U_Z20_SPEC",T2."U_CHXH",T0."DocDate" "收货日期" , t6."BinCode" "库位",T1."Quantity" "已入库", T1."OpenQty" "未开票" FROM OPDN T0 INNER JOIN PDN原创 2021-03-10 08:19:16 · 231 阅读 · 1 评论 -
HANA Studio 备份数据库
备份HANA数据库直接在consol里面操作即可,也可登录到数据库操作/*备份MOMA账套到指定文件夹*/export "SJ_ZS"."*" as binary into '/hana/log/backup/SJ_ZS20210306' with replace threads 10/*导入指定文件夹MOMA账套备份,重命名账套为CS*/import "SJ_ZS"."*" as binary from '/hana/log/backup/SJ_ZS20210306' with ignore原创 2021-03-08 08:17:44 · 479 阅读 · 0 评论