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

161 columns | Print definition?ERP 6.0  | CREATEDBY

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/PERSONAS/FLAVORPersonas Flavor Header Data9CREATEDBYCreated by Usernvarchar120
2/PERSONAS/FLVVERPersonas : Flavor Version Header data5CREATEDBYCreated by Usernvarchar120
3/PERSONAS/ICONSPersonas : Icons Header8CREATEDBYCreated by Usernvarchar120
4/PERSONAS/MIGRSLInformation about Personas 2.0 Silverlight flavors.7CREATEDBYCreated by Usernvarchar120
5/PERSONAS/RESOURPersonas : Resource (Image, Media Files etc.) Header11CREATEDBYCreated by Usernvarchar120
6/PERSONAS/ROLESPersonas : Role Ranks4CREATEDBYCreated by Usernvarchar120
7/PERSONAS/THEMEPersonas : Themes8CREATEDBYCreated by Usernvarchar120
8/SAPPSSRM/FAUDDatabase table for Audit Trail10CREATEDBYCreated Bynvarchar100
9/SLOAP/MAPPINGLT Analysis: Standalone Mappings for Analysis Applications5CREATEDBYUser Namenvarchar120
10/UI5/BUNDLECNOT USED4CREATEDBYAuthornvarchar120
11/UI5/BUNDLECFILENOT USED9CREATEDBYAuthornvarchar120
12/UI5/CFSUI Theming: Bundle in client-dependent file system5CREATEDBYAuthornvarchar120
13/UI5/CFS_FILEUI Theming: File in client-dependent file system11CREATEDBYAuthornvarchar120
14CNVA_00555_HDRHeader table for Run Time Estimation package5CREATEDBYUser Namenvarchar120
15CNVA_CCD_ANA_HDRHeader table for CC Deletion Analysis Package5CREATEDBYUser Namenvarchar120
16CNVA_CCD_ANA_SHDHeader table for CC Deletion Analysis Package in SolMan8CREATEDBYUser Namenvarchar120
17CNVA_PCREA_RUNIDHeader Information of Profit Center Reorganization10CREATEDBYUser Namenvarchar120
18CNVCMIS_A_1_LDBDAdministration information for LDB8CREATEDBYAuthornvarchar120
19COPC_ACCTCOPC Org and Account Relationship10CREATEDBYUser Namenvarchar120
20DITAT_D_FIPRPhysical objects fingerprint pairs9CREATEDBYUser Namenvarchar120
21DITAT_D_POFLHDPhysical objects fixed-length header data11CREATEDBYUser Namenvarchar120
22DITAT_D_TTXPhysical objects TTXs9CREATEDBYUser Namenvarchar120
23DITAT_D_TXTPhysical objects texts9CREATEDBYUser Namenvarchar120
24DMC_VERSION_HDRVersion Data of an Object5CREATEDBYMWB: Created by usernvarchar120
25EENRGY_CR_BRBrazil: Energy Credits Account16CREATEDBYName of Person who Created the Objectnvarchar120
26GRFNFDSSTFMETAFlexible Data Store - Storage Type - File, Meta Data10CREATEDBYUser Namenvarchar120
27GRFNJOBJob22CREATEDBYJob created bynvarchar120
28GRFNREAAudit Risk Rating7CREATEDBYAudit Risk Rating - Created bynvarchar120
29RSDHAMAPHANA Analysis Processes5CREATEDBYLast changed bynvarchar120
30RSDHAOBJTYPETypes of Analysis Elements7CREATEDBYLast changed bynvarchar120
31RSDHA_PROC_MDProcedure Metadata6CREATEDBYLast changed bynvarchar120
32SQLMSASQL Monitor: Snapshot Administration6CREATEDBYCreated on ... timestampnvarchar120
33SQLMZMSQL Monitor: Measurements5CREATEDBYABAP System Field: Name of Current Usernvarchar120
34T5FDSN_GEN_HDRDSN: Header of generated sections11CREATEDBYUser Namenvarchar120
35TBAT_PRICEQUOTDerivative Contract Specification: Price Quotations14CREATEDBYFirst Entered Bynvarchar120
36TBAT_PRICEQUOT_FDerivative Contract Specification: Price Quotations Futures14CREATEDBYFirst Entered Bynvarchar120
37TBAT_PRICEQUOT_ODerivative Contract Specification: Price Quotations Options15CREATEDBYFirst Entered Bynvarchar120
38TBAT_PRICE_FWDDerivative Contract Specification: Commodity Forward Prices16CREATEDBYFirst Entered Bynvarchar120
39TYC_BSPRD_MDBasis Spreads: Market Data8CREATEDBYCreated Bynvarchar120
40TYC_CSPRD_MDCredit Spreads: Market Data9CREATEDBYCreated Bynvarchar120
41UCONHTTPCUSTHEADUnified Connectivity Service Sub Services32CREATEDBYLast Changed bynvarchar120
42UCONPROFHEADUCON: Profile Header Table30CREATEDBYLast Changed bynvarchar120
43UCONRFCSERVHEADUCON: RFC Service Header Table6CREATEDBYLast Changed bynvarchar120
44UCONSERVASHEADUnified Connectivity Service Sub Services3CREATEDBYLast Changed bynvarchar120
45UCONSERVHEADERUCON: HTTP Service Header Table3CREATEDBYLast Changed bynvarchar120
46UCONVIRTHOSTHEADHeader for virt. hosts5CREATEDBYLast Changed bynvarchar120
47Z603QUOTATIONBIT603 - Exercises5CREATEDBYAntragsteller(in)nvarchar120
48Z603TRAREQUESTTravelrequest - BIT6036CREATEDBYAntragsteller(in)nvarchar120
49ZSKSYSUSERuser in den IDES-Systemen14CREATEDBYnvarchar120
TOPABAP Workbench, Java IDE and Infrastructure
50ENHHOOKMIGRTEMPTable for Migration Support for Change of Hook ID16CREATEDBYAuthornvarchar120
TOPApplication-Specific Upgrade
51/ASU/HEADERASU Version Header5CREATEDBYUser Namenvarchar120
TOPBackground Processing
52SXPGCOSTABDefinition of logical OS commands(customer table)7CREATEDBYUser Namenvarchar120
53SXPGCOTABEDefinition of logical operating system commands(SAP table)7CREATEDBYUser Namenvarchar120
54SXPGHISTORHistory of Logical Commands10CREATEDBYUser Namenvarchar120
TOPBasic Functions
55ETXDCHExternal tax document: header info10CREATEDBYName of person who created the external tax documentnvarchar120
56TTSTRSDWorking Times in SD/WS7CREATEDBYUser that created objectnvarchar120
TOPCapacity Evaluations
57CYTSTR_TABTime stream keys9CREATEDBYUser that created objectnvarchar120
TOPClaims Management
58ICLACTIVITYTasks in Claim9CREATEDBYCreated Bynvarchar120
59ICLCAREREP1Data on Care Request7CREATEDBYCreated Bynvarchar120
60ICLCAREREP2Data on Caregiver8CREATEDBYCreated Bynvarchar120
61ICLCCEVENTClaim Bundle7CREATEDBYCreated Bynvarchar120
62ICLCLAIMClaim7CREATEDBYCreated Bynvarchar120
63ICLDAMOBJDamaged Object8CREATEDBYCreated Bynvarchar120
64ICLEACTIVITYTasks in Claim Bundle8CREATEDBYCreated Bynvarchar120
65ICLIBNRHEALTHCLUCases, Quantities, and Costs (Totalled) at Evaluation Level9CREATEDBYCreated Bynvarchar120
66ICLIBNRHEALTHDETQuantities and Costs (Totalled, if Nec) at Single Case Level21CREATEDBYCreated Bynvarchar120
67ICLINDRESReserve Lot3CREATEDBYCreated Bynvarchar120
68ICLNOLNotice of Loss3CREATEDBYCreated bynvarchar120
69ICLNOLAUNotice of Loss Vehicle3CREATEDBYCreated bynvarchar120
70ICLNOLDAMITEMDamage9CREATEDBYCreated bynvarchar120
71ICLNOLDONotice of Loss: Damaged Object4CREATEDBYCreated bynvarchar120
72ICLNOLDOAUNotice of Loss: Damaged Vehicle4CREATEDBYCreated bynvarchar120
73ICLNOLDOBINotice of Loss: Injured Person5CREATEDBYCreated bynvarchar120
74ICLNOLDODESCASSNDamage Descriptors per Object5CREATEDBYCreated bynvarchar120
75ICLNOLDORENotice of Loss: Damaged Vehicle4CREATEDBYCreated bynvarchar120
76ICLNOLHONotice of Loss Building3CREATEDBYCreated bynvarchar120
77ICLNOLPNotice of Loss Participant7CREATEDBYCreated bynvarchar120
78ICLNOLPARTRORole Notifier Participant5CREATEDBYCreated bynvarchar120
79ICLNOLPDRNotice of Loss: Driver6CREATEDBYCreated bynvarchar120
80ICLPAYClaim Payment9CREATEDBYCreated Bynvarchar120
81ICLPAYEEAdditional Payee10CREATEDBYCreated Bynvarchar120
82ICLPROCUREClaim Item Groupings9CREATEDBYCreated Bynvarchar120
83ICLSUBCLSubclaim8CREATEDBYCreated Bynvarchar120
84ICLSUBCLFRAUDResult from Check System8CREATEDBYCreated Bynvarchar120
85ICLULAERUNTimestamp for a ULAE Reserve Calculation Run3CREATEDBYCreated Bynvarchar120
86ICLX_PARTICIPANTError Table for Participants with XI Input6CREATEDBYCreated Bynvarchar120
87ICL_INVSTG_LOGClaim Investigation Messages5CREATEDBYCreated Bynvarchar120
88ICL_REGREP_LOGRegulatory Reporting Log4CREATEDBYCreated Bynvarchar120
89ICSACTIVITYActivity in the Claim9CREATEDBYCreated Bynvarchar120
90ICSCCEVENTShadow Table Claim Bundle7CREATEDBYCreated Bynvarchar120
91ICSCLAIMClaim7CREATEDBYCreated Bynvarchar120
92ICSDAMOBJDamaged Object8CREATEDBYCreated Bynvarchar120
93ICSEACTIVITYTask in Claim Bundle Shadow Table8CREATEDBYCreated Bynvarchar120
94ICSPAYPayment9CREATEDBYCreated Bynvarchar120
95ICSPAYEEAdditional Payee10CREATEDBYCreated Bynvarchar120
96ICSPROCUREClaim Item Groupings9CREATEDBYCreated Bynvarchar120
97ICSSUBCLSubclaim8CREATEDBYCreated Bynvarchar120
98ICSSUBCLFRAUDResult from Claims Check System8CREATEDBYCreated Bynvarchar120
TOPCollaborative Cross Applications
99/POA/D_CTX_HDRPOA SBC Business Context Header6CREATEDBYUser Name in User Master Recordnvarchar120
TOPCommunication Services Mail, Fax, SMS, Telephony
100BCSD_BREAKLOOPBCS: Breakloops in SAPconnect6CREATEDBYBCS: User That Set Breakloopnvarchar120
TOPControlling
101FCOMT_INASETInactive Groups8CREATEDBYCreated Bynvarchar120
TOPCross-Application Components
102/IXOS/DC_TCPJProjects with versions7CREATEDBYAuthornvarchar120
TOPData Collection
103S304WIS: Sample scenario10CREATEDBYApplicantnvarchar120
104S304ES304 - Structural Information5CREATEDBYApplicantnvarchar120
TOPDB2 for OS39
105STU3COTABCDefinition of DB2 OS/390 and OS/390 Commands(Customer Table)12CREATEDBYUser Namenvarchar120
106STU3COTABSDefinition of DB2 for OS/390 and OS/390 Commands (SAP Table)12CREATEDBYUser Namenvarchar120
TOPFast Search Infrastructure
107SFSG_DEF_DDatabase Table for GFS Definitions (Design Time)12CREATEDBYLast Changed bynvarchar120
108SFSG_QR_DEFRepository Table for Query Definition7CREATEDBYLast Changed bynvarchar120
109SFSRFW_ALIAS_HReplication Framework - Aliases4CREATEDBYLast Changed bynvarchar120
110SFSRFW_IDX_DReplication Framework - Index Definition3CREATEDBYLast Changed bynvarchar120
111SFSRFW_JDX_DReplication Framework - Join Index Rules3CREATEDBYLast Changed bynvarchar120
112SFSRFW_REQ_HReplication Framework - Requester9CREATEDBYLast Changed bynvarchar120
TOPGeographical Functions
113GEOLOCGeo location (lon/lat/alt/...)11CREATEDBYUser Namenvarchar120
114GEOOBJRGen. object ref. (customer, plant, ...)9CREATEDBYUser Namenvarchar120
TOPIntegration Engine
115SXMSINTERFACESender/Receiver Definition11CREATEDBYCreated by Usernvarchar120
116SXMSJOBSJobs for Time-Controlled Message Processing8CREATEDBYCreated by Usernvarchar120
117SXMSMSGDEFMessage Definition18CREATEDBYCreated by Usernvarchar120
118SXMS_BCFG_MASTPackage Configuration Types6CREATEDBYCreated by Usernvarchar120
119SXMS_BCONFAssignment Package Configuration4CREATEDBYCreated by Usernvarchar120
120SXMS_BCONF_SPECSpecific Packaging Configuration6CREATEDBYCreated by Usernvarchar120
121SXMS_CUST_HDREncrypting Customer Header5CREATEDBYCreated by Usernvarchar120
122SXMS_EXT_FILFilter for Extractors10CREATEDBYCreated by Usernvarchar120
123SXMS_LCR_VERSXI: Version Information form SLD About Receiver Systems14CREATEDBYCreated by Usernvarchar120
124SXMS_LMS_EXTRLean Message Search Extractor14CREATEDBYCreated by Usernvarchar120
125SXMS_NSPREFIXTable for Extractor Namespace Prefixes5CREATEDBYCreated by Usernvarchar120
126SXMS_SEQU_QUEUEAssignment of WS Inbound Sequence to XI Queue ID5CREATEDBYCreated by Usernvarchar120
TOPLogical DB, Selection Screens, Selection Variants
127LDBDAdministration information for LDB4CREATEDBYAuthornvarchar120
TOPMetadata Repository
128RSLTIPDirectory Transient Providers8CREATEDBYLast changed bynvarchar120
TOPOLAP Technology
129RSDDCOPRComposite Provider Directory5CREATEDBYLast changed bynvarchar120
130RSWSPList of Workspaces4CREATEDBYLast changed bynvarchar120
TOPProcess Controls
131GRPCCTRLPROPOSALGRPC:Control Proposal27CREATEDBYCreated Bynvarchar120
132GRPCORGUGRLCRAssign Organization unit value to Organization Unit Group13CREATEDBYCreated Bynvarchar120
133GRPCORGUGRPTOrganization Unit Group Description7CREATEDBYCreated Bynvarchar120
134GRPCORGUNITGRPOrganization Unit Group5CREATEDBYCreated Bynvarchar120
135GRPCRLCRRule Criteria9CREATEDBYCreated Bynvarchar120
136GRPCRULERule17CREATEDBYCreated Bynvarchar120
137GRPCRULE_SNPRule for Snapshot18CREATEDBYCreated Bynvarchar120
138GRPCRULE_TEMPRule - Temporary table for installation17CREATEDBYCreated Bynvarchar120
139GRPCRVVALRule Criteria Value15CREATEDBYCreated Bynvarchar120
140GRPCRVVAL_SNPRule Criteria Value16CREATEDBYCreated Bynvarchar120
141GRPCSCHEDULERScheduler23CREATEDBYCreated Bynvarchar120
142GRPCSCRIPTScript20CREATEDBYCreated Bynvarchar120
143GRPCSCRIPT_TEMPScript - Temporary table for installation20CREATEDBYCreated Bynvarchar120
144GRPCTRANSGRC Rules Analysis35CREATEDBYCreated Bynvarchar120
145GRPCTRANS_SNPGRC Rules Analysis36CREATEDBYCreated Bynvarchar120
146GRPC_OLSP_SNPAssign Organization unit value to Organization Unit Group15CREATEDBYCreated Bynvarchar120
TOPProcess Monitoring Infrastructure
147SSPIMODSPI: Change Metadata5CREATEDBYSPI: Created Bynvarchar120
TOPProject System
148PSHLP_DRAFT_DBTable holds Draft Workbench Information11CREATEDBYDraft Created Bynvarchar120
149PSHLP_DRAFT_DB_NTable holds Draft Workbench Information11CREATEDBYDraft Created Bynvarchar120
TOPRuntime WorkbenchMonitoring
150SXMSEPCACHEXI: Runtime Cache for Exchange Profile9CREATEDBYCreated by Usernvarchar120
151SXMSEPCLOGXI: Log Table for Runtime Cache for Exchange Profile5CREATEDBYUser Namenvarchar120
TOPSAP Business Workflow
152SWDAHEADAd Hoc Agents - Header Table4CREATEDBYCreated bynvarchar120
153SWXFORMABSForm: Notification of Absence6CREATEDBYApplicantnvarchar120
154SWXTRAREQUESTTravel Request6CREATEDBYApplicantnvarchar120
TOPTable Maintenance Tool
155SDMEDPCHDME: Dialog Pool Component Header5CREATEDBYDME: Authornvarchar120
TOPTime streams
156TTSTRTime stream: Administration table21CREATEDBYUser that created objectnvarchar120
157TTSTRTTexts for time stream administration table12CREATEDBYUser that created objectnvarchar120
TOPTransport Management System
158CTWFPROPOSTransport Proposal: Header5CREATEDBYCreator of proposalnvarchar120
TOPTravel Planning
159FTPT_REQ_HEADFramework Data of Travel Request22CREATEDBYUser Who Created the Objectnvarchar120
TOPWorkforce Management Core
160/SAPAPO/LRPSUBIDTable for Subscription of Concrete Subjects11CREATEDBYUser Namenvarchar120
161/SAPAPO/LRPSUBTYTable for Subscription of Generic Subjects10CREATEDBYUser Namenvarchar120