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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

39 columns | Print definition?ERP 6.0  | BCPID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPClinical System
1N1BCIMPFPOSKEYBasic Cat.: Import - External Item Key6BCPIDBasic Cat.: Item Keynvarchar330
2N1BCPBasic Cat.: Catalog Item3BCPIDBasic Cat.: Item Keynvarchar330
3N1BCP2DIAGBasic Cat.: Catalog Item to Diagnosis Assignment3BCPIDBasic Cat.: Item Keynvarchar330
4N1BCP2MATBasic Cat.: Catalog Item to Material Assignment3BCPIDBasic Cat.: Item Keynvarchar330
5N1BCP2NTPKBasic Cat.: Catalog Item to Service Assignment3BCPIDBasic Cat.: Item Keynvarchar330
6N1BCP2RCBasic Cat.: Item - Display Configuration Assignment4BCPIDBasic Cat.: Item Keynvarchar330
7N1BCP2TASKBasic Cat.: Catalo Item to Task Assignment3BCPIDBasic Cat.: Item Keynvarchar330
8N1BCP2URLBasic Cat.: Catalog Item to URL Assignment3BCPIDBasic Cat.: Item Keynvarchar330
9N1BCPBADIOBSOLET2BCPIDBasiskat.: Positionsschlüsselnvarchar330
10N1BCPCOMOBSOLETE2BCPIDBasic Cat.: Item Keynvarchar330
11N1BCPDIAGOBSOLETE2BCPIDBasic Cat.: Item Keynvarchar330
12N1BCPINTVBasic Cat.: Additional Item Data Procedure Catalog3BCPIDBasic Cat.: Item Keynvarchar330
13N1BCPLDOBSOLETE5BCPIDBasic Cat.: Item Keynvarchar330
14N1BCPMATBasic Cat.: Additional Item Data Material Catalog3BCPIDBasic Cat.: Item Keynvarchar330
15N1BCPPROBBasic Cat.: Additional Item Data Health Problem Catalog3BCPIDBasic Cat.: Item Keynvarchar330
16N1BCPRESOBSOLETE2BCPIDBasic Cat.: Item Keynvarchar330
17N1BCPTBasic Cat.: Catalog Item - Texts4BCPIDBasic Cat.: Item Keynvarchar330
18N1BCPTARGBasic Cat.: Additional Item Data - Goal Catalog3BCPIDBasic Cat.: Item Keynvarchar330
19N1BCSPEC2BCPBasic Cat.: Range to Catalog Item Assignment5BCPIDBasic Cat.: Item Keynvarchar330
20N1BCSPEC2EBCPBasic Cat.: Range to Excluded Catalog Item Assignment5BCPIDBasic Cat.: Item Keynvarchar330
21N1BCUFAVPBasic Cat.: User-Specific Favorites - Items4BCPIDBasic Cat.: Item Keynvarchar330
22N1SRVServices: Service Data9BCPIDBasic Cat.: Item Keynvarchar330
23N1SRVPROPNursing Services: Service Properties6BCPIDBasic Cat.: Item Keynvarchar330
24N2AD_ALLERGYAllergy Documentation - Allergies5BCPIDBasic Cat.: Item Keynvarchar330
25N2BCPADAdditional Data Items - Catalog Category - Allergies3BCPIDBasic Cat.: Item Keynvarchar330
26N2BCPCLIFAdditional Data Item Catalog Type Fixed Values3BCPIDBasic Cat.: Item Keynvarchar330
27N2BCPCLIMAdditional Data Item Catalog Type Clinical Measurements3BCPIDBasic Cat.: Item Keynvarchar330
28N2BCPCLIRAdditional Data Item Catalog Type Value Ranges3BCPIDBasic Cat.: Item Keynvarchar330
29N2CLIM_PLDVSVital Signs: Definite Planned Measurement (with Time)9BCPIDBasic Cat.: Item Keynvarchar330
30N2CLIM_SDLVSVital Signs: Measurement Plan for Patient (Cycles)9BCPIDBasic Cat.: Item Keynvarchar330
31N2CLIM_VALVSVital Signs: Measured Values9BCPIDBasic Cat.: Item Keynvarchar330
32TN2CLIM_COMP_OUCLIM: Measurement - Entry Element Assignment for OU6BCPIDBasic Cat.: Item Keynvarchar330
33TN2CLIM_SPECIFYCLIM: Specify Measurement6BCPIDBasic Cat.: Item Keynvarchar330
34TN2CLIM_SPEC_POSCLIM: Specialize Items for Measurement6BCPIDBasic Cat.: Item Keynvarchar330
TOPNursing
35N1NRSPENursing Plan: Entry10BCPIDBasic Cat.: Item Keynvarchar330
36N1SNP2BCPOBS.: Std. Nrs.Plan: Std. Nrs. Plan to Basic Cat. Item Asgmt5BCPIDBasic Cat.: Item Keynvarchar330
37N1SNPEStandard Nursing Plan: Entry9BCPIDBasic Cat.: Item Keynvarchar330
38N1SNPH2BCPStnd Nrs. Plan: Stnd Nrs. Plan to Basic Calog Item Asgmt5BCPIDBasic Cat.: Item Keynvarchar330
39N1SNPPOBSOLETE - Std. Nrs. Plan: Std. Nrs. Plan Item5BCPIDBasic Cat.: Item Keynvarchar330