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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

35 columns | Print definition?ERP 6.0  | SWITCH

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BI0/PSWITCHMaster Data (Time-Ind.): Characteristic Switch1SWITCHSwitchnvarchar300
2/BI0/SSWITCHMaster Data IDs: InfoObject Switch1SWITCHSwitchnvarchar300
3/BI0/TSWITCHTexts: Char. Switch1SWITCHSwitchnvarchar300
4CNVHCM_SWITCHTDMS4HCM: Switches2SWITCHTDMS4HCM: Switch namenvarchar350
5CNVHCM_SWITCHESTDMS4HCM: Switches5SWITCHTDMS4HCM: Switch namenvarchar350
6CNVHCM_SWITCH_TTDMS4HCM: Switches3SWITCHTDMS4HCM: Switch namenvarchar350
7CTS_AIM_TRC_PTSHControl Table for Shadow Import During the Upgrade26SWITCHnvarchar10
8PUTTB_SHD_1Steuertabelle für den Schattenimport während des Upgrades25SWITCHTabelle wird umbenanntnvarchar10
9SPROX_SWITCHESSwitches for Proxy Generation1SWITCHSwitchnvarchar100
10T5A7SSwitch Table for PCALZ Checks6SWITCHCheck Activated or Deactivatednvarchar10
11TVROPTSD - Report Optimization3SWITCHData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
12UPG_SW_CHANGESwitch Framework: Statusänderungen von Schaltern1SWITCHID eines Schalters im Switch Frameworknvarchar300
TOPApplication-Specific Upgrade
13/ASU/FLAGSASU Toolbox: global switch control flags2SWITCHCharacter field of length 40nvarchar400
TOPBRFplus - ABAP-Based Business Rules
14FDT_EXPR_2604FDT: Flow Rules7SWITCHData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
15FDT_EXPR_2604AFDT: Flow Rules7SWITCHData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
16FDT_EXPR_2604SFDT: Flow Rules6SWITCHData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
17FDT_EXPR_2604TFDT: Flow Rules6SWITCHData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
18FDT_RLST_0000FDT: RuleSet - Attributes6SWITCHData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
19FDT_RLST_0000AFDT: RuleSet - Attributes6SWITCHData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
20FDT_RLST_0000SFDT: RuleSet - Attributes5SWITCHData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
21FDT_RLST_0000TFDT: RuleSet - Attributes5SWITCHData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
22FDT_RLST_1000FDT: RuleSet - Rules5SWITCHData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
23FDT_RLST_1000AFDT: RuleSet - Rules5SWITCHData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
24FDT_RLST_1000SFDT: RuleSet - Rules4SWITCHData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
25FDT_RLST_1000TFDT: RuleSet - Rules4SWITCHData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPIndustry Solution Oil
26TOI0SWITCHGeneral setting (Function on/off switch)4SWITCHSelection flag / general switchnvarchar10
TOPIntegration Engine
27SXMSDCONFIntegration Engine: Settings for Deletion Concept2SWITCHIntegration Engine: Switch Modenvarchar10
TOPLean Staffing
28TWE_ENGTYPEAssignment Object Type10SWITCHId of a Switch in Switch Frameworknvarchar300
TOPProvisioning
29SPCIPSWITCHIP Browser Switch3SWITCHSwitch Indicatornvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
30TN2BITYPBase Items: Base Item Types17SWITCHId of a Switch in Switch Frameworknvarchar300
TOPSwitch Framework Tools
31SFW_SW_CHANGESwitch Framework: Status Changes of Switches1SWITCHId of a Switch in Switch Frameworknvarchar300
TOPUpgrade - General
32PUTTB_SHDControl Table for Shadow Import During the Upgrade25SWITCHTable is being renamednvarchar10
33PUTTB_SHD_SAVSteuertabelle für den Schattenimport während des Upgrades25SWITCHTabelle wird umbenanntnvarchar10
34PUTTB_SHD_SHDSteuertabelle für den Schattenimport während des Upgrades25SWITCHTabelle wird umbenanntnvarchar10
35PUTTB_SHD_STDSteuertabelle für den Schattenimport während des Upgrades25SWITCHTabelle wird umbenanntnvarchar10