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  | SMLS
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
Project System :: Structures :: Operative Structures :: Network and Activity
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0SMLS772Standard milestoneNetwork and Activity
SQL:  selectupdate insert create

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

SELECT MLST_MANDT, AUTYP, MLST_SMLNR, MLSET, MLSTN, USERH, DATEH, USERV, DATEV, LST_FERTG, LATED, DLTAS, DELTA, DELTE, PRCNT, SDDAT, KZ_LSTWR, KZ_WFLOW, KZ_FAKTP, KZ_FRMST, RELSU, RELMS, INCPN, INCNW, INCSN, WKFLW, RELSU_SS, RELMS_SS, INCPN_SS, INCNW_SS, INCSN_SS, WKFLW_SS, RELSU_SM, RELMS_SM, INCPN_SM, INCNW_SM, INCSN_SM, WKFLW_SM, RELSU_CH, RELMS_CH, INCPN_CH, INCNW_CH, INCSN_CH, WKFLW_CH, RELSU_SG, RELMS_SG, INCPN_SG, INCNW_SG, INCSN_SG, WKFLW_SG, RELSU_TR, RELMS_TR, INCPN_TR, INCNW_TR, INCSN_TR, WKFLW_TR, RELSU_US, RELMS_US, INCPN_US, INCNW_US, INCSN_US, WKFLW_US, AUART_ICNW, STDNR_ICNW, ALTNR_ICNW, STDNR_ICPN, ALTNR_ICPN, VORNR_ICPN, STDNR_ICSN, ALTNR_ICSN, OPRST_ICSN, OPREN_ICSN, TASK_ID, BEGRU, STSMA, FPROZ, KZ_TREND FROM SMLS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MLST_MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2AUTYPOrder categorynvarchar20NUMC(N'00')NoAUFTYP Allow NULL? 
3MLST_SMLNRName of standard milestonenvarchar100CHAR(N' ')NoMLST_SMLNR Allow NULL? 
4MLSETMilestone groupnvarchar100CHAR(N' ')NoSMLGMLSET Allow NULL? 
5MLSTNUsagenvarchar50CHAR(N' ')NoT433MILESTONE Allow NULL? 
6USERHStandard milestone created bynvarchar120CHAR(N' ')NoSMLS_USERH Allow NULL? 
7DATEHStandard milestone created onnvarchar80DATS(N'00000000')NoSMLS_DATEH Allow NULL? 
8USERVStandard milestone changed bynvarchar120CHAR(N' ')NoSMLS_USERV Allow NULL? 
9DATEVStandard milestone changed onnvarchar80DATS(N'00000000')NoSMLS_DATEV Allow NULL? 
10LST_FERTGPercentage of completion (%)nvarchar30NUMC(N'000')NoSMLS_FERTG Allow NULL? 
11LATEDIndicator: Latest dateschar10CHAR(N' ')NoSMLS_LATE Allow NULL? 
12DLTASInd: Offset for time interval (start/finish activity date)char10CHAR(N' ')NoSMLS_DLTAS Allow NULL? 
13DELTAOffset between standard milestone and activity datesdecimal50QUAN((0))NoSMLS_DELTA
14DELTEUnit for time interval std. milestone/activity datenvarchar30UNIT(N' ')NoT006SMLS_DELTE Allow NULL? 
15PRCNTTime interval in percentage std. milestone/activity datedecimal30DEC((0))NoSMLS_PRCNT
16SDDATKey that determines the date for milestone in sales ordernvarchar20CHAR(N' ')NoSMLS_SDDAT Allow NULL? 
17KZ_LSTWRIndicator: Milestone relevant for progress analysischar10CHAR(N' ')NoSMLS_LSTWR Allow NULL? 
18KZ_WFLOWIndicator: Milestone is used for milestone functionschar10CHAR(N' ')NoSMLS_WFLOW Allow NULL? 
19KZ_FAKTPIndicator: Milestone is relevant for date in sales documentchar10CHAR(N' ')NoSMLS_FAKTP Allow NULL? 
20KZ_FRMSTMilestone: Release stop indicatorchar10CHAR(N' ')NoSMLS_FRMST Allow NULL? 
21RELSUSelection functionchar10CHAR(N' ')NoSMLS_RELSU Allow NULL? 
22RELMSSelection functionchar10CHAR(N' ')NoSMLS_RELMS Allow NULL? 
23INCPNSelection functionchar10CHAR(N' ')NoSMLS_INCPN Allow NULL? 
24INCNWSelection functionchar10CHAR(N' ')NoSMLS_INCNW Allow NULL? 
25INCSNSelection functionchar10CHAR(N' ')NoSMLS_INCSN Allow NULL? 
26WKFLWSelection functionchar10CHAR(N' ')NoSMLS_WKFLW Allow NULL? 
27RELSU_SSFunction - activated system statusnvarchar50CHAR(N' ')NoSYSTA Allow NULL? 
28RELMS_SSFunction - activated system statusnvarchar50CHAR(N' ')NoSYSTA Allow NULL? 
29INCPN_SSFunction - activated system statusnvarchar50CHAR(N' ')NoSYSTA Allow NULL? 
30INCNW_SSFunction - activated system statusnvarchar50CHAR(N' ')NoSYSTA Allow NULL? 
31INCSN_SSFunction - activated system statusnvarchar50CHAR(N' ')NoSYSTA Allow NULL? 
32WKFLW_SSFunction - activated system statusnvarchar50CHAR(N' ')NoSYSTA Allow NULL? 
33RELSU_SMSelection profile for standard milestone statusnvarchar70CHAR(N' ')NoTJ48SMLS_SESMA Allow NULL? 
34RELMS_SMSelection profile for standard milestone statusnvarchar70CHAR(N' ')NoTJ48SMLS_SESMA Allow NULL? 
35INCPN_SMSelection profile for standard milestone statusnvarchar70CHAR(N' ')NoTJ48SMLS_SESMA Allow NULL? 
36INCNW_SMSelection profile for standard milestone statusnvarchar70CHAR(N' ')NoTJ48SMLS_SESMA Allow NULL? 
37INCSN_SMSelection profile for standard milestone statusnvarchar70CHAR(N' ')NoTJ48SMLS_SESMA Allow NULL? 
38WKFLW_SMSelection profile for standard milestone statusnvarchar70CHAR(N' ')NoTJ48SMLS_SESMA Allow NULL? 
39RELSU_CHStatus change triggering the functionchar10CHAR(N' ')NoSMLS_CHANG Allow NULL? 
40RELMS_CHStatus change triggering the functionchar10CHAR(N' ')NoSMLS_CHANG Allow NULL? 
41INCPN_CHStatus change triggering the functionchar10CHAR(N' ')NoSMLS_CHANG Allow NULL? 
42INCNW_CHStatus change triggering the functionchar10CHAR(N' ')NoSMLS_CHANG Allow NULL? 
43INCSN_CHStatus change triggering the functionchar10CHAR(N' ')NoSMLS_CHANG Allow NULL? 
44WKFLW_CHStatus change triggering the functionchar10CHAR(N' ')NoSMLS_CHANG Allow NULL? 
45RELSU_SGInd: Function should only be executed oncechar10CHAR(N' ')NoSMLS_SGACT Allow NULL? 
46RELMS_SGInd: Function should only be executed oncechar10CHAR(N' ')NoSMLS_SGACT Allow NULL? 
47INCPN_SGInd: Function should only be executed oncechar10CHAR(N' ')NoSMLS_SGACT Allow NULL? 
48INCNW_SGInd: Function should only be executed oncechar10CHAR(N' ')NoSMLS_SGACT Allow NULL? 
49INCSN_SGInd: Function should only be executed oncechar10CHAR(N' ')NoSMLS_SGACT Allow NULL? 
50WKFLW_SGInd: Function should only be executed oncechar10CHAR(N' ')NoSMLS_SGACT Allow NULL? 
51RELSU_TRActivate functionchar10CHAR(N' ')NoSMLS_TRIGG Allow NULL? 
52RELMS_TRActivate functionchar10CHAR(N' ')NoSMLS_TRIGG Allow NULL? 
53INCPN_TRActivate functionchar10CHAR(N' ')NoSMLS_TRIGG Allow NULL? 
54INCNW_TRActivate functionchar10CHAR(N' ')NoSMLS_TRIGG Allow NULL? 
55INCSN_TRActivate functionchar10CHAR(N' ')NoSMLS_TRIGG Allow NULL? 
56WKFLW_TRActivate functionchar10CHAR(N' ')NoSMLS_TRIGG Allow NULL? 
57RELSU_USFunction - activated user statusnvarchar50CHAR(N' ')NoUSSTA Allow NULL? 
58RELMS_USFunction - activated user statusnvarchar50CHAR(N' ')NoUSSTA Allow NULL? 
59INCPN_USFunction - activated user statusnvarchar50CHAR(N' ')NoUSSTA Allow NULL? 
60INCNW_USFunction - activated user statusnvarchar50CHAR(N' ')NoUSSTA Allow NULL? 
61INCSN_USFunction - activated user statusnvarchar50CHAR(N' ')NoUSSTA Allow NULL? 
62WKFLW_USFunction - activated user statusnvarchar50CHAR(N' ')NoUSSTA Allow NULL? 
63AUART_ICNWNetwork typenvarchar40CHAR(N' ')NoT003OMLST_AUART Allow NULL? 
64STDNR_ICNWStandard network numbernvarchar80CHAR(N' ')NoCN_PLNNR Allow NULL? 
65ALTNR_ICNWAlternative to a standard networknvarchar20CHAR(N' ')NoCN_PLNAL Allow NULL? 
66STDNR_ICPNStandard network numbernvarchar80CHAR(N' ')NoCN_PLNNR Allow NULL? 
67ALTNR_ICPNAlternative to a standard networknvarchar20CHAR(N' ')NoCN_PLNAL Allow NULL? 
68VORNR_ICPNActivity number in network and standard networknvarchar40CHAR(N' ')NoCN_VORNR Allow NULL? 
69STDNR_ICSNStandard network numbernvarchar80CHAR(N' ')NoCN_PLNNR Allow NULL? 
70ALTNR_ICSNAlternative to a standard networknvarchar20CHAR(N' ')NoCN_PLNAL Allow NULL? 
71OPRST_ICSNActivity preceding the standard network to be includednvarchar40CHAR(N' ')NoOPR_START Allow NULL? 
72OPREN_ICSNActivity following the standard network to be includednvarchar40CHAR(N' ')NoOPR_END Allow NULL? 
73TASK_IDWorkflow tasknvarchar140CHAR(N' ')NoMLST_TASK Allow NULL? 
74BEGRUAuthorization Groupnvarchar40CHAR(N' ')NoBEGRU Allow NULL? 
75STSMAStatus Profilenvarchar80CHAR(N' ')NoTJ20J_STSMA Allow NULL? 
76FPROZPercentage of value to be invoiceddecimal52DEC((0))YesFPROZ
77KZ_TRENDIndicator: Milestone relevant for trend analysischar10CHAR(N' ')YesSMLS_TREND Allow NULL? 
NamePrimaryUniqueTypeColumns
SMLS~0YesYesCLUSTEREDMLST_SMLNR, AUTYP, MLST_MANDT
SMLS~1NoNoNONCLUSTEREDMLSTN

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