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

30 columns | Print definition?ERP 6.0  | VACLID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1EHPRCC_EXPL_PCP: BOS-Explosion configuration composition priorities7VACLIDRatingnvarchar100
TOPEnvironment, Health and Safety
2/TDAG/CPC_EXPL_PCP: BOS-Explosion configuration composition priorities7VACLIDRatingnvarchar100
3EHQMT_BASIC_DATAEH&S-QM: Basic Data for Inspection Plans9VACLIDRatingnvarchar100
4EHQMT_IP_MEMORYEH&S-QM: Memorize Created Inspection Plans4VACLIDRatingnvarchar100
5EHSBT_APPL_SCOPEEHS: General Scope of Application19VACLIDRatingnvarchar100
6TCG86EHS: Characteristic rating2VACLIDRatingnvarchar100
TOPInspection Planning
7QMIPD_SPECIP_MATMapping Table Between Inspection Plan and EHS Specification3VACLIDRatingnvarchar100
8QMIPD_SPECMATLOGStatus of Synchr. Between Inspection Plan and Specification3VACLIDRatingnvarchar100
TOPProduct Safety
9CCRCC_DETEHS: Data Determination Modules per Regulation/Scenario13VACLIDRatingnvarchar100
10ESTDUEHS: Additional Information: Value Assignment Usage18VACLIDRatingnvarchar100
11ESTLUEHS: Report Variant Rating16VACLIDRatingnvarchar100
12ESTSTEHS: Specification Status Assignment19VACLIDRatingnvarchar100
13TCG87EHS: Language-Dependent Desc. for Value Assignment Rating3VACLIDRatingnvarchar100
14TCG98EHS: Usage profile-rating-validity area assignments3VACLIDRatingnvarchar100
15TCGRULPOSUREHS: Easy Expert Set of Rules, Usage Entry for Reading7VACLIDRatingnvarchar100
16TCGRULPOSUWEHS: Easy Expert Set of Rules, Usage Entry for Writing7VACLIDRatingnvarchar100
17TCGTPLUEHS: Inheritance Templates - Usages17VACLIDRatingnvarchar100
TOPRecipe
18RCPC_MSC_ASCOPEChanges to Scope-of-Application Status5VACLIDRatingnvarchar100
19RCPC_RATINGRatings Allowing Transfer From GR to MR2VACLIDRatingnvarchar100
TOPRecipe Development
20/PLMB/CCK_CUSCompliance Check: Constraint Usages3VACLIDRatingnvarchar100
21/PLMB/CCK_PCUSCompliance Check: Saved Parameters - Constraint Usages3VACLIDRatingnvarchar100
22/PLMB/CCK_RUSCompliance Check: Result Usages4VACLIDRatingnvarchar100
23/PLMI/DEF_PARAMDefault Calculation Parameter6VACLIDRatingnvarchar100
24/PLMI/RCA_TAVADefine Rating for Target Values for Specification2VACLIDRatingnvarchar100
TOPResourcen Management
25FRMLC35RMGMT Formula: Key Figures5VACLIDKey Figure Ratingnvarchar100
26FRMLC50RMS-FRM: Data Source2VACLIDRatingnvarchar100
27FRMLC51RMS-FRM: Data Source Texts2VACLIDRatingnvarchar100
28FRMLC_VIEWPARARMS22: Formula View Parameters9VACLIDValue Assignment Rating for Reading and Writing EHS Datanvarchar100
29PAFRMRMS-FRM: Alternative Segment for Object Category FRM6VACLIDRating of Formula Compositionnvarchar100
30RMSAT_STD_PARA_HRMS-ATL: Header Table Parameter Standardization6VACLIDRatingnvarchar100