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

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
Production Planning and Control :: Production Planning :: Demand Management
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T459K411Control table for customer requirementsDemand Management
SQL:  selectupdate insert create

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

SELECT MANDT, BEDAR, ATPPR, BEDSD, NODIS, VPZUO, KNTTP, APROF, ABGRS, PABKZ, PLNKZ, ZUVKZ, BDTYP, KONFI, KALKU, KALSM_K, KONFV, MNTGA, AUART, VKOMP, DIAGM, AUTPL, VKAPA, KALART, KALVAR, KSUEB, DIRKST, SDUPD, QUOTA, KZAKP, KZBWS, AUCOST, BWST3, MNTKAL, KSCHL_KO, KSCHL_KOF, OCMACT, FKBER, SLIST, MODFG, ICONC FROM T459K
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2BEDARRequirements classnvarchar30CHAR(N' ')NoBEDAR Allow NULL? 
3ATPPRSD availability checkchar10CHAR(N' ')YesATPPR Allow NULL? 
4BEDSDTransfer of requirements / Begin assembly order from SDchar10CHAR(N' ')YesBEDSD Allow NULL? 
5NODISRequirements record not relevant to MRPchar10CHAR(N' ')YesNODIS Allow NULL? 
6VPZUOAllocation Indicatorchar10CHAR(N' ')YesVPZUO Allow NULL? 
7KNTTPAccount Assignment Categorychar10CHAR(N' ')YesT163KKNTTP Allow NULL? 
8APROFSettlement profilenvarchar60CHAR(N' ')YesTKB1AAPROF Allow NULL? 
9ABGRSResults Analysis Keynvarchar60CHAR(N' ')YesTKKAAABGR_SCHL Allow NULL? 
10PABKZRequirements reduction indicatorchar10CHAR(N' ')YesPABKZ Allow NULL? 
11PLNKZPlanning Indicatorchar10CHAR(N' ')YesPLNKZ Allow NULL? 
12ZUVKZConsumption indicatorchar10CHAR(N' ')YesDZUVKZ Allow NULL? 
13BDTYPRequirements categorychar10CHAR(N' ')YesBDTYP Allow NULL? 
14KONFIConfiguration allowed or requiredchar10CHAR(N' ')YesKONFI Allow NULL? 
15KALKUControl of Costingchar10CHAR(N' ')YesKALKU_D Allow NULL? 
16KALSM_KCosting Sheetnvarchar60CHAR(N' ')YesT683AUFKALSM Allow NULL? 
17KONFVConsumption of configurationchar10CHAR(N' ')YesKONFV Allow NULL? 
18MNTGAAssembly typechar10NUMC(N'0')YesMNTGA Allow NULL? 
19AUARTOrder Typenvarchar40CHAR(N' ')YesT003OAUFART Allow NULL? 
20VKOMPAvailability check at component level in assembly orderchar10CHAR(N' ')YesVKOMP Allow NULL? 
21DIAGMAssembly: display production/planned order or componentschar10CHAR(N' ')YesDIAGM Allow NULL? 
22AUTPLAutomatic start of make-to-order in background modechar10CHAR(N' ')YesAUTPL Allow NULL? 
23VKAPADisplay Capacity Availabilitychar10CHAR(N' ')YesVKAPA Allow NULL? 
24KALARTCosting Methodchar10CHAR(N' ')YesCK_KALART Allow NULL? 
25KALVARCosting Variantnvarchar40CHAR(N' ')YesTCK03CK_KLVAR Allow NULL? 
26KSUEBCopy Costing Sheet into Dependent Objectschar10CHAR(N' ')YesKSUEB Allow NULL? 
27DIRKSTDirect cost recipientchar10CHAR(N' ')YesDIRKST Allow NULL? 
28SDUPDNo update of confirmation in assemblychar10CHAR(N' ')YesSDUPD Allow NULL? 
29QUOTAProduct allocation activechar10CHAR(N' ')YesQUOTA Allow NULL? 
30KZAKPIndicator for type of component checkchar10CHAR(N' ')YesKZAKP Allow NULL? 
31KZBWSValuation of Special Stockchar10CHAR(N' ')YesKZBWS Allow NULL? 
32AUCOSTCosting activities indicatorchar10CHAR(N' ')YesAUCOST Allow NULL? 
33BWST3Valuation with Standard Price of Make-to-Stock Inventorychar10CHAR(N' ')YesCK_BWST3 Allow NULL? 
34MNTKALGenerate Sales Order Cost Estimatechar10CHAR(N' ')YesMNTKAL Allow NULL? 
35KSCHL_KOCondition type for copying costs from line itemsnvarchar40CHAR(N' ')YesT685KSCHL_KO Allow NULL? 
36KSCHL_KOFCondition type for fixed cost transfer from line itemsnvarchar40CHAR(N' ')YesT685KSCHL_KOF Allow NULL? 
37OCMACTTrigger order change managementchar10CHAR(N' ')YesCO_FLGOCM Allow NULL? 
38FKBERFunctional Areanvarchar160CHAR(N' ')YesTFKBFKBER Allow NULL? 
39SLISTStrategy sequences for automatic generation of SETCnvarchar60CHAR(N' ')YesTKB10SLASR_SLIST Allow NULL? 
40MODFGChange behavior during automatic generation of SETCchar10NUMC(N'0')YesSR_MODIFLAG Allow NULL? 
41ICONCICON Availability Checkchar10CHAR(N' ')YesICONC Allow NULL? 
NamePrimaryUniqueTypeColumns
T459K~0YesYesCLUSTEREDBEDAR, MANDT