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

51 columns | Print definition?ERP 6.0  | NOTUSE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/RULCNTContent of alphanumeric numbering rules7NOTUSECharacters to Be Excluded from Numbering Rulenvarchar100
2/SAPPSSRM/RULEIDIDs for alphanumeric numbering rules4NOTUSECharacters to Be Excluded from Numbering Rulenvarchar100
3CNV20000TABCTRLControl table to handle the NOTUSE indicator5NOTUSEConversion: Exclusion indicatornvarchar10
4CNVMBT09TABLETables to be processed5NOTUSEFlag to Indicate Non-Usagenvarchar10
5CNVMBT_DEL_TABLETable to be processed5NOTUSEFlag to Indicate Non-Usagenvarchar10
6CNVTDMSBW_CLINDRList of cli-ind tables to be deleted in receiver5NOTUSEFlag to Indicate Non-Usagenvarchar10
7CNVTDMSSCM_CLINDList of cli-ind tables to be deleted in receiver5NOTUSEFlag to Indicate Non-Usagenvarchar10
8CNVTDMSSCR_DPARSParameters assigned to the Domain11NOTUSEExclusion from conversion indicationnvarchar10
9CNVTDMSSCR_FLDSList of Tables and Fields Assigned to a Rule9NOTUSEExclusion from conversion indicationnvarchar10
10CNVTDMSSCR_FPARSParameters assigned to the Rules10NOTUSEExclusion from conversion indicationnvarchar10
11CNVTDMS_09_TABLETables to be processed5NOTUSEFlag to Indicate Non-Usagenvarchar10
12CNV_10020_ACTActions - Header data5NOTUSEIndicator that an object/record is excludednvarchar10
13CNV_10020_CARDRequired cardinality per path9NOTUSEIndicator that an object/record is excludednvarchar10
14CNV_10020_CDOBJHCondition objects: Header data6NOTUSEIndicator that an object/record is excludednvarchar10
15CNV_10020_CFOBJHConcatenated/fragmented objects: Header data7NOTUSEIndicator that an object/record is excludednvarchar10
16CNV_10020_CFTABTables for which conflict detection has to be performed6NOTUSEIndicator that an object/record is excludednvarchar10
17CNV_10020_CONDConditions - Header data5NOTUSEIndicator that an object/record is excludednvarchar10
18CNV_10020_DPPATHPath dependencies7NOTUSEIndicator that an object/record is excludednvarchar10
19CNV_10020_DTFLDAssignment of determination to tables and fields19NOTUSEIndicator that an object/record is excludednvarchar10
20CNV_10020_DTOBJHDetermination objects8NOTUSEIndicator that an object/record is excludednvarchar10
21CNV_10020_EMEMPaths without calculation of memory requirements5NOTUSEIndicator that an object/record is excludednvarchar10
22CNV_10020_EPATHPaths that should not be suggested8NOTUSEIndicator that an object/record is excludednvarchar10
23CNV_10020_FVOBJFixed value objects8NOTUSEIndicator that an object/record is excludednvarchar10
24CNV_10020_LCOMPComponents to be evaluated in addition8NOTUSEIndicator that an object/record is excludednvarchar10
25CNV_10020_LOBARTObject types to be loaded irrespective of org. analysis7NOTUSEIndicator that an object/record is excludednvarchar10
26CNV_10020_LPATHPaths to be loaded irrespective of DTFLD entries7NOTUSEIndicator that an object/record is excludednvarchar10
27CNV_10020_PATHDetermination paths: Header data17NOTUSEIndicator that an object/record is excludednvarchar10
28CNV_10020_PATH_MMultiple paths: Item data7NOTUSEIndicator that an object/record is excludednvarchar10
29CNV_10020_RULERules - Header data4NOTUSEIndicator that an object/record is excludednvarchar10
30CNV_10020_VLISTValue lists - Header data5NOTUSEIndicator that an object/record is excludednvarchar10
31CNV_10520_PARTIFParticipating Interfaces6NOTUSEExclusion from conversion indicationnvarchar10
32CNV_10996_CLASSA.session: Archiving classes and their tables9NOTUSEExclusion from conversion indicationnvarchar10
33CNV_10996_DTFLDMapping determination - header tables14NOTUSEExclusion from conversion indicationnvarchar10
34CNV_10996_FIELDSSpecific conversion routines12NOTUSEExclusion from conversion indicationnvarchar10
35CNV_10996_ORGPTHPossible paths for ORG determination5NOTUSEExclusion from conversion indicationnvarchar10
36CNV_10996_TABLESTables of an archiving session7NOTUSEExclusion from conversion indicationnvarchar10
37CNV_20200_SP_FNCLists Priority Routines which support Spec Prio Handling4NOTUSEExclusion from conversion indicationnvarchar10
38CNV_20332_PARTIFParticipating Interfaces (AO object ID mapping)6NOTUSEExclusion from conversion indicationnvarchar10
39CNV_20333_PARTIFParticipating Interfaces (VD object ID mapping)6NOTUSEExclusion from conversion indicationnvarchar10
40CNV_20551_EXCLTables which were manually excluded from deletion5NOTUSEExclusion from conversion indicationnvarchar10
41CNV_20551_EX_TABTables which were manually excluded from deletion5NOTUSEExclusion from conversion indicationnvarchar10
42CNV_INDX_FIELDSINDX conversion: Conv.-relev. RELID component fields11NOTUSEExclusion from conversion indicationnvarchar10
43CNV_INDX_TABLESINDX conversion: Conv.-relev. RELID components9NOTUSEExclusion from conversion indicationnvarchar10
44CNV_MBT_09_TABLETables for table deletion5NOTUSEFlag to Indicate Non-Usagenvarchar10
TOPBusiness Application Support
45CNVFIELDSConversion: Table fields affected12NOTUSEExclusion from conversion indicationnvarchar10
46CNVFIELDSCConversion: Table fields with conflicts in blending13NOTUSEExclusion from conversion indicationnvarchar10
47CNVFIELDSCUConversion: User-defined table fields affected12NOTUSEExclusion from conversion indicationnvarchar10
48CNVTABLESConversion: Tables for processing by package10NOTUSEExclusion from conversion indicationnvarchar10
49CNVTABLESCConversion: conflict tables in blending11NOTUSEExclusion from conversion indicationnvarchar10
50CNVTABLESCUConversion: user-defined tables affected10NOTUSEExclusion from conversion indicationnvarchar10
51CNV_ABLAssignment of table/field to derivation or selection types8NOTUSEExclusion from conversion indicationnvarchar10