资源描述:
《金蝶kingdee-K3系统-BOM多级展开-SQL递归查询-数据接口-查询分析报表.docx》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、金蝶kingdeeK3系统BOM多级展开,SQL语句,数据接口,查询分析报表CREATETABLEt_IC_Item(FItemIDint,FNumbervarchar(200),FNamevarchar(200),FModelvarchar(200),FUnitIDint,FErpClsIDint)INSERTt_IC_ItemSELECT1,'CP.001','产品1','产品规格1',1,2UNIONSELECT2,'BC.001','半成品1','半成品规格1',1,2UNIONSELECT3,'BC.002','半成品2','半成
2、品规格2',1,2UNIONSELECT4,'BC.003','半成品3','半成品规格3',1,3UNIONSELECT5,'BC.004','半成品4','半成品规格4',1,2UNIONSELECT6,'ZC.001','主材料1','主材料规格1',1,1UNIONSELECT7,'ZC.002','主材料2','主材料规格2',1,1UNIONSELECT8,'ZC.003','主材料3','主材料规格3',1,1UNIONSELECT9,'ZC.004','主材料4','主材料规格4',1,1UNIONSELECT10,'ZC.
3、005','主材料5','主材料规格5',1,1UNIONSELECT11,'ZC.006','主材料6','主材料规格6',1,1UNIONSELECT12,'ZC.007','主材料7','主材料规格7',1,1UNIONSELECT13,'ZC.008','主材料8','主材料规格8',1,1UNIONSELECT14,'ZC.009','主材料9','主材料规格9',1,1UNIONSELECT15,'ZC.010','主材料10','主材料规格10',1,1UNIONSELECT16,'ZC.011','主材料11','主材料规格
4、11',1,1UNIONSELECT17,'ZC.012','主材料12','主材料规格12',1,1CREATETABLEt_Unit(FIDint,FNamevarchar(20))INSERTt_UnitSELECT1,'个'CREATETABLEt_BOM(FIDint,FBomNovarchar(200),FItemIDint,FQtydecimal(28,10),FUnitIDint)INSERTt_BOMSELECT1,'BOM01',1,1,1UNIONSELECT2,'BOM02',2,1,1UNIONSELECT3,'B
5、OM03',3,1,1UNIONSELECT4,'BOM04',4,1,1UNIONSELECT5,'BOM05',5,1,1CREATETABLEt_BOMChild(FIDint,FEntryIDint,FItemIDint,FQtydecimal(28,10),FUnitIDint)INSERTt_BOMChildSELECT1,1,2,1,1UNIONSELECT1,2,3,1,1UNIONSELECT1,3,15,1,1UNIONSELECT1,4,17,1,1UNIONSELECT2,1,6,1,1UNIONSELECT2,2,
6、7,1,1UNIONSELECT3,1,8,1,1UNIONSELECT3,2,9,1,1UNIONSELECT3,3,7,1,1UNIONSELECT3,4,4,1,1UNIONSELECT4,1,10,1,1UNIONSELECT4,2,11,1,1UNIONSELECT4,3,5,1,1/*UNIONSELECT5,1,12,1,1UNIONSELECT5,2,13,1,1UNIONSELECT5,3,14,1,1UNIONSELECT5,4,16,1,1UNIONSELECT5,5,7,1,1*/GOcreateprocedures
7、p_testasbegindeclare@iintdeclare@ttable(Levelint,Codevarchar(40),FItemIDint,FNumbervarchar(20),FNamevarchar(20),FModelvarchar(20),FErpClsIDint,FQtyint,FName1varchar(20),Statusvarchar(20))declare@t1table(idintidentity(1,1),Levelvarchar(10),Codevarchar(40),FItemIDint,FNumber
8、varchar(20),FNamevarchar(20),FModelvarchar(20),FErpClsIDvarchar(20),FQtyint,FName1varchar