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

101 columns | Print definition?ERP 6.0  | LOTIM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1TN1MCI_COMPComponent Registration12LOTIMDeletion Timenvarchar60
2TN1MCI_PROCCommunication Processes12LOTIMDeletion Timenvarchar60
3TN1MCI_PROPProperties of a Processing Step13LOTIMDeletion Timenvarchar60
4TN1MCI_STEPProcessing Steps of a Communication Process13LOTIMDeletion Timenvarchar60
TOPClinical System
5N1BCEXPCFGBasis Cat.: Export Configuration15LOTIMDeletion Timenvarchar60
6N1BCEXPCFGCPLBasis Cat.: Export Configuration Item Assignment8LOTIMDeletion Timenvarchar60
7N1BCHBasic Cat.: Catalog Header16LOTIMDeletion Timenvarchar60
8N1BCH2OUOBSOLETE14LOTIMDeletion Timenvarchar60
9N1BCH2ROLEOBSOLETE13LOTIMDeletion Timenvarchar60
10N1BCH2USEROBSOLETE13LOTIMDeletion Timenvarchar60
11N1BCHLDBasic Cat.: Catalog Assignment Definition16LOTIMDeletion Timenvarchar60
12N1BCIMPCFGBasic Cat.: Import Configuration22LOTIMDeletion Timenvarchar60
13N1BCIMPCFGCPLBasic Cat.: Import Configuration Item Assignment10LOTIMDeletion Timenvarchar60
14N1BCPBasic Cat.: Catalog Item21LOTIMDeletion Timenvarchar60
15N1BCP2BCPBasic Cat.: Catalog Item to Catalog Item Assignment18LOTIMDeletion Timenvarchar60
16N1BCP2DIAGBasic Cat.: Catalog Item to Diagnosis Assignment15LOTIMDeletion Timenvarchar60
17N1BCP2HIERBasic Cat.: Catalog Item to Hierarchy Assignment15LOTIMDeletion Timenvarchar60
18N1BCP2MATBasic Cat.: Catalog Item to Material Assignment15LOTIMDeletion Timenvarchar60
19N1BCP2NTPKBasic Cat.: Catalog Item to Service Assignment17LOTIMDeletion Timenvarchar60
20N1BCP2RCBasic Cat.: Item - Display Configuration Assignment16LOTIMDeletion Timenvarchar60
21N1BCP2TASKBasic Cat.: Catalo Item to Task Assignment14LOTIMDeletion Timenvarchar60
22N1BCP2URLBasic Cat.: Catalog Item to URL Assignment16LOTIMDeletion Timenvarchar60
23N1BCPLDOBSOLETE16LOTIMDeletion Timenvarchar60
24N1BCRCBasic Cat.: Display Configuration12LOTIMDeletion Timenvarchar60
25N1BCRC2BCSMCBasic Cat.: Display Config. - Main Catalog Assignment17LOTIMDeletion Timenvarchar60
26N1BCRGBasic Cat.: Display Group14LOTIMDeletion Timenvarchar60
27N1BCSOBSOLETE: Basic Cat.: Basic Catalog Set17LOTIMDeletion Timenvarchar60
28N1BCSEOBSOLETE: Basic Cat.: Basic Catalog Set Entry17LOTIMDeletion Timenvarchar60
29N1BCSEPOBSOLETE: Basic Cat.: Basic Catalog Set Entry Property17LOTIMDeletion Timenvarchar60
30N1BCSFBasic Catalog Set: Folder13LOTIMDeletion Timenvarchar60
31N1BCSGOBSOLETE: Basic Cat.: Basic Catalog Set Group14LOTIMDeletion Timenvarchar60
32N1BCSHBasic Catalog Set: Header Data18LOTIMDeletion Timenvarchar60
33N1BCSMCBasic Catalog Set: Main Catalog18LOTIMDeletion Timenvarchar60
34N1BCSPCBasic Catalog Set: Property Catalog17LOTIMDeletion Timenvarchar60
35N1BCSPECBasic Cat.: Range12LOTIMDeletion Timenvarchar60
36N1BCSPEC2BCPBasic Cat.: Range to Catalog Item Assignment15LOTIMDeletion Timenvarchar60
37N1BCSPEC2EBCPBasic Cat.: Range to Excluded Catalog Item Assignment14LOTIMDeletion Timenvarchar60
38N1BCSPEC2OUBasic Cat.: Range to OU Assignment15LOTIMDeletion Timenvarchar60
39N1CORDUNITCORD: Units for Clinical Orders12LOTIMDeletion Timenvarchar60
40N1DCIS-H*MED: Table of Formularies17LOTIMDeletion Timenvarchar60
41N1FOCATREFAi.s.h.med: Medication, ID References for External Catalogs15LOTIMDeletion Timenvarchar60
42N1FOFILLSABi.s.h.med: Medication, Fill Source - Drug Assignment19LOTIMDeletion Timenvarchar60
43N1FOFORMTYPEAi.s.h.med: Medication, Drug - Drug Type Assignment14LOTIMDeletion Timenvarchar60
44N1FOFOTYPEAIS-H*MED: (O B S O L E T E) Usage Type - Drug Assignment13LOTIMDeletion Timenvarchar60
45N1FOTHCLASSAIS-H*MED: Classification Code - Drug Assignment16LOTIMDeletion Timenvarchar60
46N1FSOURCEIS-H*MED: Fill Source17LOTIMDeletion Timenvarchar60
47N1FSOURCEOUAIS-H*MED: Fill Source for OUs Assignment16LOTIMDeletion Timenvarchar60
48N1GPFOAIS-H*MED: Medication, Gener. Drug - Parameter Assignment17LOTIMDeletion Timenvarchar60
49N1MESFOAi.s.h.med: Medication, Drug Messages20LOTIMDeletion Timenvarchar60
50N1PRDOCIS-H*MED: PATREG: Dokumente34LOTIMSilme saatinvarchar60
51N1PRFOAi.s.h.med: Medication, Price - Drug Assignment19LOTIMDeletion Timenvarchar60
52N1SPMLAYOUT_DISi.s.h.med: Table for Display Parameters24LOTIMDeletion Timenvarchar60
53N1TMSTPi.s.h.med: Table for Time Stamps13LOTIMDeletion Timenvarchar60
54N1TMSTPDURDEFi.s.h.med: Duration Definition of Time Stamps19LOTIMDeletion Timenvarchar60
55NAGENTIS-H*MED: Agents of Drugs19LOTIMDeletion Timenvarchar60
56NDOCAIS-H*MED: Document Management Data for Archived Documents42LOTIMDeletion Timenvarchar60
57NDOCSTORNOIS-H*MED: Canceled Documents43LOTIMDeletion Timenvarchar60
58TN1AGTYPEi.s.h.med: Medication, Agent Types of Drugs12LOTIMDeletion Timenvarchar60
59TN1CCPROVi.s.h.med: Medication, External Provider Medication Checks15LOTIMDeletion Timenvarchar60
60TN1DEVICEMedication: Administration Devices14LOTIMDeletion Timenvarchar60
61TN1FORMLEVELi.s.h.med: Medication, Drug Levels22LOTIMDeletion Timenvarchar60
62TN1FORMPi.s.h.med: Medication, Generic Drug Parameters12LOTIMDeletion Timenvarchar60
63TN1FORMTYPEIS-H*MED: Drug Types14LOTIMDeletion Timenvarchar60
64TN1LINTYPIS-H*MED: Line Type13LOTIMDeletion Timenvarchar60
65TN1MEALHANDi.s.h.med: Medication - Alert Processing18LOTIMDeletion Timenvarchar60
66TN1MECCGEPAi.s.h.med: Medication Transfer Parameters19LOTIMDeletion Timenvarchar60
67TN1MECCTSi.s.h.med: Medication Time Spans19LOTIMDeletion Timenvarchar60
68TN1MECHARTGRPMedication: Customizable Grouping Types14LOTIMDeletion Timenvarchar60
69TN1MECHTYPEi.s.h.med: Medication Check Type26LOTIMDeletion Timenvarchar60
70TN1MEDCLASSIS-H*MED: Medication Classes - OBSOLETE12LOTIMDeletion Timenvarchar60
71TN1MEDGROUPIS-H*MED: Medication Groups14LOTIMDeletion Timenvarchar60
72TN1MELOCIS-H*MED: Localization for Medication13LOTIMDeletion Timenvarchar60
73TN1MESEVLEVi.s.h.med: Severity for Medication Alerts16LOTIMDeletion Timenvarchar60
74TN1MSGGROUPi.s.h.med: Medication, Groups of Drug Messages12LOTIMDeletion Timenvarchar60
75TN1PHFORMMedication: Dosage Form15LOTIMDeletion Timenvarchar60
76TN1PRICETYPi.s.h.med: Medication, Price Types for Drug12LOTIMDeletion Timenvarchar60
77TN1RCINDMedication: Reason Code (Institution-Independent)13LOTIMDeletion Timenvarchar60
78TN1RCODEIS-H*MED: Reason Code20LOTIMDeletion Timenvarchar60
79TN1ROUTEMedication: Administration Routes14LOTIMDeletion Timenvarchar60
80TN1SIGNSi.s.h.med: Patient Record, Indicators12LOTIMDeletion Timenvarchar60
81TNTHCLASSMedication: Classification Codes16LOTIMDeletion Timenvarchar60
TOPContract Accounts Receivable and Payable
82DFKKCRDELCR: Deleted Payment Medium / Basic Data10LOTIMSystem Timenvarchar60
83DFKKCRDEL2PCR: Deleted Payment Medium / Payee Data11LOTIMSystem Timenvarchar60
84DFKKCRDELADDCR: Deleted Payment Medium / Additional Data10LOTIMSystem Timenvarchar60
85DFKKCRDELD2Check Register: Deleted Payment Media/Partial Encashments11LOTIMSystem Timenvarchar60
86DFKKCRDELESCHCheck Register: Escheatment Data10LOTIMSystem Timenvarchar60
87DFKKCRDELESCHACheck Register: Escheatment Data: Correspondence5LOTIMSystem Timenvarchar60
TOPDocuments
88N1IM_IMAGESingle Image Within Image Study22LOTIMDeletion Timenvarchar60
89N1IM_STUDYMeta Data of Image Study24LOTIMDeletion Timenvarchar60
TOPNursing
90N1NRSPKMSNursing Plan: NCPS Classifications20LOTIMDeletion Timenvarchar60
91N1SNPOBSOLETE - Std.Nurs.Plan: Std.Nurs.Plan Header Data19LOTIMDeletion Timenvarchar60
92N1SNP2BCPOBS.: Std. Nrs.Plan: Std. Nrs. Plan to Basic Cat. Item Asgmt15LOTIMDeletion Timenvarchar60
93N1SNP2SNPOBSOLETE: Std. Nrs. Plan: Std. Nrs. Plan to Std. Nrs. Plan15LOTIMDeletion Timenvarchar60
94N1SNPEStandard Nursing Plan: Entry20LOTIMDeletion Timenvarchar60
95N1SNPHStd.Nurs.Plan: Header Data20LOTIMDeletion Timenvarchar60
96N1SNPH2BCPStnd Nrs. Plan: Stnd Nrs. Plan to Basic Calog Item Asgmt16LOTIMDeletion Timenvarchar60
97N1SNPH2OUStnd Nrs. Plan: Standard Nursing Plan to OU Assignment15LOTIMDeletion Timenvarchar60
98N1SNPH2SNPHStd.Nurs.Plan: Std.Nurs.Plan to Std.Nurs.Plan15LOTIMDeletion Timenvarchar60
99N1SNPPOBSOLETE - Std. Nrs. Plan: Std. Nrs. Plan Item16LOTIMDeletion Timenvarchar60
TOPPatient Management
100NDOCIS-H: Assignment of IS-H Objects to Documents in DMS42LOTIMDeletion Timenvarchar60
TOPSAP Healthcare - Industry-Specific Components for Hospitals
101N2BASEITEMBase Items: Base Item22LOTIMDeletion Timenvarchar60