| 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 | 38 | MANSP | | nvarchar | 1 | 0 | | |
2 | /BIC/B0000166000 | PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta | 38 | MANSP | | nvarchar | 1 | 0 | | |
3 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 34 | MANSP | | nvarchar | 1 | 0 | | |
4 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 34 | MANSP | | nvarchar | 1 | 0 | | |
5 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 40 | MANSP | | nvarchar | 1 | 0 | | |
6 | /SMD/MD_____00ND | SID-Tabelle fuer Dunning block | 3 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
7 | /SMD/MD_____00ZE | SID-Tabelle fuer Dunning block | 3 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
8 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 62 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
9 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 65 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
10 | BSEG | Accounting Document Segment | 156 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
11 | BSID_BAK | Accounting: Secondary Index for Customers | 62 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
12 | BSIK_BAK | Accounting: Secondary index for vendors | 65 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
13 | BSSEG | Accounting Document Segment | 145 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
14 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 145 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
15 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 145 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
16 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 145 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
17 | GLPOS_C_CT | FI Document: Entry View | 170 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
18 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 170 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
19 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 170 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
20 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 170 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
21 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 173 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
22 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 173 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
23 | MHND | Dunning Data | 28 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
24 | REGUP | Processed items from payment program | 148 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
25 | T028B | Transaction Type of Sender Bank | 12 | MANSP | Set Dunning Block | nvarchar | 1 | 0 | | |
26 | T040S | Blocking reasons for dunning notices | 2 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
27 | T040T | Dunning block reason names | 3 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPAccounting |
28 | TDIOA_TEMPL | Template for Interest On Arrears Calculation | 11 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPAccounting Interface |
29 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 122 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
30 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 122 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPAccounts Receivable Accounting Process Integration |
31 | TFDM_P2PCC | Settings for Promise to Pay per Company Code | 5 | MANSP | Dunning Block for Items with Open Promises to Pay | nvarchar | 1 | 0 | | |
TOPAdvertising Management |
32 | /NAM/TJHBAD_DEBT | Filter Conditions for Customer Bad Debt Accounts | 5 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
33 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 42 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPBank Accounting |
34 | FPS_BLOCK | Payment and Dunning Block for Each Payment Service Provider | 4 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPBasic Functions |
35 | FEBEP | Electronic Bank Statement Line Items | 77 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
36 | FEBPI | Polling Statement Line Item Information | 21 | MANSP | Set Dunning Block | nvarchar | 1 | 0 | | |
37 | T028Z | Returns Activities: Change Open Items | 4 | MANSP | Set Dunning Block | nvarchar | 1 | 0 | | |
TOPBilling |
38 | VBRK | Billing Document: Header Data | 65 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
39 | DFKKMACFCSMK | FICA Dunning - Blocked Accounts | 6 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
40 | DFKKMOP | Items in contract account document | 74 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
41 | DFKKMOPW | Items in contract account document | 15 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
42 | DFKKOP | Items in contract account document | 74 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
43 | DFKKOPW | Items in contract account document | 15 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
44 | DFKKOP_REP | Open Items from FPO4 | 78 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
45 | FKKBEP | Electronic Bank Statement Line Items | 77 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
46 | FKKMAZE | Dunning history of line items | 20 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
47 | FKKVKP | Contract Account Partner-Specific | 40 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
48 | TE305 | Transactions for Company Code and Division | 11 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
49 | TFK047S | Dunning block reasons | 2 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
50 | TFK047ST | Dunning block reason text | 3 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
TOPCross-Application Components |
51 | BBSID | Accounting: Secondary index for customers | 62 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
52 | VVBKD | Sales Document: Business Data | 28 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPDunning |
53 | MHNDO | Dunning data version before the next change | 15 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
54 | MHNK | Dunning data (account entries) | 28 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
55 | MHNKO | Dunning data (acct entries) version before the next change | 29 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPElectronic Bank Statement |
56 | FEB_AVIR_EXTD | Advice Note Subitem Enhancement (Bank Statement Postproc.) | 12 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
57 | FEB_ITEM_SAVE | Saving of Posting Items for Postprocessing (On Account) | 17 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPFinancial Accounting |
58 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 62 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
59 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 65 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
60 | BSID | Accounting: Secondary Index for Customers | 62 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
61 | BSIK | Accounting: Secondary Index for Vendors | 65 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
62 | KNB5 | Customer master (dunning data) | 6 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
63 | LFB5 | Vendor master (dunning data) | 6 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
64 | VBSEGD | Document Segment for Customer Document Parking | 78 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
65 | VBSEGK | Document Segment for Vendor Document Parking | 86 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPFunds Management-Specific Postings |
66 | PAYRC | Additional Header Data for Recovery Order | 10 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
67 | PSOSEGD | Document Segment: Recurring Request, Customer | 79 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
68 | PSOSEGK | Recurring Request Document Segment, Vendors | 87 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPGeneric Contract Accounts Receivable and Payable |
69 | TFSCHVTV | Transactions for Company Code and Division | 11 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
TOPInformation System |
70 | BWPOS | Valuations for Open Items | 28 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPInvoicing |
71 | DEABPS | Customer change table: Logical view of BB amounts | 67 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
72 | EABPS_CORR | Sub Budget Billing Plan for Correspondence Print | 48 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
TOPLoans Management |
73 | TDREPAY_TEMPL | Table for Payoff and Notice Templates | 31 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
74 | TTONFTVVZZKOPO | Test neue Fima: VVZZKOPO | 87 | MANSP | Mahnsperre | nvarchar | 1 | 0 | | |
75 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 191 | MANSP | Mahnsperre | nvarchar | 1 | 0 | | |
76 | TVDST | Posting applications control table | 6 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
77 | VDBEPI | Posted line items for document header | 89 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
78 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 89 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
79 | VDBEPP | Flow Data - Planned Item | 122 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
80 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 122 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
81 | VDCFWAREHOUSE | Cash Flow Management | 85 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
82 | VDREPAYMENT | Payoff Master Data | 86 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
83 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 125 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPLocalization |
84 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 43 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
85 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 41 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
86 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 41 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
87 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 41 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPMaster Data |
88 | EVER | IS-U Cont. | 90 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
89 | VDESCROWKOPO0 | TEMPORARY USE: Escrow Condition Items | 77 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPMove-InOut |
90 | EAUSV | Move-out Doc. Contract Level | 16 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
91 | TE490AV | Move-Out Control: Contract Level | 8 | MANSP | Dunning Lock Reason | nvarchar | 1 | 0 | | |
TOPPatient Accounting |
92 | NVBRK | IS-H: Billing document header data | 47 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
93 | TN22Q | IS-H: Control Parameters FI Posting Copayment Request | 5 | MANSP | IS-H: Dunning Block | nvarchar | 1 | 0 | | |
94 | TN22R | IS-H: Control Params FI Posting Copayment/Copay.Cred.Memo | 32 | MANSP | IS-H: Dunning Block | nvarchar | 1 | 0 | | |
95 | TN22S | IS-H: Control Parameters FI Posting Down Payment Request | 5 | MANSP | IS-H: Dunning Block | nvarchar | 1 | 0 | | |
TOPPortfolio |
96 | VDCOT_VER_CON | Conditions in the Condition Table | 43 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPReal Estate Management |
97 | S407 | Rental agreements | 107 | MANSP | Dunning: Blocking reason | nvarchar | 1 | 0 | | |
98 | TZK02 | Condition group, condition group - condition type allocation | 43 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
99 | VIAKBSEG | Document Line Item from SCS for Interface | 47 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
100 | VIMI04 | Old. replaced in 3.0 with VIMIMV | 94 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
101 | VIMIEV | Supplementary lease-outs | 10 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
102 | VIMIMV | Lease-Out | 74 | MANSP | Dunning: Blocking reason | nvarchar | 1 | 0 | | |
103 | VIRPS407 | Rental agreements | 107 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
104 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 147 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
105 | /BEV3/CHRGMHNSP | Dunning Block Rule | 10 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPSales |
106 | VBKD | Sales Document: Business Data | 28 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
107 | TN22F | IS-H: Steuerungsparameter FI-Buchung amb. Zuzahl.anforderung | 5 | MANSP | IS-H: Mahnsperre | nvarchar | 1 | 0 | | |
108 | TN22G | IS-H: Steuerungsparameter FI-Buchung amb. Zuzahlung | 5 | MANSP | IS-H: Mahnsperre | nvarchar | 1 | 0 | | |
TOPSimulation |
109 | VSVBKD_CN | Version: Sales document - commercial data | 29 | MANSP | Dunning block | nvarchar | 1 | 0 | | |
TOPTreasury |
110 | VZZKOPO | Table condition items | 80 | MANSP | Dunning block | nvarchar | 1 | 0 | | |