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  | VLCBATCHACT
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
Industry Specific :: Industry-Specific Component Automotive :: Vehicle Management System
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0VLCBATCHACT1351VELO : Variant for Action Execution in BatchVehicle Management System
SQL:  selectupdate insert create

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

SELECT MANDT, ACTION, EXECVARI, COMP_CODE, BWKEY, UMWERKS, WERKS, EKORG, EKGRP, MATNR, NUMOFVEHI, UNIT_OF_MEASURE, BSTYP, BSART, LIFNR, REWORKER, PSTYP, EBELN, NETPR, EINDT, LPEIN, DOC_DATE, PSTNG_DATE, CURRENCY, GROSS_AMOUNT, PMNTTRMS, TAX_CODE, TAX_AMOUNT, KALSM, REF_DOC_NO, INVOICEDOCNUMBER, FISCALYEAR, REVREASON, REV_INVDOCNO, REV_FISCYEAR, ADDR_HANDLE_CPD, KTOKK, BELNR, BUDAT_RV, BKTXT_RV, XBLNR_RV, VPRSV, VKORG, VTWEG, SPART, AUART, FKARA, VBELN, PRECEDING_DOC, PREC_DOC_POSNR, KUNNR, KUNAM, VDATU, BSTNK, BSTDK, ANGDT, BNDDT, LBELN, KUNWE, WENAM, LFDAT, FBELN, REVBELN, KUNRG, RGNAM, AUGRU, KSCHA, NETWR, WAERK, TRANSFERFLAG, RQDEALER, RQDEALNAM, DVDEALER, DVDEALNAM, VSART, ABGRU, LGORT, BWART, MAT_DOC, DOC_YEAR, REV_MAT_DOC, REV_DOC_YEAR, BLDAT, BUDAT, WADAT_IST, LFSNR, FRBNR, UMLGO, EXBWR, QUEUE, PSDATU, PDDATU, CDDATE, CSTRYEAR, CSTRMONTH, CSTRWEEK, ENDCU, LOCTNTXT, ENDCU_NAME, VHVIN, VHCEX, AVAIL, VBLTY, LOCTN, GPRICE, GPRICECUKY, CDTSP, PSTSP, PDTSP, ERNAM, VHUSG, CMPGN, PCOUNT, PCOUNT_U, IMMATDATE, VHSAR, VHORD, SHLVL, ARCHIVE_FLAG, USED_VEHICLE, AKNCAT, MGANR1, GWLDT1, MGANR2, GWLDT2, MGANR1VLC, GWLDT1VLC, MGANR2VLC, GWLDT2VLC, BBDATE, BBPRICE, BBSTEXT, BBCUR, LT_LANG, PREV_VHCLE FROM VLCBATCHACT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2ACTIONActionnvarchar40CHAR(N' ')NoCVLC03VLC_ACTION Allow NULL? 
3EXECVARIExecution Variant for Batch Actionsnvarchar120CHAR(N' ')NoVLC_VARIANT Allow NULL? 
4COMP_CODECompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
5BWKEYValuation Areanvarchar40CHAR(N' ')Yes*BWKEY Allow NULL? 
6UMWERKSDestination Plantnvarchar40CHAR(N' ')Yes*VLC_UMWERKS Allow NULL? 
7WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
8EKORGPurchasing Organizationnvarchar40CHAR(N' ')Yes*EKORG Allow NULL? 
9EKGRPPurchasing Groupnvarchar30CHAR(N' ')Yes*EKGRP Allow NULL? 
10MATNRVehicle Modelnvarchar180CHAR(N' ')Yes*VLC_MATNR Allow NULL? 
11NUMOFVEHINumber of Vehiclesdecimal50QUAN((0))YesVLC_NUMOFVEHI
12UNIT_OF_MEASUREBase Unit of Measurenvarchar30UNIT(N' ')Yes*LAGME Allow NULL? 
13BSTYPPurchasing Document Categorychar10CHAR(N' ')YesEBSTYP Allow NULL? 
14BSARTPurchasing Document Typenvarchar40CHAR(N' ')Yes*ESART Allow NULL? 
15LIFNRVendornvarchar100CHAR(N' ')Yes*VLC_LIFNR Allow NULL? 
16REWORKERReworkernvarchar100CHAR(N' ')Yes*VLC_REWORKER Allow NULL? 
17PSTYPItem Category in Purchasing Documentchar10CHAR(N' ')Yes*PSTYP Allow NULL? 
18EBELNPurchasing Document Numbernvarchar100CHAR(N' ')Yes*EBELN Allow NULL? 
19NETPRNet Price in Purchasing Document (in Document Currency)decimal112CURR((0))YesBPREI
20EINDTItem Delivery Datenvarchar80DATS(N'00000000')YesEINDT Allow NULL? 
21LPEINCategory of Delivery Datechar10CHAR(N' ')Yes*LPEIN Allow NULL? 
22DOC_DATEDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
23PSTNG_DATEPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
24CURRENCYCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
25GROSS_AMOUNTGross invoice amount in document currencydecimal132CURR((0))YesRMWWR
26PMNTTRMSTerms of Payment Keynvarchar40CHAR(N' ')YesDZTERM Allow NULL? 
27TAX_CODETax on sales/purchases codenvarchar20CHAR(N' ')YesT007AMWSKZ Allow NULL? 
28TAX_AMOUNTTax amount in document currencydecimal132CURR((0))YesWMWST
29KALSMProcedure (Pricing, Output Control, Acct. Det., Costing,...)nvarchar60CHAR(N' ')Yes*KALSM_D Allow NULL? 
30REF_DOC_NOReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
31INVOICEDOCNUMBERDocument Number of an Invoice Documentnvarchar100CHAR(N' ')YesRE_BELNR Allow NULL? 
32FISCALYEARFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
33REVREASONReason for Reversalnvarchar20CHAR(N' ')YesT041CSTGRD Allow NULL? 
34REV_INVDOCNODocument Number of an Invoice Documentnvarchar100CHAR(N' ')YesRE_BELNR Allow NULL? 
35REV_FISCYEARFiscal Yearnvarchar40NUMC(N'0000')YesGJAHR Allow NULL? 
36ADDR_HANDLE_CPDHandle for Creating Addresses/Persons (Bus. Addr. Services)nvarchar1400CHAR(N' ')YesAD_HANDLE Allow NULL? 
37KTOKKVendor account groupnvarchar40CHAR(N' ')Yes*KTOKK Allow NULL? 
38BELNRNumber of a Material Ledger Document/Price Change Documentnvarchar100CHAR(N' ')YesCK_BELNR Allow NULL? 
39BUDAT_RVPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
40BKTXT_RVDocument Header Textnvarchar250CHAR(N' ')YesBKTXT Allow NULL? 
41XBLNR_RVReference Document Numbernvarchar160CHAR(N' ')YesXBLNR1 Allow NULL? 
42VPRSVPrice control indicatorchar10CHAR(N' ')YesVPRSV Allow NULL? 
43VKORGSales Organizationnvarchar40CHAR(N' ')Yes*VKORG Allow NULL? 
44VTWEGDistribution Channelnvarchar20CHAR(N' ')Yes*VTWEG Allow NULL? 
45SPARTDivisionnvarchar20CHAR(N' ')Yes*SPART Allow NULL? 
46AUARTSales Document Typenvarchar40CHAR(N' ')Yes*AUART Allow NULL? 
47FKARAProposed billing type for an order-related billing documentnvarchar40CHAR(N' ')Yes*FKARA Allow NULL? 
48VBELNSales Documentnvarchar100CHAR(N' ')Yes*VBELN_VA Allow NULL? 
49PRECEDING_DOCDocument number of the reference documentnvarchar100CHAR(N' ')Yes*VGBEL Allow NULL? 
50PREC_DOC_POSNRItem number of the reference itemnvarchar60NUMC(N'000000')Yes*VGPOS Allow NULL? 
51KUNNRCustomernvarchar100CHAR(N' ')YesKNA1VLC_KUNNR Allow NULL? 
52KUNAMName of Customernvarchar350CHAR(N' ')YesVLC_CU_NAME1_GP Allow NULL? 
53VDATURequested Delivery Datenvarchar80DATS(N'00000000')YesVLC_VDATU Allow NULL? 
54BSTNKCustomer purchase order numbernvarchar200CHAR(N' ')YesBSTNK Allow NULL? 
55BSTDKCustomer purchase order datenvarchar80DATS(N'00000000')YesBSTDK Allow NULL? 
56ANGDTQuotation/Inquiry is valid fromnvarchar80DATS(N'00000000')YesANGDT_V Allow NULL? 
57BNDDTDate until which bid/quotation is binding (valid-to date)nvarchar80DATS(N'00000000')YesBNDDT Allow NULL? 
58LBELNDeliverynvarchar100CHAR(N' ')Yes*VBELN_VL Allow NULL? 
59KUNWEShip-to partynvarchar100CHAR(N' ')Yes*KUNWE Allow NULL? 
60WENAMName 1nvarchar350CHAR(N' ')YesNAME1_GP Allow NULL? 
61LFDATDelivery Datenvarchar80DATS(N'00000000')YesLFDAT_V Allow NULL? 
62FBELNBilling Documentnvarchar100CHAR(N' ')Yes*VBELN_VF Allow NULL? 
63REVBELNBilling Documentnvarchar100CHAR(N' ')Yes*VBELN_VF Allow NULL? 
64KUNRGPayernvarchar100CHAR(N' ')Yes*KUNRG Allow NULL? 
65RGNAMName 1nvarchar350CHAR(N' ')YesNAME1_GP Allow NULL? 
66AUGRUOrder reason (reason for the business transaction)nvarchar30CHAR(N' ')YesTVAUAUGRU Allow NULL? 
67KSCHACondition typenvarchar40CHAR(N' ')Yes*KSCHA Allow NULL? 
68NETWRNet Value of the Sales Order in Document Currencydecimal152CURR((0))YesNETWR_AK
69WAERKCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
70TRANSFERFLAGNew Input Valueschar10CHAR(N' ')YesXFLAG Allow NULL? 
71RQDEALERDealer Requested Vehiclenvarchar100CHAR(N' ')YesKNA1VLC_RQDEALER Allow NULL? 
72RQDEALNAMName of Requesting Customernvarchar350CHAR(N' ')YesVLC_RQDEALNAM Allow NULL? 
73DVDEALERDealer Desired Vehiclenvarchar100CHAR(N' ')YesKNA1VLC_DVDEALER Allow NULL? 
74DVDEALNAMName of Owning Customernvarchar350CHAR(N' ')YesVLC_DVDEALNAM Allow NULL? 
75VSARTShipping typenvarchar20CHAR(N' ')YesT173VSARTTR Allow NULL? 
76ABGRUReason for rejection of quotations and sales ordersnvarchar20CHAR(N' ')YesTVAGABGRU_VA Allow NULL? 
77LGORTStorage Locationnvarchar40CHAR(N' ')YesT001LLGORT_D Allow NULL? 
78BWARTMovement Type (Inventory Management)nvarchar30CHAR(N' ')Yes*BWART Allow NULL? 
79MAT_DOCNumber of Material Documentnvarchar100CHAR(N' ')YesMBLNR Allow NULL? 
80DOC_YEARMaterial Document Yearnvarchar40NUMC(N'0000')YesMJAHR Allow NULL? 
81REV_MAT_DOCNumber of Material Documentnvarchar100CHAR(N' ')YesMBLNR Allow NULL? 
82REV_DOC_YEARMaterial Document Yearnvarchar40NUMC(N'0000')YesMJAHR Allow NULL? 
83BLDATDocument Date in Documentnvarchar80DATS(N'00000000')YesBLDAT Allow NULL? 
84BUDATPosting Date in the Documentnvarchar80DATS(N'00000000')YesBUDAT Allow NULL? 
85WADAT_ISTActual Goods Movement Datenvarchar80DATS(N'00000000')YesWADAT_IST Allow NULL? 
86LFSNRNumber of External Delivery Notenvarchar160CHAR(N' ')YesLFSNR1 Allow NULL? 
87FRBNRNumber of Bill of Lading at Time of Goods Receiptnvarchar160CHAR(N' ')YesFRBNR1 Allow NULL? 
88UMLGOReceiving/Issuing Storage Locationnvarchar40CHAR(N' ')YesT001LUMLGO Allow NULL? 
89EXBWRExternally Entered Posting Amount in Local Currencydecimal132CURR((0))YesEXBWR
90QUEUEMark for Quotationchar10CHAR(N' ')YesVLC_XQUEUE Allow NULL? 
91PSDATUPlanned Delivery Datenvarchar80DATS(N'00000000')YesVLC_PDATUM Allow NULL? 
92PDDATUProduction Datenvarchar80DATS(N'00000000')YesVLC_PRODDATUM Allow NULL? 
93CDDATEConfirmed Delivery Date (According to CTP Logic)nvarchar80DATS(N'00000000')YesVLC_CDATE Allow NULL? 
94CSTRYEARConstruction Year of Vehiclenvarchar40NUMC(N'0000')YesVLC_YEAR_OF_CONSTRUCTION Allow NULL? 
95CSTRMONTHMonth of Construction of Vehiclenvarchar20NUMC(N'00')YesVLC_MONTH Allow NULL? 
96CSTRWEEKProduction Weeknvarchar20NUMC(N'00')YesVLC_WEEK Allow NULL? 
97ENDCUEnd Customer (Central Business Partner)nvarchar100CHAR(N' ')YesBUT000VLC_ENDCU Allow NULL? 
98LOCTNTXTDescription of VMS Vehicle Locationnvarchar300CHAR(N' ')YesVLC_LOCTNTXT Allow NULL? 
99ENDCU_NAMEShort name of business partnernvarchar500CHAR(N' ')YesBU_DESCRIP Allow NULL? 
100VHVINVehicle Identification Number (Vehicle Identification No.)nvarchar350CHAR(N' ')YesVLC_VHVIN Allow NULL? 
101VHCEXExternal Vehicle Numbernvarchar350CHAR(N' ')YesVLC_VHCEX Allow NULL? 
102AVAILAvailability Statusnvarchar20CHAR(N' ')YesCVLC10VLC_AVAILABILITY Allow NULL? 
103VBLTYVisibilitychar10CHAR(N' ')YesVLC_VISIBILITY Allow NULL? 
104LOCTNVMS-Vehicle Locationnvarchar100CHAR(N' ')YesVLC_LOCTN Allow NULL? 
105GPRICEGross List Price of Vehicledecimal172CURR((0))YesVLC_GPRICE
106GPRICECUKYCurrency of Vehicle Pricenvarchar50CUKY(N' ')YesTCURCVLC_GPRICECUKY Allow NULL? 
107CDTSPTime Stamp for Confirmed Delivery Datedecimal150DEC((0))YesVLC_CTSTAMP
108PSTSPTime Stamp for Planned Delivery Timedecimal150DEC((0))YesVLC_PTSTAMP
109PDTSPTime Stamp for Production Timedecimal150DEC((0))YesVLC_PRODTSTAMP
110ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
111VHUSGVehicle Usagenvarchar20CHAR(N' ')YesCVLC13VLC_VEHIUSAGE Allow NULL? 
112CMPGNSales Campaignnvarchar100CHAR(N' ')YesVLCSCAMPGNVLC_SALESCAMPAIGN Allow NULL? 
113PCOUNTCounter Readingdecimal70QUAN((0))YesVLC_PCOUNT
114PCOUNT_UFleet counter unitnvarchar30UNIT(N' ')YesT006FLEET_COUNT_UNIT Allow NULL? 
115IMMATDATEInitial Registration Datenvarchar80DATS(N'00000000')YesVLC_IMMATDATE Allow NULL? 
116VHSARVehicle Search Areanvarchar100CHAR(N' ')YesCVLC18VLC_VHSAR Allow NULL? 
117VHORDOriginal Ordering Party of Vehiclenvarchar100CHAR(N' ')YesKNA1VLC_VHORD Allow NULL? 
118SHLVLSharing Levels for Vehicle Searchnvarchar20CHAR(N' ')YesCVLC27VLC_SHLVL Allow NULL? 
119ARCHIVE_FLAGArchivingchar10CHAR(N' ')YesVLC_ARCHIVE_VEHICLE Allow NULL? 
120USED_VEHICLEFlag That Indicates That the Vehicle Is a Used Vehiclechar10CHAR(N' ')YesVLC_USED_FLAG Allow NULL? 
121AKNCATAcknowledge Categorynvarchar60CHAR(N' ')Yes*VLC_ACKNOWLEDGE_CATEGORY Allow NULL? 
122MGANR1Master warranty numbernvarchar200CHAR(N' ')Yes*MGANR Allow NULL? 
123GWLDT1Warranty Datenvarchar80DATS(N'00000000')YesGWLDT Allow NULL? 
124MGANR2Master warranty numbernvarchar200CHAR(N' ')Yes*MGANR Allow NULL? 
125GWLDT2Warranty Datenvarchar80DATS(N'00000000')YesGWLDT Allow NULL? 
126MGANR1VLCMaster warranty numbernvarchar200CHAR(N' ')Yes*MGANR Allow NULL? 
127GWLDT1VLCWarranty Datenvarchar80DATS(N'00000000')YesGWLDT Allow NULL? 
128MGANR2VLCMaster warranty numbernvarchar200CHAR(N' ')Yes*MGANR Allow NULL? 
129GWLDT2VLCWarranty Datenvarchar80DATS(N'00000000')YesGWLDT Allow NULL? 
130BBDATEBuy-Back Datenvarchar80DATS(N'00000000')YesVLC_BBDATE Allow NULL? 
131BBPRICEAgreed Buy-Back Pricedecimal172CURR((0))YesVLC_BBPRICE
132BBSTEXTBuy-Back Descriptionnvarchar400CHAR(N' ')YesVLC_BBTEXT Allow NULL? 
133BBCURCurrencynvarchar50CUKY(N' ')Yes*VLC_CUKY Allow NULL? 
134LT_LANGLanguage Keychar10LANG(N' ')Yes*SPRAS Allow NULL? 
135PREV_VHCLEPreceding Internal Vehicle Number (New Vehicle)nvarchar100CHAR(N' ')Yes*VLC_PREV_VHCLE Allow NULL? 
NamePrimaryUniqueTypeColumns
VLCBATCHACT~0YesYesCLUSTEREDMANDT, ACTION, EXECVARI

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