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

23 columns | Print definition?ERP 6.0  | DEVICEID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPClinical System
1N2DDEVICEIS-H*MED RAD: Description of the modality, workstation2DEVICEIDCodes of the modality, of the devicenvarchar100
2N2DPREFETCHIS-H*MED RAD: Prefetch rule10DEVICEIDCodes of the modality, of the devicenvarchar100
3N2DSERIESIS-H*MED RAD: Description of a DICOM image series8DEVICEIDCodes of the modality, of the devicenvarchar100
4N2DWORKLISTIS-H*MED RAD: Work list (RIS - PACS work list)5DEVICEIDCodes of the modality, of the devicenvarchar100
5N2RADWLIS-H*MED: Radiology Worklist7DEVICEIDRAD: Scheduled Station AE Titlenvarchar160
6N2RADWL1IS-H*MED: Modality Worklist (extended structure)7DEVICEIDRAD: Scheduled Station AE Titlenvarchar160
7N2RADWLEXTIS-H*MED: Radiological Worklist for Optional Attributes7DEVICEIDRAD: Scheduled Station AE Titlenvarchar160
TOPConfiguration management
8IBSPCMIB: Config.Mang.: Specialization17DEVICEIDIB: Identificationnvarchar400
TOPDSD Connector
9/DSD/ME_CPT_CHANDSD CN: Channel8DEVICEIDDSD Connector: Unique Identification Number of the HHnvarchar320
TOPInstalled Base
10IBSPIB: Installed Base Component - Enhancement/Specialization17DEVICEIDIB: Identificationnvarchar400
TOPMaintenance History
11HIKOOrder master data history71DEVICEIDAdditional Device Datanvarchar400
TOPMaintenance Notifications
12QMELQuality Notification100DEVICEIDAdditional Device Datanvarchar400
TOPMaintenance Orders
13AFIHMaintenance order header41DEVICEIDAdditional Device Datanvarchar400
TOPMaintenance Task Lists
14MPOSMaintenance item53DEVICEIDAdditional Device Datanvarchar400
TOPMobile Applications
15/ISDFPS/MECAA010Local Authorization (Item) for Logging16DEVICEIDUnique ID of Synchronization Containernvarchar360
16/ISDFPS/MECAAUTHLocal Authorization (Header) for Logging2DEVICEIDUnique ID of Synchronization Containernvarchar360
17/ISDFPS/ME_NRBuffer Table for Mobile Numbers from Number Ranges7DEVICEIDDevice IDnvarchar320
TOPSAP NetWeaver Mobile - Use subcomponents
18INST_IMG_MAPPINGMapping for Installation Toolkit, TempID / DeviceID2DEVICEIDUnique ID of Devicenvarchar360
19MICONFIGINFOMI Client Configuration Files2DEVICEIDUnique ID of Synchronization Containernvarchar360
20MICONFIGINFO_UDevice IDs to Send Configuration Information with Next Sync2DEVICEIDUnique ID of Synchronization Containernvarchar360
21MIPACKAGE_HEADPackagegeneration header4DEVICEIDUnique ID of Synchronization Containernvarchar360
22MISYNDEVMI System News Delivered Messages2DEVICEIDUnique ID of Synchronization Containernvarchar360
TOPSimulation
23VSAFIH_CNVersion: Order header for plant maintenance42DEVICEIDAdditional Device Datanvarchar400