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

36 columns | Print definition?ERP 6.0  | INSTA

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1P05EIR_MSG_TYPEElectronic Illness Reporting: Status Table Administration6INSTAExternal Agencynvarchar40
2PA3266HR master record, infotype 326640INSTAInstitution's statistical codenvarchar170
3PA3531HR Master Record: Infotype 353133INSTAEvaluation Panelnvarchar40
4PB3531Applicant data infotype 3531 (model)33INSTAEvaluation Panelnvarchar40
5T5H81TRegistered employment relationships (multiple employer)30INSTAInstitution's statistical codenvarchar170
6T5H82TRegistered employment relationships (multiple employer)30INSTAInstitution's statistical codenvarchar170
7T7CNAFEvaluation Panel3INSTAEvaluation Panelnvarchar40
8T7CNAFTText of Evaluation Panel4INSTAEvaluation Panelnvarchar40
TOPBasic Functions
9TINSOFailed Payment Transactions and Charges16INSTAProcessing statusnvarchar10
TOPNetherlands
10P05EIR_MSG_ADMElectronic Illness Reporting: Status Administration12INSTAExternal Agencynvarchar40
11T5N9IExternal Agencies2INSTAExternal Agencynvarchar40
12T5N9JText: External Agencies3INSTAExternal Agencynvarchar40
13T5N9RRelationship Repr. Legal Person and External Agencies3INSTAExternal Agencynvarchar40
TOPPayroll
14T7BGA2Changes of external transfers (IT11)5INSTAInstallment of the loandecimal152
15T7ROA5Changes of external transfers (IT11)5INSTAInstallment of the loandecimal152
TOPPension fund Netherlands
16T5NH2Externe instanties werkgever3INSTAExterne instantie werkgevernvarchar40
17T5NH2TOmschrijving externe instanties werkgever4INSTAExterne instantie werkgevernvarchar40
18T5NH3Relatie werkgever en externe instanties5INSTAExterne instantie werkgevernvarchar40
TOPSAP Note Assistant
19CWBCICATTRAttributes set by customer for correction instructions1INSTACorrection instructions creation system (installation no.)nvarchar100
20CWBCICONFIRMLOCCorrection Instruction: Confirmation Non-Transportable Act.1INSTACorrection instructions creation system (installation no.)nvarchar100
21CWBCIDATACompressed data on correction instructions2INSTACorrection instructions creation system (installation no.)nvarchar100
22CWBCIDATAOBJCompressed data on correction instructions2INSTACorrection instructions creation system (installation no.)nvarchar100
23CWBCIDPNDCDependencies of correction instructions1INSTACorrection instructions creation system (installation no.)nvarchar100
24CWBCIFIXEDDelivery event processed correction instructions1INSTACorrection instructions creation system (installation no.)nvarchar100
25CWBCIHEADHeader data for correction instructions1INSTACorrection instructions creation system (installation no.)nvarchar100
26CWBCIINVLDRelease interval for which corr. instructions are invalid1INSTACorrection instructions creation system (installation no.)nvarchar100
27CWBCIOBJObject list of correction instructions with TADIR key1INSTACorrection instructions creation system (installation no.)nvarchar100
28CWBCIVALIDValidity table for correction instructions1INSTACorrection instructions creation system (installation no.)nvarchar100
29CWBNTHEADHeader table for OSS Notes in customer systems4INSTACreation system of Note (installation number)nvarchar100
30CWB_HIST_HCorrection Workbench: History Header5INSTAnvarchar100
31SCWBINDXVSDummy Table for Packing Data2INSTACorrection instructions creation system (installation no.)nvarchar100
32SCWB_HISTHistory of Delta Copies in the Correction Workbench8INSTAnvarchar100
TOPService Data Download
33/SDF/CMO_CWBNTHECMO Service: Header Table for Notes in Customer Systems4INSTAnvarchar100
34/SDF/CMO_T_25SAP Notes list for DEV4INSTAnvarchar100
35/SDF/CMO_T_26SAP Notes list for QAS4INSTAnvarchar100
36/SDF/CMO_T_27SAP Notes list for PRD4INSTAnvarchar100