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  | SMI_PROFILE
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
Sales and Distribution :: Basic Functions :: Supplier Managed Inventory
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0SMI_PROFILE372SMI ProfileSupplier Managed Inventory
SQL:  selectupdate insert create

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

SELECT MANDT, ID, ACTIVE_FLAG, NAME, CUSTOMER_ID, KDMAT, BSTKD, POSEX, WERKS_EXT, MATNR, VBELN, POSNR, SOBKZ, STOP_HORIZON, REPL_METH, SAFETY_PERC, SAFETY_QTY, SFTY_QTY_UOM, CUST_ROUND_VAL, REPL_PROC_LOGIC, SEND_PROC_LOGIC, STOP_FLAG, COMP_LOGIC, SMI_HORIZON_S, SMI_HORIZON_M, SMI_HORIZON_L, HIGH_PERC_S, LOW_PERC_S, HIGH_PERC_M, LOW_PERC_M, HIGH_PERC_L, LOW_PERC_L, ALERTCATEGORY, CREATOR, CHANGER, CREATED, CHANGED FROM SMI_PROFILE
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClient IDnvarchar30CLNT(N'000')No*SYMANDT Allow NULL? 
2IDSupplier-Managed Inventory Replenishment Profilenvarchar100CHAR(N' ')NoSMI_PROFILE_ID Allow NULL? 
3ACTIVE_FLAGProfile is Activechar10CHAR(N' ')YesSMI_PROFILE_ACTIVE Allow NULL? 
4NAMEText Fieldnvarchar500CHAR(N' ')YesTEXT50 Allow NULL? 
5CUSTOMER_IDCustomer Numbernvarchar100CHAR(N' ')YesSMI_AGREEMENTSKUNNR Allow NULL? 
6KDMATMaterial Number Used by Customernvarchar350CHAR(N' ')YesSMI_AGREEMENTSMATNR_KU Allow NULL? 
7BSTKDCustomer purchase order numbernvarchar350CHAR(N' ')YesBSTKD Allow NULL? 
8POSEXItem Number of the Underlying Purchase Ordernvarchar60CHAR(N' ')YesPOSEX Allow NULL? 
9WERKS_EXTCustomer description of partner (plant, storage location)nvarchar300CHAR(N' ')YesSMI_AGREEMENTSKNREF Allow NULL? 
10MATNRMaterial Numbernvarchar180CHAR(N' ')YesMARAMATNR Allow NULL? 
11VBELNSales Documentnvarchar100CHAR(N' ')Yes*VBELN_VA Allow NULL? 
12POSNRSales Document Itemnvarchar60NUMC(N'000000')Yes*POSNR_VA Allow NULL? 
13SOBKZSpecial Stock Indicatorchar10CHAR(N' ')Yes*SOBKZ Allow NULL? 
14STOP_HORIZONStop Horizon in Daysnvarchar40NUMC(N'0000')YesSMI_STOP_HORIZON Allow NULL? 
15REPL_METHSMI Replenishment Methodchar10CHAR(N' ')YesSMI_REPL_METH Allow NULL? 
16SAFETY_PERCSafety Tolerance (%)decimal41DEC((0))YesSMI_SAFETY_PERC
17SAFETY_QTYSafety Quantitydecimal136QUAN((0))YesSMI_SAFETY_QTY
18SFTY_QTY_UOMSafety Level Unitnvarchar30UNIT(N' ')Yes*SMI_SAFETY_UOM Allow NULL? 
19CUST_ROUND_VALIndicator for Usage of Customer Rounding Valueschar10CHAR(N' ')YesSMI_CUST_ROUNDING_VAL Allow NULL? 
20REPL_PROC_LOGICProcessing Trigger Replenishment (Autom., Batch, Manually)char10CHAR(N' ')YesSMI_PROCTRIG_REPL Allow NULL? 
21SEND_PROC_LOGICProcessing Trigger Send (Autom., Batch, Manually)char10CHAR(N' ')YesSMI_PROCTRIG_SEND Allow NULL? 
22STOP_FLAGStop Processing Indicatorchar10CHAR(N' ')YesSMI_STOP_FLAG Allow NULL? 
23COMP_LOGICSMI Comparison Logic Typechar10CHAR(N' ')YesSMI_COMP_LOGIC Allow NULL? 
24SMI_HORIZON_SShort-Term Period in Daysnvarchar20NUMC(N'00')YesSMI_HORIZON_SHORT Allow NULL? 
25SMI_HORIZON_MMid-Term Period in Daysnvarchar30NUMC(N'000')YesSMI_HORIZON_MID Allow NULL? 
26SMI_HORIZON_LLong-Term Period in Daysnvarchar40NUMC(N'0000')YesSMI_HORIZON_HIGH Allow NULL? 
27HIGH_PERC_SUpper Tolerance (%)decimal41DEC((0))YesSMI_HIGH_PERC
28LOW_PERC_SLower Tolerance (%)decimal41DEC((0))YesSMI_LOW_PERC
29HIGH_PERC_MUpper Tolerance (%)decimal41DEC((0))YesSMI_HIGH_PERC
30LOW_PERC_MLower Tolerance (%)decimal41DEC((0))YesSMI_LOW_PERC
31HIGH_PERC_LUpper Tolerance (%)decimal41DEC((0))YesSMI_HIGH_PERC
32LOW_PERC_LLower Tolerance (%)decimal41DEC((0))YesSMI_LOW_PERC
33ALERTCATEGORYAlert Categorynvarchar300CHAR(N' ')YesSALRTCATSALRTDCAT Allow NULL? 
34CREATORName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
35CHANGERName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
36CREATEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150DEC((0))YesTZNTSTMPS
37CHANGEDUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150DEC((0))YesTZNTSTMPS
NamePrimaryUniqueTypeColumns
SMI_PROFILE~0YesYesCLUSTEREDID, MANDT
SMI_PROFILE~SM1NoNoNONCLUSTEREDBSTKD, KDMAT, CUSTOMER_ID, 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