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

33 columns | Print definition?ERP 6.0  | DIMUM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPGlobal Trade Services
1/SAPSLL/BOPHDGTS: General Bill of Product - Header Data13DIMUMUnit of Measurement of a Dimensionnvarchar30
2/SAPSLL/BOPITGTS: General Bill of Product - Item Data15DIMUMUnit of Measurement of a Dimensionnvarchar30
3/SAPSLL/BOPITCONGTS: bill of product: assign licenses to items in BOP9DIMUMUnit of Measurement of a Dimensionnvarchar30
4/SAPSLL/CORDIMLegal & Logistics Services: Dimensions7DIMUMUnit of Measurement of a Dimensionnvarchar30
5/SAPSLL/CUITPREGTS: Customs Document: Item: Preference Data13DIMUMUnit of Measurement of a Dimensionnvarchar30
6/SAPSLL/ITARAUDITAR Tracking: Log - Header Data11DIMUMUnit of Measurement of a Dimensionnvarchar30
7/SAPSLL/ITARAUDDITAR Tracking: Log - Item Data7DIMUMUnit of Measurement of a Dimensionnvarchar30
8/SAPSLL/LCLICAQLegal Control: License: Available Quantity7DIMUMUnit of Measurement of a Dimensionnvarchar30
9/SAPSLL/LCLICAQLLicense: Change Log: Available Quantity11DIMUMUnit of Measurement of a Dimensionnvarchar30
10/SAPSLL/LCLICCQLegal Control: License - Quantities per Component7DIMUMUnit of Measurement of a Dimensionnvarchar30
11/SAPSLL/LCLICCQULicense - Quantities Taken per Component7DIMUMUnit of Measurement of a Dimensionnvarchar30
12/SAPSLL/LCLICESLL: Legal Control: License - Restitution5DIMUMUnit of Measurement of a Dimensionnvarchar30
13/SAPSLL/LCLICQLegal Control: Licenses - Quantities4DIMUMUnit of Measurement of a Dimensionnvarchar30
14/SAPSLL/LCLICQUSLegal Control: Licenses - Quantities Allocated4DIMUMUnit of Measurement of a Dimensionnvarchar30
15/SAPSLL/LC_CUSB1GTS: Custs Prcssng: Duty Cat: Non-EU Country Duty, Pharmac.15DIMUMUnit of Measurement of a Dimensionnvarchar30
16/SAPSLL/LC_CUSB2GTS Customs Management: Toll Category: Preferred Customs16DIMUMUnit of Measurement of a Dimensionnvarchar30
17/SAPSLL/LC_CUSMNGTS: Customs Processing: Measures Relating to Duty Rate11DIMUMUnit of Measurement of a Dimensionnvarchar30
18/SAPSLL/LEGCONLegal Control - Document21DIMUMUnit of Measurement of a Dimensionnvarchar30
19/SAPSLL/PRBOPCGTS: Outward Processing BOP - Components7DIMUMUnit of Measurement of a Dimensionnvarchar30
20/SAPSLL/PRBOPHSLL: Outward Processing BOM - Header Data6DIMUMUnit of Measurement of a Dimensionnvarchar30
21/SAPSLL/PREVDPreference: Long-Term Vendor Declaration - Header29DIMUMUnit of Measurement of a Dimensionnvarchar30
22/SAPSLL/PREVDHPreference: Long-Term Vendor Declaration Header26DIMUMUnit of Measurement of a Dimensionnvarchar30
23/SAPSLL/PRFPMSLL: Preference: Log: Products11DIMUMUnit of Measurement of a Dimensionnvarchar30
24/SAPSLL/PRVALLegal and Logistics Services: Product Master - Prices9DIMUMUnit of Measurement of a Dimensionnvarchar30
25/SAPSLL/RECSIDReconciliation Summary: Item Details12DIMUMUnit of Measurement of a Dimensionnvarchar30
26/SAPSLL/RXPMRACVRe-Export: Log: Values of Component9DIMUMUnit of Measurement of a Dimensionnvarchar30
27/SAPSLL/RXPMRAVRe-Export: Log: Values of Assembly9DIMUMUnit of Measurement of a Dimensionnvarchar30
28/SAPSLL/RXPMRVRe-Export: Log: Values in BOP9DIMUMUnit of Measurement of a Dimensionnvarchar30
29/SAPSLL/RXPMVRe-Export: Log: Values of Product9DIMUMUnit of Measurement of a Dimensionnvarchar30
30/SAPSLL/TCOTSUSLL: Mapping of Special Units of Measure in SAP UoMs6DIMUMUnit of Measurement of a Dimensionnvarchar30
31/SAPSLL/TLEVPGDerive Package Type from Sales Unit3DIMUMUnit of Measurement of a Dimensionnvarchar30
32/SAPSLL/VDOWLWorklist: Vendor Declaration for Customer's Purpose18DIMUMUnit of Measurement of a Dimensionnvarchar30
33/SAPSLL/VDOWLDETC-LTVD Worklist: Predefined Agreement Segments13DIMUMUnit of Measurement of a Dimensionnvarchar30