| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /GSINS/INH_EXTDE | External Transfers (in HCM infotype 0011) | 68 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
2 | /OPT/VIM_STG_LIF | Table: Staging data - Vendor master for ICC | 29 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
3 | /OPT/WT_3S_PYMNT | Supplier Self Service Payment Information | 29 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
4 | BBP_SUS_STG_BANK | Staging Bank table | 14 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
5 | BKK_OPD_RCN_AC | Reconciliation Accounts for Outgoing Payment Dispatcher | 9 | IBAN | International Bank Account Number | nvarchar | 35 | 0 | | |
6 | BKK_PXPO_ORDER | Collective Payment Order | 12 | IBAN | International Bank Account Number | nvarchar | 35 | 0 | | |
7 | FIAPSAD_ORDR_HD | Order Number Header KSA | 32 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
8 | P05EIR_ADM_UNIT | Electronic Illness Reporting: Administrative Unit Data | 12 | IBAN | IBAN (International Bank Account Number) | nvarchar | 42 | 0 | | |
9 | P05EIR_PERSOON | Electronic Illness Reporting: Natural Person Data | 11 | IBAN | IBAN (International Bank Account Number) | nvarchar | 42 | 0 | | |
10 | P2RB_I0125 | Garnishment payroll Belgium | 45 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
11 | P2RF_SAR | Payroll Results: Garnishment | 28 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
12 | P2RG_COURT | Types of Court Order (GB) | 38 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
13 | P2RX_BT | Payroll Results: Bank Transfers | 33 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
14 | P2RX_BT_PERSON | Payment-Related Information (Person) | 35 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
15 | SEPA_CI_PROC | SEPA CI Limits and CI Whitelist | 5 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
16 | SEPA_CI_PROC_ENQ | SEPA CI Limit: Auxilliary Table for ENQUEUE | 4 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
17 | SEPA_CI_PROC_HIS | SEPA CI Limits and CI Whitelist | 6 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
18 | T536C_BANK | Bank Details for Public Sector Employer | 13 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
19 | T5D1KK | Account Data from Contribution Rate File | 6 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
20 | T77PAYKZBT | Bank Transfer Table Image (BTKZ) | 50 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
21 | VDZNB_SEPA | Pmnt Postproc.: Storage of SEPA Return Data | 9 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
22 | HRP1890 | DB Table for Infotype 1890 | 73 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPAdvertising Management |
23 | JHAISZ | IS-M/AM: Assignment Table of Advertisers for OPM Order | 53 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
24 | JHTFK | IS-M/AM: Settlement Documents (Billing, Commission) - Header | 62 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
25 | JHWWWTEMP_ORDER | IS-M/AM: Temporary Table for Order Data from the Internet | 57 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPAustria |
26 | PA0136 | HR Master Record: Infotype 0136 (Garn. Transfer A) | 48 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
27 | PA0526 | HR Master Record: Infotype 0526 | 144 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
28 | PA0662 | HR Master Record: Infotype 0662 | 33 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPBank |
29 | TIBAN | IBAN | 6 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPBank Master Data |
30 | TBCHAIN0 | Definition bank chains | 10 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
31 | TBCHAIN21 | Bank chains per business partner account (allocation) | 14 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPBelgium |
32 | PA0125 | HR Master Record: Infotype 0125 (Garnishment B) | 52 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
33 | T5B1S | Companies | 17 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
34 | T5B9A | Institutions (B) | 35 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPBrazil |
35 | PA0736 | Alimony order for Brazil | 53 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPChile |
36 | PA3235 | HR Master Record: Infotype 3235 | 43 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPCompany Pension Scheme Germany |
37 | P01CBT | Transfer Records for Reimbursement of Contributions CPS | 28 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPConstruction Industry |
38 | PDBKAN | Construction Industry Social Fund Proced: ANMEL Data Records | 45 | IBAN | IBAN | nvarchar | 34 | 0 | | |
TOPContract Accounts Receivable and Payable |
39 | DFKKRH | Returns History | 27 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
40 | DFKKRP | Returns lot: Data for payment | 46 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
41 | DFKKZA | Repayment Request | 41 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
42 | DFKKZP | Payment lot: Data for payment | 73 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
43 | FKK_GPSHAD | Data Extract: Business Partner Data (Faster Access) | 44 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
44 | TFK006Y | IBAN Exceptions for Clarification Proposal | 2 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
45 | TFK006YS | IBAN Exceptions for Clarification Proposal | 2 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
46 | TFK006YT | Exception Accounts for Clarification Proposal | 3 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPCross-Application Objects in HR |
47 | HRP5584 | DB Table for Infotype 5584 | 22 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPFinancial Accounting |
48 | /OPT/VIM_1HEAD | Document Header | 151 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPFrance |
49 | PA0272 | Infotype 0272 (Garnishment) | 49 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPGeneric Contract Accounts Receivable and Payable |
50 | BCA_DIM_BU_PAY_D | Payment Details of a Business Partner | 3 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPGermany |
51 | PA0010 | HR Master Record: Infotype 0010 (Capital Formation) | 52 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
52 | PA0026 | HR Master Record: Infotype 0026 (Company Insurance) | 55 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
53 | PA0116 | HR Master Record: Infotype 0116 (Garn. Transfer D) | 46 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
54 | PA0699 | Personnel Master Record Infotype 0699 | 137 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
55 | T5D1H | Supplementary Insurance | 17 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
56 | T5D1K | Branch Offices | 26 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPGreat Britain |
57 | PA0070 | HR Master Record: Infotype 0070 (Court Orders - GB) | 57 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPHong Kong |
58 | T7HK2H | Provider Attributes | 19 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPIntercompany Data Exchange |
59 | TINV_INV_BANK | Bank Data for Bill or Payment Advice Note | 10 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPLoans Management |
60 | VDAUSZ | Drawings on Disbursement | 58 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
61 | VDZNB_USAGE | Payment Postprocessing: Usage of a Payment Postpr. Activity | 78 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
62 | VZFZE_VDAUSZ | Central Entry Table for Release Procedure | 60 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
63 | VZFZE_VDNBZE | Central Entry Table for Release Procedure | 86 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPMaster Data |
64 | BKK615 | Data for External Root Accounts Cash Concentration | 4 | IBAN | International Bank Account Number | nvarchar | 35 | 0 | | |
65 | VDDISBTEMP | Disbursements That Were Not Released | 32 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPMedia Sales and Distribution |
66 | /NAM/PAY_CH | Workload for Check Payments | 22 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPMexico |
67 | PA0426 | Garnishment | 50 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPMove-InOut |
68 | ECAMIOPRBANK | IS-U: Pre-entry Document: Bank Details | 10 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPNetherlands |
69 | T5N9R | Relationship Repr. Legal Person and External Agencies | 10 | IBAN | IBAN (International Bank Account Number) | nvarchar | 42 | 0 | | |
TOPPayment Transactions |
70 | TFIBLAPARPVAR | Online Payment: Variants | 13 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPPayroll |
71 | T5T1L | Bank accounts of authorities (tax,insurance) | 27 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
72 | T5TA1 | External transfers | 64 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
73 | T7SIA6 | Bank transfer - interface table | 14 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
74 | T7SIBT | Virman configuration (WT->Accounts) | 13 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
75 | T7SK1L | Bank accounts of authorities (tax,insurance) | 29 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
76 | T7SKA1 | External transfers | 64 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
77 | T7SKEC0009 | Logovacia tabulka pre EURO konverziu - IT 0009 | 62 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
78 | T7SKEC0011 | Logovacia tabulka pre EURO konverziu - IT 0011 | 62 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPPension fund Netherlands |
79 | T5NH5 | Werkgeversdata van de aan het pensioenfonds verbonden deeln. | 17 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPPension Fund Switzerland |
80 | PA3230 | Personnel Master Record for Infotype 3230 | 48 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPPeriodical Sales and Distribution |
81 | JFRK | IS-M/SD: Billing - Header Data | 89 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
82 | JKWWWTEMP_ORDER | IS-M/SD: WWW Temporary Table for Order Data from Internet | 83 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
83 | JKWWWTEMP_PAY | IS-M: Temporary Internet Table: Payment Data Change | 9 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
84 | JNTRECH | IS-M/SD: Research | 72 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPPersonnel Administration |
85 | PA0009 | HR Master Record: Infotype 0009 (Bank Details) | 59 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
86 | PA0011 | HR Master Record: Infotype 0011 (Ext.Bank Transfers) | 59 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
87 | PA0226 | Személyzeti törzsrekord 0164 infotípus tábla (TB - Magyaro.) | 86 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
88 | T521B | Payee Keys | 27 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPPersonnel Management |
89 | T7HRA1 | Bank transfer - interface table | 14 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPPublic Sector |
90 | T5D8S_BANK | Bank Details for Payroll Numbers | 12 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
91 | DFMCA_BRF650 | BRF: Business Partner Reading | 16 | IBAN | BRF: Expression | nvarchar | 20 | 0 | | |
92 | DFMCA_BRF800 | BRF: Create/Update Bank Details ID | 13 | IBAN | BRF: Expression | nvarchar | 20 | 0 | | |
93 | DFMCA_BRF890 | BRF: Business Partner Determination from Form | 17 | IBAN | BRF: Expression | nvarchar | 20 | 0 | | |
TOPReceivablesPayment Management |
94 | VDAD_RESULT | Result Table for Auto Debit Collection | 22 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPRecruitment |
95 | PB0009 | HR Master Record: Infotype 0009 (Bank Details) | 59 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPReporting |
96 | P05TPRNL_EE_PD | Pension Return: Personal Data - Pers Level | 34 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPRussia |
97 | T7RU1B | Payee Keys of receiving orders (Russia standard) | 28 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPSocial Insurance |
98 | T5D31 | Professionals Pension Organization (PPO) | 17 | IBAN | IBAN of a Professionals Pension Organization | nvarchar | 34 | 0 | | |
TOPSpain |
99 | PA0887 | HR master record, infotype 0887 | 51 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPThird Party ManagementCOA |
100 | VIMMHBACC | House Bank Account | 10 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPUse AP-MD-BP Components |
101 | BUT0BK | BP: Bank Details | 17 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |
TOPVenezuela |
102 | PA0401 | HRMS-VE: Table for Benefits Infotype (IT401) | 38 | IBAN | IBAN (International Bank Account Number) | nvarchar | 34 | 0 | | |