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

46 columns | Print definition?ERP 6.0  | TEXT5

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DVKTXR/2-R/3 Link: Delivery texts R2 -> R312TEXT5Text R/2-R/3 Linknvarchar720
TOPBasic Functions
2MAZOForeign Trade: Customs Law Description10TEXT5Description for customs descriptionnvarchar700
3T604NImport Processing: Control Code Description9TEXT5Description of rulenvarchar600
4T604OForeign Trade: Sections With Regard to Customs Law - Descr.9TEXT5Text, 40 Characters Longnvarchar400
5T604TForeign Trade: Commodity Code/Import Code No. Description9TEXT5Text, 40 Characters Longnvarchar400
6T604ZForeign Trade: Chapter - Descriptions10TEXT5Text, 40 Characters Longnvarchar400
7T605TForeign Trade: Business Transaction Type - Descriptions9TEXT5Text Field of Length 60nvarchar600
8T615TForeign Trade: Customs Offices - Descriptions9TEXT5Text Field of Length 60nvarchar600
9T616TForeign Trade: Procedures - Descriptions9TEXT5Text Field of Length 60nvarchar600
10T618MTEU Market: EU Market Products List No. - Descriptions9TEXT5Description of rulenvarchar600
TOPBudgeting
11FMBUDTYPETTexts for Budget Types6TEXT5Budget type short text (5)nvarchar50
12FMSTATDEFTTexts for Budgeting Status5TEXT5Status short text (5)nvarchar50
TOPCentral Part of Product Master
13CRMC_TAX_TCODE_TDescription for Assignment of Tax Scale Code to a Country9TEXT5Description of Tax Scale Codenvarchar600
TOPForeign Trade
14/SAPSLL/T604R3GTS: Worklist: Retransfer of Commodity Code12TEXT5Text, 40 Characters Longnvarchar400
TOPFunds Management
15TBP4TTexts for Budget/Plan Subcategories5TEXT5Budget Subtype Name (S)nvarchar50
TOPGlobal Trade Services
16/SAPSLL/CCGRTLegal Control: Control Groupings for Products - Relation.9TEXT5Text 60 Characters Longnvarchar600
17/SAPSLL/CTYGPTLegal Services: Country Group - Text8TEXT5Text 60 Characters Longnvarchar600
18/SAPSLL/CUCAPRTSLL: Additional Procedures - Description9TEXT5Text 60 Characters Longnvarchar600
19/SAPSLL/PRECONDTGTS: preference: additional cond's (upload data provider -B)9TEXT5Text 60 Characters Longnvarchar600
20/SAPSLL/PSVCONDTGTS: Preference: Additional Conditions (Manual Entry)9TEXT5Text 60 Characters Longnvarchar600
21/SAPSLL/T606DLTLegal Control: Text for Procedure for Determining Lic. Types8TEXT5Text 60 Characters Longnvarchar600
22/SAPSLL/T606DRTLegal Control: Text for Procedure for Determining Leg. Regs8TEXT5Text 60 Characters Longnvarchar600
23/SAPSLL/T608GTSanctioned Party List: Group of List - Name9TEXT5Text 60 Characters Longnvarchar600
24/SAPSLL/T608ITSanctioned Party List: Type of Identification - Name9TEXT5Text 60 Characters Longnvarchar600
25/SAPSLL/T608LTLegal Control - SPL - Type of List - Reference9TEXT5Text 60 Characters Longnvarchar600
26/SAPSLL/TCOCMPTText for Rule Set for Comparing Addresses/Strings8TEXT5Text 60 Characters Longnvarchar600
27/SAPSLL/TCOGVSTText for Feeder System Grouping7TEXT5Text 60 Characters Longnvarchar600
28/SAPSLL/TCOTSTBasic Structure of Customs Tariff System - Text8TEXT5Text 60 Characters Longnvarchar600
29/SAPSLL/TCSIDDTSchema for Identification Types - Name8TEXT5Text 60 Characters Longnvarchar600
30/SAPSLL/TCSSCHTDetermination Procedure for Release Reason - Name8TEXT5Text 60 Characters Longnvarchar600
TOPLocalization
31J_1AOFTPTTexts for official document types4TEXT5Text field with length of 5nvarchar50
TOPMaterial Groups
32WTREEVersion Management for Reclassification Trees50TEXT5Text/Icon/Symbolnvarchar750
TOPMaterial Master
33MGVSPECTYPETEXTSText for specialization types9TEXT5Column overview characteristics valuenvarchar400
TOPRemaining Beverage - Obsolete Objects
34/BEV1/CLT998Table for Border Crossing Points7TEXT5Table textnvarchar600
35/BEV3/CHCDPCUSTCDP: Contract Data Customer24TEXT5CH: Free Text 30 Charactersnvarchar300
36/BEV3/CHWDCMMNTInternal memos / comments on CHD11TEXT5Check: Character Field length = 80, Upper and Lower Casenvarchar800
TOPRisk Analysis
37JBRNODETXTAll Information for Display of Hierarchies46TEXT5Text/Icon/Symbolnvarchar750
TOPWarehouse Management
38LL01Whse Activity Monitor: Critical Transfer Order Items19TEXT5Processing note for a critical activitynvarchar400
39LL02Whse Activity Monitor: Critical Transfer Requirement Items20TEXT5Processing note for a critical activitynvarchar400
40LL03Whse Activity Monitor: Critical Posting Change Documents16TEXT5Processing note for a critical activitynvarchar400
41LL04Whse Activity Monitor: Critical Deliveries16TEXT5Processing note for a critical activitynvarchar400
42LL05Whse Activity Monitor: Critical Stocks16TEXT5Processing note for a critical activitynvarchar400
43LL06Whse Activity Monitor: Critical Storage Bins16TEXT5Processing note for a critical activitynvarchar400
44LL07Whse Activity Monitor: Critical Production Orders16TEXT5Processing note for a critical activitynvarchar400
TOPWorkbench Tools Editors, Painters, Modelers
45COVMVDATTable for Storing Coverage Results from Coverage Analyzer33TEXT5For General Use of Names of Length < 30nvarchar300
46COVMVHISTable for Storing the History from Coverage Analyzer35TEXT5For General Use of Names of Length < 30nvarchar300