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  | FERC_C0
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
Financial Accounting
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FERC_C0201General regulatory parametersFinancial Accounting
SQL:  selectupdate insert create

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

SELECT MANDT, IGN_SCE, EXT_SET, NREG_CLRG, NWA_WBS, NO_ZERO, HOR_COR, THRESHOLD, WAIT, BTCSYSTEM, PRCTR_TRC_0, PRCTR_TRC_1, PRCTR_DIR_0, PRCTR_DIR_1, RLDNR_FROM, RLDNR_TO_1, LOG_AMODAL, LOG_GRID, REP_GRID, PATHS_MAX FROM FERC_C0
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2IGN_SCEFlag: Ignore secondary cost elements in trace allowed?char10CHAR(N' ')YesFE_IGN_SCE Allow NULL? 
3EXT_SETTreatment of external settlement cost elementschar10CHAR(N' ')YesFE_EXT_SET Allow NULL? 
4NREG_CLRGFlag: Treat all clrg costs in non-reg. CCs as miscellaneous?char10CHAR(N' ')YesFE_NRGCLRG Allow NULL? 
5NWA_WBSFlag: Treat WBS assignment to NWA as flow for plan data?char10CHAR(N' ')YesFE_NWA_WBS Allow NULL? 
6NO_ZERODrill down path creation criteriachar10NUMC(N'0')YesFE_NO_ZERO Allow NULL? 
7HOR_CORFlag: Higher order correction for coupled loops active?char10CHAR(N' ')YesFE_HOR_COR Allow NULL? 
8THRESHOLDAcceptable numerical error threshold in % per sending objectnvarchar30NUMC(N'000')YesFE_THRSHLD Allow NULL? 
9WAITNumber of blocking attemptstinyint30INT1((0))YesFE_WAIT
10BTCSYSTEMTarget System to Run Background Jobnvarchar320CHAR(N' ')YesBTCTGTSYS Allow NULL? 
11PRCTR_TRC_0Flag: Include profit center in actual regulatory postingschar10CHAR(N' ')YesFE_PRCTR_0 Allow NULL? 
12PRCTR_TRC_1Flag: Include profit center in plan regulatory postingschar10CHAR(N' ')YesFE_PRCTR_1 Allow NULL? 
13PRCTR_DIR_0Flag: Include profit center in actual regulatory postingschar10CHAR(N' ')YesFE_PRCTR_0 Allow NULL? 
14PRCTR_DIR_1Flag: Include profit center in plan regulatory postingschar10CHAR(N' ')YesFE_PRCTR_1 Allow NULL? 
15RLDNR_FROMLedger containing profit center records for direct postingsnvarchar20CHAR(N' ')YesT881FE_RLDNR_FROM Allow NULL? 
16RLDNR_TO_1Plan ledger updated with regulatory profit center postingsnvarchar20CHAR(N' ')YesT881FE_RLDNR_TO_1 Allow NULL? 
17LOG_AMODALFlag: Display message log in amodal windowchar10CHAR(N' ')YesFE_LOG_AMODAL Allow NULL? 
18LOG_GRIDFlag: Display list using grid displaychar10CHAR(N' ')YesFE_ALV_GRID Allow NULL? 
19REP_GRIDFlag: Display list using grid displaychar10CHAR(N' ')YesFE_ALV_GRID Allow NULL? 
20PATHS_MAXMaximal number of paths for one source objectint100INT4((0))YesFE_PATHS_MAX Allow NULL? 
NamePrimaryUniqueTypeColumns
FERC_C0~0YesYesCLUSTEREDMANDT

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