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  | MDKPDB
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.0MDKPDB992Header 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, BERID, PLSCN, PLWRK, 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 MDKPDB
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? 
4BERIDMRP Areanvarchar100CHAR(N' ')NoMDLVBERID Allow NULL? 
5PLSCNPlanning Scenario of Long-Term Planningnvarchar30NUMC(N'000')NoPLSCPLSCN Allow NULL? 
6PLWRKMRP area: Plantnvarchar40CHAR(N' ')Yes*WERKDP Allow NULL? 
7DTNUMNumber of material requirements planning tablenvarchar100NUMC(N'0000000000')YesDTNUM Allow NULL? 
8DSDATMRP datenvarchar80DATS(N'00000000')YesDSDAT Allow NULL? 
9BDBKZSelection indicator for processed MRP listschar10CHAR(N' ')YesBDBKZ Allow NULL? 
10SLKZ1Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
11SLKZ2Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
12SLKZ3Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
13SLKZ4Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
14SLKZ5Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
15SLKZ6Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
16SLKZ7Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
17SLKZ8Selection indicator for exception groupschar10CHAR(N' ')YesSLKZX Allow NULL? 
18VRKZ1Processing indicator 01char10CHAR(N' ')YesVRKZ1 Allow NULL? 
19VRKZ2Processing indicator 02char10CHAR(N' ')YesVRKZ2 Allow NULL? 
20VRKZ3Processing indicator - 03char10CHAR(N' ')YesVRKZ3 Allow NULL? 
21MTARTMaterial Typenvarchar40CHAR(N' ')YesT134MTART Allow NULL? 
22MEINSBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
23DISSTLow-Level Codenvarchar30CHAR(N' ')YesDISST Allow NULL? 
24BESKZProcurement Typechar10CHAR(N' ')YesBESKZ Allow NULL? 
25SOBSLSpecial procurement typenvarchar20CHAR(N' ')YesT460ASOBSL Allow NULL? 
26SOBESSpecial procurement typechar10CHAR(N' ')YesSOBES Allow NULL? 
27WRK02Planning/production plantnvarchar40CHAR(N' ')YesT001WWRK02 Allow NULL? 
28DISMMMRP Typenvarchar20CHAR(N' ')YesT438ADISMM Allow NULL? 
29DISVFMRP procedurechar10CHAR(N' ')YesDISVF Allow NULL? 
30DISPOMRP Controller (Materials Planner)nvarchar30CHAR(N' ')YesT024DDISPO Allow NULL? 
31PLDISPlanning controller (no longer used)nvarchar30CHAR(N' ')YesT024DPLDIS Allow NULL? 
32EKGRPPurchasing Groupnvarchar30CHAR(N' ')YesT024EKGRP Allow NULL? 
33MTWZTMaterial replenishment lead timedecimal30DEC((0))YesMTWZT
34WEBAZGoods Receipt Processing Time in Daysdecimal30DEC((0))YesWEBAZ
35BEAZTProcessing time for purchase order proposaldecimal30DEC((0))YesBEAZT
36FIXTREnd of planning time fence (date)nvarchar80DATS(N'00000000')YesFIXTR Allow NULL? 
37MFHKZPlanning time fence set manually (MFXDT)char10CHAR(N' ')YesMFHKZ Allow NULL? 
38DISLSLot size (materials planning)nvarchar20CHAR(N' ')YesT439ADISLS Allow NULL? 
39LOSVFLot-sizing procedure for short-term periodchar10CHAR(N' ')YesLOSVF Allow NULL? 
40LOSKZLot-size indicator for the short-term periodchar10CHAR(N' ')YesLOSKZ Allow NULL? 
41PERAZNumber of periods for the short-term areadecimal30DEC((0))YesPERAZ
42EISBESafety Stockdecimal133QUAN((0))YesEISBE
43MINBEReorder Pointdecimal133QUAN((0))YesMINBE
44HOEBEMaximum stock leveldecimal133QUAN((0))YesMABST
45BSTMIMinimum Lot Sizedecimal133QUAN((0))YesBSTMI
46BSTMAMaximum Lot Sizedecimal133QUAN((0))YesBSTMA
47BSTFXFixed lot sizedecimal133QUAN((0))YesBSTFE
48BSTRFRounding value for purchase order quantitydecimal133QUAN((0))YesBSTRF
49SUM01Plant stock / only plant segmentdecimal133QUAN((0))YesSUM01W
50SUM02No longer used/do not use!!decimal133QUAN((0))YesNOUSE
51SUM03No longer used/do not use!!decimal133QUAN((0))YesNOUSE
52SUM04No longer used/do not use!!decimal133QUAN((0))YesNOUSE
53SUM05No longer used/do not use!!decimal133QUAN((0))YesNOUSE
54NEGBSNegative stockdecimal133QUAN((0))YesNEGBS
55MSGIDMessage identificationnvarchar200CHAR(N' ')Yes*MSGID Allow NULL? 
56MSGARMessage Typechar10CHAR(N' ')YesMSGTY Allow NULL? 
57MSGNRMessage numbernvarchar30CHAR(N' ')YesT100MSGNR Allow NULL? 
58MSGV1Message variable 01nvarchar500CHAR(N' ')YesMSGV1 Allow NULL? 
59MSGV2Message variable 02nvarchar500CHAR(N' ')YesMSGV2 Allow NULL? 
60MSGV3Message variable 03nvarchar500CHAR(N' ')YesMSGV3 Allow NULL? 
61MSGV4Message variable 04nvarchar500CHAR(N' ')YesMSGV4 Allow NULL? 
62DISGRMRP Groupnvarchar40CHAR(N' ')YesT438MDISGR Allow NULL? 
63PERIVFiscal Year Variantnvarchar20CHAR(N' ')YesT009PERIV Allow NULL? 
64MRPPPPPC planning calendarnvarchar30CHAR(N' ')YesT439GMRPPP Allow NULL? 
65BDARFRequirements quantity from material requirements planningdecimal133QUAN((0))YesBDARF
66LFRHYPlanning cyclenvarchar30CHAR(N' ')YesT439GLFRHY Allow NULL? 
67RDPRFRounding Profilenvarchar40CHAR(N' ')Yes*RDPRF Allow NULL? 
68BERW1Stock Days' Supply Without Receiptsdecimal41DEC((0))YesBERW1
69BERW2First Receipt Days' Supplydecimal41DEC((0))YesBERW2
70KZAUSDiscontinuation indicatorchar10CHAR(N' ')YesKZAUS Allow NULL? 
71AUSDTEffective-Out Datenvarchar80DATS(N'00000000')YesAUSDT Allow NULL? 
72NFMATFollow-Up Materialnvarchar180CHAR(N' ')Yes*NFMAT Allow NULL? 
73AUSZ1Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
74AUSZ2Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
75AUSZ3Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
76AUSZ4Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
77AUSZ5Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
78AUSZ6Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
79AUSZ7Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
80AUSZ8Exception group in the MRP listnvarchar20CHAR(N' ')YesAUSZX Allow NULL? 
81BEADAMRP list processing datenvarchar80DATS(N'00000000')YesBEADA Allow NULL? 
82NAUKZIndicator: new exception in the MRP listchar10CHAR(N' ')YesNAUKZ Allow NULL? 
83SAUFTInd.: Repetitive mfg allowedchar10CHAR(N' ')YesSA_SAUFT Allow NULL? 
84KZPROMOIndicator: Material in promotionchar10CHAR(N' ')YesKZPROMO Allow NULL? 
85SHFLGSafety time indicator (with or without safety time)char10CHAR(N' ')YesSHFLG Allow NULL? 
86SHZETSafety time (in workdays)nvarchar20NUMC(N'00')YesSHZET Allow NULL? 
87FABKZIndicator: Item Relevant to JIT Delivery Scheduleschar10CHAR(N' ')YesFABKZ Allow NULL? 
88MFXDTManual firming datenvarchar80DATS(N'00000000')YesMFXDT Allow NULL? 
89BSKFLFlag whether stock correction factors existchar10CHAR(N' ')YesBSKFL Allow NULL? 
90MAABCABC Indicatorchar10CHAR(N' ')Yes*MAABC Allow NULL? 
91CFLAGAggregated MRP listchar10CHAR(N' ')YesCOMPMRPL Allow NULL? 
92GRRELRelevant for requirements grouping for project stockchar10CHAR(N' ')YesGRREL Allow NULL? 
93RWPRORange of coverage profilenvarchar30CHAR(N' ')Yes*RWPRO Allow NULL? 
94SHPROPeriod Profile for Safety Timenvarchar30CHAR(N' ')Yes*SHPRO Allow NULL? 
95AHDISMRP relevancy for dependent requirementschar10CHAR(N' ')YesAHDIS Allow NULL? 
96BERW4Second Receipt Days' Supplydecimal41DEC((0))YesBERW4
97BADONIndicator: BAdI is Activechar10CHAR(N' ')YesMD_BADI_ON Allow NULL? 
98SGT_STATCSegmentation Statuschar10CHAR(N' ')YesSGT_STATC Allow NULL? 
99HANAONHANA Optimizations Active / Inactivechar10CHAR(N' ')YesPPH_HANA_ON Allow NULL? 
NamePrimaryUniqueTypeColumns
MDKPDB~0YesYesCLUSTEREDPLSCN, BERID, MATNR, DTART, MANDT
MDKPDB~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