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

40 columns | Print definition?ERP 6.0  | CLASSID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1PYD_D_FOLPayroll Data Source Folder2CLASSIDPayroll Data Source Class IDnvarchar300
2PYD_D_FOLTPayroll Data Source Folder Text3CLASSIDPayroll Data Source Class IDnvarchar300
3PYD_D_FOLTYPayroll Data Source Folder Type Assignment2CLASSIDPayroll Data Source Class IDnvarchar300
4PYD_D_FOLTYSCPayroll Data Source Folder Type Semantical Relationship2CLASSIDPayroll Data Source Class IDnvarchar300
TOPAdvertising Management
5TJHCUSTENVCLUBIS-M: Cluster Builder Levels for Business Partner Environmnt4CLASSIDObject Provider: Class identificationnvarchar300
TOPAnalysis Process Designer
6RSANT_FCT_CIDFactory - Class IDs1CLASSIDClass ID for Objectsnvarchar300
7RSANT_FCT_CIDAFactory - Class IDs - Attributes to Be Serialized1CLASSIDClass ID for Objectsnvarchar300
8RSANT_FCT_CIDNFactory - Class IDs - Node Attribute1CLASSIDClass ID for Objectsnvarchar300
9RSANT_FCT_CIDTFactory - Repository for Class IDs - Texts2CLASSIDClass ID for Objectsnvarchar300
10RSANT_FCT_TOOLFactory - Toolbar Tools4CLASSIDClass ID for Objectsnvarchar300
TOPCollectionsDisbursements
11INSCUSTENVCLUBLevels of the IS-U CIC Cluster Builder4CLASSIDObject Provider: Class identificationnvarchar300
12TFSCD_COV_CLUBFSCD: Levels Cluster Builder Business Partner Environment4CLASSIDObject Provider: Class identificationnvarchar300
TOPCross-Application Components
13PLLPOTask list - operation/activity194CLASSIDInternal Class Numbernvarchar100
TOPCustomer Interaction Center
14CCM_OPFACTORYObject Provider Service: Class Definition1CLASSIDObject Provider: Class identificationnvarchar300
15CRM_CIC_OPDELCObject Provider Service: class delegation - customer1CLASSIDObject Provider: Class identificationnvarchar300
16CRM_CIC_OPDELSObject Provider Service: class delegation - delivery1CLASSIDObject Provider: Class identificationnvarchar300
17CRM_CIC_OPFACTObject Provider Service: class definition1CLASSIDObject Provider: Class identificationnvarchar300
18CRM_CIC_OPFACTTObject Provider Service: class definition2CLASSIDObject Provider: Class identificationnvarchar300
TOPFront Office
19EWCUSTENVCLUBLevels of the IS-U CIC Cluster Builder4CLASSIDObject Provider: Class identificationnvarchar300
TOPMaster Data Distribution
20/ISDFPS/TL1Task List - Operation/Activity194CLASSIDInternal Class Numbernvarchar100
TOPMetadata Repository
21RSOCLASSBW Metadata Repository: Class1CLASSIDBW Metadata Repository, Classe: Qualified Namenvarchar800
22RSOCLASSATTRBW Metadata Repository: Attributes for a Class1CLASSIDBW Metadata Repository, Classe: Qualified Namenvarchar800
23RSOCLASSINHBW Metadata Repository: (Multiple) Inheritance from Classes1CLASSIDBW Metadata Repository, Classe: Qualified Namenvarchar800
24RSOCLASSREFBW Metadata Repository: References for a Class1CLASSIDBW Metadata Repository, Classe: Qualified Namenvarchar800
TOPPatient Management
25N1COMPIS-H: Clinical Order - Module Master Data3CLASSIDCORD/PREG: Component Class namenvarchar300
TOPProduct Configurator
26COMM_CFGCHARACBasic Data for Characteristics7CLASSIDInternal identifier of a model elementint100
TOPPublic Sector Contract Accounts Receivable and Payable
27TFMCA_COV_CLUBIS-PS-CA: Set Hierarchy Cluster Builder Business Part. Envir4CLASSIDObject Provider: Class identificationnvarchar300
TOPRemaining Beverage - Obsolete Objects
28/BEV3/CHCAGCLSFAssignment: Agreement to classification2CLASSIDClassification Identifiernvarchar40
29/BEV3/CHCCLSFClassification2CLASSIDClassification Identifiernvarchar40
30/BEV3/CHCCLSFFLTAssignment: Classification to filter3CLASSIDClassification Identifiernvarchar40
31/BEV3/CHCCLSFTClassification - Text2CLASSIDClassification Identifiernvarchar40
TOPRouting
32PLPOTask list - operation/activity194CLASSIDInternal Class Numbernvarchar100
TOPSAP Healthcare - Industry-Specific Components for Hospitals
33NNL_CLASSMeldung Klassification6CLASSIDKlassification IDnvarchar30
34NNL_CLASSLMeldung Klassifikation log6CLASSIDKlassification IDnvarchar30
35TNNLCLASS_CATMeldung Klassifikation Katalog3CLASSIDKlassification IDnvarchar30
36TNNLCLASS_MESSMeldung Klassifikation meldungen3CLASSIDKlassification IDnvarchar30
37TNNLREJCLAS_CATISH NL Rejection Classification Catalogue3CLASSIDKlassification IDnvarchar30
38TNNLREJCLAS_MESSRejection Classification Messages3CLASSIDKlassification IDnvarchar30
TOPValidation, Substitution and Rules
39GB90Boolean Formula Header for Rules and Boolean Functions4CLASSIDBoolean class. Which fields can be used.nvarchar30
TOPWaste Management
40EWACUSTENVCLUBLevels of Waste CIC Cluster Builder4CLASSIDObject Provider: Class identificationnvarchar300