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  | MDKP
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
Production Planning and Control :: Material Requirements Planning :: Master Data
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0MDKP982Header Data for MRP DocumentMaster Data
SQL:  selectupdate insert create

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

SELECT MANDT, DTART, MATNR, PLWRK, PLSCN, DTNUM, DSDAT, BDBKZ, SLKZ1, SLKZ2, SLKZ3, SLKZ4, SLKZ5, SLKZ6, SLKZ7, SLKZ8, VRKZ1, VRKZ2, VRKZ3, MTART, MEINS, DISST, BESKZ, SOBSL, SOBES, WRK02, DISMM, DISVF, DISPO, PLDIS, EKGRP, MTWZT, WEBAZ, BEAZT, FIXTR, MFHKZ, DISLS, LOSVF, LOSKZ, PERAZ, EISBE, MINBE, HOEBE, BSTMI, BSTMA, BSTFX, BSTRF, SUM01, SUM02, SUM03, SUM04, SUM05, NEGBS, MSGID, MSGAR, MSGNR, MSGV1, MSGV2, MSGV3, MSGV4, DISGR, PERIV, MRPPP, BDARF, LFRHY, RDPRF, BERW1, BERW2, KZAUS, AUSDT, NFMAT, AUSZ1, AUSZ2, AUSZ3, AUSZ4, AUSZ5, AUSZ6, AUSZ7, AUSZ8, BEADA, NAUKZ, SAUFT, KZPROMO, SHFLG, SHZET, FABKZ, MFXDT, BSKFL, MAABC, CFLAG, GRREL, RWPRO, SHPRO, AHDIS, BERW4, BADON, SGT_STATC, HANAON FROM MDKP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2DTARTType of MRP listnvarchar20CHAR(N' ')NoDTART Allow NULL? 
3MATNRMaterial Numbernvarchar180CHAR(N' ')NoMARAMATNR Allow NULL? 
4PLWRKPlantnvarchar40CHAR(N' ')NoT001WWERKS_D Allow NULL? 
5PLSCNPlanning Scenario of Long-Term Planningnvarchar30NUMC(N'000')NoPLSCPLSCN Allow NULL? 
6DTNUMNumber of material requirements planning tablenvarchar100NUMC(N'0000000000')YesDTNUM Allow NULL? 
7DSDATMRP datenvarchar80DATS(N'00000000')YesDSDAT Allow NULL? 
8BDBKZSelection indicator for processed MRP listschar10CHAR(N' ')YesBDBKZ Allow NULL? 
9SLKZ1Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
10SLKZ2Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
11SLKZ3Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
12SLKZ4Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
13SLKZ5Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
14SLKZ6Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
15SLKZ7Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
16SLKZ8Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
17VRKZ1Processing indicator 01char10CHAR(N' ')YesVRKZ1 Allow NULL? 
18VRKZ2Processing indicator 02char10CHAR(N' ')YesVRKZ2 Allow NULL? 
19VRKZ3Processing indicator - 03char10CHAR(N' ')YesVRKZ3 Allow NULL? 
20MTARTMaterial Typenvarchar40CHAR(N' ')YesT134MTART Allow NULL? 
21MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
22DISSTLow-Level Codenvarchar30CHAR(N' ')YesDISST Allow NULL? 
23BESKZProcurement Typechar10CHAR(N' ')YesBESKZ Allow NULL? 
24SOBSLSpecial procurement typenvarchar20CHAR(N' ')YesT460ASOBSL Allow NULL? 
25SOBESSpecial procurement typechar10CHAR(N' ')YesSOBES Allow NULL? 
26WRK02Planning/production plantnvarchar40CHAR(N' ')YesT001WWRK02 Allow NULL? 
27DISMMMRP Typenvarchar20CHAR(N' ')YesT438ADISMM Allow NULL? 
28DISVFMRP procedurechar10CHAR(N' ')YesDISVF Allow NULL? 
29DISPOMRP Controller (Materials Planner)nvarchar30CHAR(N' ')YesT024DDISPO Allow NULL? 
30PLDISPlanning controller (no longer used)nvarchar30CHAR(N' ')YesT024DPLDIS Allow NULL? 
31EKGRPPurchasing Groupnvarchar30CHAR(N' ')YesT024EKGRP Allow NULL? 
32MTWZTMaterial replenishment lead timedecimal30DEC((0))YesMTWZT
33WEBAZGoods Receipt Processing Time in Daysdecimal30DEC((0))YesWEBAZ
34BEAZTProcessing time for purchase order proposaldecimal30DEC((0))YesBEAZT
35FIXTREnd of planning time fence (date)nvarchar80DATS(N'00000000')YesFIXTR Allow NULL? 
36MFHKZPlanning time fence set manually (MFXDT)char10CHAR(N' ')YesMFHKZ Allow NULL? 
37DISLSLot size (materials planning)nvarchar20CHAR(N' ')YesT439ADISLS Allow NULL? 
38LOSVFLot-sizing procedure for short-term periodchar10CHAR(N' ')YesLOSVF Allow NULL? 
39LOSKZLot-size indicator for the short-term periodchar10CHAR(N' ')YesLOSKZ Allow NULL? 
40PERAZNumber of periods for the short-term areadecimal30DEC((0))YesPERAZ
41EISBESafety Stockdecimal133QUAN((0))YesEISBE
42MINBEReorder Pointdecimal133QUAN((0))YesMINBE
43HOEBEMaximum stock leveldecimal133QUAN((0))YesMABST
44BSTMIMinimum Lot Sizedecimal133QUAN((0))YesBSTMI
45BSTMAMaximum Lot Sizedecimal133QUAN((0))YesBSTMA
46BSTFXFixed lot sizedecimal133QUAN((0))YesBSTFE
47BSTRFRounding value for purchase order quantitydecimal133QUAN((0))YesBSTRF
48SUM01Plant stock / only plant segmentdecimal133QUAN((0))YesSUM01W
49SUM02No longer used/do not use!!decimal133QUAN((0))YesNOUSE
50SUM03No longer used/do not use!!decimal133QUAN((0))YesNOUSE
51SUM04No longer used/do not use!!decimal133QUAN((0))YesNOUSE
52SUM05No longer used/do not use!!decimal133QUAN((0))YesNOUSE
53NEGBSNegative stockdecimal133QUAN((0))YesNEGBS
54MSGIDMessage identificationnvarchar200CHAR(N' ')Yes*MSGID Allow NULL? 
55MSGARMessage Typechar10CHAR(N' ')YesMSGTY Allow NULL? 
56MSGNRMessage numbernvarchar30CHAR(N' ')YesT100MSGNR Allow NULL? 
57MSGV1Message variable 01nvarchar500CHAR(N' ')YesMSGV1 Allow NULL? 
58MSGV2Message variable 02nvarchar500CHAR(N' ')YesMSGV2 Allow NULL? 
59MSGV3Message variable 03nvarchar500CHAR(N' ')YesMSGV3 Allow NULL? 
60MSGV4Message variable 04nvarchar500CHAR(N' ')YesMSGV4 Allow NULL? 
61DISGRMRP Groupnvarchar40CHAR(N' ')YesT438MDISGR Allow NULL? 
62PERIVFiscal Year Variantnvarchar20CHAR(N' ')YesT009PERIV Allow NULL? 
63MRPPPPPC planning calendarnvarchar30CHAR(N' ')YesT439GMRPPP Allow NULL? 
64BDARFRequirements quantity from material requirements planningdecimal133QUAN((0))YesBDARF
65LFRHYPlanning cyclenvarchar30CHAR(N' ')YesT439GLFRHY Allow NULL? 
66RDPRFRounding Profilenvarchar40CHAR(N' ')Yes*RDPRF Allow NULL? 
67BERW1Stock Days' Supply Without Receiptsdecimal41DEC((0))YesBERW1
68BERW2First Receipt Days' Supplydecimal41DEC((0))YesBERW2
69KZAUSDiscontinuation indicatorchar10CHAR(N' ')YesKZAUS Allow NULL? 
70AUSDTEffective-Out Datenvarchar80DATS(N'00000000')YesAUSDT Allow NULL? 
71NFMATFollow-Up Materialnvarchar180CHAR(N' ')Yes*NFMAT Allow NULL? 
72AUSZ1Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
73AUSZ2Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
74AUSZ3Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
75AUSZ4Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
76AUSZ5Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
77AUSZ6Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
78AUSZ7Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
79AUSZ8Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
80BEADAMRP list processing datenvarchar80DATS(N'00000000')YesBEADA Allow NULL? 
81NAUKZIndicator: new exception in the MRP listchar10CHAR(N' ')YesNAUKZ Allow NULL? 
82SAUFTInd.: Repetitive mfg allowedchar10CHAR(N' ')YesSA_SAUFT Allow NULL? 
83KZPROMOIndicator: Material in promotionchar10CHAR(N' ')YesKZPROMO Allow NULL? 
84SHFLGSafety time indicator (with or without safety time)char10CHAR(N' ')YesSHFLG Allow NULL? 
85SHZETSafety time (in workdays)nvarchar20NUMC(N'00')YesSHZET Allow NULL? 
86FABKZIndicator: Item Relevant to JIT Delivery Scheduleschar10CHAR(N' ')YesFABKZ Allow NULL? 
87MFXDTManual firming datenvarchar80DATS(N'00000000')YesMFXDT Allow NULL? 
88BSKFLFlag whether stock correction factors existchar10CHAR(N' ')YesBSKFL Allow NULL? 
89MAABCABC Indicatorchar10CHAR(N' ')Yes*MAABC Allow NULL? 
90CFLAGAggregated MRP listchar10CHAR(N' ')YesCOMPMRPL Allow NULL? 
91GRRELRelevant for requirements grouping for project stockchar10CHAR(N' ')YesGRREL Allow NULL? 
92RWPRORange of coverage profilenvarchar30CHAR(N' ')Yes*RWPRO Allow NULL? 
93SHPROPeriod Profile for Safety Timenvarchar30CHAR(N' ')Yes*SHPRO Allow NULL? 
94AHDISMRP relevancy for dependent requirementschar10CHAR(N' ')YesAHDIS Allow NULL? 
95BERW4Second Receipt Days' Supplydecimal41DEC((0))YesBERW4
96BADONIndicator: BAdI is Activechar10CHAR(N' ')YesMD_BADI_ON Allow NULL? 
97SGT_STATCSegmentation Statuschar10CHAR(N' ')YesSGT_STATC Allow NULL? 
98HANAONHANA Optimizations Active / Inactivechar10CHAR(N' ')YesPPH_HANA_ON Allow NULL? 
NamePrimaryUniqueTypeColumns
MDKP~0YesYesCLUSTEREDPLSCN, PLWRK, MATNR, DTART, MANDT
MDKP~1NoNoNONCLUSTEREDDISPO, PLWRK, 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