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
Sales and Distribution :: Sales
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VBAK1442Sales Document: Header DataSales
SQL:  selectupdate insert create

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

SELECT MANDT, VBELN, ERDAT, ERZET, ERNAM, ANGDT, BNDDT, AUDAT, VBTYP, TRVOG, AUART, AUGRU, GWLDT, SUBMI, LIFSK, FAKSK, NETWR, WAERK, VKORG, VTWEG, SPART, VKGRP, VKBUR, GSBER, GSKST, GUEBG, GUEEN, KNUMV, VDATU, VPRGR, AUTLF, VBKLA, VBKLT, KALSM, VSBED, FKARA, AWAHR, KTEXT, BSTNK, BSARK, BSTDK, BSTZD, IHREZ, BNAME, TELF1, MAHZA, MAHDT, KUNNR, KOSTL, STAFO, STWAE, AEDAT, KVGR1, KVGR2, KVGR3, KVGR4, KVGR5, KNUMA, KOKRS, PS_PSP_PNR, KURST, KKBER, KNKLI, GRUPP, SBGRP, CTLPC, CMWAE, CMFRE, CMNUP, CMNGV, AMTBL, HITYP_PR, ABRVW, ABDIS, VGBEL, OBJNR, BUKRS_VF, TAXK1, TAXK2, TAXK3, TAXK4, TAXK5, TAXK6, TAXK7, TAXK8, TAXK9, XBLNR, ZUONR, VGTYP, KALSM_CH, AGRZR, AUFNR, QMNUM, VBELN_GRP, SCHEME_GRP, ABRUF_PART, ABHOD, ABHOV, ABHOB, RPLNR, VZEIT, STCEG_L, LANDTX, XEGDR, ENQUEUE_GRP, DAT_FZAU, FMBDAT, VSNMR_V, HANDLE, PROLI, CONT_DG, CRM_GUID, UPD_TMSTMP, MSR_ID, TM_CTRL_KEY, HANDOVERLOC, /XLSO/SO_VALD_FM, /XLSO/SO_VALD_TO, /XLSO/PAYMENT_OP, /XLSO/TRANS_CTXT, /XLSO/CATALOG_ID, /XLSO/VARIANT_ID, PSM_BUDAT, SWENR, SMENR, PHASE, MTLAUR, STAGE, HB_CONT_REASON, HB_EXPDATE, HB_RESDATE, MILL_APPL_ID, TAS, BETC, MOD_ALLOW, CANCEL_ALLOW, PAY_METHOD, BPN, REP_FREQ, LOGSYSB, KALCD, MULTI, SPPAYM, WTYSC_CLM_HDR FROM VBAK
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VBELNSales Documentnvarchar100CHAR(N' ')NoVBUKVBELN_VA Allow NULL? 
3ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
4ERZETEntry timenvarchar60TIMS(N'000000')YesERZET Allow NULL? 
5ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
6ANGDTQuotation/Inquiry is valid fromnvarchar80DATS(N'00000000')YesANGDT_V Allow NULL? 
7BNDDTDate until which bid/quotation is binding (valid-to date)nvarchar80DATS(N'00000000')YesBNDDT Allow NULL? 
8AUDATDocument Date (Date Received/Sent)nvarchar80DATS(N'00000000')YesAUDAT Allow NULL? 
9VBTYPSD document categorychar10CHAR(N' ')YesVBTYP Allow NULL? 
10TRVOGTransaction groupchar10CHAR(N' ')YesTRVOG Allow NULL? 
11AUARTSales Document Typenvarchar40CHAR(N' ')YesTVAKAUART Allow NULL? 
12AUGRUOrder reason (reason for the business transaction)nvarchar30CHAR(N' ')YesTVAUAUGRU Allow NULL? 
13GWLDTWarranty Datenvarchar80DATS(N'00000000')YesGWLDT Allow NULL? 
14SUBMICollective number (SD)nvarchar100CHAR(N' ')YesSUBMI_SD Allow NULL? 
15LIFSKDelivery block (document header)nvarchar20CHAR(N' ')YesTVLSLIFSK Allow NULL? 
16FAKSKBilling block in SD documentnvarchar20CHAR(N' ')YesTVFSFAKSK Allow NULL? 
17NETWRNet Value of the Sales Order in Document Currencydecimal152CURR((0))YesNETWR_AK
18WAERKSD Document Currencynvarchar50CUKY(N' ')YesTCURCWAERK Allow NULL? 
19VKORGSales Organizationnvarchar40CHAR(N' ')YesTVKOVKORG Allow NULL? 
20VTWEGDistribution Channelnvarchar20CHAR(N' ')YesTVKOVVTWEG Allow NULL? 
21SPARTDivisionnvarchar20CHAR(N' ')YesTVTASPART Allow NULL? 
22VKGRPSales Groupnvarchar30CHAR(N' ')YesTVBVKVKGRP Allow NULL? 
23VKBURSales Officenvarchar40CHAR(N' ')YesTVKBZVKBUR Allow NULL? 
24GSBERBusiness Areanvarchar40CHAR(N' ')YesTGSBGSBER Allow NULL? 
25GSKSTBusiness area from cost centernvarchar40CHAR(N' ')YesTGSBGSKST Allow NULL? 
26GUEBGValid-from date (outline agreements, product proposals)nvarchar80DATS(N'00000000')YesGUEBG Allow NULL? 
27GUEENValid-to date (outline agreements, product proposals)nvarchar80DATS(N'00000000')YesGUEEN Allow NULL? 
28KNUMVNumber of the document conditionnvarchar100CHAR(N' ')YesKNUMV Allow NULL? 
29VDATURequested delivery datenvarchar80DATS(N'00000000')YesEDATU_VBAK Allow NULL? 
30VPRGRProposed date typechar10CHAR(N' ')YesPRGRS_VBAK Allow NULL? 
31AUTLFComplete delivery defined for each sales order?char10CHAR(N' ')YesAUTLF Allow NULL? 
32VBKLAOriginal system with release and transaction controlnvarchar90CHAR(N' ')YesVBKLA Allow NULL? 
33VBKLTSD document indicatorchar10CHAR(N' ')YesVBKLT Allow NULL? 
34KALSMSales and Distribution: Pricing Procedure in Pricingnvarchar60CHAR(N' ')YesT683KALSMASD Allow NULL? 
35VSBEDShipping Conditionsnvarchar20CHAR(N' ')YesTVSBVSBED Allow NULL? 
36FKARAProposed billing type for an order-related billing documentnvarchar40CHAR(N' ')YesTVFKFKARA Allow NULL? 
37AWAHRSales probabilitynvarchar30NUMC(N'000')YesAWAHR_AK Allow NULL? 
38KTEXTSearch term for product proposalnvarchar400CHAR(N' ')YesKTEXT_V Allow NULL? 
39BSTNKCustomer purchase order numbernvarchar200CHAR(N' ')YesBSTNK Allow NULL? 
40BSARKCustomer purchase order typenvarchar40CHAR(N' ')YesT176BSARK Allow NULL? 
41BSTDKCustomer purchase order datenvarchar80DATS(N'00000000')YesBSTDK Allow NULL? 
42BSTZDPurchase order number supplementnvarchar40CHAR(N' ')YesBSTZD Allow NULL? 
43IHREZYour Referencenvarchar120CHAR(N' ')YesIHREZ Allow NULL? 
44BNAMEName of orderernvarchar350CHAR(N' ')YesBNAME_V Allow NULL? 
45TELF1Telephone Numbernvarchar160CHAR(N' ')YesTELF1_VP Allow NULL? 
46MAHZANumber of contacts from the customerdecimal30DEC((0))YesMAHZA
47MAHDTLast customer contact datenvarchar80DATS(N'00000000')YesMAHDT Allow NULL? 
48KUNNRSold-to partynvarchar100CHAR(N' ')YesKNA1KUNAG Allow NULL? 
49KOSTLCost Centernvarchar100CHAR(N' ')Yes*KOSTL Allow NULL? 
50STAFOUpdate group for statistics updatenvarchar60CHAR(N' ')Yes*STAFO Allow NULL? 
51STWAEStatistics currencynvarchar50CUKY(N' ')YesTCURCSTWAE Allow NULL? 
52AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
53KVGR1Customer group 1nvarchar30CHAR(N' ')YesTVV1KVGR1 Allow NULL? 
54KVGR2Customer group 2nvarchar30CHAR(N' ')YesTVV2KVGR2 Allow NULL? 
55KVGR3Customer group 3nvarchar30CHAR(N' ')YesTVV3KVGR3 Allow NULL? 
56KVGR4Customer group 4nvarchar30CHAR(N' ')YesTVV4KVGR4 Allow NULL? 
57KVGR5Customer group 5nvarchar30CHAR(N' ')YesTVV5KVGR5 Allow NULL? 
58KNUMAAgreement (various conditions grouped together)nvarchar100CHAR(N' ')YesKONAKNUMA Allow NULL? 
59KOKRSControlling Areanvarchar40CHAR(N' ')YesTKA01KOKRS Allow NULL? 
60PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')YesPRPSPS_PSP_PNR Allow NULL? 
61KURSTExchange Rate Typenvarchar40CHAR(N' ')YesTCURVKURST Allow NULL? 
62KKBERCredit control areanvarchar40CHAR(N' ')YesT014KKBER Allow NULL? 
63KNKLICustomer's account number with credit limit referencenvarchar100CHAR(N' ')YesKNA1KNKLI Allow NULL? 
64GRUPPCustomer Credit Groupnvarchar40CHAR(N' ')Yes*GRUPP_CM Allow NULL? 
65SBGRPCredit representative group for credit managementnvarchar30CHAR(N' ')YesT024BSBGRP_CM Allow NULL? 
66CTLPCCredit management: Risk categorynvarchar30CHAR(N' ')YesT691ACTLPC_CM Allow NULL? 
67CMWAECurrency key of credit control areanvarchar50CUKY(N' ')YesTCURCWAERS_CM Allow NULL? 
68CMFRERelease date of the document determined by credit managementnvarchar80DATS(N'00000000')YesCMFRE Allow NULL? 
69CMNUPDate of next credit check of documentnvarchar80DATS(N'00000000')YesCMNUP Allow NULL? 
70CMNGVNext datenvarchar80DATS(N'00000000')YesCMNGV Allow NULL? 
71AMTBLReleased credit value of the documentdecimal152CURR((0))YesAMTBL_CM
72HITYP_PRHierarchy type for pricingchar10CHAR(N' ')YesTHITHITYP_PR Allow NULL? 
73ABRVWUsage Indicatornvarchar30CHAR(N' ')YesTVLVABRVW Allow NULL? 
74ABDISMRP for delivery schedule typeschar10CHAR(N' ')YesABDIS Allow NULL? 
75VGBELDocument number of the reference documentnvarchar100CHAR(N' ')YesVBUKVGBEL Allow NULL? 
76OBJNRObject number at header levelnvarchar220CHAR(N' ')YesONR00OBJKO Allow NULL? 
77BUKRS_VFCompany code to be billednvarchar40CHAR(N' ')YesT001BUKRS_VF Allow NULL? 
78TAXK1Alternative tax classificationchar10CHAR(N' ')Yes*TAXK1_AK Allow NULL? 
79TAXK2Tax classification 2 for customerchar10CHAR(N' ')Yes*TAXK2 Allow NULL? 
80TAXK3Tax classification 3 for customerchar10CHAR(N' ')Yes*TAXK3 Allow NULL? 
81TAXK4Tax Classification 4 Customerchar10CHAR(N' ')Yes*TAXK4 Allow NULL? 
82TAXK5Tax classification 5 for customerchar10CHAR(N' ')Yes*TAXK5 Allow NULL? 
83TAXK6Tax classification 6 for customerchar10CHAR(N' ')Yes*TAXK6 Allow NULL? 
84TAXK7Tax classification 7 for customerchar10CHAR(N' ')Yes*TAXK7 Allow NULL? 
85TAXK8Tax classification 8 for customerchar10CHAR(N' ')Yes*TAXK8 Allow NULL? 
86TAXK9Tax classification 9 for customerchar10CHAR(N' ')Yes*TAXK9 Allow NULL? 
87XBLNRReference Document Numbernvarchar160CHAR(N' ')YesXBLNR_V1 Allow NULL? 
88ZUONRAssignment numbernvarchar180CHAR(N' ')YesORDNR_V Allow NULL? 
89VGTYPDocument category of preceding SD documentchar10CHAR(N' ')YesVBTYP_V Allow NULL? 
90KALSM_CHSearch procedure for batch determinationnvarchar60CHAR(N' ')YesT683KALSMA_CH Allow NULL? 
91AGRZRAccrual period for order-related billing docs.to be accruednvarchar20NUMC(N'00')YesAGRZR Allow NULL? 
92AUFNROrder Numbernvarchar120CHAR(N' ')YesAUFKAUFNR Allow NULL? 
93QMNUMNotification Nonvarchar120CHAR(N' ')YesQMELQMNUM Allow NULL? 
94VBELN_GRPMster contract numbernvarchar100CHAR(N' ')Yes*VBELN_GRP Allow NULL? 
95SCHEME_GRPReferencing requirement: Procedurenvarchar40CHAR(N' ')YesTVGRPSSCHEME_GRP Allow NULL? 
96ABRUF_PARTCheck partner authorizationschar10CHAR(N' ')YesABRUF_PART Allow NULL? 
97ABHODPick up datenvarchar80DATS(N'00000000')YesABHOD Allow NULL? 
98ABHOVPick up timenvarchar60TIMS(N'000000')YesABHOZ Allow NULL? 
99ABHOBPick up timenvarchar60TIMS(N'000000')YesABHOZ Allow NULL? 
100RPLNRNumber of payment card plan typenvarchar100CHAR(N' ')YesFPLARPLNR Allow NULL? 
101VZEITProposed schedule line time (local with ref. to sales org.)nvarchar60TIMS(N'000000')YesEZEIT_VBAK Allow NULL? 
102STCEG_LTax Destination Countrynvarchar30CHAR(N' ')YesT005LAND1TX Allow NULL? 
103LANDTXTax departure countrynvarchar30CHAR(N' ')YesT005LANDTX Allow NULL? 
104XEGDRIndicator: Triangular deal within the EU ?char10CHAR(N' ')YesXEGDR Allow NULL? 
105ENQUEUE_GRPBlock master contr. until all lower level contracts updatedchar10CHAR(N' ')YesENQUEUE_GRP Allow NULL? 
106DAT_FZAUCml delivery order qty datenvarchar80DATS(N'00000000')YesDAT_FZAU Allow NULL? 
107FMBDATMaterial Staging/Availability Datenvarchar80DATS(N'00000000')YesMBDAT Allow NULL? 
108VSNMR_VSales document version numbernvarchar120CHAR(N' ')YesVSNMR_V Allow NULL? 
109HANDLEInternational unique key for VBAK-VBELNnvarchar220CHAR(N' ')YesTSEGGUID_VBAK Allow NULL? 
110PROLIDangerous Goods Management Profile in SD Documentsnvarchar30CHAR(N' ')YesTDGC5ADGE_PROLI Allow NULL? 
111CONT_DGIndicator: Document contains dangerous goodschar10CHAR(N' ')YesADGE_NCDG Allow NULL? 
112CRM_GUIDCharacter field, length 70nvarchar700CHAR(N' ')YesCHAR70 Allow NULL? 
113UPD_TMSTMPUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)decimal217DEC((0))YesTIMESTAMPL
114MSR_IDProcess Identification Numbernvarchar100CHAR(N' ')YesMSR_PROCESS_ID Allow NULL? 
115TM_CTRL_KEYControl Key for Document Transfer to TMnvarchar40CHAR(N' ')YesTM_CTRL_KEY Allow NULL? 
116HANDOVERLOCLocation for a physical handover of goodsnvarchar100CHAR(N' ')YesHANDOVER_LOC Allow NULL? 
117/XLSO/SO_VALD_FMField of type DATSnvarchar80DATS(N'00000000')YesDATS Allow NULL? 
118/XLSO/SO_VALD_TOField of type DATSnvarchar80DATS(N'00000000')YesDATS Allow NULL? 
119/XLSO/PAYMENT_OPPayment Methodnvarchar20CHAR(N' ')Yes/XLSO/E_PAY_METHOD Allow NULL? 
120/XLSO/TRANS_CTXTTransaction Context GUIDnvarchar80NUMC(N'00000000')Yes/XLSO/E_TRANS_CTXT Allow NULL? 
121/XLSO/CATALOG_IDProduct catalog numbernvarchar100CHAR(N' ')Yes*WMINR Allow NULL? 
122/XLSO/VARIANT_IDProduct catalog variantnvarchar30CHAR(N' ')Yes*WMVARD Allow NULL? 
123PSM_BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')YesPSM_BUDAT Allow NULL? 
124SWENRBusiness Entity Numbernvarchar80CHAR(N' ')YesVIOB01HB_SWENR Allow NULL? 
125SMENRNumber of Sales Unitnvarchar80CHAR(N' ')YesVIMI01HB_SMENR Allow NULL? 
126PHASESales Phasenvarchar110CHAR(N' ')YesHBSSPHHB_SPHSE Allow NULL? 
127MTLAURMarker for Low Income Housingchar10CHAR(N' ')YesCHBSNCMHB_MTLAUR Allow NULL? 
128STAGEConstruction Stageint100INT4((0))YesHB_STAGE Allow NULL? 
129HB_CONT_REASONContingency datanvarchar20CHAR(N' ')YesHBSCREASONHB_CONT Allow NULL? 
130HB_EXPDATEExpiration datenvarchar80DATS(N'00000000')YesHB_EXP Allow NULL? 
131HB_RESDATEResolution datenvarchar80DATS(N'00000000')YesHB_RES Allow NULL? 
132MILL_APPL_IDApplication ID Category for Configurationnvarchar20CHAR(N' ')YesMILL_APPL_ID Allow NULL? 
133TASTreasury Account Symbolnvarchar300CHAR(N' ')YesFMFG_TAS Allow NULL? 
134BETCBusiness Event Type Codenvarchar100CHAR(N' ')YesFMFG_BETC Allow NULL? 
135MOD_ALLOWModification Allowedchar10CHAR(N' ')YesFMFG_MOD_ALLOW Allow NULL? 
136CANCEL_ALLOWCancellation Allowedchar10CHAR(N' ')YesFMFG_CANCEL_ALLOW Allow NULL? 
137PAY_METHODList of the Payment Methods to be Considerednvarchar100CHAR(N' ')YesDZWELS Allow NULL? 
138BPNBusiness Partner Numbernvarchar60CHAR(N' ')YesT880FMFG_BPN Allow NULL? 
139REP_FREQReporting Frequencynvarchar30CHAR(N' ')YesFMFG_REP_FREQ Allow NULL? 
140LOGSYSBLogical system with which document was creatednvarchar100CHAR(N' ')Yes*LOGSYSB Allow NULL? 
141KALCDProcedure for Campaign Determinationnvarchar60CHAR(N' ')Yes*KALCD Allow NULL? 
142MULTIMultiple Campaigns/Trade Promotions Active Indicatorchar10CHAR(N' ')YesCMPC_MULT_CAMPAIGN Allow NULL? 
143SPPAYMPayment Form for Special Payment Methodnvarchar20CHAR(N' ')YesSPPAYM Allow NULL? 
144WTYSC_CLM_HDRClaim headernvarchar160CHAR(N' ')YesWTYSC_CLM_HDR Allow NULL? 
NamePrimaryUniqueTypeColumns
VBAK~0YesYesCLUSTEREDMANDT, VBELN
VBAK~AUDNoNoNONCLUSTEREDMANDT, AUDAT