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

36 columns | Print definition?ERP 6.0  | HITYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1THIOZCustomer Hierarchies: Allowed Organizational Assignments2HITYPCustomer hierarchy typenvarchar10
2THIZUCustomer Hierarchy: Allowed Account Group Assignments2HITYPCustomer hierarchy typenvarchar10
TOPAdvertising Management
3JJTKSIS-M/AM: Business Partner Hierarchy2HITYPIS-M: BP Hierarchy Hierarchy Typenvarchar10
4TJHVAIS-M/AM: General Contract Attributes for Sales Area9HITYPIS-M: Hierarchy Type of BP Hierarchynvarchar10
5TJJ69IS-M/AM: Hierarchy Type for BP Hierarchy2HITYPIS-M: Hierarchy Type of BP Hierarchynvarchar10
6TJJ70IS-M/AM: Text Table for BP Hierarchy Type3HITYPIS-M: Hierarchy Type of BP Hierarchynvarchar10
TOPBasic Functions
7KNVHCustomer Hierarchies2HITYPCustomer hierarchy typenvarchar10
8THITCustomer Hierarchy Types2HITYPCustomer hierarchy typenvarchar10
9THITTTexts for Customer Hierarchy Types3HITYPCustomer hierarchy typenvarchar10
10VBPASales Document: Partner14HITYPCustomer hierarchy typenvarchar10
TOPCross-Application Components
11VBBPASales Document: Partner14HITYPCustomer hierarchy typenvarchar10
12VVBBPASales Document: Partner14HITYPCustomer hierarchy typenvarchar10
13VVVBPASales Document: Partner14HITYPCustomer hierarchy typenvarchar10
TOPFreight Processing
14VFPAPartner for Shipment Costs14HITYPCustomer hierarchy typenvarchar10
TOPHandheld Connectivity
15/DSD/PR_CUSTMDSD Promotions - General Settings5HITYPCustomer hierarchy typenvarchar10
TOPMaterial Maintenance
16TPARBusiness Partner: Functions8HITYPCustomer hierarchy typenvarchar10
TOPOrganizational Management
17T777HObject Type Hierarchy3HITYPSuperior Object Typenvarchar40
TOPProfitability Analysis
18TKEBManagement for Operating Concerns (Client-Specific)5HITYPCustomer hierarchy typenvarchar10
TOPPurchasing
19EKPAPartner Roles in Purchasing13HITYPHierarchy category: vendor hierarchynvarchar10
20T161Purchasing Document Types16HITYPHierarchy category: vendor hierarchynvarchar10
TOPRecycling Administration Core Functions
21J_7LC51REA Data Filters: Access Sequences - Accesses5HITYPCustomer hierarchy typenvarchar10
22J_7LE09REA Partner Master: Document Types54HITYPCustomer hierarchy typenvarchar10
23J_7LV1KREA Document: Header Data87HITYPCustomer hierarchy typenvarchar10
TOPRemaining Beverage - Obsolete Objects
24/BEV1/BO_FIELDSField Conversion Condition Table for Information Structure6HITYPCustomer hierarchy typenvarchar10
25/BEV1/RBVBPASales Document: Partner, Copy VBPA for Indirect Orders14HITYPCustomer hierarchy typenvarchar10
26/BEV1/TSSDBTPRCategory Reference for Main Table Statistics Telephone Sales16HITYPCustomer Hierarchy Cat. to Be Used for Cat. Assignment TSnvarchar10
27/BEV1/TSVBCustomizing Telephone Sales per Sales Area5HITYPTelephone Sales: Customer Hierarchy Categorynvarchar10
28/BEV1/TSZTYMAVTTypes/Material Allocation Sales Area11HITYPCustomer Hierarchy Cat. to Be Used for Cat. Assignment TSnvarchar10
29/BEV3/CHCDPALLOCCDP: R/3 Environment Data35HITYPCustomer hierarchy typenvarchar10
TOPTransportation
30VTPAShipping Partner14HITYPCustomer hierarchy typenvarchar10
TOPTransportation and Distribution
31OIGSPAPartner in TD-shipment14HITYPCustomer hierarchy typenvarchar10
TOPVendor Master
32LFMHVendor hierarchy2HITYPHierarchy category: vendor hierarchynvarchar10
33TLHIOZVendor hierarchy: allowed assignments2HITYPHierarchy category: vendor hierarchynvarchar10
34TLHITVendor Hierarchy Category2HITYPHierarchy category: vendor hierarchynvarchar10
35TLHITTVendor hierarchy category (description)3HITYPHierarchy category: vendor hierarchynvarchar10
36TLHIZUVendor hierarchy: allowed account groups2HITYPHierarchy category: vendor hierarchynvarchar10