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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

50 columns | Print definition?ERP 6.0  | SUBPROJECT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVHCM_ADR_GRPTDMS4HCM: VADM address group3SUBPROJECTIdentification of MBT Subprojectnvarchar200
2CNVHCM_CLSTDEFTDMS4HCM: Definitions of PCLn Clusters3SUBPROJECTIdentification of MBT Subprojectnvarchar200
3CNVHCM_EXCLUDETDMS4HCM: Object types and infotypes excluded from transfer3SUBPROJECTIdentification of MBT Subprojectnvarchar200
4CNVHCM_MOLGATDMS4HCM: Molga for the Package3SUBPROJECTIdentification of MBT Subprojectnvarchar200
5CNVHCM_SWITCHESTDMS4HCM: Switches3SUBPROJECTIdentification of MBT Subprojectnvarchar200
6CNVHCM_TARGETSTDMS4HCM: User specific key target ranges3SUBPROJECTIdentification of MBT Subprojectnvarchar200
7CNVMBTACTIVEactive packages and current phase2SUBPROJECTIdentification of MBT Subprojectnvarchar200
8CNVMBTATTACHMENTAttachments3SUBPROJECTIdentification of MBT Subprojectnvarchar200
9CNVMBTCODEAPPCodeAppends3SUBPROJECTIdentification of MBT Subprojectnvarchar200
10CNVMBTDEXHEADDMIS PCL Data Extract Header information15SUBPROJECTIdentification of MBT Subprojectnvarchar200
11CNVMBTNOTESNotes3SUBPROJECTIdentification of MBT Subprojectnvarchar200
12CNVMBTPACKpackage information/creator/creation date/scenarion10SUBPROJECTIdentification of MBT Subprojectnvarchar200
13CNVMBTSCAPPLScrambling Applications3SUBPROJECTIdentification of MBT Subprojectnvarchar200
14CNVMBTSCCDSETConditionSet3SUBPROJECTIdentification of MBT Subprojectnvarchar200
15CNVMBTSCCDSETTConditionSetText3SUBPROJECTIdentification of MBT Subprojectnvarchar200
16CNVMBTSCCUCOScramblingRule Code Customizing3SUBPROJECTIdentification of MBT Subprojectnvarchar200
17CNVMBTSCCUCOPARSScramble Rule Parameters3SUBPROJECTIdentification of MBT Subprojectnvarchar200
18CNVMBTSCFDSETFieldSet3SUBPROJECTIdentification of MBT Subprojectnvarchar200
19CNVMBTSCFDSETTFieldSetText3SUBPROJECTIdentification of MBT Subprojectnvarchar200
20CNVMBTSCGRPScramblingGroup3SUBPROJECTIdentification of MBT Subprojectnvarchar200
21CNVMBTSCGRPTScramblingGroupText3SUBPROJECTIdentification of MBT Subprojectnvarchar200
22CNVMBTSCKYSETKeySet3SUBPROJECTIdentification of MBT Subprojectnvarchar200
23CNVMBTSCOPRDOperands3SUBPROJECTIdentification of MBT Subprojectnvarchar200
24CNVMBTSCSCCUScramblingRule Customizing3SUBPROJECTIdentification of MBT Subprojectnvarchar200
25CNVMBTSCSCCUTScramblingRule Customizing3SUBPROJECTIdentification of MBT Subprojectnvarchar200
26CNVMBTSCSCRLScramblingRule3SUBPROJECTIdentification of MBT Subprojectnvarchar200
27CNVMBTSCSCRLTScramblingRule Text3SUBPROJECTIdentification of MBT Subprojectnvarchar200
28CNVMBTSCSETScramblingSet3SUBPROJECTIdentification of MBT Subprojectnvarchar200
29CNVMBTSCSETTScramblingSetText3SUBPROJECTIdentification of MBT Subprojectnvarchar200
30CNVMBTSUBPROJECTsupprojects / mass transfer ID- relation to project2SUBPROJECTIdentification of MBT Subprojectnvarchar200
31CNVMBTUSEDMTIDSUsed and obsolete MTIDs2SUBPROJECTIdentification of MBT Subprojectnvarchar200
32CNVMBTUSRSUBPROJConversion: User locking and unlocking2SUBPROJECTIdentification of MBT Subprojectnvarchar200
33DMC_MT_HEADERDMC: Header Record of a Mass Data Transfer6SUBPROJECTSubproject Identifiersnvarchar200
TOPData Conversion
34DMC_COBJDMC: Conversion Object2SUBPROJECTMWB: GUID of a Subprojectnvarchar220
35DMC_UDATDMC: Administration of User-Specific Settings4SUBPROJECTSubproject Identifiersnvarchar200
TOPData Transfer Workbench
36DXATTRIBTask Attributes3SUBPROJECTData Transfer Subprojectnvarchar150
37DXATTRIB2Attributes of Task of Type MAP LSMW3SUBPROJECTData Transfer Subprojectnvarchar150
38DXATTRIB3Attribute of Task of Type Split3SUBPROJECTData Transfer Subprojectnvarchar150
39DXATTRIB4Attributes of Task of Type MAP DMCW3SUBPROJECTData Transfer Subprojectnvarchar150
40DXFILETRANSPContainer for Transporting Data Information5SUBPROJECTData Transfer Subprojectnvarchar150
41DXLOASTATStatus of 'Load via BAPI'3SUBPROJECTData Transfer Subprojectnvarchar150
42DXRELATAssignment of Files to Tasks3SUBPROJECTData Transfer Subprojectnvarchar150
43DXRUNData Transfer Run to R/33SUBPROJECTData Transfer Subprojectnvarchar150
44DXRUNDEFRun Definition of Mass Data Transfer to R/33SUBPROJECTData Transfer Subprojectnvarchar150
45DXRUNDEF_TRun Definition Texts for Mass Data Transfer4SUBPROJECTData Transfer Subprojectnvarchar150
46DXSUBPROSub-Projects for Mass Data Transfer to R/33SUBPROJECTData Transfer Subprojectnvarchar150
47DXSUBPRO_TSub-Project Texts for Mass Data Transfer to R/34SUBPROJECTData Transfer Subprojectnvarchar150
48DXTASKSTasks for Mass Data Transfer to R/33SUBPROJECTData Transfer Subprojectnvarchar150
49DXTASKS_TTask Texts for Mass Data Transfer to R/34SUBPROJECTData Transfer Subprojectnvarchar150
TOPMarketing, Accounting and Pricing
50OIC_CPE_FO_LINKRelationship Between F&A Formula and CPE Formula15SUBPROJECTSubprojectnvarchar150