| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /OPT/AT_APPR_HIS | Approval History for Level Based Approvals | 89 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
2 | /OPT/AT_LBA_LOG | Approval History for Level Based Approvals | 90 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
3 | /OPT/VIM_1ITEM_S | Document Item | 95 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
4 | /OPT/VIM_TITEM | Document Item | 95 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
5 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 158 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
6 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 162 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
7 | BSEG | Accounting Document Segment | 266 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
8 | BSID_BAK | Accounting: Secondary Index for Customers | 158 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
9 | BSIK_BAK | Accounting: Secondary index for vendors | 162 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
10 | BSSEG | Accounting Document Segment | 255 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
11 | FIAPSAD_ADP_LT | Advance Payment Request Line Items Details | 11 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
12 | FIAPSAD_ORDR_LT | Line Item for Order Number KSA | 24 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
13 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 255 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
14 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 255 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
15 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 255 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
16 | GLPOS_C_CT | FI Document: Entry View | 142 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
17 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 142 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
18 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 142 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
19 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 142 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
20 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 144 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
21 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 144 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
22 | REGUP | Processed items from payment program | 165 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
23 | YVIM_1ITEM | Document Item | 95 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPAccounting Interface |
24 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 185 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
25 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 185 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPActual Payments and Forecast |
26 | COFP | Document Lines (project cash management) | 48 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPElectronic Bank Statement |
27 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 61 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
28 | FEB_ACT | Acct Assignment Templates | 61 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPExternal Services |
29 | ESKN | Account Assignment in Service Package | 54 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPFinancial Accounting |
30 | /OPT/VIM_1ITEM | Document Item | 95 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
31 | ACCTIT | Compressed Data from FI/CO Document | 106 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
32 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 158 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
33 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 162 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
34 | BSID | Accounting: Secondary Index for Customers | 158 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
35 | BSIK | Accounting: Secondary Index for Vendors | 162 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
36 | KMZEI | FI: Account Assignment Model Item Information | 65 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
37 | KOMU | Account Assignment Templates for G/L Account Items | 65 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
38 | VBSEGA | Document Segment for Document Parking - Asset Database | 37 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
39 | VBSEGD | Document Segment for Customer Document Parking | 122 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
40 | VBSEGK | Document Segment for Vendor Document Parking | 134 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
41 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 98 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPFunds Management |
42 | FCABP | FI-CA: Document Item | 43 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
43 | FMEP | FI-FM Line Items | 55 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
44 | FMLGD_H_VG_01_01 | Budget Type 01: Customer Down Payment | 8 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
45 | FMLGD_H_VG_02_01 | Posting Type 02: Vendor Down Payment | 8 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
46 | FMLGD_H_VG_05_01 | Posting Type 05: Down Payment with General Request (01) | 6 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
47 | FMLGD_H_VG_05_02 | Posting Type 05:Vendor Down Payment with General Request(02) | 8 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
48 | FMLGD_H_VG_06_01 | Posting Type 06:Customer Down Payment with General Request | 6 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPFunds Management-Specific Postings |
49 | FMCJ | IS-PS: Documents in Cash Desk Subsidiary Ledger | 24 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
50 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 97 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
51 | PSOSEGA | Document Segment for Assets Document Parking | 38 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
52 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 96 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPGeneral Ledger Accounting |
53 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 60 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPGL Account Posting |
54 | TCJ_POSITIONS | Cash Journal Document Items | 68 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPInventory Management |
55 | MSEG | Document Segment: Material | 188 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
56 | RESB | Reservation/dependent requirements | 187 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPInvoice Verification |
57 | RBCO | Document Item, Incoming Invoice, Account Assignment | 60 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPMaterials Management |
58 | /ISDFPS/CS_EXLST | Exception List: Overwritten Purchase Requisitions | 138 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPPayment Transactions |
59 | CRACC | Payment Cards: Account Assignments in Card Master Record | 18 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
60 | CRNUM | Payment cards: Card master record | 39 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPPurchasing |
61 | EBAN | Purchase Requisition | 130 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
62 | EBKN | Purchase Requisition Account Assignment | 57 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
63 | EKCPA | Purchasing Contract Commitment Plan Account Assignment Data | 7 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
64 | EKKN | Account Assignment in Purchasing Document | 62 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
65 | EKPO | Purchasing Document Item | 208 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
66 | MEREQX | Purchase Requisition Change Parameter | 130 | KBLPOS | Updated information in related user data field | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
67 | /BEV3/CH1030BSG2 | Document Segment CH Event Ledger Part2 | 22 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPRepetitive Manufacturing |
68 | COMPMOVE | Goods Movement of Components | 151 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPSelf-Service Procurement |
69 | /SRMERP/D_ACC_IT | Account assignment item | 50 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
TOPSimulation |
70 | VSEBKN_CN | Version: Purchase requisition account assignment | 58 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |
71 | VSRESB_CN | Version: Reservation/Dependent requirements | 195 | KBLPOS | Earmarked Funds: Document Item | nvarchar | 3 | 0 | | |