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

143 columns | Print definition?ERP 6.0  | OBJECTNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_COA_OTHERSMapping for other objects 'Old/New'6OBJECTNAMESet name (for object type SETVAL)nvarchar400
2CODD_MAPPINGDefault Mapping from C4C2OBJECTNAMEObject Namenvarchar300
3CODD_OBJECTRelationship Suite BC object - ByD BCO/GDT2OBJECTNAMEObject Namenvarchar300
4CODD_PREFIXESThe prefixes that C4C supports for customer entries2OBJECTNAMEObject Namenvarchar300
5CODD_TABLESSuite BCO table2OBJECTNAMEObject Namenvarchar300
6DB2CONVTOOLDB2 z/OS: Recommendations for data conversions2OBJECTNAMEObject name (table, index, column)nvarchar1280
7DDLDEPENDENCYDD: Objects in a DDL Source2OBJECTNAMEName of the ABAP Dictionary objectnvarchar300
8DMC_MDS_OBJMObject Method1OBJECTNAMEObject Namenvarchar300
9MDG_RD_MAPPINGMapping table for Reference Data2OBJECTNAMEObject Namenvarchar300
10MDS_OBJHMDS: OBJH to a specific simulation version2OBJECTNAMEObject Namenvarchar300
11MDS_OBJMMDS: OBJM to a specific simulation version2OBJECTNAMEObject Namenvarchar300
12MDS_OBJSMDS: OBJS to a specific simulation version2OBJECTNAMEObject Namenvarchar300
13MDS_OBJSLMDS: OBJSL to a specific simulation version2OBJECTNAMEObject Namenvarchar300
14OBJMAPISOBJ: API called by an after import method1OBJECTNAMEObject Namenvarchar300
15OBJMAUTHSOBJ: Authorization objects locking AIM data1OBJECTNAMEObject Namenvarchar300
16OBJMTTables accessed by an After Import Method1OBJECTNAMEObject Namenvarchar300
17OBJMTTXText table for OBJMT2OBJECTNAMEObject Namenvarchar300
18OBJM_EXTExtension of OBJM1OBJECTNAMEObject Namenvarchar300
19OBJM_REFSOBJ: Reference to AIM meta data of another transport object1OBJECTNAMEObject Namenvarchar300
20OBJM_SRELExtension of OBJM: start release configuration1OBJECTNAMEObject Namenvarchar300
21PPH_HANA_ACTIVEObjects in Which DB Optimization Is to Be Used2OBJECTNAMEObject Name in Object Directorynvarchar400
22TACO1Table for activating DD objects2OBJECTNAMEName of the ABAP Dictionary objectnvarchar300
23TACOBTable for activating DD objects2OBJECTNAMEName of the ABAP Dictionary objectnvarchar300
24TKENRNames for CO development objects4OBJECTNAMEName of the ABAP Dictionary objectnvarchar300
TOPABAP Runtime Environment
25DDLOADDR3load-data table for migration1OBJECTNAMEObject Name in Object Directorynvarchar400
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
26TMAGETable for mass activator2OBJECTNAMEName of the ABAP Dictionary objectnvarchar300
TOPBAPI Tools for BAPIs see Note 813411
27BATMANSQTcontains the BAPI sequence to be tested5OBJECTNAMEObject namenvarchar320
TOPBasic Data
28TIVJUMP01REMD Direct Entry: Transaction Determination1OBJECTNAMEREMD Direct Entry: Object Namenvarchar120
29TIVJUMP02REMD Direct Entry: OK Code Determination1OBJECTNAMEREMD Direct Entry: Object Namenvarchar120
TOPBusiness Configuration Sets
30SCPRACPMBC Sets: Activation Logs (Messages)5OBJECTNAMEObject Namenvarchar300
31SCPRACPRBC Sets: Activation Logs (Activated Data Records)3OBJECTNAMEObject Namenvarchar300
32SCPRCOBJBC Set: Manually maintained cust. object tables1OBJECTNAMEObject Namenvarchar300
33SCPREXCPTBC Set: Control Table for Exceptions1OBJECTNAMEObject Namenvarchar300
34SCPRMRPMBC Sets in SFW: Migration Report Messages10OBJECTNAMEObject Namenvarchar300
35SCPRRECABC Set: BC Set record attributes5OBJECTNAMEObject Namenvarchar300
36SCPRSRECASwitch BC Set: BC Set Data Record Attributes5OBJECTNAMEObject Namenvarchar300
37SCPRSREVERTOWNERRevert SBCSets: Which rows were touched by which BCSet4OBJECTNAMEObject Namenvarchar300
38SCPRSREVERTOWNRDRevert SBCSets: Which rows were touched by which BCSet5OBJECTNAMEObject Namenvarchar300
39SCPRSREVERTOWNRIRevert SBCSets: Which rows were touched by which BCSet4OBJECTNAMEObject Namenvarchar300
TOPCCMS Database Monitors for Oracle
40ORAPARTGENDDLGenerated DDL Statements for partitioning3OBJECTNAMEnvarchar300
TOPCross-Application Components
41CRMMASSUPDMass Data Handling for Adapter Objects: Technical Settings4OBJECTNAMEObject Namenvarchar150
42CRMMASSUPD_ACTHistory Table, Activation/Deactivation of Mass Data Handling4OBJECTNAMEObject Namenvarchar150
43CRMMASSUPD_CUSSettings for Mass Data Handling4OBJECTNAMEObject Namenvarchar150
44SPRTL0Business Objects That Are Released for Drag&Relate1OBJECTNAMEDrag&Relate: Object Typenvarchar100
45SPRTL0CBusiness Objects for Drag&Relate (Runtime)2OBJECTNAMEDrag&Relate: Object Typenvarchar100
46SPRTL1Assignment of Business Objects to Data Elements1OBJECTNAMEDrag&Relate: Object Typenvarchar100
47SPRTL15Function Modules for Data Collection1OBJECTNAMEDrag&Relate: Object Typenvarchar100
48SPRTL15CFunction Modules for Data Collection (Runtime)2OBJECTNAMEDrag&Relate: Object Typenvarchar100
49SPRTL17Drag&Relate: Bindings for Reading Object Information1OBJECTNAMEDrag&Relate: Object Typenvarchar100
50SPRTL17CDrag&Relate: Bindings for Reading Object Info (Runtime)2OBJECTNAMEDrag&Relate: Object Typenvarchar100
51SPRTL18Object Definitions1OBJECTNAMEDrag&Relate: Object Typenvarchar100
52SPRTL1CAssignment of Business Objects to Data Elements (Runtime)2OBJECTNAMEDrag&Relate: Object Typenvarchar100
53SPRTL2Assignment: Data Element -> Object Name2OBJECTNAMEDrag&Relate: Object Typenvarchar100
54SPRTL25Drag&Relate: AdHoc Queries for Data Collection1OBJECTNAMEDrag&Relate: Object Typenvarchar100
55SPRTL25CDrag&Relate: AdHoc Queries for Data Collection at Runtime2OBJECTNAMEDrag&Relate: Object Typenvarchar100
56SPRTL26Drag&Relate: Bindings for Reading Object Information1OBJECTNAMEDrag&Relate: Object Typenvarchar100
57SPRTL26CDrag&Relate: Bindings for Reading Object Info. at Runtime2OBJECTNAMEDrag&Relate: Object Typenvarchar100
58SPRTL3Assignment of TCODEs to Business Objects (Obsolete)2OBJECTNAMEDrag&Relate: Object Typenvarchar100
59SPRTL31Assignment of Services to Business Objects1OBJECTNAMEDrag&Relate: Object Typenvarchar100
60SPRTL31CAssignment of Services to Business Objects (Runtime)2OBJECTNAMEDrag&Relate: Object Typenvarchar100
61SPRTL41Drag&Relate: Search Help Link2OBJECTNAMEDrag&Relate: Object Typenvarchar100
62SPRTL41CDrag&Relate: Search Help Link at Runtime3OBJECTNAMEDrag&Relate: Object Typenvarchar100
63SPRTL42Drag&Relate: Bindings for Search Help Link2OBJECTNAMEDrag&Relate: Object Typenvarchar100
64SPRTL42CDrag&Relate: Bindings for Search Help Link at Runtime3OBJECTNAMEDrag&Relate: Object Typenvarchar100
65SPRTL9Transaction Parameter Description (Obsolete)3OBJECTNAMEDrag&Relate: Object Typenvarchar100
66SPRTL91Service Parameter Description1OBJECTNAMEDrag&Relate: Object Typenvarchar100
67SPRTL91CService Parameter Description (Runtime)2OBJECTNAMEDrag&Relate: Object Typenvarchar100
68SPRTLOBRELDrag&Relate: Released Object Types1OBJECTNAMEDrag&Relate: Object Typenvarchar100
69SPRTLTRANSTransport Information and Time Stamp2OBJECTNAMEDrag&Relate: Object Typenvarchar100
TOPCross-System Tools
70CMPOBJCustomizing Comparison: Object Description2OBJECTNAMEObject Namenvarchar300
71CMPWLCustomizing Comparison: Worklist Items2OBJECTNAMEObject Namenvarchar300
72CMPWLHCustomizing Comparison: Worklist Header34OBJECTNAMEObject Namenvarchar300
73CMPWLKCustomizing Comparison: Keys of Worklist Items2OBJECTNAMEObject Namenvarchar300
74SCDTOBJOINTable Joins6OBJECTNAMEObject Namenvarchar300
75SCDTSOURCECross-System Customizing Object: Source Tables7OBJECTNAMEObject Namenvarchar300
76SCDTTARGETCross-System Customizing Object: Target Tables7OBJECTNAMEObject Namenvarchar300
TOPCustomizing Project Management IMG
77TPR_XREF_DIndex for Where-Used List4OBJECTNAMEObject Namenvarchar300
TOPDB2 Universal Database for UNIX NT
78DB6PMHTDB6: Detail Record of Table and Index Space Statistics3OBJECTNAMEDB6: Table Namenvarchar180
79DB6PMHT_HDDB6: Summary Record of Table and Index Space Statistics3OBJECTNAMEDB6: Table Namenvarchar180
80DB6PMHXPDB6: Detail Record of Tablespace and DB Space Statistics3OBJECTNAMEDB6: Tablespace Namenvarchar300
81DB6PMHXPHDDB6: Summary Record of Tablespace And DB Space Statistics3OBJECTNAMEDB6: Tablespace Namenvarchar300
82DB6PMHXTDB6: Detail Record of Tablespace and DB Table/Index Stats3OBJECTNAMEDB6: Tablespace Namenvarchar300
83DB6PMHXTHDDB6: Summary Rec. of Tablespace and DB Table/Index Stats3OBJECTNAMEDB6: Tablespace Namenvarchar300
TOPGlobal Organization Customizing
84ENTCOPY01Object Assignments for Entity Copier3OBJECTNAMEObject Namenvarchar300
TOPImplementation Guide
85CTIMPEXCLogical import: exception table1OBJECTNAMEObject Namenvarchar300
86CUS_ACTOBJCustomizing Activity - Object List3OBJECTNAMEObject Namenvarchar300
87CUS_ACTOBTCustomizing Activity - Object List4OBJECTNAMEObject Namenvarchar300
88EXCEPT1IMG Activity-Specific BC Set Error Exception Table2OBJECTNAMEObject Namenvarchar300
89EXCEPT1TException Justification Text3OBJECTNAMEObject Namenvarchar300
90EXCEPT2Object-Specific BC Set Error Case Exception Table1OBJECTNAMEObject Namenvarchar300
91EXCEPT2TException Justification Text2OBJECTNAMEObject Namenvarchar300
92TCUS_XREFCross reference for objects in IMG projects1OBJECTNAMEObject Namenvarchar300
93TCUS_XREF4Cross reference for objects in IMG projects1OBJECTNAMEObject Namenvarchar300
94TMPOBJRES1Temporary BC Set Check Report Data2OBJECTNAMEObject Namenvarchar300
TOPMonitoring
95ALALERTDBAlert: alert database (general alert structure, raw message)18OBJECTNAMEAlert: Name of Monitoring Objectnvarchar400
96ALALERTXCCMS Monitoring: Cache for Alerts Already Read25OBJECTNAMEAlert: Name of Monitoring Objectnvarchar400
97ALALRTGUIDGUIDs for CCMS Alert IDs (for Alert Framework)18OBJECTNAMEAlert: Name of Monitoring Objectnvarchar400
98ALDBSMTECCMS Monitoring Arch.: Database Segment: General MTE Data15OBJECTNAMEAlert: Name of Monitoring Objectnvarchar400
99ALMTCUSGENAlert: MT-specific Customizing Class-independent9OBJECTNAMEAlert: Name of Monitoring Objectnvarchar400
100ALMTCUSMSCAlert: MTE-specific Customizing: message container9OBJECTNAMEAlert: Name of Monitoring Objectnvarchar400
101ALMTCUSPERAlert: MT-specific Customizing Performance-Class9OBJECTNAMEAlert: Name of Monitoring Objectnvarchar400
102ALMTCUSSMGAlert: MT-specific Customizing: Single Message Class9OBJECTNAMEAlert: Name of Monitoring Objectnvarchar400
103ALMTMSCFILAlert: MTE-Specific Message Container Filter10OBJECTNAMEAlert: Name of Monitoring Objectnvarchar400
104ALPFCOLLTIDTID List Created from ALPFREORG:Objects to Collect in PerfDB8OBJECTNAMEAlert: Name of Monitoring Objectnvarchar400
105ALTIDTOOLAlert: Assignment of tools to Tid10OBJECTNAMEAlert: Name of Monitoring Objectnvarchar400
106SCMC_NODEBasic Data of Executed Monitors19OBJECTNAMEAlert: Name of Monitoring Objectnvarchar400
TOPProcess Controls -Automated Controls
107GRPCRTA_SCRIPTOBGRPCRTA Change log script and Table relationship2OBJECTNAMEObject Namenvarchar300
108GRPCRTA_TSCRTBLChange log : Script->Table relationship2OBJECTNAMEObject Namenvarchar300
TOPProcess Monitoring Infrastructure
109SSPIMOALERTSPMI: Self-Monitoring, Table of Triggered Alerts19OBJECTNAMEAlert: Name of Monitoring Objectnvarchar400
TOPProduction Orders
110COCF_IS_BTNButtons for Information System feeder2OBJECTNAMEObject typenvarchar100
TOPProfitability Analysis
111TKECMACO-PA Customizing Monitor: Account Determination Tables3OBJECTNAMECharacter field, length 32nvarchar320
TOPPublic Sector Contract Accounts Receivable and Payable
112DFMCA_FORM_VERSVersions of Form Data4OBJECTNAMEInstance Namenvarchar1000
TOPReal Estate Management
113VISPRTL3RE: Assignment of TCODEs to Business Objects (SPRTL3)2OBJECTNAMECharacter Field Length = 10nvarchar100
TOPRegulatory reporting for insurance companies
114TISSR_TP_CDYNBSTISSR: Texttabelle zur Tabelle TISSR_TP_C_DYNSB6OBJECTNAMEFeldnamenvarchar300
115TISSR_TP_CDYNFSTISSR: Texttabelle zur Tabelle TISSR_TP_C_DYNF6OBJECTNAMEFeldnamenvarchar300
116TISSR_TP_CDYNTDTISSR: Dynam. Zuweisung von Texten zu Tabreitern in Dynpros6OBJECTNAMETabellennamenvarchar300
117TISSR_TP_CDYNTSTISSR: Texttabelle zur Tabelle TISSR_TP_C_DYNTS6OBJECTNAMETabellennamenvarchar300
118TISSR_TP_C_DYNBISSR: Zuweisung des Textes zu Dynproblöcken5OBJECTNAMETabellennamenvarchar300
119TISSR_TP_C_DYNBSISSR: Zuweisung des Textes zu Selektionsbildblöcken5OBJECTNAMEFeldnamenvarchar300
120TISSR_TP_C_DYNBTISSR: Texttabelle zur Tabelle TISSR_TP_C_DYNB6OBJECTNAMETabellennamenvarchar300
121TISSR_TP_C_DYNFSISSR: Feldsteuerung Selektionsbildschirme DSUMB5OBJECTNAMEFeldnamenvarchar300
122TISSR_TP_C_DYNTDISSR: Dynam.Texte + Einstellungen zu Tabreitern in Dynpros5OBJECTNAMETabellennamenvarchar300
123TISSR_TP_C_DYNTSISSR: Dynam. Zuweisung von Texten zu Tabreitern in Selscreen5OBJECTNAMETabellennamenvarchar300
TOPRemaining Beverage - Obsolete Objects
124/BEV3/CHCBDGPRIMCustomizing Condition Log In Module6OBJECTNAMEObject Namenvarchar300
TOPScripting
125CRMD_IC_GPSCRTable of Group Relation with Script2OBJECTNAMEXML Document Namenvarchar320
126CRMD_IC_SCRATTRScript/Survey attributes (Interactive Script Editor)3OBJECTNAMEXML Document Namenvarchar320
127CRMD_IC_SCRDSCInteractive Script description3OBJECTNAMEXML Document Namenvarchar320
TOPService Data Download
128/SDF/DB6PMHT_HDDB6: summary record of table & index space statistics2OBJECTNAMEnvarchar180
129/SDF/RZ20_TMPL_NTemplate Table for SDCC Component Download - Negative List5OBJECTNAMEText, 40 Characters Longnvarchar400
130/SDF/RZ20_TMPL_PTemplate Table for SDCC Component Download - Positive List5OBJECTNAMEText, 40 Characters Longnvarchar400
TOPSystem Audit Information System
131OBJSUBREPFor transact. 0REP: Program to be started (comp. SREPOVARI)1OBJECTNAMEObject Namenvarchar300
TOPTransport Organizer
132OBJHObject: Header1OBJECTNAMEObject Namenvarchar300
133OBJLANObject: Special Rule for Original Language1OBJECTNAMEObject Namenvarchar300
134OBJMObject Method1OBJECTNAMEObject Namenvarchar300
135OBJSObject: Object List1OBJECTNAMEObject Namenvarchar300
136OBJSLObject: Object List - Logical Object1OBJECTNAMEObject Namenvarchar300
137OBJSUBSubobjects1OBJECTNAMEObject Namenvarchar300
138OBJSUBTObject: Short Description of Sub-Object2OBJECTNAMEObject Namenvarchar300
139OBJTDescription of Type T Objects (Separate Transaction)2OBJECTNAMEObject Namenvarchar300
TOPWeb Application Builder
140W3PUBDIRWAB: Publish Directory for Objects2OBJECTNAMEObject Name in Object Directorynvarchar400
TOPWithout Description
141CCMSBI_CPH_GUIDSGUIDs for Long MTE Name5OBJECTNAMEAlert: short name of MTEnvarchar400
142CCMSBI_GUIDS_CPHGUIDs for Long MTE Names (Extended)4OBJECTNAMEAlert: short name of MTEnvarchar400
TOPWorkbench Tools Editors, Painters, Modelers
143T100OAssignment of message to object3OBJECTNAMEObject Namenvarchar300