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

20 columns | Print definition?ERP 6.0  | ITEMNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1FIAPSAD_ADP_LTAdvance Payment Request Line Items Details6ITEMNRCommitment Itemnvarchar140
2MEV_D_AD_ITEMPeriod-End Valuation: Accruals Document Item4ITEMNRPeriod-End Valuation: Document Itemnvarchar60
3CMACDB_FEEFICAFee Calculation Document: FI-CA Documents3ITEMNRItem Numbernvarchar40
4CMACDB_FEESCFee Calculation Document Items (Program)3ITEMNRItem Numbernvarchar40
5CMACDB_FEESMFee Calculation Document Items (Module)3ITEMNRItem Numbernvarchar40
6CMACDB_ITEMRESFee Calculation Line Results3ITEMNRItem Numbernvarchar40
TOPBasic Functions
7ETXDCIExternal tax document: line item info3ITEMNRExternal-tax document item numbernvarchar60
8ETXDCJExt. tax document: tax rates and amounts by Jurisdict. level3ITEMNRExternal-tax document item numbernvarchar60
TOPContract Accounts Receivable and Payable
9DFKKFMBGAINFOTax Information for Public-Owned Commercial Operations3ITEMNR5 Character Numeric NUMCnvarchar50
TOPDownloadUpload
10/DSD/HH_RACOCICIDSD Route Settlement: Check-Out/Check-In - Money Item4ITEMNRDSD - RA: Check-Out / Check-In - Item Numbernvarchar60
11/DSD/HH_RACOCIMIDSD Route Settlement: Check-Out Check-In - Items4ITEMNRDSD - RA: Check-Out / Check-In - Item Numbernvarchar60
TOPKnowledge Base
12ISMITSDB: Symptom Trigger4ITEMNRSDB: Trigger Numbernvarchar40
13ISMITCASDB: Symptom Trigger Cause5ITEMNRSDB: Trigger Numbernvarchar40
14ISMITOPSDB: Symptom Trigger Object Part5ITEMNRSDB: Trigger Numbernvarchar40
15ISMITPRSDB: Symptom Trigger Problem5ITEMNRSDB: Trigger Numbernvarchar40
16ISMITXTSDB: Symptom Trigger Short Text4ITEMNRSDB: Trigger Numbernvarchar40
17ISMOBSDB: Symptom Object table4ITEMNRSDB: Trigger Numbernvarchar40
18ISMSLSDB: Symptom Solution Link table4ITEMNRSDB: Trigger Numbernvarchar40
TOPStock Visibility
19/DSD/SV_RACOCICIDSD SV: Check-Out / Check-In - Money Item4ITEMNRDSD - RA: Check-Out / Check-In - Item Numbernvarchar60
20/DSD/SV_RACOCIMIDSD SV: Check-Out / Check-In - Items4ITEMNRDSD - RA: Check-Out / Check-In - Item Numbernvarchar60