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

117 columns | Print definition?ERP 6.0  | RNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMSBW_REQOBJRequests and objects between tdms ERP and BI5RNRBI Request(RNR)nvarchar300
2RSREQMAP_SAVE2Monitor: Saving of the updated IC and ODS per request1RNRRequest ID (Request Number)nvarchar300
3RSREQMDEL_SAVE2Monitor: Saving of the updated IC and ODS per request2RNRRequest ID (Request Number)nvarchar300
4TESTDATRNRPARTARequest Join Table1RNRRequest ID (Request Number)nvarchar300
5TESTDATRNRPARTBRequest Join Table1RNRRequest ID (Request Number)nvarchar300
6TESTDATRNRPARTCRequest Join Table1RNRRequest ID (Request Number)nvarchar300
7TESTDATRNRPARTDRequest Join Table1RNRRequest ID (Request Number)nvarchar300
8TESTDATRNRPARTERequest Join Table1RNRRequest ID (Request Number)nvarchar300
9TESTDATRNRPARTFRequest Join Table1RNRRequest ID (Request Number)nvarchar300
10TESTDATRNRPARTGRequest Join Table1RNRRequest ID (Request Number)nvarchar300
11TESTDATRNRPARTHRequest Join Table1RNRRequest ID (Request Number)nvarchar300
12TESTDATRNRPARTIRequest Join Table1RNRRequest ID (Request Number)nvarchar300
13TESTDATRNRPARTJRequest Join Table1RNRRequest ID (Request Number)nvarchar300
14TESTDATRNRPARTKRequest Join Table1RNRRequest ID (Request Number)nvarchar300
15TESTDATRNRPARTLRequest Join Table1RNRRequest ID (Request Number)nvarchar300
16TESTDATRNRPARTMRequest Join Table1RNRRequest ID (Request Number)nvarchar300
17TESTDATRNRPARTNRequest Join Table1RNRRequest ID (Request Number)nvarchar300
18TESTDATRNRPARTORequest Join Table1RNRRequest ID (Request Number)nvarchar300
19TESTDATRNRPARTPRequest Join Table1RNRRequest ID (Request Number)nvarchar300
20TESTDATRNRPARTQRequest Join Table1RNRRequest ID (Request Number)nvarchar300
21TESTDATRNRPARTRRequest Join Table1RNRRequest ID (Request Number)nvarchar300
22TESTDATRNRPARTSRequest Join Table1RNRRequest ID (Request Number)nvarchar300
23TESTDATRNRPARTTRequest Join Table1RNRRequest ID (Request Number)nvarchar300
24TESTDATRNRPARTURequest Join Table1RNRRequest ID (Request Number)nvarchar300
25TESTDATRNRPARTVRequest Join Table1RNRRequest ID (Request Number)nvarchar300
26TESTDATRNRPARTWRequest Join Table1RNRRequest ID (Request Number)nvarchar300
27TESTDATRNRPARTXRequest Join Table1RNRRequest ID (Request Number)nvarchar300
28TESTDATRNRPARTYRequest Join Table1RNRRequest ID (Request Number)nvarchar300
29TESTDATRNRPARTZRequest Join Table1RNRRequest ID (Request Number)nvarchar300
TOPData Staging
30RS2NDPROCPROTEvents Log5RNRRequest number for the data transfernvarchar300
31RSBOOKProcessing of IDocs in the batch6RNRRequest number for the data transfernvarchar300
32RSCRTDONECRT Packages Enhancements for Apollo1RNRRequest ID (Request Number)nvarchar300
33RSCRTMONDATACopy of INDX for CRT Runtime Data2RNRRequest ID (Request Number)nvarchar300
34RSCRT_CONFIRMTIDs for CRT Daemon1RNRRequest ID (Request Number)nvarchar300
35RSCRT_CTRLControl Information for Active (Near)-Real-Time InfoPackages5RNRRequest ID (Request Number)nvarchar300
36RSCRT_DEMON_LOGLog Table for Daemon12RNRRequest ID (Request Number)nvarchar300
37RSCRT_DEMON_TRACStorage for Performance/Trace Data for Real-Time Data Acqui.1RNRRequest ID (Request Number)nvarchar300
38RSCRT_RDA_MONDATCopy of INDX for CRT Runtime Data2RNRRequest ID (Request Number)nvarchar300
39RSCRT_RDA_TRACEObsolete1RNRRequest ID (Request Number)nvarchar300
40RSDELDONEBW: Selection Table for Deletion with Full Update Scheduler1RNRRequest number for the data transfernvarchar300
41RSDELPARTAggregation management of the IC for the Monitor2RNRRequest number for the data transfernvarchar300
42RSDSGENDELTADPLast Delta State by Data Package (for Numeric Pointer)5RNRRequest ID (Request Number)nvarchar300
43RSDTA_PERF_ADMPerformance Improvement for PSA Load, etc.3RNRMaster data IDint100
44RSHIEDONESelection table for Fields Scheduler1RNRRequest number for the data transfernvarchar300
45RSHIEFOLTTMPHelp Table for Packaged Loading of Hierarchies1RNRRequest number for the data transfernvarchar300
46RSHIEINTVLTMPHelp Table for Packaged Loading of Hierarchies1RNRRequest number for the data transfernvarchar300
47RSHIENODETMPHelp Table for Packaged Loading of Hierarchies1RNRRequest number for the data transfernvarchar300
48RSHIETXTTMPHelp Table for Loading Packaged Hierarchies1RNRRequest number for the data transfernvarchar300
49RSICCONTMonitor: Saving of the updated IC and ODS per request1RNRRequest number for the data transfernvarchar300
50RSICCONTDELMonitor: Saving of the updated IC and ODS per request1RNRRequest number for the data transfernvarchar300
51RSICCONT_SAVERequests Deleted from Administration Stored Here1RNRRequest number for the data transfernvarchar300
52RSICCONT_SAVE2Monitor: Saving of the updated IC and ODS per request1RNRRequest number for the data transfernvarchar300
53RSICNEWREQRequests for the reconstruction of an IC2RNRRequest number for the data transfernvarchar300
54RSICODS_SAVEMonitor: Saving of the updated IC and ODS per request1RNRRequest number for the data transfernvarchar300
55RSICPROTLogs for Processed Jobs7RNRRequest ID (Request Number)nvarchar300
56RSICSDELSTATStatistics on Records in Requests After Selective Deletion4RNRRequest ID (Request Number)nvarchar300
57RSIDOCSAVEIDoc table of the monitor for requests1RNRRequest number for the data transfernvarchar300
58RSLDTDONETexts on the requested InfoPackages and groups1RNRRequest number for the data transfernvarchar300
59RSMONEXTService Table for Extractor for Selection Cube (for Delta)2RNRRequest number for the data transfernvarchar300
60RSMONFACTFact table monitor1RNRRequest number for the data transfernvarchar300
61RSMONICDPMonitor Request Data Packet Table1RNRRequest number for the data transfernvarchar300
62RSMONICDP_SAVERequests Deleted from Administration Stored Here1RNRRequest number for the data transfernvarchar300
63RSMONICDP_SAVE2Monitor Request Data Packet Table1RNRRequest number for the data transfernvarchar300
64RSMONICTABMonitor IC table1RNRRequest number for the data transfernvarchar300
65RSMONIPTABInfoPackage for the monitor1RNRRequest number for the data transfernvarchar300
66RSMONJUDGEMonitor: Evaluating a Request1RNRRequest number for the data transfernvarchar300
67RSMONMESSMessages for the monitor1RNRRequest number for the data transfernvarchar300
68RSMONNEWPROTLog Requests for Reconstruction and Cancellation Request1RNRRequest number for the data transfernvarchar300
69RSMONPCLoad-Monitor Connection of Process Runs1RNRRequest number for the data transfernvarchar300
70RSMONPROCESSProcesses that have worked with requests1RNRRequest ID (Request Number)nvarchar300
71RSMONRQTABMonitor table for request IDocs1RNRRequest number for the data transfernvarchar300
72RSMONSTACKCall Stack Monitor with Error Messages1RNRRequest number for the data transfernvarchar300
73RSODSACTSELActivation of ODS M Records8RNRRequest number for the data transfernvarchar300
74RSREQARCHCTRLArchiving for Request Control Records1RNRRequest ID (Request Number)nvarchar300
75RSREQARCHDELArchiving for Request Control Records1RNRRequest ID (Request Number)nvarchar300
76RSREQARCHMONTotals Record of Monitor Tables after Archiving1RNRRequest ID (Request Number)nvarchar300
77RSREQDONEMonitor: Saving of the QM entries1RNRRequest number for the data transfernvarchar300
78RSREQDPTIDNote TID for Request and Data Package1RNRRequest number for the data transfernvarchar300
79RSREQHIERData Request Hierarchy1RNRRequest ID (Request Number)nvarchar300
80RSREQICODSMonitor: Saving of the updated IC and ODS per request1RNRRequest number for the data transfernvarchar300
81RSREQICODS_SAVERequests Deleted from Administration Stored Here1RNRRequest number for the data transfernvarchar300
82RSREQICODS_SAVE2Monitor: Saving of the updated IC and ODS per request1RNRRequest number for the data transfernvarchar300
83RSREQPROGSGenerated Programs for Each Request1RNRRequest ID (Request Number)nvarchar300
84RSREQSTORNOReversal of requests in IC1RNRRequest number for the data transfernvarchar300
85RSRNRRequest table1RNRRequest number for the data transfernvarchar300
86RSRULEDONEABAP Code for Scheduler Selections1RNRRequest number for the data transfernvarchar300
87RSSDLINITLast Valid Initializations to an OLTP Source3RNRRequest number for the data transfernvarchar300
88RSSDLINITDELLast Valid Initializations to an OLTP Source3RNRRequest number for the data transfernvarchar300
89RSSDLINITSELLast Valid Initializations to an OLTP Source3RNRRequest number for the data transfernvarchar300
90RSSELDONEMonitor: Selections for executed request1RNRRequest number for the data transfernvarchar300
91RSSELDTPSelection Conditions for Output in Administration1RNRRequest ID (Request Number)nvarchar300
92RSSIMUDATTransfer table for simulation of IDocs1RNRRequest number for the data transfernvarchar300
93RSSMPARTSCRATCH1Temporary Data for Join1RNRRequest ID (Request Number)nvarchar300
94RSSMWPDPSAVESave work process and data packet ID for editing1RNRRequest number for the data transfernvarchar300
95RSSTATMANPARTStore for G_T_PART of Request Display in DTA Administration3RNRRequest ID (Request Number)nvarchar300
96RSSTATMANPARTTStore for G_T_PART of Request Display in DTA Administration4RNRRequest ID (Request Number)nvarchar300
97RSSTATMANPSAStore for G_T_PART of Request Display in DTA Administration2RNRRequest ID (Request Number)nvarchar300
98RSSTATMANPSATStore for G_T_PART of Request Display in DTA Administration3RNRRequest ID (Request Number)nvarchar300
99RSSTATMANREQMAPMapping of Higher- to Lower-Level Status Manager Request1RNRRequest ID (Request Number)nvarchar300
100RSSTATMANREQMDELMapping of Higher- to Lower-Level Status Manager Request2RNRRequest ID (Request Number)nvarchar300
101RSSTATMANSTATDELStatus Manager Table of Deleted Request Status2RNRRequest ID (Request Number)nvarchar300
102RSSTATMANSTATUSApollo Status Manager Management Table of Request Status1RNRRequest ID (Request Number)nvarchar300
103RSSTATMANT_SAVE2Store for G_T_PART of Request Display in DTA Administration4RNRRequest ID (Request Number)nvarchar300
104RSSTATMAN_SAVE2Store for G_T_PART of Request Display in DTA Administration3RNRRequest ID (Request Number)nvarchar300
105RSTCPDONESelection table for 3rd party; Scheduler1RNRRequest number for the data transfernvarchar300
106RSUICDONEBIW: Selection table for user-selection update ICs1RNRRequest number for the data transfernvarchar300
107RSUPDSIMULHTable for saving simulation data header information1RNRRequest number for the data transfernvarchar300
108TESTDATRNRPART0Request Join Table 01RNRRequest ID (Request Number)nvarchar300
109TESTDATRNRPART1Temprary RNR Table 11RNRRequest ID (Request Number)nvarchar300
110TESTDATRNRPART2Request Join Table 21RNRRequest ID (Request Number)nvarchar300
111TESTDATRNRPART3Request Join Table 31RNRRequest ID (Request Number)nvarchar300
112TESTDATRNRPART4Request Join Table 41RNRRequest ID (Request Number)nvarchar300
113TESTDATRNRPART5Request Join Table 51RNRRequest ID (Request Number)nvarchar300
114TESTDATRNRPART6Request Join Table 61RNRRequest ID (Request Number)nvarchar300
115TESTDATRNRPART7Request Join Table 71RNRRequest ID (Request Number)nvarchar300
116TESTDATRNRPART8Request Join Table 81RNRRequest ID (Request Number)nvarchar300
117TESTDATRNRPART9Request Join Table 91RNRRequest ID (Request Number)nvarchar300