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

127 columns | Print definition?ERP 6.0  | CREATEDON

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PERSONAS/FLAVORPersonas Flavor Header Data10CREATEDONCreation datenvarchar80
2/PERSONAS/FLVVERPersonas : Flavor Version Header data6CREATEDONCreation datenvarchar80
3/PERSONAS/ICONSPersonas : Icons Header9CREATEDONCreation datenvarchar80
4/PERSONAS/MIGRSLInformation about Personas 2.0 Silverlight flavors.8CREATEDONCreation datenvarchar80
5/PERSONAS/RESOURPersonas : Resource (Image, Media Files etc.) Header12CREATEDONCreation datenvarchar80
6/PERSONAS/ROLESPersonas : Role Ranks5CREATEDONCreation datenvarchar80
7/PERSONAS/THEMEPersonas : Themes9CREATEDONCreation datenvarchar80
8/SLOAP/MAPPINGLT Analysis: Standalone Mappings for Analysis Applications6CREATEDONSystem Datenvarchar80
9/UI5/BUNDLECNOT USED5CREATEDONCreated onnvarchar80
10/UI5/BUNDLECFILENOT USED10CREATEDONCreated onnvarchar80
11/UI5/CFSUI Theming: Bundle in client-dependent file system6CREATEDONCreated onnvarchar80
12/UI5/CFS_FILEUI Theming: File in client-dependent file system12CREATEDONCreated onnvarchar80
13CNVCMIS_A_1_CLASStores repository information about 'CLAS' object for CMIS14CREATEDONCreated onnvarchar80
14CNVCMIS_A_1_CLFRfriend relationship of classes10CREATEDONCreated onnvarchar80
15CNVCMIS_A_1_COMPRepository information about 'components of 'CLAS'18CREATEDONCreated onnvarchar80
16CNVCMIS_A_1_COSUsub compunents for clas14CREATEDONCreated onnvarchar80
17COPC_ACCTCOPC Org and Account Relationship11CREATEDONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
18DITAT_D_FIPRPhysical objects fingerprint pairs10CREATEDONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
19DITAT_D_POFLHDPhysical objects fixed-length header data12CREATEDONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
20DITAT_D_TTXPhysical objects TTXs10CREATEDONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
21DITAT_D_TXTPhysical objects texts10CREATEDONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
22GRACALHDRAlerts Header Info10CREATEDONTime Stampdecimal150
23GRFNAEAudit Entity6CREATEDONAuditable Entity-Created Onnvarchar80
24GRFNAPAudit Plan Proposal4CREATEDONAudit Plan Proposal - Created Onnvarchar80
25GRFNAPLOGAudit Plan Proposal Transfer Log5CREATEDONAudit Plan Proposal - Created Onnvarchar80
26GRFNAUAudit Proposal12CREATEDONAudit Plan Proposal - Created Onnvarchar80
27GRFNAULOGAudit Proposal Transfer Log13CREATEDONAudit Plan Proposal - Created Onnvarchar80
28GRFNJOBJob20CREATEDONJob created onnvarchar80
29GRFNREAAudit Risk Rating8CREATEDONAudit Risk Rating - Created Onnvarchar80
30MRP_REQ_LINEDate and Quantity Values for Change Requests4CREATEDONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
31MRP_REQ_NOTERequests and Notes for MRP Cockpit3CREATEDONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
32SLAPISOBJ: API called by an after import method9CREATEDONCreated onnvarchar80
33SQLMSASQL Monitor: Snapshot Administration5CREATEDONCreated on ... timestampdecimal150
34SQLMZMSQL Monitor: Measurements4CREATEDONint100
35UCONHTTPCUSTHEADUnified Connectivity Service Sub Services33CREATEDONDate of Last Changenvarchar80
36UCONPROFHEADUCON: Profile Header Table31CREATEDONDate of Last Changenvarchar80
37UCONRFCSERVHEADUCON: RFC Service Header Table7CREATEDONDate of Last Changenvarchar80
38UCONSERVASHEADUnified Connectivity Service Sub Services4CREATEDONDate of Last Changenvarchar80
39UCONSERVHEADERUCON: HTTP Service Header Table4CREATEDONDate of Last Changenvarchar80
40UCONVIRTHOSTHEADHeader for virt. hosts6CREATEDONDate of Last Changenvarchar80
41ZQUOTAB1Quotation details4CREATEDONField of type DATSnvarchar80
TOPABAP Workbench, Java IDE and Infrastructure
42ENHHOOKMIGRTEMPTable for Migration Support for Change of Hook ID17CREATEDONCreated onnvarchar80
TOPBasic Functions
43ETXDCHExternal tax document: header info9CREATEDONDate on which the the external tax document was creatednvarchar80
TOPBusiness Planning
44UPB_CW_EP_UICost Center Wizard: Interfaces12CREATEDONCreated onnvarchar80
TOPBusiness Planning and Simulation
45UPWB_MDATAMaster Data Web Interface4CREATEDONCreated onnvarchar80
TOPBusiness Server Pages
46O2TAGBSP Elements5CREATEDONCreated onnvarchar80
47O2TAGLIBBSP Extensions4CREATEDONCreated onnvarchar80
TOPCapacity and Resource Planning
48/MRSS/D_RM_CANDCandidates for Demands9CREATEDONTime Stamp - Long Formatnvarchar210
TOPClass Builder
49SEOCLASSDFDefinition of class/interface8CREATEDONCreated onnvarchar80
50SEOCOMPODFDefinition class/interface component13CREATEDONCreated onnvarchar80
51SEOFRIENDSFriend relationship7CREATEDONCreated onnvarchar80
52SEOMETARELMeta relationship6CREATEDONCreated onnvarchar80
53SEOREFPROTRefactoring log for changes to classes/interfaces12CREATEDONCreated onnvarchar80
54SEORELATRelationship type6CREATEDONCreated onnvarchar80
55SEORELCOMPRelationship type component7CREATEDONCreated onnvarchar80
56SEOSPECTYPSpecialization type (inheriting, implementing, comprising)5CREATEDONCreated onnvarchar80
57SEOSUBCODFDefinition class/interface subcomponent9CREATEDONCreated onnvarchar80
58SEOTYPEPLSType group application6CREATEDONCreated onnvarchar80
TOPCross-Application Components
59/IXOS/DC_TCPJProjects with versions8CREATEDONCreated onnvarchar80
TOPCustomer Enhancements
60ENHCOMPHEADEREnhancement Composite Header Data6CREATEDONCreated onnvarchar80
61ENHSPOTCOMPHEADEnhancement Composite Header Data6CREATEDONCreated onnvarchar80
62ENHSPOTHEADEREnhancement Spot Header Data7CREATEDONCreated onnvarchar80
TOPEnterprise Service Framework Layer
63SCOL_ACTIONCool : Action5CREATEDONCreated onnvarchar80
64SCOL_ASPECTCool : Aspect11CREATEDONCreated onnvarchar80
65SCOL_ASP_RELATCool : Relation8CREATEDONCreated onnvarchar80
66SCOL_BO_ADMINESF: Business Object - Properties4CREATEDONCreated onnvarchar80
67SCOL_BO_HEADERESF: Business Object - Properties12CREATEDONCreated onnvarchar80
68SCOL_BO_NODEESF : Business Object - Node10CREATEDONCreated onnvarchar80
69SCOL_BO_QUERYObsolete7CREATEDONCreated onnvarchar80
70SCOL_ND_ACTIONESF : Business Object - Action9CREATEDONCreated onnvarchar80
71SCOL_ND_ASSOCESF : Business Object - Association19CREATEDONCreated onnvarchar80
72SCOL_ND_QUERYESF : Business Object - Query9CREATEDONCreated onnvarchar80
73SCOL_RELATIONCool : Relation8CREATEDONCreated onnvarchar80
74SCOL_SVC_MODULECool : Service Module6CREATEDONCreated onnvarchar80
TOPFlexible Real Estate Management
75VIXCSCCHTAPEHeader Data for External Heating Expenses Settlement10CREATEDONDate on Which File Was Generatednvarchar80
TOPForms
76THRFORMS_01HR Forms: Form Directory7CREATEDONCreated onnvarchar80
TOPObject Services
77SEOMAPCLSRelational Mapping Classes5CREATEDONCreated onnvarchar80
TOPProcess Controls
78GRPCCTRLPROPOSALGRPC:Control Proposal25CREATEDONDate Creatednvarchar80
79GRPCORGUGRLCRAssign Organization unit value to Organization Unit Group11CREATEDONDate Creatednvarchar80
80GRPCORGUGRPTOrganization Unit Group Description5CREATEDONDate Creatednvarchar80
81GRPCORGUNITGRPOrganization Unit Group3CREATEDONDate Creatednvarchar80
82GRPCRLCRRule Criteria7CREATEDONDate Creatednvarchar80
83GRPCRULERule15CREATEDONDate Creatednvarchar80
84GRPCRULE_SNPRule for Snapshot16CREATEDONDate Creatednvarchar80
85GRPCRULE_TEMPRule - Temporary table for installation15CREATEDONDate Creatednvarchar80
86GRPCRVVALRule Criteria Value13CREATEDONDate Creatednvarchar80
87GRPCRVVAL_SNPRule Criteria Value14CREATEDONDate Creatednvarchar80
88GRPCSCHEDULERScheduler21CREATEDONDate Creatednvarchar80
89GRPCSCRIPTScript18CREATEDONDate Creatednvarchar80
90GRPCSCRIPT_TEMPScript - Temporary table for installation18CREATEDONDate Creatednvarchar80
91GRPCTRANSGRC Rules Analysis33CREATEDONDate Creatednvarchar80
92GRPCTRANS_SNPGRC Rules Analysis34CREATEDONDate Creatednvarchar80
93GRPC_OLSP_SNPAssign Organization unit value to Organization Unit Group13CREATEDONDate Creatednvarchar80
TOPService Data Download
94/SDF/CMO_O2APPLCMO Service: O2: BSP Applications5CREATEDONCreated onnvarchar80
95/SDF/O2PAGDIRCMO Service: Oxygen: Page Directory5CREATEDONCreated onnvarchar80
TOPSwitch Framework Tools
96SFW_BFBusiness Function5CREATEDONCreated onnvarchar80
97SFW_BSBusiness Set5CREATEDONCreated onnvarchar80
98SFW_SWITCHSwitches / Switch Framework4CREATEDONCreated onnvarchar80
TOPSyntax, Compiler, Runtime
99SLAD_OBJECT_SETSLAD: Object Set - Range Table4CREATEDONCreated onnvarchar80
100SLAD_PROFILESLAD: Profile4CREATEDONCreated onnvarchar80
TOPTable Maintenance Tool
101SDMECLSDME: Class Definition of a Maintenance Object5CREATEDONCreated onnvarchar80
102SDMEDPCHDME: Dialog Pool Component Header6CREATEDONDME: Created Onnvarchar80
103SDMEDPHDRDME: Dialog Pool Header Data3CREATEDONDME: Created Onnvarchar80
TOPWeb Application Builder
104O2APPLO2: BSP Applications5CREATEDONCreated onnvarchar80
105O2PAGDIROxygen: Page Directory5CREATEDONCreated onnvarchar80
106O2PAGDIRIOxygen: Page Directory (Inactive)5CREATEDONCreated onnvarchar80
107O2THEMECUSO2: Customizing Theme <-> BSP Application5CREATEDONCreated onnvarchar80
108O2THEMESO2: Themes for BSP Applications3CREATEDONCreated onnvarchar80
109O2XMLDESCXML Description7CREATEDONCreated onnvarchar80
TOPWeb Dynpro ABAP
110WDY_CONFIG_APPLConfiguration Data for Web Dynpro Components6CREATEDONCreated onnvarchar80
111WDY_CONFIG_DATAConfiguration Data for Web Dynpro Components9CREATEDONCreated onnvarchar80
112WDY_CONF_APPLUCustomizing Data for Web Dynpro Applications11CREATEDONCreated onnvarchar80
113WDY_CONF_USERWeb Dynpro: Configuration Data for User13CREATEDONCreated onnvarchar80
114WDY_SETTINGSGlobal Settings for Web Dynpro ABAP6CREATEDONCreated onnvarchar80
TOPWeb Screen Tools - ABAP
115WDY_APPLICATIONWeb Dynpro: Application7CREATEDONCreated onnvarchar80
116WDY_CHIP_DEFCHIP Definition9CREATEDONCreated onnvarchar80
117WDY_COMPONENTWeb Dynpro: Component10CREATEDONCreated onnvarchar80
118WDY_CONTROLLERWeb Dynpro: Controller9CREATEDONCreated onnvarchar80
119WDY_UI_LIBRARYWeb Dynpro: UI Element Library Definition6CREATEDONCreated onnvarchar80
120WDY_VIEWWeb Dynpro: View12CREATEDONCreated onnvarchar80
TOPWeb Service Tools - ABAP
121SCGHEADERServiceGroups - Header18CREATEDONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
122SLOGICALDESTLogical destinations9CREATEDONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
123SMIFHDRMatching Interfaces: Header7CREATEDONMatching Interface: UTC-timestamp (JJJJMMTThhmdecimal150
124VEPHEADERVirtual End Point Definition: Administrative Data6CREATEDONCreated onnvarchar80
125WSHEADERWeb Services Definition Administrative Data5CREATEDONCreated onnvarchar80
126WSHEADER_DARKDark table of WSHEADER (only for transport reasons)6CREATEDONCreated onnvarchar80
TOPWorkbench Tools Editors, Painters, Modelers
127O2XSLTDESCStorage for XSLT Programs6CREATEDONCreated onnvarchar80