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

65 columns | Print definition?ERP 6.0  | CLASSTYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBP_PDATTDocument Attachment6CLASSTYPEBusiness Document Service: Class Typenvarchar20
2BBP_TRANS_ARCATBBP: Transient Storage of Archived Attachments8CLASSTYPEBusiness Document Service: Class typenvarchar20
3BDS_BAR_IN_REFReference Structure for BDS_BAR_IN6CLASSTYPEBusiness Document Service: Class typenvarchar20
4BDS_CON019BDS: Link Table4CLASSTYPEBusiness Document Service: Class typenvarchar20
5CLF_OBJKEY_MPPNGClassification Object Key Mapping2CLASSTYPEClass Typenvarchar30
6LAW2D_USMM_PERSLAW 2.0 USMM user results15CLASSTYPENew Input Valuesnvarchar10
7REQATTAttachments for shopping cart lines8CLASSTYPEBusiness Document Service: Class Typenvarchar20
TOPBusiness Document Service
8BDS_BAR_INBusiness Document Service: Internal Bar Codes5CLASSTYPEBusiness Document Service: Class typenvarchar20
9BDS_CLASSBDS: Class Definition2CLASSTYPEBusiness Document Service: Class typenvarchar20
10BDS_CLASSLBDS: Language Table for Class Definition2CLASSTYPEBusiness Document Service: Class typenvarchar20
11BDS_CL_DOCBDS: Class Definition3CLASSTYPEBusiness Document Service: Class typenvarchar20
12BDS_CONN00BDS: Client-Specific Link Tables4CLASSTYPEBusiness Document Service: Class typenvarchar20
13BDS_CONN01BDS: Client-Independent Link Tables3CLASSTYPEBusiness Document Service: Class typenvarchar20
14BDS_CONN02BDS: Link Table Default for Undefined Classes3CLASSTYPEBusiness Document Service: Class typenvarchar20
15BDS_CONN03BDS: Link Table Default for Undefined Classes3CLASSTYPEBusiness Document Service: Class typenvarchar20
16BDS_CONN04BDS: Client-Specific Link Tables4CLASSTYPEBusiness Document Service: Class typenvarchar20
17BDS_CONN05BDS: Link Table Default for Undefined Classes3CLASSTYPEBusiness Document Service: Class typenvarchar20
18BDS_CONN06BDS: Link Table Default for Undefined Classes4CLASSTYPEBusiness Document Service: Class typenvarchar20
19BDS_CONN07BDS: Link Table Default for Undefined Classes4CLASSTYPEBusiness Document Service: Class typenvarchar20
20BDS_CONN08BDS: Link Table Default for Undefined Classes4CLASSTYPEBusiness Document Service: Class typenvarchar20
21BDS_CONN09BDS: Link Table Default for Undefined Classes3CLASSTYPEBusiness Document Service: Class typenvarchar20
22BDS_LOCLBDS: Assignment of Application Classes to KPro Doc. Classes2CLASSTYPEBusiness Document Service: Class typenvarchar20
23BDS_LOGBDS: Protocol Table for Accesses to BDS Documents5CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPBusiness Information Collection
24BDS_CONN23BDS: Link Table Default for Undefined Classes4CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPBusiness Planning and Simulation
25BDS_CONN22BDS: Link Table Default for Undefined Classes4CLASSTYPEBusiness Document Service: Class typenvarchar20
26BDS_CONN31BDS: Link Table Default for Undefined Classes4CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPCharacteristics
27CLNAMESPACENamespace for Characteristics / Classes3CLASSTYPEClass Typenvarchar30
TOPConstruction Progress Report
28/SAPPCE/TPNV04Construction Progress Report: Assignment BDS Document7CLASSTYPEBusiness Document Service: Class typenvarchar20
29/SAPPCE/TPNV06Planned Revenues: Assignment BDS Document6CLASSTYPEBusiness Document Service: Class typenvarchar20
30/SAPPCE/TPNV07Planned Costs: Assignment BDS Document6CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPControlling
31BDS_CONN24BDS: Link Table Default for Undefined Class4CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPCorporate Performance Monitor
32BDS_CONN15BDS: Link Table Default for Undefined Class4CLASSTYPEBusiness Document Service: Class typenvarchar20
33BDS_CONN17BDS: Link Table Default for Undefined Class3CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPCustomer Interaction Center
34CCM_OPCLASSTYPEObject Provider Service: Class Type Definition1CLASSTYPEObject Provider Service: Class Typenvarchar10
35CCM_OPCLASSTYPETObject Provider Service: Class Type Definition2CLASSTYPEObject Provider Service: Class Typenvarchar10
36CCM_OPFACTORYObject Provider Service: Class Definition2CLASSTYPEObject Provider Service: Class Typenvarchar10
TOPDocument Management System
37EDMS_LAY_DETAILList of Layout Criteria8CLASSTYPEClass Typenvarchar30
38TDIBPDDS: context8CLASSTYPEClass typenvarchar30
39TDIPRDDS: definition of plotters3CLASSTYPEClass Typenvarchar30
TOPEnd User Technology
40BDS_CONN111BDS: Link Table Default for Undefined Classes3CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPIntegrated Product and Process Engineering
41USRTICLASSClass Assignment for Tabular Maintenance of iPPE6CLASSTYPEClass Typenvarchar30
TOPLaunchpad
42BDS_CONN24ABDS: Linkage Default for non-defined Classes4CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPMaintenance Program Definition
43MPDCUST_EFFT_DOCCustomising table to store effectivity data for documents4CLASSTYPEClass Typenvarchar30
44MPDEFFECTMPD effectivity data4CLASSTYPEClass Typenvarchar30
TOPManufacturing Execution System
45/SAPHT/MESZPCHARCustom formula parameters for characteristcs.8CLASSTYPEclass typenvarchar30
TOPPlanning
46RSISISVC_CServices: Assignment of Classes (Customer)2CLASSTYPEServices: Type of Assigned Classnvarchar20
47RSISISVC_SServices: Assignment of Classes (SAP)2CLASSTYPEServices: Type of Assigned Classnvarchar20
TOPProcess Management
48BDS_CONN25BDS: Link Table Default for Undefined Class4CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPProduct Catalog
49TWPCDCOPYProduct Catalog: Transfer of Document Links During Creation6CLASSTYPEClass Typenvarchar30
TOPProduct Configurator
50COMM_CFGOCLASSBasic Data for OO-Classes6CLASSTYPEClass Typenvarchar30
TOPProduct Structure Browser
51FILTERDEFOperative Filter Entries for Product Structure Browser15CLASSTYPEClass Typenvarchar30
TOPReal Estate Management
52BDS_CONN26BDS: Link Table Default for Undefined Class4CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPSales and Distribution
53SCEOCLASSOO Classes of SCE Knowledge Base6CLASSTYPEClass typenvarchar30
54SCEPROFILEKnowledge-Base Profiles (SCE)7CLASSTYPEClass Typenvarchar30
TOPSAP Business Workflow
55BDS_CON020BDS: Link Table Default for Undefined Class4CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPSAP GUI for Windows Controls
56BDS_CONN14BDS: Client-Specific Link Tables4CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPSAP List Viewer
57BDS_CONN16BDS: Link Table Default for Undefined Class4CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPSAP Records Management
58SRMGSATNAMRecords Management: Content Model-Specific Attribute Names2CLASSTYPEClass Typenvarchar160
TOPSAPscript
59BDSX_CON04BDS link3CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPStakeholder Relationship Management
60BDS_CON028BDS: Link Table Default for Undefined Class4CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPTransaction Variant and Table Control Settings
61BDS_CONN21BDS: Link Table Default for Undefined Class3CLASSTYPEBusiness Document Service: Class typenvarchar20
TOPValidation, Substitution and Rules
62GB01Classes for Boolean Formulas2CLASSTYPEClass type: Read or writenvarchar10
63GB01CClasses for Boolean Formulas for Customers3CLASSTYPEClass type: Read or writenvarchar10
TOPWithout Description
64BDS_CONN18BDS: Link Table Default for Undefined Classes3CLASSTYPEBusiness Document Service: Class typenvarchar20
65BDS_CONN20BDS: Link Table Default for Undefined Classes3CLASSTYPEBusiness Document Service: Class typenvarchar20