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

101 columns | Print definition?ERP 6.0  | CREATEDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/CFUNC_DETFunction Information10CREATEDATEDatenvarchar80
2/AIF/FHEADFile header data8CREATEDATEDatenvarchar80
3/AIF/HINTSDB Table for saving the hints9CREATEDATEDatenvarchar80
4/AIF/LFA_DATAFile data for Lean File Adapter7CREATEDATEDatenvarchar80
5/ATL/FORECLOSUREForeclosures24CREATEDATESystem Datenvarchar80
6BBP_SUS_NEWSSRM-SUS: News Management by Purchaser3CREATEDATEDate for Newsnvarchar80
7CNVA_00555_HDRHeader table for Run Time Estimation package6CREATEDATEDate of Creation for the Runtime Estimation IDnvarchar80
8CNVA_00555_RUNIDHeader Information of Run Time Estimation Id9CREATEDATEDate of Creation for the Runtime Estimation IDnvarchar80
9CNVA_CCD_ANA_HDRHeader table for CC Deletion Analysis Package6CREATEDATEDatenvarchar80
10CNVA_CCD_ANA_SHDHeader table for CC Deletion Analysis Package in SolMan9CREATEDATEDatenvarchar80
11CNVA_PCREA_RUNIDHeader Information of Profit Center Reorganization8CREATEDATESystem Datenvarchar80
12DMC_BO_HEADERMWB: Business Objects (Header)8CREATEDATESystem Datenvarchar80
13DMC_CNTRLPARAMMWB: Control Parameters10CREATEDATESystem Datenvarchar80
14DMC_CU_RUN_HDRHeader record of a Content Upgrade Run5CREATEDATESystem Datenvarchar80
15DMC_DEVL_CSTEPSSP: Status table of ConvObj Work Steps (Development Env.)6CREATEDATESystem Datenvarchar80
16DMC_DW_TEMPLATEDynamic WHERE Clause Templates3CREATEDATESystem Datenvarchar80
17DMC_FIXEDVALUEMWB: Fixed Values13CREATEDATESystem Datenvarchar80
18DMC_PC_COBJSTEPSSP: Status table of ConvObj Work Steps (Processing Cockpit)6CREATEDATESystem Datenvarchar80
19DMC_PC_PROJSTEPSSP: Status table of Project Work Steps (Processing Cockpit)8CREATEDATESystem Datenvarchar80
20DMC_STREE_TRACEMWB: Trace storage for table DMC_STREE18CREATEDATESystem Datenvarchar80
21DMC_VARIABLEMWB: Variables17CREATEDATESystem Datenvarchar80
22DMC_VERSION_HDRVersion Data of an Object3CREATEDATET: Creation datenvarchar80
23ICFSRV4ADMINICF Services, which only have to be used for administration5CREATEDATESystem Datenvarchar80
24IUUC_RL_HEADERIUUC ReplicationLogging Content5CREATEDATEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
25IUUC_RL_TABLESIUUC ReplicationLogging Tables7CREATEDATEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
26THAEXT_TRANS_COPCommodity exposure pricing data5CREATEDATEE-HA: Date the Transaction is Creatednvarchar80
27THAEXT_TRAN_DCSPCommodity exposure DCS pricing data5CREATEDATEE-HA: Date the Transaction is Creatednvarchar80
28Z603TRAREQUESTTravelrequest - BIT6035CREATEDATEDatumnvarchar80
29ZRDB_DEL_DIR16.09.2009: Delete DIR37CREATEDATEAusgabedatum des Dokumentsnvarchar80
30HRP1724Database Table for Infotype 172421CREATEDATEDate On Which Academic Work Was Assigned to Where-Used Listnvarchar80
31HRP1725Database Table for Infotype 172522CREATEDATEDate On Which Academic Work Was Assigned to Where-Used Listnvarchar80
TOPBackground Processing
32SXPGCOSTABDefinition of logical OS commands(customer table)8CREATEDATESystem Datenvarchar80
33SXPGCOTABEDefinition of logical operating system commands(SAP table)8CREATEDATESystem Datenvarchar80
34SXPGHISTORHistory of Logical Commands11CREATEDATESystem Datenvarchar80
TOPClaims Management
35ICLINDRESReserve Lot4CREATEDATECreated Onnvarchar80
TOPClinical System
36N2DSERIESIS-H*MED RAD: Description of a DICOM image series5CREATEDATEGeneration date of a DICOM Objectnvarchar80
TOPCollectionsDisbursements
37DIMAPARSCPOSIO: Change to Scheduling Items6CREATEDATEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
38VVSCTRANSFERPayment Plan: Business Partner Transfer4CREATEDATEUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
TOPData Conversion
39DMC_ACTPDMC: Actual Parameters from Rule Call or Operator Call9CREATEDATESystem Datenvarchar80
40DMC_ANWDGDMC: Applications in the Direct Input Concept7CREATEDATESystem Datenvarchar80
41DMC_BAPIDMC: Master Data for BAPI Integration12CREATEDATESystem Datenvarchar80
42DMC_BIPDMC: Attributes for Standard Batch Input8CREATEDATESystem Datenvarchar80
43DMC_BWIBData from BW Query Inbound Processing5CREATEDATESystem Datenvarchar80
44DMC_BWQRYInbound Interface for BW Query8CREATEDATESystem Datenvarchar80
45DMC_CNTNContainer Type for Sender Structure Name Administration7CREATEDATESystem Datenvarchar80
46DMC_COBJDMC: Conversion Object11CREATEDATESystem Datenvarchar80
47DMC_COMPLComplex Data Structures5CREATEDATESystem Datenvarchar80
48DMC_DITDirect Input - Test Type7CREATEDATESystem Datenvarchar80
49DMC_DIWWrapper for Direct Input8CREATEDATESystem Datenvarchar80
50DMC_FDESCDMC: Description of Data to Be Imported7CREATEDATESystem Datenvarchar80
51DMC_FIELDDMC: Data Field of a Structure15CREATEDATESystem Datenvarchar80
52DMC_IDOCMaster Data for IDocs12CREATEDATESystem Datenvarchar80
53DMC_IFREGRegistration of Interfaces14CREATEDATESystem Datenvarchar80
54DMC_IOTMPLRegistry Entry for Inbound/Outbound Template9CREATEDATESystem Datenvarchar80
55DMC_IRULEDMC: Installed Rules10CREATEDATESystem Datenvarchar80
56DMC_ISBDMC Tool: Information about Direct Input 28CREATEDATESystem Datenvarchar80
57DMC_OPDMC: Rule Implementation Type9CREATEDATESystem Datenvarchar80
58DMC_PARAMDMC: Formal Parameters in Rule and Operation Calls11CREATEDATESystem Datenvarchar80
59DMC_PRJCTProject Management8CREATEDATESystem Datenvarchar80
60DMC_RCALLDMC: Representation of Rule or Operator Calls10CREATEDATESystem Datenvarchar80
61DMC_RSDATDMC: Information about Self-Defined Recipient Container5CREATEDATESystem Datenvarchar80
62DMC_RSRELDMC: Relations Between Sender/Recipient Structures10CREATEDATESystem Datenvarchar80
63DMC_RULEMapping Rules in DMC Tool12CREATEDATESystem Datenvarchar80
64DMC_SPRJCTSub-Projects (Conversion Object Administration)8CREATEDATESystem Datenvarchar80
65DMC_SSDATDMC: Information About Self-Defined Sender Container5CREATEDATESystem Datenvarchar80
66DMC_STREEDMC: Tree Structure for Administration of Structures15CREATEDATESystem Datenvarchar80
67DMC_STRUCTSender Structure or Recipient Structure11CREATEDATESystem Datenvarchar80
68DMC_SXDAMaster Data for SXDA10CREATEDATESystem Datenvarchar80
69DMC_TROBJDMC: Recoding Object Definition9CREATEDATESystem Datenvarchar80
70DMC_WSTEPSave and Display User Steps10CREATEDATESystem Datenvarchar80
71DMC_XMLDDMC: Administration of XML Descriptions6CREATEDATESystem Datenvarchar80
TOPDB2 for OS39
72DB2BPTUNEDB2/390: Buffer Pool Tuning Settings2CREATEDATESystem Datenvarchar80
73STU3COTABCDefinition of DB2 OS/390 and OS/390 Commands(Customer Table)13CREATEDATESystem Datenvarchar80
74STU3COTABSDefinition of DB2 for OS/390 and OS/390 Commands (SAP Table)13CREATEDATESystem Datenvarchar80
TOPDocument Management Framework
75SKWF_TRANSShadow Table for Namespace Transport30CREATEDATESystem Datenvarchar80
TOPFast Search Infrastructure
76SFSRFW_TIMESTime Measurement3CREATEDATEDate of Last Changenvarchar80
TOPFunds Management
77FMEUROPLANTable of Euro FM Areas4CREATEDATEField of type DATSnvarchar80
TOPHierarchy Storage
78TTREV_COMPVersions: Structure/Hierarchy Comparisons4CREATEDATECreated onnvarchar80
79TTREV_HCHIHeader table for structure versions6CREATEDATECreated onnvarchar80
80TTREV_HEADHeader table for structure versions4CREATEDATECreated onnvarchar80
TOPIndustry Solution Catch Weight Management
81CON_FIN_CKOMPUAllowance for Price Update13CREATEDATECreated onnvarchar80
TOPJob Pricing
82T71JPR06Survey Header Data6CREATEDATEDate on which Survey Data was Imported or Adjustednvarchar80
TOPMonitoring
83SQLRUSERCustomizing Table for SQL Trace Interpreter8CREATEDATESystem Datenvarchar80
84SQLRUSER1User Table for Groups for SQL Trace Interpreter5CREATEDATESystem Datenvarchar80
85SQLRUSER2User Table for Function for SQL Trace Interpreter4CREATEDATESystem Datenvarchar80
TOPSAP Business Workflow
86SWU5_DYNPChronology of generated program objects11CREATEDATESystem Datenvarchar80
87SWXFORMABSForm: Notification of Absence5CREATEDATEDatenvarchar80
88SWXTRAREQUESTTravel Request5CREATEDATEDatenvarchar80
TOPSAP NetWeaver Mobile - Use subcomponents
89MDK_INVENTORYMDK Inventory Example - Data Table8CREATEDATECreated onnvarchar80
90MISYNMSGMI System News Messages10CREATEDATECreation Date of System Messagenvarchar80
TOPShared Service Center Framework
91SSCSRservice request in backend10CREATEDATECreation Date for Service Requestnvarchar80
TOPTransaction Manager
92THAEXT_TRANS_COTransaction for commodity price exposure5CREATEDATEE-HA: Date the Transaction is Creatednvarchar80
93THMEXT_TRANS_FXE-HA: Transactions5CREATEDATEE-HA: Date the Transaction is Creatednvarchar80
94THMEXT_TRANS_IRE-HA: IR Transactions5CREATEDATEE-HA: Date the Transaction is Creatednvarchar80
TOPTransport Management System
95CTWFPROPOSTransport Proposal: Header4CREATEDATEDatenvarchar80
TOPTransport Organizer
96GUPDLAYOUTList of Table Layouts that Need to Be Updated7CREATEDATEDate of Last Changenvarchar80
TOPUpgrade - General
97MERGEMAPSHeader Information for Merge Maps7CREATEDATEDate of Last Changenvarchar80
TOPWorkforce Management Application
98WFATM_SC_LOGAudit Trail of WFM ESS Schedule Change7CREATEDATEDatenvarchar80
99WFATM_SR_LOGAudit Trail of WFM ESS Schedule Rule Change9CREATEDATEDatenvarchar80
TOPWorkforce Management Core
100WFMTM_SC_LOGAudit Trail of WFM ESS Schedule Change7CREATEDATEDatenvarchar80
101WFMTM_SR_LOGAudit Trail of WFM ESS Schedule Rule Change8CREATEDATEDatenvarchar80