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
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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

182 tablesERP 6.0 

Plant Maintenance :: Technical Objects
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0EAML_CM_PROFID31EAML: Profile ID for Context Menu in graphical displayTechnical Objects
2ERP EHP76.0EAML_CM_PROFID_T41EAML: Context Menu Profile DescriptionTechnical Objects
3ERP EHP76.0EAML_CM_PROFIT61EAML: Profile Elements for Context Menu in graphical displayTechnical Objects
4ERP EHP76.0EAML_D_AUSP_CDOC91Linear Data for CharacteristicsTechnical Objects
5ERP EHP76.0EAML_D_AUSP_LFE191Linear Data for Characteristics - Database tableTechnical Objects
6ERP EHP76.0EAML_D_EVT182EAML: Events DB TableTechnical Objects
7ERP EHP76.0EAML_D_EVT_ATVAL61EAML: Event Attribute ValueTechnical Objects
8ERP EHP76.0EAML_D_LFE_CDOC191Linear DataTechnical Objects
9ERP EHP76.0EAML_D_LFE_DATA192Linear Asset Management - DatabaseTechnical Objects
10ERP EHP76.0EAML_D_LFE_NDR31Linear Data - Notif.Item Default Rules dep. on Message TypesTechnical Objects
11ERP EHP76.0EAML_D_LINK_CDOC21Link IDs for CDOCTechnical Objects
12ERP EHP76.0EAML_D_LOL_DATA131Linear Asset Mgmt. - Object Link Enhancements - DatabaseTechnical Objects
13ERP EHP76.0EAML_D_LRP_HDR91Linear Reference Pattern HeaderTechnical Objects
14ERP EHP76.0EAML_D_LRP_HDR_T41Linear Reference Pattern Header TextsTechnical Objects
15ERP EHP76.0EAML_D_LRP_ITEM51Linear Reference Pattern ItemsTechnical Objects
16ERP EHP76.0EAML_D_LRP_ITM_T51Linear Reference Pattern Item TextsTechnical Objects
17ERP EHP76.0EAML_D_OFFSET_TC51Offset Type CodesTechnical Objects
18ERP EHP76.0EAML_D_OFFSET_TT41Offset Type Codes Text and DocumentationTechnical Objects
19ERP EHP76.0EAML_D_TCLS41Organizational area for characteristics with linear dataTechnical Objects
20ERP EHP76.0EAML_EDGE_PROF91EAML Display profile for Edge typesTechnical Objects
21ERP EHP76.0EAML_EDGE_PROF_T41EAML Display profile textsTechnical Objects
22ERP EHP76.0EAML_EDGE_TYPE31EAML: Type for Link ObjectTechnical Objects
23ERP EHP76.0EAML_EDGE_TYPE_T41EAML: Type for Link Object (Text table)Technical Objects
24ERP EHP76.0EAML_EVT_ATT_REL41EAML: Attribute - Event Object Type AssignmentTechnical Objects
25ERP EHP76.0EAML_EVT_A_VAL51EAML Event Attribute Allowed ValuesTechnical Objects
26ERP EHP76.0EAML_EVT_A_VAL_T61EAML Event Attribute Allowed Values DescriptionTechnical Objects
27ERP EHP76.0EAML_EVT_OBJ41EAML Event ObjectTechnical Objects
28ERP EHP76.0EAML_EVT_OBJ_T51EAML Event ObjectTechnical Objects
29ERP EHP76.0EAML_EVT_OTYPE31EAML Event Object TypesTechnical Objects
30ERP EHP76.0EAML_EVT_OTYPE_T41EAML: Event Object Types TextTechnical Objects
31ERP EHP76.0EAML_EVT_O_ATT81EAML Event Object AttributeTechnical Objects
32ERP EHP76.0EAML_EVT_O_ATT_T51EAML: Event Object Attribute TextTechnical Objects
33ERP EHP76.0EAML_JNET_COLORS21EAML: Colors for JNET GraphicsTechnical Objects
34ERP EHP76.0EAML_LRP_TYPE21EAML: LRP TypeTechnical Objects
35ERP EHP76.0EAML_LRP_TYPE_T41EAML: LRP Type TextTechnical Objects
36ERP EHP76.0EAML_NET_EVT_REL31EAML: Network Type - Event Object Type AssignmentTechnical Objects
37ERP EHP76.0EAML_NODE_PROF61EAML Display profile for Node typesTechnical Objects
38ERP EHP76.0EAML_NODE_PROF_T41EAML Display profile textsTechnical Objects
39ERP EHP76.0EAML_NODE_TYPE31EAML: Node Type for Object Link From / ToTechnical Objects
40ERP EHP76.0EAML_NODE_TYPE_T41EAML: Node Type for Object Link From / ToTechnical Objects
41ERP EHP76.0EAML_NW_GROUP21EAML: IMG Network GroupTechnical Objects
42ERP EHP76.0EAML_NW_GROUP_T41EAML: IMG Network Group TextTechnical Objects
43ERP EHP76.0EAML_NW_TYPE41EAML: IMG Network TypeTechnical Objects
44ERP EHP76.0EAML_NW_TYPE_T41EAML: IMG Network Type TextTechnical Objects
45ERP EHP76.0EAML_OL_POS31EAML: Define Link Position on FROM/TO objectTechnical Objects
46ERP EHP76.0EAML_OL_POS_T41EAML: Define Link Position on FROM/TO objectTechnical Objects
47ERP EHP76.0EAML_TT_PROFID31EAML: Profile ID for Tooltips in graphical displayTechnical Objects
48ERP EHP76.0EAML_TT_PROFID_T41EAML: Tooltip Profile DescriptionTechnical Objects
49ERP EHP76.0EAML_TT_PROFIT71EAML: Profile Elements for Tooltips in graphical displayTechnical Objects
50ERP EHP76.0FLEET555Fleet AttributesTechnical Objects
51ERP EHP76.0T370CLC91Fleet Consumption Calculation KeysTechnical Objects
52ERP EHP76.0T370CLC_T41Text for Fleet Consumption Calculation KeysTechnical Objects
53ERP EHP76.0T370CON21Fleet Consumption Unit GroupTechnical Objects
54ERP EHP76.0T370CONV51Fleet Consumption UnitsTechnical Objects
55ERP EHP76.0T370CON_T41Short Text For Fleet Consumption Unit GroupsTechnical Objects
56ERP EHP76.0T370DMP31Default Measuring Point For Technical ObjectTechnical Objects
57ERP EHP76.0T370ENG21Engine TypeTechnical Objects
58ERP EHP76.0T370ENG_T41Engine Type: Multilingual Short TextsTechnical Objects
59ERP EHP76.0T370FLD21Fluid TypesTechnical Objects
60ERP EHP76.0T370FLD_T41Fluid Types: Multilingual Short TextsTechnical Objects
61ERP EHP76.0T370FLT41Fleet TypesTechnical Objects
62ERP EHP76.0T370FLT_R41Fleet Types: Reference to Technical Object Types (Equi/FL)Technical Objects
63ERP EHP76.0T370POS31Valid Measuring Point Positions (Sort Field)Technical Objects
64ERP EHP76.0T370POS_T41Valid Measuring Point Positions (Sort Field) - Short TextsTechnical Objects
65ERP EHP76.0T370POS_USG31Fleet Objects: Counter UsageTechnical Objects
66ERP EHP76.0T370USG21Fleet UsageTechnical Objects
67ERP EHP76.0T370USG_T41Fleet Usage: Multilingual Short TextsTechnical Objects
68ERP EHP76.0TITOBPROF31Technical Objects: View Profiles for Tab Index CustomizingTechnical Objects
69ERP EHP76.0TITOBPROFT51Technical Objects: Texts for Profiles from Table TITOBPROFTechnical Objects
70ERP EHP76.0TITOBPROF_SUB91Technical Objects: Customizing Tab Index in View ProfilesTechnical Objects
71ERP EHP76.0TITOBSUB61Technical Objects: Subscreens with Customizable AssignmentTechnical Objects
72ERP EHP76.0TITOBSUBT41Technical Objects: Texts for Subscreens from Table TITOBSUBTechnical Objects
73ERP EHP76.0TITOBTABS51Technical Objects: Customizing (Tabstrip) ButtonsTechnical Objects
74ERP EHP76.0TITOBTABST61Technical Objects: Customizing Texts (Tabstrip) ButtonsTechnical Objects
75ERP EHP76.0TITOB_IBASE113Creation of IBase: Buffer Table StructuresTechnical Objects
Plant Maintenance :: Technical Objects :: Configuration Control
ProductVersionTableColumnsIndexesDescriptionModule
76ERP EHP76.0CCMEQBOM51Equi. BOM Customizing for Configuration ControlConfiguration Control
77ERP EHP76.0CCMHOLE174Structure Gap TableConfiguration Control
78ERP EHP76.0CCMINSTOPT21Configuration Control Customizing: Installation OptionsConfiguration Control
79ERP EHP76.0IE4N_CGP71General IE4N Settings for Installation/DismantlingConfiguration Control
80ERP EHP76.0IE4N_USP41Definition of User-Specific SettingsConfiguration Control
81ERP EHP76.0IE4N_USPI61Definition of User-Specific Settings: InstallationConfiguration Control
82ERP EHP76.0IE4N_USPR61Definition of User-Specific Settings: DismantlingConfiguration Control
83ERP EHP76.0MPL_C_ADAPTER121Adapter for iPPE WorkbenchConfiguration Control
84ERP EHP76.0MPL_C_DOCTYPES41Adapter for iPPE Workbench: Document TypesConfiguration Control
85ERP EHP76.0TIWEVENTNOTIF141Properties of Installation/Dismantling NotificationsConfiguration Control
Plant Maintenance :: Technical Objects :: Equipment
ProductVersionTableColumnsIndexesDescriptionModule
86ERP EHP76.0EQKT73Equipment Short TextsEquipment
87ERP EHP76.0EQUI907Equipment master dataEquipment
88ERP EHP76.0EQUZ465Equipment time segmentEquipment
89ERP EHP76.0IEQT_WL_HDR_BAC162Interim Statuses - Header Data (Backup)Equipment
90ERP EHP76.0IEQT_WL_HEADER181Interim Statuses - Header DataEquipment
91ERP EHP76.0IEQT_WL_ITEMS1102Interim Statuses - ItemsEquipment
92ERP EHP76.0IEQT_WL_ITM_BAC1111Interim Statuses - Items (Backup)Equipment
93ERP EHP76.0IEQT_WL_MP91Interim Statuses: Measurement ObjectsEquipment
94ERP EHP76.0T024I71Maintenance planner groupsEquipment
95ERP EHP76.0T370T371Equipment categoriesEquipment
96ERP EHP76.0T370U41Language-dependent texts for T370TEquipment
Plant Maintenance :: Technical Objects :: Functional Locations
ProductVersionTableColumnsIndexesDescriptionModule
97ERP EHP76.0EAM_D_IHPA_TIME101Validity for Partner Assignment in Plant MaintenanceFunctional Locations
98ERP EHP76.0IFLOALT41Labeling Systems for Functional LocationsFunctional Locations
99ERP EHP76.0IFLOALT_T41Labeling Systems for Functional Locations: Short TextsFunctional Locations
100ERP EHP76.0IFLOCUST31System-Specific SettingsFunctional Locations
101ERP EHP76.0IFLOCUSTA51System-Specific Settings (Permitted Labeling Systems)Functional Locations
102ERP EHP76.0IFLOS112Functional Location LabelsFunctional Locations
103ERP EHP76.0IFLOS_VS122Functional Location Labels (Version Table)Functional Locations
104ERP EHP76.0IFLOT597Functional Location (Table)Functional Locations
105ERP EHP76.0IFLOTX72Functional Location: Short TextsFunctional Locations
106ERP EHP76.0IFLOTX_VS82Functional Location Data Fields: Short Texts (Version Table)Functional Locations
107ERP EHP76.0IFLOT_VS605Functional Location (Version Table)Functional Locations
108ERP EHP76.0IFLOUSR101User Profile for Labeling Functional LocationsFunctional Locations
109ERP EHP76.0IHPA163Plant Maintenance: PartnersFunctional Locations
110ERP EHP76.0ILOA487PM Object Location and Account AssignmentFunctional Locations
111ERP EHP76.0ILOA_VS495Location & Account Assignment for PM Object (Version Table)Functional Locations
112ERP EHP76.0INHB41Termination of Data Transfer to Technical ObjectsFunctional Locations
113ERP EHP76.0IRLOT304Reference Functional Location (Table)Functional Locations
114ERP EHP76.0IRLOTX72Reference Functional Location: Short TextsFunctional Locations
115ERP EHP76.0ITOBCUST41System Settings for Alternative Labeling of FunctLocationsFunctional Locations
116ERP EHP76.0T35751Plant SectionFunctional Locations
117ERP EHP76.0T370F131Functional Location CategoryFunctional Locations
118ERP EHP76.0T370F_T41Language-Dependent Texts for T370FFunctional Locations
119ERP EHP76.0T370R41Reference Functional Location CategoryFunctional Locations
120ERP EHP76.0T370R_T41Language-Dependent Texts for T370RFunctional Locations
121ERP EHP76.0T370S41Functional Location Structure IndicatorsFunctional Locations
122ERP EHP76.0T370S_T41Language-Dependent Texts for T370SFunctional Locations
Plant Maintenance :: Technical Objects :: Object Networking
ProductVersionTableColumnsIndexesDescriptionModule
123ERP EHP76.0INET286Object networkingObject Networking
124ERP EHP76.0INETX62Language-dependent texts for INETObject Networking
125ERP EHP76.0T372I51Network identificationObject Networking
126ERP EHP76.0T372I_T41Language-dependent texts for network IDObject Networking
127ERP EHP76.0T372M71MediumObject Networking
128ERP EHP76.0T372M_T41Language-dependent texts for link medium (T372)MObject Networking
Plant Maintenance :: Technical Objects :: TakeoverHandover of Technical Objects
ProductVersionTableColumnsIndexesDescriptionModule
129ERP EHP76.0PHINH182Header Table for Take OverTakeoverHandover of Technical Objects
130ERP EHP76.0PHINT612Phase In TableTakeoverHandover of Technical Objects
131ERP EHP76.0PHIN_MSG171table for internal message handling in Takeover/HandoverTakeoverHandover of Technical Objects
132ERP EHP76.0PHIN_MSG_REPL61TOHO Messages to be replaced in Message LogTakeoverHandover of Technical Objects
133ERP EHP76.0TPHIN_CF31Configuration for Customer-Specific FieldsTakeoverHandover of Technical Objects
134ERP EHP76.0TPHIN_CFT41Text Table for Customer-Specific FieldsTakeoverHandover of Technical Objects
135ERP EHP76.0TPHIN_MPT_EXT72External ID of Supported PHIN CountersTakeoverHandover of Technical Objects
136ERP EHP76.0TPHIN_MPT_EXT171External ID of Supported PHIN CountersTakeoverHandover of Technical Objects
137ERP EHP76.0TPHIN_PI_PRO71Takeover Profile TableTakeoverHandover of Technical Objects
138ERP EHP76.0TPHIN_PI_PROT41Texttable for Takeover ProfilesTakeoverHandover of Technical Objects
139ERP EHP76.0TPHIN_PO_ACT131Handover ProfileTakeoverHandover of Technical Objects
140ERP EHP76.0TPHIN_PO_ACTT41Text Table for Handover ProfilesTakeoverHandover of Technical Objects
141ERP EHP76.0TPHIN_TCB0331Internal Characteristic Numbers for ToHo CharacteristicsTakeoverHandover of Technical Objects
Plant Maintenance :: Technical Objects :: Additional Functions :: Measuring Points and Counters
ProductVersionTableColumnsIndexesDescriptionModule
142ERP EHP76.0CLFT131Customizing for Reference Object Screen for Vehicle DataMeasuring Points and Counters
143ERP EHP76.0EAM_IFCU71Goods Movement for Technical ObjectMeasuring Points and Counters
144ERP EHP76.0IMEL92Entry List for Measurement DocumentsMeasuring Points and Counters
145ERP EHP76.0IMEP61Items in the Entry ListMeasuring Points and Counters
146ERP EHP76.0IMPH152Measurement and Counter Reading Transmission HistoryMeasuring Points and Counters
147ERP EHP76.0IMPTT496Measuring Point (Table)Measuring Points and Counters
148ERP EHP76.0IMRCCUST31System Settings for Measuring Points and Measurement DocsMeasuring Points and Counters
149ERP EHP76.0IMRG534Measurement DocumentMeasuring Points and Counters
150ERP EHP76.0IMRG_TEST_LOG21Log file for imrg testerMeasuring Points and Counters
151ERP EHP76.0IMTR61Termination of MeasRead. Data Transfer to Measuring PointsMeasuring Points and Counters
152ERP EHP76.0INHB_MP_TRANS31Meas. Pt: TRANS - Post Logic for Transferring Meas. ValsMeasuring Points and Counters
153ERP EHP76.0T370CON_TOL61PM: Tolerance for Consumption Control CheckMeasuring Points and Counters
154ERP EHP76.0T370CON_TOL_T41PM: Tolerance for Consumption Control Check TextsMeasuring Points and Counters
155ERP EHP76.0T370FLD_GMOVE101PM: Goods Movement/Account Assignment Usage TransactionMeasuring Points and Counters
156ERP EHP76.0T370FLD_GMOVE_T41PM: Goods Movement/Account Assignmt Consumpt.Transactn TextsMeasuring Points and Counters
157ERP EHP76.0T370FLD_MAT51Fluid TypesMeasuring Points and Counters
158ERP EHP76.0T370FLD_STN51PM: Gas Stations for Fleet ManagementMeasuring Points and Counters
159ERP EHP76.0T370FLD_STN_T41PM: Gas Stations for Fleet Management, TextsMeasuring Points and Counters
160ERP EHP76.0T370O61Object Categories Allowed for MeasPoints and MeasDocumentsMeasuring Points and Counters
161ERP EHP76.0T370P91Measuring Point CategoryMeasuring Points and Counters
162ERP EHP76.0T370P_T41Language-Dependent Texts for T370PMeasuring Points and Counters
Plant Maintenance :: Technical Objects :: Additional Functions :: Permits
ProductVersionTableColumnsIndexesDescriptionModule
163ERP EHP76.0IHGNS181Permit Segment for Plant MaintenancePermits
164ERP EHP76.0IHSG275Object-Related Permits in Plant MaintenancePermits
165ERP EHP76.0T352T21Permit CategoriesPermits
166ERP EHP76.0T352T_T41Text for Permit CategoriesPermits
167ERP EHP76.0T357G111PermitsPermits
168ERP EHP76.0T357G_GR31PM: Permit groupsPermits
169ERP EHP76.0T357G_T61Text for Table 357GTPermits
Plant Maintenance :: Technical Objects :: Additional Functions :: Warranties
ProductVersionTableColumnsIndexesDescriptionModule
170ERP EHP76.0BGMK211Master Warranty HeaderWarranties
171ERP EHP76.0BGMKOBJ131Master Warranty - Object AssignmentWarranties
172ERP EHP76.0BGMP221Master Warranty ItemWarranties
173ERP EHP76.0BGMS71Master Warranty Text ItemWarranties
174ERP EHP76.0BGMT62Master Warranty TextWarranties
175ERP EHP76.0BGMZ161Warranty CounterWarranties
176ERP EHP76.0T79061Warranty Transaction - Initial ValuesWarranties
177ERP EHP76.0T790G131Warranty TypeWarranties
178ERP EHP76.0T790G_T41Warranty Type TextWarranties
179ERP EHP76.0T790T41Warranty Category FunctionsWarranties
180ERP EHP76.0T790T_C31Warranty Category Default ValuesWarranties
181ERP EHP76.0T790_C51Warranty Default Values - Initial TransactionsWarranties
182ERP EHP76.0T791Z41Permitted Warranty Counters - GeneralWarranties