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
Controlling
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0IAOM_BS_MASTER321Business Scenario Control TableControlling
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT BS_IDENT, BS_DEV_CLASS, BS_VCL_PRGM, BS_VIM_FGRP, BS_TAB_TYPE_DET, BS_TAB_SCEN_DET, BS_TAB_ASSIGN, BS_VV_COSCENARIO, BS_VCL_NAME, BS_VIEW_SELECT, BS_CO_SINGLE, BS_CO_MULTIPLE, BS_CO_DIRECT, BS_CO_PROJECT, BS_CO_NOT_RELEV, BS_CO_SINGLE_LEV, BS_CO_AUFART, BS_TAB_SUB_OBJ, BS_US_REF_IGNORE, BS_US_REF_ADOPT, BS_US_RF_AD_SET, BS_US_RF_AD_CRST, BS_US_RF_AD_COP, BS_NO_CX_SUB_OBJ, BS_HLO_CHANGE, BS_REF_CHANGE, BS_CTP_CHANGE, BS_CO_PROFIDPROJ, BS_WRITE_HISTORY, BS_WRTE_USE_HIST, BS_NO_HISTORY, BS_GROUP_IDENT FROM IAOM_BS_MASTER
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1BS_IDENTBusiness Scenario for Which Controlling Is Performednvarchar160 Allow NULL? 
2BS_DEV_CLASSDevelopment Class for Generated Objs of a Business Scenarionvarchar300 Allow NULL? 
3BS_VCL_PRGMProgram Pool of View Cluster Maintenance CO Scen. Determ.nvarchar400 Allow NULL? 
4BS_VIM_FGRPFunction Group of View Maintenance Cust. CO Integrationnvarchar260 Allow NULL? 
5BS_TAB_TYPE_DETTable for Determination of Controlling Typenvarchar300 Allow NULL? 
6BS_TAB_SCEN_DETTable with Definition Controlling Scenario Determinationnvarchar300 Allow NULL? 
7BS_TAB_ASSIGNTable with Current Controlling Relevance and Assignmentnvarchar300 Allow NULL? 
8BS_VV_COSCENARIOName of View Variant for CO Scenarionvarchar300 Allow NULL? 
9BS_VCL_NAMEName of View Cluster for Maint. of Controlling Type Determ.nvarchar300 Allow NULL? 
10BS_VIEW_SELECTName of Selection Viewnvarchar300 Allow NULL? 
11BS_CO_SINGLEBusiness Scenario Allows Single-Object Controllingchar10 Allow NULL? 
12BS_CO_MULTIPLEBusiness Scenario Allows Mass-Object Controllingchar10 Allow NULL? 
13BS_CO_DIRECTBusiness Scenario Allows Controlling on Acct Assignment Obj.char10 Allow NULL? 
14BS_CO_PROJECTBus. Scenario Allows Single-Obj. Controlling of PS Projectschar10 Allow NULL? 
15BS_CO_NOT_RELEVBusiness Scenario Allows Non-Relevant Objectchar10 Allow NULL? 
16BS_CO_SINGLE_LEVAllowed Single-Object Controlling in Object Class Hierarchychar10 Allow NULL? 
17BS_CO_AUFARTOrder Typenvarchar40 Allow NULL? 
18BS_TAB_SUB_OBJTable with Subordinate Objectsnvarchar300 Allow NULL? 
19BS_US_REF_IGNOREBusiness Scenario Allows Reference 'Ignore'char10 Allow NULL? 
20BS_US_REF_ADOPTBusiness Scenario Allows Reference 'Adopt'char10 Allow NULL? 
21BS_US_RF_AD_SETBusiness Scenario Allows Transfer of Additional Referencechar10 Allow NULL? 
22BS_US_RF_AD_CRSTBusiness Scenario Allows Transfer and Addit. Acc. Assignmentchar10 Allow NULL? 
23BS_US_RF_AD_COPBusiness Scenario Allows Transfer of Reference 1 to 1char10 Allow NULL? 
24BS_NO_CX_SUB_OBJNo Coexistence of Original- and Lower-Level Objectschar10 Allow NULL? 
25BS_HLO_CHANGEBusiness Scenario Allows Changes to Higher-Level Object.char10 Allow NULL? 
26BS_REF_CHANGEBusiness Scenario Allows Changes to Referencechar10 Allow NULL? 
27BS_CTP_CHANGEBusiness Scenario Allows Changes to Controlling Typechar10 Allow NULL? 
28BS_CO_PROFIDPROJProject Profilenvarchar70 Allow NULL? 
29BS_WRITE_HISTORYWrite Change Historychar10 Allow NULL? 
30BS_WRTE_USE_HISTWrite and Use Change Historychar10 Allow NULL? 
31BS_NO_HISTORYNo Change Historychar10 Allow NULL? 
32BS_GROUP_IDENTBusiness Scenario Groupnvarchar160 Allow NULL? 
NamePrimaryUniqueTypeColumns
IAOM_BS_MASTER~0YesYesCLUSTEREDBS_IDENT