| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CCEE/SIFI_CACC | SI: Cash Sales Report - account assignment to payment type | 5 | ACCOUNT | General Ledger Account | nvarchar | 10 | 0 | | |
2 | BBP_PCACC | Procurement Card: Accounting Data | 8 | ACCOUNT | G/L Account Number | nvarchar | 10 | 0 | | |
3 | BBP_PCMOD | Procurement Card: Modified Statement Data | 10 | ACCOUNT | G/L Account Number | nvarchar | 10 | 0 | | |
4 | CNV_20100_IC_POS | Status of postings per account and company code | 6 | ACCOUNT | G/L Account Number | nvarchar | 10 | 0 | | |
5 | EPIC_DUM_BAL | Balance of Dummy Bank | 3 | ACCOUNT | 30 Characters | nvarchar | 30 | 0 | | |
6 | EPIC_DUM_TRANSAC | Transactions of Dummy Bank | 3 | ACCOUNT | 30 Characters | nvarchar | 30 | 0 | | |
7 | FIAPPTD_BALANCE | Table to store the Balances for Vendor/Customer/Bank Account | 6 | ACCOUNT | Account Number | nvarchar | 10 | 0 | | |
8 | FIAPPTD_BAL_SCB | SCB codes for Vendor/Customer and House Bank Balances | 3 | ACCOUNT | Account Number | nvarchar | 10 | 0 | | |
9 | FIAPPTD_TRANS | Table to store the transaction details of the CBR PT | 10 | ACCOUNT | Account Number | nvarchar | 10 | 0 | | |
10 | INTITFX | Fixed Interest Amounts per Invoice | 15 | ACCOUNT | SD business partner identifier (number or code) | nvarchar | 10 | 0 | | |
11 | REP_EAPS_DCOLN_C | Data Connector: Layout Customizing/Line Definition | 4 | ACCOUNT | Additional Texts for Account | nvarchar | 30 | 0 | | |
12 | TCORIT_SWIFT_PGN | SWIFT MT535 depot statement pages - fragment adm. with CoCod | 2 | ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
13 | TCORIT_SWIFT_STN | SWIFT MT535 depot statements - fragment administration CoCod | 2 | ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
14 | TCMAC05C | Determine Payment Card Authorization | 3 | ACCOUNT | G/L Account Number | nvarchar | 10 | 0 | | |
TOPAccounting Interface |
15 | GLE_ECS_BAL | ECS+GL Balances by Company Code, Account, Fiscal Year, Crcy | 3 | ACCOUNT | General Ledger Account | nvarchar | 10 | 0 | | |
16 | GLE_ECS_BAL_ITEM | GL open items that are not in ECS | 5 | ACCOUNT | General Ledger Account | nvarchar | 10 | 0 | | |
17 | GLE_ECS_ITEM | ECS: Error Correction Items | 20 | ACCOUNT | General Ledger Account of Posted Document | nvarchar | 10 | 0 | | |
18 | GLE_TECS_ACP04 | Threshold | 6 | ACCOUNT | Threshold Check: Account Number for Write-Off Account | nvarchar | 10 | 0 | | |
TOPAssetLiability Management |
19 | JBR_US_ACCT | Balance Sheet Account Key | 2 | ACCOUNT | Balancing Account | nvarchar | 3 | 0 | | |
20 | JBR_US_ACCT_MAP | Balancing Account | 2 | ACCOUNT | Balancing Account | nvarchar | 3 | 0 | | |
21 | TJBR_US_ACCT_T | Customizing Table for Balancing Account Texts | 3 | ACCOUNT | Balancing Account | nvarchar | 3 | 0 | | |
TOPBack Office |
22 | TRST_SECACC_BANK | Payment Details for Securities Account | 8 | ACCOUNT | Short key for house bank account | nvarchar | 5 | 0 | | |
23 | TRST_SECACC_PAY | Downport Payment Information for Securities Management | 7 | ACCOUNT | Short key for house bank account | nvarchar | 5 | 0 | | |
TOPBSI |
24 | BTXRATE | BSI: Tax Rates per Company Based on Degree of Experience | 9 | ACCOUNT | BSI: Account number | nvarchar | 11 | 0 | | |
25 | BTXRATE_O | BSI: Tax Rates per Company Based on Degree of Experience | 8 | ACCOUNT | BSI: Account number | nvarchar | 11 | 0 | | |
TOPBusiness Server Pages |
26 | AUUSER | User Table for the eRhine Auction House | 12 | ACCOUNT | Auction - Amount | decimal | 10 | 2 | | |
TOPCollectionsDisbursements |
27 | IBROSTMCF | Clarif. Cases from Broker Report | 9 | ACCOUNT | Contract Account Number | nvarchar | 12 | 0 | | |
28 | IBROSTMP | ISCD: Broker Report - Item Data | 17 | ACCOUNT | Contract Account Number | nvarchar | 12 | 0 | | |
29 | INSCUSTENV | INS Information Cluster Builder: Parameters | 6 | ACCOUNT | Display Activation for Cluster Builder Object Level | nvarchar | 1 | 0 | | |
30 | TFSCD_COV_PAR | Ins: Parameter Cluster Builder Business Partner Environment | 6 | ACCOUNT | Display Activation for Cluster Builder Object Level | nvarchar | 1 | 0 | | |
31 | TINS_COV_PAR | IS-PS-CA: Parameter Cluster Builder Business Partner Environ | 6 | ACCOUNT | Display Activation for Cluster Builder Object Level | nvarchar | 1 | 0 | | |
TOPContract Accounts Receivable and Payable |
32 | EBRLIVICMS | Registro de Apuração do ICMS: List control additional acct | 6 | ACCOUNT | General Ledger Account | nvarchar | 10 | 0 | | |
TOPCost Element Accounting |
33 | COFIS | Actual line items for reconciliation ledger | 62 | ACCOUNT | Reconciliation Account for Reconciliation Posting | nvarchar | 10 | 0 | | |
TOPFinancial Accounting |
34 | /CCEE/YUFI_PRACC | DRQ Serbia: Public revenue accounts | 2 | ACCOUNT | | nvarchar | 5 | 0 | | |
35 | FDKMAIL | Sender of External Mail | 3 | ACCOUNT | SD business partner identifier (number or code) | nvarchar | 10 | 0 | | |
36 | INTITHE | Until When Was Interest Calculated for Item? | 6 | ACCOUNT | GL/Customer/Vendor Account Number | nvarchar | 10 | 0 | | |
37 | INTITIT | Interest Calculation Details per Item | 21 | ACCOUNT | SD business partner identifier (number or code) | nvarchar | 10 | 0 | | |
38 | J_1GALL | G/L to A/L link deficiencies (Log file) | 3 | ACCOUNT | Account Number | nvarchar | 10 | 0 | | |
TOPFinancial Supply Chain Management |
39 | IHC_PI_INB_ACCTS | PI: Clearing Partner Details for Inbound IDOC | 8 | ACCOUNT | PI: Account Number from BCA Current Account | nvarchar | 35 | 0 | | |
TOPFront Office |
40 | EWCUSTENV | IS-U Information Cluster Builder: Parameter | 7 | ACCOUNT | Display Activation for Cluster Builder Object Level | nvarchar | 1 | 0 | | |
TOPFSCM In-House Cash |
41 | IHC_DB_INB_ACCTS | Clearing Partner Details for PEXR2002 | 8 | ACCOUNT | External Account Number | nvarchar | 35 | 0 | | |
TOPFunctions for U.S. Federal Government |
42 | FMFG_T095 | Contra accounts asset accounting | 6 | ACCOUNT | G/L Account Number | nvarchar | 10 | 0 | | |
TOPFunds Management |
43 | FMFG_BL_BALACC | Budgetary Ledger balancing account for document split | 3 | ACCOUNT | G/L Account Number | nvarchar | 10 | 0 | | |
TOPGeneral Ledger Accounting |
44 | T8G30B | Acct determination for document splitting - accounts | 7 | ACCOUNT | G/L Account Number | nvarchar | 10 | 0 | | |
TOPLocalization |
45 | J_1BLB08 | Registro de Apuração do IPI: List control additional accts | 6 | ACCOUNT | General Ledger Account | nvarchar | 10 | 0 | | |
46 | J_1BLB09 | Registro de Apuração do ICMS: List control additional acct | 6 | ACCOUNT | General Ledger Account | nvarchar | 10 | 0 | | |
47 | J_1IUTILIZE | Utilization Determination | 3 | ACCOUNT | Account Name | nvarchar | 10 | 0 | | |
TOPMaster Data |
48 | BKK620 | Account Hierarchy: Amount Definitions for Cash Concentration | 5 | ACCOUNT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
49 | BKK621 | Cash Concentration: Different Amount Defintions | 4 | ACCOUNT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
50 | BKK622 | Cash Concentration: Balancing Date of Last Execution | 3 | ACCOUNT | Internal Account Number for Current Account | nvarchar | 10 | 0 | | |
51 | EPROP | Owner Allocation | 4 | ACCOUNT | Contract Account Number | nvarchar | 12 | 0 | | |
TOPMobile Materials Management |
52 | /ISDFPS/MEMMTRQL | Customizing: Requisition Type for Document Cat. (Mobile) | 7 | ACCOUNT | Account Assignment | nvarchar | 1 | 0 | | |
TOPMove-InOut |
53 | ECAMIOPRMDKEY | IS-U: Parked Document: Master Data Key | 5 | ACCOUNT | Contract Account Number | nvarchar | 12 | 0 | | |
TOPPerformance Monitors TCC |
54 | SAPWLT000 | SAP workload: statistics data | 11 | ACCOUNT | User Name in User Master Record | nvarchar | 12 | 0 | | |
55 | SAPWLT001 | SAP workload: Table statistics | 11 | ACCOUNT | User Name in User Master Record | nvarchar | 12 | 0 | | |
56 | SAPWLT002 | SAP workload: RFC statistics data | 11 | ACCOUNT | User Name in User Master Record | nvarchar | 12 | 0 | | |
TOPPortfolio |
57 | VDBILL_RES_HEAD | Bill Results Header | 4 | ACCOUNT | Contract Number | nvarchar | 13 | 0 | | |
TOPProcess Monitoring Infrastructure |
58 | SSPISTRECS | Compressed Statistical Records Before Cumulation | 11 | ACCOUNT | DSR Statistics: User Name | nvarchar | 32 | 0 | | |
TOPPublic Sector Contract Accounts Receivable and Payable |
59 | DFMCA_BRF901 | BRF: Form Bundle Accounting Data Update | 8 | ACCOUNT | BRF: Expression | nvarchar | 20 | 0 | | |
60 | DFMCA_RETURN | Data Table for Tax Returns | 11 | ACCOUNT | Contract Account Number | nvarchar | 12 | 0 | | |
61 | DFMCA_RETURN_M | Data Table for Additional Accounting Data in Return | 5 | ACCOUNT | Contract Account Number | nvarchar | 12 | 0 | | |
62 | DFMCA_RETURN_O | Data Table for Tax Returns | 14 | ACCOUNT | Contract Account Number | nvarchar | 12 | 0 | | |
63 | DFMCA_RISK_PROF | Data Table for Risk Profiles | 3 | ACCOUNT | Contract Account Number | nvarchar | 12 | 0 | | |
64 | DFMCA_TAX_CASE | Data Table for Tax Cases | 4 | ACCOUNT | Contract Account Number | nvarchar | 12 | 0 | | |
65 | DFMCA_TF_CST_L | Line Item Table of Consolidated SUT Member Schedule | 7 | ACCOUNT | Contract Account Number | nvarchar | 12 | 0 | | |
66 | TFMCA_COV_PAR | IS-PS-CA: Parameter Cluster Builder Business Partner Environ | 6 | ACCOUNT | Display Activation for Cluster Builder Object Level | nvarchar | 1 | 0 | | |
TOPRevenue |
67 | OIUAR_WO_CONFIG | Accounts Receivable Writeoff Configuration | 3 | ACCOUNT | Account Number | nvarchar | 10 | 0 | | |
TOPService Data Download |
68 | /SDF/BPM_ASTAD | BPMon Application Statistical Records | 6 | ACCOUNT | User Name in User Master Record | nvarchar | 12 | 0 | | |
69 | /SDF/BPM_ASTAD2 | BPMon Application Statistical Records | 6 | ACCOUNT | User Name in User Master Record | nvarchar | 12 | 0 | | |
70 | /SDF/BPM_TSTAD | BPMon Technical Statistical Records | 7 | ACCOUNT | User Name in User Master Record | nvarchar | 12 | 0 | | |
TOPTax Reporting |
71 | OIUX4_WO_SETUP | Taxes Payable Writeoff Configuration | 3 | ACCOUNT | Account ID | nvarchar | 10 | 0 | | |
TOPThird Party Remittance |
72 | T7US3PR_V0TYPE_T | Maintain wage types for other HR payees of V0 type 'T' | 4 | ACCOUNT | Account identifier for V0 type 'T' | nvarchar | 6 | 0 | | |
TOPTransaction Manager |
73 | TCORIT_SWIFT_PG | SWIFT MT535 depot statement pages - fragment administration | 2 | ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
74 | TCORIT_SWIFT_ST | SWIFT MT535 depot statements - fragment administration | 2 | ACCOUNT | Securities Account | nvarchar | 10 | 0 | | |
75 | TCORT_BP_BIC | BIC Codes/ Account numbers for Business partners | 7 | ACCOUNT | External Securities Account ID | nvarchar | 35 | 0 | | |
TOPTravel Planning |
76 | FTPT_REQ_ACCOUNT | Travel Request Cost Assignment | 6 | ACCOUNT | Sequential number of cost distribution in travel request | nvarchar | 2 | 0 | | |
TOPWaste Management |
77 | EWACUSTENV | IS-U Waste, Information Cluster Builder: Parameters | 10 | ACCOUNT | Display Activation for Cluster Builder Object Level | nvarchar | 1 | 0 | | |