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

31 columns | Print definition?ERP 6.0  | BEZEICHNUNG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CIDEON/FM_NAMECIDEON® Fast Property Update CallBack Name3BEZEICHNUNGFunction assignmentnvarchar700
TOPElectronic Data Interchange
2PRICAT_KARTTPrice Catalog Customizing: Catalog Type Text Tables4BEZEICHNUNGDescriptionnvarchar300
TOPExcise Duty
3/BEV2/ED970TList Types4BEZEICHNUNGDescription of the List Type of a Listnvarchar300
TOPMedia Product
4JPTMESTYPTIS-M: Customizing Table / Adressees for Title Announcement5BEZEICHNUNGText for Message Typenvarchar300
5TJPCNMUNITTexts for Units of Measure4BEZEICHNUNGUnit of Measure Textnvarchar300
6TJPCPREXCTTexts for Special Provisions4BEZEICHNUNGSpecial Provision Textnvarchar300
7TJPDESIGNTProduct Presentation Text Table4BEZEICHNUNGIS-M: Short Textnvarchar150
8TJPEDITYPTTexts for Edition Types4BEZEICHNUNGEdition Category Textnvarchar200
9TJPEXTUNITTexts for Scope Units of Measurement4BEZEICHNUNGIS-M: Short Textnvarchar150
10TJPFORMATTText Table for IS-M Formats4BEZEICHNUNGFormats Textnvarchar150
11TJPIDCAREATID Code Area Text Table5BEZEICHNUNGIS-M: Short Textnvarchar150
12TJPIDCNUMARTID Code Number Range6BEZEICHNUNGIS-M: Short Textnvarchar150
13TJPIDCTYPTTexts for Identification Code Types4BEZEICHNUNGIdentification Code Type Textnvarchar150
14TJPIMPRTTexts for Imprint (Publisher)4BEZEICHNUNGImprint Textnvarchar300
15TJPLANGUAGESTIS-M: Customizing Table of Product Languages Texts4BEZEICHNUNGText for publication languagenvarchar400
16TJPMEDTPTText Table for Media Types4BEZEICHNUNGMedia Type Textnvarchar150
17TJPMESADRTIS-M: Customizing Table / Adressees for Title Announcement4BEZEICHNUNGAddress for Title Announcementnvarchar300
18TJPNUMUNITTexts for Feature Units4BEZEICHNUNGUnit of Measure Textnvarchar300
19TJPPERTYPEIS-M: Period Types (Language-Dependent)4BEZEICHNUNGPeriod Type Textnvarchar300
20TJPPERTYPTTexts for Period Types3BEZEICHNUNGPeriod Type Textnvarchar300
21TJPPUBTPTPublication Type Text Table Customizing4BEZEICHNUNGIS-M: Short Textnvarchar150
22TJPRPRTYPTTexts for Reprinting Types4BEZEICHNUNGReprinting Textnvarchar200
TOPOutput Determination
23LEDPROFILTDefinition of Print Profile Names and their Usage4BEZEICHNUNGDescription of print profilenvarchar400
TOPPlant Maintenance
24Z9I_STK_WVARIWerkstattlisten-Varianten6BEZEICHNUNGBezeichnung der Werkstattlisten-Variantenvarchar400
TOPQuantity optimizing
25WLC_PRESEL_CRITTLoad Control/Ext. Paral. Proc.: Preselection Criteria5BEZEICHNUNGDescriptionnvarchar300
TOPRemaining Beverage - Obsolete Objects
26/BEV3/CHCBDGKLTCustomizing Condition Classes4BEZEICHNUNGText data element of length 60nvarchar600
27/BEV3/CHCBDPROTCustomizing Condition Log Out Module / Text4BEZEICHNUNGText data element of length 60nvarchar600
28/BEV3/CHCBDPRTTCustomizing Condition Log Out5BEZEICHNUNGText data element of length 60nvarchar600
29/BEV3/CHCHKPNTTCheck Points for Text Authorization Check5BEZEICHNUNG60-Character Descriptionnvarchar600
30/BEV3/CHCVKEVCVTCH BTE Customizing Agreement Class/EvliClass/ACB6BEZEICHNUNGText data element of length 30nvarchar300
TOPTravel Expenses
31T702_BKZCountry and Industry Specific Indicator (Public Sector)6BEZEICHNUNGName of Country or Industry Sector ID (Public Sector)nvarchar500