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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

37 columns | Print definition?ERP 6.0  | GENFLAG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SDF/CC_RELLink between CC_OBJECTS and CC_REF entries21GENFLAGGeneration flagnvarchar10
2CNVCMIS_A_10RES1CNVCMIS_A_RES131GENFLAGGeneration flagnvarchar10
3CNVCMIS_A_10_SELREPOSITORY ANALYSIS SEL ECTION20GENFLAGGeneration flagnvarchar10
4SCI_HANA_TEST1Katalog der Repository-Objekte9GENFLAGGenerierungskennzeichennvarchar10
5SCI_HANA_TEST2single records buffering9GENFLAGGenerierungskennzeichennvarchar10
6SCI_HANA_TEST2Ageneric buffering9GENFLAGGenerierungskennzeichennvarchar10
7SCI_HANA_TEST2Bfully buffered9GENFLAGGenerierungskennzeichennvarchar10
8SCI_HANA_TEST2Csingle records buffering9GENFLAGGenerierungskennzeichennvarchar10
9SCI_HANA_TEST3buffering allowed but turned off9GENFLAGGenerierungskennzeichennvarchar10
10TSCITKatalog der Repository-Objekte9GENFLAGGenerierungskennzeichennvarchar10
11TSIW_TEST_TAB2Test Table for SIW Mass TABU Producer with 6 key fields7GENFLAGGeneration flagnvarchar10
TOPBW Service API
12RODCHABASInfoObjects / basic characteristics in the source system9GENFLAGFlag: InfoSource was generatednvarchar10
13ROISInfoSources in the source systems6GENFLAGFlag: InfoSource was generatednvarchar10
14ROOSOURCETable Header for SAP BW OLTP Sources (Relevant From 2.0)19GENFLAGDataSource uses generic interfacesnvarchar10
15RSSGTPCLABW Generation Tool: Program Class3GENFLAGGeneration Flagnvarchar10
TOPCentral Part of Product Master
16COMC_CRD_GEN_BWOCRM CRD: Generated Objects for Attribute-DataSources9GENFLAGObjects Generatednvarchar10
17COMC_SETTYPEAdministrative Tables for Set Types26GENFLAGSet Type Has Been Generatednvarchar10
18COMC_SETTYP_ATTRAdministrative Table for Set Type Attribute Information11GENFLAGSet Type Has Been Generatednvarchar10
19COMM_FRGTYPESet Type9GENFLAGSet Type Has Been Generatednvarchar10
TOPChange Transport System
20GTADIRGlobal Object Directory7GENFLAGGeneration flagnvarchar10
21GTADIRAGlobal Object List (Change and Transport System)7GENFLAGGeneration flagnvarchar10
22TTADIRBuffer Memory for Unchecked TADIR Entries9GENFLAGGeneration flagnvarchar10
TOPData Staging
23RSISOLTPInfoSources (tranascation data) in source system5GENFLAGIndicator: Object was generatednvarchar10
24RSISSHShadow table: InfoSource12GENFLAGBooleannvarchar10
25RSOSOLTPInfoSources (master data, ...) in the source system10GENFLAGIndicator: Object was generatednvarchar10
TOPHR Managers Desktop
26HRP1019DB Table for Infotype 1019 Required Positions19GENFLAGGeneration Executednvarchar10
TOPMobile Applications
27/ISDFPS/ME_SFLDDO Segement Fields32GENFLAGIndicatornvarchar10
TOPProfitability Analysis
28TKEASCO-PA derivation rules: Control table10GENFLAGFlag for generation of derivation structurenvarchar10
TOPService Data Download
29/SDF/CMO_T_42DCustomer Objects in Analysis Period9GENFLAGGeneration flagnvarchar10
TOPService Implementation Workbench
30TSIW_TEST_TABTest Table for SIW Mass TABU Producer9GENFLAGGeneration flagnvarchar10
TOPTransport Organizer
31KTADIRDirectory of Repository Objects9GENFLAGGeneration flagnvarchar10
32TADIRDirectory of Repository Objects9GENFLAGGeneration flagnvarchar10
33TADIR_TMPNewly Created Repository Objects6GENFLAGGeneration flagnvarchar10
34TRESCReserved Names for Customizing Tables/Objects5GENFLAGID for "implicitly generated"nvarchar10
TOPUpgrade - General
35LTODIRObject List for Switch13GENFLAGGeneration flagnvarchar10
36TODIRObject List for Switch13GENFLAGGeneration flagnvarchar10
37TTODIRObject List for Switch13GENFLAGGeneration flagnvarchar10