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

67 columns | Print definition?ERP 6.0  | ISOURCE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1HRBW_CNTB_DELTATime stamps for Payroll Reconcilliation Extractors2ISOURCEInfoSourcenvarchar300
TOPBW Service API
2AQBWCATInfoSource Catalog (SAP Query) Customer1ISOURCEInfoSourcenvarchar300
3AQBWCAT_SAPInfoSource Catalog (SAP Query) Used by SAP1ISOURCEInfoSourcenvarchar300
4AQBWFCATInfoSource Catalog (SAP Query) Customer1ISOURCEInfoSourcenvarchar300
5AQBWFCAT_SAPField catalog for InfoSources (SAP Query) used by SAP1ISOURCEInfoSourcenvarchar300
6ROISInfoSources in the source systems1ISOURCEInfoSourcenvarchar300
7ROISGENGenerated objects for the InfoSource1ISOURCEInfoSourcenvarchar300
8ROISIOBJBW: Assignment of InfoSource Fields to InfoObjects1ISOURCEInfoSourcenvarchar300
9ROISTName of the InfoSources2ISOURCEInfoSourcenvarchar300
TOPData Basis
10RSDCUBEDirectory of InfoCubes / InfoProvider38ISOURCEInfoSourcenvarchar300
TOPData Retention Tool
11TXW_DIRData file log (replaced by txw_dir2, use of guids)5ISOURCEInfo Source (should be overwritten with RSISOURCE from BRS)nvarchar300
12TXW_DIR2Data file log7ISOURCEInfo Source (should be overwritten with RSISOURCE from BRS)nvarchar300
13TXW_DIRSEGData file segment directory (replaced by txw_dirsg2: uuids)20ISOURCEInfo Source (should be overwritten with RSISOURCE from BRS)nvarchar300
14TXW_DIRSG2Data file segment directory20ISOURCEInfo Source (should be overwritten with RSISOURCE from BRS)nvarchar300
TOPData Staging
15RSGENISOSMAPHeader Mapping for Generating Applications4ISOURCEInfoSourcenvarchar300
16RSISInfoSource (transaction data)1ISOURCEInfoSourcenvarchar300
17RSISFIELDInfoSource fields (provider structure of all systems)1ISOURCEInfoSourcenvarchar300
18RSISFIELDSHShadow table: InfoSource fields3ISOURCEInfoSourcenvarchar300
19RSISNInfoSource - Header Table1ISOURCEInfoSourcenvarchar300
20RSISNFIELDInfoSource - Field Table1ISOURCEInfoSourcenvarchar300
21RSISNTInfoSource - Texts2ISOURCEInfoSourcenvarchar300
22RSISODSODS1ISOURCEInfoSourcenvarchar300
23RSISOFIELDInfoSource fields (provider structure of a source system)1ISOURCEInfoSourcenvarchar300
24RSISOLTPInfoSources (tranascation data) in source system1ISOURCEInfoSourcenvarchar300
25RSISOSELFDInfoSource selection fields of a source system1ISOURCEInfoSourcenvarchar300
26RSISOSMAPMapping Between InfoSources and OLTP Sources4ISOURCEInfoSourcenvarchar300
27RSISOSMAPSHShadow Table: Mapping between InfoSources and OLTPSource3ISOURCEInfoSourcenvarchar300
28RSISSELFDSHShadow table: InfoSource fields3ISOURCEInfoSourcenvarchar300
29RSISSHShadow table: InfoSource3ISOURCEInfoSourcenvarchar300
30RSISTInfoSource texts2ISOURCEInfoSourcenvarchar300
31RSISTSHShadow table: InfoSource texts4ISOURCEInfoSourcenvarchar300
32RSKSFIELDNEWFields for New InfoSource1ISOURCEInfoSourcenvarchar300
33RSKSNEWNew InfoSource - TLOGO: TRCS1ISOURCEInfoSourcenvarchar300
34RSKSNEWTNew InfoSource Texts2ISOURCEInfoSourcenvarchar300
35RSKSSEGTXTTexts for Segments2ISOURCEInfoSourcenvarchar300
36RSOACUBEBW OLTP Direct Access: List of Virtual InfoCubes3ISOURCEInfoSourcenvarchar300
37RSREQPROGSGenerated Programs for Each Request14ISOURCEInfoSourcenvarchar300
38RSSTATMANPARTStore for G_T_PART of Request Display in DTA Administration24ISOURCEInfoSourcenvarchar300
39RSSTATMANPSAStore for G_T_PART of Request Display in DTA Administration11ISOURCEInfoSourcenvarchar300
40RSSTATMAN_SAVE2Store for G_T_PART of Request Display in DTA Administration24ISOURCEInfoSourcenvarchar300
41RSUPDENQRemoval of locks in the update rules2ISOURCEInfoSourcenvarchar300
42RSUPDINFOUpdate info (status and program)4ISOURCEInfoSourcenvarchar300
43RSUPDSIMULHTable for saving simulation data header information9ISOURCEInfoSourcenvarchar300
TOPHR Information Systems
44HRMS_BIW_PPDELTABW: Delta management for posting-data extractors2ISOURCEInfoSourcenvarchar300
TOPInformation System
45T804JReport Writer: Read module for table class S4ISOURCEInfoSourcenvarchar300
46T881ISFI-SL Ledger3ISOURCEInfoSourcenvarchar300
47T881IS_PIAssignment of TT/SI DataSource for FI-SL Ledger (Plug-In)3ISOURCEInfoSourcenvarchar300
TOPLogistics Information System LIS
48TMCEXACTLO Data Extraction: Activate Data Sources/Update3ISOURCEDataSource (OSOA/OSOD)nvarchar300
TOPOLAP Technology
49RSBBSCUBEBW: InfoCube Receiver10ISOURCEInfoSourcenvarchar300
50RSBBSQUERYBW: Query Receiver11ISOURCEInfoSourcenvarchar300
51RSDDSTATEXTRACTExtractor BW statistics: Time of last delta load2ISOURCEInfoSourcenvarchar300
52RSDDSTATWHMStatistics Data: BW for Warehouse Management5ISOURCEInfoSourcenvarchar300
TOPOverhead Cost Controlling
53OMIS_IS_PIDAllocation of InfoSource to InfoSourceViewer ProGID1ISOURCEInfoSourcenvarchar300
TOPProfitability Analysis
54TKEBWLCO-PA Connection to SAP BW: InfoSources1ISOURCECO-PA Connection to SAP BW: CO-PA InfoSourcenvarchar300
55TKEBWLFCO-PA Connection to SAP BW: Fields for the InfoSources1ISOURCEInfoSourcenvarchar300
56TKEBWLGCO-PA Connectn to SAP BW: Status Information for InfoSource1ISOURCEInfoSourcenvarchar300
57TKEBWLGNCO-PA Connectn to SAP BW: Status Information for InfoSource1ISOURCEInfoSourcenvarchar300
58TKEBWLOGActivity Log CO-PA Extractor for SAP BW1ISOURCEInfoSourcenvarchar300
59TKEBWLOGNActivity Log CO-PA Extractor for SAP BW1ISOURCEInfoSourcenvarchar300
60TKEBWLSCO-PA Connection to SAP BW: Selection Condition1ISOURCEInfoSourcenvarchar300
61TKEBWLTCO-PA Connection to SAP BW: InfoSource Texts1ISOURCECO-PA Connection to SAP BW: CO-PA InfoSourcenvarchar300
62TKEBWLXCO-PA / SAP BW: Debugging Transaction Data Extractor1ISOURCECO-PA Connection to SAP BW: CO-PA InfoSourcenvarchar300
63TKEBWLXNCO-PA / SAP BW: Debugging Transaction Data Extractor1ISOURCEInfoSourcenvarchar300
64TKEBWLYCO-PA / SAP BW: Read Special Settings from DataSource1ISOURCECO-PA Connection to SAP BW: CO-PA InfoSourcenvarchar300
65TKEBWTSCO-PA Connection to SAP BW: Processed Time Intervals2ISOURCEInfoSourcenvarchar300
66TKEBWTSNCO-PA Connection to SAP BW: Processed Time Intervals1ISOURCEInfoSourcenvarchar300
TOPWithout Description
67RSTCMASTERLOADMaster data: Time of Last Load2ISOURCEInfoSourcenvarchar300