| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | BKK_SEPA_LIM_EV | Event Table for Mandate Limits | 5 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
2 | BKK_SEPA_LIM_HIS | History Table for Mandate Limits | 6 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
3 | J_1I_EXIMACCLOG | EXIM: Account Posting Log | 4 | DOCNO | Document Number | nvarchar | 10 | 0 | | |
4 | J_1I_PMLICUTIL | EXIM : License Utilization | 6 | DOCNO | Document Number | nvarchar | 10 | 0 | | |
5 | PA3317 | HR Master Record: Infotype 3317 | 33 | DOCNO | Number of Receipt | nvarchar | 26 | 0 | | |
TOPAccount Management |
6 | BKKITNTC | Notice: Payment Item with Notice Lock Period > 0 | 5 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
7 | BKKPAYMNOTE | BCA: Payment Notes | 2 | DOCNO | BCA: Document Number of Payment Notes | nvarchar | 18 | 0 | | |
8 | BKK_FA_USED | Utilization of Allowance | 5 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
TOPApplication System |
9 | /SAPTRX/ASITEMID | Item Identifier Refernce Table | 3 | DOCNO | Document Number | nvarchar | 20 | 0 | | |
TOPASAP Tools and Contents |
10 | SMAPDOCNO | Solution Map: Doc. ID number status | 2 | DOCNO | | nvarchar | 10 | 0 | | |
TOPBank Customer Accounts |
11 | BCA_US_MEM_ITEMS | Memo item table | 10 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
12 | BKKCORRITEM | Auxiliary Table: Payment Items for Adjustments | 3 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
13 | BKK_PRENOTE | Prenotes | 35 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
14 | RTP_US_HIST | Retirement plan history and audit table | 13 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
TOPClaims Management |
15 | ICLDOC | Document to be Sent in Claim | 5 | DOCNO | Number of Document in Claim | nvarchar | 3 | 0 | | |
16 | ICLDOCAL | Attachments to Outbound Documents | 5 | DOCNO | Number of Document in Claim | nvarchar | 3 | 0 | | |
17 | ICSDOC | Document in Claim | 5 | DOCNO | Number of Document in Claim | nvarchar | 3 | 0 | | |
18 | ICSDOCAL | Attachments to Outbound Correspondence | 5 | DOCNO | Number of Document in Claim | nvarchar | 3 | 0 | | |
TOPEnvironment, Health and Safety |
19 | /TDAG/CPT_TASKD | CP: Dokumente zu Aufgabenpositionen | 4 | DOCNO | Internal Document Number | nvarchar | 10 | 0 | | |
20 | /TDAG/CPT_TASKDA | CP: Dokumente zu Aufgabenpositionen / Archiv | 4 | DOCNO | Internal Document Number | nvarchar | 10 | 0 | | |
TOPFSCM In-House Cash |
21 | IHC_DB_DSP_TRAPO | Table Structure for displaying the Posted Item Detail | 2 | DOCNO | Input Field for Search Criterion for Selecting Open Items | nvarchar | 30 | 0 | | |
TOPGL transfer |
22 | BKKC02 | General Ledger: Posting Totals for FI | 5 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
23 | BKKC12_ITEM | GL: New Balances for Balance Sheet Preparation (Items) | 3 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
24 | BKKITGL | Gen. Ledger: Payment Item Data | 3 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
TOPIndustry Solution Catch Weight Management |
25 | CON_FIN_WQ_HDR | Header Table for Transactions in Work Queue | 12 | DOCNO | Document Number of Transaction in Work Queue | nvarchar | 12 | 0 | | |
TOPInterface to Terminal Automation System |
26 | OIK01 | IS-OIL/TAS: LID Document Data | 3 | DOCNO | SAP Document Number (TAS) | nvarchar | 10 | 0 | | |
27 | OIK01D | IS-OIL/TAS: deactivated LID Document Data | 3 | DOCNO | SAP Document Number (TAS) | nvarchar | 10 | 0 | | |
28 | OIK02A | IS-OIL/TAS: Status of processed functions | 12 | DOCNO | SAP Document Number (TAS) | nvarchar | 10 | 0 | | |
29 | OIKLIDR | TD - TAS Reference Table | 7 | DOCNO | SAP Document Number (TAS) | nvarchar | 10 | 0 | | |
TOPLease Accounting |
30 | FIOTPOH | One-Time Postings: Header | 7 | DOCNO | Document Number | nvarchar | 4 | 0 | | |
31 | FIOTPOI | One-Time Postings: Items | 7 | DOCNO | Document Number | nvarchar | 4 | 0 | | |
TOPLocalization |
32 | J_1IEXCDEP | Excise information of vendor at detail level for depot | 4 | DOCNO | Internal Excise Document Number | nvarchar | 10 | 0 | | |
33 | J_1IEXCDTL | Excise invoice line item details | 4 | DOCNO | Internal Excise Document Number | nvarchar | 10 | 0 | | |
34 | J_1IEXCHDR | Excise invoice header detail | 4 | DOCNO | Internal Excise Document Number | nvarchar | 10 | 0 | | |
35 | J_1IPART1 | Excise part I detials | 13 | DOCNO | Internal Excise Document Number | nvarchar | 10 | 0 | | |
36 | J_1IPART2 | Excise Part II details | 7 | DOCNO | Internal Excise Document Number | nvarchar | 10 | 0 | | |
37 | J_1IQRDEP | Quarterly Returns Depot structure | 1 | DOCNO | Internal Excise Document Number | nvarchar | 10 | 0 | | |
38 | J_1IRG23D | RG23D register for the depot | 4 | DOCNO | Internal number - GR for delivery at depot | nvarchar | 10 | 0 | | |
39 | J_1ISUBBYP | Subcontracting Scrap/ Byproduct | 3 | DOCNO | Internal Excise Document Number | nvarchar | 10 | 0 | | |
TOPMaster Data |
40 | BCA_US_HLD2REL | Hold Records which have not been released - Dual Control | 21 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
41 | BCA_US_HOLD | Hold Amounts Which Affect Available Balance | 20 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
TOPPayment Item |
42 | BKKI3 | Turnover Items Not Posted for Last Bank Statement | 3 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
43 | BKKIT | Payment Item | 3 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
44 | BKKITADR | Payment Item: Address of Transferring Party | 3 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
45 | BKKITENQ | Blocked Payment Items | 3 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
46 | BKKITPRE | Parked Payment Items | 5 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
47 | BKKITREL | Payment Item | 3 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
48 | BKKITRETREL | Payment Item Return to be released | 3 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
49 | BKKITTMP | Planned Payment Items | 5 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
50 | BKKITTMP_DEL | Planned Payment Items - Completed | 5 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
51 | BKKNT | Purpose | 3 | DOCNO | Item number in current accounts | nvarchar | 12 | 0 | | |
TOPReporting |
52 | P05T_WCR_ER_INFO | WCR Info on Employer Level | 13 | DOCNO | Invoice Number | nvarchar | 10 | 0 | | |
TOPReturnable Packaging Logistics |
53 | RLACPOIT | Account Posting Record | 23 | DOCNO | Reference document for RP account posting | nvarchar | 35 | 0 | | |
54 | RLACSTIT | Transactions in Returnable Packaging Account Statement | 8 | DOCNO | Document Number for Transaction | nvarchar | 35 | 0 | | |
TOPSelf-Billing Proced. |
55 | TRNSM | Data Transfer | 16 | DOCNO | IDoc number | nvarchar | 16 | 0 | | |
TOPService Station Retailing |
56 | OIRA_PRNDOC_HEAD | Print document header data | 2 | DOCNO | Collective print document number | nvarchar | 10 | 0 | | |
57 | OIRA_PRNDOC_ITEM | Print document item data | 2 | DOCNO | Collective print document number | nvarchar | 10 | 0 | | |
TOPTraders and Schedulers Workbench |
58 | OIJPEG | TSW: Pegging of scheduled movements | 3 | DOCNO | Document key (generic) | nvarchar | 20 | 0 | | |
59 | OIJ_EL_DFLOW_SUB | TSW - Document flow for sub items | 2 | DOCNO | TSW - Reference Document Number for Sub-Item Document Flow | nvarchar | 10 | 0 | | |
60 | OIJ_EL_ELOG_SUB | TSW: Error log for ticketing process at sub item | 2 | DOCNO | TSW - Reference Document Number for Sub-Item Document Flow | nvarchar | 10 | 0 | | |
TOPUSA |
61 | PA0566 | HR Master Record: Infotype 0566 | 24 | DOCNO | QDRO Docket Number | nvarchar | 35 | 0 | | |
TOPUse Subcomponents |
62 | SOFM | SAPoffice: Folder contents | 7 | DOCNO | Object: Number from ID | nvarchar | 12 | 0 | | |
63 | SOMG | Table for persistence of objects MESSAGE/RECIPIENT | 15 | DOCNO | Object: Number from ID | nvarchar | 12 | 0 | | |
TOPWaste Management |
64 | EHSWAT_ENTAM | Disposal Processing (Quantity Entry/Planning) | 44 | DOCNO | External Document | nvarchar | 16 | 0 | | |