SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

80 tablesERP 6.0 

Financial Services :: Collateral Management System :: Master Data :: Real Estate
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CMS_RE_OBJ623Real estate header detailsReal Estate
2ERP EHP76.0CMS_RE_OBJ_BP151Link between Real estate objects and BuPa is stored hereReal Estate
3ERP EHP76.0CMS_RE_OBJ_DOC121Link between Real estate objects and Doc is stored hereReal Estate
4ERP EHP76.0CMS_RE_OBJ_PRT1452Real Estate Object part detailsReal Estate
5ERP EHP76.0CMS_RE_OBJ_RL122Real Estate Object role detailsReal Estate
6ERP EHP76.0CMS_RE_OBJ_SPC271Space Details to describe a real estate objectReal Estate
7ERP EHP76.0CMS_RE_PRT_ACS362Real Estate Part accessory detailsReal Estate
8ERP EHP76.0CMS_RE_PRT_BP183Real Estate Part BP detailsReal Estate
9ERP EHP76.0CMS_RE_PRT_CST262Real Estate Part Cost detailsReal Estate
10ERP EHP76.0CMS_RE_PRT_DOC182Real Estate Document detailsReal Estate
11ERP EHP76.0CMS_RE_PRT_LR133Real Estate Part LR detailsReal Estate
12ERP EHP76.0CMS_RE_PRT_VAL212Real Estate Part value detailsReal Estate
13ERP EHP76.0TCMS_OMS_ID_CT21Attribute Indicator categoryReal Estate
14ERP EHP76.0TCMS_OMS_ID_CT_T31Attribute Indicator category - Text tableReal Estate
15ERP EHP76.0TCMS_OMS_ID_TY31Attribute Indicator typeReal Estate
16ERP EHP76.0TCMS_OMS_ID_TY_T51Attribute Indicator type - Text TableReal Estate
17ERP EHP76.0TCMS_RE_ACS_SAS51Acs type - Sub Asset relationReal Estate
18ERP EHP76.0TCMS_RE_ACS_TY41Customizing table for Object Accessories TypeReal Estate
19ERP EHP76.0TCMS_RE_ACS_TY_T41Customizing table for Object Accessories Type (text table)Real Estate
20ERP EHP76.0TCMS_RE_APPL21Customizing table for ApplicationsReal Estate
21ERP EHP76.0TCMS_RE_APPL_T41Application name(Text table)Real Estate
22ERP EHP76.0TCMS_RE_BPRL31Customizing table for Business Partner rolesReal Estate
23ERP EHP76.0TCMS_RE_BPRL_T41Business partner roles(Text table)Real Estate
24ERP EHP76.0TCMS_RE_COND21Customizing table for real estate conditionsReal Estate
25ERP EHP76.0TCMS_RE_COND_T41Object condition(Text table)Real Estate
26ERP EHP76.0TCMS_RE_CST_TY31Customizing table for Object Cost TypeReal Estate
27ERP EHP76.0TCMS_RE_CST_TY_T41Customizing table for Object Cost Type (text table)Real Estate
28ERP EHP76.0TCMS_RE_C_CAT11System table for Cost CategoryReal Estate
29ERP EHP76.0TCMS_RE_C_CAT_T31System table for Cost Category (text table)Real Estate
30ERP EHP76.0TCMS_RE_ENV_ST21Customizing table for envirnonmental statusReal Estate
31ERP EHP76.0TCMS_RE_ENV_ST_T41Environmental Status(Text table)Real Estate
32ERP EHP76.0TCMS_RE_EX_BPRL41Customizing table for External BuPa rolesReal Estate
33ERP EHP76.0TCMS_RE_EX_DOC41Customizing table for External Doc typesReal Estate
34ERP EHP76.0TCMS_RE_EX_TYP41Customizing table for External object typesReal Estate
35ERP EHP76.0TCMS_RE_FX_FIT21Customizing table for fixtures and fitting typesReal Estate
36ERP EHP76.0TCMS_RE_FX_FIT_T41Fixtures and Fittings type(Text table)Real Estate
37ERP EHP76.0TCMS_RE_HER_RG21Customizing table for Heritable building rightsReal Estate
38ERP EHP76.0TCMS_RE_HER_RG_T41Heritable Building rights(Text table)Real Estate
39ERP EHP76.0TCMS_RE_LGL_MS21Customizing table for Legal Measure typesReal Estate
40ERP EHP76.0TCMS_RE_LGL_MS_T41Legal measure types(Text table)Real Estate
41ERP EHP76.0TCMS_RE_LOC_MA21Customizing table for Macro location typesReal Estate
42ERP EHP76.0TCMS_RE_LOC_MA_T41Macro location types(Text table)Real Estate
43ERP EHP76.0TCMS_RE_LOC_MI21Customizing table for Micro location typesReal Estate
44ERP EHP76.0TCMS_RE_LOC_MI_T41Micro location types(Text table)Real Estate
45ERP EHP76.0TCMS_RE_LR_ID11Land Registers IdentifiersReal Estate
46ERP EHP76.0TCMS_RE_LR_ID_T31Land Registers Identifiers TextReal Estate
47ERP EHP76.0TCMS_RE_OBJ_ACS131Real Estate object type - Accessories relationshipReal Estate
48ERP EHP76.0TCMS_RE_OBJ_PRT131Real Estate object type - Building Parts relationshipReal Estate
49ERP EHP76.0TCMS_RE_PRT_SAS51Building Part type - Sub Asset relationReal Estate
50ERP EHP76.0TCMS_RE_PRT_TY31Customizing table for Object Part TypeReal Estate
51ERP EHP76.0TCMS_RE_PRT_TY_T41Customizing table for Object Part Type (text table)Real Estate
52ERP EHP76.0TCMS_RE_P_CAT11Building Part CategoryReal Estate
53ERP EHP76.0TCMS_RE_P_CAT_T31System table for Building Part Category (text table)Real Estate
54ERP EHP76.0TCMS_RE_SP_TYP21Customizing table for space typesReal Estate
55ERP EHP76.0TCMS_RE_SP_TYP_T41Space Types(Text table)Real Estate
56ERP EHP76.0TCMS_RE_STATUS31Customizing table for Object statusReal Estate
57ERP EHP76.0TCMS_RE_STATUS_T41Object status(Text table)Real Estate
58ERP EHP76.0TCMS_RE_STR21Customizing table for Building Structure typesReal Estate
59ERP EHP76.0TCMS_RE_STR_T41Building Structures Types(Text table)Real Estate
60ERP EHP76.0TCMS_RE_ST_CAT11System table for Object Status CategoryReal Estate
61ERP EHP76.0TCMS_RE_ST_CAT_T31Object Status category(Text table)Real Estate
62ERP EHP76.0TCMS_RE_TRNSCTN51Customizing table for Transaction codesReal Estate
63ERP EHP76.0TCMS_RE_TR_CON21Customizing table for Transport connection typesReal Estate
64ERP EHP76.0TCMS_RE_TR_CON_T41Transport connection types(Text table)Real Estate
65ERP EHP76.0TCMS_RE_TYP211Customizing table for real estate typesReal Estate
66ERP EHP76.0TCMS_RE_TYP_T41Object types(Text table)Real Estate
67ERP EHP76.0TCMS_RE_T_CAT11System table for Object categoryReal Estate
68ERP EHP76.0TCMS_RE_T_CAT_T31Object category(Text table)Real Estate
69ERP EHP76.0TCMS_RE_U_CAT11System table for Object Usage CategoryReal Estate
70ERP EHP76.0TCMS_RE_U_CAT_T31Object usage category(Text table)Real Estate
71ERP EHP76.0TCMS_RE_U_TYP41Customizing table for Object usageReal Estate
72ERP EHP76.0TCMS_RE_U_TYP_T41Object usage(Text table)Real Estate
73ERP EHP76.0TCMS_VAL_COMP41Valuation componentsReal Estate
74ERP EHP76.0TCMS_VAL_COMP_T41Text table for valuation componentsReal Estate
75ERP EHP76.0TCMS_VAL_PARAM61Valuation parametersReal Estate
76ERP EHP76.0TCMS_VAL_PARAM_T31Text table for valuation parametersReal Estate
77ERP EHP76.0TCMS_VAL_PARGP31Grouping factor for valuation fields in formula builderReal Estate
78ERP EHP76.0TCMS_VAL_PARGP_T31Text table for parameter groups of valuationReal Estate
79ERP EHP76.0TCMS_VAL_RES31Real estate valuation resultsReal Estate
80ERP EHP76.0TCMS_VAL_RES_T41Text table of real estate valuation resultsReal Estate