| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SLOAP/ADT_CATT | transport table for /SLOAS/ADT_CAT | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
2 | /SLOAP/BIN_PROF | sloap profile | 3 | PROFILE_GUID | SLOAS: Guid | varbinary | 16 | 0 | | |
3 | /SLOAP/CATTOPICT | Transport table for /SLOAS/CATTOPIC | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
4 | /SLOAP/CAT_HEADT | trasport table for /SLOAS/CAT_HEAD | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
5 | /SLOAP/CHARTYPT | transport tab for /SLOAS/CHARTYPS | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
6 | /SLOAP/CLU_SRCT | Transport table for /SLOAS/CLU_SRC | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
7 | /SLOAP/CLU_STORT | Transport table for /SLOAS/CLU_STORE | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
8 | /SLOAP/CLU_TXTT | transport table for /SLOAS/CLU_TXT | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
9 | /SLOAP/DESC_ALIT | Transport table for /SLOAS/DESC_ALIA | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
10 | /SLOAP/DEVC_FITT | transport table for /SLOAS/DEVC_FILT | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
11 | /SLOAP/FIELDT | Transport table for /SLOAS/FIELD | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
12 | /SLOAP/GEN_STATE | State of output generation | 2 | PROFILE_GUID | SLOAS Output Profile GUID | varbinary | 16 | 0 | | |
13 | /SLOAP/MD_FIELDT | transport table for /SLOAS/MD_FIELD | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
14 | /SLOAP/MD_SYST | transport table for /SLOAS/MD_SYS | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
15 | /SLOAP/MODULET | transport table for /SLOAP/MODULE | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
16 | /SLOAP/OUTP_CATT | transport table for /SLOAS/OUTP_CAT | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
17 | /SLOAP/OUTP_XMLT | transport table for /SLOAS/OUTP_XML | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
18 | /SLOAP/OUT_COMMT | Transport Tables for /SLOAS/OUT_COMM | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
19 | /SLOAP/OUT_GRT | transport tables for /SLOAS/OUT_GR | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
20 | /SLOAP/OUT_GR_GT | transport table for /SLOAS/OUT_GR_GR | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
21 | /SLOAP/OUT_GR_MT | transport table for /SLOAS/OUT_GR_MD | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
22 | /SLOAP/OUT_MD5_T | transport table for /SLOAS/OUT_MD5_P | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
23 | /SLOAP/OUT_MDT | transport table for /SLOAS/OUT_MD | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
24 | /SLOAP/OUT_MD_MT | transport table for /SLOAS/OUT_MD_MD | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
25 | /SLOAP/OUT_PRT | transport tables for /SLOAS/OUT_PR | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
26 | /SLOAP/OUT_PR_GT | transport tables for /SLOAS/OUT_PR_GR | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
27 | /SLOAP/OUT_REFT | transport table for /SLOAS/OUT_REF | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
28 | /SLOAP/PICCATT | transport table for /SLOAS/PICCATT | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
29 | /SLOAP/PR_XMLT | transport table for /SLOAS/PR_XML | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
30 | /SLOAP/QUA_MAPPT | transport table for /SLOAS/QUA_MAPPI | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
31 | /SLOAP/RELEASET | transport table for /SLOAS/RELEASE | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
32 | /SLOAP/SELOPTT | Transfer table for /SLOAS/SELOPT | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
33 | /SLOAP/SELOPT_GT | transport table for /SLOAS/SELOPT_G | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
34 | /SLOAP/SM_MAPPT | Transport table for /SLOAS/SM_MAPPI | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
35 | /SLOAP/STORAGET | transport table for /SLOAS/STORAGE | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
36 | /SLOAP/SYS_TYPET | Transpoert tables for SLOAP system types | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
37 | /SLOAP/SYS_TYPT2 | Transport tables for SLOAP system types | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
38 | /SLOAP/TEMPLBGT | transport tables for /SLOAS/TEMPLBG | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
39 | /SLOAP/TEMPLHTMT | transport tables for /SLOAS/TEMPLHTML | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
40 | /SLOAP/TEMPLPDFT | transport table for /SLOAS/TEMPLPDF | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
41 | /SLOAP/TEXTT | transport tables for /SLOAS/TEXT | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
42 | /SLOAP/TEXT_2T | Transport tbl -SLOAS text mappings - using SAP documentation | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
43 | /SLOAP/TITLET | transport tables for /SLOAS/TITLE | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
44 | /SLOAP/TITLET2 | Transport table for SAP LT titles | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
45 | /SLOAP/TRANS | SAP LT AP: transport admin tables | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
46 | /SLOAP/TXT_TYPET | transport table for /SLOAS/TXT_TYPE | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
47 | /SLOAP/XMLT | transport table for /SLOAS/XML | 2 | PROFILE_GUID | Character field, length 32 | nvarchar | 32 | 0 | | |
48 | /XLSO/COMD_WECCP | Checkout Profile | 3 | PROFILE_GUID | Checkout Profile GUID | varbinary | 16 | 0 | | |
49 | /XLSO/WEC_BP_CPD | Default Checkout Profile | 4 | PROFILE_GUID | Checkout Profile GUID | varbinary | 16 | 0 | | |
TOPMaintenance Orders |
50 | /MRSS/D_SQP_EAPP | Employee Profile : Approval details | 2 | PROFILE_GUID | Profile GUID | varbinary | 16 | 0 | | |
51 | /MRSS/D_SQP_EHDR | Employee Profile : Header Attributes | 2 | PROFILE_GUID | Profile guid | nvarchar | 32 | 0 | | |
52 | /MRSS/D_SQP_EHIS | Employee Profile : History of changes | 2 | PROFILE_GUID | Profile GUID | varbinary | 16 | 0 | | |
53 | /MRSS/D_SQP_ESTR | Employee Profile - Structured Qualifications | 2 | PROFILE_GUID | Profile GUID | varbinary | 16 | 0 | | |
54 | /MRSS/D_SQP_EUST | Employee Profile : Unstructured Qualifications | 2 | PROFILE_GUID | Profile GUID | varbinary | 16 | 0 | | |
55 | /MRSS/D_SQP_PROF | Profile Master Table : Contains all Profile Guids | 2 | PROFILE_GUID | Profile GUID | varbinary | 16 | 0 | | |
56 | /MRSS/D_SQP_RADT | Requirements Profile: Information of Additional attributes | 2 | PROFILE_GUID | Profile GUID | varbinary | 16 | 0 | | |
57 | /MRSS/D_SQP_RHDR | Requirements Profile: Header Attributes | 2 | PROFILE_GUID | Profile GUID | varbinary | 16 | 0 | | |
58 | /MRSS/D_SQP_ROCS | Requirement Profie on call types with search types | 2 | PROFILE_GUID | Profile GUID | varbinary | 16 | 0 | | |
59 | /MRSS/D_SQP_ROCT | Requirement Profie on call types | 2 | PROFILE_GUID | Profile GUID | varbinary | 16 | 0 | | |
60 | /MRSS/D_SQP_RSTR | Requirements Profile : Structured Qualifications | 2 | PROFILE_GUID | Profile GUID | varbinary | 16 | 0 | | |
61 | /MRSS/D_SQP_RUSR | Requirements Profile: Unstructured Qualifications | 2 | PROFILE_GUID | Profile GUID | varbinary | 16 | 0 | | |
62 | /MRSS/D_SQP_RUST | Requirements Profile: Unstruct Qualif. - Language depend. | 2 | PROFILE_GUID | Profile GUID | varbinary | 16 | 0 | | |
TOPWeb Channel Applications |
63 | COMD_WEC_BP_CP | Checkout Profile | 3 | PROFILE_GUID | Checkout Profile GUID | varbinary | 16 | 0 | | |
64 | COMD_WEC_BP_CPD | Default Checkout Profile | 4 | PROFILE_GUID | Checkout Profile GUID | varbinary | 16 | 0 | | |