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

30 columns | Print definition?ERP 6.0  | SOPTION

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVHCM_PARDEFTDMS4HCM: Parameter Object Definitions7SOPTIONTDMS4HCM: Optionnvarchar20
2CNVMBTACTPARAMSParameters for Activities9SOPTIONSelection Optionnvarchar20
3CNVMBTACTPARLOGMBT PCL - Activity execution log11SOPTIONSelection Optionnvarchar20
4CNVMBTMODIFINFOMBT PCL: Setting for modifiable system information6SOPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
5CNVMBTPARAMSTable for storing general parameters5SOPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
6CNVMBTPEBPARAMSParameters for process execution blocks10SOPTIONSelection Optionnvarchar20
7CNVMBTSELGRPVALMBT PCL Selection group values10SOPTIONSelection Optionnvarchar20
8CNVMBTSHELLSPECShell Creation: Tables with special handling for copy7SOPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
9CNVMBTSPECSpecial handling of tables7SOPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
10CNVMBTSUBPARAMSParameters for Subactivities11SOPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
11CNVMBTTRTRACKTo store tables configured for tracking11SOPTIONSelection Optionnvarchar20
12CNVTDMS_05_CUSTMTable to customize the select statement in fill header pgm10SOPTIONOption ( GE/EQ/GT....)nvarchar20
13CNVTDMS_06_SPECSpecial handling of tables7SOPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
14CNVTDMS_14_PARAMTable for storing general parameters6SOPTIONABAP: Selection option (EQ/BT/CP/...)nvarchar20
15FIBKRUC_TACCRULESelection criteria6SOPTIONOption values for Account template rulesnvarchar20
16J_3RFREP_ATTRSELReporting Object Attribut Selections14SOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
17J_3RFREP_OBJSELTax reporting object selections9SOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
18NWS_EXT_SVALUEData Transport Management Tool SELECT OPTIONS, Values11SOPTIONSelecion Criteria: OPTIONnvarchar20
TOPAccrual Engine
19ACEPSPPSELSelect Options Periodic Posting Run7SOPTIONOption for Ranges Tablesnvarchar20
TOPCross-Application Components
20CCMSBI_MTEMAP_SSelection Conditions for MTEs with Names That Are Converted5SOPTIONSelection criteria: OPTIONnvarchar20
TOPDevice installation
21TE179Permissibility of Installation Relevant to Billing6SOPTIONSelection option (EQ/BT/CP/...) for TE179nvarchar20
TOPGermany
22TZA11RValues for classifying appendices acc. to R96/115SOPTIONRelational Operatornvarchar20
23TZA11R1Values for Classifying Appendix 10 According to R5/975SOPTIONRelational Operatornvarchar20
24TZR96Circular R5/97 Control Table for Report Program RFVZBR004SOPTIONOption for ranges tablesnvarchar20
TOPJoint Venture und Production Sharing Accounting
25T8JEVSJoint venture event select options12SOPTIONVersion Number Componentnvarchar20
26T8PSA_EVENT_SOJoint venture event select options12SOPTIONSelect Optionnvarchar20
TOPLocalization
27J_3RFF4PARACash flow statement additional parameters8SOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
28J_3RFTAX_OBJSELTax object selections13SOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
29J_3RTAX_SELTRVALSelective transfer values4SOPTIONOPTION field in structure of SELECT-OPTIONS tablesnvarchar20
TOPTreasury
30TTXBFCorrespondence Interface: Definition of Letter Categories22SOPTIONM/Text Option bytenvarchar10