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

53 columns | Print definition?ERP 6.0  | SEGID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
TOPBW Service API
1ROOSGENSEGGenerated Objects for OLTP Source4SEGIDOld Segment ID (CHAR1)nvarchar10
2ROOSGENTFSTRTransfer Structure (Character) Segmented4SEGIDSegment ID (NUMC4, corresponding to RSDS_SEGID in BW)nvarchar40
3ROOSSEGSegments of a DataSource3SEGIDSegment ID (NUMC4, corresponding to RSDS_SEGID in BW)nvarchar40
TOPData Staging
4RSBERRORCHANGEDLog of Changed Records3SEGIDSegmentnvarchar40
5RSBERRORLOGLogs for Incorrect Records3SEGIDSegmentnvarchar40
6RSDAARCHREQCREFAssignment of Archiving Request to Source Request3SEGIDSegment ID in Archivingnvarchar40
7RSDADAPIDXBW Archiving: Archive Index3SEGIDSegmentnvarchar40
8RSDADAPIDXOBJBW Archiving: Further Index Characteristics3SEGIDSegmentnvarchar40
9RSDANLREQDPAKSEGBW Archiving: Segment in Nearline Request Data Package3SEGIDSegment ID in Archivingnvarchar40
10RSDANLSEGBW Archiving: Segment of a Nearline Object2SEGIDSegmentnvarchar40
11RSDANLSEGIBW Archiving: Fields of a Segment Index2SEGIDSegmentnvarchar40
12RSDANLSEGIFBW Archiving: Segment Index of a Nearline Object2SEGIDSegmentnvarchar40
13RSDANLSEGVBW Archiving: Errors for a Segment Version2SEGIDSegmentnvarchar40
14RSDANLSEGVFBW Archiving: Segment Version of a Nearline Object2SEGIDSegmentnvarchar40
15RSDANLSEGVIBW Archiving: Errors for a Segment Version2SEGIDSegmentnvarchar40
16RSDSRTSEGCOUNTDataSource: Data Package ID Counter, Record3SEGIDSegmentnvarchar40
17RSDSSEGDataSource - Segments4SEGIDSegmentnvarchar40
18RSDSSEGFDDataSource - Segment Fields4SEGIDSegmentnvarchar40
19RSDSSEGFDSHDataSource in BW - Shadow Table Fields4SEGIDSegmentnvarchar40
20RSDSSEGFDTDataSource - Texts for Segment Fields5SEGIDSegmentnvarchar40
21RSDSSEGFDTSHDataSource in BW - Shadow Table Field Texts5SEGIDSegmentnvarchar40
22RSDSSEGSHDataSource in BW - Shadow Table Segments4SEGIDSegmentnvarchar40
23RSDSSEGTDataSource - Segment Texts5SEGIDSegmentnvarchar40
24RSDSSEGTSHDataSource in BW - Shadow Table Segment Texts5SEGIDSegmentnvarchar40
25RSDSTRANSTRUDataSource: Transfer Structures3SEGIDSegmentnvarchar40
26RSKSFIELDNEWFields for New InfoSource3SEGIDSegment Numbernvarchar40
27RSKSSEGTXTTexts for Segments4SEGIDSegment Numbernvarchar40
28RSOLTPSOURCESEGSegments of a DataSource4SEGIDSegment IDnvarchar10
29RSOLTPSOURCESEGTSegment Texts for DataSource5SEGIDSegment IDnvarchar10
30RSOLTPSOURCESFISegment Fields of a DataSource4SEGIDSegment IDnvarchar10
31RSOLTPSOURCESFITTexts for the Segment Fields of a DataSource5SEGIDSegment IDnvarchar10
32RSOSSEGFIEMAPMapping between DataSource and InfoSource Segments (Fields)4SEGIDSegment IDnvarchar10
33RSOSSEGFIEMAPSHMapping between DataSource and InfoSource Segments (Fields)3SEGIDSegment IDnvarchar10
34RSOSSEGMAPMapping between DataSource and InfoSource Segments4SEGIDSegment IDnvarchar10
35RSOSSEGMAPSHMapping between DataSource and InfoSource Segments3SEGIDSegment IDnvarchar10
36RSTRANFIELDMapping of Rule Parameters - Structure Fields3SEGIDSegment Numbernvarchar40
37RSTRANFIELDPROPField Properties Within Transformation (obsolete?)3SEGIDSegment Numbernvarchar40
38RSTRANGROUPFIELDSelected Grouping Fields of Transformation (Source)3SEGIDSegment Numbernvarchar40
39RSTRANROUTMAPRule Type: Routine7SEGIDSegment Numbernvarchar40
40RSTRANSEGUsed segments3SEGIDSegment Numbernvarchar40
41RSTRFIELDSHShadow table: Transfer Structure Fields3SEGIDSegment IDnvarchar10
42RSTRRULESSHShadow table: Transfer Structure Transfer Rules3SEGIDSegment IDnvarchar10
43RSTRSHShadow table: Transfer Structure3SEGIDSegment IDnvarchar10
TOPIncentive and Commission Management ICM
44CACS_SEGAGRAgreement for The Assignment of Segments6SEGIDNumber of segmentnvarchar120
45CACS_SEGMNTSegment4SEGIDNumber of segmentnvarchar120
46CACS_SEGMNTTSegment: Text5SEGIDNumber of segmentnvarchar120
TOPInternationalization I18N
47TCP00SAP code page catalog24SEGIDStart Segment of Code Pagenvarchar50
48TCPSATTRCode Page Segment Attributes1SEGIDName for Code Page Segmentnvarchar50
49TCPSBUILDIterative Structure of Code Page Segments1SEGIDName for Code Page Segmentnvarchar50
50TCPSEGList of Code Page Segments1SEGIDName for Code Page Segmentnvarchar50
51TCPSPTLCode Points (Up to 126 Bytes long)1SEGIDName for Code Page Segmentnvarchar50
52TCPSPTSCode Points (up to 4 Bytes Long)1SEGIDName for Code Page Segmentnvarchar50
53TCPSRULECode Page Segment Special Rules1SEGIDName for Code Page Segmentnvarchar50