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

68 columns | Print definition?ERP 6.0  | DTID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1N1PMD_MGENMass Generation PMD Background Jobs3DTIDDocument Category IDnvarchar100
2TN1DOC_ARCSettings for Archiving of Document Categories3DTIDDocument Category IDnvarchar100
TOPClinical System
3N1ANFTYPIS-H*MED: Request Type8DTIDDocument Category IDnvarchar100
4N1EDIVKADOKSTATDokumentenversand Edivka3DTIDIdent des Dokumenttypsnvarchar100
5N1POPAKTEIS-H*Med: Patient Organizer - Redundant Structure23DTIDDocument Category IDnvarchar100
6N1PRDOCIS-H*MED: PATREG: Dokumente17DTIDDoküman tipi taniticisinvarchar100
7N1ROUTINGSPOOLIS-H*MED: Routing Tasks8DTIDDocument Category IDnvarchar100
8N1VORBDOKELIS-H*MED: Defaults for the doc. elements3DTIDDocument Category IDnvarchar100
9N2DI_PMD_LCUSTSettings for Dictation Interface Link Element3DTIDDocument Category IDnvarchar100
10N2DLIS-H*MED: Table of doc. category to service assignments5DTIDDocument Category IDnvarchar100
11N2DOIS-H*MED: Table of doc. category to org. unit assignments4DTIDDocument Category IDnvarchar100
12N2DOCCOMPIS-H*MED: Documentation Components8DTIDDocument Category IDnvarchar100
13N2DOCREFCASEIS-H*MED: Empty Table for Lock Object Case Reference Level3DTIDDocument Category IDnvarchar100
14N2DOCREFMOVEIS-H*MED: Empty Table for Lock Object Movement Ref. Level3DTIDDocument Category IDnvarchar100
15N2DOCREFPATIS-H*MED: Empty Table for Lock Object Patient Ref. Level3DTIDDocument Category IDnvarchar100
16N2DOCREFSERVIS-H*MED: Empty Table for Lock Object Service Ref. Level3DTIDDocument Category IDnvarchar100
17N2DOCTEMPLATEIS-H*MED: Templates for Documents4DTIDDocument Category IDnvarchar100
18N2DTAPPLFORMATDocument Category: Special Format of Action3DTIDDocument Category IDnvarchar100
19N2DTAPPLPDFi.s.h.med: Table of Document Categories PDF Application4DTIDDocument Category IDnvarchar100
20N2DTAPPLXMLi.s.h.med: Table of XML Application Document Categories4DTIDDocument Category IDnvarchar100
21N2DTAPPL_ADOBEDocumen Category: ADOBE Form Data3DTIDDocument Category IDnvarchar100
22N2DTAPPL_PDFi.s.h.med: Table of Document Categories PDF Application3DTIDDocument Category IDnvarchar100
23N2DTAPPL_XMLi.s.h.med: Table of Document Categories XML Application3DTIDDocument Category IDnvarchar100
24N2DTDTAIS-H*MED: Table of Documentation Categs. for Desktop Appl.4DTIDDocument Category IDnvarchar100
25N2DTPART2IS-H*MED: PMD DocCat-Header (n2dt) 2nd Part3DTIDDocument Category IDnvarchar100
26N2DTPART3PMD: Part 3 of Doc. Categ. Table3DTIDDocument Category IDnvarchar100
27N2DTTIS-H*MED: Text table for the document category4DTIDDocument Category IDnvarchar100
28N2DTWORDIS-H*MED: Table of Word application document categories4DTIDDocument Category IDnvarchar100
29N2DT_HTML_TMPLIS-H*MED: DocCateg. addition HTML template4DTIDDocument Category IDnvarchar100
30N2DT_SETSDocument Categories to SET ID Assignment Table3DTIDDocument Category IDnvarchar100
31N2ETIS-H*MED: Table of docElement to DocCategory assignments3DTIDDocument Category IDnvarchar100
32N2ET2PMD: Definite Elements (Part 2)3DTIDDocument Category IDnvarchar100
33N2ETTIS-H*MED: Texts for document category assignments (N2ET)4DTIDDocument Category IDnvarchar100
34N2EXTENDPCIS-H*MED: Customizing Word Container Param. Documents3DTIDDocument Category IDnvarchar100
35N2GL_BASE_DOCIS-H*MED: Base Item Document12DTIDDocument Category IDnvarchar100
36N2LINKCUSTPMD: Customizing for Link Modules3DTIDDocument Category IDnvarchar100
37N2MIDEFIS-H*MED: Definitions for MedImage coupling3DTIDDocument Category IDnvarchar100
38N2MV_VSVORPresetting Control Table3DTIDDocument Category IDnvarchar100
39N2PMDALV_LCUSTISHMED: Settings for Link Element ALV Grid Viewer (PMD)3DTIDDocument Category IDnvarchar100
40N2PMDBTF_LCUSTIS-H*MED: Settings for Link Element BTF Editor (PMD)3DTIDDocument Category IDnvarchar100
41N2PMDDOCV_LCUSTIS-H*MED: Settings for Link Element Document Viewer3DTIDDocument Category IDnvarchar100
42N2PMDHTML_LCUSTIS-H*MED: Link Element HTML Viewer (PMD) Settings3DTIDDocument Category IDnvarchar100
43N2PMDPVB_LCUSTIS-H*MED: Link Element HTML Viewer (PMD) Settings3DTIDDocument Category IDnvarchar100
44N2PMDRLF4_LCUSTIS-H*MED: Link Element HTML Viewer (PMD) Settings3DTIDDocument Category IDnvarchar100
45N2XMLFILESIS-H*MED: XML File Management4DTIDDocument Category IDnvarchar100
46NDOCAIS-H*MED: Document Management Data for Archived Documents25DTIDDocument Category IDnvarchar100
47NDOCSTORNOIS-H*MED: Canceled Documents26DTIDDocument Category IDnvarchar100
48TN1MEPRSCFORMIS-H*MED: Prescription Print Forms4DTIDDocument Category IDnvarchar100
49TN1ROUTINGIS-H*MED: Routing Rules3DTIDDocument Category IDnvarchar100
50TN2CA_CORD_DTIDAssignment Long Text Fields of Prefindings to CORD5DTIDDocument Category IDnvarchar100
51TN2COM_DOCFORMATDocument Category Settings for Document Dispatch4DTIDDocument Category IDnvarchar100
52TN2COM_DOCTYPMAPImage of Relationship Between Internal & External Doc. Categ6DTIDDocument Category IDnvarchar100
53TN2DEVDOC_ACTInterface - Document Assignment dep. on OK Code3DTIDDocument Category IDnvarchar100
54TN2DEVDOC_CUSTInterface Fields - Document Assignment4DTIDDocument Category IDnvarchar100
55TN2DI_TEXTKEYAssignment of Keywords to Text Fields3DTIDDocument Category IDnvarchar100
56TN2DOCEXE_CUSTPMD Customizing for Branch to File Processing3DTIDDocument Category IDnvarchar100
57TN2FO_APPLXSLFO: DocCateg. Use (XSLPROGRAM Is Language-Dependent)4DTIDDocument Category IDnvarchar100
58TN2GENDIADiagnoses for Document Content3DTIDDocument Category IDnvarchar100
59TN2STATUS_SWITCHDocuments: Control of Status Change3DTIDDocument Category IDnvarchar100
TOPDocuments
60TN1IM_CFGConfiguration Settings for Image System, General7DTIDDocument Category IDnvarchar100
61TN1IM_IMAGIC_CFGConfiguration Settings for Imagic Client7DTIDDocument Category IDnvarchar100
62TN1IM_LCUSTSettings for Link Module of Image Integration3DTIDDocument Category IDnvarchar100
TOPPatient Management
63N1CORDTYPAIS-H: Clinical Order Type - Order Type Structure10DTIDDocument Category IDnvarchar100
64N2DTIS-H*MED: Table of Documentation Categories3DTIDDocument Category IDnvarchar100
65NDOCIS-H: Assignment of IS-H Objects to Documents in DMS25DTIDDocument Category IDnvarchar100
TOPRadiology
66TN1PACSIS-H*MED RAD: PACS Descriptions7DTIDDocument Category IDnvarchar100
TOPSAP Healthcare - Industry-Specific Components for Hospitals
67NLPORTAL_DOCPortal medizinische brief5DTIDIdent des Dokumenttypsnvarchar100
68NLPORTAL_PMDPortal medizinische dokument3DTIDIdent des Dokumenttypsnvarchar100