| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BKK_OPD_IT_EXT | External Item Selection Table - Outgoing Payment Dispatcher | 48 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
2 | CCGLT_PRTREQ_HDR | EHS: Print Request Header Table | 9 | CRTIM | Creation Time of Print Request | nvarchar | 6 | 0 | | |
3 | CCGLT_PR_HDR_UT2 | EHS: Print Request Header Table Test Data for Unit Test | 13 | CRTIM | Creation Time of Print Request | nvarchar | 6 | 0 | | |
4 | CNVLTHCM_STATUS | Status of Path Determination | 6 | CRTIM | Creation time | nvarchar | 6 | 0 | | |
5 | CNV_10020_ACT | Actions - Header data | 10 | CRTIM | Creation time | nvarchar | 6 | 0 | | |
6 | CNV_10020_CDOBJH | Condition objects: Header data | 9 | CRTIM | Creation time | nvarchar | 6 | 0 | | |
7 | CNV_10020_CFOBJH | Concatenated/fragmented objects: Header data | 10 | CRTIM | Creation time | nvarchar | 6 | 0 | | |
8 | CNV_10020_COND | Conditions - Header data | 10 | CRTIM | Creation time | nvarchar | 6 | 0 | | |
9 | CNV_10020_DTFLD | Assignment of determination to tables and fields | 23 | CRTIM | Creation time | nvarchar | 6 | 0 | | |
10 | CNV_10020_DTOBJH | Determination objects | 11 | CRTIM | Creation time | nvarchar | 6 | 0 | | |
11 | CNV_10020_FVOBJ | Fixed value objects | 11 | CRTIM | Creation time | nvarchar | 6 | 0 | | |
12 | CNV_10020_PATH | Determination paths: Header data | 26 | CRTIM | Creation time | nvarchar | 6 | 0 | | |
13 | CNV_10020_RCOMP | Assignment of rules to non-transp. field components | 14 | CRTIM | Creation time | nvarchar | 6 | 0 | | |
14 | CNV_10020_RDTOBJ | Assignment of rules to determination object components | 14 | CRTIM | Creation time | nvarchar | 6 | 0 | | |
15 | CNV_10020_RULE | Rules - Header data | 9 | CRTIM | Creation time | nvarchar | 6 | 0 | | |
16 | CNV_10020_VLIST | Value lists - Header data | 10 | CRTIM | Creation time | nvarchar | 6 | 0 | | |
17 | T049C | Evaluation of the Autocash Tapes | 3 | CRTIM | Tape Creation Time | nvarchar | 6 | 0 | | |
18 | T7UNPF_FI_ADDET | Additional Details | 23 | CRTIM | Time created | nvarchar | 6 | 0 | | |
19 | T7UNPF_FI_ADJUS | Adjustments | 15 | CRTIM | Time created | nvarchar | 6 | 0 | | |
20 | T7UNPF_FI_CONTR | Contributions | 11 | CRTIM | Time created | nvarchar | 6 | 0 | | |
21 | T7UNPF_FI_MISCE | Financial Interface Misc. Transactions | 13 | CRTIM | Time created | nvarchar | 6 | 0 | | |
22 | T7UNPF_FI_OPRHD | Operation Header | 13 | CRTIM | Time created | nvarchar | 6 | 0 | | |
23 | T7UNPF_FI_STFHD | Staff Member Header Table | 11 | CRTIM | Time created | nvarchar | 6 | 0 | | |
24 | T7UNPF_FI_TRANS | Additional Details | 36 | CRTIM | Time created | nvarchar | 6 | 0 | | |
25 | T7UNPF_HR_ADDR | Address | 18 | CRTIM | Time created | nvarchar | 6 | 0 | | |
26 | T7UNPF_HR_CHILD | Child details | 19 | CRTIM | Time created | nvarchar | 6 | 0 | | |
27 | T7UNPF_HR_CNTRC | Contract details | 18 | CRTIM | Time created | nvarchar | 6 | 0 | | |
28 | T7UNPF_HR_DEPND | Dependent details | 19 | CRTIM | Time created | nvarchar | 6 | 0 | | |
29 | T7UNPF_HR_DS | Duty Station details | 10 | CRTIM | Time created | nvarchar | 6 | 0 | | |
30 | T7UNPF_HR_EMAIL | Email Information | 12 | CRTIM | Time created | nvarchar | 6 | 0 | | |
31 | T7UNPF_HR_LANG | Language Allowance | 10 | CRTIM | Time created | nvarchar | 6 | 0 | | |
32 | T7UNPF_HR_LWOP | Leave Without Pay | 11 | CRTIM | Time created | nvarchar | 6 | 0 | | |
33 | T7UNPF_HR_OPRHD | Operation Header | 12 | CRTIM | Time created | nvarchar | 6 | 0 | | |
34 | T7UNPF_HR_PART | Parttime Details | 10 | CRTIM | Time created | nvarchar | 6 | 0 | | |
35 | T7UNPF_HR_PHONE | Phone Information | 12 | CRTIM | Time created | nvarchar | 6 | 0 | | |
36 | T7UNPF_HR_SAL | Salary details | 12 | CRTIM | Time created | nvarchar | 6 | 0 | | |
37 | T7UNPF_HR_SECON | Staff Secondment details | 13 | CRTIM | Time created | nvarchar | 6 | 0 | | |
38 | T7UNPF_HR_SEP | Staff Member Separation details | 13 | CRTIM | Time created | nvarchar | 6 | 0 | | |
39 | T7UNPF_HR_STAFF | Staff Member Table | 21 | CRTIM | Time created | nvarchar | 6 | 0 | | |
40 | T7UNPF_HR_STFHD | Staff Member Header Table | 14 | CRTIM | Time created | nvarchar | 6 | 0 | | |
TOPAccount Management |
41 | BKK42_NTC | Master Data for Notice and Allowances | 18 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
42 | BKKNTC | Notice: Partial Amount and Full Amount Notice | 19 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
TOPAddress ManagementBusiness Address |
43 | SADR | Address Management: Company Data | 42 | CRTIM | Addresses: Creation time | nvarchar | 6 | 0 | | |
44 | SADRP | Address Management: Personal Data | 18 | CRTIM | Addresses: Creation time | nvarchar | 6 | 0 | | |
TOPApplication-Specific Upgrade |
45 | /ASU/HEADER | ASU Version Header | 7 | CRTIM | Field of type TIMS | nvarchar | 6 | 0 | | |
TOPBank Customer Accounts |
46 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 93 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
47 | BKKSO | BCA: Standing Orders | 38 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
48 | BKK_PRENOTE | Prenotes | 39 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
49 | NIHC_DB_PO_PNTA | Source Document for Incoming Payment Orders | 43 | CRTIM | Time when the object was created or changed | nvarchar | 6 | 0 | | |
50 | NIHC_DB_PO_STAT | Status of Payment Order | 9 | CRTIM | Time when the object was created or changed | nvarchar | 6 | 0 | | |
51 | TBKKCORR | BCA: Table showing if Correspondence is Active | 5 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
TOPBusiness Partner |
52 | BPOBTAB | Partner-Object Relationship | 15 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
TOPConfiguration management |
53 | IBINCM | IB: Config.Mang.: Component/Instance | 27 | CRTIM | Time (UTC) at which the object was created | decimal | 15 | 0 | | |
54 | IBSPCM | IB: Config.Mang.: Specialization | 20 | CRTIM | Time (UTC) at which the object was created | decimal | 15 | 0 | | |
55 | IBSTCM | IB: Conf.Mang.:Structure | 8 | CRTIM | Time (UTC) at which the object was created | decimal | 15 | 0 | | |
TOPContract Accounts Receivable and Payable |
56 | DFKKIP_ITM | Payment Specification: Related Items | 15 | CRTIM | Payment Specification: Time of Creation of Item | nvarchar | 6 | 0 | | |
57 | DFKKIP_ITMV | Payment Specification: Preselected Items | 12 | CRTIM | Payment Specification: Time of Creation of Item | nvarchar | 6 | 0 | | |
TOPFinancial Supply Chain Management |
58 | BNK_BTCH_STREF | Status reference | 10 | CRTIM | Create Time | nvarchar | 6 | 0 | | |
TOPFSCM In-House Cash |
59 | IHC_DB_PN | Source Document for Incoming Payment Orders | 89 | CRTIM | Created At | nvarchar | 6 | 0 | | |
60 | IHC_DB_PN_STATUS | IHC: Payment Order Status | 15 | CRTIM | Time when the object was created or changed | nvarchar | 6 | 0 | | |
TOPGL transfer |
61 | BKKC01 | Gen.Ledger: Reconciliation Key Accounting Documents | 10 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
62 | BKKC30 | Gen. Ledger: Log for Transfer Postings (Bal.Sh.Prep., etc.) | 8 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
63 | BKKCNOITGL | Table of Items not Updated on the Account | 41 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
64 | BKKCVA | Administration Table Individual Value Adjustment | 12 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
TOPGlobal Trade Services |
65 | /SAPSLL/XLCLICS | Temporary Table for Upload Licenses: License Status | 5 | CRTIM | Time | nvarchar | 6 | 0 | | |
TOPInstalled Base |
66 | IBADDR | IBase: Business Address Services Connection | 9 | CRTIM | Time (UTC) at which the object was created | decimal | 15 | 0 | | |
67 | IBIB | IB: Installed Base/IBase | 4 | CRTIM | Time (UTC) at which the object was created | decimal | 15 | 0 | | |
68 | IBIN | IB: IBase Components - Condition | 27 | CRTIM | Time (UTC) at which the object was created | decimal | 15 | 0 | | |
69 | IBINTX | IBase: Text for the Instance | 10 | CRTIM | Time (UTC) at which the object was created | decimal | 15 | 0 | | |
70 | IBSP | IB: Installed Base Component - Enhancement/Specialization | 20 | CRTIM | Time (UTC) at which the object was created | decimal | 15 | 0 | | |
71 | IBST | IB: Installation Component - Structure | 8 | CRTIM | Time (UTC) at which the object was created | decimal | 15 | 0 | | |
TOPMaster Data |
72 | BCA_US_HLD2REL | Hold Records which have not been released - Dual Control | 25 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
73 | BCA_US_HOLD | Hold Amounts Which Affect Available Balance | 24 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
TOPMaster Data Synchronization |
74 | BC001 | Business Partner: Assign Vendor - Partner | 6 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
75 | BD001 | Business Partner: Assignment Customer - Partner | 6 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
76 | CVI_CUST_CT_LINK | Connec. Between Relationship + Activity Partner for Customer | 7 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
77 | CVI_CUST_LINK | Assignment Between Customer and Business Partner | 6 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
78 | CVI_VEND_CT_LINK | Connec. Between Relationship + Activity Partner for Vendor | 7 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
79 | CVI_VEND_LINK | Assignment Between Vendor and Business Partner | 6 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
TOPNon Profit Organizations |
80 | T7UNPF_MI_ACTCO | UNJSPF Monthly Interface Activity Control Table | 10 | CRTIM | Time created | nvarchar | 6 | 0 | | |
81 | T7UNPF_MI_BISTA | UNJSPF Monthly Interface Break in Service | 13 | CRTIM | Time created | nvarchar | 6 | 0 | | |
82 | T7UNPF_MI_CHLDR | UNJSPF Monthly Interface Children Table | 23 | CRTIM | Time created | nvarchar | 6 | 0 | | |
83 | T7UNPF_MI_DEPND | UNJSPF Monthly Interface Export key | 24 | CRTIM | Time created | nvarchar | 6 | 0 | | |
84 | T7UNPF_MI_PARTT | UNJSPF Monthly Interface Part Time Table | 11 | CRTIM | Time created | nvarchar | 6 | 0 | | |
85 | T7UNPF_MI_PRTCI | UNJSPF Monthly Interface Participant Table | 25 | CRTIM | Time created | nvarchar | 6 | 0 | | |
86 | T7UNPF_YI_SCHE | UNJSPF Yearly Interface data table | 14 | CRTIM | Time created | nvarchar | 6 | 0 | | |
TOPPayment Item |
87 | BKKIT | Payment Item | 93 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
88 | BKKITAI | Info Items for Interest Penalty at Balancing | 26 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
89 | BKKITENQ | Blocked Payment Items | 93 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
90 | BKKITREL | Payment Item | 93 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
91 | BKKITTMP | Planned Payment Items | 94 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
92 | BKKITTMP_DEL | Planned Payment Items - Completed | 94 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
TOPPayment Order |
93 | BKKPOHD | Payment Order, Header Data | 32 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
94 | BKKPOHD_TMP | Planned Payment Order, Header Data | 33 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
95 | BKKPOHD_TMP_DEL | Planned Payment Order, Header Data | 33 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
TOPProduct Safety |
96 | CVCHE | EHS: Event buffer for report shipping | 5 | CRTIM | Entry Time | nvarchar | 6 | 0 | | |
97 | CVDDH | EHS: Report shipping orders | 108 | CRTIM | Entry Time | nvarchar | 6 | 0 | | |
98 | CVDPH | DDS: OBSOLETE !! DDOC log, header record | 19 | CRTIM | Entry Time | nvarchar | 6 | 0 | | |
TOPProgress Tracking |
99 | TSTNT | Expediting Status Information | 10 | CRTIM | Time | nvarchar | 6 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
100 | FMOPBL | Document Reference IS-PS <=> IS-PS-CA | 8 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
TOPReal Estate Management |
101 | BPOBIMMO | Business Partner - Object Relationship: Real Estate | 26 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
TOPRecycling Administration Core Functions |
102 | J_7LSADR | Address Management: Company Data | 42 | CRTIM | Addresses: Creation time | nvarchar | 6 | 0 | | |
TOPSales |
103 | LINKAGE | Relationships | 11 | CRTIM | Entry time | nvarchar | 6 | 0 | | |
TOPStakeholder Relationship Management |
104 | USC_CONTACT | SRM Contact: Central Storage of Contacts | 16 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
105 | USC_CONT_DOC | SRM Contact: Documents | 10 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
106 | USC_CONT_KWD | SRM Contact: Keywords | 7 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
107 | USC_CONT_REL | SRM Contact: Related Contacts | 7 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
108 | USC_CONT_STH | SRM Contact: Stakeholders | 13 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
109 | USS_STAKEHOLDER | SEM-SRM: Specific Master Data of Stakeholder | 11 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
110 | USS_STH_COVER | SEM-SRM: Relationship Stakeholder and Coverage | 7 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
111 | USS_STH_EXPECT | SEM-SRM: Expectations of Stakeholders | 17 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
112 | USS_STH_INFL | SEM-SRM: Influence of Stakeholders | 12 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
113 | USS_STH_SHARE | SEM-SRM: Shares of Stakeholders | 11 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
114 | USS_STH_STH_GRP | SEM-SRM: Group of Stakeholders | 10 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
TOPUse AP-MD-BP Components |
115 | BUT000 | BP: General data I | 78 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
116 | BUT000_TD | BP: General Data I, Shadow Table Time Dependency | 79 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
117 | BUT000_TDS | BP: General Data I, Shadow Table Time Dependency | 80 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
118 | BUT050 | BP relationships/role definitions: General data | 14 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
119 | BUT050S | BP Relationships/Role Definitions: General Data | 15 | CRTIM | Time at which the object was created | nvarchar | 6 | 0 | | |
TOPUse Subcomponents |
120 | SOFD | SAPoffice: Object Definition | 16 | CRTIM | Time created | nvarchar | 6 | 0 | | |
121 | SOOD | SAPoffice: Object definition | 18 | CRTIM | Time created | nvarchar | 6 | 0 | | |
122 | SORF | SAPoffice: Replication Table | 19 | CRTIM | Time created | nvarchar | 6 | 0 | | |
123 | SOUD | SAPoffice: user definition | 10 | CRTIM | Time created | nvarchar | 6 | 0 | | |