SAP Business One 9.2 表清单之一

SAP BUSINESS ONE 9.2 系统表清单之一

USE [SBO-COMMON]
GO

SELECT TOP 90 * FROM [SXRPR]  -- 38750

--  2052:简体中文
SELECT TOP 900 * FROM [SXRTE] WHERE Language =2052   -- 21050
SELECT TOP 90 * FROM [SXRRE]  -- 8235
SELECT TOP 90 * FROM [SXROB]  -- 4614
SELECT TOP 90 * FROM [SHQR]  -- 2864

-- 系统存储过程记录表
SELECT TOP 90 * FROM [SCSP]  -- 2246
SELECT TOP 90 * FROM [SDRQ]  -- 1675
SELECT TOP 90 * FROM [SLSC]  -- 254
SELECT TOP 90 * FROM [SXRPD]  -- 60
SELECT TOP 90 * FROM [SDRF]  -- 59
SELECT TOP 90 * FROM [SXREV]  -- 46
SELECT TOP 90 * FROM [SLSD]  -- 39
SELECT TOP 90 * FROM [SHLP]  -- 27
SELECT TOP 90 * FROM [SEULA]  -- 11
SELECT TOP 90 * FROM [SDRR]  -- 10
SELECT TOP 90 * FROM [SDRC]  -- 9
SELECT TOP 90 * FROM [SXRCD]  -- 9
SELECT TOP 90 * FROM [SXRNO]  -- 8
SELECT TOP 90 * FROM [SXRET]  -- 7
SELECT TOP 90 * FROM [SLOGR]  -- 2
SELECT TOP 90 * FROM [SARI]  -- 1
SELECT TOP 90 * FROM [SCAB]  -- 1
SELECT TOP 90 * FROM [SCFG]  -- 1
SELECT TOP 90 * FROM [SCUC]  -- 1
SELECT TOP 90 * FROM [SDRO]  -- 1
SELECT TOP 90 * FROM [SEVT]  -- 1
SELECT TOP 90 * FROM [SEWHW]  -- 1
SELECT TOP 90 * FROM [SEWLA]  -- 1
SELECT TOP 90 * FROM [SEWSY]  -- 1
SELECT TOP 90 * FROM [SINF]  -- 1
SELECT TOP 90 * FROM [SLIC]  -- 1
SELECT TOP 90 * FROM [SLOG]  -- 1
SELECT TOP 90 * FROM [SLSP]  -- 1
SELECT TOP 90 * FROM [SRGC]  -- 1
SELECT TOP 90 * FROM [SXRDB]  -- 1
SELECT TOP 90 * FROM [EBCFG]  -- 0
SELECT TOP 90 * FROM [EBUSR]  -- 0
SELECT TOP 90 * FROM [ECLGF]  -- 0
SELECT TOP 90 * FROM [ECLGT]  -- 0
SELECT TOP 90 * FROM [ECLOG]  -- 0
SELECT TOP 90 * FROM [EESUB]  -- 0
SELECT TOP 90 * FROM [ELCFG]  -- 0
SELECT TOP 90 * FROM [EMERR]  -- 0
SELECT TOP 90 * FROM [EMIDS]  -- 0
SELECT TOP 90 * FROM [EMMSG]  -- 0
SELECT TOP 90 * FROM [EMSTT]  -- 0
SELECT TOP 90 * FROM [EPASM]  -- 0
SELECT TOP 90 * FROM [EPOPR]  -- 0
SELECT TOP 90 * FROM [EPPKG]  -- 0
SELECT TOP 90 * FROM [EPPRC]  -- 0
SELECT TOP 90 * FROM [EPSRV]  -- 0
SELECT TOP 90 * FROM [IDX1]  -- 0
SELECT TOP 90 * FROM [LOG1]  -- 0
SELECT TOP 90 * FROM [MACT]  -- 0
SELECT TOP 90 * FROM [MCFL]  -- 0
SELECT TOP 90 * FROM [MCOL]  -- 0
SELECT TOP 90 * FROM [MIDX]  -- 0
SELECT TOP 90 * FROM [MKEY]  -- 0
SELECT TOP 90 * FROM [MLOG]  -- 0
SELECT TOP 90 * FROM [MLST]  -- 0
SELECT TOP 90 * FROM [MOBJ]  -- 0
SELECT TOP 90 * FROM [MUSR]  -- 0
SELECT TOP 90 * FROM [MVLD]  -- 0
SELECT TOP 90 * FROM [ORTT]  -- 0
SELECT TOP 90 * FROM [SCLC]  -- 0
SELECT TOP 90 * FROM [SCPT]  -- 0
SELECT TOP 90 * FROM [SEWAD]  -- 0
SELECT TOP 90 * FROM [SEWBU]  -- 0
SELECT TOP 90 * FROM [SEWCS]  -- 0
SELECT TOP 90 * FROM [SEWDB]  -- 0
SELECT TOP 90 * FROM [SEWDQ]  -- 0
SELECT TOP 90 * FROM [SEWDV]  -- 0
SELECT TOP 90 * FROM [SEWH1]  -- 0
SELECT TOP 90 * FROM [SEWIC]  -- 0
SELECT TOP 90 * FROM [SEWSN]  -- 0
SELECT TOP 90 * FROM [SEWST]  -- 0
SELECT TOP 90 * FROM [SEWU]  -- 0
SELECT TOP 90 * FROM [SEWU1]  -- 0
SELECT TOP 90 * FROM [SEWU2]  -- 0
SELECT TOP 90 * FROM [SEWUA]  -- 0
SELECT TOP 90 * FROM [SEWUS]  -- 0
SELECT TOP 90 * FROM [SEWUT]  -- 0
SELECT TOP 90 * FROM [SFDK]  -- 0
SELECT TOP 90 * FROM [SFMD]  -- 0
SELECT TOP 90 * FROM [SLSPP]  -- 0
SELECT TOP 90 * FROM [SMSG]  -- 0
SELECT TOP 90 * FROM [SPAR]  -- 0
SELECT TOP 90 * FROM [SSEN]  -- 0
SELECT TOP 90 * FROM [STNG]  -- 0
SELECT TOP 90 * FROM [SWDP]  -- 0
SELECT TOP 90 * FROM [SWEI]  -- 0
SELECT TOP 90 * FROM [SWFQ]  -- 0
SELECT TOP 90 * FROM [SWID]  -- 0
SELECT TOP 90 * FROM [SWPD]  -- 0
SELECT TOP 90 * FROM [SWRS]  -- 0
SELECT TOP 90 * FROM [SXRCO]  -- 0
SELECT TOP 90 * FROM [SXRDF]  -- 0
SELECT TOP 90 * FROM [SXREL]  -- 0
SELECT TOP 90 * FROM [SXRFU]  -- 0
SELECT TOP 90 * FROM [SXRIN]  -- 0
SELECT TOP 90 * FROM [SXRME]  -- 0
SELECT TOP 90 * FROM [SXROA]  -- 0
SELECT TOP 90 * FROM [SXRRO]  -- 0
SELECT TOP 90 * FROM [SXRSS]  -- 0
SELECT TOP 90 * FROM [TSCD]  -- 0
SELECT TOP 90 * FROM [UDAB]  -- 0
SELECT TOP 90 * FROM [UFRM]  -- 0
SELECT TOP 90 * FROM [UITE]  -- 0
SELECT TOP 90 * FROM [ULNG]  -- 0
SELECT TOP 90 * FROM [UMNU]  -- 0
SELECT TOP 90 * FROM [XSCMP]  -- 0
SELECT TOP 90 * FROM [XSSE]  -- 0
SELECT TOP 90 * FROM [XSUSR]  -- 0
SELECT TOP 90 * FROM [XSXA]  -- 0

  

posted @ 2023-08-24 23:14  samrv  阅读(76)  评论(0编辑  收藏  举报