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

124 columns | Print definition?ERP 6.0  | CHANGEDATE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/AIF/FHEADFile header data11CHANGEDATEDatenvarchar80
2CNVA_00555_RUNIDHeader Information of Run Time Estimation Id11CHANGEDATEDate of Execution of the Runtime Estimation IDnvarchar80
3CNVA_CCD_ANA_SHDHeader table for CC Deletion Analysis Package in SolMan11CHANGEDATEDatenvarchar80
4CNVA_PCREA_RUNIDHeader Information of Profit Center Reorganization11CHANGEDATESystem Datenvarchar80
5CNVTDMS_04_TABTable Pool for TDMS MD&C13CHANGEDATESystem Datenvarchar80
6DMC_BO_HEADERMWB: Business Objects (Header)10CHANGEDATESystem Datenvarchar80
7DMC_CNTRLPARAMMWB: Control Parameters8CHANGEDATESystem Datenvarchar80
8DMC_CNTRLPARAMCCustomizing Control Parameters5CHANGEDATESystem Datenvarchar80
9DMC_CU_RUN_HDRHeader record of a Content Upgrade Run8CHANGEDATESystem Datenvarchar80
10DMC_DEVL_CSTEPSSP: Status table of ConvObj Work Steps (Development Env.)9CHANGEDATESystem Datenvarchar80
11DMC_DW_TEMPLATEDynamic WHERE Clause Templates5CHANGEDATESystem Datenvarchar80
12DMC_FIXEDVALUEMWB: Fixed Values11CHANGEDATESystem Datenvarchar80
13DMC_FIXEDVALUECCustomizing Fixed Values5CHANGEDATESystem Datenvarchar80
14DMC_IU_T000MWB: Backup Copy of Table T00016CHANGEDATEDate of Last Changenvarchar80
15DMC_PC_COBJSTEPSSP: Status table of ConvObj Work Steps (Processing Cockpit)9CHANGEDATESystem Datenvarchar80
16DMC_PC_PROJSTEPSSP: Status table of Project Work Steps (Processing Cockpit)11CHANGEDATESystem Datenvarchar80
17DMC_RULECMWB: Customizing of rules5CHANGEDATESystem Datenvarchar80
18DMC_STREE_TRACEMWB: Trace storage for table DMC_STREE16CHANGEDATESystem Datenvarchar80
19DMC_VARIABLEMWB: Variables15CHANGEDATESystem Datenvarchar80
20GSWCGRP_SERVER_AComponent --- Group17CHANGEDATEDate of Last Changenvarchar80
21GTABKEYEXC_ARCHException List: Global Key Check20CHANGEDATEDate of Last Changenvarchar80
22GTABKEY_ARCHIVEGlobal Key Entries from Requests/Tasks18CHANGEDATEDate of Last Changenvarchar80
23IUUC_PROCOPT_CHNChange log for Process Option changes6CHANGEDATESystem Datenvarchar80
24IUUC_RL_HEADERIUUC ReplicationLogging Content7CHANGEDATEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
25IUUC_RL_TABLESIUUC ReplicationLogging Tables9CHANGEDATEUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
26ZLANGIEClients in IDES6CHANGEDATEDate of Last Changenvarchar80
27ZSKSYSUSERuser in den IDES-Systemen17CHANGEDATEnvarchar80
28T7PIQ_NL_EDUCEducation Details4CHANGEDATELast Changed Onnvarchar80
29T7PIQ_NL_EDUPGMEducational Program Details7CHANGEDATELast Changed Onnvarchar80
30T7PIQ_NL_INSTITInstitutes and Education Details5CHANGEDATELast Changed Onnvarchar80
TOPBackground Processing
31SXPGCOSTABDefinition of logical OS commands(customer table)11CHANGEDATESystem Datenvarchar80
32SXPGCOTABEDefinition of logical operating system commands(SAP table)11CHANGEDATESystem Datenvarchar80
33SXPGHISTORHistory of Logical Commands4CHANGEDATESystem Datenvarchar80
TOPBusiness Configuration Sets
34SCPRSTRANSPSwitch BC Sets: Transport Recording Tables4CHANGEDATEDatenvarchar80
TOPBusiness Planning and Simulation
35UPS_CHANGELOGChange Log for Status8CHANGEDATEField of type DATSnvarchar80
36UPS_LOCKSLock Table for Status and Tracking System7CHANGEDATEField of type DATSnvarchar80
TOPClient Copy
37CCC_CHECKClient dummy19CHANGEDATEDate of Last Changenvarchar80
38T000Clients16CHANGEDATEDate of Last Changenvarchar80
TOPContract Accounts Receivable and Payable
39FKKSTEPCOUNTSkipped Collection Steps per Dunning Group9CHANGEDATEDatenvarchar80
TOPCross-Application Components
40AFPOSTPROCPostprocessing Status after Installation/Upgrade/SP9CHANGEDATELast Changed Onnvarchar80
41CRMMASSUPD_ACTHistory Table, Activation/Deactivation of Mass Data Handling5CHANGEDATELast Changed Onnvarchar80
42CRMRFCPARDefinitions for RFC Connections18CHANGEDATELast Changed Onnvarchar80
TOPData Conversion
43DMC_ACTPDMC: Actual Parameters from Rule Call or Operator Call10CHANGEDATESystem Datenvarchar80
44DMC_ANWDGDMC: Applications in the Direct Input Concept5CHANGEDATESystem Datenvarchar80
45DMC_BAPIDMC: Master Data for BAPI Integration13CHANGEDATESystem Datenvarchar80
46DMC_BIPDMC: Attributes for Standard Batch Input9CHANGEDATESystem Datenvarchar80
47DMC_BWIBData from BW Query Inbound Processing6CHANGEDATESystem Datenvarchar80
48DMC_BWQRYInbound Interface for BW Query7CHANGEDATESystem Datenvarchar80
49DMC_CNTNContainer Type for Sender Structure Name Administration5CHANGEDATESystem Datenvarchar80
50DMC_COBJDMC: Conversion Object9CHANGEDATESystem Datenvarchar80
51DMC_COMPLComplex Data Structures4CHANGEDATESystem Datenvarchar80
52DMC_DITDirect Input - Test Type6CHANGEDATESystem Datenvarchar80
53DMC_DIWWrapper for Direct Input6CHANGEDATESystem Datenvarchar80
54DMC_FDESCDMC: Description of Data to Be Imported8CHANGEDATESystem Datenvarchar80
55DMC_FIELDDMC: Data Field of a Structure13CHANGEDATESystem Datenvarchar80
56DMC_IDOCMaster Data for IDocs11CHANGEDATESystem Datenvarchar80
57DMC_IFREGRegistration of Interfaces15CHANGEDATESystem Datenvarchar80
58DMC_IOTMPLRegistry Entry for Inbound/Outbound Template10CHANGEDATESystem Datenvarchar80
59DMC_IRULEDMC: Installed Rules11CHANGEDATESystem Datenvarchar80
60DMC_ISBDMC Tool: Information about Direct Input 29CHANGEDATESystem Datenvarchar80
61DMC_OPDMC: Rule Implementation Type7CHANGEDATESystem Datenvarchar80
62DMC_PARAMDMC: Formal Parameters in Rule and Operation Calls9CHANGEDATESystem Datenvarchar80
63DMC_PRJCTProject Management6CHANGEDATESystem Datenvarchar80
64DMC_RCALLDMC: Representation of Rule or Operator Calls8CHANGEDATESystem Datenvarchar80
65DMC_RSDATDMC: Information about Self-Defined Recipient Container4CHANGEDATESystem Datenvarchar80
66DMC_RSRELDMC: Relations Between Sender/Recipient Structures8CHANGEDATESystem Datenvarchar80
67DMC_RULEMapping Rules in DMC Tool13CHANGEDATESystem Datenvarchar80
68DMC_SPRJCTSub-Projects (Conversion Object Administration)6CHANGEDATESystem Datenvarchar80
69DMC_SSDATDMC: Information About Self-Defined Sender Container4CHANGEDATESystem Datenvarchar80
70DMC_STREEDMC: Tree Structure for Administration of Structures13CHANGEDATESystem Datenvarchar80
71DMC_STRUCTSender Structure or Recipient Structure8CHANGEDATESystem Datenvarchar80
72DMC_SXDAMaster Data for SXDA9CHANGEDATESystem Datenvarchar80
73DMC_TROBJDMC: Recoding Object Definition7CHANGEDATESystem Datenvarchar80
74DMC_WSTEPSave and Display User Steps9CHANGEDATESystem Datenvarchar80
75DMC_XMLDDMC: Administration of XML Descriptions4CHANGEDATESystem Datenvarchar80
TOPDatabase Interface, Database Platforms
76DB6NAVSYSTDB6: System Registration Table18CHANGEDATESystem Datenvarchar80
TOPDB2 for OS39
77DB2JUTSO User on OS/3902CHANGEDATEField type date, YYYYMMDDnvarchar80
78STU3COTABCDefinition of DB2 OS/390 and OS/390 Commands(Customer Table)16CHANGEDATESystem Datenvarchar80
79STU3COTABSDefinition of DB2 for OS/390 and OS/390 Commands (SAP Table)16CHANGEDATESystem Datenvarchar80
TOPI18N Unicode
80CONTAINERINFOCollection of all Container Fields11CHANGEDATESystem Datenvarchar80
81UM4EXCEPSPUMG: Exception table to UMGCCTL14CHANGEDATEnvarchar80
82UMGEXCEPSPUMG: Exception table to UMGCCTL14CHANGEDATEDate data element for SYSTnvarchar80
TOPIndustry Solution Catch Weight Management
83CON_FIN_CKOMPUAllowance for Price Update16CHANGEDATEDate of last changenvarchar80
TOPInteractive Drilldown Reporting
84TAPPLCLASSHIEApplication Classes in the Hierarchy Interface2CHANGEDATEChanged onnvarchar80
TOPLoans Management
85VDSTOP_VDARL_AAssign Stop to Loan12CHANGEDATELast Edited onnvarchar80
TOPMaterials Management
86/ISDFPS/CS_EXLSTException List: Overwritten Purchase Requisitions6CHANGEDATEChange Datenvarchar80
TOPMaxDB
87SDBSYSTEMSOverview of Integrated SAP DB and liveCache Systems5CHANGEDATESystem Datenvarchar80
TOPMonitoring
88SQLRUSERCustomizing Table for SQL Trace Interpreter11CHANGEDATESystem Datenvarchar80
89SQLRUSER1User Table for Groups for SQL Trace Interpreter8CHANGEDATESystem Datenvarchar80
90SQLRUSER2User Table for Function for SQL Trace Interpreter7CHANGEDATESystem Datenvarchar80
TOPOrganizational Management
91T77OMIFDETHierarchy Framework: Interface for Detail Objects4CHANGEDATEName of Function Modulenvarchar300
92T77OMIFOVEHierarchy Framework: Overview Object Interface4CHANGEDATEName of Function Modulenvarchar300
93T77OMIFSTAHierarchy Framework: Status Object Interface3CHANGEDATEName of Function Modulenvarchar300
TOPPersonnel Administration
94T51B1HR-ARC: Global Characteristics of Archiving Group13CHANGEDATEDatenvarchar80
TOPProduct Configurator
95COMM_CFGKBRuntime Version of SCE Knowledge Base18CHANGEDATEKB validity datenvarchar80
TOPReportReport Interface
96TAPPLCLASSApplication Classes in Drilldown Reporting2CHANGEDATEChanged Onnvarchar80
97TRSTTTText Table for the Reporting Tools4CHANGEDATEChanged Onnvarchar80
TOPSales and Distribution
98SCEKBRuntime Version of SCE Knowledge Base12CHANGEDATEChanged Onnvarchar80
99SCEKBOBJKnowledge-Base Object (SCE)10CHANGEDATEChanged Onnvarchar80
TOPSAP NetWeaver Mobile - Use subcomponents
100MDK_INVENTORYMDK Inventory Example - Data Table11CHANGEDATELast Changed onnvarchar80
TOPSCM Basis
101CRCIFKAPIDObject IDs for Changed Capacities7CHANGEDATEDatenvarchar80
TOPService Data Download
102/SDF/CMO_T_53CMO Service: Clients of DEV system16CHANGEDATEnvarchar80
103/SDF/CMO_T_54CMO Service: Clients of QAS system16CHANGEDATEnvarchar80
104/SDF/SWCM_T000_PClients of PRD16CHANGEDATEnvarchar80
TOPTable Maintenance Tool
105VCLDIRViewcluster directory2CHANGEDATE(8-character) Date for SYSTnvarchar80
TOPTranslation Tools
106LANGTR2Translation exclusions6CHANGEDATEDate of Last Changenvarchar80
107LANGUSRObsolete table -> do not use6CHANGEDATEDate of Last Changenvarchar80
108LANG_MANDTObsolete table; do not use5CHANGEDATEDate of Last Changenvarchar80
109LXE_CO_2HHeader Data for Collection Groups5CHANGEDATEDate of Last Changenvarchar80
110LXE_DIS_OObject Type Selection for Automatic Distribution6CHANGEDATEDate of Last Changenvarchar80
111TRNL_DC_2HHeader Data for Groups of Development Classes5CHANGEDATEDate of Last Changenvarchar80
112TRNL_DIS_OGroup Selection for Automatic Distribution5CHANGEDATEDate of Last Changenvarchar80
113TRNL_LANGTranslation Environment: Target Languages and Attributes 13CHANGEDATEDate of Last Changenvarchar80
114TRNL_OTRSettings for OTR8CHANGEDATEDate of Last Changenvarchar80
115TRNL_OTR_SSettings for OTR9CHANGEDATEDate of Last Changenvarchar80
116TRNL_PROFTranslation Authorization Profiles4CHANGEDATEDate of Last Changenvarchar80
117TRNL_USERTranslators7CHANGEDATEDate of Last Changenvarchar80
TOPTransport Organizer
118TRNSPACETSL: Namespaces (Transportable)8CHANGEDATEDate of Last Changenvarchar80
TOPUpgrade - General
119MERGEMAPSHeader Information for Merge Maps10CHANGEDATEDate of Last Changenvarchar80
TOPWorkforce Management Application
120WFATM_SC_LOGAudit Trail of WFM ESS Schedule Change9CHANGEDATEDatenvarchar80
121WFATM_SR_LOGAudit Trail of WFM ESS Schedule Rule Change11CHANGEDATEDatenvarchar80
TOPWorkforce Management Core
122WFMTM_SC_LOGAudit Trail of WFM ESS Schedule Change9CHANGEDATEDatenvarchar80
123WFMTM_SR_LOGAudit Trail of WFM ESS Schedule Rule Change10CHANGEDATEDatenvarchar80
TOPWorkplace Server
124TWPPRSTIMETime Stamp: Last Change to the Personalization Data3CHANGEDATEPersonalization Information Changed Onnvarchar80