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

32 columns | Print definition?ERP 6.0  | STRING

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_10940_VARDETStoring values of variants9STRINGSearch Stringnvarchar200
2CNV_DOWNUPCHKSTRUpload check strings1STRINGUpload check stringnvarchar480
3CNV_DOWNUPCHKSTTUpload check string texts1STRINGUpload check stringnvarchar480
4CNV_DOWNUPTABDEPDependent tables for a table set1STRINGUpload check stringnvarchar480
5CNV_DOWNUPTABSETSets of table for a table set1STRINGUpload check stringnvarchar480
6CNV_INDX_TABLESINDX conversion: Conv.-relev. RELID components6STRINGIndicator if given object is a structure or notnvarchar10
7HRSFI_D_COMP_EX2SuccessFactors: Comp Log Table for Transfer Data (Delta Log)8STRINGFilter Stringntext10737418230
8HRSFI_D_COMP_EXTSuccessFactors: Comp Log Table for Transfer Data (Delta Log)7STRINGFilter Stringntext10737418230
9HRSFI_D_COMP_IMPSuccessFactors: Imported Comp data9STRINGFilter Stringntext10737418230
10HRSFI_D_EXTR_LOGSuccessFactors: Log Table for Delta Handling8STRINGFilter Stringntext10737418230
11HRSFI_D_VARPY_IMImported Variable Pay data9STRINGFilter Stringntext10737418230
12VERI_STRGVerifikation von STRING-Feldern4STRINGDatenelement für automatische Verifikationntext10737418230
13VERSTRINGTesttabelle zum Verbuchen von Strings1STRINGnvarchar1000
TOPActivity-Based Costing
14COTPLFCCO-OM-ABC: Process Template Control Blocks (TYPE TPLIC_BCB)12STRINGStringnvarchar720
TOPArchiveLink
15TOA_L03SAP ArchiveLink: Log table9STRINGChar 80nvarchar800
TOPBusiness Navigator
16DFBNTBusiness Navigator WEB Textpool4STRINGText, 255 Charactersnvarchar2550
TOPClasses
17CLPROFClassification: Parameters for Settings56STRINGFind string for characteristics that have character formatnvarchar10
TOPClassification System New
18CME_ST_VALUECME Data Type: Values13STRINGCharacter-Type Valuesnvarchar2540
19CME_ST_VALUEHCME Data Type: Values13STRINGCharacter-Type Valuesnvarchar2540
TOPCross-Application Components
20ZGADGETS_CUSTURL Maintenance for Gadgets15STRINGString case sensitiventext10737418230
21ZGADGETS_URLSURL Maintenance for Gadgets14STRINGString case sensitiventext10737418230
22ZGADGETS_USERSUsers gadget speciffic entries20STRINGString case sensitiventext10737418230
TOPData Collection
23TKEBGGraphic settings for hierarchy graphic5STRINGParameter for graphicnvarchar800
TOPDenmark
24T5M8KLog of report calls for Danish payroll accounting6STRINGParameter string for reportnvarchar1000
TOPGeneral Ledger Accounting
25FAGL_BW_LOG_HEADFI-GL: Log for BW Extraction: Control Data7STRINGCharacter 100nvarchar1000
TOPMigration
26TEMFEIS-U Mig.: Fxd Vals3STRINGFixed Value is a Stringnvarchar10
TOPOnline Text Repository
27BTFR_OBJ_IDSBTFR Object Types, "Translation" Object Type - Vector7STRINGBTFR Indicatornvarchar10
TOPProduct Cost Planning
28CKTC_CBEWCosting Master Data - Attributes19STRINGFree Characteristicnvarchar200
29KEKO_CCAdditional Data for Concurrent Costing17STRINGFree Characteristicnvarchar200
TOPPurchasing
30TEMPLATE_DATATemplates4STRINGData Stream for Templatentext10737418230
TOPTranslation Tools
31TSKTUIndustry Short Text Search Strings3STRINGText (30 Characters)nvarchar300
TOPWeb Service and SOAP - ABAP
32SRT_SEQ_TST_DTSequence Manager test data16STRINGntext10737418230