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

Home | ERP 6.0  | COMC_SETTYPE
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
Application Platform :: Master Data :: Central Part of Product Master
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0COMC_SETTYPE343Administrative Tables for Set TypesCentral Part of Product Master
SQL:  selectupdate insert create

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

SELECT FRGTYPE_GUID, LOGSYS, FRGTYPE_ID, FRGTYPE_TAB, FRGTYPE_DYNPRO, FRGTYPE_PROGRAM, FUNC_CREATE, FUNC_CHANGE, FUNC_INIT, FUNC_SAVE, FUNC_FREE, FUNC_SAVE_LOCAL, FUNC_CHECK, FUNC_READ, FUNC_READ_LOCAL, FUNC_READ_MULTI, FUNC_MAINT_READ, FUNC_MAINT_MULTI, FUNC_MAINT_UPD, FUNC_MAINT_READP, FUNC_GET, FUNC_GET_HISTORY, FUNC_PBO, FUNC_PAI, FUNC_READ_TFW, GENFLAG, BUS_OBJTYPE, ORG_UNIT, PROD_COMP_TYPE, STATUS_OBJECT, OBJECT_FAMILY, NON_ASSIGNABLE, CALLORDER_SAVEL, CLEARING_NODEKEY FROM COMC_SETTYPE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1FRGTYPE_GUIDInternal Key of a Set Typenvarchar320CHAR(N' ')NoCOMT_FRGTYPE_GUID32 Allow NULL? 
2LOGSYSOriginal Systemnvarchar100CHAR(N' ')Yes*COMT_LOGSYS Allow NULL? 
3FRGTYPE_IDIdentification of a Set Typenvarchar160CHAR(N' ')YesCOMT_FRGTYPE_ID Allow NULL? 
4FRGTYPE_TABDatabase Table for the Set Typenvarchar160CHAR(N' ')YesCOMT_FRGTYPE_TABLE Allow NULL? 
5FRGTYPE_DYNPROSubscreen for Maintaining Data on the Set Typenvarchar40CHAR(N' ')YesCOMT_FRGTYPE_DYNPRO Allow NULL? 
6FRGTYPE_PROGRAMProgram in Which the Subscreen Was Created for the Set Typenvarchar400CHAR(N' ')Yes*COMT_FRGTYPE_PROGRAM Allow NULL? 
7FUNC_CREATEFunction Module for Writing Set Type Datanvarchar300CHAR(N' ')Yes*COMT_SETTYPE_FUNCCREATE Allow NULL? 
8FUNC_CHANGEFunction Module for Changing Set Type Datanvarchar300CHAR(N' ')Yes*COMT_SETTYPE_FUNCCHANGE Allow NULL? 
9FUNC_INITFunction Module for Initializing the Set Type Subscreennvarchar300CHAR(N' ')Yes*COMT_FRGTYPE_FUNCINIT Allow NULL? 
10FUNC_SAVEFunction Module for Saving the Set Type Datanvarchar300CHAR(N' ')Yes*COMT_FRGTYPE_FUNCSAVE Allow NULL? 
11FUNC_FREEFunction Module for Resetting a Set Type's Buffersnvarchar300CHAR(N' ')Yes*COMT_FRGTYPE_FUNCFREE Allow NULL? 
12FUNC_SAVE_LOCALFunction Module for Saving Local Set Type Buffernvarchar300CHAR(N' ')Yes*COMT_SETTYPE_FUNCSAVE_LOCAL Allow NULL? 
13FUNC_CHECKFunction Module for Checking Set Type Datanvarchar300CHAR(N' ')Yes*COMT_SETTYPE_FUNCCHECK Allow NULL? 
14FUNC_READFunction Module for Reading Set Type Datanvarchar300CHAR(N' ')Yes*COMT_SETTYPE_FUNCREAD Allow NULL? 
15FUNC_READ_LOCALFunction Module for Reading Set Type Data Locallynvarchar300CHAR(N' ')Yes*COMT_SETTYPE_FUNCREAD_LOCAL Allow NULL? 
16FUNC_READ_MULTIFunction Module for Reading Multiple Set Type Datanvarchar300CHAR(N' ')Yes*COMT_SETTYPE_FUNCREAD_MULTI Allow NULL? 
17FUNC_MAINT_READFunction Module for Reading for Maintenancenvarchar300CHAR(N' ')Yes*COMT_SETTYPE_FUNCMAINT_READ Allow NULL? 
18FUNC_MAINT_MULTIFunction Module for Changing Multiple Set Type Datanvarchar300CHAR(N' ')Yes*COMT_SETTYPE_FUNCMAINT_MULTI Allow NULL? 
19FUNC_MAINT_UPDFunction Module for Changes (Dialog)nvarchar300CHAR(N' ')Yes*COMT_SETTYPE_FUNCMAINT_UPD Allow NULL? 
20FUNC_MAINT_READPFunction Module for Reading Set Type Data for Productnvarchar300CHAR(N' ')Yes*COMT_SETTYPE_FUNCMAINT_READ_PR Allow NULL? 
21FUNC_GETFunction Module for Saving (BAdI) Set Type Datanvarchar300CHAR(N' ')Yes*COMT_SETTYPE_FUNCGET Allow NULL? 
22FUNC_GET_HISTORYFunction Module for Reading History Datanvarchar300CHAR(N' ')Yes*COMT_SETTYPE_FUNCGET_HISTORY Allow NULL? 
23FUNC_PBOFunction Module for PBO Functionsnvarchar300CHAR(N' ')Yes*COMT_SETTYPE_FUNC_PBO Allow NULL? 
24FUNC_PAIFunction Module for PAI Functionsnvarchar300CHAR(N' ')Yes*COMT_SETTYPE_FUNC_PAI Allow NULL? 
25FUNC_READ_TFWFunction Module for Reading Referenced Data from TFWnvarchar300CHAR(N' ')Yes*COMT_FRGTYPE_FUNCTFWR Allow NULL? 
26GENFLAGSet Type Has Been Generatedchar10CHAR(N' ')YesCOMT_FRGTYPE_GENFLAG Allow NULL? 
27BUS_OBJTYPEObject Type of a Set Typenvarchar100CHAR(N' ')YesCOMC_SET_OBJTYPECOMT_BUS_OBJTYPE Allow NULL? 
28ORG_UNITIndicator for Organizational Dependencynvarchar100CHAR(N' ')YesCOMS_PR_ORGCOMT_PR_ORG_TYPE Allow NULL? 
29PROD_COMP_TYPEProduct Component Typenvarchar20CHAR(N' ')YesCOMT_PROD_COMP_TYPE Allow NULL? 
30STATUS_OBJECTObject Categorynvarchar30CHAR(N' ')Yes*CRM_J_OBTYP Allow NULL? 
31OBJECT_FAMILYObject Familynvarchar40CHAR(N' ')Yes*COMT_PRODUCT_OBJECT_FAMILY Allow NULL? 
32NON_ASSIGNABLEIndicator: Set Type Cannot Be Assigned to Categorychar10CHAR(N' ')YesCOMT_SETTYPE_NON_ASSIGNABLE Allow NULL? 
33CALLORDER_SAVELCall Sequence of Functions During Maintenanceint100INT4((0))YesCOMT_SETTYPE_FUNC_CALL_ORDER Allow NULL? 
34CLEARING_NODEKEYNodes in Clearing Toolnvarchar100CHAR(N' ')YesCOMT_CLEARING_NODE_KEY Allow NULL? 
NamePrimaryUniqueTypeColumns
COMC_SETTYPE~0YesYesCLUSTEREDFRGTYPE_GUID
COMC_SETTYPE~1NoYesNONCLUSTEREDFRGTYPE_ID
COMC_SETTYPE~2NoNoNONCLUSTEREDFRGTYPE_TAB

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy