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

57 columns | Print definition?ERP 6.0  | CONVOBJECT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_FIELDSExplicit conversion rules for fields during migration3CONVOBJECTConversion Objectnvarchar160
2CNVCMIS_FIPARSparameters for rules mentioned in cnvmbtfields3CONVOBJECTConversion Objectnvarchar160
3CNVCMIS_MAPPINGTable for storing information about the mapping3CONVOBJECTConversion Objectnvarchar160
4CNVCMIS_M_CONF_RShadow table for storing the conflicts information3CONVOBJECTConversion Objectnvarchar160
5CNVCMIS_M_HIERARSAP LT CT Store info about hierarchical objects3CONVOBJECTObjectnvarchar320
6CNVCMIS_M_HIERATSAP LT CT Text table for CNVCMIS_M_HIERAR2CONVOBJECTObjectnvarchar320
7CNVCMIS_SPLIT_EXSAP LT Store runtime Inforamtion about Splitted Mig.Objects4CONVOBJECTObjectnvarchar320
8CNVCMIS_SPLIT_KBSAP LT Store Inforamtion about Split Option for Mig.Tabs.1CONVOBJECTObjectnvarchar320
9CNVCMIS_TAB_POSTPostponed conflicts between sender and receiver system3CONVOBJECTConversion Objectnvarchar160
10CNVCMIS_TB_CNT_NCMIS: Table count results (new with history)5CONVOBJECTConversion Objectnvarchar160
11CNVCMIS_TB_COUNTCMIS: Table count results4CONVOBJECTConversion Objectnvarchar160
12CNVLTHCM_ADDTABOBSOLETE! DO NOT USE!!!3CONVOBJECTTable Namenvarchar160
13CNVLTHCM_APPLTABOBSOLETE! DO NOT USE!!!3CONVOBJECTTable Namenvarchar160
14CNVLTHCM_BASETABLT HCM: List of HCM Basis Tables3CONVOBJECTTable Namenvarchar160
15CNVLTHCM_DELTABLT HCM: List of HCM Tables to be Deleted3CONVOBJECTTable Namenvarchar160
16CNVLTHCM_HRTABLT HCM: List of HCM Tables for Transfer3CONVOBJECTTable Namenvarchar160
17CNVLTHCM_SELTABSLT HCM: Data Selection for Tables3CONVOBJECTTable Namenvarchar160
18CNVLTHCM_TABCOMPLT HCM: Component of Conversion Object3CONVOBJECTTable Namenvarchar160
19CNVMBTBLOCKPROCControlled Blocking of MWB processing steps4CONVOBJECTConversion Objectnvarchar160
20CNVMBTCHECKSMBT Checks3CONVOBJECTConversion Objectnvarchar160
21CNVMBTCOBJconversion objects3CONVOBJECTConversion Objectnvarchar160
22CNVMBTCONFLICTSConflicts between sender and receiver system3CONVOBJECTConversion Objectnvarchar160
23CNVMBTCONVERSIONSettings for integrated conversion3CONVOBJECTConversion Objectnvarchar160
24CNVMBTDOMCONFLConflicts between sender and receiver system3CONVOBJECTConversion Objectnvarchar160
25CNVMBTFIELDSexplicite conversion rules for fields during migration3CONVOBJECTConversion Objectnvarchar160
26CNVMBTFIPARSparameters for rules mentioned in cnvmbtfields3CONVOBJECTConversion Objectnvarchar160
27CNVMBTFORKEYForeign key releations in structure + fixed values3CONVOBJECTConversion Objectnvarchar160
28CNVMBTINCLMBT PCL: Includes to be integrated in Conversion Objects3CONVOBJECTConversion Objectnvarchar160
29CNVMBTINCOBJObjects which use incremental transfer4CONVOBJECTConversion Objectnvarchar160
30CNVMBTPRECALCOBJPrecalculation tables for TDMS4CONVOBJECTnvarchar160
31CNVMBTSELCONFRConfrontation of org-independent group IDs3CONVOBJECTConversion Objectnvarchar160
32CNVMBTSELRANKSPossible Reduction groups5CONVOBJECTConversion Objectnvarchar160
33CNVMBTSTEPSsteps / rules3CONVOBJECTConversion Objectnvarchar160
34CNVMBTTABLESexplicite list of tables to be handled during migration3CONVOBJECTConversion Objectnvarchar160
35CNVMBTTABSTRUCField list of tables for file transfer3CONVOBJECTConversion Objectnvarchar160
36CNVMBTTREEStructure of conversion object / hierachy3CONVOBJECTConversion Objectnvarchar160
37CNVMBTTRTRACKTo store tables configured for tracking6CONVOBJECTConversion Objectnvarchar160
38CNVTDMSBI_MULDATTo store the mulitple 'from dates' at infoarea level4CONVOBJECTConversion Objectnvarchar160
39CNVTDMSBW_ALLOBJAll Objects and their tables6CONVOBJECTConversion Objectnvarchar160
40CNVTDMSBW_EXLOBJObjects in BW system and conversion object mapping4CONVOBJECTConversion Objectnvarchar160
41CNVTDMSBW_ICSELSelection group id for Infocube4CONVOBJECTConversion Objectnvarchar160
42CNVTDMSBW_OBJDTObjects in BW system and conversion object mapping4CONVOBJECTConversion Objectnvarchar160
43CNVTDMSBW_SELGRPSelection groups of all objects5CONVOBJECTConversion Objectnvarchar160
44CNVTDMSEC_REDUCTable Reduction - Changed Tables4CONVOBJECTConversion Objectnvarchar160
45CNVTDMS_02_RUNdata transfer volume6CONVOBJECTConversion Objectnvarchar160
46CNVTDMS_03_CONFRConfrontation of org-independent group IDs3CONVOBJECTConversion Objectnvarchar160
47CNVTDMS_03_GROUPPossible Reduction groups5CONVOBJECTConversion Objectnvarchar160
48CNVTDMS_08_FIELDexplicite conversion rules for fields during migration4CONVOBJECTConversion Objectnvarchar160
49CNVTDMS_08_FIPARparameters for rules mentioned in cnvmbtfields4CONVOBJECTConversion Objectnvarchar160
50DTL_PRECALC_OBJPrecalculation tables for TDMS2CONVOBJECTnvarchar160
51IUUC_PARALL_CALCPrecalculation tables for IUUC initial load2CONVOBJECTTable Name for non-SAP tablesnvarchar300
52IUUC_PRECALC_OBJPrecalculation tables for IUUC initial load2CONVOBJECTTable Name for non-SAP tablesnvarchar300
TOPMigration
53TEMCNVIS-U Mig: Conversion objects1CONVOBJECTConversion objectnvarchar150
54TEMCNVTIS-U Mig: Conversion objects (text)2CONVOBJECTConversion objectnvarchar150
55TEMCNVTABIS-U Mig: Conversion table1CONVOBJECTConversion objectnvarchar150
56TEMRCIS-U Mig: Conversion rule (conversion definitions)5CONVOBJECTConversion objectnvarchar150
57TEMUSIS-U Mig.: Managmnt32CONVOBJECTConversion objectnvarchar150