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

92 columns | Print definition?ERP 6.0  | OLTPSOURCE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBP_BW_TIMESTAMPTime Stamp for Delta Handling (Data Transfer EBP -> BW)2OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
2T7PIQBW_DATASOURBW Extraction: Map DataSource with FM for Delta Queue1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
3T7PIQBW_DELTABW Extraction: Map Infotype <-> BW Data Source5OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
TOPAssetLiability Management
4SAVID_DELTA_STATStatus of Delta Update2OLTPSOURCEInfoSource (master data, text and hierarchies)nvarchar300
TOPBW Interface
5DPR_BW_DQ_DScProjects BW: Object Cat./DataSource/DataSource Type Assign.4OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
TOPBW Service API
6ROAUTHAuthorizations for DataSources1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
7ROBWQTSTATDelta Update Status1OLTPSOURCEInfoSource (master data, text and hierarchies)nvarchar300
8RODSEXITDataSource Events1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
9ROEXSOURCEABAP Source Code for BW Extractors1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
10ROMDDELTABIW: DataSource Assignment - Change Pointer1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
11ROOHIECATAdditional Hierarchy Information for DS in Source System1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
12ROOHIECOMCompound Information for Hierarchy DS in Source System1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
13ROOSATTRDataSource Attributes1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
14ROOSESRMAPMapping DataSource ESR (Serialized Object)1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
15ROOSFIELDDataSource Fields1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
16ROOSGENGenerated Objects for OLTP Source1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
17ROOSGENDLMGeneric Delta Management for DataSources (Client-Dep.)1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
18ROOSGENDLTGeneric Delta Management for DataSources1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
19ROOSGENQGenerated Coding for DS (Only for Delta Queue at Present)1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
20ROOSGENQVExtract Structure Versions1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
21ROOSGENQVFField Descriptions for Extract Structure Versions1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
22ROOSGENRTGenerated Objects for OLTP Source1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
23ROOSGENSEGGenerated Objects for OLTP Source1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
24ROOSGENTFSTRTransfer Structure (Character) Segmented1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
25ROOSOURCETable Header for SAP BW OLTP Sources (Relevant From 2.0)1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
26ROOSOURCETTexts for an OLTP Source2OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
27ROOSPRMSControl Parameters Per DataSource1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
28ROOSPRMSCControl Parameter Per DataSource Channel1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
29ROOSPRMSFControl Parameters Per DataSource1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
30ROOSSEGSegments of a DataSource1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
31ROOSSHORTNDataSource Short Name1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
32ROPROXCONFDeprecated1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
33ROPROXYObsolete: DataSource Proxies1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
34ROPXCONFDataSource Proxy Setting3OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
35RSAOLTP_DSWRITEGenerated Reports for File Output1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
TOPContract Billing
36TE538DataSources for Mass Simulation3OLTPSOURCEDataSource for Mass Simulationnvarchar300
TOPData Conversion
37DMC_BWIBData from BW Query Inbound Processing7OLTPSOURCEDataSourcenvarchar300
TOPData Staging
38RS3RDFLDNEWVariable Fields of Third Party Source System - New2OLTPSOURCEDataSourcenvarchar300
39RS3RDFLDNEWTText Table for Var. Fields of Third Party Source Sys.- New3OLTPSOURCEDataSourcenvarchar300
40RSGENEXITCreate Exit Management for Generating Applications for IOBJ1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
41RSGENFIELDMAPIOBJ Field Mapping for Generating Applications1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
42RSGENISOSMAPHeader Mapping for Generating Applications1OLTPSOURCEDataSourcenvarchar300
43RSISOSIBUSHThe OLTPSource is suited for which IBUs?1OLTPSOURCEDataSourcenvarchar300
44RSISOSMAPMapping Between InfoSources and OLTP Sources1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
45RSISOSMAPSHShadow Table: Mapping between InfoSources and OLTPSource1OLTPSOURCEDataSourcenvarchar300
46RSISOSNDPSHThe OLTPSource is suited to which NDP?1OLTPSOURCEDataSourcenvarchar300
47RSLDPIOLog.data packet: No.16OLTPSOURCEInfoSourcenvarchar300
48RSLDPIOSHLog.data packet: No.13OLTPSOURCEInfoSourcenvarchar300
49RSMONENQEnqueue table for scheduler3OLTPSOURCEInfoSourcenvarchar300
50RSOACUBE_DSOURCEBW OLTP Direct Access: Not Assigned DataSources3OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
51RSOLTPHIECOMReplicate of Compounding Info. for Hier.-DataSource in BW1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
52RSOLTPSOURCEReplicate Table for OLTP Sources in BW1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
53RSOLTPSOURCEFDSHShadow Table: OLTP Source Fields1OLTPSOURCEDataSourcenvarchar300
54RSOLTPSOURCEFIEOLTP Source Fields1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
55RSOLTPSOURCEFIETTexts for OLTP Source Fields2OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
56RSOLTPSOURCEFTSHTexts for OLTP Source Fields2OLTPSOURCEDataSourcenvarchar300
57RSOLTPSOURCESEGSegments of a DataSource1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
58RSOLTPSOURCESEGTSegment Texts for DataSource2OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
59RSOLTPSOURCESFISegment Fields of a DataSource1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
60RSOLTPSOURCESFITTexts for the Segment Fields of a DataSource2OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
61RSOLTPSOURCESHShadow Table: Replica Table for OLTP Sources in BW1OLTPSOURCEDataSourcenvarchar300
62RSOLTPSOURCETSegment Texts for a DataSource2OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
63RSOLTPSOURCETSHShadow Table: Texts for OLTP Sources2OLTPSOURCEDataSourcenvarchar300
64RSOSFIELDMAPMapping Between OLTP Source Fields and InfoObjects1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
65RSOSFIELDMAPSHShadow Table: Mapping between OLTPs, Fields and IOBJs1OLTPSOURCEDataSourcenvarchar300
66RSOSGENMAPInformation on Mapping Generation: IS OLTP Source1OLTPSOURCEDataSourcenvarchar300
67RSOSOHIESHShadow Table: Hierarchy Information in BW1OLTPSOURCEDataSourcenvarchar300
68RSOSOHIETSHShadow Table: Hierarchy Information in BW2OLTPSOURCEDataSourcenvarchar300
69RSOSSEGFIEMAPMapping between DataSource and InfoSource Segments (Fields)1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
70RSOSSEGFIEMAPSHMapping between DataSource and InfoSource Segments (Fields)1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
71RSOSSEGMAPMapping between DataSource and InfoSource Segments1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
72RSOSSEGMAPSHMapping between DataSource and InfoSource Segments1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
73RSREQPROGSGenerated Programs for Each Request11OLTPSOURCEDataSourcenvarchar300
74RSSDLCONVEXIT1Saving conversion exits in/output1OLTPSOURCEDataSourcenvarchar300
75RSSDLINITLast Valid Initializations to an OLTP Source1OLTPSOURCEInfoSourcenvarchar300
76RSSDLINITDELLast Valid Initializations to an OLTP Source1OLTPSOURCEInfoSourcenvarchar300
77RSSDLINITSELLast Valid Initializations to an OLTP Source1OLTPSOURCEInfoSourcenvarchar300
78RSSELDONEMonitor: Selections for executed request57OLTPSOURCEDataSourcenvarchar300
79RSSTATMANPARTStore for G_T_PART of Request Display in DTA Administration26OLTPSOURCEDataSourcenvarchar300
80RSSTATMANPSAStore for G_T_PART of Request Display in DTA Administration13OLTPSOURCEDataSourcenvarchar300
81RSSTATMAN_SAVE2Store for G_T_PART of Request Display in DTA Administration26OLTPSOURCEDataSourcenvarchar300
TOPGeneral Ledger Accounting
82FAGL_DSOURCE_RLDNew General Ledger Accounting: Assign Ledger to DataSource1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
TOPInformation System
83BIW_PS_DELTAAdmin. Data for Delta Extraction of Master Data3OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
84HTDRM_BW_TMSTMPDRM Timestamp for BW extractor1OLTPSOURCEInfoSource (master data, text and hierarchies)nvarchar300
TOPInformation System, iViews
85BWOM2_SAFETYBW CO-OM: Float After Production For Determ. of Time Stamp2OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
86BWOM2_TIMESTBW CO-OM: Timestamp Table for Delta Extraction2OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
87BWOM_SETTINGSBW CO-OM: Control Data2OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
TOPMDG for Financials
88USMDZ5200Determination Entity Type Depending on DataSource2OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
TOPPersonnel Time Management
89PTDW_RFC_ASSIGNSAP-internal Assignment Table for RFC Call Ups1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
TOPPublic Sector Contract Accounts Receivable and Payable
90DFMCA_FPF_BILog of Mass Activities for Delta Update3OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
91TFMCA_FORMCustomizing Table for Forms9OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300
TOPUniversal Data Integration
92RSSDKGENMETATable Stores Generic UDConnect Mapping Info1OLTPSOURCEDataSource (OSOA/OSOD)nvarchar300