| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /BIC/B0000165000 | PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta | 13 | MABER | | nvarchar | 2 | 0 | | |
2 | /BIC/B0000166000 | PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta | 13 | MABER | | nvarchar | 2 | 0 | | |
3 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 32 | MABER | | nvarchar | 2 | 0 | | |
4 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 32 | MABER | | nvarchar | 2 | 0 | | |
5 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 38 | MABER | | nvarchar | 2 | 0 | | |
6 | /SMD/MD_____00NH | SID-Tabelle fuer Dunning Area | 4 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
7 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 66 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
8 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 69 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
9 | BSEG | Accounting Document Segment | 159 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
10 | BSID_BAK | Accounting: Secondary Index for Customers | 66 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
11 | BSIK_BAK | Accounting: Secondary index for vendors | 69 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
12 | BSSEG | Accounting Document Segment | 148 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
13 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 148 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
14 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 148 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
15 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 148 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
16 | GLPOS_C_CT | FI Document: Entry View | 168 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
17 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 168 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
18 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 168 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
19 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 168 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
20 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 171 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
21 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 171 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
22 | MHND | Dunning Data | 29 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
23 | REGUP | Processed items from payment program | 182 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
24 | T047E | Form selection for dunning notices | 5 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
25 | T047M | Dunning areas | 3 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
26 | T047N | Dunning area texts | 4 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPAccount Determination |
27 | TVTA | Organizational Unit: Sales Area(s) | 9 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPAccounting |
28 | TDIOA_TEMPL | Template for Interest On Arrears Calculation | 10 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
29 | VDDUNN_DISP | Dunning run data per loan and dunning run | 5 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPAccounting Interface |
30 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 118 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
31 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 118 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPAdvertising Management |
32 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 84 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPBasic Functions |
33 | KNKKF1 | Credit Management: FI Status Data | 11 | MABER | A/R Summary: Dunning Area (Highest Dunning Level) | nvarchar | 2 | 0 | | |
TOPBilling |
34 | VBRK | Billing Document: Header Data | 54 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPBusiness Partner Enhancements for Financial Services |
35 | MAHNS_DI | Accounts blocked by dunning selection | 5 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPCross-Application Components |
36 | BBSID | Accounting: Secondary index for customers | 66 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPDunning |
37 | MAHNS | Accounts blocked by dunning selection | 5 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
38 | T047I | Standard texts for dunning notices | 3 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPFinancial Accounting |
39 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 66 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
40 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 69 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
41 | BSID | Accounting: Secondary Index for Customers | 66 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
42 | BSIK | Accounting: Secondary Index for Vendors | 69 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
43 | KNB5 | Customer master (dunning data) | 4 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
44 | LFB5 | Vendor master (dunning data) | 4 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
45 | VBSEGD | Document Segment for Customer Document Parking | 79 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
46 | VBSEGK | Document Segment for Vendor Document Parking | 87 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPFlexible Real Estate Management |
47 | TIVXCRACHDUNNA | Dunning Area per Posting Procedure | 4 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPFunds Management-Specific Postings |
48 | PSO06 | Assign Revenue Type/Dunning Area | 4 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
49 | PSO47 | Assign Dunning Procedure to Dunning Area | 3 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
50 | PSOSEGD | Document Segment: Recurring Request, Customer | 80 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
51 | PSOSEGK | Recurring Request Document Segment, Vendors | 88 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPInformation System |
52 | BWPOS | Valuations for Open Items | 29 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPLoans Management |
53 | TD47E | Form selection for dunning notices | 4 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
54 | TDDEFPROD | Control Dunning Using Product Type | 4 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
55 | TDREPAY_TEMPL | Table for Payoff and Notice Templates | 32 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
56 | TTONFTVDARL | Test neue Fima: Grunddaten und VDARL | 83 | MABER | Mahnbereich | nvarchar | 2 | 0 | | |
57 | TTONFTVVZZKOPO | Test neue Fima: VVZZKOPO | 30 | MABER | Mahnbereich | nvarchar | 2 | 0 | | |
58 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 153 | MABER | Mahnbereich | nvarchar | 2 | 0 | | |
59 | VDARL | Loans | 69 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
60 | VDBEPI | Posted line items for document header | 50 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
61 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 50 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
62 | VDBEPP | Flow Data - Planned Item | 84 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
63 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 84 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
64 | VDCFWAREHOUSE | Cash Flow Management | 72 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
65 | VDDEF_COUNTER | Number of Times in Arrears per Days Past Due Category | 5 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
66 | VDDUNN | Dunning run data per loan and dunning run | 5 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
67 | VDREPAYMENT | Payoff Master Data | 85 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
68 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 87 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPLocalization |
69 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 41 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
70 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 39 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
71 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 39 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
72 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 39 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPMaster Data |
73 | VDESCROWKOPO0 | TEMPORARY USE: Escrow Condition Items | 29 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPPatient Accounting |
74 | NVBRK | IS-H: Billing document header data | 42 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
75 | TN22P | IS-H: Control Parameters FI Posting Down Payment | 8 | MABER | IS-H: Dunning Area | nvarchar | 2 | 0 | | |
76 | TN22Q | IS-H: Control Parameters FI Posting Copayment Request | 7 | MABER | IS-H: Dunning Area | nvarchar | 2 | 0 | | |
77 | TN22R | IS-H: Control Params FI Posting Copayment/Copay.Cred.Memo | 8 | MABER | IS-H: Dunning Area | nvarchar | 2 | 0 | | |
78 | TN22S | IS-H: Control Parameters FI Posting Down Payment Request | 7 | MABER | IS-H: Dunning Area | nvarchar | 2 | 0 | | |
TOPPeriodical Sales and Distribution |
79 | JFRK | IS-M/SD: Billing - Header Data | 44 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPReal Estate Management |
80 | S407 | Rental agreements | 109 | MABER | Dunning: area | nvarchar | 2 | 0 | | |
81 | VIAKBSEG | Document Line Item from SCS for Interface | 46 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
82 | VIMI04 | Old. replaced in 3.0 with VIMIMV | 88 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
83 | VIMIEV | Supplementary lease-outs | 9 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
84 | VIMIMV | Lease-Out | 68 | MABER | Dunning: area | nvarchar | 2 | 0 | | |
85 | VIRPS407 | Rental agreements | 109 | MABER | Dunning: area | nvarchar | 2 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
86 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 150 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
TOPTreasury |
87 | TZPAB | Financial Assets Management product types | 63 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
88 | VZZKOPO | Table condition items | 32 | MABER | Dunning Area | nvarchar | 2 | 0 | | |
89 | VZZPARO | Partner / Role / Object relationship | 13 | MABER | Dunning Area | nvarchar | 2 | 0 | | |