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  | HANDLE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMERP/STG_PM001Data staging - Equipment complex table71HANDLESAP Development Reserve: Integration of Date Segment (Key)nvarchar220
2/SMERP/STG_PM002Data staging - Functional Location complex table60HANDLESAP Development Reserve: Integration of Date Segment (Key)nvarchar220
3/SMERP/STG_PM003Data staging - Equipment List Set - Hdr - complex tab71HANDLESAP Development Reserve: Integration of Date Segment (Key)nvarchar220
4/SMERP/STG_PM008Data staging - Functional Loc. List Set - Hdr - complex tab60HANDLESAP Development Reserve: Integration of Date Segment (Key)nvarchar220
5CNV_20340_ME_DISCustomizing for parameter visibility in ME UI3HANDLEIdentifier of a Table in a Hierarchical Mappingnvarchar320
6CNV_MBT_ME_SIM_AAlias table to determine Name for different handls in mapp's2HANDLEIdentifier of a Table in a Hierarchical Mappingnvarchar320
7LTMC_DISP_TEMPGeneric store for extracts4HANDLEMgt. ID for repeated calls from the same programnvarchar40
8NWVIEW_019Special View Data for Workflow Tasks9HANDLEMgt. ID for repeated calls from the same programnvarchar40
9TILMSTORRDBLOB_2ILM DB Store: Table of Resources for AU Tests1HANDLEILM Storage: Resource Handlenvarchar320
10TILM_STORILM DB Store: Root Table / Mapping URI HANDLE2HANDLEILM Storage: Resource Handlenvarchar320
11TILM_STOR_AUDITILM DB Store: Audit Information about Payload Requests2HANDLEILM Storage: Resource Handlenvarchar320
12TILM_STOR_BLOBILM DB Store: Table of Resources1HANDLEILM Storage: Resource Handlenvarchar320
13TILM_STOR_COLILM DB Store: Table of Collections1HANDLEILM Storage: Resource Handlenvarchar320
14TILM_STOR_PROPILM DB Store: Archive Properties1HANDLEILM Storage: Resource Handlenvarchar320
15TILM_STOR_RTIILM DB Store: Table of Runtime Properties1HANDLEILM Storage: Resource Handlenvarchar320
16TILM_STOR_RTMILM DB Store: Runtime Management1HANDLEILM Storage: Resource Handlenvarchar320
17ZEIM_LIPSSD document: Delivery: Item data200HANDLEWorldwide unique key for LIPS-VBELN & LIPS_POSNRnvarchar220
18ZEIM_VBAKSales Document: Header Data109HANDLEInternational unique key for VBAK-VBELNnvarchar220
TOPAccounting Engine
19/EACC/DERIVCHARSTarget Characteristics in Derivation Steps5HANDLEDerivation Step Handle (GUID)varbinary160
20/EACC/DERIV_CONDConditions for Derivation Steps5HANDLEDerivation Step Handle (GUID)varbinary160
21/EACC/DERIV_EXITMethods for Derviation Exits7HANDLEDerivation Step Handle (GUID)varbinary160
22/EACC/JRNL_DERIVDerivation Configuration for the Journal9HANDLEDerivation Step Handle (GUID)varbinary160
23/EACC/TDR_STEPSDerivation Steps2HANDLEDerivation Step Handle (GUID)varbinary160
24/EACC/TDR_STEPSTDerivation Steps - Texts2HANDLEDerivation Step Handle (GUID)varbinary160
25/EACC/VIEWDCHARSSource Characteristics in Derivation Steps6HANDLEDerivation Step Handle (GUID)varbinary160
26/EACC/VIEW_DERIVDerivation Configuration Requirements in a View7HANDLEDerivation Step Handle (GUID)varbinary160
TOPAdditionals Management
27WTADABAdditionals: Documents7HANDLEGlobally unique identifier (linked to time segment, etc)nvarchar220
TOPASAP AcceleratedSAP
28SASAPBCSETBC Sets in Q&Adb1HANDLEBC Sets: Container for 32-character GUIDnvarchar320
TOPAuthentication and SSO
29SAML2_ARTIFACTStorage Table for SMAL2 Artifacts2HANDLEHash Value of the SAML2 Entity Namevarbinary200
TOPBasic functions
30HUINV_HDRHandling Unit: Phys. Inv. Document Header2HANDLEUUID in X form (binary)varbinary160
31HUINV_ITEMHandling Unit: Physical Inventory Document Item2HANDLEUUID in X form (binary)varbinary160
32HUINV_SERNRHandling Unit Phys. Inv. Doc. - Serial Numbers for Item2HANDLEUUID in X form (binary)varbinary160
33VEKPHandling Unit - Header Table70HANDLEWorldwide unique key for VEKP-VENUMnvarchar220
34VEVWWhere-Used List for Handling Units2HANDLEWorldwide unique key for VEKP-VENUMnvarchar220
TOPBRFplus - ABAP-Based Business Rules
35FDT_DEBUG_INDXSystem Table INDX3HANDLEFDT: Universal Unique Identifiernvarchar320
TOPClinical System
36NWPLACE_P01IS-H / IS-H*MED: Aspects in the Patient Organizer10HANDLEMgt. ID for repeated calls from the same programnvarchar40
37NWPLACE_PERSIS-H / IS-H*MED: Pers.Information for the Work Environment6HANDLEMgt. ID for repeated calls from the same programnvarchar40
38NWVIEW_006IS-H / IS-H*MED: Special View Data Documents9HANDLEMgt. ID for repeated calls from the same programnvarchar40
39NWVIEW_011IS-H / IS-H*MED: Special View Data Surgeries9HANDLEMgt. ID for repeated calls from the same programnvarchar40
40NWVIEW_012IS-H / IS-H*MED: Special View Data Drug Order9HANDLEMgt. ID for repeated calls from the same programnvarchar40
41NWVIEW_013IS-H / IS-H*MED: Special View Data Drug Events9HANDLEMgt. ID for repeated calls from the same programnvarchar40
42NWVIEW_015Medication: Medication Order, Cross-Institutional9HANDLEMgt. ID for repeated calls from the same programnvarchar40
43NWVIEW_016IS-H / ISHMED: Special View Data Dictations9HANDLEMgt. ID for repeated calls from the same programnvarchar40
44NWVIEW_017i.s.h.med: Special View Data Surgery Progress Monitor9HANDLEMgt. ID for repeated calls from the same programnvarchar40
45NWVIEW_018IS-H/ISHMED: Special View Data Surgery Planning Work Station9HANDLEMgt. ID for repeated calls from the same programnvarchar40
46NWVIEW_P01IS-H / IS-H*MED: Spezialization Table for Patient Organizer12HANDLEMgt. ID for repeated calls from the same programnvarchar40
TOPConsolidation
47TF515Journal Entry Layout: Field Names4HANDLEMgt. ID for repeated calls from the same programnvarchar40
TOPCross-Application Component CA Enhancements
48/SAPMP/MIG_T001Migration CS -> DIMP: Object Status Material Master20HANDLEApplication Log: Log Handlenvarchar220
49/SAPMP/MIG_T002Migration CS -> DIMP: Object Status Batch Stock23HANDLEApplication Log: Log Handlenvarchar220
50/SAPMP/MIG_T003Migration CS -> DIMP: Object Status Material BOM14HANDLEApplication Log: Log Handlenvarchar220
51/SAPMP/MIG_T004Migration CS -> DIMP: Object Status Routing14HANDLEApplication Log: Log Handlenvarchar220
52/SAPMP/MIG_T005Migration CS -> DIMP: Object Status Production Version13HANDLEApplication Log: Log Handlenvarchar220
TOPCross-Application Components
53CKLTEXGeneric store for extracts5HANDLEMgt. ID for repeated calls from the same programnvarchar40
54CMLTEXGeneric store for extracts5HANDLEMgt. ID for repeated calls from the same programnvarchar40
55VVBAKSales Document: Header Data109HANDLEInternational unique key for VBAK-VBELNnvarchar220
TOPData Staging
56RSDDICDTELGenerated structures for function mod. RSAR_POPUP_GET_VALUES1HANDLEBW Generation tool: GUID in compressed form (CHAR25)nvarchar250
57RSDDICSTRUCTGenerated structures for function mod. RSAR_POPUP_GET_VALUES1HANDLEBW Generation tool: GUID in compressed form (CHAR25)nvarchar250
TOPDenmark
58T5MAHFile Access Path3HANDLEHandle for File Operationsnvarchar40
TOPEnvironment, Health and Safety
59EHSBT_APPL_SCOPEEHS: General Scope of Application24HANDLEEHS: General Context Informationnvarchar300
TOPEquipment
60EQUIEquipment master data66HANDLESAP Development Reserve: Integration of Date Segment (Key)nvarchar220
TOPFast Search Infrastructure
61SFSRFW_LOAD_HDLReplication Framework - List of Batch Job Handles6HANDLEReplication Framework - Handleimage21474836470
TOPFunctional Locations
62IFLOTFunctional Location (Table)54HANDLESAP Development Reserve: Integration of Date Segment (Key)nvarchar220
63IFLOT_VSFunctional Location (Version Table)55HANDLESAP Development Reserve: Integration of Date Segment (Key)nvarchar220
TOPGoods Issue Process
64/SPE/XHU_LOCK_01Handling Unit Lock Structure - with VENUM3HANDLEWorldwide unique key for VEKP-VENUMnvarchar220
65/SPE/XHU_LOCK_02Handling Unit Lock Structure - w/o venum3HANDLEWorldwide unique key for VEKP-VENUMnvarchar220
TOPMaintenance Notifications
66QMELQuality Notification108HANDLEGlobally unique identifier (linked to time segment, etc)nvarchar220
67QMSMQuality notification - tasks38HANDLEGlobally unique identifier (linked to time segment, etc)nvarchar220
TOPMaintenance Orders
68/MRSS/D_ENG_LOGProtokolltabelle für Engineläufe2HANDLELog Handle Exactly One Entry in RCCFnvarchar220
TOPMedia Product Sales and Distribution
69JKSDTRANSFERIS-M: BP Goods Transfer32HANDLEApplication Log: Log Handlenvarchar220
TOPOLAP Technology
70RSDRATCOSTRuntime Estimation Check1HANDLENatural Numberint100
TOPPatient Management
71NWVIEW_001IS-H / IS-H*MED: Speical View Data for Occupancy9HANDLEMgt. ID for repeated calls from the same programnvarchar40
72NWVIEW_002IS-H / IS-H*MED: Special View Data for Arrivals9HANDLEMgt. ID for repeated calls from the same programnvarchar40
73NWVIEW_003IS-H / IS-H*MED: Special View Data for Departures9HANDLEMgt. ID for repeated calls from the same programnvarchar40
74NWVIEW_004IS-H / IS-H*MED: Special View Data for Requests9HANDLEMgt. ID for repeated calls from the same programnvarchar40
75NWVIEW_005IS-H / IS-H*MED: Special View Data for Transport Orders9HANDLEMgt. ID for repeated calls from the same programnvarchar40
76NWVIEW_007IS-H/IS-H*MED: Special View Data Svce Facility/Outp. Clinic9HANDLEMgt. ID for repeated calls from the same programnvarchar40
77NWVIEW_008IS-H/IS-H*MED: Special View Data Medical Controlling9HANDLEMgt. ID for repeated calls from the same programnvarchar40
78NWVIEW_009IS-H / IS-H*MED: Special View Data Occupancy Characteristic9HANDLEMgt. ID for repeated calls from the same programnvarchar40
79NWVIEW_010IS-H / IS-H*MED: Special View Data Preregistrations9HANDLEMgt. ID for repeated calls from the same programnvarchar40
80NWVIEW_PERSPersonalization Information for View12HANDLEMgt. ID for repeated calls from the same programnvarchar40
TOPPlanning
81NWVIEW_014IS-H / IS-H*MED: Appointment Planning Special View Data9HANDLEMgt. ID for repeated calls from the same programnvarchar40
82RSPLS_ENQ_MASTERTable of Master Locks2HANDLEGUID in 'CHAR' Format in Uppercasenvarchar320
TOPProduct Data Management
83CONV_FILEClipboard for Objects to Convert2HANDLEKey for identifying a particular conversionnvarchar320
84CONV_MATRICESMatrixes that must be checked into BOMs2HANDLEInternal Identification for DMU Objects of Type RAW 16varbinary160
TOPProduction Orders
85NAVP_DEFAULTNavigation Profile: Default Profiles3HANDLEAdministration ID for Multiple Calls from the Same Programnvarchar40
86NAVP_FUNCFunction of a Navigation Profile3HANDLEAdministration ID for Multiple Calls from the Same Programnvarchar40
87NAVP_FUNC_TEXTText for Function of a Navigation Profile3HANDLEAdministration ID for Multiple Calls from the Same Programnvarchar40
88NAVP_PROFILENavigation Profile3HANDLEAdministration ID for Multiple Calls from the Same Programnvarchar40
89NAVP_PROF_TEXTText for the Navigation Profile3HANDLEAdministration ID for Multiple Calls from the Same Programnvarchar40
90NAVP_SGP_MATCHSET/GET Parameter Matching for the Function of a Profile3HANDLEAdministration ID for Multiple Calls from the Same Programnvarchar40
TOPRemote Control and Communication Framework
91RCCD_ENG_LOGLog Table for Engine Runs2HANDLELog Handle of Exactly One Entry in RCCFnvarchar220
TOPReport Selection for Product Costing
92TKKBORSELCustomizing Table for Order Selection3HANDLEMgt. ID for repeated calls from the same programnvarchar40
TOPResourcen Management
93RMSTT_TBLB_USRRMS-TLS: User Settings for Title Elements (Tabstrip Library)3HANDLEHandle for Saving a Tab Title Configurationnvarchar150
TOPSales
94VBAKSales Document: Header Data109HANDLEInternational unique key for VBAK-VBELNnvarchar220
TOPSAP Business Workflow
95SWT_LOGCATWorkflow trace catalog2HANDLEID of Workflow Tracenvarchar120
96SWT_LOGENTWorkflow: Selections in a workflow trace2HANDLEID of Workflow Tracenvarchar120
97SWWWIHEADWorkflow Runtime: Header Table for All Work Item Types32HANDLEID of Workflow Tracenvarchar120
TOPSAP Healthcare - Industry-Specific Components for Hospitals
98NWVIEW_FR1IS-H-FR: Special View Data for Absences9HANDLEMgt. ID for repeated calls from the same programnvarchar40
99NWVIEW_NL1Sichtdaten cockpit9HANDLEVerwaltungsID für Mehrfachaufrufe aus dem selben Programmnvarchar40
TOPSAP List Viewer
100LTCXGeneric store for extracts4HANDLEMgt. ID for repeated calls from the same programnvarchar40
101LTDXGeneric storage of display variants4HANDLEMgt. ID for repeated calls from the same programnvarchar40
102LTDXBStorage of BLOBs for display variants from LTDX4HANDLEMgt. ID for repeated calls from the same programnvarchar40
103LTDXDDefault display variants4HANDLEMgt. ID for repeated calls from the same programnvarchar40
104LTDXSSAP Default Display Variants4HANDLEMgt. ID for repeated calls from the same programnvarchar40
105LTDXTDisplay Variant Texts4HANDLEMgt. ID for repeated calls from the same programnvarchar40
106LTEXGeneric store for extracts4HANDLEMgt. ID for repeated calls from the same programnvarchar40
TOPSCM Basis
107CIF_MAP_HANDLETable: Conversion of Object ID to Unique Handle2HANDLENatural Numberint100
TOPShipping
108LIKPSD Document: Delivery Header Data113HANDLEWorldwide unique key for LIKP-VBELNnvarchar220
109LIPSSD document: Delivery: Item data200HANDLEWorldwide unique key for LIPS-VBELN & LIPS_POSNRnvarchar220
110LIPSRFLIPS Reference Data2HANDLEWorldwide unique key for LIPS-VBELN & LIPS_POSNRnvarchar220
111VRSLIReceipt of Materials from Deliveries2HANDLEGlobally unique identifier (linked to time segment, etc)nvarchar220
TOPSimulation
112VSVBAK_CNVersion: Sales document: Header data110HANDLEInternational unique key for VBAK-VBELNnvarchar220
TOPSyntax, Compiler, Runtime
113SABAP_ALV_CHECKSTable for Collecting Dynamic ALV Check Data9HANDLEMgt. ID for repeated calls from the same programnvarchar40
TOPTime streams
114TTSTRTime stream: Administration table6HANDLETime stream: Time stream handlenvarchar320
115TTSTRCOMPCompiled time stream (data container)3HANDLETime stream: Time stream handlenvarchar320
116TTSTRCOMPHCompiled time stream (runtime header)3HANDLETime stream: Time stream handlenvarchar320
TOPTransaction Manager
117RDPT_FILE_PATHSave the File Path of the Transaction3HANDLEAdministration ID for Multiple Calls from Same Programnvarchar40
TOPTransportation
118VTTKShipment Header85HANDLEGlobally unique identifier (linked to time segment, etc)nvarchar220
TOPWaste Management
119TSERVHANDLEControl for Maintenance of Service Frequency2HANDLEIndicator for Service Frequency Maintenancenvarchar10
TOPWithout Description
120RSDDSTATStatistics data BW for aggregate selection and accounting5HANDLEBW: General reference field for internal IDsnvarchar40