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

41 columns | Print definition?ERP 6.0  | ACTFLAG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVCMIS_A_1_DOMASelection of Object Type Master information20ACTFLAGActivation flagnvarchar10
2CNVCMIS_A_1_DTELSelection of Object Type Master information14ACTFLAGActivation flagnvarchar10
3CNVCMIS_A_1_ENQUENQU Data (Header)18ACTFLAGActivation flagnvarchar10
4CNVCMIS_A_1_INDXIndx Table(CMIS)14ACTFLAGActivation flagnvarchar10
5CNVCMIS_A_1_MCIDMCID type Repository Analysis18ACTFLAGActivation flagnvarchar10
6CNVCMIS_A_1_MCOBMCOB type Repository Analysis15ACTFLAGActivation flagnvarchar10
7CNVCMIS_A_1_TABDSelection of Object Type TABLE (TABD) Master information17ACTFLAGActivation flagnvarchar10
8CNVCMIS_A_1_TTYPTable types for Repository Analysis6ACTFLAGActions to be executed for a dependent DD objectnvarchar40
9CNVCMIS_A_1_VIEWVIEW type Repository Analysis16ACTFLAGActivation flagnvarchar10
10DD02BDD: Header for Structured Objects9ACTFLAGActions to be executed for a dependent DD objectnvarchar40
11sap_dblocks1actflagsmallint50
TOPActivation Program, Conversion Program, DB Utility, MC, SPDD
12CD0TBSH001Veri-Struktur mit Suchhilfe-Anbindung13ACTFLAGAktivierungsflagnvarchar10
13DBDCGENTBDD: Persisting Activating Ojects in Mass Activation10ACTFLAGActions to be executed for a dependent DD objectnvarchar40
14DD01LDomains16ACTFLAGActivation flagnvarchar10
15DD02LSAP Tables13ACTFLAGActivation flagnvarchar10
16DD04LData elements12ACTFLAGActivation flagnvarchar10
17DD06LPool/cluster structures8ACTFLAGActivation flagnvarchar10
18DD09LDD: Technical settings of tables16ACTFLAGActivation flagnvarchar10
19DD12LR/3 S_SECINDEX: secondary indexes, header;10ACTFLAGActivation flagnvarchar10
20DD15LR/3 DD: SAP objects7ACTFLAGActivation flagnvarchar10
21DD20LMatchcode objects12ACTFLAGActivation flagnvarchar10
22DD23LMatchcode ID15ACTFLAGActivation flagnvarchar10
23DD25LAggregate Header (Views, MC Objects, Lock Objects)13ACTFLAGActivation flagnvarchar10
24DD29LSelection Condition for Views and MC IDs13ACTFLAGActivation flagnvarchar10
25DD40LTable types (internal tables defined in DD)3ACTFLAGActions to be executed for a dependent DD objectnvarchar40
TOPALE Integration Technology
26EDIMSGOutput Types and Assignment to IDoc Types5ACTFLAGCurrent assignment (not used)nvarchar10
TOPF4 Help
27DD30LSearch helps13ACTFLAGActivation flagnvarchar10
TOPLanguage Transport
28TLSY8Language import client data6ACTFLAGImport Modenvarchar10
TOPLocal Currency Changeover
29EWUPAKEuro conversion packages7ACTFLAGIndicator: Changeover package active?nvarchar10
TOPOccupational Health
30T7EHS00_LIMFORMForm: Restrictions5ACTFLAGActivenvarchar10
31T7EHS00_MCFORMForm: Medical Certificate6ACTFLAGActivenvarchar10
32T7EHS00_VSFORMForm: Protocol Log7ACTFLAGActivenvarchar10
TOPPackage Tools
33AKB_SYSLISTObsolete: BCB System List for Replication9ACTFLAGObsolete: Indicator "Active for BCB Integration"nvarchar10
TOPRisk Analysis
34JBRDERICharacteristic Derivation Settings for Analysis Structure3ACTFLAGRisk Analysis: Indicator - Active Characteristic Derivationnvarchar10
TOPTransport Organizer
35VERSNTABStructures of the sub-objects of versionable objects3ACTFLAGActivation flag for versionable objectsnvarchar10
36VERSOBJList of the Versionable Objects3ACTFLAGActivation flag for versionable objectsnvarchar10
37VERSSUBOBJTable structures for a versionable object3ACTFLAGActivation flag for versionable objectsnvarchar10
38VERS_IFLDSList of fields that are not relevant for comparison3ACTFLAGActivation flag for versionable objectsnvarchar10
39VERS_TABSDDIC structures used in version management2ACTFLAGActivation flag for versionable objectsnvarchar10
TOPUpgrade Tools
40UPG_DD12LICNV: Secondary Indexes - Header11ACTFLAGnvarchar10
TOPWeb Services Tool
41CRMC_WSC_GENSTRWSC Table for generated Structures3ACTFLAGWSC Activation Indicatornvarchar10