| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/KPKP01 | Chasier connection to sales document | 2 | ZUONR | Allocation number | nvarchar | 10 | 0 | | |
2 | /ATL/KPKP01KP | Chasier connection to sales document - Temporary | 2 | ZUONR | Allocation number | nvarchar | 10 | 0 | | |
3 | /ATL/KPRCPT | Detail of receipt | 10 | ZUONR | Allocation number | nvarchar | 10 | 0 | | |
4 | /ATL/KPRCPTKP | Detail of temporary receipt | 10 | ZUONR | Allocation number | nvarchar | 10 | 0 | | |
5 | /BIC/B0000165000 | PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta | 69 | ZUONR | | nvarchar | 18 | 0 | | |
6 | /BIC/B0000166000 | PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta | 69 | ZUONR | | nvarchar | 18 | 0 | | |
7 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 75 | ZUONR | | nvarchar | 18 | 0 | | |
8 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 75 | ZUONR | | nvarchar | 18 | 0 | | |
9 | /BIC/B0000170000 | PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta | 61 | ZUONR | | nvarchar | 18 | 0 | | |
10 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 88 | ZUONR | | nvarchar | 18 | 0 | | |
11 | /OPT/VIM_1CLEAR | /OPT/VIM_1HEAD Extension with Clearing Documents (BSAK) | 13 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
12 | /OPT/VIM_1ITEM_S | Document Item | 24 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
13 | /OPT/VIM_TITEM | Document Item | 24 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
14 | BBP_RBKP | Document Header: Invoice Receipt | 65 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
15 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 8 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
16 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 8 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
17 | BSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 6 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
18 | BSEG | Accounting Document Segment | 55 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
19 | BSID_BAK | Accounting: Secondary Index for Customers | 8 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
20 | BSIK_BAK | Accounting: Secondary index for vendors | 8 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
21 | BSIS_BAK | Accounting: Secondary Index for G/L Accounts | 6 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
22 | BSSEG | Accounting Document Segment | 44 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
23 | CNVA_PCREA_GRIRO | GR/IR Items - Results (Level 2) | 7 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
24 | CNVTDMS_05_BSAD | Header table for BSAD | 10 | ZUONR | DOCNR for table CNVTDMS_05_VS | nvarchar | 20 | 0 | | |
25 | CNVTDMS_05_BSAD1 | Header table for BSAD | 10 | ZUONR | ZUONR for TDMS | nvarchar | 18 | 0 | | |
26 | CNVTDMS_05_BSAK | Header table for BSAK | 10 | ZUONR | DOCNR for table CNVTDMS_05_VS | nvarchar | 20 | 0 | | |
27 | CNVTDMS_05_BSAK1 | Header table for BSAK | 10 | ZUONR | ZUONR for TDMS | nvarchar | 18 | 0 | | |
28 | CNVTDMS_05_BSAS | Fill Header BSAS - P&G | 7 | ZUONR | ZUONR for TDMS | nvarchar | 18 | 0 | | |
29 | CNVTDMS_05_BSEG | FILL Header BSEG | 7 | ZUONR | DOCNR for table CNVTDMS_05_VS | nvarchar | 20 | 0 | | |
30 | CNVTDMS_05_BSEG1 | FILL Header BSEG | 7 | ZUONR | ZUONR for TDMS | nvarchar | 18 | 0 | | |
31 | CNVTDMS_05_BSIS | Fill Header BSIS - P&G | 7 | ZUONR | ZUONR for TDMS | nvarchar | 18 | 0 | | |
32 | EPIC_EBR_HDR | OBSOLETE!!! | 57 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
33 | FAGLBSAS_BAK | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 6 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
34 | FAGLBSIS_BAK | Accounting: Secondary Index for G/L Accounts | 6 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
35 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 44 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
36 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 44 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
37 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 44 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
38 | GLPOS_C_CT | FI Document: Entry View | 324 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
39 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 324 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
40 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 324 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
41 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 324 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
42 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 333 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
43 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 333 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
44 | J_1UF_TAX_POS | Extended data of tax document positions | 29 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
45 | MHND | Dunning Data | 18 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
46 | REGUP | Processed items from payment program | 119 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
47 | YVIM_1ITEM | Document Item | 24 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
48 | ZEIM_VBAK | Sales Document: Header Data | 88 | ZUONR | Assignment number | nvarchar | 18 | 0 | | |
TOPAccounting Interface |
49 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 133 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
50 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 133 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPAdvertising Management |
51 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 72 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
52 | JHTFP | IS-M/AM: Billing/Settlement Documents - Item | 131 | ZUONR | IS-M: Assignment number in FI document | nvarchar | 18 | 0 | | |
TOPAgency Business Global Trade |
53 | WBRK | Agency business: Header | 28 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPAutomatic Payments |
54 | PAYRQ | Payment Requests | 124 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
55 | PAYRQP | PAYRQ Enhancement (Cross-Country Bank Account Transfers) | 9 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPBasic Functions |
56 | ANEK | Document Header Asset Posting | 34 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
57 | BSIW | Index table for customer bills of exchange used | 4 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
58 | BSIX | Index table for customer bills of exchange used | 4 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
59 | FDES | Cash Management and Forecast: Memo Records | 22 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
60 | FDESDIST | Cash management memo records (distributed) | 23 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
61 | FEBEP | Electronic Bank Statement Line Items | 35 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPBilling |
62 | VBRK | Billing Document: Header Data | 80 | ZUONR | Assignment number | nvarchar | 18 | 0 | | |
TOPCash Desk |
63 | FMSHERLOCK | Clarification List (Payments to be Clarified) | 28 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPContract Accounts Receivable and Payable |
64 | FKKBEP | Electronic Bank Statement Line Items | 35 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPCross-Application Components |
65 | BBSID | Accounting: Secondary index for customers | 8 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
66 | VVBAK | Sales Document: Header Data | 88 | ZUONR | Assignment number | nvarchar | 18 | 0 | | |
TOPData Retention Tool |
67 | TXW_S_BSEG | Retrieve BSEG from archive | 28 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPData Transfer |
68 | PPDIT | Transfer to Accounting: Lines in HR IDOCs | 14 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPElectronic Bank Statement |
69 | FEB_ACCNT_SAVE | Saving of Posting Lines for Postprocessing (Account Assign.) | 13 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
70 | FEB_ACT | Acct Assignment Templates | 13 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
71 | FEB_AVIR_EXTD | Advice Note Subitem Enhancement (Bank Statement Postproc.) | 10 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
72 | FEB_ITEM_SAVE | Saving of Posting Items for Postprocessing (On Account) | 19 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPFinancial Accounting |
73 | /OPT/VIM_1HEAD | Document Header | 171 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
74 | /OPT/VIM_1ITEM | Document Item | 24 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
75 | ACCTIT | Compressed Data from FI/CO Document | 185 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
76 | AVIP | Payment Advice Line Item | 17 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
77 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 8 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
78 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 8 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
79 | BSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 6 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
80 | BSID | Accounting: Secondary Index for Customers | 8 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
81 | BSIK | Accounting: Secondary Index for Vendors | 8 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
82 | BSIS | Accounting: Secondary Index for G/L Accounts | 6 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
83 | EBSEG | Doc.Segment of Fin.Accntng External Documents | 28 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
84 | KMZEI | FI: Account Assignment Model Item Information | 16 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
85 | KOMU | Account Assignment Templates for G/L Account Items | 16 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
86 | VBSEGA | Document Segment for Document Parking - Asset Database | 21 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
87 | VBSEGD | Document Segment for Customer Document Parking | 30 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
88 | VBSEGK | Document Segment for Vendor Document Parking | 35 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
89 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 25 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPFlexible Real Estate Management |
90 | VIXCOTDOC | COA, Distribution of VAT, Documents | 18 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPFunds Management-Specific Postings |
91 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 27 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
92 | PSOSEGA | Document Segment for Assets Document Parking | 22 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
93 | PSOSEGD | Document Segment: Recurring Request, Customer | 31 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
94 | PSOSEGK | Recurring Request Document Segment, Vendors | 36 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
95 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 26 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPGeneral Ledger Accounting |
96 | BSEG_ADD | Entry View of Accounting Document for Additional Ledgers | 16 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
97 | FAGLBSAS | Accounting: Secondary Index for G/L Accounts (Cleared Items) | 6 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
98 | FAGLBSIS | Accounting: Secondary Index for G/L Accounts | 6 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPGL transfer |
99 | BKKC02 | General Ledger: Posting Totals for FI | 20 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
100 | BKKCNOITGL | Table of Items not Updated on the Account | 37 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
101 | BKKITGL | Gen. Ledger: Payment Item Data | 24 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
102 | TBKKCASS | GL Account Assignment | 14 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPInformation System |
103 | BWPOS | Valuations for Open Items | 19 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
104 | DKKOP | Balance Audit Trail | 40 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
105 | DKOKP | Open Item Account Balance Audit Trail | 49 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
106 | DSKOP | Balance Audit Trail | 45 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPInvoice Verification |
107 | RBCO | Document Item, Incoming Invoice, Account Assignment | 66 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
108 | RBKP | Document Header: Invoice Receipt | 65 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPLease Accounting |
109 | FILA_GF_ITEMDATA | Process Data | 52 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPLoans Management |
110 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 171 | ZUONR | Zuordnungsnummer | nvarchar | 18 | 0 | | |
111 | VDBEKI | Flow Data: Document Header for Actual Record | 23 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
112 | VDBEKI_SHADOW | Shadow Table for VDBEKI (Restrictions) | 23 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
113 | VDBEPP | Flow Data - Planned Item | 25 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
114 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 25 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
115 | VDCFWAREHOUSE | Cash Flow Management | 66 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
116 | VDORDER | Borrower's note loan order data | 66 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
117 | VZFZE_VDBEKI | Central Entry Table for Release Procedure | 26 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
118 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 28 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPLocal Currency Changeover |
119 | EWUMMFI | EMU: transfer table for clearing entries MM-FI | 6 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPLocalization |
120 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 91 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
121 | J_3RSL_BK_TABLE | Transparent table for SaleBook (ALV) | 98 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
122 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 90 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
123 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 90 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
124 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 90 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPPatient Accounting |
125 | NVBRK | IS-H: Billing document header data | 53 | ZUONR | Assignment number | nvarchar | 18 | 0 | | |
126 | TN21Z | IS-H: Incoming Payments Control Parameters | 11 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPPayment Transactions |
127 | FPRL_ITEM | Item Data | 59 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPPeriodical Sales and Distribution |
128 | JFXBPOSDL | IS-M: Backup Transfer Internal Table XBPOS | 14 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
129 | JKACCFIZUO | IS-M/SD: Payment Log - FI Document Data at Cycle Level | 10 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPReal Estate Management |
130 | VIAKBSEG | Document Line Item from SCS for Interface | 30 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
131 | VIMIIP | Invoice Items | 13 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
132 | /BEV1/RBVBAK | Sales Document: Header Data | 88 | ZUONR | Assignment number | nvarchar | 18 | 0 | | |
133 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 46 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
134 | /BEV3/CHABELFLUS | Contract Statement Document Flow | 16 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPRouting |
135 | PLMZ | Allocation of bill of material items to operations | 4 | ZUONR | No. for material comp. allocation to task list | nvarchar | 8 | 0 | | |
TOPRouting EBOM Assignment |
136 | /PLMI/RTGRCALNKH | Routing Component Assignment Link | 12 | ZUONR | No. for material comp. allocation to task list | nvarchar | 8 | 0 | | |
TOPSales |
137 | VBAK | Sales Document: Header Data | 88 | ZUONR | Assignment number | nvarchar | 18 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
138 | NWCHLS_RNLSR | IS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR) | 151 | ZUONR | | nvarchar | 10 | 0 | | |
TOPSimulation |
139 | VSVBAK_CN | Version: Sales document: Header data | 89 | ZUONR | Assignment number | nvarchar | 18 | 0 | | |
TOPTransaction Manager |
140 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 95 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
141 | OTC_CONV_IFHAPO | Backup Table for Underlying Transaction Flows | 72 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
142 | VTBFHA | Transaction | 38 | ZUONR | Finance Project | nvarchar | 13 | 0 | | |
143 | VTBFHAPO | Transaction Flow | 95 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
144 | VTBFHAPO_MIGR | Migrated Financial Flows | 95 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
145 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 95 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
146 | VTIFHA | Underlying transaction | 36 | ZUONR | Finance Project | nvarchar | 13 | 0 | | |
147 | VTIFHAPO | Underlying transaction flows | 72 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |
TOPTreasury |
148 | VZZUSP | Payment splitting | 18 | ZUONR | Assignment Number | nvarchar | 18 | 0 | | |