| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /ARBA/AN_ISUINV | Temp table for BTE ISU | 13 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
2 | /BIC/B0000165000 | PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta | 36 | ZLSPR | | nvarchar | 1 | 0 | | |
3 | /BIC/B0000166000 | PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta | 36 | ZLSPR | | nvarchar | 1 | 0 | | |
4 | /BIC/B0000168000 | PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items | 73 | ZLSPR | | nvarchar | 1 | 0 | | |
5 | /BIC/B0000169000 | PSA for 0FI_GL_41 T90CLNT090 Documents, Compact | 73 | ZLSPR | | nvarchar | 1 | 0 | | |
6 | /BIC/B0000172000 | PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items | 86 | ZLSPR | | nvarchar | 1 | 0 | | |
7 | /CCEE/SIFIPOBOTI | ePoboti: Obligatory manysided reconciliation - XML output | 39 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
8 | /CCEE/SIFIPOBXRF | ePoboti: Define reference field, blocking reason | 4 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
9 | BBP_RBKP | Document Header: Invoice Receipt | 66 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
10 | BSAD_BAK | Accounting: Secondary index for customers (cleared items) | 50 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
11 | BSAK_BAK | Accounting: Secondary Index for Vendors (Cleared Items) | 52 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
12 | BSEG | Accounting Document Segment | 117 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
13 | BSID_BAK | Accounting: Secondary Index for Customers | 50 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
14 | BSIK_BAK | Accounting: Secondary index for vendors | 52 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
15 | BSSEG | Accounting Document Segment | 106 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
16 | CID_DB_INB_TARGT | Clearing Partner for PEXR2002 | 17 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
17 | COPC_ACCOUNT | Cash Account | 30 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
18 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 106 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
19 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 106 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
20 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 106 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
21 | GLPOS_C_CT | FI Document: Entry View | 319 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
22 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 319 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
23 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 319 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
24 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 319 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
25 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 328 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
26 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 328 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
27 | MHND | Dunning Data | 33 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
28 | REGUP | Processed items from payment program | 60 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPAccounting Interface |
29 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 123 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
30 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 123 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPAutomatic Payments |
31 | PAYRQ | Payment Requests | 135 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
32 | DPAYP | Payment program - data on paid item | 37 | ZLSPR | Lock Reason for Automatic Payment | nvarchar | 1 | 0 | | |
TOPCross-Application Components |
33 | BBSID | Accounting: Secondary index for customers | 50 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPElectronic Bank Statement |
34 | FEB_AVIR_EXTD | Advice Note Subitem Enhancement (Bank Statement Postproc.) | 11 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
35 | FEB_ITEM_SAVE | Saving of Posting Items for Postprocessing (On Account) | 16 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPExchanges |
36 | OIA08 | LIA Document: Item Data | 20 | ZLSPR | Block Key for Payment | nvarchar | 1 | 0 | | |
TOPExtended Rebate |
37 | BON_ENH_LEDGER | Reconciliation Accounts for Rebate Credit Memos | 8 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPExtra Charge |
38 | /BEV1/ECMITD | Extra Charge Reconciliation Accounts | 9 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPFinancial Accounting |
39 | BSAD | Accounting: Secondary Index for Customers (Cleared Items) | 50 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
40 | BSAK | Accounting: Secondary Index for Vendors (Cleared Items) | 52 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
41 | BSID | Accounting: Secondary Index for Customers | 50 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
42 | BSIK | Accounting: Secondary Index for Vendors | 52 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
43 | FMFGAAPAYBLOCK | Payment block for Partial Payments by Account Assignment | 2 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
44 | VBSEGD | Document Segment for Customer Document Parking | 61 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
45 | VBSEGK | Document Segment for Vendor Document Parking | 67 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPFinancial Supply Chain Management |
46 | IHC_PI_INB_TARGT | PI: Payment Parameters for Inbound IDOC | 17 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPFSCM In-House Cash |
47 | IHC_DB_INB_TARGT | Clearing Partner for PEXR2002 | 17 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPFund Accounting |
48 | FMPP_CONTROL | Partial Payment per G/L Account Assignments: Control Table | 3 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPFunds Management-Specific Postings |
49 | FMPY | IS-PS: Payment Transactions | 9 | ZLSPR | Payment block key | nvarchar | 1 | 0 | | |
50 | PSO37 | Payment Block to be Set Automatically | 5 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
51 | PSOSEGD | Document Segment: Recurring Request, Customer | 62 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
52 | PSOSEGK | Recurring Request Document Segment, Vendors | 68 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPInvoice Verification |
53 | RBKP | Document Header: Invoice Receipt | 66 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPLoans Management |
54 | TTONFTVVZZKOPO | Test neue Fima: VVZZKOPO | 102 | ZLSPR | Schlüssel für Zahlungssperre | nvarchar | 1 | 0 | | |
55 | TTONFTVZZBEPP | Test neue FIMA: VZZBEPP | 256 | ZLSPR | Schlüssel für Zahlungssperre | nvarchar | 1 | 0 | | |
TOPLocalization |
56 | J_3RFTAX_EXTRD | Tax Extract Detail Lines | 89 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
57 | RFITEMAP_NO_ITEM | Item wise detail for the Vendor Transactions | 88 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
58 | RFITEMAR_NO_ITEM | Item wise detail for the Customer Transactions | 88 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
59 | RFITEMGL_NO_ITEM | Item wise detail for the GL Account Transactions | 88 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPMaster Data |
60 | VDESCROWKOPO0 | TEMPORARY USE: Escrow Condition Items | 89 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPPatient Accounting |
61 | TN22S | IS-H: Control Parameters FI Posting Down Payment Request | 19 | ZLSPR | Payment Block | nvarchar | 1 | 0 | | |
TOPPayment Transactions |
62 | FPRL_ITEM | Item Data | 109 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
63 | REGUH | Settlement data from payment program | 83 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
64 | REGUPO | Line item status before the 'n'th change | 13 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
65 | T042U | Block Entries for Debit Customers/Credit Vendors | 7 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPPeriodical Sales and Distribution |
66 | JFXBPOSDL | IS-M: Backup Transfer Internal Table XBPOS | 37 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPReal Estate Management |
67 | VIAKBSEG | Document Line Item from SCS for Interface | 115 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
68 | VIBEPP | Flow data - Planned items for real estate management | 81 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
69 | /BEV1/BO_LEDGER | Reconciliation Accounts for Rebate Credit Memos | 8 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
70 | /BEV1/RBMITD | Rebate Reconciliation Accounts | 8 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
71 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 108 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPTransfer to Financial Accounting |
72 | TRACT_ACCITEM | Accounting Items | 27 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
TOPTreasury |
73 | VZZKOPO | Table condition items | 92 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |
74 | VZZUSP | Payment splitting | 19 | ZLSPR | Payment Block Key | nvarchar | 1 | 0 | | |