| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /SAPF15/SM | F15 SEPA Mandat | 14 | MNDID | Eindeutige Referenz auf das Mandat je Zahlungsempfänger | nvarchar | 35 | 0 | | |
2 | BKKPOMND | Payment order Enriched with Mandate details | 4 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
3 | BKK_SEPA_LIM_EV | Event Table for Mandate Limits | 9 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
4 | BKK_SEPA_LIM_HIS | History Table for Mandate Limits | 10 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
5 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 172 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
6 | BSEG | Accounting Document Segment | 327 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
7 | BSID_BAK | Accounting: Secondary Index for Customers | 172 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
8 | DFKKPRNH | SEPA: Direct Debit Pre-Notifications (FI-CA) | 8 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
9 | DFKK_SEPA_IDS | SEPA: Short Key for Mandate Reference | 4 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
10 | GLPOS_C_CT | FI Document: Entry View | 349 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
11 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 343 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
12 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 343 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
13 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 343 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
14 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 358 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
15 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 352 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
16 | P2RX_BT | Payroll Results: Bank Transfers | 35 | MNDID | SEPA Mandate: Unique Reference to Mandate per Creditor | nvarchar | 35 | 0 | | |
17 | P2RX_BT_PERSON | Payment-Related Information (Person) | 37 | MNDID | SEPA Mandate: Unique Reference to Mandate per Creditor | nvarchar | 35 | 0 | | |
18 | RDPT_CONDITION | Condition within Redemption Schedule | 73 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
19 | SEPA_MDTENQ_MULT | SEPA Mandate: Auxilliary Table for Multiple Enqueue | 7 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
20 | T77PAYKZBT | Bank Transfer Table Image (BTKZ) | 52 | MNDID | SEPA Mandate: Unique Reference to Mandate per Creditor | nvarchar | 35 | 0 | | |
21 | VDSEPA_MND_USG | Overview of mandates used in Loans Management | 17 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPAdvertising Management |
22 | JHAISZ | IS-M/AM: Assignment Table of Advertisers for OPM Order | 68 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
23 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 63 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
24 | JHWWWTEMP_ORDER | IS-M/AM: Temporary Table for Order Data from the Internet | 58 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPAgency Business Global Trade |
25 | WBRK | Agency business: Header | 172 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPBank |
26 | SEPA_MANDATE | SEPA Mandate | 3 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
27 | SEPA_MANDATE_ENQ | SEPA Mandate: Internal Table for ENQUEUE | 2 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPBilling |
28 | VBRK | Billing Document: Header Data | 106 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPCollectionsDisbursements |
29 | VVSCPOS | Payment Plan Item | 144 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPContract Accounts Receivable and Payable |
30 | DFKKDDA | Debit Memo Notification | 37 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
31 | DFKKIP_GRP | Payment Specification: Header Data | 10 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
32 | DFKKIP_GRPH | Payment Specification: Payment Data (History) | 12 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
33 | DPAYH | Payment program - data for payment | 102 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
34 | FKKPREPACC | Master Data for Prepaid Account | 30 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
35 | FKKVKP | Contract Account Partner-Specific | 89 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPFinancial Accounting |
36 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 172 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
37 | BSID | Accounting: Secondary Index for Customers | 172 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPLoans Management |
38 | VDBEPI | Posted line items for document header | 155 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
39 | VDBEPI_SHADOW | Shadow Table for VDBEPI (Restrictions) | 154 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
40 | VDBEPP | Flow Data - Planned Item | 179 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
41 | VDBOBEPP | Business Operation: Entered and Activated Flow Data | 179 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
42 | VDCFWAREHOUSE | Cash Flow Management | 88 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
43 | VDDEBTTRANS | Borrower Change Without Capital Transfer | 22 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
44 | VDGPO | Loan: Relationship Partner/Role Object | 22 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
45 | VDREPAYMENT | Payoff Master Data | 88 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
46 | VDZV | Payment Details for the Loan | 26 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
47 | VZFZE_VDBEPP | Central Entry Table for Release Procedure | 182 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPLogistics - General |
48 | WBHD | Trading Contract: Commercial Data | 80 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPOutgoing Payments |
49 | VDDISB | Disbursement Specific Header Data | 21 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPPayment Transactions |
50 | FPRL_ITEM | Item Data | 171 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPPeriodical Sales and Distribution |
51 | JFRK | IS-M/SD: Billing - Header Data | 88 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
52 | JKKD | Sales Order: Business Data | 44 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
53 | JKWWWTEMP_ORDER | IS-M/SD: WWW Temporary Table for Order Data from Internet | 84 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
54 | JKWWWTEMP_PAY | IS-M: Temporary Internet Table: Payment Data Change | 10 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
55 | JNTRECH | IS-M/SD: Research | 71 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPPortfolio |
56 | VDDEFERRAL | Deferral Data | 57 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
57 | DPSOB_BP_ACC | Data for Contract Object for Each Partner & Cont. Acct Cat. | 31 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPSales |
58 | VBKD | Sales Document: Business Data | 94 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPTransaction Manager |
59 | OTC_CONV_FHAPO | Backup Table for Financial Transaction Flows | 171 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
60 | TRDT_FLOW | Persistent distributor flows | 87 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
61 | VTBFHAPO | Transaction Flow | 171 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
62 | VTBFHAPO_MIGR | Migrated Financial Flows | 171 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
63 | VTBFHAPO_UNFIXED | Non-Fixed Financial Transaction Flows | 171 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
64 | VTBZV | Payment Details for Transaction | 31 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPTransfer to Financial Accounting |
65 | TRACT_ACCITEM | Accounting Items | 44 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
66 | TRPRT_PAYMENTS | Persistent Data for Payment Requests | 58 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
TOPTreasury |
67 | VZZKOPO | Table condition items | 100 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |
68 | VZZUSP | Payment splitting | 20 | MNDID | Unique Referene to Mandate per Payment Recipient | nvarchar | 35 | 0 | | |