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

105 columns | Print definition?ERP 6.0  | SWITCH_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWFND/I_COGSDOControl Table "GSDO Type"4SWITCH_IDId of a Switch in Switch Frameworknvarchar300
2/SAPPSSRM/CTRLItem Process Type - Control Key23SWITCH_IDCustomizing Switch IDnvarchar300
3/SAPPSSRM/HTMP_CItem Type Control9SWITCH_IDCustomizing Switch IDnvarchar300
4/SAPPSSRM/IPTDefinition table for Item Process Types18SWITCH_IDCustomizing Switch IDnvarchar300
5/SAPPSSRM/RODWRollDown Rules3SWITCH_IDCustomizing Switch IDnvarchar300
6/SAPPSSRM/RODW_FRollDown Rules - Field Control5SWITCH_IDCustomizing Switch IDnvarchar300
7/SAPPSSRM/RODW_SRolldown Rules to Copy Sets6SWITCH_IDCustomizing Switch IDnvarchar300
8/SAPSRM/C_APP_SWOBSOLETE: Assignment of Extension Appends to Switches3SWITCH_IDId of a Switch in Switch Frameworknvarchar300
9/SAPSRM/C_BOITTYAssignment of Item Types to SRM Procurement Document Types3SWITCH_IDCustomizing Switch IDnvarchar300
10/SAPSRM/C_CLIPField Mapping for Cross BO copy/paste7SWITCH_IDCustomizing Switch IDnvarchar300
11/SAPSRM/C_CLIPCField Mapping for Cross BO copy/paste for customer fields7SWITCH_IDCustomizing Switch IDnvarchar300
12/SAPSRM/C_MDA_H1Meta Data Configuration for Business Object Header Fields5SWITCH_IDCustomizing Switch IDnvarchar300
13/SAPSRM/C_MDA_I1Meta Data Configuration for Business Object Item Fields7SWITCH_IDCustomizing Switch IDnvarchar300
14/SAPSRM/C_MDA_S1Meta Data Configuration for Set Actions7SWITCH_IDCustomizing Switch IDnvarchar300
15/SAPSRM/C_MDF_H1Meta Data Configuration for Business Object Header Fields5SWITCH_IDCustomizing Switch IDnvarchar300
16/SAPSRM/C_MDF_I1Meta Data Configuration for Business Object Item Fields7SWITCH_IDCustomizing Switch IDnvarchar300
17/SAPSRM/C_MDF_S1Meta Data Configuration for Set Fields7SWITCH_IDCustomizing Switch IDnvarchar300
18/SAPSRM/C_MDS_H1Meta Data Configuration for Business Object Header Fields4SWITCH_IDCustomizing Switch IDnvarchar300
19/SAPSRM/C_MDS_I1Meta Data Configuration for Business Object Item Fields6SWITCH_IDCustomizing Switch IDnvarchar300
20/SAPSRM/C_PWL_FCPOWL: Customizing Fieldcatalog4SWITCH_IDCustomizing Switch IDnvarchar300
21/SAPSRM/C_SWITCHDefinition of Customizing Switches and their Attributes1SWITCH_IDCustomizing Switch IDnvarchar300
22/SAPSRM/C_SWITCTText Table for Definition of Customizing Switches2SWITCH_IDCustomizing Switch IDnvarchar300
23/SAPSRM/C_SW_ACTActivation of Customizing Switches2SWITCH_IDCustomizing Switch IDnvarchar300
24/SAPSRM/C_SW_FLDTable to switch structure fields4SWITCH_IDCustomizing Switch IDnvarchar300
25/SAPSRM/C_SW_LOGLog for System Activation Status of Customizing Switches3SWITCH_IDCustomizing Switch IDnvarchar300
26/SAPSRM/C_SW_SYSSystem Activation Status of Customizing Switches2SWITCH_IDCustomizing Switch IDnvarchar300
27/SAPSRM/C_SW_WDTable to switch Web-Dynpro UI Elements4SWITCH_IDCustomizing Switch IDnvarchar300
28/SAPSRM/C_SW_WDPTable to switch Web-dynpro View Element Properties7SWITCH_IDCustomizing Switch IDnvarchar300
29/SAPSRM/C_VIEW_MTable to switch FPM Main View2SWITCH_IDCustomizing Switch IDnvarchar300
30/SAPSRM/C_VIEW_STable to switch FPM Sub View2SWITCH_IDCustomizing Switch IDnvarchar300
31/SAPSRM/C_VIEW_UTable to switch UIBB4SWITCH_IDCustomizing Switch IDnvarchar300
32/SAPSRM/C_WD_TESettings for Standard Display of Table Extensions on UI8SWITCH_IDCustomizing Switch IDnvarchar300
33/SAPSRM/C_WD_TECSettings for Columm Visibility of Table Extensions on UI6SWITCH_IDCustomizing Switch IDnvarchar300
34/SAPSRM/C_WF_RResponsibility Resolver Names2SWITCH_ID30 Charactersnvarchar300
35BBPC_PARTNERFTYPDefinition of Partner Function Types2SWITCH_IDCustomizing Switch IDnvarchar300
36BBPC_SUS_TABDEFDefinition of Displayable Fields in a Table Item16SWITCH_IDCustomizing Switch IDnvarchar300
37GRRMOBITEMSWSwitch Configuration - Menu Items Visibility3SWITCH_IDId of a Switch in Switch Frameworknvarchar300
38SFW_SNAPSHOTSnapshot of switch states for switch framework activation1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
39UPG_STATECHANGESchalter, deren Zustand beim Aktivieren verändert wurde1SWITCH_IDID eines Schalters im Switch Frameworknvarchar300
TOPApplication Frame
40CRMC_UI_DLG_AAssign Links To Direct Link Group5SWITCH_IDId of a Switch in Switch Frameworknvarchar300
41CRMC_UI_NBDefine Navigation Bar Profile4SWITCH_IDId of a Switch in Switch Frameworknvarchar300
42CRMC_UI_NB_A_DLGAssign Direct Link Groups To Navigation Bar Profile5SWITCH_IDId of a Switch in Switch Frameworknvarchar300
43CRMC_UI_NB_A_WCAssign Work Centers To Navigation Bar Profile5SWITCH_IDId of a Switch in Switch Frameworknvarchar300
44CRMC_UI_WCDefine Work Center5SWITCH_IDId of a Switch in Switch Frameworknvarchar300
45CRMC_UI_WCLG_AAssign Links To Work Center Link Group6SWITCH_IDId of a Switch in Switch Frameworknvarchar300
46CRMC_UI_WC_AAssign Work Center Link Groups To Work Center5SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPCentral Part of Product Master
47COMC_SETTYPE_SFWDefinition of Switch per Set Type and Product Type3SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPCustomer Enhancements
48ENHCROSSCross Reference for ENH Object13SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPDevelopment Workbench
49WCF_CONF_SWITCHSwitch Info1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPEnhancement Tools
50TEEF_MIG_STATEMigration Status Table11SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPEnterprise Search Integration
51CRMD_ES_ATTRNode attributes15SWITCH_IDId of a Switch in Switch Frameworknvarchar300
52CRMD_ES_TMPLHDRTemplates for ES15SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPGeneric Interaction Layer
53CRMC_GIL_COMP_ATActive State Table: Delta of attributes7SWITCH_IDId of a Switch in Switch Frameworknvarchar300
54GIL_ENH_COMP_ATActive State Table: Delta of attributes8SWITCH_IDId of a Switch in Switch Frameworknvarchar300
55GIL_ENH_METHODBOL model methods7SWITCH_IDId of a Switch in Switch Frameworknvarchar300
56GIL_ENH_MODELBOL model relations12SWITCH_IDId of a Switch in Switch Frameworknvarchar300
57GIL_ENH_OBJECTSBOL model objects27SWITCH_IDId of a Switch in Switch Frameworknvarchar300
58WCFC_GIL_METHODBOL model methods7SWITCH_IDId of a Switch in Switch Frameworknvarchar300
59WCFC_GIL_MODELBOL model relations12SWITCH_IDId of a Switch in Switch Frameworknvarchar300
60WCFC_GIL_OBJECTSBOL model objects27SWITCH_IDId of a Switch in Switch Frameworknvarchar300
61WCFC_GIL_OBJ_ATTBOL model characteristics of attributes8SWITCH_IDId of a Switch in Switch Frameworknvarchar300
62WCF_GIL_METHODBOL model methods6SWITCH_IDId of a Switch in Switch Frameworknvarchar300
63WCF_GIL_MODELBOL model relations11SWITCH_IDId of a Switch in Switch Frameworknvarchar300
64WCF_GIL_OBJECTSBOL model objects26SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPHierarchy Storage
65TTREE_SFW_NODESAssignment of SFW Switches to Hierarchy Tool Nodes2SWITCH_IDID of Switch in Switch Frameworknvarchar300
TOPLaunchpad
66APB_LPD_VERSIONSLaunchpad: Role and Instance5SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPMetadata Repository
67RSOSC_SWT_REPLSwitches replicated in BI (Texts)1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
68RSOSC_SW_REPLSwitch replicated into BI (including Status)1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPNetWeaver Enterprise Search
69ESH_OM_CSWASGNSwitch Assignments7SWITCH_IDSwitch IDnvarchar300
TOPRelationships Between Objects with GUID Identification
70COMC_IL_TYPE_SFWDefinition of Switch per Relationship Type and Product Type3SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPSales
71LORD_GAF_EWB_OBJObject types for LO GAF Enhancement Workbench2SWITCH_IDId of a Switch in Switch Frameworknvarchar300
72LORD_GAF_EWB_TABSources for cust fields of object types for LO GAF EWB4SWITCH_IDId of a Switch in Switch Frameworknvarchar300
73LORD_OIF_MAP_GRPLO OIF maps Object Type/Field to FPM special groups5SWITCH_IDId of a Switch in Switch Frameworknvarchar300
74LORD_OIF_MAP_OVSLO OIF maps Object Type/Field to OVS4SWITCH_IDId of a Switch in Switch Frameworknvarchar300
75TSD_FUNC_ACTActivation of additional functionality in SD8SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPSAP Utilities
76ISU_IL_OBJMETHIS-U: Object Methods in Generic Interaction Layer6SWITCH_IDId of a Switch in Switch Frameworknvarchar300
77ISU_IL_OBJPROPIS-U:Characteristics of Objects in Generic Interaction Layer17SWITCH_IDId of a Switch in Switch Frameworknvarchar300
78ISU_IL_RELDETIS-U: Relations in Generic Interaction Layer11SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPService Mapping Tool
79TSMT_CHECKField Check9SWITCH_IDId of a Switch in Switch Frameworknvarchar300
80TSMT_CHECK_CClient-Dependent: Field Check11SWITCH_IDId of a Switch in Switch Frameworknvarchar300
81TSMT_EXTENSIONMapping Extension5SWITCH_IDId of a Switch in Switch Frameworknvarchar300
82TSMT_TRCall-Up of a Transformation10SWITCH_IDId of a Switch in Switch Frameworknvarchar300
83TSMT_TR_CClient-Dependent: Call-Up of a Transformation12SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPSwitch Framework Tools
84SFW_BF_SWAssignment Switch / Business Function1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
85SFW_ENH_CROSS1Where-Used Packages in Enhancements1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
86SFW_ENH_CROSS2Where-Used Switches in Enhancements1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
87SFW_IA_SWImpact Analyser: Inital view1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
88SFW_IA_SW_IVChanged Portal iView of a Switch1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
89SFW_IA_SW_PRChanged Portal Roles of a Switch1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
90SFW_IA_SW_RPChanged ABAP Report of a Switch1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
91SFW_IA_SW_TXChanged Transactions of a Switch1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
92SFW_IA_SW_WDAChanged Web Dynpro Application of a Switch1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
93SFW_PACKAGEAssignment Switch / Package1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
94SFW_STATECHANGESwitch whose status was changed upon activation1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
95SFW_SWITCHSwitches / Switch Framework1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
96SFW_SWITCHTText Table for the Switches1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
97SFW_SW_BFAssignment Switch / Business Function3SWITCH_IDId of a Switch in Switch Frameworknvarchar300
98SFW_VIEWFIELDAssignment Switch / View Field4SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPSyntax, Compiler, Runtime
99SFW_CONFLConflict Switch (Assignment) for Conflict Resolution3SWITCH_IDId of a Switch in Switch Frameworknvarchar300
100SFW_SWITCH_STATESwitch Settings (Switch States)1SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPTable Maintenance Tool
101VCLSTRUCViewcluster: Structure table10SWITCH_IDID of Switch in Switch Frameworknvarchar300
TOPTransport Organizer
102TDEVCPackages42SWITCH_IDId of a Switch in Switch Frameworknvarchar300
TOPWebClient UI
103CRMC_UIF_BOL_METObjects in UIF_FL BOL/GENIL5SWITCH_IDId of a Switch in Switch Frameworknvarchar300
104CRMC_UIF_BOL_MODModel table for UIF_FL BOL/GENIL7SWITCH_IDId of a Switch in Switch Frameworknvarchar300
105CRMC_UIF_BOL_OBJObjects in UIF_FL BOL/GENIL7SWITCH_IDId of a Switch in Switch Frameworknvarchar300