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

120 columns | Print definition?ERP 6.0  | CHANGEDON

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PERSONAS/FLAVORPersonas Flavor Header Data13CHANGEDONChange Datenvarchar80
2/PERSONAS/FLVCCHPersonas : Flavor Program Screen Changes Cache6CHANGEDONChange Datenvarchar80
3/PERSONAS/FLVVERPersonas : Flavor Version Header data9CHANGEDONChange Datenvarchar80
4/PERSONAS/ICONSPersonas : Icons Header12CHANGEDONChange Datenvarchar80
5/PERSONAS/MIGRSLInformation about Personas 2.0 Silverlight flavors.11CHANGEDONChange Datenvarchar80
6/PERSONAS/RESOURPersonas : Resource (Image, Media Files etc.) Header15CHANGEDONChange Datenvarchar80
7/PERSONAS/ROLESPersonas : Role Ranks8CHANGEDONChange Datenvarchar80
8/PERSONAS/THEMEPersonas : Themes12CHANGEDONChange Datenvarchar80
9/SLOAP/MAPPINGLT Analysis: Standalone Mappings for Analysis Applications8CHANGEDONSystem Datenvarchar80
10/UI5/BUNDLECNOT USED8CHANGEDONChanged Onnvarchar80
11/UI5/BUNDLECFILENOT USED13CHANGEDONChanged Onnvarchar80
12/UI5/CFSUI Theming: Bundle in client-dependent file system9CHANGEDONChanged Onnvarchar80
13/UI5/CFS_FILEUI Theming: File in client-dependent file system15CHANGEDONChanged Onnvarchar80
14CNVCMIS_A_1_CLASStores repository information about 'CLAS' object for CMIS16CHANGEDONChanged Onnvarchar80
15CNVCMIS_A_1_CLFRfriend relationship of classes12CHANGEDONChanged Onnvarchar80
16CNVCMIS_A_1_COMPRepository information about 'components of 'CLAS'20CHANGEDONChanged Onnvarchar80
17CNVCMIS_A_1_COSUsub compunents for clas16CHANGEDONChanged Onnvarchar80
18COPC_ACCTCOPC Org and Account Relationship13CHANGEDONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
19GRFNAEAudit Entity9CHANGEDONChanged Onnvarchar80
20GRFNAPAudit Plan Proposal9CHANGEDONAudit Plan Proposal - Changed Onnvarchar80
21GRFNAPLOGAudit Plan Proposal Transfer Log10CHANGEDONAudit Plan Proposal - Changed Onnvarchar80
22GRFNAUAudit Proposal15CHANGEDONAudit Plan Proposal - Changed Onnvarchar80
23GRFNAULOGAudit Proposal Transfer Log16CHANGEDONAudit Plan Proposal - Changed Onnvarchar80
24GRFNJOBJob24CHANGEDONJob changed onnvarchar80
25GRFNJOBDETAILJob Step24CHANGEDONJob changed onnvarchar80
26GRFNREAAudit Risk Rating11CHANGEDONAudit Risk Rating - Changed Onnvarchar80
27SLAPISOBJ: API called by an after import method11CHANGEDONChanged Onnvarchar80
28UCONHTTPCUSTHEADUnified Connectivity Service Sub Services36CHANGEDONDate of Last Changenvarchar80
29UCONPROFHEADUCON: Profile Header Table34CHANGEDONDate of Last Changenvarchar80
30UCONRFCSERVHEADUCON: RFC Service Header Table10CHANGEDONDate of Last Changenvarchar80
31UCONSERVASHEADUnified Connectivity Service Sub Services7CHANGEDONDate of Last Changenvarchar80
32UCONSERVHEADERUCON: HTTP Service Header Table7CHANGEDONDate of Last Changenvarchar80
33UCONVIRTHOSTHEADHeader for virt. hosts9CHANGEDONDate of Last Changenvarchar80
TOPABAP Workbench, Java IDE and Infrastructure
34ENHHOOKMIGRTEMPTable for Migration Support for Change of Hook ID19CHANGEDONChanged Onnvarchar80
TOPAuthentication and SSO
35USRCERTRULEActive Rules for Rule-Based Certificate Logon11CHANGEDONChanged Ondecimal150
TOPBusiness Planning
36UPB_CW_EP_UICost Center Wizard: Interfaces14CHANGEDONChanged Onnvarchar80
TOPBusiness Planning and Simulation
37UPWB_MDATAMaster Data Web Interface6CHANGEDONChanged Onnvarchar80
TOPBusiness Server Pages
38O2TAGBSP Elements7CHANGEDONChanged Onnvarchar80
39O2TAGLIBBSP Extensions6CHANGEDONChanged Onnvarchar80
TOPCapacity and Resource Planning
40/MRSS/D_RM_CANDCandidates for Demands11CHANGEDONTime Stamp - Long Formatnvarchar210
TOPClass Builder
41SEOCLASSDFDefinition of class/interface10CHANGEDONChanged Onnvarchar80
42SEOCOMPODFDefinition class/interface component15CHANGEDONChanged Onnvarchar80
43SEOFRIENDSFriend relationship9CHANGEDONChanged Onnvarchar80
44SEOMETARELMeta relationship8CHANGEDONChanged Onnvarchar80
45SEOREFPROTRefactoring log for changes to classes/interfaces14CHANGEDONChanged Onnvarchar80
46SEORELATRelationship type8CHANGEDONChanged Onnvarchar80
47SEORELCOMPRelationship type component9CHANGEDONChanged Onnvarchar80
48SEOSPECTYPSpecialization type (inheriting, implementing, comprising)7CHANGEDONChanged Onnvarchar80
49SEOSUBCODFDefinition class/interface subcomponent11CHANGEDONChanged Onnvarchar80
50SEOTYPEPLSType group application8CHANGEDONChanged Onnvarchar80
TOPCross-Application Components
51/IXOS/DC_TCPJProjects with versions10CHANGEDONLast changed onnvarchar80
TOPCustomer Enhancements
52ENHCOMPHEADEREnhancement Composite Header Data8CHANGEDONChanged Onnvarchar80
53ENHSPOTCOMPHEADEnhancement Composite Header Data8CHANGEDONChanged Onnvarchar80
54ENHSPOTHEADEREnhancement Spot Header Data9CHANGEDONChanged Onnvarchar80
TOPEnterprise Service Framework Layer
55SCOL_ACTIONCool : Action8CHANGEDONChanged Onnvarchar80
56SCOL_ASPECTCool : Aspect14CHANGEDONChanged Onnvarchar80
57SCOL_ASP_RELATCool : Relation11CHANGEDONChanged Onnvarchar80
58SCOL_BO_ADMINESF: Business Object - Properties7CHANGEDONChanged Onnvarchar80
59SCOL_BO_HEADERESF: Business Object - Properties15CHANGEDONChanged Onnvarchar80
60SCOL_BO_NODEESF : Business Object - Node13CHANGEDONChanged Onnvarchar80
61SCOL_BO_QUERYObsolete10CHANGEDONChanged Onnvarchar80
62SCOL_ND_ACTIONESF : Business Object - Action12CHANGEDONChanged Onnvarchar80
63SCOL_ND_ASSOCESF : Business Object - Association22CHANGEDONChanged Onnvarchar80
64SCOL_ND_QUERYESF : Business Object - Query12CHANGEDONChanged Onnvarchar80
65SCOL_RELATIONCool : Relation11CHANGEDONChanged Onnvarchar80
66SCOL_SVC_MODULECool : Service Module9CHANGEDONChanged Onnvarchar80
TOPFlexible Real Estate Management
67VIXCSCCHTAPEHeader Data for External Heating Expenses Settlement12CHANGEDONChange Date of Imported Datanvarchar80
TOPForms
68THRFORMS_01HR Forms: Form Directory11CHANGEDONChanged onnvarchar80
TOPLocalization
69VIXCFRBUDGETBudget Seasonality Data83CHANGEDONDate of Last Changenvarchar80
TOPObject Services
70SEOMAPCLSRelational Mapping Classes7CHANGEDONChanged Onnvarchar80
TOPProcess Controls
71GRPCCTRLPROPOSALGRPC:Control Proposal28CHANGEDONLast Changed Onnvarchar80
72GRPCJOBLOGJob Log from Scheduler32CHANGEDONLast Changed Onnvarchar80
73GRPCORGUGRLCRAssign Organization unit value to Organization Unit Group14CHANGEDONLast Changed Onnvarchar80
74GRPCORGUGRPTOrganization Unit Group Description8CHANGEDONLast Changed Onnvarchar80
75GRPCORGUNITGRPOrganization Unit Group6CHANGEDONLast Changed Onnvarchar80
76GRPCRLCRRule Criteria10CHANGEDONLast Changed Onnvarchar80
77GRPCRULERule18CHANGEDONLast Changed Onnvarchar80
78GRPCRULE_SNPRule for Snapshot19CHANGEDONLast Changed Onnvarchar80
79GRPCRULE_TEMPRule - Temporary table for installation18CHANGEDONLast Changed Onnvarchar80
80GRPCRVVALRule Criteria Value16CHANGEDONLast Changed Onnvarchar80
81GRPCRVVAL_SNPRule Criteria Value17CHANGEDONLast Changed Onnvarchar80
82GRPCSCHEDULERScheduler24CHANGEDONLast Changed Onnvarchar80
83GRPCSCRIPTScript21CHANGEDONLast Changed Onnvarchar80
84GRPCSCRIPT_TEMPScript - Temporary table for installation21CHANGEDONLast Changed Onnvarchar80
85GRPCTRANSGRC Rules Analysis36CHANGEDONLast Changed Onnvarchar80
86GRPCTRANS_SNPGRC Rules Analysis37CHANGEDONLast Changed Onnvarchar80
87GRPC_OLSP_SNPAssign Organization unit value to Organization Unit Group16CHANGEDONLast Changed Onnvarchar80
TOPService Data Download
88/SDF/CMO_O2APPLCMO Service: O2: BSP Applications7CHANGEDONChanged Onnvarchar80
89/SDF/O2PAGDIRCMO Service: Oxygen: Page Directory7CHANGEDONChanged Onnvarchar80
TOPSwitch Framework Tools
90SFW_BFBusiness Function7CHANGEDONChanged Onnvarchar80
91SFW_BSBusiness Set7CHANGEDONChanged Onnvarchar80
92SFW_SWITCHSwitches / Switch Framework6CHANGEDONChanged Onnvarchar80
TOPSyntax, Compiler, Runtime
93SLAD_OBJECT_SETSLAD: Object Set - Range Table6CHANGEDONChanged Onnvarchar80
94SLAD_PROFILESLAD: Profile6CHANGEDONChanged Onnvarchar80
TOPTable Maintenance Tool
95SDMECLSDME: Class Definition of a Maintenance Object7CHANGEDONCreated onnvarchar80
96SDMEDPCHDME: Dialog Pool Component Header8CHANGEDONDME: Change Datenvarchar80
TOPWeb Application Builder
97O2APPLO2: BSP Applications7CHANGEDONChanged Onnvarchar80
98O2PAGDIROxygen: Page Directory7CHANGEDONChanged Onnvarchar80
99O2PAGDIRIOxygen: Page Directory (Inactive)7CHANGEDONChanged Onnvarchar80
100O2THEMECUSO2: Customizing Theme <-> BSP Application7CHANGEDONChanged Onnvarchar80
101O2THEMESO2: Themes for BSP Applications5CHANGEDONChanged Onnvarchar80
102O2XMLDESCXML Description9CHANGEDONChanged Onnvarchar80
TOPWeb Dynpro ABAP
103WDY_CONFIG_APPLConfiguration Data for Web Dynpro Components8CHANGEDONChanged Onnvarchar80
104WDY_CONFIG_DATAConfiguration Data for Web Dynpro Components11CHANGEDONChanged Onnvarchar80
105WDY_CONF_APPLUCustomizing Data for Web Dynpro Applications13CHANGEDONChanged Onnvarchar80
106WDY_CONF_USERWeb Dynpro: Configuration Data for User15CHANGEDONChanged Onnvarchar80
107WDY_SETTINGSGlobal Settings for Web Dynpro ABAP8CHANGEDONChanged Onnvarchar80
TOPWeb Screen Tools - ABAP
108WDY_APPLICATIONWeb Dynpro: Application9CHANGEDONChanged Onnvarchar80
109WDY_CHIP_DEFCHIP Definition11CHANGEDONChanged Onnvarchar80
110WDY_COMPONENTWeb Dynpro: Component12CHANGEDONChanged Onnvarchar80
111WDY_CONTROLLERWeb Dynpro: Controller11CHANGEDONChanged Onnvarchar80
112WDY_UI_LIBRARYWeb Dynpro: UI Element Library Definition8CHANGEDONChanged Onnvarchar80
113WDY_VIEWWeb Dynpro: View14CHANGEDONChanged Onnvarchar80
TOPWeb Service Tools - ABAP
114SCGHEADERServiceGroups - Header20CHANGEDONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
115SLOGICALDESTLogical destinations11CHANGEDONUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
116SMIFHDRMatching Interfaces: Header9CHANGEDONMatching Interface: UTC-timestamp (JJJJMMTThhmdecimal150
117VEPHEADERVirtual End Point Definition: Administrative Data8CHANGEDONChanged Onnvarchar80
118WSHEADERWeb Services Definition Administrative Data7CHANGEDONChanged Onnvarchar80
119WSHEADER_DARKDark table of WSHEADER (only for transport reasons)8CHANGEDONChanged Onnvarchar80
TOPWorkbench Tools Editors, Painters, Modelers
120O2XSLTDESCStorage for XSLT Programs8CHANGEDONChanged Onnvarchar80