| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /AIF/NS_LOCK | Define Namespace | 4 | COMPANY | Company requesting the lock | nvarchar | 50 | 0 | | |
2 | /OPT/VIM_STG_LIF | Table: Staging data - Vendor master for ICC | 9 | COMPANY | Name 1 | nvarchar | 35 | 0 | | |
3 | /SAPPSSRM/THRESL | Thresholds | 14 | COMPANY | Company Code | nvarchar | 14 | 0 | | |
4 | /SMD/MD_____00ZD | SID-Tabelle fuer Accts rble pled.ind. | 3 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
5 | /XLSO/APPR_REQ | Maintain Approval Settings for Company Booking and Cancellat | 3 | COMPANY | Customer Number | nvarchar | 10 | 0 | | |
6 | /XLSO/BOOK_APPR | Maintain System-wide Booking Approval Time | 2 | COMPANY | Customer Number | nvarchar | 10 | 0 | | |
7 | /XLSO/COMP_INV | Customizing for Company Billing Due List (Combined Invoice) | 2 | COMPANY | Customer Number | nvarchar | 10 | 0 | | |
8 | /XLSO/CORR_COMP | xLSO Correspondence types system wide | 2 | COMPANY | Customer Number | nvarchar | 10 | 0 | | |
9 | /XLSO/PMAIL_COMP | Company wise periodic mail settings | 2 | COMPANY | Customer Number | nvarchar | 10 | 0 | | |
10 | BBPC_AVL_DET | Define Sourcing using Supplier List | 2 | COMPANY | Company in MarketSet Procurement | nvarchar | 10 | 0 | | |
11 | BBPC_PDMSG_CUS | BBP: Settings for Customizeable Messages | 5 | COMPANY | Company in MarketSet Procurement | nvarchar | 10 | 0 | | |
12 | BBPC_PDMSG_XML | BBP: Settings for XML Message Control | 5 | COMPANY | Company in MarketSet Procurement | nvarchar | 10 | 0 | | |
13 | BBPD_ARCH_RESI | Archiving of EBP Documents Resididence Times | 2 | COMPANY | Company in MarketSet Procurement | nvarchar | 10 | 0 | | |
14 | BBPD_TREX_INDEX | BBP TREX Indexes: Assign Business Object -> TREX Indexes | 3 | COMPANY | Company | nvarchar | 14 | 0 | | |
15 | BBP_DET_ACCOUNT | Determination G/L Account by Product Categories | 2 | COMPANY | Company in MarketSet Procurement | nvarchar | 10 | 0 | | |
16 | BBP_LOCMAP | Mapping Table Business Partner --> System --> Location | 6 | COMPANY | Company in E-Procurement | nvarchar | 10 | 0 | | |
17 | ECPAO_COMPANY | EC Company | 2 | COMPANY | EC Company ID | nvarchar | 20 | 0 | | |
18 | ECPAO_COMPANY_TT | EC Company Text | 3 | COMPANY | EC Company ID | nvarchar | 20 | 0 | | |
19 | ECPAO_EE_INVT | Inventory of Employees Replicated | 2 | COMPANY | EC Company ID | nvarchar | 20 | 0 | | |
20 | ECPAO_FLD | EC Template Field Mapping | 2 | COMPANY | EC Company ID | nvarchar | 20 | 0 | | |
21 | ECPAO_MAPENTY_TT | Value Mapper Entity Text Table | 3 | COMPANY | EC Company ID | nvarchar | 20 | 0 | | |
22 | ECPAO_MAP_ENTITY | Value Mapper Entity Table | 2 | COMPANY | EC Company ID | nvarchar | 20 | 0 | | |
23 | ECPAO_TEMPL_SET | Employee Central Template Group Set | 4 | COMPANY | EC Company ID | nvarchar | 20 | 0 | | |
24 | ECPAO_VALUE_MAP | Value Mapping Table | 2 | COMPANY | EC Company ID | nvarchar | 20 | 0 | | |
25 | ECPAO_VALUE_MAPC | Value Mapping Table (Country Specific) | 2 | COMPANY | EC Company ID | nvarchar | 20 | 0 | | |
26 | GRACCOMPANY | Company | 2 | COMPANY | Company | nvarchar | 10 | 0 | | |
27 | GRACCOMPANYT | Company text | 3 | COMPANY | Company | nvarchar | 10 | 0 | | |
28 | GRACFUNCTAREA | Functional Area Table | 3 | COMPANY | Company | nvarchar | 10 | 0 | | |
29 | GRACREQUSERADR | User Communication Fields | 6 | COMPANY | Company | nvarchar | 42 | 0 | | |
30 | GRACRLCOMPANY | Role Company | 3 | COMPANY | Company | nvarchar | 10 | 0 | | |
31 | J_5K_LFCL | | 2 | COMPANY | | nvarchar | 4 | 0 | | |
32 | ODFIN_MAP_BUKRS | Key Mapping Company - Company Code | 3 | COMPANY | Char 20 | nvarchar | 20 | 0 | | |
33 | ZCUSTOMERMOBILE | Table to store information about recorded customers | 5 | COMPANY | Name of company | nvarchar | 30 | 0 | | |
TOPALE Integration Technology |
34 | EDIPHONE | Telephony Data for Partner Profiles | 13 | COMPANY | Company (for telephony) | nvarchar | 55 | 0 | | |
TOPBasic Functions |
35 | LECI_EVENT_DATA | Activity Data Within the Check-in/Check-out Process | 24 | COMPANY | Company name | nvarchar | 50 | 0 | | |
TOPBSI |
36 | BTXCOMP | BSI: Tax Company Code | 2 | COMPANY | BSI: Tax Company Code | nvarchar | 11 | 0 | | |
37 | BTXCOMP_O | BSI: Tax Company Code | 1 | COMPANY | BSI: Tax Company Code | nvarchar | 11 | 0 | | |
38 | BTXRATE | BSI: Tax Rates per Company Based on Degree of Experience | 2 | COMPANY | BSI: Tax Company Code | nvarchar | 11 | 0 | | |
39 | BTXRATE_O | BSI: Tax Rates per Company Based on Degree of Experience | 1 | COMPANY | BSI: Tax Company Code | nvarchar | 11 | 0 | | |
40 | T5UTH_O | Tax Number <-> BSI Tax Interface | 3 | COMPANY | BSI: Tax Company Code | nvarchar | 11 | 0 | | |
TOPCentral Part of Product Master |
41 | COMC_VALAREA_R3 | Valuation Areas in R/3 | 4 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
TOPCheck Input |
42 | OIUCI_DOCS | Incoming Checks - Generated/Booked Documents | 7 | COMPANY | Organization level 1 number (Company Code) | nvarchar | 3 | 0 | | |
TOPCommunication Services Mail, Fax, SMS, Telephony |
43 | SPH_USNOLI | SAPphone: Telephone number list for each user | 7 | COMPANY | SAPphone: Company | nvarchar | 55 | 0 | | |
TOPCross-Application Components |
44 | J_5KFH_CLFORMCMP | Legal forms in company | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
45 | J_5KFH_LFHDR | Legal form header | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
TOPDealer Portal |
46 | /SAPDII/SPPARTIC | Table of Articles | 4 | COMPANY | 30 Characters | nvarchar | 30 | 0 | | |
TOPDepreciation Simulation |
47 | IMCC | IM Summarization: Characteristics that are master data | 10 | COMPANY | Company | nvarchar | 6 | 0 | | |
48 | IMCEM | IM Summarization: Measures | 2 | COMPANY | Company | nvarchar | 6 | 0 | | |
49 | IMCEMT | IM Summarization: Texts for measures | 3 | COMPANY | Company | nvarchar | 6 | 0 | | |
50 | IMCER | IM Summarization: Appropriation requests | 2 | COMPANY | Company | nvarchar | 6 | 0 | | |
51 | IMCERT | IM Summarization: Texts for appropriation requests | 3 | COMPANY | Company | nvarchar | 6 | 0 | | |
TOPE-Recruiting |
52 | T77RCFBRANCHCOMP | Assignment of Branches to Companies | 2 | COMPANY | Holding Companies | nvarchar | 8 | 0 | | |
53 | T77RCF_ACT2FORM | Assignment of Forms to Activity Types | 3 | COMPANY | Holding Companies | nvarchar | 8 | 0 | | |
54 | T77RCF_COMPANY | Companies of a Holding | 2 | COMPANY | Holding Companies | nvarchar | 8 | 0 | | |
55 | T77RCF_CS_S2SF | Definition SF from Service, Recipient Category and Company | 3 | COMPANY | Holding Companies | nvarchar | 8 | 0 | | |
TOPFinancial Accounting |
56 | J_1GJOURNAL1 | Journals | 10 | COMPANY | Print company code data | nvarchar | 1 | 0 | | |
57 | TCESSION | Accounts Receivable Pledging | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
58 | TCESSIONT | Texts for Accounts Receivable Pledging | 3 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
TOPGL transfer |
59 | TBKKC_BUKRS | BCA Locally Duplicated Values for Corresponding FI | 11 | COMPANY | Company | nvarchar | 6 | 0 | | |
TOPImplementation Guide |
60 | TRESSP | Project Resources | 5 | COMPANY | Company of Team Member | nvarchar | 35 | 0 | | |
TOPJoint Venture und Production Sharing Accounting |
61 | T8J6E | JV Master Data JIB Subclass B Codes | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
62 | T8J6F | JV JIB Subclass B Codes Text Table | 3 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
63 | T8J6G | JV JIB Account Mapping for Non-AFE | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
64 | T8J6H | JV JIB Account Mapping and Class | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
65 | T8J6I | JV JIB Class and Account Mapping | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
66 | T8J6J | JV JIB Account Mapping for AFE | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
67 | T8JOH_ACSET_LIST | List of account sets for each base amount condition | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
68 | T8JOH_BASE_CONDT | Conditions used to capture base amount to calculate overhead | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
69 | T8JOH_COMPLEX_F | Table of Complex Formulas in Overhead Organizer | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
70 | T8JOH_CONDT_TEXT | Base amount condition text for overhead organizer | 3 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
71 | T8JOH_COSET_LIST | List of cost object sets for each base amount condition | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
72 | T8JOH_COST_OBJS | Table of cost centers, projects and orders for each overhead | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
73 | T8JOH_FMULA_TEXT | Text table for Overhead Organizer formulas | 3 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
74 | T8JOH_FORMULAS | Formulas used by each overhead in Overhead Organizer | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
75 | T8JOH_FORMULA_TX | Formula text for Overhead Organizer | 3 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
76 | T8JOH_JOAS | List of JOA level parameters in Overhead Organizer | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
77 | T8JOH_KEYLISTS | List of overhead characters for each overhead key | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
78 | T8JOH_KEYTEXT | Text table for overhead keys | 3 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
79 | T8JOH_KEYWORDS | List of keywords used to capture the cost objects for users | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
80 | T8JOH_OHLISTS | List of overheads defined in Overhead Organizer | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
81 | T8JOH_OHTEXT | Text for each overhead key in different languages | 3 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
82 | T8JOH_OH_DETAILS | Overhead general detail | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
83 | T8JOH_OVERHEADS | List of all overheads in each company | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
84 | T8JOH_PERCENT_F | Table of Percentage Formulas in Overhead Organizer | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
85 | T8JOH_RUNS | List of run information for each <company, joa> | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
86 | T8JOH_STEPRATE_F | Table of Step Rate Formulas in Overhead Organizer | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
87 | T8JOH_STTRATIO_F | Table of Statistical Ratio Formulas in Overhead Organizer | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
88 | T8JOH_VENTURES | List of Venture Level parameters in Overhead Organizer | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
TOPLegal Case Management for ILM |
89 | LHM_CASE_ATTR | Table with Additional Attributes for Legal Hold Cases | 3 | COMPANY | Company Name | nvarchar | 80 | 0 | | |
90 | SLHM_CASE_HEAD | Legal Hold Management - Cases (Header Data) | 7 | COMPANY | Company Name | nvarchar | 80 | 0 | | |
TOPLocalization |
91 | J_3R_CAUTH | Output control for Goods Withholding Authorization | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
92 | J_3R_CLFORMCMP | Legal forms in company | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
93 | J_3R_LFHDR | Legal form header | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
94 | J_VE_INCWT | Maintain Withholding Tax Payment Details | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
TOPMaterials Management |
95 | J_5KFH_CAUTH | Output control for Goods Withholding Authorization | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
96 | J_5KMH_CAUTH | Output control for Goods Withholding Authorization | 2 | COMPANY | Company Code | nvarchar | 4 | 0 | | |
TOPRevenue |
97 | OIUAR_BAL_TRFR | Accounts Receivable Balance Transfer | 4 | COMPANY | Organization level 1 number (Company Code) | nvarchar | 3 | 0 | | |
98 | OIUAR_REC_BAL | Accounts Receivable Balance | 3 | COMPANY | Organization level 1 number (Company Code) | nvarchar | 3 | 0 | | |
99 | OIUAR_REC_BAL_H | Accounts Receivable Balance History | 3 | COMPANY | Organization level 1 number (Company Code) | nvarchar | 3 | 0 | | |
100 | OIUAR_WO_CONFIG | Accounts Receivable Writeoff Configuration | 2 | COMPANY | Organization level 1 number (Company Code) | nvarchar | 3 | 0 | | |
TOPSAP Note Assistant |
101 | SCWB_RFC_GEN_EXC | SIDs where automatic RFC destination generation is disabled | 2 | COMPANY | 30 Characters | nvarchar | 30 | 0 | | |
TOPStakeholder Relationship Management |
102 | USS_COMP_FIGS | Key Figures Related to Company | 4 | COMPANY | Company | nvarchar | 10 | 0 | | |
103 | USS_CUST_TABLE | SRM: Customizing Table | 3 | COMPANY | Stakeholder | nvarchar | 10 | 0 | | |
TOPTax Reporting |
104 | OIUX4_BALANCE | Taxes Payable Balance | 2 | COMPANY | Organization level 1 number (Company Code) | nvarchar | 3 | 0 | | |
105 | OIUX4_BALANCE_H | Taxes Payable Balance History | 2 | COMPANY | Organization level 1 number (Company Code) | nvarchar | 3 | 0 | | |
106 | OIUX4_BAL_CTGZN | Taxes Payable Balance Categorization | 2 | COMPANY | Organization level 1 number (Company Code) | nvarchar | 3 | 0 | | |
107 | OIUX4_COMMENTS | Taxes Payable Comments | 2 | COMPANY | Organization level 1 number (Company Code) | nvarchar | 3 | 0 | | |
108 | OIUX4_RESP_ID | Taxes Payable Responsibility ID | 2 | COMPANY | Organization level 1 number (Company Code) | nvarchar | 3 | 0 | | |
109 | OIUX4_WO_SETUP | Taxes Payable Writeoff Configuration | 2 | COMPANY | Organization level 1 number (Company Code) | nvarchar | 3 | 0 | | |
TOPTravel Expenses |
110 | PTRV_RECDETAIL | Participant(s) in Entertainment Receipts | 12 | COMPANY | Company | nvarchar | 30 | 0 | | |
TOPUSA |
111 | BTXEMPT | BSI: Employee tax results | 4 | COMPANY | BSI: Tax Company Code | nvarchar | 11 | 0 | | |
112 | T5UTH | Tax Number <-> BSI Tax Interface | 3 | COMPANY | BSI: Tax Company Code | nvarchar | 11 | 0 | | |
TOPUser and Authorization Management |
113 | USCOMPANY | Company in user's address | 2 | COMPANY | Company address, cross-system key | nvarchar | 42 | 0 | | |
114 | USCOMPANYS | Shadow table for USCOMPANY | 3 | COMPANY | Company address, cross-system key | nvarchar | 42 | 0 | | |
115 | USZBVPROTC | CUA: Protocols of the Distribution of Company Addresses | 2 | COMPANY | Company address, cross-system key | nvarchar | 42 | 0 | | |
116 | USZBVSYSC | CUA: Assignment of Systems to Company Addresses | 2 | COMPANY | Company address, cross-system key | nvarchar | 42 | 0 | | |