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  | WSDT_BASIC_CFG
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
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
10OINM101Whse Journal
Sales and Distribution :: Master Data :: Material Maintenance :: Additional Material Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0WSDT_BASIC_CFG421Basic Configuration for Counter SalesAdditional Material Functions
SQL:  selectupdate insert create

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

SELECT MANDT, APP_NAME, MAT_CREATE, IND_SECTOR, MAT_TYPE, TAX_CLASS, BACKGROUND, SP_CALC, SP_DETERM_LEVEL, SP_DETERM_SEQ, PP_DETERM_SEQ, REF_PLANT, EXT_CATALOG, DEFAULT_PLT, SINGLE_RES_RET, MS_MAX_RESULTS, MS_DISP_PAGE, MS_FUZZY_MODE, ATP_ZERO_DISPLAY, ATP_DETAIL_DISP, RFC_DEST, SO_ACTIVE, TREX_UPDATE, STD_SCRN_NBR, ENH_SCRN_NBR, DISPLAY_PRICES, OWN_PLANT_AVAIL, CBP_AVAIL, OTHER_PLT_AVAIL, OWN_PLANT_CHANGE, OTHER_PLT_MARC, INFORECORD_LEVEL, SEARCH_ENGINE, HIDE_PLANT_FILT, FILTER_DISPLAY, METHOD_MATERIAL, METHOD_CATALOG, CHANGE_MATERIAL, MAINT_GROUP, MGROUP_TEXT, PLANT_DATA, ITEM_ADD_METHOD FROM WSDT_BASIC_CFG
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2APP_NAMEApplicationnvarchar20CHAR(N' ')NoWSDT_APPLWSD_APPLICATION Allow NULL? 
3MAT_CREATECategory of materials that are createdchar10CHAR(N' ')YesWSD_MAT_CREATE Allow NULL? 
4IND_SECTORIndustry sectorchar10CHAR(N' ')YesT137MBRSH Allow NULL? 
5MAT_TYPEMaterial Typenvarchar40CHAR(N' ')YesWSDT_MAT_MTARTMTART Allow NULL? 
6TAX_CLASSTax classification of the materialchar10CHAR(N' ')YesTSKMTAKLV Allow NULL? 
7BACKGROUNDFlag for using background creation processchar10CHAR(N' ')YesWSD_BACKGROUND_CREATE Allow NULL? 
8SP_CALCPerforms Sales Price Calculationchar10CHAR(N' ')YesWSD_SP_CALC Allow NULL? 
9SP_DETERM_LEVELSales price calculationchar10CHAR(N' ')YesWSD_SP_LEVEL Allow NULL? 
10SP_DETERM_SEQSales price determination sequencenvarchar20CHAR(N' ')YesTWEVEKERV_V Allow NULL? 
11PP_DETERM_SEQPurchase price determination sequencenvarchar20CHAR(N' ')YesTWEVEKERV_M Allow NULL? 
12REF_PLANTReference Plant of the Category "Store" (Material Master)nvarchar40CHAR(N' ')YesT001WVLGFI Allow NULL? 
13EXT_CATALOGAccess to external catalogchar10CHAR(N' ')YesWSD_EXT_CATALOG_ACCESS Allow NULL? 
14DEFAULT_PLTRelated plants for material searchchar10CHAR(N' ')YesWSD_MS_INCLUDE_PLANTS Allow NULL? 
15SINGLE_RES_RETImmediate return of a single search resultchar10CHAR(N' ')YesWSD_MS_SINGLE_RESULT_RETURN Allow NULL? 
16MS_MAX_RESULTSSearch result maximum entries allowedint100INT4((0))YesWSD_MS_MAX_RESULTS Allow NULL? 
17MS_DISP_PAGENumber of materials displayed per pagetinyint30INT1((0))YesWSD_MS_DISP_PER_PAGE
18MS_FUZZY_MODEMaterial search fuzzy mode flagchar10CHAR(N' ')YesWSD_MS_FUZZY_MODE Allow NULL? 
19ATP_ZERO_DISPLAYHide Plants with Zero Stockchar10CHAR(N' ')YesWSD_ATP_ZERO_DISPLAY Allow NULL? 
20ATP_DETAIL_DISPATP display configurationchar10CHAR(N' ')YesWSD_ATP_DETAIL_DISP Allow NULL? 
21RFC_DESTLogical Destination (Specified in Function Call)nvarchar320CHAR(N' ')YesRFCDESRFCDEST Allow NULL? 
22SO_ACTIVEActivate Enhanced Material Search and Creationchar10CHAR(N' ')YesWSD_SO_ACTIVE Allow NULL? 
23TREX_UPDATEStart automatic TREX update after Material creationchar10CHAR(N' ')YesWSD_TREX_UPDATE Allow NULL? 
24STD_SCRN_NBRScreen number for primary search parametersnvarchar40CHAR(N' ')YesWSD_STD_SCRN_NBR Allow NULL? 
25ENH_SCRN_NBRScreen number for secondary search parametersnvarchar40CHAR(N' ')YesWSD_ENH_SCRN_NBR Allow NULL? 
26DISPLAY_PRICESDisplay prices in the detail area of search result flagchar10CHAR(N' ')YesWSD_DISP_DETAIL_PRICES Allow NULL? 
27OWN_PLANT_AVAILMaterial availability display option for own plantchar10CHAR(N' ')YesWSD_MS_OWN_PLANT_AVAILABILITY Allow NULL? 
28CBP_AVAILClose-by Plants Material Availability Display Optionchar10CHAR(N' ')YesWSD_MS_CBP_AVAILABILITY Allow NULL? 
29OTHER_PLT_AVAILOther Plants Material Availability Display Optionchar10CHAR(N' ')YesWSD_MS_OTHER_PLANTS_AVAILAB Allow NULL? 
30OWN_PLANT_CHANGEAllow Change of Own Plantchar10CHAR(N' ')YesWSD_MS_OWN_PLANT_CHANGE Allow NULL? 
31OTHER_PLT_MARCAllow Material Creation for Other Plantschar10CHAR(N' ')YesWSD_MS_CREATE_OTHER_PLANT_MARC Allow NULL? 
32INFORECORD_LEVELDefinition of Level for Creation of Inforecordschar10CHAR(N' ')YesWSD_INFOREC_LEVEL Allow NULL? 
33SEARCH_ENGINESearch Enginenvarchar20CHAR(N' ')YesWSD_SEARCH_ENGINE Allow NULL? 
34HIDE_PLANT_FILTHide Plant Filter And Availabilitychar10CHAR(N' ')YesWSD_HIDE_PLANT_FILTER_AVAIL Allow NULL? 
35FILTER_DISPLAYFilter Display for Generic Materialnvarchar20CHAR(N' ')YesWSD_FILTER_DISP_RETAIL_MAT Allow NULL? 
36METHOD_MATERIALCreation Method Based on Materialnvarchar20CHAR(N' ')YesWSD_CREATE_FROM_MATERIAL Allow NULL? 
37METHOD_CATALOGCreation Method based on Catalognvarchar20CHAR(N' ')YesWSD_CREATE_FROM_CATALOG Allow NULL? 
38CHANGE_MATERIALChange Method For Retail Materialsnvarchar20CHAR(N' ')YesWSD_CHANGE_MATERIAL Allow NULL? 
39MAINT_GROUPMaintenance Groupnvarchar60NUMC(N'000000')YesWSD_MGROUP Allow NULL? 
40MGROUP_TEXTText of Maintenance Group fieldnvarchar300CHAR(N' ')YesWSD_MGROUP_TEXT Allow NULL? 
41PLANT_DATACreation of Plant Datanvarchar20CHAR(N' ')YesWSD_PLANT_DATA Allow NULL? 
42ITEM_ADD_METHODSearch Result Selection Methodnvarchar20CHAR(N' ')YesWSD_ITEM_SEL_CRITERIA Allow NULL? 
NamePrimaryUniqueTypeColumns
WSDT_BASIC_CFG~0YesYesCLUSTEREDMANDT, APP_NAME

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