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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

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

65 columns | Print definition?ERP 6.0  | OBJTY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/OPT/X185WFI Role Configuration5OBJTYObject Typenvarchar20
2/OPT/Y185WFI Role Configuration5OBJTYObject Typenvarchar20
3/OPT/Z185WFI Role Configuration5OBJTYObject Typenvarchar20
4/PTGWFI/W_ORGWFI Role Configuration5OBJTYObject Typenvarchar20
5TCS19BOM Item Object Types2OBJTYObject type (BOM item)nvarchar10
6TCS22BOM Item Object Types: external --> internal4OBJTYObject type (BOM item)nvarchar10
7TSTCRIDTesttabelle für Very - analog CRID angelegt2OBJTYFür Very - Kopie CR_OBJTY - CIM Resource Object Typenvarchar20
TOPBasic Data
8TNOBJIS-H: Objects for Client Reset Program2OBJTYIS-H: Object Type (Table, Number Range, Long Text, etc.)nvarchar10
TOPBills of Material
9STPOBOM item64OBJTYObject type (BOM item)nvarchar10
10TCS20Texts for BOM Item Object Types3OBJTYObject type (BOM item)nvarchar10
11TCS21BOM Item Object Types: internal --> external3OBJTYObject type (BOM item)nvarchar10
TOPCAD Integration
12TCAOObject ID in Product Structure Explosion2OBJTYObject Type for Product Structure Explosionnvarchar30
13TCAOTLanguage-Dependent Object Identification3OBJTYObject Type for Product Structure Explosionnvarchar30
TOPComputer Aided Process Planning
14VERTEAssignment of CAPP processes to work centers2OBJTYObject types of the CIM resourcenvarchar20
TOPCross-Application Components
15CCRHDWork Center Header2OBJTYObject types of the CIM resourcenvarchar20
16PLLPOTask list - operation/activity19OBJTYObject types of the CIM resourcenvarchar20
TOPDistribution Requirements Planning
17PLPLAN_PARAMBOM-dependent planning parameter16OBJTYObject types of the CIM resourcenvarchar20
TOPFrance
18T77TNM_OBTable Training Objective7OBJTYTraining Objective Categorynvarchar20
TOPGlobal Trade Services
19/SAPSLL/TCO120Assignment of Authorization Groups to Program Objects4OBJTYObject Typenvarchar40
TOPMaintenance Task Lists
20MPOSMaintenance item21OBJTYObject types of the CIM resourcenvarchar20
TOPMaster Data Distribution
21/ISDFPS/TL1Task List - Operation/Activity19OBJTYObject types of the CIM resourcenvarchar20
TOPMaterial Master
22MFHM_TMPFile for Incorrect Data in Direct Input7OBJTYObject types of the CIM resourcenvarchar20
23MVHMMRP material version4OBJTYObject types of the CIM resourcenvarchar20
TOPPatient Management
24NCTOContext-to-Object Assignment5OBJTYIS-H: Object Typenvarchar30
25NOBTYIS-H: Object List1OBJTYIS-H: Object Typenvarchar30
26NOBTYTIS-H: Object List, Texts1OBJTYIS-H: Object Typenvarchar30
27NOCTYIS-H: Context-to-Object Type Assignment4OBJTYIS-H: Object Typenvarchar30
TOPPlant Data Collection
28T705RAssignment of work center to subsystem link group2OBJTYObject types of the CIM resourcenvarchar20
TOPProduction Campaign
29PCMO4Production campaign pegged reqmt resource network8OBJTYObject types of the CIM resourcenvarchar20
TOPProduction Planning for Process Industries
30DTEFWDowntime Values Entered4OBJTYObject types of the CIM resourcenvarchar20
TOPProduction ResourcesTools
31AFFHPRT assignment data for the work order10OBJTYObject types of the CIM resourcenvarchar20
32CRFHCIM production resource/tool master data2OBJTYObject types of the CIM resourcenvarchar20
33CRVD_ALink of PRT to Document2OBJTYObject types of the CIM resourcenvarchar20
34CRVD_BLink of Document to PRT6OBJTYObject types of the CIM resourcenvarchar20
35CRVE_AAssignment PRT data - equipment2OBJTYObject types of the CIM resourcenvarchar20
36CRVE_BAssignment equipment - PRT data3OBJTYObject types of the CIM resourcenvarchar20
37CRVM_ALink of PRT data to a material2OBJTYObject types of the CIM resourcenvarchar20
38CRVM_BLink of material to a production resource/tool4OBJTYObject types of the CIM resourcenvarchar20
39CRVP_ALinkage of PRT Data - Measuring Point2OBJTYObject types of the CIM resourcenvarchar20
40CRVP_BLinkage of Measuring Point - PRT Data3OBJTYObject types of the CIM resourcenvarchar20
41CRVS_ARelationship of PRT internal number to PRT external number2OBJTYObject types of the CIM resourcenvarchar20
42CRVS_BRelationship of PRT external number to PRT internal number3OBJTYObject types of the CIM resourcenvarchar20
TOPRemote Logistics Management
43OIO_CM_OBJGP_CTObject group contents3OBJTYObject type for document flownvarchar40
44OIO_CM_OBJSTDocument flow object type status codes1OBJTYObject type for document flownvarchar40
45OIO_CM_OBJST_TXDocument flow object type status code names2OBJTYObject type for document flownvarchar40
46OIO_CM_OBJTYObject types for RLM1OBJTYObject type for document flownvarchar40
47OIO_CM_OBJTY_TXObject type texts2OBJTYObject type for document flownvarchar40
48OIO_CU_OBJTYRLM Object type customer values2OBJTYObject type for document flownvarchar40
49OIO_CU_OBJTY_TXRLM Object type customer texts3OBJTYObject type for document flownvarchar40
50OIO_MT_DFLOWMaterial tracking document flow definition3OBJTYObject type for document flownvarchar40
51OIO_MT_FDMAPField mapping for tracking program2OBJTYObject type for document flownvarchar40
52OIO_MT_TRGRP_STTracking group status3OBJTYObject type for document flownvarchar40
53OIO_MX_OBJECTRLM tracking extract object data5OBJTYObject type for document flownvarchar40
54OIO_RT_SBSDCRLM returns processes3OBJTYObject type for document flownvarchar40
TOPRouting
55PLFHTask list - production resources/tools15OBJTYObject types of the CIM resourcenvarchar20
56PLPOTask list - operation/activity19OBJTYObject types of the CIM resourcenvarchar20
TOPSCM Basis
57CRCIFKAPIDObject IDs for Changed Capacities2OBJTYObject types of the CIM resourcenvarchar20
TOPSimulation
58VSAFFH_CNVersion: PRT allocation to work order11OBJTYObject types of the CIM resourcenvarchar20
TOPWork Center
59CRCAWork Center Capacity Allocation2OBJTYObject types of the CIM resourcenvarchar20
60CRCIFOBJObject IDs of changed capacities2OBJTYObject types of the CIM resourcenvarchar20
61CRCOAssignment of Work Center to Cost Center2OBJTYObject types of the CIM resourcenvarchar20
62CRHDWork Center Header2OBJTYObject types of the CIM resourcenvarchar20
63CRHHHierarchy Header Data2OBJTYObject types of the CIM resourcenvarchar20
64CRIDCIM Resource - Entities2OBJTYObject types of the CIM resourcenvarchar20
65CRTXText for the Work Center or Production Resource/Tool2OBJTYObject types of the CIM resourcenvarchar20