SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

www.saptables.net

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
1BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
2FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
3/ISDFPS/CHVW_E34External Batch Where-Used List
4FMARCPAR4Parallelization of FMARC_BATCH
5CEKRS5Movement type parameters for automatic ERS
6/1RA/0SD010MI170Items for Class SD01 - Raw Data
7/ATL/AANLCP79Periodic Asset-value fields, like anlc, for all areas
8AUDLORIPR7KPro: Logical Information Object Attribute Values
9BSEG345Accounting Document Segment
10/OPT/Z1344Reporting table: Text table for exception definitions

B1 9.2: Top 10 requests

TableColumnsDescription
1OINV386A/R Invoice
2OITM299Items
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OACT114G/L Accounts

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2OINV268A/R Invoice
3OVPM154Outgoing Payments
4ORCT154Incoming Payment
5OIVL77Whse Journal
6OPCH268A/P Invoice
7OOCR9Loading Factors
8JDT1110Journal Entry - Rows
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
PHPRef.com - the webs number one PHP Function reference tool
Logistics - General :: Logistics Information System LIS :: Data Collection
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0S039921Statistics: Inventory ControllingData Collection
SQL:  selectupdate insert create

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

SELECT MANDT, SSOUR, VRSIO, SPMON, SPTAG, SPWOC, SPBUP, WERKS, MATNR, LGORT, DISPO, DISMM, MTART, MATKL, GSBER, SPART, PERIV, VWDAT, BASME, HWAER, MZUBB, WZUBB, AZUBB, MZUKB, AZUKB, MAGBB, WAGBB, AAGBB, MAGKB, AAGKB, AMBWG, MGVBR, WGVBR, AGVBR, MUVBR, WUVBR, AUVBR, ASTOR, BBNULL, KBNULL, GBNULL, MBWBEST, WBWBEST, MKOBEST, DZUBB, DZWBB, DAGBB, DAWBB, DZUKB, DAGKB, DGVBR, GSBEST, RWGSBEST, RWKOBEST, RWBEWBEST, UHGSBEST, UHBWBEST, UHKOBEST, DBWBEST, DKOBEST, DGSBEST, DWBWBEST, DRWBWBEST, DRWKOBEST, DRWGSBEST, DUHBWBEST, DUHKOBEST, DUHGSBEST, DWGVBR, DUVBR, DWUVBR, UHWBWBEST, UHWGSBEST, DUHWGSBEST, DUHWBWBEST, JUHWGSBEST, JUHWBWBEST, JUHGSBEST, JUHKOBEST, JUHBWBEST, RWWGSBEST, RWWBWBEST, DRWWGSBEST, DRWWBWBEST, LETZTZUG, LETZTABG, LETZTVER, LETZTBEW, EISBE, BESZUG, WBESZUG, BKLAS FROM S039
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SSOURStatistic(s) originnvarchar40CHAR(N' ')NoSSOUR Allow NULL? 
3VRSIOVersion number in the information structurenvarchar30CHAR(N' ')No*VRSIO Allow NULL? 
4SPMONPeriod to analyze - monthnvarchar60NUMC(N'000000')NoSPMON Allow NULL? 
5SPTAGPeriod to analyze - current datenvarchar80DATS(N'00000000')NoSPTAG Allow NULL? 
6SPWOCPeriod to analyze - weeknvarchar60NUMC(N'000000')NoSPWOC Allow NULL? 
7SPBUPPeriod to analyze - posting periodnvarchar60NUMC(N'000000')NoSPBUP Allow NULL? 
8WERKSPlantnvarchar40CHAR(N' ')NoT001WWERKS_D Allow NULL? 
9MATNRMaterial Numbernvarchar180CHAR(N' ')NoMARAMATNR Allow NULL? 
10LGORTStorage Locationnvarchar40CHAR(N' ')NoT001LLGORT_D Allow NULL? 
11DISPOMRP Controller (Materials Planner)nvarchar30CHAR(N' ')NoT024DDISPO Allow NULL? 
12DISMMMRP Typenvarchar20CHAR(N' ')NoT438ADISMM Allow NULL? 
13MTARTMaterial Typenvarchar40CHAR(N' ')NoT134MTART Allow NULL? 
14MATKLMaterial Groupnvarchar90CHAR(N' ')NoT023MATKL Allow NULL? 
15GSBERBusiness Areanvarchar40CHAR(N' ')NoTGSBGSBER Allow NULL? 
16SPARTDivisionnvarchar20CHAR(N' ')NoTSPASPART Allow NULL? 
17PERIVFiscal Year Variantnvarchar20CHAR(N' ')YesT009PERIV Allow NULL? 
18VWDATPointer to administrative datanvarchar100NUMC(N'0000000000')YesVWDAT Allow NULL? 
19BASMEBase Unit of Measurenvarchar30UNIT(N' ')YesT006MEINS Allow NULL? 
20HWAERCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
21MZUBBValuated stock receipts quantitydecimal153QUAN((0))YesMZUBB
22WZUBBValuated stock receipts valuedecimal152CURR((0))YesWZUBB
23AZUBBNumber of times that valuated stock has been receiveddecimal90DEC((0))YesAZUBB
24MZUKBConsignment stock receipts quantitydecimal153QUAN((0))YesMZUKB
25AZUKBNumber of times that consignment stock has been receiveddecimal90DEC((0))YesAZUKB
26MAGBBQuantity of valuated stock issuesdecimal153QUAN((0))YesMAGBB
27WAGBBValue of valuated stock that has been issueddecimal152CURR((0))YesWAGBB
28AAGBBNumber of times valuated stock has been issueddecimal90DEC((0))YesAAGBB
29MAGKBQuantity of consignment stock that has been issueddecimal153QUAN((0))YesMAGKB
30AAGKBNumber of times consignment stock has been issueddecimal90DEC((0))YesAAGKB
31AMBWGNumber of material movementsdecimal90DEC((0))YesAMBWG
32MGVBRTotal usage quantitydecimal153QUAN((0))YesGVBRM
33WGVBRTotal usage valuedecimal152CURR((0))YesWGVBR
34AGVBRNumber of times that total usage has been updateddecimal90DEC((0))YesAGVBR
35MUVBRUnplanned usage quantitydecimal153QUAN((0))YesUVBRM
36WUVBRUnplanned usage valuedecimal152CURR((0))YesWUVBR
37AUVBRNumber of times an unplanned usage has been recordeddecimal90DEC((0))YesAUVBR
38ASTORNumber of cancelation documents to datedecimal90DEC((0))YesASTOR
39BBNULLNumber of times that valuated stock was zerodecimal90DEC((0))YesBBNULL
40KBNULLNumber of times that consignment stock was zerodecimal90DEC((0))YesKBNULL
41GBNULLNumber of times that total stock was zerodecimal90DEC((0))YesGBNULL
42MBWBESTQuantity of valuated stockdecimal153QUAN((0))YesMBWBEST
43WBWBESTValue of valuated stockdecimal152CURR((0))YesWBWBEST
44MKOBESTQuantity of consignment stockdecimal153QUAN((0))YesMKOBEST
45DZUBBAverage valuated stock receipts quantitydecimal153QUAN((0))YesDZUBB
46DZWBBAverage valuated stock receipts valuedecimal152CURR((0))YesDZWBB
47DAGBBAverage quantity of valuated stock issuesdecimal153QUAN((0))YesDAGBB
48DAWBBAverage valuated stock issues valuedecimal152CURR((0))YesDAWBB
49DZUKBAverage consignment stock receipts quantitydecimal153QUAN((0))YesDZUKB
50DAGKBAverage quantity of consignment stock that has been issueddecimal153QUAN((0))YesDAGKB
51DGVBRAverage consumptiondecimal153QUAN((0))YesDGVBR
52GSBESTTotal stockdecimal153QUAN((0))YesGSBEST
53RWGSBESTRange of coverage of total stockdecimal70DEC((0))YesRWGSBEST
54RWKOBESTRange of coverage of consignment stockdecimal70DEC((0))YesRWKOBEST
55RWBEWBESTRange of coverage of valuated stockdecimal70DEC((0))YesRWBEWBEST
56UHGSBESTTurnover of total stockdecimal70DEC((0))YesUHGESBEST
57UHBWBESTTurnover of valuated stockdecimal70DEC((0))YesUHBWBEST
58UHKOBESTTurnover of consignment stockdecimal70DEC((0))YesUHKOBEST
59DBWBESTAverage quantity of valuated stockdecimal153QUAN((0))YesDBWBEST
60DKOBESTAverage quantity of consignment stockdecimal153QUAN((0))YesDKOBEST
61DGSBESTAverage quantity of total stockdecimal153QUAN((0))YesDGSBEST
62DWBWBESTAverage valuated stock valuedecimal152CURR((0))YesDWBWBEST
63DRWBWBESTAverage range of coverage of valuated stockdecimal70DEC((0))YesDRWBWBEST
64DRWKOBESTAverage range of coverage of consignment stockdecimal70DEC((0))YesDRWKOBEST
65DRWGSBESTAverage range of coverage of total stockdecimal70DEC((0))YesDRWGSBEST
66DUHBWBESTAverage inventory turnover of valuated stockdecimal70DEC((0))YesDUHBWBEST
67DUHKOBESTAverage turnover of consignment stockdecimal70DEC((0))YesDUHKOBEST
68DUHGSBESTAverage turnover of total stockdecimal70DEC((0))YesDUHGSBEST
69DWGVBRValue of average total usagedecimal152CURR((0))YesDWGVBR
70DUVBRAverage unplanned usage quantitydecimal153QUAN((0))YesDUVBR
71DWUVBRAverage unplanned usage valuedecimal152CURR((0))YesDWUVBR
72UHWBWBESTInventory turnover (value-based) of valuated stockdecimal70DEC((0))YesUHWBWBEST
73UHWGSBESTInventory turnover (value-based) of total stockdecimal70DEC((0))YesUHWGSBEST
74DUHWGSBESTAverage turnover (value-based) of total stockdecimal70DEC((0))YesDUHWGSBEST
75DUHWBWBESTAverage turnover (value-based) of valuated stockdecimal70DEC((0))YesDUHWBWBEST
76JUHWGSBESTAnnual inventory turnover (value-based) of total stockdecimal70DEC((0))YesJUHWGSBEST
77JUHWBWBESTAnnual inventory turnover (value-based) of valuated stockdecimal70DEC((0))YesJUHWBWBEST
78JUHGSBESTAnnual inventory turnover (quantity-based) of total stockdecimal70DEC((0))YesJUHGSBEST
79JUHKOBESTAnnual turnover (quantity-based) of consignment stockdecimal70DEC((0))YesJUHKOBEST
80JUHBWBESTAnnual inventory turnover of valuated stockdecimal70DEC((0))YesJUHBWBEST
81RWWGSBESTRange of coverage (value-based) of total stockdecimal70DEC((0))YesRWWGSBEST
82RWWBWBESTRange of coverage (value-based) of valuated stockdecimal70DEC((0))YesRWWBWBEST
83DRWWGSBESTAverage range of coverage (value-based) of total stockdecimal70DEC((0))YesDRWWGSBEST
84DRWWBWBESTAverage range of coverage (value-based) of valuated stockdecimal70DEC((0))YesDRWWBWBEST
85LETZTZUGDate: Last Receiptnvarchar80DATS(N'00000000')YesLETZTZUG Allow NULL? 
86LETZTABGDate: last (i.e. most recent) goods issuenvarchar80DATS(N'00000000')YesLETZTABG Allow NULL? 
87LETZTVERDate: last (i.e. most recent) consumptionnvarchar80DATS(N'00000000')YesLETZTVER Allow NULL? 
88LETZTBEWDate: last (i.e. most recent) goods movementnvarchar80DATS(N'00000000')YesLETZTBEW Allow NULL? 
89EISBESafety stockdecimal153QUAN((0))YesMC_EISBE
90BESZUGStock level at goods receiptdecimal153QUAN((0))YesBESZUG
91WBESZUGValue of stock at goods receiptdecimal152CURR((0))YesWBESZUG
92BKLASValuation Classnvarchar40CHAR(N' ')Yes*BKLAS Allow NULL? 
NamePrimaryUniqueTypeColumns
S039~0YesYesCLUSTEREDSPART, GSBER, MATKL, MTART, DISMM, DISPO, LGORT, MATNR, WERKS, SPBUP, SPWOC, SPTAG, SPMON, VRSIO, SSOUR, MANDT