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

33 columns | Print definition?ERP 6.0  | CREP_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/XFT/APPLLAYCREPApplication layer: HTTP destination4CREP_IDContent repository IDnvarchar300
2/XFT/EPA_DELDECLRejected Documents2CREP_IDContent repositorynvarchar320
3/XFT/EPA_DELMDATManually Set Deletion Date2CREP_IDContent repositorynvarchar320
4/XFT/EPA_DELRUNNRunning Deletion Processes2CREP_IDContent repositorynvarchar320
5/XFT/EPA_DPERS/XFT/EPA_PERS2CREP_IDContent Repository Identificationnvarchar20
6/XFT/EPA_RECPOSProperty extension: File nodes ArchiveLink documents4CREP_IDContent repositorynvarchar320
7/XFT/EPA_TPROTLog9CREP_IDContent Repository Identificationnvarchar20
8/XFT/MIG_DOCSDokumente in Migration2CREP_IDContent Repository Quellenvarchar300
9/XFT/STLCERTCREPxft StorageLink: Crep -> Certificate2CREP_IDContent Repository IDnvarchar300
10/XFT/STLCHEADxft StorageLink: Headertabelle für Komponenten Infos3CREP_IDContent Repository IDnvarchar300
11/XFT/STLHEADxft StorageLink: Header Tabelle3CREP_IDContent Repository IDnvarchar300
12/XFT/STLSSTRATxft StorageLink: Ablagestrategie2CREP_IDContent Repository IDnvarchar300
13CNVCMIS_A_ARCHCMIS table for storing info. about active archive objects6CREP_IDStorage Repository for Physical Objectsnvarchar300
14CNVCMIS_A_OPCREPOptical archive Crep table info4CREP_IDStorage Repository for Physical Objectsnvarchar300
15CNV_CMIS_A_ARCHCMIS table for storing info. about active archive objects6CREP_IDStorage Repository for Physical Objectsnvarchar300
16TILM_STOR_ALILM DB Store: Mapping of ArchiveLink to Content Repository1CREP_IDStorage Repository for Physical Objectsnvarchar300
TOPArchiving Connector ABAP
17ARCHLNK_AL_INDEXAssignment of BOR Key to ArchiveLink Attachment Doc_ID6CREP_IDCharacter field of length 40nvarchar400
18ARCHLNK_DL_INDILM: Attributes for Finding ArchiveLink Print Lists in RW12CREP_IDCharacter field of length 40nvarchar400
TOPBasis Components
19/XFT/INV_VIEW02Administration table for buffer table3CREP_IDContent repository IDnvarchar300
TOPContent Management Service
20CREPKPRO CMS: Content Repositories1CREP_IDStorage Repository for Physical Objectsnvarchar300
21CREPDESCRKPRO CMS: Descriptions of Content Repositories1CREP_IDStorage Repository for Physical Objectsnvarchar300
22CREPDOCSPDocument Areas for Content Repositories1CREP_IDStorage Repository for Physical Objectsnvarchar300
23CREP_FILEKPRO CMS: Content Repositories (RFC)1CREP_IDStorage Repository for Physical Objectsnvarchar300
24CREP_FTPKPRO CMS: Content Repositories (FTP)1CREP_IDStorage Repository for Physical Objectsnvarchar300
25CREP_HTTPKPRO CMS: Content Repositories (HTTP)1CREP_IDStorage Repository for Physical Objectsnvarchar300
26CREP_LREPKPro CMS: Content Repositories (Logical Repository)1CREP_IDStorage Repository for Physical Objectsnvarchar300
27CREP_R3DBKPRO CMS: Content Repositories (R3DB)1CREP_IDStorage Repository for Physical Objectsnvarchar300
28CREP_RACLCertificates for HTTP Access to R3 Database1CREP_IDStorage Repository for Physical Objectsnvarchar300
29CREP_RFCKPRO CMS: Content Repositories (RFC)1CREP_IDStorage Repository for Physical Objectsnvarchar300
30CREP_RPCKPRO CMS: Content Repositories (RPC)1CREP_IDStorage Repository for Physical Objectsnvarchar300
31CREP_TREEKPRO CMS: Content Repositories (TREE)1CREP_IDStorage Repository for Physical Objectsnvarchar300
TOPContract Accounts Receivable and Payable
32TFK068ACustomizing of Document Categories3CREP_IDStorage Repository for Physical Objectsnvarchar300
TOPSAP Records Management
33SRMALDOCSRM: Management Table for ArchiveLink Documents3CREP_IDStorage Repository for Physical Objectsnvarchar300