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

36 columns | Print definition?ERP 6.0  | SUBKEY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DB2CONVTOOLDB2 z/OS: Recommendations for data conversions6SUBKEYDB2 z/OS: subkey of an objectnvarchar160
2DLP_LOGPOINTSDynamic Logpoints (DO NOT CHANGE - BELONGS TO ABAP-KERNEL)6SUBKEYnvarchar5120
3SCIREST_TMPCode Inspector: Temporary Information5SUBKEYCHAR40 for SYSTnvarchar400
4SRTCM_SNAPSHOT_SSnapshot: Mapping from Subkey to Hash3SUBKEYntext10737418230
5SRTMP_SUBRuntime Monitoring: Subkey Table4SUBKEYRuntime Monitoring: Subkeynvarchar2000
TOPDB2 for OS39
6DB2MISCMiscellaneous CCMS on DB2 for z/OS settings and properties2SUBKEYnvarchar500
TOPEnterprise Service Framework Layer
7SCOOLRELATIONSRelations3SUBKEYCool Subkeynvarchar800
TOPInternationalization I18N
8TCPT1Code pages: Table 1 for tests and messages2SUBKEYSystem log: message textnvarchar100
9TCPT2Code Page Texts: Help Table 24SUBKEYCode page handling: counternvarchar60
TOPLoans Management
10VDBOINSBusiness Operation Insurance Data6SUBKEYPartial Key for Table VDBOINSnvarchar30
TOPLocalization
11IDCN_ACCITEMChina Golden Audit Interface: Account Lines6SUBKEYTechnical key field - calculated internallynvarchar20
TOPProcess Monitoring Infrastructure
12SSPIRGOVPRSPI Cumulation at Process Level3SUBKEYSPI Overview: Subkey for Status and Cumulationnvarchar20
13SSPIRGOVSTXSPI Cumulation at Step Level3SUBKEYSPI Overview: Subkey for Status and Cumulationnvarchar20
TOPProduct Cost Planning
14CKISItems Unit Costing/Itemization Product Costing135SUBKEYCO key subnumbernvarchar140
TOPProfit Center Accounting
15KE1_WU_ANLPCA Where-Used List: Assets5SUBKEY5 Character Numeric NUMCnvarchar50
16KE1_WU_BPPCA Where-Used List: Cost Centers5SUBKEY5 Character Numeric NUMCnvarchar50
17KE1_WU_COPCA Where-Used List: Cost Centers/Processes5SUBKEY5 Character Numeric NUMCnvarchar50
18KE1_WU_IMPCA Where-Used List: Real Estate Objects5SUBKEY5 Character Numeric NUMCnvarchar50
19KE1_WU_IM_ITEMPCA Where-Used List: Itemization for Real Estate4SUBKEY5 Character Numeric NUMCnvarchar50
20KE1_WU_ITEMPCA Where-Used List: Itemization4SUBKEY5 Character Numeric NUMCnvarchar50
21KE1_WU_KSPCA Where-Used List: Cost Centers5SUBKEY5 Character Numeric NUMCnvarchar50
22KE1_WU_KTRPCA Where-Used List: Cost Objects5SUBKEY5 Character Numeric NUMCnvarchar50
23KE1_WU_MATPCA Where-Used List: Material5SUBKEY5 Character Numeric NUMCnvarchar50
24KE1_WU_ORPCA Where-Used List: Orders5SUBKEY5 Character Numeric NUMCnvarchar50
25KE1_WU_PSPCA Where-Used List: Projects5SUBKEY5 Character Numeric NUMCnvarchar50
26KE1_WU_VBPCA Where-Used List: Sales Documents5SUBKEY5 Character Numeric NUMCnvarchar50
TOPProfitability Analysis
27RKEMCTEMLSTRMass Customizing - Template Structure Definition4SUBKEYMass Customizing - Template Subkeynvarchar160
TOPSyntax, Compiler, Runtime
28RTMRESRuntime Monitoring Result Table3SUBKEYRuntime Monitoring: Subkeynvarchar2000
29SRTM_SUBRuntime Monitoring: Subkey Table3SUBKEYRuntime Monitoring: Subkeynvarchar2000
TOPUI Configuration Design Layer
30BSPC_DL_FIELDUSEField Property table3SUBKEYGeneric Subkeynvarchar40
31BSPC_DL_XMLSTORXStoragetable for XML layout descriptions3SUBKEYGeneric Subkeynvarchar40
32BSP_DDLC_STEXTRPRepository for delivered custom texts4SUBKEYGeneric Subkeynvarchar40
33BSP_DDLC_XMLSTORStoragetable for delivered XML layout descriptions2SUBKEYGeneric Subkeynvarchar40
34BSP_DLC_SKEYDEFSubkey definition table1SUBKEYGeneric Subkeynvarchar40
35BSP_DLC_SKEYDEFTTexttable for Subkey definitions2SUBKEYGeneric Subkeynvarchar40
36BSP_DLC_STEXTREPRepository for custom texts5SUBKEYGeneric Subkeynvarchar40