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  | VSVBAK_CN
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
Project System :: Simulation
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VSVBAK_CN1131Version: Sales document: Header dataSimulation
SQL:  selectupdate insert create

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

SELECT MANDT, VSNMR, 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, WTYSC_CLM_HDR FROM VSVBAK_CN
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2VSNMRNumber or description of a versionnvarchar120CHAR(N' ')NoVSNMR Allow NULL? 
3VBELNSales Documentnvarchar100CHAR(N' ')No*VBELN_VA Allow NULL? 
4ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')NoERDAT Allow NULL? 
5ERZETEntry timenvarchar60TIMS(N'000000')NoERZET Allow NULL? 
6ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')NoERNAM Allow NULL? 
7ANGDTQuotation/Inquiry is valid fromnvarchar80DATS(N'00000000')NoANGDT_V Allow NULL? 
8BNDDTDate until which bid/quotation is binding (valid-to date)nvarchar80DATS(N'00000000')NoBNDDT Allow NULL? 
9AUDATDocument Date (Date Received/Sent)nvarchar80DATS(N'00000000')NoAUDAT Allow NULL? 
10VBTYPSD document categorychar10CHAR(N' ')NoVBTYP Allow NULL? 
11TRVOGTransaction groupchar10CHAR(N' ')NoTRVOG Allow NULL? 
12AUARTSales Document Typenvarchar40CHAR(N' ')No*AUART Allow NULL? 
13AUGRUOrder reason (reason for the business transaction)nvarchar30CHAR(N' ')No*AUGRU Allow NULL? 
14GWLDTWarranty Datenvarchar80DATS(N'00000000')NoGWLDT Allow NULL? 
15SUBMICollective Numbernvarchar100CHAR(N' ')NoSUBMI Allow NULL? 
16LIFSKDelivery block (document header)nvarchar20CHAR(N' ')No*LIFSK Allow NULL? 
17FAKSKBilling block in SD documentnvarchar20CHAR(N' ')No*FAKSK Allow NULL? 
18NETWRNet Value of the Sales Order in Document Currencydecimal152CURR((0))NoNETWR_AK
19WAERKSD Document Currencynvarchar50CUKY(N' ')No*WAERK Allow NULL? 
20VKORGSales Organizationnvarchar40CHAR(N' ')No*VKORG Allow NULL? 
21VTWEGDistribution Channelnvarchar20CHAR(N' ')No*VTWEG Allow NULL? 
22SPARTDivisionnvarchar20CHAR(N' ')No*SPART Allow NULL? 
23VKGRPSales Groupnvarchar30CHAR(N' ')No*VKGRP Allow NULL? 
24VKBURSales Officenvarchar40CHAR(N' ')No*VKBUR Allow NULL? 
25GSBERBusiness Areanvarchar40CHAR(N' ')No*GSBER Allow NULL? 
26GSKSTBusiness area from cost centernvarchar40CHAR(N' ')No*GSKST Allow NULL? 
27GUEBGValid-from date (outline agreements, product proposals)nvarchar80DATS(N'00000000')NoGUEBG Allow NULL? 
28GUEENValid-to date (outline agreements, product proposals)nvarchar80DATS(N'00000000')NoGUEEN Allow NULL? 
29KNUMVNumber of the document conditionnvarchar100CHAR(N' ')NoKNUMV Allow NULL? 
30VDATURequested delivery datenvarchar80DATS(N'00000000')NoEDATU_VBAK Allow NULL? 
31VPRGRProposed date typechar10CHAR(N' ')NoPRGRS_VBAK Allow NULL? 
32AUTLFComplete delivery defined for each sales order?char10CHAR(N' ')NoAUTLF Allow NULL? 
33VBKLAOriginal system with release and transaction controlnvarchar90CHAR(N' ')NoVBKLA Allow NULL? 
34VBKLTSD document indicatorchar10CHAR(N' ')NoVBKLT Allow NULL? 
35KALSMSales and Distribution: Pricing Procedure in Pricingnvarchar60CHAR(N' ')No*KALSMASD Allow NULL? 
36VSBEDShipping Conditionsnvarchar20CHAR(N' ')No*VSBED Allow NULL? 
37FKARAProposed billing type for an order-related billing documentnvarchar40CHAR(N' ')No*FKARA Allow NULL? 
38AWAHRSales probabilitynvarchar30NUMC(N'000')NoAWAHR_AK Allow NULL? 
39KTEXTSearch term for product proposalnvarchar400CHAR(N' ')NoKTEXT_V Allow NULL? 
40BSTNKCustomer purchase order numbernvarchar200CHAR(N' ')NoBSTNK Allow NULL? 
41BSARKCustomer purchase order typenvarchar40CHAR(N' ')No*BSARK Allow NULL? 
42BSTDKCustomer purchase order datenvarchar80DATS(N'00000000')NoBSTDK Allow NULL? 
43BSTZDPurchase order number supplementnvarchar40CHAR(N' ')NoBSTZD Allow NULL? 
44IHREZYour Referencenvarchar120CHAR(N' ')NoIHREZ Allow NULL? 
45BNAMEName of orderernvarchar350CHAR(N' ')NoBNAME_V Allow NULL? 
46TELF1Telephone Numbernvarchar160CHAR(N' ')NoTELF1_VP Allow NULL? 
47MAHZANumber of contacts from the customerdecimal30DEC((0))NoMAHZA
48MAHDTLast customer contact datenvarchar80DATS(N'00000000')NoMAHDT Allow NULL? 
49KUNNRSold-to partynvarchar100CHAR(N' ')No*KUNAG Allow NULL? 
50KOSTLCost Centernvarchar100CHAR(N' ')No*KOSTL Allow NULL? 
51STAFOUpdate group for statistics updatenvarchar60CHAR(N' ')No*STAFO Allow NULL? 
52STWAEStatistics currencynvarchar50CUKY(N' ')No*STWAE Allow NULL? 
53AEDATChanged Onnvarchar80DATS(N'00000000')NoAEDAT Allow NULL? 
54KVGR1Customer group 1nvarchar30CHAR(N' ')No*KVGR1 Allow NULL? 
55KVGR2Customer group 2nvarchar30CHAR(N' ')No*KVGR2 Allow NULL? 
56KVGR3Customer group 3nvarchar30CHAR(N' ')No*KVGR3 Allow NULL? 
57KVGR4Customer group 4nvarchar30CHAR(N' ')No*KVGR4 Allow NULL? 
58KVGR5Customer group 5nvarchar30CHAR(N' ')No*KVGR5 Allow NULL? 
59KNUMAAgreement (various conditions grouped together)nvarchar100CHAR(N' ')No*KNUMA Allow NULL? 
60KOKRSControlling Areanvarchar40CHAR(N' ')No*KOKRS Allow NULL? 
61PS_PSP_PNRWork Breakdown Structure Element (WBS Element)nvarchar80NUMC(N'00000000')No*PS_PSP_PNR Allow NULL? 
62KURSTExchange Rate Typenvarchar40CHAR(N' ')No*KURST Allow NULL? 
63KKBERCredit control areanvarchar40CHAR(N' ')No*KKBER Allow NULL? 
64KNKLICustomer's account number with credit limit referencenvarchar100CHAR(N' ')No*KNKLI Allow NULL? 
65GRUPPCustomer Credit Groupnvarchar40CHAR(N' ')No*GRUPP_CM Allow NULL? 
66SBGRPCredit representative group for credit managementnvarchar30CHAR(N' ')No*SBGRP_CM Allow NULL? 
67CTLPCCredit management: Risk categorynvarchar30CHAR(N' ')No*CTLPC_CM Allow NULL? 
68CMWAECurrency key of credit control areanvarchar50CUKY(N' ')No*WAERS_CM Allow NULL? 
69CMFRERelease date of the document determined by credit managementnvarchar80DATS(N'00000000')NoCMFRE Allow NULL? 
70CMNUPDate of next credit check of documentnvarchar80DATS(N'00000000')NoCMNUP Allow NULL? 
71CMNGVNext datenvarchar80DATS(N'00000000')NoCMNGV Allow NULL? 
72AMTBLReleased credit value of the documentdecimal152CURR((0))NoAMTBL_CM
73HITYP_PRHierarchy type for pricingchar10CHAR(N' ')No*HITYP_PR Allow NULL? 
74ABRVWUsage Indicatornvarchar30CHAR(N' ')No*ABRVW Allow NULL? 
75ABDISMRP for delivery schedule typeschar10CHAR(N' ')NoABDIS Allow NULL? 
76VGBELDocument number of the reference documentnvarchar100CHAR(N' ')No*VGBEL Allow NULL? 
77OBJNRObject number at header levelnvarchar220CHAR(N' ')No*OBJKO Allow NULL? 
78BUKRS_VFCompany code to be billednvarchar40CHAR(N' ')No*BUKRS_VF Allow NULL? 
79TAXK1Tax classification 1 for customerchar10CHAR(N' ')No*TAXK1 Allow NULL? 
80TAXK2Tax classification 2 for customerchar10CHAR(N' ')No*TAXK2 Allow NULL? 
81TAXK3Tax classification 3 for customerchar10CHAR(N' ')No*TAXK3 Allow NULL? 
82TAXK4Tax Classification 4 Customerchar10CHAR(N' ')No*TAXK4 Allow NULL? 
83TAXK5Tax classification 5 for customerchar10CHAR(N' ')No*TAXK5 Allow NULL? 
84TAXK6Tax classification 6 for customerchar10CHAR(N' ')No*TAXK6 Allow NULL? 
85TAXK7Tax classification 7 for customerchar10CHAR(N' ')No*TAXK7 Allow NULL? 
86TAXK8Tax classification 8 for customerchar10CHAR(N' ')No*TAXK8 Allow NULL? 
87TAXK9Tax classification 9 for customerchar10CHAR(N' ')No*TAXK9 Allow NULL? 
88XBLNRReference Document Numbernvarchar160CHAR(N' ')NoXBLNR_V1 Allow NULL? 
89ZUONRAssignment numbernvarchar180CHAR(N' ')NoORDNR_V Allow NULL? 
90VGTYPDocument category of preceding SD documentchar10CHAR(N' ')NoVBTYP_V Allow NULL? 
91KALSM_CHSearch procedure for batch determinationnvarchar60CHAR(N' ')No*KALSMA_CH Allow NULL? 
92AGRZRAccrual period for order-related billing docs.to be accruednvarchar20NUMC(N'00')NoAGRZR Allow NULL? 
93AUFNROrder Numbernvarchar120CHAR(N' ')No*AUFNR Allow NULL? 
94QMNUMNotification Nonvarchar120CHAR(N' ')No*QMNUM Allow NULL? 
95VBELN_GRPMster contract numbernvarchar100CHAR(N' ')Yes*VBELN_GRP Allow NULL? 
96SCHEME_GRPReferencing requirement: Procedurenvarchar40CHAR(N' ')Yes*SCHEME_GRP Allow NULL? 
97ABRUF_PARTCheck partner authorizationschar10CHAR(N' ')YesABRUF_PART Allow NULL? 
98ABHODPick up datenvarchar80DATS(N'00000000')YesABHOD Allow NULL? 
99ABHOVPick up timenvarchar60TIMS(N'000000')YesABHOZ Allow NULL? 
100ABHOBPick up timenvarchar60TIMS(N'000000')YesABHOZ Allow NULL? 
101RPLNRNumber of payment card plan typenvarchar100CHAR(N' ')Yes*RPLNR Allow NULL? 
102VZEITProposed schedule line time (local with ref. to sales org.)nvarchar60TIMS(N'000000')YesEZEIT_VBAK Allow NULL? 
103STCEG_LTax Destination Countrynvarchar30CHAR(N' ')Yes*LAND1TX Allow NULL? 
104LANDTXTax departure countrynvarchar30CHAR(N' ')Yes*LANDTX Allow NULL? 
105XEGDRIndicator: Triangular deal within the EU ?char10CHAR(N' ')YesXEGDR Allow NULL? 
106ENQUEUE_GRPBlock master contr. until all lower level contracts updatedchar10CHAR(N' ')YesENQUEUE_GRP Allow NULL? 
107DAT_FZAUCml delivery order qty datenvarchar80DATS(N'00000000')YesDAT_FZAU Allow NULL? 
108FMBDATMaterial Staging/Availability Datenvarchar80DATS(N'00000000')YesMBDAT Allow NULL? 
109VSNMR_VSales document version numbernvarchar120CHAR(N' ')YesVSNMR_V Allow NULL? 
110HANDLEInternational unique key for VBAK-VBELNnvarchar220CHAR(N' ')YesTSEGGUID_VBAK Allow NULL? 
111PROLIDangerous Goods Management Profile in SD Documentsnvarchar30CHAR(N' ')YesTDGC5ADGE_PROLI Allow NULL? 
112CONT_DGIndicator: Document contains dangerous goodschar10CHAR(N' ')YesADGE_NCDG Allow NULL? 
113WTYSC_CLM_HDRClaim headernvarchar160CHAR(N' ')YesWTYSC_CLM_HDR Allow NULL? 
NamePrimaryUniqueTypeColumns
VSVBAK_CN~0YesYesCLUSTEREDMANDT, VSNMR, VBELN

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