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  | MPDPSD
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
Industry Specific :: Aerospace Defence Industry Solution :: Maintenance Program Definition
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0MPDPSD532MPD: MPD and MP header dataMaintenance Program Definition
SQL:  selectupdate insert create

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

SELECT MANDT, PLAN_DATA_ID, DOKAR, DOKNR, DOKVR, DOKTL, AENNR, MPTYP, WSET, WPTXT, PLAN_SORT, BEGRU, VSPOS, VSNEG, TOPOS, TOSNEG, SFAKT, STICH, FABKL, ABRHO, HUNIT, HORIZ, CALL_CONFIRM, STADT, SZAEH, PSTXT, IWERK, WPGRP, AUFART, ILART, GEWERK, WERGW, GSBER, PLNTY, PLNNR, PLNAL, APFKT, QMART, PRIOK, TASK_DETERMINE, DOC_UPDT, TLC_IND, MP_CRTD_IND, COMPLIANCE_DATE, JOBNAME, JOBCOUNT, START_DATE, START_TIME, OR_KNZ, AND_KNZ, VORLAUF, TOBE_UPDATED, TOBE_RESTARTED FROM MPDPSD
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2PLAN_DATA_IDDocument Identification GUIDvarbinary160RAWNoMPD_DOCID
3DOKARDocument Typenvarchar30CHAR(N' ')NoTDWADOKAR Allow NULL? 
4DOKNRDocument numbernvarchar250CHAR(N' ')NoDRAWDOKNR Allow NULL? 
5DOKVRDocument Versionnvarchar20CHAR(N' ')NoDOKVR Allow NULL? 
6DOKTLDocument Partnvarchar30CHAR(N' ')NoDOKTL_D Allow NULL? 
7AENNRChange Numbernvarchar120CHAR(N' ')NoAENRAENNR Allow NULL? 
8MPTYPMaintenance Plan Categorynvarchar20CHAR(N' ')YesT399WMPD_MPTYP Allow NULL? 
9WSETCycle set for multiple counter plannvarchar60CHAR(N' ')Yes*WSET Allow NULL? 
10WPTXTMaintenance Plan Textnvarchar400CHAR(N' ')YesWPTXT Allow NULL? 
11PLAN_SORTSort field for maintenance plansnvarchar200CHAR(N' ')YesT399GPLAN_SORT Allow NULL? 
12BEGRUTechnical object authorization groupnvarchar40CHAR(N' ')YesT370BIAUTG Allow NULL? 
13VSPOSShift Factor for Late Completionnvarchar30NUMC(N'000')YesVERSCHPLUS Allow NULL? 
14VSNEGShift Factor for Early Completionnvarchar30NUMC(N'000')YesVERSCHNEG Allow NULL? 
15TOPOSTolerance for Late Completion (%)nvarchar30NUMC(N'000')YesTOLERPLUS Allow NULL? 
16TOSNEGTolerance for Early Completion (%)nvarchar30NUMC(N'000')YesTOLERNEG Allow NULL? 
17SFAKTCycle modification factordecimal32DEC((0))YesSFAKT
18STICHScheduling indicatorchar10CHAR(N' ')YesTERMKNZ Allow NULL? 
19FABKLFactory calendar keynvarchar20CHAR(N' ')Yes*FABKL Allow NULL? 
20ABRHOScheduling Periodnvarchar30NUMC(N'000')YesABRHO Allow NULL? 
21HUNITUnit in scheduling intervalnvarchar30UNIT(N' ')YesT006HUNIT Allow NULL? 
22HORIZHorizon until which dates in billing/invoice plan are validnvarchar80DATS(N'00000000')YesHORIZ Allow NULL? 
23CALL_CONFIRMOnly Create New Call Object After Completing Predecessorchar10CHAR(N' ')YesCALL_CONFIRM Allow NULL? 
24STADTStart datenvarchar80DATS(N'00000000')YesSTADT Allow NULL? 
25SZAEHStart counter readingnvarchar220CHAR(N' ')YesSZAEHC Allow NULL? 
26PSTXTItem Short Textnvarchar400CHAR(N' ')YesPOSTXT Allow NULL? 
27IWERKMaintenance Planning Plantnvarchar40CHAR(N' ')YesT399IIWERK Allow NULL? 
28WPGRPPlanner Group for Customer Service and Plant Maintenancenvarchar30CHAR(N' ')YesT024IINGRP Allow NULL? 
29AUFARTOrder Typenvarchar40CHAR(N' ')YesT003OAUFART Allow NULL? 
30ILARTMaintenance activity typenvarchar30CHAR(N' ')Yes*ILA Allow NULL? 
31GEWERKMain work center for maintenance tasksnvarchar80CHAR(N' ')YesGEWRK Allow NULL? 
32WERGWPlant associated with main work centernvarchar40CHAR(N' ')YesT001WWERGW Allow NULL? 
33GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
34PLNTYTask List Typechar10CHAR(N' ')Yes*PLNTY Allow NULL? 
35PLNNRKey for Task List Groupnvarchar80CHAR(N' ')YesPLNNR Allow NULL? 
36PLNALGroup Counternvarchar20CHAR(N' ')YesPLNAL Allow NULL? 
37APFKTExecution factor for whole task listdecimal30DEC((0))YesAPFKT
38QMARTNotification Typenvarchar20CHAR(N' ')YesTQ80QMART Allow NULL? 
39PRIOKPrioritychar10CHAR(N' ')YesT356PRIOK Allow NULL? 
40TASK_DETERMINEAutomatic task determination in the notificationchar10CHAR(N' ')YesTASK_DETERMINE Allow NULL? 
41DOC_UPDTPlanning and Scheduling Data Update Indicatorchar10CHAR(N' ')YesMPD_UPD Allow NULL? 
42TLC_INDLife-Limited Component Indicatorchar10CHAR(N' ')YesMPD_TLC Allow NULL? 
43MP_CRTD_INDMaintenance Plan Creation Indicatorchar10CHAR(N' ')YesMPD_CRTD_IND Allow NULL? 
44COMPLIANCE_DATECompliance Datenvarchar80DATS(N'00000000')YesMPD_COMPL_DATE Allow NULL? 
45JOBNAMEBackground job namenvarchar320CHAR(N' ')YesBTCJOB Allow NULL? 
46JOBCOUNTJob IDnvarchar80CHAR(N' ')YesBTCJOBCNT Allow NULL? 
47START_DATEMPD: Default Start Date for Maintenance Plansnvarchar80DATS(N'00000000')YesMPD_DEFAULT_START_DATE Allow NULL? 
48START_TIMEMPD: Default Start Time for Maintenance Plansnvarchar60TIMS(N'000000')YesMPD_DEFAULT_START_TIME Allow NULL? 
49OR_KNZIndicator for OR or AND linkchar10CHAR(N' ')YesANDOR Allow NULL? 
50AND_KNZIndicator for OR or AND linkchar10CHAR(N' ')YesANDOR Allow NULL? 
51VORLAUFLead Float in Daysnvarchar30NUMC(N'000')YesPUFF_VORL Allow NULL? 
52TOBE_UPDATEDMaintenance Plan to Be Updatedchar10CHAR(N' ')YesTOBE_UPDATED Allow NULL? 
53TOBE_RESTARTEDMaintenance Plan to Be Restartedchar10CHAR(N' ')YesTOBE_RESTARTED Allow NULL? 
NamePrimaryUniqueTypeColumns
MPDPSD~0YesYesCLUSTEREDAENNR, DOKTL, DOKVR, DOKNR, DOKAR, PLAN_DATA_ID, MANDT
MPDPSD~DDDNoNoNONCLUSTEREDDOKTL, DOKNR, DOKAR

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