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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

68 columns | Print definition?ERP 6.0  | COMMENTS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/ARBA/INVCOMMENTInvoice Status update comments table5COMMENTSMessage Textnvarchar2200
2/CPD/D_MP_MEMBERProject Member7COMMENTSCommentsnvarchar2550
3/CPD/D_MP_ST_ARVTable for Status Area version8COMMENTSKey Message for Review Periodnvarchar400
4/CPD/D_MP_ST_HRAStatus Header Area8COMMENTSKey Message for Review Periodnvarchar400
5/SAPPSSRM/MATRAttributes7COMMENTSComment on Dynamic Attributenvarchar2550
6ARC_DESTR_DBRUNDestruction Run for Data on the Database5COMMENTSDescription of a Data Destruction Runnvarchar700
7BBP_TMP_ZA_ASPTemporary: Request 'Bidder', Contact Addresses70COMMENTSNotes for Partnernvarchar400
8CNVA_PCREA_AA_CPC Reorg Analysis: FI-AA Profit Center assignments18COMMENTSComment/Reasonnvarchar400
9CNVCMIS_A_OPFILEOptical Archiving file13COMMENTSNote for an archive filenvarchar600
10CNVCMIS_A_WFRESComparison result for Workflow data in Sender & Receiver17COMMENTSnvarchar2500
11CNVC_CCE_STATTCustomizing Comparison Descriptions for Status and Comments6COMMENTSChar60nvarchar600
12CNVMBTACTIVITYUnique ID for all activities,information about execution20COMMENTSDescription Fieldnvarchar600
13CNVMBTACTIVITYTText table for CNVMBTACTIVITIES5COMMENTSDescription Fieldnvarchar600
14CNVMBTACTPARAMSParameters for Activities16COMMENTSnvarchar600
15CNVMBTISCNTRLIs: Control Table9COMMENTSDescription Fieldnvarchar600
16CNVMBTISCONTRLIs: Control Table new9COMMENTSDescription Fieldnvarchar600
17CNVMBTISOBJIS: List of tables relavant for merge functionality4COMMENTSDescription Fieldnvarchar600
18CNVMBTJOBSCMBT PCL: Batch-related information12COMMENTSnvarchar600
19CNVMBTJOBSCTMBT PCL: Batch-related technical control9COMMENTSnvarchar600
20CNVMBTMODIFINFOMBT PCL: Setting for modifiable system information12COMMENTSnvarchar600
21CNVMBTPEBPARAMSParameters for process execution blocks17COMMENTSnvarchar600
22CNVMBTRESETVARVariants for the reset activities7COMMENTSDescription Fieldnvarchar600
23CNVMBTRESETVAR_MMaster table for creation of activity status reset variant4COMMENTSDescription Fieldnvarchar600
24CNVMBTSUBPARAMSParameters for Subactivities18COMMENTSnvarchar600
25CNVTDMSEHPCONTRLControl Table for TDMS EhP9COMMENTSDescription Fieldnvarchar600
26CNVTDMS_06_EXHRTDMS: HR Integration - Exclude/Include HR7COMMENTSDescription Fieldnvarchar600
27CNV_02300_NOTESContains the list of SAP Notes required before migration15COMMENTSCommentnvarchar800
28CNV_10993_FORMRSResult table for Forms13COMMENTSCommentsnvarchar800
29CNV_10993_MAILMaiing details10COMMENTSCommentsnvarchar800
30CNV_10993_RESHDRCoding Scan Result header table11COMMENTSCommentsnvarchar800
31CNV_10993_RESULTCoding Scan 10993 Search Run Result Table18COMMENTSCommentsnvarchar800
32COPC_RPR_VAR_VLCOPC: RPR variant value46COMMENTSntext10737418230
33FITDKWC_LOSS_TTexts to Losses Carried Forward5COMMENTSCommentsnvarchar600
34GRACANALYZEDOBJAnalyzed Objects6COMMENTSDescriptionnvarchar1320
35GRACEXCLUDEDOBJSAC batch Risk Analysis Excluded objects.7COMMENTSDescriptionnvarchar1320
36SFTT_EQUIEquipment Status diary9COMMENTSEquipment Status Commentsnvarchar1000
37SFTT_SNShift Notes: Master Data14COMMENTSSN Commentsnvarchar1000
38STODOINFInformationen zu TODO Meldungen17COMMENTSAnmerkungen zu der Meldungntext10737418230
39T7CNREW_APRHISPayroll approval item history8COMMENTSApprvoal Item Commentsntext10737418230
40ZEHPRC_D_CM_SMLTConflict Mineral Smelter Data9COMMENTSCommentsnvarchar2550
TOPArchive Development Kit
41ADMI_FILESArchive Files of Archive Sessions10COMMENTSNote for an archive filenvarchar600
42ADMI_JOBSArchive Jobs11COMMENTSArchiving Session Notenvarchar600
43ADMI_RUNArchive Runs Header Data7COMMENTSArchiving Session Notenvarchar600
44ADMI_XRUNArchiving Session for XML Archiving Objects9COMMENTSArchiving Session Notenvarchar600
TOPASAP Tools and Contents
45SMAPBP0Solution Map: Best Practice3COMMENTSSolution Map: Doc. IDnvarchar320
46SMAPPR0Solution Map: Process category, main process, process13COMMENTSSolution Map: Doc. IDnvarchar320
TOPCapacity and Resource Planning
47/MRSS/D_RM_CANDCandidates for Demands8COMMENTSComments for Partnernvarchar2550
TOPData Retention Tool
48TXW_R_STATStatus/Trace for TXW-data retrieval from archives11COMMENTSArchiving Session Notenvarchar600
TOPE-Recruiting
49HRP5123Database Table for Infotype 512318COMMENTSComments for Legal Hold (Pointer)nvarchar60
TOPGovernance, Risk and Compliance
50GRFNMDCRMaster Data Change Request13COMMENTSntext10737418230
TOPGRC Access Control Plug-In
51/VIRSA/DTCWKFLOWMitigation Work flow Table22COMMENTSChar255nvarchar2550
TOPInteraction Center WebClient
52CRMC_IC_EMAILEmail client customizing table13COMMENTSCommentsnvarchar400
TOPIRM Run Time
53LRM_T_OT_POL_ORIPolicy (Origin)10COMMENTSComment for Policynvarchar2550
TOPLocalization
54J_3RFCNTMaintain Internal Contract Numbers9COMMENTSCommentsnvarchar800
TOPMaintenance Orders
55/MRSS/D_SQP_EAPPEmployee Profile : Approval details6COMMENTSCommentsnvarchar2550
TOPNon Profit Organizations
56T7UNCMT_LOADSCMT Deliveries Loads Executed7COMMENTSnvarchar2500
TOPProcess Controls
57GRPCAODDATAaod data10COMMENTSTextnvarchar1000
58GRPCAODGROUPaod group8COMMENTSCommentntext10737418230
59GRPCQANSWERSurvey question answers6COMMENTSAnswer commentsntext10737418230
60GRPCTESTRESULTResults for test steps7COMMENTSTest commentsntext10737418230
TOPProject Management
61DPR_CONF_DETProject Management Confirmation: Detail Fields of Tasks10COMMENTSCommentntext10737418230
TOPRoyalty Reporting
62OIUREP_FIELDSRegulatory Report Master Data set up14COMMENTSReg.Reporting Comments maintainable on field levelnvarchar10
63OIUREP_REPORTSSupported Regulatory reports14COMMENTSReg.Reporting Comments maintainable on field levelnvarchar10
TOPService Processing
64/WSCGMBH/C_ASSIGClickSchedule: Assignment9COMMENTSCommentnvarchar500
TOPShip
65CMS_SHPDescription of a Ship - Master Table22COMMENTSDescriptionnvarchar400
TOPSmart Forms
66SSFOBJSCRSAP Smart Forms: Object/Screen Fields Assignment8COMMENTSntext10737418230
TOPWorkforce Management Application
67WFA_SCHEDULESchedule Table10COMMENTSSchedule Commentsnvarchar2550
TOPWorkforce Management Core
68WFMCAS_SCHEDULESchedule Table10COMMENTSSchedule Commentsnvarchar2550