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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

71 columns | Print definition?ERP 6.0  | GUID_PR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPElectronic Compliance Reporting
1/ECRS/WLENWorklist for Intrastat Declaration48GUID_PRGUID in 'RAW' formatvarbinary160
TOPGlobal Trade Services
2/SAPSLL/BOMHDSLL: BOM - Header28GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
3/SAPSLL/BOMITSLL: BOM - Item24GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
4/SAPSLL/BOPITGTS: General Bill of Product - Item Data6GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
5/SAPSLL/CMLPRCase Management Audit Customs Product3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
6/SAPSLL/CUITCustoms Document: Item18GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
7/SAPSLL/CUITSUBLegal Services: Customs Document - Subitem9GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
8/SAPSLL/CUPEDRIGTS: Period Entry Reference to Customs Document Item15GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
9/SAPSLL/CUSWLAWorklist for Quantity Comparison Goods Issue/Customs Doc.14GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
10/SAPSLL/CUSWLBCustoms Worklist: Qty Adjustment - Completed Transactions18GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
11/SAPSLL/CUSWLDCustoms Processing: Procedures Completed for Customs Decl.21GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
12/SAPSLL/CUSWLEWorklist for Processing Domestic Customs Warehouse Issues12GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
13/SAPSLL/CUSWLFCustoms Worklist: Domestic Issues - Completed Transactions12GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
14/SAPSLL/CUSWLMQuantity Comparison: Customs Declaration/Goods Receipt28GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
15/SAPSLL/CUSWLNCompleted Quantity Comparisons Customs Declaration/GR28GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
16/SAPSLL/CUSWLOWorklist for Transactions with Reference to Delivery or PO21GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
17/SAPSLL/CUSWLSCustoms Worklist: Temporary Storage16GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
18/SAPSLL/CUSWLTCustoms Worklist: Completed Temporary Storage16GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
19/SAPSLL/CWLCCPWorklist of Export Items to Determine IP Closing Portions6GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
20/SAPSLL/CWLOCPWorklist: Import Items to Determine OP Closing Portions5GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
21/SAPSLL/CWLPCPWorklist: Installation Statement FC w/PEU13GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
22/SAPSLL/FTOPRRELGTS: Relational Table: Foreign Trade Org.for Product4GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
23/SAPSLL/GPASTOCKShared, Periodic, and Completed Stock4GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
24/SAPSLL/ITARAUDITAR Tracking: Log - Header Data7GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
25/SAPSLL/IVMCST01Indiv. Stock Item: Special Customs Procedures: Inward Proc.5GUID_PRProduct GUID im 'RAW' Formatvarbinary160
26/SAPSLL/IVMCST02Totals Stock: Special Customs Procedure: Inward Processing5GUID_PRProduct GUID im 'RAW' Formatvarbinary160
27/SAPSLL/IVMFST01Individual Stock Item Free Circulation for Prescribed EndUse4GUID_PRProduct GUID im 'RAW' Formatvarbinary160
28/SAPSLL/IVMPST01Processing Stock4GUID_PRProduct GUID im 'RAW' Formatvarbinary160
29/SAPSLL/KMATPREFGTS: Preference Processing KMAT - Storage of Results4GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
30/SAPSLL/LCLICAQLegal Control: License: Available Quantity4GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
31/SAPSLL/LCLICAVLegal Control: License: Available Quantity4GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
32/SAPSLL/LCLICMLegal Control - Licenses - Materials4GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
33/SAPSLL/PNTPRLegal and Logistics Services: Product Master Mapping5GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
34/SAPSLL/PRLegal & Logistics Services: Product Master2GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
35/SAPSLL/PRBOPCGTS: Outward Processing BOP - Components9GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
36/SAPSLL/PRBOPHSLL: Outward Processing BOM - Header Data3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
37/SAPSLL/PRBWHGTS Product Master: BW Relevance per Logical System3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
38/SAPSLL/PRCONLegal Control - Product Master7GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
39/SAPSLL/PRCTRProduct Master: Authority/Country Data3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
40/SAPSLL/PRCTSProduct Master - Global Customs Tariff Numbers7GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
41/SAPSLL/PRCTSCProduct Master - Country-Specific Customs Tariff Numbers7GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
42/SAPSLL/PRDOCProduct Master: Documents / Verifications3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
43/SAPSLL/PRECIPProduct Master: Data for Special Customs Procedures3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
44/SAPSLL/PREFDIMGTS: Preference Designated Intermediate Materials (NAFTA)4GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
45/SAPSLL/PREVDPreference: Long-Term Vendor Declaration - Header5GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
46/SAPSLL/PREVDCHGGTS: Preference, Vendor Decl. (Customer), Relevant Changes3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
47/SAPSLL/PREVDHPreference: Long-Term Vendor Declaration Header6GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
48/SAPSLL/PREVDWLISLL: Preference: Vendor-Based LTVD - Worklist5GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
49/SAPSLL/PREVDWLOSLL: Preference: Vend.Decl. f. Cust. Purp. - Worklist3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
50/SAPSLL/PRFPMSLL: Preference: Log: Products4GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
51/SAPSLL/PRFPMRDSLL: Preference: Log: Designated Intermediate Materials4GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
52/SAPSLL/PRGENGTS: Product Master: Generic Characteristic Values3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
53/SAPSLL/PRODWLGTS: Product Master: Global: Worklist3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
54/SAPSLL/PRPARLegal and Logistics Services: Product Master - Partner3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
55/SAPSLL/PRPREFSLL: Product Master: Preference Data3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
56/SAPSLL/PRPREFNGSLL: Product Master: Preference Data5GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
57/SAPSLL/PRPRFCSLL: Product Master: Preference Data: Confirm. Pref. Reqmts3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
58/SAPSLL/PRPRFSSLL: Product Master: Preference Data: Special Requirements3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
59/SAPSLL/PRPROCIDSLL: Product Master: Procurement Type3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
60/SAPSLL/PRRECOP - Product/Receiver Assignment4GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
61/SAPSLL/PRREXProduct Master: Re-Export Segment3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
62/SAPSLL/PRTLegal and Logistics Services: Product Master - Short Text7GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
63/SAPSLL/PRTAXLegal and Logistics Services: Product Master - Tax Groups3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
64/SAPSLL/PRUOMLegal & Logistics Services: Product Master - Units7GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
65/SAPSLL/PRVALLegal and Logistics Services: Product Master - Prices3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
66/SAPSLL/PRVDRELProduct Master: Relevance for Request of Vendor Declaration3GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
67/SAPSLL/RXPMRe-Export: Log: Products4GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
68/SAPSLL/RXPMRARe-Export: Log: Assemblies in Bill of Product7GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
69/SAPSLL/RXPMRACRe-Export: Log: Components in Assembly4GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
70/SAPSLL/VDMTWLPreference: Worklist to Maintain LTVD via Web Dynpro5GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160
71/SAPSLL/VDOWLWorklist: Vendor Declaration for Customer's Purpose6GUID_PRPrimary Key as GUID in 'RAW' Formatvarbinary160