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

115 columns | Print definition?ERP 6.0  | VIEWNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BTP_DL_WDCHELPBTP Web Dynpro Components Help2VIEWNAMEWeb Dynpro: View Namenvarchar300
2CNVCMIS_A_1_ENQDENQU Data (FIELDNAMES)4VIEWNAMEName of SAP table viewnvarchar300
3CNVCMIS_A_1_ENQSENQU Data ( Base tables and foreign key relationships)4VIEWNAMEName of SAP table viewnvarchar300
4CNVCMIS_A_1_ENQUENQU Data (Header)4VIEWNAMEName of SAP table viewnvarchar300
5CNVCMIS_A_1_MCOBMCOB type Repository Analysis9VIEWNAMEName of SAP table viewnvarchar300
6CNVCMIS_A_1_MCOFMCOF type Repository Analysis5VIEWNAMEName of SAP table viewnvarchar300
7CNVCMIS_A_1_VIEFVIEF type Repository Analysis4VIEWNAMEName of SAP table viewnvarchar300
8CNVCMIS_A_1_VIEWVIEW type Repository Analysis4VIEWNAMEName of SAP table viewnvarchar300
9CNVMBT09VIEWTable for database views of dropped tables3VIEWNAMEName of SAP table viewnvarchar300
10CNVMBTDELPARAMSParameter for the generic deletion program5VIEWNAMEName of SAP table viewnvarchar300
11CNVMBT_09_VIEWTable for database views of dropped tables3VIEWNAMEName of SAP table viewnvarchar300
12CNVTDMS_09_VIEWTable for database views of dropped tables3VIEWNAMEName of SAP table viewnvarchar300
13CNV_00001_VIEWSTable for avtivation of DB views3VIEWNAMEName of SAP table viewnvarchar300
14DMC_IU_E071KMWB Upgrade: Table E071K9VIEWNAMEName of SAP table viewnvarchar300
15DMC_MDS_SOBJKIUUC: dyn maint event saving of e071k for logical w/o aim8VIEWNAMEName of SAP table viewnvarchar300
16GTABKEY_ARCHIVEGlobal Key Entries from Requests/Tasks11VIEWNAMEName of SAP table viewnvarchar300
17MDS_E071KMDS: E071K to a specific simulation version9VIEWNAMEName of SAP table viewnvarchar300
18OCS_CP_E071KTLOGO E071K für CP TR: Schlüsseleinträge8VIEWNAMEName eines SAP-Tabellenviewsnvarchar300
19OCS_CP_E071K_STRTLOGO E071K_STR für CP TR: Schlüsseleinträge mit Strngfelder8VIEWNAMEName eines SAP-Tabellenviewsnvarchar300
20SCTS_TRACK_KEYcCTS: Helper for key persistence for object level tracking4VIEWNAMEName of SAP table viewnvarchar300
21TKEIGCO-PA characteristics table5VIEWNAMEName of SAP table viewnvarchar300
TOPABAP Authorization and Role Management
22AGR_CUSTOMRole Customizing objects3VIEWNAMEUnique ID - 32 charactersnvarchar320
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
23CD0TBSH001Veri-Struktur mit Suchhilfe-Anbindung1VIEWNAMEName eines SAP-Tabellenviewsnvarchar300
24DD20LMatchcode objects6VIEWNAMEName of SAP table viewnvarchar300
25DD25LAggregate Header (Views, MC Objects, Lock Objects)1VIEWNAMEName of SAP table viewnvarchar300
26DD25TShort Texts for Views and Lock Objects2VIEWNAMEName of SAP table viewnvarchar300
27DD26SBase tables and foreign key relationships for a view1VIEWNAMEName of SAP table viewnvarchar300
28DD27SFields in an Aggregate (View, MC Object, Lock Object)1VIEWNAMEName of SAP table viewnvarchar300
29DD29LSelection Condition for Views and MC IDs6VIEWNAMEName of SAP table viewnvarchar300
TOPApplication Framework
30MDG_TR_E071KObject List for Client Copy (Key)9VIEWNAMEName of SAP table viewnvarchar300
TOPBusiness Application Support
31CNVPROGSConversion: Programs for converting tables (generated)6VIEWNAMEName of SAP table viewnvarchar300
32CNV_00001_PUSRTable is no longer required4VIEWNAMEStructures: Name of Viewnvarchar120
TOPBusiness Configuration Sets
33SCPRACTRBC Set: Active records in Local System7VIEWNAMEBC Set: Table/View Namenvarchar300
34SCPRSREVERTOWNERRevert SBCSets: Which rows were touched by which BCSet7VIEWNAMEBC Set: Table/View Namenvarchar300
35SCPRSREVERTOWNRDRevert SBCSets: Which rows were touched by which BCSet8VIEWNAMEBC Set: Table/View Namenvarchar300
36SCPRSREVERTOWNRIRevert SBCSets: Which rows were touched by which BCSet7VIEWNAMEBC Set: Table/View Namenvarchar300
TOPBW Service API
37ROVERTABLETables for Verification Scenarios3VIEWNAMEName of SAP table viewnvarchar300
TOPChange Transport System
38GTABLESList Tables with Global RFC Interface5VIEWNAMEObject Name for Global Objectsnvarchar400
TOPClaims Management
39TICL130Tables of Claim System9VIEWNAMEName of Table/View for Extended Table Maintenancenvarchar300
TOPCross-System Tools
40CMPWLCustomizing Comparison: Worklist Items5VIEWNAMEObject Namenvarchar300
41CMPWLECustomizing Comparison: Exception List (SAP)1VIEWNAMEObject Namenvarchar300
42CMPWLECCustomizing Comparison: Exception List (Customer)1VIEWNAMEObject Namenvarchar300
43CMPWLHCustomizing Comparison: Worklist Header37VIEWNAMEObject Namenvarchar300
44CMPWLKCustomizing Comparison: Keys of Worklist Items5VIEWNAMEObject Namenvarchar300
45CMP_EXCEPTComparison Tools Exception Table (will be deleted)1VIEWNAMEName of SAP table viewnvarchar300
46CMP_RUNSComparisons (will be deleted)7VIEWNAMEName of SAP table viewnvarchar300
47SCDT_E071K_TRIGGDistribution Polling Trigger Buffer9VIEWNAMEName of SAP table viewnvarchar300
TOPCustomer Enhancements
48ENHTABEnhancements for Tables9VIEWNAMEName of SAP table viewnvarchar300
TOPData Modeler
49DM25LDM View-Entity Type Assignment3VIEWNAMEName of SAP table viewnvarchar300
50TDI01Entity Type - View Assignment4VIEWNAMEName of SAP table viewnvarchar300
TOPData Staging
51RSDANLSEGBW Archiving: Segment of a Nearline Object6VIEWNAMEName of a Table in Near-Line Storagenvarchar300
52RSDANLSEGVBW Archiving: Errors for a Segment Version7VIEWNAMEName of a Table in Near-Line Storagenvarchar300
TOPDevelopment Workbench
53BSP_WD_EXT_HISTLog Table for Enhancement History2VIEWNAMEName of BSP Page (Upper and Lower Case)nvarchar700
54WCF_CONF_SWITCHSwitch Info3VIEWNAMEInternal Name (Key) of BSP Pagenvarchar700
TOPEEW Generator
55GOX_TR_TABKEYTable Keys for GOX Objects11VIEWNAMEName of SAP table viewnvarchar300
TOPEnd User Technology
56RSR_LKP_ATTRCalculation with Attributes: Query Name <-> View Name Folder2VIEWNAMEView Name for Lookup - Calculate with Attributesnvarchar300
TOPF4 Help
57DD92SMapping of R/3 Data on External Index3VIEWNAMEName of SAP table viewnvarchar300
TOPFinancials Basis
58FINB_TR_E071KObject List for Client Copy (Key)9VIEWNAMEName of SAP table viewnvarchar300
TOPGeneral Application Functions
59BAMUIVIEWApplication Analysis: UI: Views of the Main List1VIEWNAMEApplication analysis: UI: Name of a view on main listnvarchar40
60BAMUIVIEWNApplication Analysis: UI: Nodes within a View1VIEWNAMEApplication analysis: UI: Name of a view on main listnvarchar40
61BAMUIVIEWTApplication analysis: UI: Name of views on main list2VIEWNAMEApplication analysis: UI: Name of a view on main listnvarchar40
TOPGlobal Organization Customizing
62ENTCOPY03ECOP: Permitted maintenance views to be processed2VIEWNAMEName of table/view for extended table maintenancenvarchar300
TOPImplementation Guide
63CUSADPDefault project and other standard settings in Customizing3VIEWNAMEStructures: Name of Viewnvarchar120
64CUSADP40Default project and other standard settings in Customizing3VIEWNAMEUnique ID - 32 charactersnvarchar320
65DSYADStructures: Display Structure Without Text2VIEWNAMEStructures: Name of Viewnvarchar120
66DSYADEFLast position in structure display3VIEWNAMEStructures: Name of Viewnvarchar120
67DSYAMRKSO70 bookmarks table3VIEWNAMEStructures: Name of Viewnvarchar120
68DSYAVStructures: Directory of Views on Books2VIEWNAMEStructures: Name of Viewnvarchar120
69DSYAWStructures: Short text for views on a book3VIEWNAMEStructures: Name of Viewnvarchar120
70DSYAXStructures: Parameters for Views on a Book2VIEWNAMEStructures: Name of Viewnvarchar120
71TSTATCPAssignment of selection to project and activity4VIEWNAMEStructures: Name of Viewnvarchar120
72TSTATHStatus fields for an activity in a project4VIEWNAMEStructures: Name of Viewnvarchar120
73TSTATHTTexts for an activity in a project5VIEWNAMEStructures: Name of Viewnvarchar120
74TSTATPPProblem numbers for project and activity5VIEWNAMEStructures: Name of Viewnvarchar120
75TSTATRPResource assignment to project and activity4VIEWNAMEStructures: Name of Viewnvarchar120
TOPIncentive and Commission Management ICM
76TCACS_APPLCUSTControl Table for Calling Views and Handling in IMG3VIEWNAMETable or view namenvarchar300
77TCACS_MOD_VIEWView Modifications1VIEWNAMETable or view namenvarchar300
TOPJoint Venture und Production Sharing Accounting
78T8PSA_VIEW_AUTHPSA view authorities1VIEWNAMEView Name, 16 Charactersnvarchar160
TOPObject Selection
79GEN_TABLES_MAINGenerated Tables for Search in Classification System4VIEWNAMEName of ABAP Dictionary Objectnvarchar300
TOPOnline Correction Support Support Package and Add-On Tools
80PAD71KKeys of Table Entries Contained in a Patch8VIEWNAMEName of SAP table viewnvarchar300
TOPPension fund Netherlands
81T5NL4Parameter restricties TC & AF4VIEWNAMENaam van een SAP-tabelviewnvarchar300
TOPProcess Controls -Automated Controls
82GRPCRTA_CTRLDEFControl Definition9VIEWNAMEView Name, 16 Charactersnvarchar160
TOPReusable Components of Business Suite Foundation
83/BOFU/VIEW_EHView Event Handlers1VIEWNAMETable or view namenvarchar300
TOPSAP Note Assistant
84STABULOGLog of Customer Modifications of Table Entries3VIEWNAMEName of SAP table viewnvarchar300
TOPServices
85FINB_VIEWData for a View1VIEWNAMEName of SAP table viewnvarchar300
86FINB_VIEW_MAPMap DDIC Field Names to Field Names of Configuration1VIEWNAMEName of SAP table viewnvarchar300
TOPSwitch Framework Tools
87SFW_VIEWFIELDAssignment Switch / View Field1VIEWNAMEName of SAP table viewnvarchar300
TOPTable Maintenance Tool
88SDMEDPDADME: Dialog Pool Component 'Dialog' (Area)5VIEWNAMEDME: Maintenance Structurenvarchar400
89SDMEDPVFDME: OBSOLETE Dialog Pool Component 'View' (Fields)2VIEWNAMEDME: Maintenance Structurenvarchar400
90SDMEDPVHDME: Dialog Pool Component 'View' (Header)2VIEWNAMEDME: Maintenance Structurenvarchar400
91SDMEDPVODME: Dialog Pool Component 'View' (Objects)2VIEWNAMEDME: Maintenance Structurenvarchar400
TOPTransport Organizer
92E071KChange & Transport System: Key Entries of Requests/Tasks8VIEWNAMEName of SAP table viewnvarchar300
93E071KS_PREVIEWTransport Request Preview: Key Entries with Strings8VIEWNAMEName of SAP table viewnvarchar300
94E071K_STRKey Entries with String Fields of Requests/Tasks8VIEWNAMEName of SAP table viewnvarchar300
95E071K_STR_SHADOWCopy of E071K_STR_SHADOW, String Replaced By Long Char8VIEWNAMEName of SAP table viewnvarchar300
96E071K__PREVIEWTransport Request Preview: Key Entries of a Request8VIEWNAMEName of SAP table viewnvarchar300
97GTABKEYGlobal Key Entries from Requests/Tasks11VIEWNAMEName of SAP table viewnvarchar300
98GTABKEY_LOCALGlobal Key Entries from Requests/Tasks11VIEWNAMEName of SAP table viewnvarchar300
99TABDIRDEVCAssignment of Development Class to Table Entries2VIEWNAMEName of SAP table viewnvarchar300
100TABDIRLANGAssignment of Original Language to Table Entries2VIEWNAMETable Namenvarchar300
101TABDIRORIGAssignment of Original Language to Table Entries2VIEWNAMETable Namenvarchar300
102TABREFINEDetermines Granularity for Originality Attributes3VIEWNAMEName of SAP table viewnvarchar300
TOPUI Configuration Design Layer
103BSPC_DL_PERSSTORStoragetable for XML personalized layout descriptions4VIEWNAMEInternal Name (Key) of BSP Pagenvarchar700
104BSPC_DL_XMLSTRX2Storagetable for XML layout descriptions4VIEWNAMEInternal Name (Key) of BSP Pagenvarchar700
105BSP_DLC_CONTEXTContext definition for Dynamic Layout configuration tools2VIEWNAMEInternal Name (Key) of BSP Pagenvarchar700
106BSP_DLC_DASSIGNDesign layer: Assignment of design object to UI7VIEWNAMEInternal Name (Key) of BSP Pagenvarchar700
107BSP_DLC_EOVPVIEWEditable Overview Page: Assignment of display view <-> edit2VIEWNAMEBSP View Namenvarchar700
108BSP_DLC_SDASSIGNDesign layer: Assignment of design object to UI6VIEWNAMEInternal Name (Key) of BSP Pagenvarchar700
109BSP_DL_XMLSTRX2Storagetable for delivered XML layout descriptions3VIEWNAMEInternal Name (Key) of BSP Pagenvarchar700
110BSP_DL_XMLST_PRProcessed Standdard Configuration (switch related handling)4VIEWNAMEInternal Name (Key) of BSP Pagenvarchar700
TOPUI Runtime Environment
111BSPWD_TBUI_TASKRepository of views of embedded task pages2VIEWNAMEView Name of Reusable Guided Activity Pagenvarchar700
112BSPWD_TBUI_TASKTRepository of views of embedded task pages3VIEWNAMEView Name of Reusable Guided Activity Pagenvarchar700
113BSPWD_TBUI_VIEWRepository of views enabled for task pages2VIEWNAMEView Name of Reusable Step View for Guided Activity Pagesnvarchar700
114BSPWD_TBUI_VIEWTRepository of views enabled for task pages3VIEWNAMEView Name of Reusable Step View for Guided Activity Pagesnvarchar700
TOPUpgrade Tools
115CRR_MDS_SOBJKCRR IUU: dyn maint event saving of e071k for logical w/o aim8VIEWNAMEName of SAP table viewnvarchar300