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

58 columns | Print definition?ERP 6.0  | TEXT4

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DVKTXR/2-R/3 Link: Delivery texts R2 -> R311TEXT4Text R/2-R/3 Linknvarchar720
2PYC_D_PY_MSGPYC: payroll message47TEXT4Text Element for Structure PLOG_TEXTnvarchar1320
3PYC_D_PY_MSG_JOBPYC: payroll message30TEXT4Text Element for Structure PLOG_TEXTnvarchar1320
4ZML_MAILSETTINGMail settings for OTM11TEXT4Textnvarchar2550
TOPBasic Functions
5MAZOForeign Trade: Customs Law Description9TEXT4Description for customs descriptionnvarchar700
6T604DPreference: Description of Preference Procedure Code9TEXT4Text, 40 Characters Longnvarchar400
7T604NImport Processing: Control Code Description8TEXT4Description of rulenvarchar600
8T604OForeign Trade: Sections With Regard to Customs Law - Descr.8TEXT4Text, 40 Characters Longnvarchar400
9T604TForeign Trade: Commodity Code/Import Code No. Description8TEXT4Text, 40 Characters Longnvarchar400
10T604ZForeign Trade: Chapter - Descriptions9TEXT4Text, 40 Characters Longnvarchar400
11T605TForeign Trade: Business Transaction Type - Descriptions8TEXT4Text Field of Length 60nvarchar600
12T615TForeign Trade: Customs Offices - Descriptions8TEXT4Text Field of Length 60nvarchar600
13T616TForeign Trade: Procedures - Descriptions8TEXT4Text Field of Length 60nvarchar600
14T618MTEU Market: EU Market Products List No. - Descriptions8TEXT4Description of rulenvarchar600
TOPCentral Part of Product Master
15CRMC_TAX_TCODE_TDescription for Assignment of Tax Scale Code to a Country8TEXT4Description of Tax Scale Codenvarchar600
TOPDenmark
16PA0073HR Master Record: Infotype 0073 (Private Pensions - DK)48TEXT4Supplementary pension text 4nvarchar610
TOPForeign Trade
17/SAPSLL/T604R3GTS: Worklist: Retransfer of Commodity Code11TEXT4Text, 40 Characters Longnvarchar400
TOPGlobal Trade Services
18/SAPSLL/CCGRTLegal Control: Control Groupings for Products - Relation.8TEXT4Text 60 Characters Longnvarchar600
19/SAPSLL/CTYGPTLegal Services: Country Group - Text7TEXT4Text 60 Characters Longnvarchar600
20/SAPSLL/CUCAPRTSLL: Additional Procedures - Description8TEXT4Text 60 Characters Longnvarchar600
21/SAPSLL/PRECONDTGTS: preference: additional cond's (upload data provider -B)8TEXT4Text 60 Characters Longnvarchar600
22/SAPSLL/PSVCONDTGTS: Preference: Additional Conditions (Manual Entry)8TEXT4Text 60 Characters Longnvarchar600
23/SAPSLL/T606DLTLegal Control: Text for Procedure for Determining Lic. Types7TEXT4Text 60 Characters Longnvarchar600
24/SAPSLL/T606DRTLegal Control: Text for Procedure for Determining Leg. Regs7TEXT4Text 60 Characters Longnvarchar600
25/SAPSLL/T608GTSanctioned Party List: Group of List - Name8TEXT4Text 60 Characters Longnvarchar600
26/SAPSLL/T608ITSanctioned Party List: Type of Identification - Name8TEXT4Text 60 Characters Longnvarchar600
27/SAPSLL/T608LTLegal Control - SPL - Type of List - Reference8TEXT4Text 60 Characters Longnvarchar600
28/SAPSLL/TCOCMPTText for Rule Set for Comparing Addresses/Strings7TEXT4Text 60 Characters Longnvarchar600
29/SAPSLL/TCOGVSTText for Feeder System Grouping6TEXT4Text 60 Characters Longnvarchar600
30/SAPSLL/TCOTSTBasic Structure of Customs Tariff System - Text7TEXT4Text 60 Characters Longnvarchar600
31/SAPSLL/TCSIDDTSchema for Identification Types - Name7TEXT4Text 60 Characters Longnvarchar600
32/SAPSLL/TCSSCHTDetermination Procedure for Release Reason - Name7TEXT4Text 60 Characters Longnvarchar600
TOPI18N Unicode
33UM4MAINLOGSPUMG: Main Log table9TEXT4nvarchar400
34UMGMAINLOGSPUMG: Main Log table9TEXT4SPUMG: Parameter for main log messagesnvarchar400
TOPInternationalization I18N
35CFONT_MAINLOGI18N:Cascading font, log table9TEXT4nvarchar400
TOPLocalization
36J_3RFF4DATACash flow statement customizing11TEXT4Item Descriptionnvarchar450
37J_3RFF4DATATCash flow statement row texts9TEXT4Item Descriptionnvarchar450
TOPMaterial Groups
38WTREEVersion Management for Reclassification Trees44TEXT4Text/Icon/Symbolnvarchar750
TOPMaterial Master
39MGVSPECTYPETEXTSText for specialization types8TEXT4Column overview materialnvarchar400
TOPOLAP Technology
40RSR_CACHE_LOGOLAP Cache Table for Saving Log Entries14TEXT4Character Field of Length 40nvarchar400
TOPPeriodical Sales and Distribution
41JVTFAHRMIS-M: Driver Notification (Shipping Documents)7TEXT4Text (80 Characters)nvarchar800
42JVTZUSTMIS-M/SD: Carrier Notification (Shipping Documents)11TEXT4Text (80 Characters)nvarchar800
TOPPersonnel Administration
43T7PL08Conversion table for leave codes8TEXT4Text field - 60 charactersnvarchar600
44T7PLT0Conversion table for leave codes fot tempolary workers8TEXT4Text field - 60 charactersnvarchar600
TOPRemaining Beverage - Obsolete Objects
45/BEV1/CLT998Table for Border Crossing Points6TEXT4Table textnvarchar600
46/BEV3/CHCDPCUSTCDP: Contract Data Customer23TEXT4CH: Free Text 30 Charactersnvarchar300
47/BEV3/CHWDCMMNTInternal memos / comments on CHD10TEXT4Check: Character Field length = 80, Upper and Lower Casenvarchar800
TOPRisk Analysis
48JBRNODETXTAll Information for Display of Hierarchies40TEXT4Text/Icon/Symbolnvarchar750
TOPTransportation
49VTTKShipment Header95TEXT4Addit.text 4nvarchar400
TOPWarehouse Management
50LL01Whse Activity Monitor: Critical Transfer Order Items18TEXT4Processing note for a critical activitynvarchar400
51LL02Whse Activity Monitor: Critical Transfer Requirement Items19TEXT4Processing note for a critical activitynvarchar400
52LL03Whse Activity Monitor: Critical Posting Change Documents15TEXT4Processing note for a critical activitynvarchar400
53LL04Whse Activity Monitor: Critical Deliveries15TEXT4Processing note for a critical activitynvarchar400
54LL05Whse Activity Monitor: Critical Stocks15TEXT4Processing note for a critical activitynvarchar400
55LL06Whse Activity Monitor: Critical Storage Bins15TEXT4Processing note for a critical activitynvarchar400
56LL07Whse Activity Monitor: Critical Production Orders15TEXT4Processing note for a critical activitynvarchar400
TOPWorkbench Tools Editors, Painters, Modelers
57COVMVDATTable for Storing Coverage Results from Coverage Analyzer32TEXT4For General Use of Names of Length < 30nvarchar300
58COVMVHISTable for Storing the History from Coverage Analyzer34TEXT4For General Use of Names of Length < 30nvarchar300