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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6OPCH386A/P Invoice
7INV1265A/R Invoice - Rows
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OINM101Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
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 TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MLST_MANDTClientnvarchar30 Allow NULL? 
2MLST_ZAEHLMilestone numbernvarchar120 Allow NULL? 
3ZAEHLInternal counternvarchar80 Allow NULL? 
4DATUVValid-From Datenvarchar80 Allow NULL? 
5TECHVTechnical status fromnvarchar120 Allow NULL? 
6AENNRChange Numbernvarchar120 Allow NULL? 
7LOEKZDeletion Indicatorchar10 Allow NULL? 
8MLSTNUsagenvarchar50 Allow NULL? 
9USERHMilestone created bynvarchar120 Allow NULL? 
10DATEHMilestone created onnvarchar80 Allow NULL? 
11USERVMilestone changed bynvarchar120 Allow NULL? 
12DATEVMilestone changed onnvarchar80 Allow NULL? 
13PLNNRStandard network numbernvarchar80 Allow NULL? 
14PLNTYStandard network typechar10 Allow NULL? 
15PLNALAlternative to a standard networknvarchar20 Allow NULL? 
16PLNKNNumber of the task list nodenvarchar80 Allow NULL? 
17AUTYPOrder categorynvarchar20 Allow NULL? 
18AUFPLRouting number of operations in the ordernvarchar100 Allow NULL? 
19APLZLInternal counternvarchar80 Allow NULL? 
20PSPNRWBS Elementnvarchar80 Allow NULL? 
21TEDATScheduled milestone date (Basic)nvarchar80 Allow NULL? 
22TETIMScheduled milestone time (Basic)nvarchar60 Allow NULL? 
23TPDATScheduled milestone date (Forecast)nvarchar80 Allow NULL? 
24TPTIMScheduled milestone time (Forecast)nvarchar60 Allow NULL? 
25EDATUFixed milestone date (basic)nvarchar80 Allow NULL? 
26EZEITFixed milestone time (Basic)nvarchar60 Allow NULL? 
27PDATUFixed milestone date (F)nvarchar80 Allow NULL? 
28PZEITFixed milestone time (F)nvarchar60 Allow NULL? 
29LATEDIndicator: Latest dateschar10 Allow NULL? 
30DLTASInd: Reference for offset (start/finish activity date)char10 Allow NULL? 
31DELTAOffset for milestone datedecimal50
32DELTETime unit for offset of milestone datenvarchar30 Allow NULL? 
33PRCNTPercentual offset of milestone to activity datedecimal30
34SDDATKey determining the date for milestone in sales ordernvarchar20 Allow NULL? 
35KZ_TRENDMilestone relevant for trend analysischar10 Allow NULL? 
36KZ_LSTWRMilestone relevant for progress analysischar10 Allow NULL? 
37KZ_WFLOWIndicator: Milestone is used for milestone functionschar10 Allow NULL? 
38KZ_FAKTPMilestone is relevant for date in sales documentchar10 Allow NULL? 
39KZ_FRMSTRelease stop indicatorchar10 Allow NULL? 
40LST_FERTGPercentage of completion (%)nvarchar30 Allow NULL? 
41LST_ACTDTActual date (Milestone met)nvarchar80 Allow NULL? 
42LST_ACTTMActual date/time (Milestone met)nvarchar60 Allow NULL? 
43RUECKCompletion confirmation number for the operationnvarchar100 Allow NULL? 
44RMZHLInternal counternvarchar80 Allow NULL? 
45AUART_ICNWNetwork typenvarchar40 Allow NULL? 
46STDNR_ICNWStandard network numbernvarchar80 Allow NULL? 
47ALTNR_ICNWAlternative to a standard networknvarchar20 Allow NULL? 
48STDNR_ICPNStandard network numbernvarchar80 Allow NULL? 
49ALTNR_ICPNAlternative to a standard networknvarchar20 Allow NULL? 
50VORNR_ICPNActivity number in network and standard networknvarchar40 Allow NULL? 
51STDNR_ICSNStandard network numbernvarchar80 Allow NULL? 
52ALTNR_ICSNAlternative to a standard networknvarchar20 Allow NULL? 
53OPRST_ICSNActivity preceding the standard network to be includednvarchar40 Allow NULL? 
54OPREN_ICSNActivity following the standard network to be includednvarchar40 Allow NULL? 
55TASK_IDWorkflow tasknvarchar140 Allow NULL? 
56RELSUSelection functionchar10 Allow NULL? 
57RELMSSelection functionchar10 Allow NULL? 
58INCPNSelection functionchar10 Allow NULL? 
59INCNWSelection functionchar10 Allow NULL? 
60INCSNSelection functionchar10 Allow NULL? 
61WKFLWSelection functionchar10 Allow NULL? 
62RELSU_ALProcessing stagechar10 Allow NULL? 
63RELMS_ALProcessing stagechar10 Allow NULL? 
64INCPN_ALProcessing stagechar10 Allow NULL? 
65INCNW_ALProcessing stagechar10 Allow NULL? 
66INCSN_ALProcessing stagechar10 Allow NULL? 
67WKFLW_ALProcessing stagechar10 Allow NULL? 
68RELSU_SSFunction - activated system statusnvarchar50 Allow NULL? 
69RELMS_SSFunction - activated system statusnvarchar50 Allow NULL? 
70INCPN_SSFunction - activated system statusnvarchar50 Allow NULL? 
71INCNW_SSFunction - activated system statusnvarchar50 Allow NULL? 
72INCSN_SSFunction - activated system statusnvarchar50 Allow NULL? 
73WKFLW_SSFunction - activated system statusnvarchar50 Allow NULL? 
74RELSU_USFunction - activated user statusnvarchar50 Allow NULL? 
75RELMS_USFunction - activated user statusnvarchar50 Allow NULL? 
76INCPN_USFunction - activated user statusnvarchar50 Allow NULL? 
77INCNW_USFunction - activated user statusnvarchar50 Allow NULL? 
78INCSN_USFunction - activated user statusnvarchar50 Allow NULL? 
79WKFLW_USFunction - activated user statusnvarchar50 Allow NULL? 
80RELSU_SMSelection profile (status)nvarchar70 Allow NULL? 
81RELMS_SMSelection profile (status)nvarchar70 Allow NULL? 
82INCPN_SMSelection profile (status)nvarchar70 Allow NULL? 
83INCNW_SMSelection profile (status)nvarchar70 Allow NULL? 
84INCSN_SMSelection profile (status)nvarchar70 Allow NULL? 
85WKFLW_SMSelection profile (status)nvarchar70 Allow NULL? 
86RELSU_CHStatus change triggering the functionchar10 Allow NULL? 
87RELMS_CHStatus change triggering the functionchar10 Allow NULL? 
88INCPN_CHStatus change triggering the functionchar10 Allow NULL? 
89INCNW_CHStatus change triggering the functionchar10 Allow NULL? 
90INCSN_CHStatus change triggering the functionchar10 Allow NULL? 
91WKFLW_CHStatus change triggering the functionchar10 Allow NULL? 
92RELSU_SGInd: Function should only be executed oncechar10 Allow NULL? 
93RELMS_SGInd: Function should only be executed oncechar10 Allow NULL? 
94INCPN_SGInd: Function should only be executed oncechar10 Allow NULL? 
95INCNW_SGInd: Function should only be executed oncechar10 Allow NULL? 
96INCSN_SGInd: Function should only be executed oncechar10 Allow NULL? 
97WKFLW_SGInd: Function should only be executed oncechar10 Allow NULL? 
98RELSU_TRActivate functionchar10 Allow NULL? 
99RELMS_TRActivate functionchar10 Allow NULL? 
100INCPN_TRActivate functionchar10 Allow NULL? 
101INCNW_TRActivate functionchar10 Allow NULL? 
102INCSN_TRActivate functionchar10 Allow NULL? 
103WKFLW_TRActivate functionchar10 Allow NULL? 
104BEGRUAuthorization Groupnvarchar40 Allow NULL? 
105STSMAStatus Profilenvarchar80 Allow NULL? 
106SPSNRStd WBS: Internal project item number (w/exit on ID)nvarchar80 Allow NULL? 
107FPROZPercentage of value to be invoiceddecimal52
108COMP_RESOCM: Result of comparison of two order objectschar10 Allow NULL? 
109CH_PROCProcess that has lead to the change of an objectchar10 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