| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ATL/KPRCPT | Detail of receipt | 35 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
2 | /ATL/KPRCPTKP | Detail of temporary receipt | 35 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
3 | /CCEE/SIFI_RFASD | SI EC Sales List - reported data - deliveries | 3 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
4 | /CCEE/SIFI_RFASL | SI EC Sales List - reported data | 3 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
5 | /CEECV/BEFI_VATD | VAT Report Estonia - document processed from RFUMSV00 | 18 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
6 | /CEECV/BVFI_PVN | Documents for VAT Declaration | 17 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
7 | /CEECV/RORFMDATA | RO RFUMSV00 official run data | 14 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
8 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 86 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
9 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 93 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
10 | BSEG | Accounting Document Segment | 199 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
11 | BSET | Tax Data Document Segment | 16 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
12 | BSID_BAK | Accounting: Secondary Index for Customers | 86 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
13 | BSIK_BAK | Accounting: Secondary index for vendors | 93 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
14 | BSSEG | Accounting Document Segment | 188 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
15 | CNV_20100_T001 | CNV backup copy for T001 | 28 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
16 | CNV_20200_T001AD | Original settings of company codes (additional fields) | 9 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
17 | DFKKHUREPDS | Recording Data for Domestic Sales Hungary | 26 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
18 | FIAPPTD_BALANCE | Table to store the Balances for Vendor/Customer/Bank Account | 22 | STCEG | Counterpart ID or VAT Registration Number | nvarchar | 20 | 0 | | |
19 | FIAPPTD_TRANS | Table to store the transaction details of the CBR PT | 27 | STCEG | Counterpart ID or VAT Registration Number | nvarchar | 20 | 0 | | |
20 | FISKD_VATCNTRL | Document's information reported to SK authorities | 13 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
21 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 188 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
22 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 188 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
23 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 188 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
24 | FUDT_VDOCBSET | Tax Data Document Segment of Verification Document | 16 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
25 | FUDT_VDOCBSETH | Tax Data Document Segment of Verification Document(History) | 16 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
26 | GLPOS_C_CT | FI Document: Entry View | 236 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
27 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 236 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
28 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 236 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
29 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 236 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
30 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 244 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
31 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 244 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
32 | REGUP | Processed items from payment program | 90 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
33 | TZD0A | Darwin: Customer default values per trans. type for KNA1 | 20 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPAccounting Interface |
34 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 125 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
35 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 125 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPAdvertising Management |
36 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 92 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPAgency Business Global Trade |
37 | WBPA | Agency Business: Business Partner Assignment | 18 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
38 | WBRK | Agency business: Header | 151 | STCEG | Vendor VAT registration number | nvarchar | 20 | 0 | | |
TOPBasic Functions |
39 | VBPA | Sales Document: Partner | 21 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPBasis Components |
40 | ZDS400_T001 | Buchungskreise | 27 | STCEG | Umsatzsteuer-Identifikationsnummer | nvarchar | 20 | 0 | | |
TOPBilling |
41 | VBRK | Billing Document: Header Data | 57 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPBusiness Partner |
42 | TIVBPVENDORGEN | Vendor Preassignment (General Data) | 38 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPBusiness Partner Enhancements for Financial Services |
43 | BP1020 | BP: Business Partner - Fiscal Data | 10 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPContract Accounts Receivable and Payable |
44 | DFKKREP01 | Data for Sales Lists (Belgium) | 3 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
45 | DFKKREP02 | Data for Sales Lists (Belgium) | 3 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
46 | DFKKREPZM | Recording Data for EC Sales List | 22 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
47 | FKK_JFRK_SHORT | Header Data for IS-M/SD Billing Document - Extracts | 25 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
48 | FKK_JLRK_SHORT | Header Data for IS-M/SD Service Settlement - Extracts | 23 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPCross-Application Components |
49 | BBSID | Accounting: Secondary index for customers | 86 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
50 | BC490KKNA1 | General data in customer master | 64 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
51 | KKNA1 | General Data in Customer Master | 64 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
52 | SKNA1 | Customer Master table for BC417 Course | 64 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
53 | VBBPA | Sales Document: Partner | 21 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
54 | VVBBPA | Sales Document: Partner | 21 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
55 | VVVBPA | Sales Document: Partner | 21 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPCustomer Master |
56 | KNA1 | General Data in Customer Master | 64 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPData Retention Tool |
57 | TXW_S_BSEG | Retrieve BSEG from archive | 94 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
58 | TXW_S_VBRK | Retrieve VBRK from archive | 34 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPERS |
59 | ISAERSLIST | ERS Collective Settlement List | 19 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPFinancial Accounting |
60 | /CCEE/SIFIDDV | Special Tax Table | 10 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
61 | /CCEE/SIFIPE17 | Temporary import of goods | 17 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
62 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 86 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
63 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 93 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
64 | BSID | Accounting: Secondary Index for Customers | 86 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
65 | BSIK | Accounting: Secondary Index for Vendors | 93 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
66 | FOTRFDITM | VAT Refund Items | 51 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
67 | FOTRFDITMCHG | Change Documents, VAT Refund Item | 25 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
68 | KNAS | Customer master (VAT registration numbers general section) | 4 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
69 | LFA1 | Vendor Master (General Section) | 55 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
70 | LFAS | Vendor master (VAT registration numbers general section) | 4 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
71 | T001 | Company Codes | 14 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
72 | T001N | Company Code - EC Tax Numbers / Notifications | 4 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
73 | VBSEGD | Document Segment for Customer Document Parking | 80 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
74 | VBSEGK | Document Segment for Vendor Document Parking | 93 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
75 | VBSEGS | Document Segment for Document Parking - G/L Account Database | 64 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPFunds Management-Specific Postings |
76 | FMFUNDTRANSYEAR | Additional Documents for Funds Transfer to Diff. Years | 63 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
77 | PSOSEGD | Document Segment: Recurring Request, Customer | 81 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
78 | PSOSEGK | Recurring Request Document Segment, Vendors | 94 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
79 | PSOSEGS | Recurring Request Document Segment, G/L Accounts | 62 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPGL Account Posting |
80 | TCJ_POSITIONS | Cash Journal Document Items | 98 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPInformation System |
81 | DKKOP | Balance Audit Trail | 64 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
82 | DSKOP | Balance Audit Trail | 76 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
83 | QSTRE | FI/HR Withholding Tax Report for Spain | 12 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
84 | RFASLD11B | EC Sales List (Spain) | 5 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPIntercompany Data Exchange |
85 | TINV_HEAD_SHORT | Extract of Bill Receipt (Evaluation System): Bill Header | 8 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
86 | TINV_INV_HEAD | Bill Header | 14 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPInvoice Verification |
87 | RBKP | Document Header: Invoice Receipt | 116 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPLocalization |
88 | RFASLD15 | EC Sales List for new EU Countries | 5 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
89 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 146 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
90 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 146 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
91 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 146 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPPayment Transactions |
92 | FPRL_ITEM | Item Data | 53 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
93 | REGUP_CORE | Processed Items from Payment Program | 30 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPPeriodical Sales and Distribution |
94 | JFRK | IS-M/SD: Billing - Header Data | 46 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
95 | JLRK | IS-M/SD: Settlement Header Data | 30 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPPurchasing |
96 | EKKO | Purchasing Document Header | 69 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
97 | /BEV1/RBVBPA | Sales Document: Partner, Copy VBPA for Indirect Orders | 21 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
98 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 190 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPThird Party ManagementCOA |
99 | VIMMMN | Mandate | 24 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
TOPTravel Expenses |
100 | PTRV_VATDETAIL | Supplier Data for VAT Refund in Travel Management | 8 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |
101 | T706_VAT_FLDS | Country-Dependent Field Control for Receipt Data | 11 | STCEG | VAT Registration Number | nvarchar | 1 | 0 | | |
TOPTreasury |
102 | VZKNA1 | Collector for batch input KNA1 from RF-VV | 43 | STCEG | VAT Registration Number | nvarchar | 20 | 0 | | |