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

38 columns | Print definition?ERP 6.0  | KATID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1NNLFYSIO_VORLAGEOBSOLETE9KATIDIS-H: Katalogidentifikationnvarchar20
2NNL_FYSIOTabelle Physiotherapie13KATIDIS-H: Katalogidentifikationnvarchar20
TOPBasic Data
3NLSUIS-H: Totals File for Service Statistics3KATIDIS-H: Service Catalog Identification Keynvarchar20
4TNK00IS-H: Diagnosis Coding Catalog Categories2KATIDIS-H: Catalog Identificationnvarchar20
5TNK01IS-H: Service Catalog Types3KATIDIS-H: Service Catalog Identification Keynvarchar20
6TNS24IS-H: Log File for Totals Records File Services3KATIDIS-H: Service Catalog Identification Keynvarchar20
TOPClinical System
7N1DFOIS-H*MED: Dispensing Form4KATIDIdentification of a Medication Catalognvarchar100
8N1DFOTIS-H*MED: Dispensing Form/Language-Dependent Text5KATIDIdentification of a Medication Catalognvarchar100
9N1DYLMZUOIS-H*MED: Dynamic material proposal4KATIDIS-H MM: Identification of a Material Catalognvarchar80
10N1MEDOBSOLETE: Patient-Related Medication Data for a Prescription5KATIDIdentification of a Medication Catalognvarchar100
11N1MEKIS-H*MED: Master Data Medications - Catalogs3KATIDIdentification of a Medication Catalognvarchar100
12N1MEKTIS-H*MED: Master Data Medications - Catalog/Lang-Dep. Text4KATIDIdentification of a Medication Catalognvarchar100
13N1MEOEZIS-H*MED: Medication - OU Assignment3KATIDIdentification of a Medication Catalognvarchar100
14N1MEPOBSOLETE: Master Data Medication - Catalog Positions3KATIDIdentification of a Medication Catalognvarchar100
15N1MEPSTFZIS-H*MED: Medication - Substance Assignment5KATIDIdentification of a Medication Catalognvarchar100
16N1MEPTOBSOLETE: Master Data Medication - Cat.Pos./Lang.-Dep. T.4KATIDIdentification of a Medication Catalognvarchar100
17N1MLZUOIS-H*MED: Service-related material proposal7KATIDIS-H MM: Identification of a Material Catalognvarchar80
18N1POPAKTEIS-H*Med: Patient Organizer - Redundant Structure61KATIDHealth Problems Catalognvarchar400
19N1STFIS-H*MED: Master Data of Medication Substances4KATIDIdentification of a Medication Catalognvarchar100
20N1STFTYPIS-H*MED: Substance Types4KATIDIdentification of a Medication Catalognvarchar100
21TN2DKATID2EXTIDIS-H*MED: Diagnosis Catalog Types TNK00 by External Version2KATIDIS-H: Catalog Identificationnvarchar20
22TN2K0IS-H*MED: Nursing catalog categories2KATIDIdentification of a Basic Catalognvarchar20
23TN2K1IS-H*MED: Nursing standard catalog categories2KATIDIdentification of Standardized Nursing Plan Catalognvarchar20
24TN2K2IS-H*MED: Classification area catalog categories2KATIDIdentification of the Classification Area Catalognvarchar20
25TN2K3IS-H*MED: Service catalog - classification catalog asgmt3KATIDIS-H: Service Catalog Identification Keynvarchar20
26TN2PKATID2EXTIDIS-H*MED: Service Catalog TNK01 by External Version3KATIDIS-H: Identification of Surgical Procedure Coding Catalognvarchar20
TOPMedical Patient Data Organization Patient Organizer
27N1STRUCMEDRECIS-H*MED: Health Problems (Struct. Med. Patient Record)6KATIDHealth Problems Catalognvarchar400
28N1STRUCMEDRECCATIS-H*MED: Health Problems Catalog2KATIDHealth Problems Catalognvarchar400
TOPPatient Accounting
29NLAZIS-H: Assign IS-H Service to CO Activity Type3KATIDIS-H: Service Catalog Identification Keynvarchar20
30NMHITIS-H MM: Material-OU hit list2KATIDIS-H MM: Identification of a Material Catalognvarchar80
31NMKAOIS-H MM: Assignment of Material Catalog to OU3KATIDIS-H MM: Identification of a Material Catalognvarchar80
32NMKAPIS-H MM: Material catalog items2KATIDIS-H MM: Identification of a Material Catalognvarchar80
33NMKATIS-H MM: Material catalogs2KATIDIS-H MM: Identification of a Material Catalognvarchar80
34NMKATTIS-H MM: Material catalogs3KATIDIS-H MM: Identification of a Material Catalognvarchar80
35TNDRGIS-H: DRG Billing Parameters11KATIDIS-H: Service Catalog Identification Keynvarchar20
TOPSAP Healthcare - Industry-Specific Components for Hospitals
36NLVERZF_007Konversion Diagnose SAP nach Diagnose VEKTIS3KATIDIS-H: Catalogusidentificatienvarchar20
37NLVERZF_008Konversion Diagnose SAP nach Diagnose VEKTIS 23KATIDIS-H: Catalogusidentificatienvarchar20
38TNWCHDRGIS-H CH: DRG-Abrechnungsparameter6KATIDIS-H: identificatore di un catalogo di prestazioninvarchar20