| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /CCEE/XXFI_TCJ | Settings for Cash Journal | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
2 | /CCEE/XX_SET_LOC | Localization Settings | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
3 | /GBT/O_MDOC_ITM | Material Document Item for Tracking | 20 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
4 | /GBT/O_PURO_ITM | Purchasing Document Item for Tracking | 15 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
5 | /OPT/APPR_COA | Approval COA | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
6 | /SAPPSSRM/C_UFD | Incremental Funding: Customizing for the Unfunded Acctg Line | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
7 | /SAPPSSRM/IF_CC | IBU PS: Incremental Funding - Active Comp Codes & Obj Types | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
8 | /SAPPSSRM/IF_CCT | IBU PS: Company Code Descriptions for Incremental Funding | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
9 | /SAPPSSRM/IF_PTY | IBU PS: Incremental Funding Process Types | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
10 | BBP_PCACC | Procurement Card: Accounting Data | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
11 | BBP_PCIAC | Accounting Data for Procurement Card Company | 3 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
12 | BBP_PCMAS | Procurement Card Master Data | 22 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
13 | BBP_PCMOD | Procurement Card: Modified Statement Data | 7 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
14 | BBP_USR01 | Internet user data | 36 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
15 | CFAFOIACT_DETL_2 | FO Integration: Selection of Details (Risk Category) | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
16 | CNV_20200_CAJO | Differences in cash journal master data | 6 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
17 | CNV_20200_CJPOST | Cash journal master - do postings exist per company code | 6 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
18 | CNV_20200_CJTR | Differences in cash journal business transactions | 6 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
19 | CNV_20200_CJTR1 | Merge of cash journal business transactions (identic. sett.) | 6 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
20 | EEWA_CJOURN_USER | Assignment of Cash Journal to User | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
21 | EWA_WA_WEIGHPC_B | Information Relevant for Payment Process | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
22 | J_1I_BANK_MASTER | EXIM: Bank Master | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
23 | LWM_CFS_MSGMT_CC | FinFactSheet - Assignment of Company Codes to Groups | 3 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPAccounts Receivable Accounting Process Integration |
24 | FDM_INVOICE_ACT | Provision of Invoice Information: Active Procedure | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
25 | FDM_INVOICE_MEM | Invoice Information Provided | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
26 | FDM_INV_MEM_OBS | Invoice Information Provided Obsolete | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPActual Update and Commitment Update |
27 | GTRRULE_ASSIGN | GTR Multi-Funding Rules Assignment To CRM Objects | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPBack Office |
28 | TRST_RECON_RCE | Treasury: External Securities Account Statement | 3 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPBank Accounting |
29 | TCJ_BALANCE | FI Cash Journal: Totals Records | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPBasic Functions |
30 | ETXDCH | External tax document: header info | 22 | COMP_CODE | Company code using tax interface | nvarchar | 4 | 0 | | |
31 | TTXU | External tax interface: Audit file update information | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
32 | TTXY | External tax interface: tax information | 9 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPBasis Components |
33 | /XFT/INV_Q | Invoice receipt queue: Header | 41 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
34 | /XFT/INV_Q_S | Invoice receipt queue: Header | 41 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPBudgeting and Availability Control |
35 | GMAVCLDGRACT | Activation of availability ledger for Grants Management | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPCollateral Management System |
36 | TCMS_IFL_MORG | Organisation units and company codes | 3 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
37 | TCMS_IFL_MORGU | Organisation units and company codes | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPCollections Management |
38 | UDM_COLL_BI_DEL | Deleted Collection Items (memorized for BI) | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
39 | UDM_COLL_ITEM | Open Items | 3 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
40 | UDM_COLL_ITEMCAS | Open Items with Dispute Case | 3 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
41 | UDM_COLL_KEYFIG | Business Partner Key Figures | 3 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
42 | UDM_COLL_LASTPAY | Last Payments of Business Partner | 3 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
43 | UDM_COMPCODE_MAP | Assignment of FI Company Code to Collection Company Code | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
44 | UDM_COMP_CODE | Company Codes in Collections Management | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
45 | UDM_SGMT_COMP | Assignment of Company Code in Collections Mgt - Segment | 3 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPCross-Application Components |
46 | /OPT/S_INV_HDR | VSS Staging Table: Invoice Header | 18 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
47 | /OPT/S_INV_LIN | VSS Staging Table: Invoice lines | 6 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
48 | /OPT/S_PAYMENT | VSS Staging Table: Payment | 18 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
49 | /OPT/VIM_HD_DP | VIM IE Monitor: Header Data for DP Invoices | 3 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
50 | /OPT/VPR_PARTNER | Partners for Registered Vendor | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPData Retention Tool |
51 | TXW_INDEX | Temporary table for data segment index | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
52 | TXW_INDEX_01 | Temporary table for data segment index | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
53 | TXW_INDEX_02 | Temporary table for data segment index | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
54 | TXW_INDEX_03 | Temporary table for data segment index | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
55 | TXW_INDEX_04 | Temporary table for data segment index | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
56 | TXW_INDEX_05 | Temporary table for data segment index | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPDefault Risk and Limit System |
57 | LMSDCIACT | Integrated Limit Check in CFM: Activation | 3 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPDepreciation Simulation |
58 | IMCC | IM Summarization: Characteristics that are master data | 11 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPDistributor-Reseller-Management |
59 | /SAPHT/DRMDETL | DRM Audit Trail | 38 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
60 | /SAPHT/DRMR3XN | DRM relevant ERP Transactions | 7 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPDSD Connector |
61 | /DSD/ME_CLR_HD | DSD CN: Clearing header data | 9 | COMP_CODE | DSD Connector: Company code | nvarchar | 4 | 0 | | |
62 | /DSD/ME_CUST_HD | DSD CN: Customer Details | 56 | COMP_CODE | DSD Connector: Company code | nvarchar | 4 | 0 | | |
TOPFunctions for U.S. Federal Government |
63 | FMFG_BL_YRCL | Customizing Budgetary Ledger Year End closing | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
64 | FMFG_BL_YRCL_TOP | Customizing Budgetary Ledger Year End Multiple Closing Rules | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
65 | FMFG_BL_YRCL_TXT | Multiple Closing Rule Texts | 3 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
66 | FMFG_BUTYPE | Budgetary ledger Attributes of the budget type | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
67 | FMFG_YE_FLG | Collect fields | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPFund Accounting |
68 | FMCCAVCLDGRACT | Activation of control ledger for Cash Control | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPFunds Management |
69 | FMBLPSTNG | FM BL posting customizing for GL line-items collection | 3 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
70 | FMBUDACL | Rules for Closing Residual Ledger Accounts | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
71 | FMBUDBCS | Budgetary ledger account derivation: BCS | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
72 | FMBUDDIS | Budgetary ledger account derivation: Budgeting (old) | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
73 | FMBUDRES | Budgetary ledger account derivation: Revenue/Statistical | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
74 | FMBUDREV | Revenue/Statistical Postings & Open items/actuals Resource | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
75 | FMBUDSTA | Budgetary ledger account derivation: Open items/Actuals bdgt | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
76 | FMDERIVEENVID | Assignment Company Code to Derivation Tool Strategy | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
77 | FMFG_BL_BALACC | Budgetary Ledger balancing account for document split | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
78 | FMFG_HEAD_INV | Header Data for Improper Invoices | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPGeneral Ledger Accounting |
79 | FAGL_VAL_COCODE | Allocation to company code | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
80 | FAGL_VAL_LEDGR | Assignment to Ledger Group | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPGL Account Posting |
81 | TCJ_CHECK_STACKS | Check Lists in Cash Journal | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
82 | TCJ_CJ_NAMES | Cash Journal Names | 3 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
83 | TCJ_CPD | FBCJ: One-Time Account Data of Cash Journal Document Items | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
84 | TCJ_C_JOURNALS | Cash Journals | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
85 | TCJ_DOCUMENTS | Cash Journal Documents (Header Data) | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
86 | TCJ_MAX_AMOUNT | Cash Journal: Amount Limit | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
87 | TCJ_POSITIONS | Cash Journal Document Items | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
88 | TCJ_TRANSACTIONS | Cash Journal Business Transactions | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
89 | TCJ_TRANS_NAMES | Cash Journal Business Transaction Names | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
90 | TCJ_WTAX_ITEMS | Withholding Tax Items for Cash Journal Document Items | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPGL transfer |
91 | TBKKC_BUKRS | BCA Locally Duplicated Values for Corresponding FI | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPGrantor Management |
92 | GTRFIAPAR | Grantor: FI AP/AR related data | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
93 | GTRFIAPARDOC | Grantor: FI AP/AR related data - Payment Type - Doc Type | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
94 | GTRFIBILL_H | Header of Grantor FI AP/AR Billing Doc | 8 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPIncentive and Commission Management ICM |
95 | CACSCD_ACSCD | Account Assignment of Stt.Types for FS-CD Settlement System | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
96 | CACSCD_DOCCD_HD | Settlement to FS-CD: Reference Document Header | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
97 | CACSFA_ACRFA | Account Assignments of Remun.Types for FI-CA settlement | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
98 | CACSFA_ACSFA | Account Assignment of Stt.Types for FI-CA Settlement System | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
99 | CACSFA_DOCFA_HD | Settlement to FI-CA: Reference Document Header | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
100 | CACSFI_DOCFI_HD | Settlement to FI: Reference Document Header | 8 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
101 | CACSNO_NO_ACSFI | Account Assignments Notification Rules FI | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
102 | YCRM01_DOCFI_H | Data Transfer: FI Documents Header Data | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
103 | YSVMA_ACCAS | Account Assignment Type/Cost Information for Remuneration | 9 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
104 | YSVMA_ACCST | Account Assignment Type/Cost Info for Settlement Types | 6 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
105 | YTEL01_ACCAS | Account Assignment Type/Cost Information for Remuneration | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPLoans Management |
106 | TDCO_USER_TEXT | Definition of Custom Text for Correspondence Tool | 10 | COMP_CODE | Relational Operator | nvarchar | 2 | 0 | | |
107 | TDORGUNIT | Field Catalog - Organizational Unit | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
108 | TDPRODPROFILE | Field Catalog - Assignment of Profiles to Products | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPPayment Transactions |
109 | TFIBLAPARPVAR | Online Payment: Variants | 9 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
110 | TFIBLFFPVAR | Online Payment: Variants | 9 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPPersonnel Time Management |
111 | PTARQ_EXTRA_INFO | Leave Request: Additional Fields for Attendances/Absences | 5 | COMP_CODE | Company code | nvarchar | 4 | 0 | | |
TOPProcurement for Public Sector |
112 | /SAPPSPRO/IF_CC | IBU-PS: Incremntl Fundng - Active Comp Codes & Purch Doc Cat | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
113 | /SAPPSPRO/IF_DT | IBU-PS: Incremental Funding Purchasing Document Types | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
114 | /SAPPSPRO/IF_TH | Incremental Funding: Customizing for GR/IR Thresholds | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPProfit Center Accounting |
115 | PCA_SCMO | Index from Schedule Manager Run to Corresponding Extracts | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPRegulatory reporting for insurance companies |
116 | ISSR_BASI_RG | Registrierungseintrag | 5 | COMP_CODE | Buchungskreis | nvarchar | 4 | 0 | | |
117 | ISSR_BASI_RGDONE | Erledigter Registrierungseintrag | 5 | COMP_CODE | Buchungskreis | nvarchar | 4 | 0 | | |
TOPRisk Analysis |
118 | CFAFOIACT | FO Integration - Activation | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
119 | CFAFOIACT_DETAIL | FO Integration: Selection of Details | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
120 | CFAFOIACT_DETL_1 | FO Integration: Selection of Details (Valuation Area) | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
121 | TNNLCLRU | Abschließ regeln | 6 | COMP_CODE | Abschließ Komponent code | nvarchar | 6 | 0 | | |
TOPSAP Retail Store |
122 | WOSCR_CBL_COCODE | Cash Balancing: Settings for Each Company Code | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
123 | WOSCR_EXI_COCODE | Vendor Invoice - Assignment for Each Company Code | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPService Station Retailing |
124 | OIRE_CCODE_CR | Complaint Result Handling | 2 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPStandard Dialogs |
125 | SVALT | Test Data for POPUP_GET_VALUES... | 7 | COMP_CODE | Relational Operator | nvarchar | 2 | 0 | | |
TOPSupply Chain Management |
126 | TCM_C_PUR_MAP | Mapping TM Organizational Unit to Purchasing Organisation | 7 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
127 | TCM_ORG_INO_MAP | Mapping TCM Organizational Units -> Account Assignment obj | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
128 | TCM_ORG_PUR_MAP | Mapping TCM Organizational unit to purchasing organisation | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
129 | TCM_PUR_ORG_MAP | Mapping TCM Organizational unit to purchasing organisation | 5 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPTransaction Manager |
130 | TCORT_COSA | Security Account Transfer: Main Data | 3 | COMP_CODE | CO: Company code | nvarchar | 4 | 0 | | |
TOPTransaction Tax Engine |
131 | TTEPD3_USITEM | Persistency TTE Document UsItem | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
132 | TTEPDT_USITEM | Persistency TTE Document UsItem | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
133 | TTESDT_USITEM | Output Exemptions | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPTravel Expenses |
134 | PTRV_COMM_ITM | Header Data: Transfer to FM When Trip Saved | 13 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
135 | PTRV_REASGN_FM | Conversion of FM Data in Trip (e.g. Fiscal Year Change) | 17 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
136 | PTRV_SCOS | Trip Statistics - Cost Assignment | 6 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPTreasury |
137 | TTXAD | User data fields per document | 11 | COMP_CODE | Relational Operator | nvarchar | 2 | 0 | | |
TOPUS Prompt Payment Act |
138 | FMFG_REASONS | Reason Codes for Accounting Documents (Item Level) | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |
TOPVehicle Management System |
139 | VLCBATCHACT | VELO : Variant for Action Execution in Batch | 4 | COMP_CODE | Company Code | nvarchar | 4 | 0 | | |