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

82 columns | Print definition?ERP 6.0  | OBTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMFND/GS002Geospatial service - object assignment6OBTYPObject Categorynvarchar30
2/SMFND/OID01_GSGeneral purpose SAP Object <-> GIS OBJECTID mapping table5OBTYPObject Categorynvarchar30
3TC34Allocating operation to object type for the check routine1OBTYPObject Categorynvarchar30
4TIS01Control of business activities: Real estate depend. activit.1OBTYPObject Categorynvarchar30
5TIS02Real estate status control: Set status and subsequent status1OBTYPObject Categorynvarchar30
6TIV81Real estate object type - Status profile allocation2OBTYPObject Categorynvarchar30
7TXV03Translation table for virt. object categories2OBTYPObject type for objects to which addresses are assignednvarchar20
8TZV03Object categ.for objects which addresses can be assigned to1OBTYPObject type for objects to which addresses are assignednvarchar20
TOPAuto-ID Backend Integration
9AIDEPCDTLObsolite: EPC Details4OBTYPObeolte: EPC object typenvarchar40
TOPBasic Data and Tools
10EHSBC_ST01EHS-BAS: Assignment: Status Profile to Object Type2OBTYPObject Categorynvarchar30
TOPBasic Data for Certificates
11QCVKCertificate profile header8OBTYPObject Categorynvarchar30
TOPBasic functions
12HUSTOBJInformation about HU Status Object3OBTYPObject Categorynvarchar30
TOPBusiness Partner
13BPTRGP_OBJADRConversion: Obj. Addresses - PDC Addr. (Real Estate Objects)4OBTYPObject type for objects to which addresses are assignednvarchar20
TOPClinical System
14N1OBFLDIS-H*MED: Definition of assignmt object type - object field1OBTYPObject Type (for Definition of Required Entry Fields)nvarchar100
15N1OBFLDTIS-H*MED: Text table for the N1OBFLD2OBTYPObject Type (for Definition of Required Entry Fields)nvarchar100
16N1OFSIS-H*MED: Assignment object field - status3OBTYPObject Type (for Definition of Required Entry Fields)nvarchar100
TOPConditions
17KONDINDGeneral Document Index for Conditions2OBTYPPermitted Object Types for Index to Conditionsnvarchar20
18T681OPermitted Document Categories for the Index to Conditions1OBTYPPermitted Object Types for Index to Conditionsnvarchar20
19T681OTObject Category Texts for Index to Conditions2OBTYPPermitted Object Types for Index to Conditionsnvarchar20
TOPContract Accounts Receivable and Payable
20TFK006AObject Types for Contract Acct Search2OBTYPObject Typenvarchar20
21TFK006ATObject text3OBTYPObject Typenvarchar20
22TFK006CNote to Payee - Key Words2OBTYPObject Typenvarchar20
23TFK006DNote to Payee - Structure2OBTYPObject Typenvarchar20
24TFK006FAssigned selection categories2OBTYPObject Typenvarchar20
25TFKIFDOAssignment of Objects to Interfaces2OBTYPObject Categorynvarchar20
26TFKIFDO_GENAssignment of Objects to Generated Interfaces2OBTYPObject Categorynvarchar20
TOPCross-Application Components
27DSV_MASS_OBJECTObjects for Status Changes in Mass Change Tool2OBTYPObject Categorynvarchar30
28DSV_MASS_VORGAllowed Processes in Mass Change Tool2OBTYPObject Categorynvarchar30
TOPData Collection
29TKCODSAP-EIS: Object types in the object list1OBTYPObject Typenvarchar40
30TKCODTSAP-EIS: Texts for object types in object list2OBTYPObject Typenvarchar40
31TKCOHSAP-EIS: Object hierarchy for object collector1OBTYPObject Typenvarchar40
32TKCOHWSAP-EIS:Criteria for finding dep. objects for obj. collector1OBTYPObject Typenvarchar40
33TKCORSAP-EIS: Transport Attributes of Collected Objects1OBTYPObject Typenvarchar40
34TKCOUSAP-EIS: Key description for object class1OBTYPObject Typenvarchar40
TOPDistributed Maintenance
35/ISDFPS/PMCPRUNTransfer Change Authorization - Runtime Data9OBTYPChange Authorization - Object Typenvarchar40
36/ISDFPS/PMDISAOAlternative Data Transport - Objects per Scenario3OBTYPChange Authorization - Object Typenvarchar40
37/ISDFPS/PMDISRHDistribution Factory - Runtime Data9OBTYPObject type (such as material, BOM, ...)nvarchar40
38/ISDFPS/PM_CPPM: Distributed Maintenance - Change Authorization2OBTYPObject type (such as material, BOM, ...)nvarchar40
39/ISDFPS/PM_CPHPM Distributed Maintenance - Change Authorization History2OBTYPObject type (such as material, BOM, ...)nvarchar40
40/ISDFPS/PM_CPTMPPM Distributed Maintenance - Preselection for Redistribution2OBTYPObject type (such as material, BOM, ...)nvarchar40
TOPEngineering Change Management
41ECM_OBJTYPESSubscription of Application to Engineering Change Management3OBTYPObject Typenvarchar30
TOPFunctional Locations
42IHPAPlant Maintenance: Partners5OBTYPObject Categorynvarchar30
TOPGeneral Application Functions
43BSVWCOUP1System status events1OBTYPObject Categorynvarchar30
44BSVWCOUP2Status restrictions1OBTYPObject Categorynvarchar30
45BSVWCOUP3User Events for Status Object Types2OBTYPObject Categorynvarchar30
46BSVWCOUP4Status for User Events2OBTYPObject Categorynvarchar30
47BSVWCOUP5User Events for Status Object Types2OBTYPObject Categorynvarchar30
48BSVWCOUP6Status for User Events2OBTYPObject Categorynvarchar30
49BSVWOT2OAStatus Management Events: Status Objects <-> Object Kind1OBTYPObject Categorynvarchar30
TOPGeneral status management
50CRM_JSTOStatus Object Information3OBTYPObject Categorynvarchar30
51JSTOStatus object information3OBTYPObject Categorynvarchar30
52TJ03Object types1OBTYPObject Categorynvarchar30
53TJ03TTexts for object types1OBTYPObject Categorynvarchar30
54TJ03VResponsible for object types1OBTYPObject Categorynvarchar30
55TJ04Status control for object type1OBTYPObject Categorynvarchar30
56TJ05Permitted transactions per object type1OBTYPObject Categorynvarchar30
57TJ07Influence of system status on transactions3OBTYPObject Categorynvarchar30
58TJ11Assigning system statuses -> authorization keys2OBTYPObject Categorynvarchar30
59TJ21Permitted object types for status profile3OBTYPObject Categorynvarchar30
TOPInstalled Base
60T371STVIBase: Status Assignment Database Table3OBTYPIB: Object Categorynvarchar30
TOPLink Between Address Management and Objects
61TXVOBTYPType for Objects to Which Addresses are Assigned (Texts)2OBTYPType for Objects to Which Addresses are Assignednvarchar20
62TZVOBTYPType for Objects to Which Addresses are Assigned1OBTYPType for Objects to Which Addresses are Assignednvarchar20
63VZOBJECTObject Data (Virtual Object)4OBTYPType for Objects to Which Addresses are Assignednvarchar20
TOPLogistics - General
64ECP_FUNCT_TYPE_ORelevant object types for function types3OBTYPObject Categorynvarchar30
65ECP_PO_STATUSStatus for completion of PO3OBTYPObject Categorynvarchar30
TOPMaintenance Orders
66T350EAccess sequence addresses for address proposal purch. data4OBTYPObject Categorynvarchar30
TOPMaintenance Processing
67/ISDFPS/MNTF_POSDFPS: Mass Maintenance4OBTYPObject type (such as material, BOM, ...)nvarchar40
TOPMeasuring Points and Counters
68T370OObject Categories Allowed for MeasPoints and MeasDocuments1OBTYPObject Categorynvarchar30
TOPPatient Management
69N1COMPCONIS-H: Component Configuration Data3OBTYPObject Categorynvarchar30
70N1COMPDEFAIS-H: Module Definition - Object Type Connection3OBTYPObject Categorynvarchar30
TOPPortugal
71T5PTCHR-PT: Time objects classification2OBTYPTime object typenvarchar20
72T5PTTHR-PT: Time object value texts3OBTYPTime object typenvarchar20
73T5PTVHR-PT: Time object values2OBTYPTime object typenvarchar20
TOPProfit Center Accounting
74KE1_WU_IM_ITEMPCA Where-Used List: Itemization for Real Estate12OBTYPObjects for Real Estate IMKEY (as from Rel. 3.0)nvarchar20
TOPQuality Inspection
75QALSInspection lot record7OBTYPObject Categorynvarchar30
TOPRouting
76TC33Allocation of function code to the operation to be checked7OBTYPObject Categorynvarchar30
TOPSAP Healthcare - Industry-Specific Components for Hospitals
77/ISHFR/TJ07Influence of system status on transactions5OBTYPObject Categorynvarchar30
TOPSimulation
78VSJSTO_CNVersion: Information on status object4OBTYPObject Categorynvarchar30
TOPTask Resource Management
79LOBSLObstacle4OBTYPObstacle Typenvarchar10
80LRTQAResource type and resource element qualifications3OBTYPObject Typenvarchar20
TOPTreasury
81SANO1Address-object relationship4OBTYPObject type for objects to which addresses are assignednvarchar20
TOPWarehouse Management
82T320Assignment IM Storage Location to WM Warehouse Number8OBTYPPicking area (storage type) for Lean WMnvarchar30