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  | BCHID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPClinical System
1N1BCEXPBasic Cat.: Export3BCHIDBasic Catalog: Catalog Keynvarchar330
2N1BCEXPCFGBasis Cat.: Export Configuration3BCHIDBasic Catalog: Catalog Keynvarchar330
3N1BCHBasic Cat.: Catalog Header2BCHIDBasic Catalog: Catalog Keynvarchar330
4N1BCH2OUOBSOLETE2BCHIDBasic Catalog: Catalog Keynvarchar330
5N1BCH2ROLEOBSOLETE2BCHIDBasic Catalog: Catalog Keynvarchar330
6N1BCH2USEROBSOLETE3BCHIDBasic Catalog: Catalog Keynvarchar330
7N1BCHBADIOBSOLET2BCHIDBasiskat.: Katalogschlüsselnvarchar330
8N1BCHCOMOBSOLETE2BCHIDBasic Catalog: Catalog Keynvarchar330
9N1BCHDIAGOBSOLETE2BCHIDBasic Catalog: Catalog Keynvarchar330
10N1BCHHITOBSOLETE2BCHIDBasic Catalog: Catalog Keynvarchar330
11N1BCHINTVOBSOLETE2BCHIDBasic Catalog: Catalog Keynvarchar330
12N1BCHMATOBSOLETE2BCHIDBasic Catalog: Catalog Keynvarchar330
13N1BCHPROBOBSOLETE2BCHIDBasic Catalog: Catalog Keynvarchar330
14N1BCHRESOBSOLETE2BCHIDBasic Catalog: Catalog Keynvarchar330
15N1BCHSPECOBSOLETE2BCHIDBasic Catalog: Catalog Keynvarchar330
16N1BCHTBasic Cat.: Catalog Header - Texts3BCHIDBasic Catalog: Catalog Keynvarchar330
17N1BCHTARGOBSOLETE2BCHIDBasic Catalog: Catalog Keynvarchar330
18N1BCIMPBasic Cat.: Import3BCHIDBasic Catalog: Catalog Keynvarchar330
19N1BCIMPCFGBasic Cat.: Import Configuration3BCHIDBasic Catalog: Catalog Keynvarchar330
20N1BCIMPFPOSKEYBasic Cat.: Import - External Item Key5BCHIDBasic Catalog: Catalog Keynvarchar330
21N1BCPBasic Cat.: Catalog Item2BCHIDBasic Catalog: Catalog Keynvarchar330
22N1BCP2DIAGBasic Cat.: Catalog Item to Diagnosis Assignment2BCHIDBasic Catalog: Catalog Keynvarchar330
23N1BCP2HIERBasic Cat.: Catalog Item to Hierarchy Assignment2BCHIDBasic Catalog: Catalog Keynvarchar330
24N1BCP2MATBasic Cat.: Catalog Item to Material Assignment2BCHIDBasic Catalog: Catalog Keynvarchar330
25N1BCP2NTPKBasic Cat.: Catalog Item to Service Assignment2BCHIDBasic Catalog: Catalog Keynvarchar330
26N1BCP2RCBasic Cat.: Item - Display Configuration Assignment2BCHIDBasic Catalog: Catalog Keynvarchar330
27N1BCP2TASKBasic Cat.: Catalo Item to Task Assignment2BCHIDBasic Catalog: Catalog Keynvarchar330
28N1BCP2URLBasic Cat.: Catalog Item to URL Assignment2BCHIDBasic Catalog: Catalog Keynvarchar330
29N1BCPINTVBasic Cat.: Additional Item Data Procedure Catalog2BCHIDBasic Catalog: Catalog Keynvarchar330
30N1BCPLDOBSOLETE4BCHIDBasic Catalog: Catalog Keynvarchar330
31N1BCPMATBasic Cat.: Additional Item Data Material Catalog2BCHIDBasic Catalog: Catalog Keynvarchar330
32N1BCPPROBBasic Cat.: Additional Item Data Health Problem Catalog2BCHIDBasic Catalog: Catalog Keynvarchar330
33N1BCPTBasic Cat.: Catalog Item - Texts3BCHIDBasic Catalog: Catalog Keynvarchar330
34N1BCPTARGBasic Cat.: Additional Item Data - Goal Catalog2BCHIDBasic Catalog: Catalog Keynvarchar330
35N1BCRCBasic Cat.: Display Configuration2BCHIDBasic Catalog: Catalog Keynvarchar330
36N1BCRCTBasic Cat.: Display Configuration Texts3BCHIDBasic Catalog: Catalog Keynvarchar330
37N1BCRGBasic Cat.: Display Group2BCHIDBasic Catalog: Catalog Keynvarchar330
38N1BCRGTBasic Cat.: Display Group Texts3BCHIDBasic Catalog: Catalog Keynvarchar330
39N1BCSEOBSOLETE: Basic Cat.: Basic Catalog Set Entry6BCHIDBasic Catalog: Catalog Keynvarchar330
40N1BCSEPOBSOLETE: Basic Cat.: Basic Catalog Set Entry Property6BCHIDBasic Catalog: Catalog Keynvarchar330
41N1BCSMCBasic Catalog Set: Main Catalog6BCHIDBasic Catalog: Catalog Keynvarchar330
42N1BCSPCBasic Catalog Set: Property Catalog6BCHIDBasic Catalog: Catalog Keynvarchar330
43N1BCSPECBasic Cat.: Range2BCHIDBasic Catalog: Catalog Keynvarchar330
44N1BCSPEC2BCPBasic Cat.: Range to Catalog Item Assignment2BCHIDBasic Catalog: Catalog Keynvarchar330
45N1BCSPEC2EBCPBasic Cat.: Range to Excluded Catalog Item Assignment2BCHIDBasic Catalog: Catalog Keynvarchar330
46N1BCSPEC2OUBasic Cat.: Range to OU Assignment2BCHIDBasic Catalog: Catalog Keynvarchar330
47N1BCSPECTBasic Cat.: Range Texts3BCHIDBasic Catalog: Catalog Keynvarchar330
48N1BCUFAVHBasic Cat.: User-Specific Favorites - Header Data5BCHIDBasic Catalog: Catalog Keynvarchar330
49N1SRVServices: Service Data8BCHIDBasic Catalog: Catalog Keynvarchar330
50N1SRVPROPNursing Services: Service Properties5BCHIDBasic Catalog: Catalog Keynvarchar330
51N2AD_ALLERGYAllergy Documentation - Allergies4BCHIDBasic Catalog: Catalog Keynvarchar330
52N2BCPADAdditional Data Items - Catalog Category - Allergies2BCHIDBasic Catalog: Catalog Keynvarchar330
53N2BCPCLIFAdditional Data Item Catalog Type Fixed Values2BCHIDBasic Catalog: Catalog Keynvarchar330
54N2BCPCLIMAdditional Data Item Catalog Type Clinical Measurements2BCHIDBasic Catalog: Catalog Keynvarchar330
55N2BCPCLIRAdditional Data Item Catalog Type Value Ranges2BCHIDBasic Catalog: Catalog Keynvarchar330
56N2CLIM_PLDVSVital Signs: Definite Planned Measurement (with Time)8BCHIDBasic Catalog: Catalog Keynvarchar330
57N2CLIM_SDLVSVital Signs: Measurement Plan for Patient (Cycles)8BCHIDBasic Catalog: Catalog Keynvarchar330
58N2CLIM_VALVSVital Signs: Measured Values8BCHIDBasic Catalog: Catalog Keynvarchar330
59TN2CLIM_COMP_OUCLIM: Measurement - Entry Element Assignment for OU5BCHIDBasic Catalog: Catalog Keynvarchar330
60TN2CLIM_SPECIFYCLIM: Specify Measurement5BCHIDBasic Catalog: Catalog Keynvarchar330
61TN2CLIM_SPEC_POSCLIM: Specialize Items for Measurement5BCHIDBasic Catalog: Catalog Keynvarchar330
TOPNursing
62N1NRSPENursing Plan: Entry9BCHIDBasic Catalog: Catalog Keynvarchar330
63N1SNP2BCPOBS.: Std. Nrs.Plan: Std. Nrs. Plan to Basic Cat. Item Asgmt4BCHIDBasic Catalog: Catalog Keynvarchar330
64N1SNPEStandard Nursing Plan: Entry8BCHIDBasic Catalog: Catalog Keynvarchar330
65N1SNPH2BCPStnd Nrs. Plan: Stnd Nrs. Plan to Basic Calog Item Asgmt4BCHIDBasic Catalog: Catalog Keynvarchar330