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  | WAKP
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
Logistics - General :: Logistics Basic Data :: Promotion
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0WAKP832Promotion Item DataPromotion
SQL:  selectupdate insert create

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

SELECT MANDT, AKTNR, ARTNR, MEBME, AKPOS, SATNR, MATKL, AKTHE, BZQFI, AKBSP, NBPOS, RESKZ, BEKTY, SPDAT, SPGRU, EKORG, EKGRP, VKORG, VTWEG, AKLIZ, PUMVP, PUMEP, PUMEN, PABBM, PABLM, AUFME, PLVKP, VPEIN, PLEKP, PLEKN, EPEIN, WAEEK, WAELA, MEINS, MELOG, MEBPR, MEAUF, RGART, MIAMG, NDISP, FBDAT, SBDAT, FLDAT, SLDAT, APSTP, BEDAT, VREGE, ABELN, ABELP, ETIAG, EKKPS, VKKPS, EKKON, VKKON, ACTIV, ERNAM, ERDAT, AENAM, AEDAT, ECKPKZ, VZKON, VZKPS, EPRGR, NVKP, VK_AKTIV_AB, VK_AKTIV_BI, BATNR, EKERV, REB_VALUE, REB_PERC, REB_STATUS, NO_KALK, ASTRA, OFFER_TYPE, OFFER_TYPE_DSC, OFFER_ID, OFFER_ID_DSC, OFFER_PRDGRP, OFFER_PRDGRP_DSC, ITEM_CREAT_INDIC, PABBM_OFFER_PRC, PABBM_OFFER_DSC, ASTRA_VAR FROM WAKP
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2AKTNRPromotionnvarchar100CHAR(N' ')NoWAKHWAKTION Allow NULL? 
3ARTNRMaterial Numbernvarchar180CHAR(N' ')NoMARAMATNR Allow NULL? 
4MEBMESales unitnvarchar30UNIT(N' ')NoT006W_MEBME Allow NULL? 
5AKPOSPromotion Item Numbernvarchar60NUMC(N'000000')NoW_AKPOS Allow NULL? 
6SATNRCross-Plant Configurable Materialnvarchar180CHAR(N' ')NoMARASATNR Allow NULL? 
7MATKLMaterial Groupnvarchar90CHAR(N' ')YesT023MATKL Allow NULL? 
8AKTHEPromotion themenvarchar40CHAR(N' ')NoTWATW_AKTHE Allow NULL? 
9BZQFISupply Source Determination Statuschar10CHAR(N' ')YesW_BZQFI Allow NULL? 
10AKBSPItem status, listingchar10CHAR(N' ')NoW_AKBSP Allow NULL? 
11NBPOSNo. of modules with this material as an itemsmallint50INT2((0))NoW_NBPOS
12RESKZCheck Against Listing Rules/Listing Conditionschar10CHAR(N' ')YesW_LCHECK Allow NULL? 
13BEKTYPromotion announcement categorynvarchar40CHAR(N' ')YesT626W_BEKTY Allow NULL? 
14SPDATDate on which promotion material is blocked for promotionnvarchar80DATS(N'00000000')NoW_SPDAT Allow NULL? 
15SPGRUReason for promotion blockchar10CHAR(N' ')NoW_SPGRU Allow NULL? 
16EKORGPurchasing Organizationnvarchar40CHAR(N' ')NoT024EEKORG Allow NULL? 
17EKGRPPurchasing Groupnvarchar30CHAR(N' ')NoT024EKGRP Allow NULL? 
18VKORGSales Organizationnvarchar40CHAR(N' ')NoTVKOVKORG Allow NULL? 
19VTWEGDistribution Channelnvarchar20CHAR(N' ')NoTVKOVVTWEG Allow NULL? 
20AKLIZPlanned delivery time for promotional goodsdecimal30DEC((0))NoW_PLIFZ
21PUMVPPromotion Plan Mat. Sales Vol. at Promo. Sales Pricedecimal132CURR((0))NoW_PUMVP
22PUMEPPromotion plan: mat. sales at PP in sales currencydecimal132CURR((0))NoW_PUMEP
23PUMENPromotion plan: sales volume at purchase price (net/net)decimal132CURR((0))YesW_PUMEN
24PABBMPlanned Sales Qty. of Promotion Material in Sales Unitsdecimal133QUAN((0))NoW_PABBM
25PABLMPlanned Sales Qty of Promotion Material in Logistics Unitsdecimal133QUAN((0))NoW_PABLM
26AUFMEPromotion plan: Material allocation table quantitydecimal133QUAN((0))NoW_AUFME
27PLVKPSales price for promotion itemdecimal112CURR((0))NoW_PLVKP
28VPEINSales price unitdecimal50DEC((0))NoVPEIN
29PLEKPPurchase price for promotion itemdecimal112CURR((0))NoW_PLEKP
30PLEKNBasic purchase price: net/net - promotion itemdecimal112CURR((0))YesW_PLEKN
31EPEINPrice Unitdecimal50DEC((0))NoEPEIN
32WAEEKPurchase price currencynvarchar50CUKY(N' ')NoTCURCW_WAEEK Allow NULL? 
33WAELACurrency current promotion - planningnvarchar50CUKY(N' ')NoTCURCW_WAELA Allow NULL? 
34MEINSBase unit of measurenvarchar30UNIT(N' ')YesT006W_MEINS Allow NULL? 
35MELOGLogistics unitnvarchar30UNIT(N' ')NoT006W_MELOG Allow NULL? 
36MEBPROrder Price Unit (Purchasing)nvarchar30UNIT(N' ')NoT006BBPRM Allow NULL? 
37MEAUFAllocation table unitnvarchar30UNIT(N' ')NoT006W_MEAUF Allow NULL? 
38RGARTReturn type for promotional materialchar10CHAR(N' ')NoW_RGART Allow NULL? 
39MIAMGMinimum order qty for promotional materialdecimal133QUAN((0))NoW_MIAMG
40NDISPReplenishment indicatornvarchar20CHAR(N' ')NoW_NDISP Allow NULL? 
41FBDATEarliest Order Datenvarchar80DATS(N'00000000')NoW_FADAT Allow NULL? 
42SBDATLatest Order Datenvarchar80DATS(N'00000000')NoW_SADAT Allow NULL? 
43FLDATEarliest delivery datenvarchar80DATS(N'00000000')NoW_FLDAT Allow NULL? 
44SLDATLatest delivery datenvarchar80DATS(N'00000000')NoW_SLDAT Allow NULL? 
45APSTPItem category of allocation tablenvarchar40CHAR(N' ')NoT621APSTP Allow NULL? 
46BEDATOrder date with vendornvarchar80DATS(N'00000000')NoW_BEDAT Allow NULL? 
47VREGERetail Promotion: Allocation Rule Numbernvarchar100CHAR(N' ')NoSVKOVREGE Allow NULL? 
48ABELNAllocation Table Numbernvarchar100CHAR(N' ')NoAUKOABELN Allow NULL? 
49ABELPItem number of allocation tablenvarchar50NUMC(N'00000')YesAUPOABELP Allow NULL? 
50ETIAGIS-R Labeling: material grouping (deactivated in 4.0)nvarchar180CHAR(N' ')NoTWEAW_ETIAG Allow NULL? 
51EKKPSMaintenance status of purchase price conditionschar10CHAR(N' ')NoW_EKKPS Allow NULL? 
52VKKPSMaintenance status of sales price conditionschar10CHAR(N' ')NoW_VKKPS Allow NULL? 
53EKKONCreate purchase price condition recordschar10CHAR(N' ')YesW_EKKON Allow NULL? 
54VKKONCreate sales price condition recordschar10CHAR(N' ')YesW_VKKON Allow NULL? 
55ACTIVNo. of successful price activationstinyint30INT1((0))YesW_ACTIV
56ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')NoERNAM Allow NULL? 
57ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')NoERDAT Allow NULL? 
58AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')NoAENAM Allow NULL? 
59AEDATChanged Onnvarchar80DATS(N'00000000')NoAEDAT Allow NULL? 
60ECKPKZIndicates whether price point tables should override pricechar10CHAR(N' ')YesF_VKPKZ Allow NULL? 
61VZKONCreate DC condition recordschar10CHAR(N' ')YesW_VZKON Allow NULL? 
62VZKPSMaintenance status of DC conditionschar10CHAR(N' ')YesW_VZKPS Allow NULL? 
63EPRGRPrice Point Group, Promotion Itemnvarchar60CHAR(N' ')Yes*W_EPRGR Allow NULL? 
64NVKPStandard sales pricedecimal112CURR((0))YesW_NVKP
65VK_AKTIV_ABSales prices active fromnvarchar80DATS(N'00000000')YesW_VK_AKTIV_AB Allow NULL? 
66VK_AKTIV_BISales price active tonvarchar80DATS(N'00000000')YesW_VK_AKTIV_BI Allow NULL? 
67BATNRAllocation material numbernvarchar180CHAR(N' ')YesMARABSTARTNR Allow NULL? 
68EKERVPromotion: Purchase price determination sequencenvarchar20CHAR(N' ')YesTWEVW_EKERV Allow NULL? 
69REB_VALUEValue of Absolute Discountdecimal112CURR((0))YesREB_VALUE
70REB_PERCPercentage Discountdecimal52DEC((0))YesREB_PERC
71REB_STATUSDiscount Statuschar10CHAR(N' ')YesREB_STATUS Allow NULL? 
72NO_KALKPrice Activation w/o Price Calculationchar10CHAR(N' ')YesNO_KALK Allow NULL? 
73ASTRARetail Promotion: Allocation Strategynvarchar40CHAR(N' ')YesT627W_ASTRA Allow NULL? 
74OFFER_TYPEOffer Type Pricenvarchar20CHAR(N' ')YesRDM_OFFER_TYPE_PRICE Allow NULL? 
75OFFER_TYPE_DSCOffer Type Discountnvarchar20CHAR(N' ')YesRDM_OFFER_TYPE_DISCOUNT Allow NULL? 
76OFFER_IDOffer ID for Pricenvarchar360CHAR(N' ')YesWPM_OFFERID_PRICE Allow NULL? 
77OFFER_ID_DSCOffer ID for Discountnvarchar360CHAR(N' ')YesWPM_OFFERID_DISCOUNT Allow NULL? 
78OFFER_PRDGRPProduct Group in Offer (Price)nvarchar30NUMC(N'000')YesWPM_OFFER_PRODUCT_GROUP_PRICE Allow NULL? 
79OFFER_PRDGRP_DSCProduct Group in Offer (Discount)nvarchar30NUMC(N'000')YesWPM_OFFER_PRODUCT_GROUP_DSCNT Allow NULL? 
80ITEM_CREAT_INDICPromotion Item Indicator for Transferred Materialschar10CHAR(N' ')YesWPM_PROMO_ITEM Allow NULL? 
81PABBM_OFFER_PRCPlanned sales qty in sales units for material in price offerdecimal133QUAN((0))YesW_PABBM_OFFER_PRC
82PABBM_OFFER_DSCPlanned sales qty in sales units of material in discnt offerdecimal133QUAN((0))YesW_PABBM_OFFER_DSC
83ASTRA_VARAllocation Strategy Variantnvarchar140CHAR(N' ')Yes*ASTRA_VAR Allow NULL? 
NamePrimaryUniqueTypeColumns
WAKP~0YesYesCLUSTEREDMANDT, AKTNR, ARTNR, MEBME
WAKP~IN1NoNoNONCLUSTEREDMANDT, ARTNR, MEBME

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