| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GSINS/INH_EXTDE | External Transfers (in HCM infotype 0011) | 59 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
2 | /OPT/VIM_STG_LIF | Table: Staging data - Vendor master for ICC | 20 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
3 | BBP_PDIGP | Business Transaction Item-Purchasing Information | 110 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
4 | BBP_RBKP | Document Header: Invoice Receipt | 52 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
5 | BSEG | Accounting Document Segment | 160 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
6 | BSSEG | Accounting Document Segment | 149 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
7 | FUDT_VDOCBSEG | Verification Document Item with Additional Info | 149 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
8 | FUDT_VDOCBSEGEV | Verification Document Item in the Entry View | 149 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
9 | FUDT_VDOCBSEGH | Verification Document Segment with Additional Info(History) | 149 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
10 | GLPOS_C_CT | FI Document: Entry View | 104 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
11 | GLPOS_C_DEB_CT | GLPOS_C_CT Customer Line Items | 104 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
12 | GLPOS_C_GL_CT | GLPOS_C_CT G/L Line Items | 104 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
13 | GLPOS_C_VEN_CT | GLPOS_C_CT Vendor Line Items | 104 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
14 | GLPOS_N_CT | New General Ledger: Line Item with Currency Type | 106 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
15 | GLPOS_N_GL_CT | New General Ledger: Line Item with Currency Type | 106 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
16 | P2RH_HU_MEMB | P21MB | 23 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
17 | P2RX_BT | Payroll Results: Bank Transfers | 28 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
18 | P2RX_BT_PERSON | Payment-Related Information (Person) | 30 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
19 | REGUP | Processed items from payment program | 72 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
20 | T77PAYKZBT | Bank Transfer Table Image (BTKZ) | 45 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
TOPAccounting Interface |
21 | GLE_FI_ITEM_MODF | ECS: Modified FI Line Items (Header/Item/Currency Data) | 231 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
22 | GLE_FI_ITEM_ORIG | ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F) | 231 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
TOPBusiness Partner |
23 | TIVBPVENDORGEN | Vendor Preassignment (General Data) | 15 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
TOPCollectionsDisbursements |
24 | VVSCPOSESR | Payment Plan Item: ISR Attachment | 6 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
TOPContract Accounts Receivable and Payable |
25 | DFKKESR | POR Payment Supplement | 4 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
26 | DPAY_CHEZAG | ZTF Switzerland: Assignment of POR Number to Document Number | 9 | ESRNR | Character field of 9 digits | nvarchar | 9 | 0 | | |
TOPFinancial Accounting |
27 | LFA1 | Vendor Master (General Section) | 32 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
28 | VBSEGK | Document Segment for Vendor Document Parking | 88 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
TOPFunds Management-Specific Postings |
29 | PSOSEGK | Recurring Request Document Segment, Vendors | 89 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
TOPInformation System |
30 | DKKOS | Balance Audit Trail | 57 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
31 | DKOKS | Open Item Account Balance Audit Trail Master Record | 60 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
TOPInvoice Verification |
32 | RBKP | Document Header: Invoice Receipt | 52 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
33 | RBKPB | Invoice Document Header (Batch Invoice Verification) | 47 | ESRNR | Obsolete: ISR subscriber number: do NOT use | nvarchar | 11 | 0 | | |
TOPPayment Transactions |
34 | FPRL_ITEM | Item Data | 48 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
35 | REGUP_CORE | Processed Items from Payment Program | 31 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
TOPPayroll |
36 | T5T1L | Bank accounts of authorities (tax,insurance) | 12 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
37 | T5TA1 | External transfers | 37 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
38 | T5TPS1L | Bank accounts of authorities (tax,insurance) | 14 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
39 | T5TSPO | Table for convert bank accounts (Ceska Sporitelna) | 9 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
40 | T7SI1L | Bank accounts of authorities (tax,insurance) | 9 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
41 | T7SIA6 | Bank transfer - interface table | 21 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
42 | T7SIBT | Virman configuration (WT->Accounts) | 17 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
43 | T7SIBU | Bank Units Slovenia | 8 | ESRNR | PNR številka udeleženca | nvarchar | 11 | 0 | | |
44 | T7SK1L | Bank accounts of authorities (tax,insurance) | 15 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
45 | T7SKA1 | External transfers | 37 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
46 | T7SKEC0009 | Logovacia tabulka pre EURO konverziu - IT 0009 | 48 | ESRNR | Císlo úcastníka PPRC | nvarchar | 11 | 0 | | |
47 | T7SKEC0011 | Logovacia tabulka pre EURO konverziu - IT 0011 | 53 | ESRNR | Císlo úcastníka PPRC | nvarchar | 11 | 0 | | |
TOPPersonnel Administration |
48 | PA0009 | HR Master Record: Infotype 0009 (Bank Details) | 45 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
49 | PA0011 | HR Master Record: Infotype 0011 (Ext.Bank Transfers) | 50 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
50 | PA0057 | HR Master Record: Infotype 0057 (Membership Fees) | 40 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
51 | T521B | Payee Keys | 22 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
TOPRecruitment |
52 | PB0009 | HR Master Record: Infotype 0009 (Bank Details) | 45 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
TOPRemaining Beverage - Obsolete Objects |
53 | /BEV3/CH1030BSG1 | Document Segment CH Event Ledger Part1 | 151 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
TOPRussia |
54 | T7RU1B | Payee Keys of receiving orders (Russia standard) | 26 | ESRNR | ISR Subscriber Number | nvarchar | 11 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
55 | NWCH80 | IS-H CH: ELACH Datenempfang; Ablage Nachrichten feldweise | 16 | ESRNR | IS-H CH: numero OPR | nvarchar | 27 | 0 | | |