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  | CCRCC_DET
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
Environment, Health and Safety :: Product Safety
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0CCRCC_DET271EHS: Data Determination Modules per Regulation/ScenarioProduct Safety
SQL:  selectupdate insert create

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

SELECT MANDT, REG, SCEN, BASE_UNIT, FLG_PERIOD, FCT_TRACK, FCT_MATNR_GET, FCT_SUBID_GET, FCT_CMP_TREE, USEXNAM, USEXPAR, CMP_ESTCAT, VACLID, RVLID, FCT_CONDENSE, FCT_PLAN_SAVE, FCT_CONF_SAVE, FCT_PROCESS_EXE, FLG_HIST, TRACK_PACK, CMP_ESTCAT2, VACLID2, RVLID2, VATSPECEXCL, CHARSPECEXCL, REGSPECEXCL, POLYMONO_TRANS FROM CCRCC_DET
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2REGRegulatory Listnvarchar100CHAR(N' ')NoTCG81ESESLSTID Allow NULL? 
3SCENScenarionvarchar100CHAR(N' ')NoCCRCT_SCENCCRCE_SCEN Allow NULL? 
4BASE_UNITUnit for Specifying Quantitiesnvarchar30UNIT(N' ')YesT006CCRCE_UOM Allow NULL? 
5FLG_PERIODDivision of Monitoring Year into Monitoring Periodschar10CHAR(N' ')YesCCRCE_FLG_PERIOD Allow NULL? 
6FCT_TRACKFunction for Tracking Datanvarchar300CHAR(N' ')YesTFDIRCCRCE_FCT_TRACK Allow NULL? 
7FCT_MATNR_GETFunction for Determining the Relevant Materialsnvarchar300CHAR(N' ')YesTFDIRCCRCE_FCT_MATNR_GET Allow NULL? 
8FCT_SUBID_GETFunction for Determining the Substances for the Materialnvarchar300CHAR(N' ')YesTFDIRCCRCE_FCT_SUBID_GET Allow NULL? 
9FCT_CMP_TREEFunction for Exploding the Componentsnvarchar300CHAR(N' ')YesTFDIRCCRCE_FCT_CMP_TREE Allow NULL? 
10USEXNAMUser Exitnvarchar100CHAR(N' ')YesTCGUEFUCCRCE_USEXNAM Allow NULL? 
11USEXPARParameters for User Exitnvarchar170CHAR(N' ')YesCCRCE_USEXPAR Allow NULL? 
12CMP_ESTCATValue Assignment Type 1nvarchar300CHAR(N' ')YesTCG11CCRCE_ESTCAT1 Allow NULL? 
13VACLIDRatingnvarchar100CHAR(N' ')YesTCG86ESEVACLID Allow NULL? 
14RVLIDValidity Areanvarchar100CHAR(N' ')YesTCG91ESERVLID Allow NULL? 
15FCT_CONDENSEFunction for Data Aggregationnvarchar300CHAR(N' ')YesTFDIRCCRCE_FCT_CONDENSE Allow NULL? 
16FCT_PLAN_SAVEFunction for Saving Planned Datanvarchar300CHAR(N' ')YesTFDIRCCRCE_FCT_PLAN_SAVE Allow NULL? 
17FCT_CONF_SAVEFunction for Saving Confirmed Datanvarchar300CHAR(N' ')YesTFDIRCCRCE_FCT_CONF_SAVE Allow NULL? 
18FCT_PROCESS_EXEFunction for Starting a Subsequent Processnvarchar300CHAR(N' ')YesTFDIRCCRCE_FCT_PRC_EXE Allow NULL? 
19FLG_HISTTracking of History of Increase in Quantitychar10CHAR(N' ')YesCCRCE_FLG_HIST Allow NULL? 
20TRACK_PACKPackage Processing in Daysnvarchar40NUMC(N'0000')YesCCRCE_PACK Allow NULL? 
21CMP_ESTCAT2Value Assignment Type 2nvarchar300CHAR(N' ')YesTCG11CCRCE_ESTCAT2 Allow NULL? 
22VACLID2Ratingnvarchar100CHAR(N' ')YesTCG86ESEVACLID Allow NULL? 
23RVLID2Validity Areanvarchar100CHAR(N' ')YesTCG91ESERVLID Allow NULL? 
24VATSPECEXCLValue Assignment Type for Filtering Out Specificationsnvarchar300CHAR(N' ')YesTCG11CCRCE_VATSPECEXCL Allow NULL? 
25CHARSPECEXCLCharacteristic for Filtering Out Specificationsnvarchar300CHAR(N' ')YesCCRCE_CHARSPECEXCL Allow NULL? 
26REGSPECEXCLCharact. for Regulatory List for Filtering Specificationsnvarchar300CHAR(N' ')YesCCRCE_REGSPECEXCL Allow NULL? 
27POLYMONO_TRANSData Transfer: Polymer/Monomerchar10CHAR(N' ')YesCCRCE_POLYMONO_TRANS Allow NULL? 
NamePrimaryUniqueTypeColumns
CCRCC_DET~0YesYesCLUSTEREDSCEN, REG, MANDT

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