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  | MPLA
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
Plant Maintenance :: Preventive Maintenance :: Maintenance Task Lists
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0MPLA471Maintenance planMaintenance Task Lists
SQL:  selectupdate insert create

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

SELECT MANDT, WARPL, ERKNZ, AEKNZ, ERSDT, ERNAM, AEDAT, AENAM, WPTXT, STRAT, ABRHO, EQUNR, TPLNR, KUNUM, LTKNZ, LVORM, ANZPS, ABNUM, LANGU, VSPOS, VSNEG, TOPOS, TONEG, SFAKT, STICH, TGOON, HORIZ, HORIZ_DAYS, HORIZ_QUALIFIER, ANDOR, KNAUT, BEGRU, OBJNR, MPTYP, HUNIT, STADT, SZAEH, CALL_CONFIRM, PLAN_SORT, FABKL, PUFFP, PUFFN, START_DATE, START_TIME, CALL_UPDATE_IND, IND_MPLA_API, MCP_SF FROM MPLA
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2WARPLMaintenance Plannvarchar120CHAR(N' ')NoWARPL Allow NULL? 
3ERKNZCreation indicatorchar10CHAR(N' ')YesERKNZ Allow NULL? 
4AEKNZChange indicatorchar10CHAR(N' ')YesAEKNZ Allow NULL? 
5ERSDTDate of creationnvarchar80DATS(N'00000000')YesEDATUM Allow NULL? 
6ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
7AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
8AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
9WPTXTMaintenance Plan Textnvarchar400CHAR(N' ')YesWPTXT Allow NULL? 
10STRATMaintenance strategynvarchar60CHAR(N' ')YesT351STRAT Allow NULL? 
11ABRHOScheduling Periodnvarchar30NUMC(N'000')YesABRHO Allow NULL? 
12EQUNREquipment Numbernvarchar180CHAR(N' ')Yes*EQUNR Allow NULL? 
13TPLNRFunctional Locationnvarchar300CHAR(N' ')Yes*TPLNR Allow NULL? 
14KUNUMCustomer Numbernvarchar100CHAR(N' ')Yes*KUNUM Allow NULL? 
15LTKNZLong Text Indicatorchar10CHAR(N' ')YesMPLTX Allow NULL? 
16LVORMIndicator: maintenance plan locked against callschar10CHAR(N' ')YesABSTOP Allow NULL? 
17ANZPSNumber of maintenance items in the maintenance plannvarchar40NUMC(N'0000')YesANZMPOS Allow NULL? 
18ABNUMMaintenance Plan Call Numberint100INT4((0))YesABNUM Allow NULL? 
19LANGULanguage key of the long textchar10LANG(N' ')Yes*MPLANGU Allow NULL? 
20VSPOSShift Factor for Late Completionnvarchar30NUMC(N'000')YesVERSCHPLUS Allow NULL? 
21VSNEGShift Factor for Early Completionnvarchar30NUMC(N'000')YesVERSCHNEG Allow NULL? 
22TOPOSTolerance for Late Completion (%)nvarchar30NUMC(N'000')YesTOLERPLUS Allow NULL? 
23TONEGTolerance for Early Completion (%)nvarchar30NUMC(N'000')YesTOLERNEG Allow NULL? 
24SFAKTCycle modification factordecimal32DEC((0))YesSFAKT
25STICHScheduling indicatorchar10CHAR(N' ')YesTERMKNZ Allow NULL? 
26TGOONScheduling to reoccur when lead float reachednvarchar30NUMC(N'000')YesTGON Allow NULL? 
27HORIZCall horizon for maintenance plan callsnvarchar30NUMC(N'000')YesHORIZONT Allow NULL? 
28HORIZ_DAYSCall horizon for maintenance plan callsnvarchar30NUMC(N'000')YesHORIZONT Allow NULL? 
29HORIZ_QUALIFIERCalculation Type of Call Horizonchar10CHAR(N' ')YesEAM_CC_CALLHORIZON_QUALIFIER Allow NULL? 
30ANDORIndicator for OR or AND linkchar10CHAR(N' ')YesANDOR Allow NULL? 
31KNAUTReservedchar10CHAR(N' ')YesKNZABR Allow NULL? 
32BEGRUTechnical object authorization groupnvarchar40CHAR(N' ')YesT370BIAUTG Allow NULL? 
33OBJNRObject numbernvarchar220CHAR(N' ')Yes*J_OBJNR Allow NULL? 
34MPTYPMaintenance plan categorynvarchar20CHAR(N' ')YesT399WMPTYP Allow NULL? 
35HUNITUnit in scheduling intervalnvarchar30UNIT(N' ')Yes*HUNIT Allow NULL? 
36STADTStart datenvarchar80DATS(N'00000000')YesSTADT Allow NULL? 
37SZAEHStart counter readingnvarchar220CHAR(N' ')YesSZAEHC Allow NULL? 
38CALL_CONFIRMOnly Create New Call Object After Completing Predecessorchar10CHAR(N' ')YesCALL_CONFIRM Allow NULL? 
39PLAN_SORTSort field for maintenance plansnvarchar200CHAR(N' ')YesT399GPLAN_SORT Allow NULL? 
40FABKLFactory calendar keynvarchar20CHAR(N' ')YesTFACDFABKL Allow NULL? 
41PUFFPLead Float in Daysnvarchar30NUMC(N'000')YesPUFF_VORL Allow NULL? 
42PUFFNFollow-up float in daysnvarchar30NUMC(N'000')YesPUFF_NACHL Allow NULL? 
43START_DATEStart Date for Schedulingnvarchar80DATS(N'00000000')YesDATE_START Allow NULL? 
44START_TIMEStart Time for Schedulingnvarchar60TIMS(N'000000')YesTIME_START Allow NULL? 
45CALL_UPDATE_INDIndicator for Adapting Basic Dates of Call Objectchar10CHAR(N' ')YesIND_CALL_UPDATE Allow NULL? 
46IND_MPLA_APIMaintenance Plan Was Created/Changed by APInvarchar20CHAR(N' ')YesIND_MPLA_API Allow NULL? 
47MCP_SFShift Factor for Multiple Counter Planchar10CHAR(N' ')YesMCP_SF Allow NULL? 
NamePrimaryUniqueTypeColumns
MPLA~0YesYesCLUSTEREDWARPL, 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