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

60 columns | Print definition?ERP 6.0  | SICHT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1T063OOK Codes in Inventory Management12SICHTView of the data to be processednvarchar20
2TTABTax Table Dependent Parameters (Foreign Key)6SICHTOrganizational areanvarchar10
TOPBasic Functions
3T182BStructure of Info View in SD Reporting3SICHTInfo view for SD analysisnvarchar30
4T182BTStructure of an Info View in Reporting4SICHTInfo view for SD analysisnvarchar30
5T182CAllocate Report > (User, View)4SICHTInfo view for SD analysisnvarchar30
6T182DAllocate Report > (View, Form)3SICHTInfo view for SD analysisnvarchar30
7T476Parameterization of the Configuration Editor2SICHTOrganizational areanvarchar10
8T476TParameterization of the Configuration Editor3SICHTOrganizational areanvarchar10
TOPBusiness Partner
9TPR2Partner-Obj. Relationship: Assignment Cat. - Application Cat5SICHTHide Date Depending on Assignment Categorynvarchar10
TOPBusiness Partner Enhancements for Financial Services
10TPZ3SBP View -> BP Field Group Assignment2SICHTBusiness Partner Viewnvarchar40
TOPClaims Management
11TICL300Category of Damaged or Insured Object3SICHTDetailed View of Insured Objectnvarchar60
TOPClasses
12CLPROFClassification: Parameters for Settings58SICHTOrganizational Areanvarchar100
13KLAHClass Header Data18SICHTOrganizational Areanvarchar100
14TCLSClasses: Organizational areas3SICHTOrganizational Area Indicatornvarchar10
15TCLSTClasses: Org. Areas (Texts)4SICHTOrganizational Area Indicatornvarchar10
TOPCollateral Management System
16TCMS_BDT_V_PLPlausibility checks for view5SICHTViewnvarchar60
TOPEnvironment
17LKLAHClass Header (Special Objects)18SICHTOrganizational Areanvarchar100
TOPFlexible Real Estate Management
18TIVCABDTSCRBDT View for All Title Elements2SICHTViewnvarchar60
TOPIndustry Solution Catch Weight Management
19CON_FIN_CKOMPUAllowance for Price Update10SICHTCost Component Viewnvarchar20
TOPInventory Management
20T063DScreen Control: View in Inventory Management3SICHTView of the data to be processednvarchar20
TOPObject Dependencies
21TCUAXOrganizational Areas Control Table3SICHTOrganizational Area Indicatornvarchar10
TOPProduct Cost Planning
22TCKH8Cost Component Views in Display2SICHTCost Component Viewnvarchar20
23TCKH9Texts for Cost Component Views in Display3SICHTCost Component Viewnvarchar20
TOPProduct Safety
24TCGRULPOSMRESTEHS: Easy Expert Set of Rules, Characteristic Restrictions22SICHTOrganizational Areanvarchar100
TOPProfitability Analysis
25TKEVA03Costing Key20SICHTCost Component Viewnvarchar20
TOPRecipe
26RCPC_VDEF_EQRDefinition of EQR Views2SICHTView Namenvarchar100
27RCPC_VDEF_EQRTLanguage-Dependent Descriptions of the Recipe Views2SICHTView Namenvarchar100
28RCPC_VDEF_POBDefinition of POB Views2SICHTView Namenvarchar100
29RCPC_VDEF_POBTLanguage-Dependent Descriptions of the POB Views2SICHTView Namenvarchar100
30RCPC_VDEF_RCPDefinition of RCP Views2SICHTView Namenvarchar100
31RCPC_VDEF_RCPTLanguage-Dependent Descriptions of the Recipe Views2SICHTView Namenvarchar100
32RCPC_VIEWSPE_EQRAssignment: View<->EQR Specification Type3SICHTView Namenvarchar100
33RCPC_VIEWSPE_POBAssignment: View<->POB Specification Type3SICHTView Namenvarchar100
34RCPC_VIEWSPE_RCPAssignment: View<->RCP Specification Type3SICHTView Namenvarchar100
TOPReport Selection for Product Costing
35KKBMMCharacteristic Assignment for Selection Screens for Ord. Sel4SICHTIndicator for selection screennvarchar20
36KKBSBSelection Screens for Order Selection4SICHTIndicator for selection screennvarchar20
37KKBSBTText Table for Selection Screens5SICHTIndicator for selection screennvarchar20
TOPRisk Analysis
38JBRBDSLFNRM-BDS: Run Number Definition5SICHTView of an Analysis Structurenvarchar30
TOPSAP Business Partner
39TBZ0FAssign BDT Object Part -> BDT Views4SICHTViewnvarchar60
40TBZ3EBDT Views3SICHTViewnvarchar60
41TBZ3FBDT Views: Texts4SICHTViewnvarchar60
42TBZ3GBDT-Views: Further checks3SICHTViewnvarchar60
43TBZ3HAssign BDT Section -> BDT View5SICHTViewnvarchar60
44TBZ3SAssign BDT View -> BDT Field Groups3SICHTViewnvarchar60
45TBZ4ABDT GUI Functions: Active for Each View4SICHTViewnvarchar60
46TBZ4BBDT GUI Functions: Active per View/Screen Seq.Variant (Obs)4SICHTViewnvarchar60
47TBZ4CBDT-GUI Functions: Active per View/Screen Sequence Cat.4SICHTViewnvarchar60
48TBZ9JBP relationship cat. -> BP view allocation4SICHTViewnvarchar60
TOPSAP Business Workflow
49TSWSBusiness Workflow: Definition of Views2SICHTDescription of view for work itemsnvarchar120
50TSWSTBusiness Workflow: Texts for Views on Work Items3SICHTDescription of view for work itemsnvarchar120
51TWFSWorkflow 3.0: Folders - Views of a User3SICHTDescription of view for work itemsnvarchar120
TOPSAP Healthcare - Industry-Specific Components for Hospitals
52NTPKCHIS-H CH: Zusatzfelder Leistungsstamm Schweiz (TARMED)30SICHTIS-H CH: cd.: modalità di indicazione prestazione in fatturanvarchar10
TOPSCM Basis
53CIF_IMCLAIntegration Model Reference Tables for Classes2SICHTOrganizational Area Indicatornvarchar10
TOPStaffing
54T77I1Views with Grouping3SICHTView for Startnvarchar80
55T77I6Views2SICHTView for Startnvarchar80
56T77I7View Texts3SICHTView for Startnvarchar80
57T77IAAreas per View2SICHTView for Startnvarchar80
58T77ICData Views with Grouping2SICHTView for Startnvarchar80
TOPTechnical Objects
59EAML_D_TCLSOrganizational area for characteristics with linear data4SICHTOrganizational Area Indicatornvarchar10
TOPVariant Configuration
60CUCOAdditional Data for Configurable Objects7SICHTOrganizational Area Indicatornvarchar10