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

147 columns | Print definition?ERP 6.0  | CREATED

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XFT/EPA_APL_002Header table application file5CREATEDSystem Datenvarchar80
2BICS_BOOKMARKHeader table for bookmarks created via ABAP BICS5CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
3CNVCMIS_A_1_LDBDAdministration information for LDB6CREATEDUtilities time zones: Time stamp, Create objectnvarchar140
4CNVFIELDMAPConversion: Table mapping7CREATEDCreator of control datanvarchar400
5CNVFIELDMAPFUNCConversion: Mapping Methods for Field Mapping7CREATEDCreator of control datanvarchar400
6CNVINCLTABConversion: Includes for certain tables7CREATEDCreator of control datanvarchar400
7CNVLTHCM_ADDTABOBSOLETE! DO NOT USE!!!7CREATEDCreator of control datanvarchar400
8CNVLTHCM_APPLTABOBSOLETE! DO NOT USE!!!7CREATEDCreator of control datanvarchar400
9CNVLTHCM_BASETABLT HCM: List of HCM Basis Tables5CREATEDCreator of control datanvarchar400
10CNVLTHCM_CWBPACKLT HCM: Assigned CWB Packages7CREATEDCreator of control datanvarchar400
11CNVLTHCM_DELOPTLT HCM: Options for Deletion of HCM Tables7CREATEDCreator of control datanvarchar400
12CNVLTHCM_DELTABLT HCM: List of HCM Tables to be Deleted8CREATEDCreator of control datanvarchar400
13CNVLTHCM_HRDOMOBSOLETE! DO NOT USE!!!5CREATEDCreator of control datanvarchar400
14CNVLTHCM_HRDOM2LT HCM: Domains of HCM Tables6CREATEDCreator of control datanvarchar400
15CNVLTHCM_HRPCKOBSOLETE! DO NOT USE!!!4CREATEDCreator of control datanvarchar400
16CNVLTHCM_HRPCK2LT HCM: HCM Development Packages5CREATEDCreator of control datanvarchar400
17CNVLTHCM_HRTABLT HCM: List of HCM Tables for Transfer8CREATEDCreator of control datanvarchar400
18CNVLTHCM_INDXTRNLT HCM: Cluster Components for Transfer8CREATEDCreator of control datanvarchar400
19CNVLTHCM_MIGSCENLT HCM: Migration Scenario9CREATEDCreator of control datanvarchar400
20CNVLTHCM_PRESELLT HCM: HR Object Selection Assignment to Package6CREATEDCreator of control datanvarchar400
21CNVLTHCM_RCVINFOLT HCM: Information about Receiver System10CREATEDCreator of control datanvarchar400
22CNVLTHCM_SELTABSLT HCM: Data Selection for Tables21CREATEDCreator of control datanvarchar400
23CNVLTHCM_SELTYPLT HCM: Customer-defined Selection Types4CREATEDCreator of control datanvarchar400
24CNVLTHCM_TABGRPLT HCM: Table Groups5CREATEDCreator of control datanvarchar400
25CNVLTHCM_TABOPTOBSOLETE! DO NOT USE!!!5CREATEDCreator of control datanvarchar400
26CNVLTHCM_TP_DEFLT HCM: Time-point Processing - Definition10CREATEDCreator of control datanvarchar400
27CNVLTHCM_TP_MAPLT HCM: Time-point Mapping6CREATEDCreator of control datanvarchar400
28CNVTABLEMAPConversion: Table mapping5CREATEDCreator of control datanvarchar400
29CNV_00001_FDOMSOBSOLETE: Use CNVDOMS10CREATEDCreator of control datanvarchar400
30CNV_00001_FORMSForm routines used in conversions14CREATEDCreator of control datanvarchar400
31CNV_00001_PARSParameters of form routines used in conversion9CREATEDCreator of control datanvarchar400
32CNV_00001_PDOMSDomains suitable for conversion routine parameters11CREATEDCreator of control datanvarchar400
33CNV_10996_FIELDSSpecific conversion routines17CREATEDCreator of control datanvarchar400
34CNV_10996_FIPARSParameters for specific conversion routines8CREATEDCreator of control datanvarchar400
35CNV_20200_SP_TABDefinition of tables for the Special Priority Handling9CREATEDCreator of control datanvarchar400
36CNV_20200_SP_VALControl Table for the Special Priority Handling7CREATEDCreator of control datanvarchar400
37CNV_20317_DATBIDetermination for date dependent tables17CREATEDCreator of control datanvarchar400
38CNV_20400_EXCLUTables to be excluded10CREATEDCreator of control datanvarchar400
39CNV_20551_TABCVTTables for special (re-) processing6CREATEDCreator of control datanvarchar400
40CNV_INDX_CLUSTSINDX clusters6CREATEDCreator of control datanvarchar400
41CNV_INDX_FIELDSINDX conversion: Conv.-relev. RELID component fields13CREATEDCreator of control datanvarchar400
42CNV_INDX_FIPARSINDX conversion: Parameters for conv. of RELID comp. fields10CREATEDCreator of control datanvarchar400
43CNV_INDX_IEINCLSIncludes for versions of RELID import/export routines8CREATEDCreator of control datanvarchar400
44CNV_INDX_IEVERSAdditional versions of RELID import/export routines9CREATEDCreator of control datanvarchar400
45CNV_INDX_IEVPARSParameters of RELID import/export routines10CREATEDCreator of control datanvarchar400
46CNV_INDX_IEVRULERules for choosng RELID structure variant6CREATEDCreator of control datanvarchar400
47CNV_INDX_IEVRULPParameters of rules for choosng RELID structure variant8CREATEDCreator of control datanvarchar400
48CNV_INDX_INCLINDX conversion: Includes for INDX RELID conversion8CREATEDCreator of control datanvarchar400
49CNV_INDX_PACKCNFConfiguration of the INDX conversion for the package12CREATEDCreator of control datanvarchar400
50CNV_INDX_RELIDSINDX cluster RELIDs9CREATEDCreator of control datanvarchar400
51CNV_INDX_STEPSINDX conversion: process-related functions12CREATEDCreator of control datanvarchar400
52CNV_INDX_STPARSINDX conversion: Parameters for process-related functions11CREATEDCreator of control datanvarchar400
53CNV_INDX_STRUCTSStructures of INDX RELIDs10CREATEDCreator of control datanvarchar400
54CNV_INDX_STRVERSAdditional versions of RELID structure retrieval methods6CREATEDCreator of control datanvarchar400
55CNV_INDX_TABLESINDX conversion: Conv.-relev. RELID components11CREATEDCreator of control datanvarchar400
56DMC_VERSIONVersion of MWB Basis Package3CREATEDnvarchar80
57EHPRCD_COD_ROOTCompliance Data Object : Root28CREATEDCompliance Data Created fromnvarchar10
58GRPCDBBUFDashboard buffer8CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
59RSRT_BOOKMARKBookmark for RSRT BICS8CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
60SRM_USR01Internet User Data4CREATEDGeneral Flagnvarchar10
TOPAdaptor
61UKM_DCDOBJCredit Management Link to DCD Case7CREATEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPBasic functions
62HUWM_LOAD_PROTLog Table of Initial Data Transfer for Subsequent Posting69CREATEDCheckboxnvarchar10
TOPBasic Functions
63TTSTRSDWorking Times in SD/WS6CREATEDTime at which object was createddecimal150
TOPBusiness Application Support
64CNVDOMSCNV: Domains required by conversion package13CREATEDCreator of control datanvarchar400
65CNVDOPARSConversion: Parameters for the FORM routines from CNVDOMS11CREATEDCreator of control datanvarchar400
66CNVFIELDSConversion: Table fields affected17CREATEDCreator of control datanvarchar400
67CNVFIPARSConversion: Parameters for conversion of table fields8CREATEDCreator of control datanvarchar400
68CNVINCLConversion: of includes required by conversion package5CREATEDCreator of control datanvarchar400
69CNVSTEPSConversion: procedure-related functions9CREATEDCreator of control datanvarchar400
70CNVSTPARSConversion: Parameters for procedure-related functions9CREATEDCreator of control datanvarchar400
71CNVTABLESConversion: Tables for processing by package17CREATEDCreator of control datanvarchar400
72CNV_00001_PARAMSParameter table12CREATEDCreator of control datanvarchar400
TOPCapacity Evaluations
73CYTSTR_TABTime stream keys8CREATEDTime at which object was createddecimal150
TOPCorporate Performance Monitor
74UMC_LG100Log6CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
75UMC_TD100Task List10CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPData Staging
76RSPCCHAINATTRAttributes for a Process Chain13CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPDevice Management
77TELOT_RESULTResults of Lot Allocation for Belgium/Netherlands11CREATEDLot created for selectionnvarchar10
TOPEnd User Technology
78RSKPI_CATKPI Catalog: Node6CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
79RSKPI_KPIKPI: Header Data9CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
80RSKPI_VNTKPI Variant: Header Data8CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
81RSKPI_WLKPI Watchlist: Header Data3CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
82RSRDE_DOCDocuments for Broadcasting3CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
83RSRD_HASHSTRINGHash Strings of BI Data during Precalculations5CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
84RSRD_REGISTRATNRegistration of Settings to Events (Broadcasting)5CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
85RSRD_SETTINGBroadcasting Settings7CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
86RSZCOMPDIRDirectory of reporting components17CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
87RSZWBOOKMARKHeader Table of the Bookmarks7CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
88RSZWREPITEMSTOREOBSOLETE ! Storagetable of Report Designer Reports6CREATEDDate data element for SYSTnvarchar80
TOPGeneral Ledger Accounting
89FAGL_DATAC_CLUSTContent of Data Container5CREATED(8-character) Date for SYSTnvarchar80
TOPGeographical Functions
90GEOLOCGeo location (lon/lat/alt/...)10CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
91GEOOBJRGen. object ref. (customer, plant, ...)8CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPGovernance, Risk and Compliance
92GRFNDMLOGDatamart: Central Log8CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPIncentive and Commission Management ICM
93FPP_CLUSTContent of Data Container5CREATED(8-character) Date for SYSTnvarchar80
TOPInformation Quality Management
94SIQMOBJECTSObject Type (Information Quality)7CREATEDCreate Start Time/Datedecimal217
95SIQMRESULTSInformation Quality Results (Main Table)9CREATEDCreate Start Time/Datedecimal217
TOPIntegration Engine
96SXMS_AS_STATUSStatus Table of Synchronous/Asynchronous Bridge8CREATEDUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
97SXMS_FEHLock Entries for FEH4CREATEDUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217
TOPInvoicing
98EBBPTEMPTemporary Budget Billing Data23CREATEDBudget Billing Plan Creatednvarchar10
TOPliveCache Applications
99/SAPAPO/UPGRADEData for Release Upgrade6CREATEDUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217
TOPLogical DB, Selection Screens, Selection Variants
100LDBDAdministration information for LDB2CREATEDUtilities time zones: Time stamp, Create objectnvarchar140
TOPMaintenance Processing
101/MRSS/D_BAS_ASGMRS Basis Assignments22CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
102/MRSS/D_DEM_DATADemand Master Data11CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPManagement of Internal Controls
103FOPCRBFLOGReporting Buffers: Central Log7CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPOffice Suite Program
104/OSP/T_CJS_GJGeneric Journal10CREATEDUTC Timestamp (YYYYMMDDhhmmss)nvarchar140
TOPPeriodical Sales and Distribution
105JVTNOTADMIS-M/SD: Administrative Data on Carrier Change Notification4CREATEDIS-M/SD: Carrier Change Notifications Creatednvarchar10
TOPPrice Planning Workbench
106WRF_PPW_PPDVERSVersion-Dependent Header Data11CREATEDPrice Plan Created onnvarchar140
TOPProcess Controls
107GRPCRBFLOGReporting Buffers: Central Log7CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPProduct Safety
108TCGES01EHS: Worklist for Enterprise Search PS Background Process3CREATEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPRecords and Case Management
109RMPSPRO_FOLDHISTHistory Table for Used Folder5CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPSales
110LORD_XSTRINGLean Order: Temporary container for DOC/RTL content, XSTRING4CREATEDData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPSAP Records Management
111SRMORGHISSRM Organizer : Worklist5CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPSecurity
112SEC_ST_CACHE_DBSecurity Token Cache Repository3CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
113SEC_ST_REPLAY_DBTable for replac detection4CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPService Data Download
114/BDL/BADHOSTSList of host that have not been transferred for certain dest8CREATEDABAP Time Stampnvarchar140
115/BDL/MAINTAINControl Table: Session refresh / service defintion resfres26CREATEDABAP Time Stampnvarchar140
116/BDL/SAPOSSinformation table for OSS-User16CREATEDnvarchar140
117/BDL/SESSMAPControl table for SDCC sessions28CREATEDABAP Time Stampnvarchar140
118/BDL/TASKSControl Table of Task Manager29CREATEDABAP Time Stampnvarchar140
TOPServices
119FINB_PR_TOBJSPersistence Objects29CREATEDTimestamp (date and time) for usernvarchar140
TOPSupplier Managed Inventory
120SMI_BORDER_HISTSMI Limit History5CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
121SMI_HEADERSMI Header Data13CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
122SMI_PROFILESMI Profile36CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
TOPTime streams
123TTSTRTime stream: Administration table20CREATEDTime at which object was createddecimal150
124TTSTRTTexts for time stream administration table11CREATEDTime at which object was createddecimal150
TOPWaste Management
125EWA_EL_DELVRYBANDelivery Lock7CREATEDCreated Onnvarchar80
126EWA_EL_SAMPLESample6CREATEDCreated Onnvarchar80
TOPWorkbench Utilities
127RLB_DB_FVReuse Library: Table for Storing Favorites4CREATEDReuse Library: Date the Product was Creatednvarchar80
TOPWorkforce Management Core
128/SAPAPO/LRPASGLCTable of Dispatching Details for Assignment21CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
129/SAPAPO/LRPASSARTable of Dispatching Details for Assignment22CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
130/SAPAPO/LRPASSGNObsolete: Table of Dispatching Details for Assignment21CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
131/SAPAPO/LRPASSIGTable of Dispatching Details for Assignment21CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
132/SAPAPO/LRPDEMHLRP Requirements5CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
133/SAPAPO/LRPGWGOPProxy for Groupware Object7CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
134/SAPAPO/LRPGWWOPProxy for Workforce Management Objects10CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
135/SAPAPO/LRPLOCDDemand Locations10CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
136/SAPAPO/LRPLOCRWFM Supplied Location Table for Resources12CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
137/SAPAPO/LRPRESOKey and Descriptive Data for a Resource5CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
138/SAPAPO/LRPRKEYObsolete since 110: Key and Descriptive Data for a Resource5CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
139/SAPAPO/LRPRTSATAttributes for a Requirement's Time Data5CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
140/SAPAPO/LRPSCHEDObsolete: Planning Step Table5CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
141/SAPAPO/LRPSTSATAttributes for Resource's Time Data5CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
142/SAPAPO/LRPSUBIDTable for Subscription of Concrete Subjects10CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
143/SAPAPO/LRPSUBTYTable for Subscription of Generic Subjects9CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
144/SAPAPO/LRPTSATTObsolete: Attributes for Time Data5CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
145/SAPAPO/TSTASGLCTable of Dispatching Details for Assignment21CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
146/SAPAPO/TSTASSIGTable of Dispatching Details for Assignment21CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150
147/SAPAPO/TSTRESOKey and Descriptive Data for a Resource5CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150