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  | MLST
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
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.0MLST1095MilestoneNetwork and Activity
SQL:  selectupdate insert create

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

SELECT MLST_MANDT, MLST_ZAEHL, ZAEHL, DATUV, TECHV, AENNR, LOEKZ, MLSTN, USERH, DATEH, USERV, DATEV, PLNNR, PLNTY, PLNAL, PLNKN, AUTYP, AUFPL, APLZL, PSPNR, TEDAT, TETIM, TPDAT, TPTIM, EDATU, EZEIT, PDATU, PZEIT, LATED, DLTAS, DELTA, DELTE, PRCNT, SDDAT, KZ_TREND, KZ_LSTWR, KZ_WFLOW, KZ_FAKTP, KZ_FRMST, LST_FERTG, LST_ACTDT, LST_ACTTM, RUECK, RMZHL, AUART_ICNW, STDNR_ICNW, ALTNR_ICNW, STDNR_ICPN, ALTNR_ICPN, VORNR_ICPN, STDNR_ICSN, ALTNR_ICSN, OPRST_ICSN, OPREN_ICSN, TASK_ID, RELSU, RELMS, INCPN, INCNW, INCSN, WKFLW, RELSU_AL, RELMS_AL, INCPN_AL, INCNW_AL, INCSN_AL, WKFLW_AL, RELSU_SS, RELMS_SS, INCPN_SS, INCNW_SS, INCSN_SS, WKFLW_SS, RELSU_US, RELMS_US, INCPN_US, INCNW_US, INCSN_US, WKFLW_US, 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, BEGRU, STSMA, SPSNR, FPROZ, COMP_RES, CH_PROC FROM MLST
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MLST_MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2MLST_ZAEHLMilestone numbernvarchar120NUMC(N'000000000000')NoMLST_ZAEHL Allow NULL? 
3ZAEHLInternal counternvarchar80NUMC(N'00000000')NoCIM_COUNT Allow NULL? 
4DATUVValid-From Datenvarchar80DATS(N'00000000')YesDATUV Allow NULL? 
5TECHVTechnical status fromnvarchar120CHAR(N' ')YesTECHV Allow NULL? 
6AENNRChange Numbernvarchar120CHAR(N' ')YesAENRAENNR Allow NULL? 
7LOEKZDeletion Indicatorchar10CHAR(N' ')YesLKENZ Allow NULL? 
8MLSTNUsagenvarchar50CHAR(N' ')YesT433MILESTONE Allow NULL? 
9USERHMilestone created bynvarchar120CHAR(N' ')YesMLST_USERH Allow NULL? 
10DATEHMilestone created onnvarchar80DATS(N'00000000')YesMLST_DATEH Allow NULL? 
11USERVMilestone changed bynvarchar120CHAR(N' ')YesMLST_USERV Allow NULL? 
12DATEVMilestone changed onnvarchar80DATS(N'00000000')YesMLST_DATEV Allow NULL? 
13PLNNRStandard network numbernvarchar80CHAR(N' ')YesCN_PLNNR Allow NULL? 
14PLNTYStandard network typechar10CHAR(N' ')YesTCA01CN_PLNTY Allow NULL? 
15PLNALAlternative to a standard networknvarchar20CHAR(N' ')YesCN_PLNAL Allow NULL? 
16PLNKNNumber of the task list nodenvarchar80NUMC(N'00000000')YesPLNKN Allow NULL? 
17AUTYPOrder categorynvarchar20NUMC(N'00')YesAUFTYP Allow NULL? 
18AUFPLRouting number of operations in the ordernvarchar100NUMC(N'0000000000')YesCO_AUFPL Allow NULL? 
19APLZLInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
20PSPNRWBS Elementnvarchar80NUMC(N'00000000')YesPRPSPS_POSNR Allow NULL? 
21TEDATScheduled milestone date (Basic)nvarchar80DATS(N'00000000')YesMLST_TEDAT Allow NULL? 
22TETIMScheduled milestone time (Basic)nvarchar60TIMS(N'000000')YesMLST_TETIM Allow NULL? 
23TPDATScheduled milestone date (Forecast)nvarchar80DATS(N'00000000')YesMLST_TPDAT Allow NULL? 
24TPTIMScheduled milestone time (Forecast)nvarchar60TIMS(N'000000')YesMLST_TPTIM Allow NULL? 
25EDATUFixed milestone date (basic)nvarchar80DATS(N'00000000')YesMLST_EDATU Allow NULL? 
26EZEITFixed milestone time (Basic)nvarchar60TIMS(N'000000')YesMLST_EZEIT Allow NULL? 
27PDATUFixed milestone date (F)nvarchar80DATS(N'00000000')YesMLST_PDATU Allow NULL? 
28PZEITFixed milestone time (F)nvarchar60TIMS(N'000000')YesMLST_PZEIT Allow NULL? 
29LATEDIndicator: Latest dateschar10CHAR(N' ')YesMLST_LATE Allow NULL? 
30DLTASInd: Reference for offset (start/finish activity date)char10CHAR(N' ')YesMLST_DLTAS Allow NULL? 
31DELTAOffset for milestone datedecimal50QUAN((0))YesMLST_DELTA
32DELTETime unit for offset of milestone datenvarchar30UNIT(N' ')YesT006MLST_DELTE Allow NULL? 
33PRCNTPercentual offset of milestone to activity datedecimal30DEC((0))YesMLST_PRCNT
34SDDATKey determining the date for milestone in sales ordernvarchar20CHAR(N' ')YesMLST_SDDAT Allow NULL? 
35KZ_TRENDMilestone relevant for trend analysischar10CHAR(N' ')YesMLST_TREND Allow NULL? 
36KZ_LSTWRMilestone relevant for progress analysischar10CHAR(N' ')YesMLST_LSTWR Allow NULL? 
37KZ_WFLOWIndicator: Milestone is used for milestone functionschar10CHAR(N' ')YesMLST_WFLOW Allow NULL? 
38KZ_FAKTPMilestone is relevant for date in sales documentchar10CHAR(N' ')YesMLST_FAKTP Allow NULL? 
39KZ_FRMSTRelease stop indicatorchar10CHAR(N' ')YesMLST_FRMST Allow NULL? 
40LST_FERTGPercentage of completion (%)nvarchar30NUMC(N'000')YesMLST_FERTG Allow NULL? 
41LST_ACTDTActual date (Milestone met)nvarchar80DATS(N'00000000')YesMLST_ACTDT Allow NULL? 
42LST_ACTTMActual date/time (Milestone met)nvarchar60TIMS(N'000000')YesMLST_ACTTM Allow NULL? 
43RUECKCompletion confirmation number for the operationnvarchar100NUMC(N'0000000000')YesCO_RUECK Allow NULL? 
44RMZHLInternal counternvarchar80NUMC(N'00000000')YesCIM_COUNT Allow NULL? 
45AUART_ICNWNetwork typenvarchar40CHAR(N' ')YesT003OMLST_AUART Allow NULL? 
46STDNR_ICNWStandard network numbernvarchar80CHAR(N' ')YesCN_PLNNR Allow NULL? 
47ALTNR_ICNWAlternative to a standard networknvarchar20CHAR(N' ')YesCN_PLNAL Allow NULL? 
48STDNR_ICPNStandard network numbernvarchar80CHAR(N' ')YesCN_PLNNR Allow NULL? 
49ALTNR_ICPNAlternative to a standard networknvarchar20CHAR(N' ')YesCN_PLNAL Allow NULL? 
50VORNR_ICPNActivity number in network and standard networknvarchar40CHAR(N' ')YesCN_VORNR Allow NULL? 
51STDNR_ICSNStandard network numbernvarchar80CHAR(N' ')YesCN_PLNNR Allow NULL? 
52ALTNR_ICSNAlternative to a standard networknvarchar20CHAR(N' ')YesCN_PLNAL Allow NULL? 
53OPRST_ICSNActivity preceding the standard network to be includednvarchar40CHAR(N' ')YesOPR_START Allow NULL? 
54OPREN_ICSNActivity following the standard network to be includednvarchar40CHAR(N' ')YesOPR_END Allow NULL? 
55TASK_IDWorkflow tasknvarchar140CHAR(N' ')YesMLST_TASK Allow NULL? 
56RELSUSelection functionchar10CHAR(N' ')YesMLST_RELSU Allow NULL? 
57RELMSSelection functionchar10CHAR(N' ')YesMLST_RELMS Allow NULL? 
58INCPNSelection functionchar10CHAR(N' ')YesMLST_INCPN Allow NULL? 
59INCNWSelection functionchar10CHAR(N' ')YesMLST_INCNW Allow NULL? 
60INCSNSelection functionchar10CHAR(N' ')YesMLST_INCSN Allow NULL? 
61WKFLWSelection functionchar10CHAR(N' ')YesMLST_WKFLW Allow NULL? 
62RELSU_ALProcessing stagechar10CHAR(N' ')YesACTLV Allow NULL? 
63RELMS_ALProcessing stagechar10CHAR(N' ')YesACTLV Allow NULL? 
64INCPN_ALProcessing stagechar10CHAR(N' ')YesACTLV Allow NULL? 
65INCNW_ALProcessing stagechar10CHAR(N' ')YesACTLV Allow NULL? 
66INCSN_ALProcessing stagechar10CHAR(N' ')YesACTLV Allow NULL? 
67WKFLW_ALProcessing stagechar10CHAR(N' ')YesACTLV Allow NULL? 
68RELSU_SSFunction - activated system statusnvarchar50CHAR(N' ')YesSYSTA Allow NULL? 
69RELMS_SSFunction - activated system statusnvarchar50CHAR(N' ')YesSYSTA Allow NULL? 
70INCPN_SSFunction - activated system statusnvarchar50CHAR(N' ')YesSYSTA Allow NULL? 
71INCNW_SSFunction - activated system statusnvarchar50CHAR(N' ')YesSYSTA Allow NULL? 
72INCSN_SSFunction - activated system statusnvarchar50CHAR(N' ')YesSYSTA Allow NULL? 
73WKFLW_SSFunction - activated system statusnvarchar50CHAR(N' ')YesSYSTA Allow NULL? 
74RELSU_USFunction - activated user statusnvarchar50CHAR(N' ')YesUSSTA Allow NULL? 
75RELMS_USFunction - activated user statusnvarchar50CHAR(N' ')YesUSSTA Allow NULL? 
76INCPN_USFunction - activated user statusnvarchar50CHAR(N' ')YesUSSTA Allow NULL? 
77INCNW_USFunction - activated user statusnvarchar50CHAR(N' ')YesUSSTA Allow NULL? 
78INCSN_USFunction - activated user statusnvarchar50CHAR(N' ')YesUSSTA Allow NULL? 
79WKFLW_USFunction - activated user statusnvarchar50CHAR(N' ')YesUSSTA Allow NULL? 
80RELSU_SMSelection profile (status)nvarchar70CHAR(N' ')YesTJ48SESMA Allow NULL? 
81RELMS_SMSelection profile (status)nvarchar70CHAR(N' ')YesTJ48SESMA Allow NULL? 
82INCPN_SMSelection profile (status)nvarchar70CHAR(N' ')YesTJ48SESMA Allow NULL? 
83INCNW_SMSelection profile (status)nvarchar70CHAR(N' ')YesTJ48SESMA Allow NULL? 
84INCSN_SMSelection profile (status)nvarchar70CHAR(N' ')YesTJ48SESMA Allow NULL? 
85WKFLW_SMSelection profile (status)nvarchar70CHAR(N' ')YesTJ48SESMA Allow NULL? 
86RELSU_CHStatus change triggering the functionchar10CHAR(N' ')YesCHANG Allow NULL? 
87RELMS_CHStatus change triggering the functionchar10CHAR(N' ')YesCHANG Allow NULL? 
88INCPN_CHStatus change triggering the functionchar10CHAR(N' ')YesCHANG Allow NULL? 
89INCNW_CHStatus change triggering the functionchar10CHAR(N' ')YesCHANG Allow NULL? 
90INCSN_CHStatus change triggering the functionchar10CHAR(N' ')YesCHANG Allow NULL? 
91WKFLW_CHStatus change triggering the functionchar10CHAR(N' ')YesCHANG Allow NULL? 
92RELSU_SGInd: Function should only be executed oncechar10CHAR(N' ')YesSGACT Allow NULL? 
93RELMS_SGInd: Function should only be executed oncechar10CHAR(N' ')YesSGACT Allow NULL? 
94INCPN_SGInd: Function should only be executed oncechar10CHAR(N' ')YesSGACT Allow NULL? 
95INCNW_SGInd: Function should only be executed oncechar10CHAR(N' ')YesSGACT Allow NULL? 
96INCSN_SGInd: Function should only be executed oncechar10CHAR(N' ')YesSGACT Allow NULL? 
97WKFLW_SGInd: Function should only be executed oncechar10CHAR(N' ')YesSGACT Allow NULL? 
98RELSU_TRActivate functionchar10CHAR(N' ')YesTRIGG Allow NULL? 
99RELMS_TRActivate functionchar10CHAR(N' ')YesTRIGG Allow NULL? 
100INCPN_TRActivate functionchar10CHAR(N' ')YesTRIGG Allow NULL? 
101INCNW_TRActivate functionchar10CHAR(N' ')YesTRIGG Allow NULL? 
102INCSN_TRActivate functionchar10CHAR(N' ')YesTRIGG Allow NULL? 
103WKFLW_TRActivate functionchar10CHAR(N' ')YesTRIGG Allow NULL? 
104BEGRUAuthorization Groupnvarchar40CHAR(N' ')YesBEGRU Allow NULL? 
105STSMAStatus Profilenvarchar80CHAR(N' ')YesTJ20J_STSMA Allow NULL? 
106SPSNRStd WBS: Internal project item number (w/exit on ID)nvarchar80NUMC(N'00000000')YesPRPSSPS_SPSNR Allow NULL? 
107FPROZPercentage of value to be invoiceddecimal52DEC((0))YesFPROZ
108COMP_RESOCM: Result of comparison of two order objectschar10CHAR(N' ')YesOCM_COMP_RES Allow NULL? 
109CH_PROCProcess that has lead to the change of an objectchar10CHAR(N' ')YesOCM_CH_PROC Allow NULL? 
NamePrimaryUniqueTypeColumns
MLST~0YesYesCLUSTEREDZAEHL, MLST_ZAEHL, MLST_MANDT
MLST~1ADNoNoNONCLUSTEREDAUFPL
MLST~2ADNoNoNONCLUSTEREDPSPNR
MLST~3NoNoNONCLUSTEREDPLNNR, PLNTY, MLST_MANDT
MLST~4ADNoNoNONCLUSTEREDSPSNR

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