SAP ABAP Table VLCBATCHACT (VELO: Variant for Action Execution in Batch)

Hierarchy

☛ ECC-DIMP (Software Component) DIMP
   ⤷ IS-A-VMS (Application Component) Vehicle Management System
     ⤷ ISAUTO_VLC (Package) Vehicle Management System (VMS)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VLCBATCHACT	Table Relationship Diagram
Short Description	VELO: Variant for Action Execution in Batch

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ACTION	☑	VLC_ACTION	VLC_ACTION	CHAR	4	0	Action	CVLC03
3	EXECVARI	☑	VLC_VARIANT	CHAR12	CHAR	12	0	Execution Variant for Batch Actions
4	.INCLUDE	☐				0	0	VELO: Transfer Structure for Actions (Header Data)
5	COMP_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
6	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	*
7	UMWERKS	☐	VLC_UMWERKS	WERKS	CHAR	4	0	Destination Plant	*
8	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
9	.INCLUDE	☐				0	0	VELO: Transfer Structure for Actions (Header Data)
10	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
11	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
12	MATNR	☐	VLC_MATNR	MATNR	CHAR	18	0	Vehicle Model	*
13	NUMOFVEHI	☐	VLC_NUMOFVEHI	VLC_NUMOFVEHI	QUAN	5	0	Number of Vehicles
14	UNIT_OF_MEASURE	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	*
15	BSTYP	☐	EBSTYP	EBSTYP	CHAR	1	0	Purchasing Document Category
16	BSART	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	*
17	LIFNR	☐	VLC_LIFNR	LIFNR	CHAR	10	0	Vendor	*
18	REWORKER	☐	VLC_REWORKER	LIFNR	CHAR	10	0	Reworker	*
19	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
20	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
21	NETPR	☐	BPREI	WERT11	CURR	11	2	Net Price in Purchasing Document (in Document Currency)
22	EINDT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
23	LPEIN	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	*
24	DOC_DATE	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
25	PSTNG_DATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
26	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
27	GROSS_AMOUNT	☐	RMWWR	WERT7	CURR	13	2	Gross invoice amount in document currency
28	PMNTTRMS	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
29	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
30	TAX_AMOUNT	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
31	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	*
32	REF_DOC_NO	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
33	INVOICEDOCNUMBER	☐	RE_BELNR	BELNR	CHAR	10	0	Document Number of an Invoice Document
34	FISCALYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
35	REVREASON	☐	STGRD	STGRD	CHAR	2	0	Reason for Reversal	T041C
36	REV_INVDOCNO	☐	RE_BELNR	BELNR	CHAR	10	0	Document Number of an Invoice Document
37	REV_FISCYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
38	ADDR_HANDLE_CPD	☐	AD_HANDLE	TEXT140	CHAR	140	0	Handle for Creating Addresses/Persons (Bus. Addr. Services)
39	KTOKK	☐	KTOKK	KTOKK	CHAR	4	0	Vendor account group	*
40	BELNR	☐	CK_BELNR	BELNR	CHAR	10	0	Number of a Material Ledger Document/Price Change Document
41	BUDAT_RV	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
42	BKTXT_RV	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
43	XBLNR_RV	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
44	VPRSV	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
45	.INCLUDE	☐				0	0	VELO: Transfer Structure for Actions (Header Data)
46	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	*
47	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	*
48	SPART	☐	SPART	SPART	CHAR	2	0	Division	*
49	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	*
50	FKARA	☐	FKARA	FKART	CHAR	4	0	Proposed billing type for an order-related billing document	*
51	VBELN	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
52	KUNNR	☐	VLC_KUNNR	KUNNR	CHAR	10	0	Customer	KNA1
53	KUNAM	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
54	VDATU	☐	VLC_VDATU	DATUM	DATS	8	0	Requested Delivery Date
55	BSTNK	☐	BSTNK	BSTNK	CHAR	20	0	Customer purchase order number
56	ANGDT	☐	ANGDT_V	DATUM	DATS	8	0	Quotation/Inquiry is valid from
57	BNDDT	☐	BNDDT	DATUM	DATS	8	0	Date until which bid/quotation is binding (valid-to date)
58	LBELN	☐	VBELN_VL	VBELN	CHAR	10	0	Delivery	*
59	KUNWE	☐	KUNWE	KUNNR	CHAR	10	0	Ship-to party	*
60	WENAM	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
61	LFDAT	☐	LFDAT_V	DATUM	DATS	8	0	Delivery Date
62	FBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
63	REVBELN	☐	VBELN_VF	VBELN	CHAR	10	0	Billing document	*
64	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	*
65	RGNAM	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
66	AUGRU	☐	AUGRU	AUGRU	CHAR	3	0	Order reason (reason for the business transaction)	TVAU
67	KSCHA	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	*
68	NETWR	☐	NETWR_AK	WERTV8	CURR	15	2	Net Value of the Sales Order in Document Currency
69	WAERK	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
70	.INCLUDE	☐				0	0	VELO: Transfer Structure for Actions (Header Data)
71	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
72	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	*
73	MAT_DOC	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
74	DOC_YEAR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
75	REV_MAT_DOC	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
76	REV_DOC_YEAR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
77	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
78	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
79	WADAT_IST	☐	WADAT_IST	DATUM	DATS	8	0	Actual Goods Movement Date
80	LFSNR	☐	LFSNR1	XBLNR1	CHAR	16	0	Number of External Delivery Note
81	FRBNR	☐	FRBNR1	XBLNR1	CHAR	16	0	Number of Bill of Lading at Time of Goods Receipt
82	UMLGO	☐	UMLGO	LGORT	CHAR	4	0	Receiving/issuing storage location	T001L
83	EXBWR	☐	EXBWR	WERT7	CURR	13	2	Externally Entered Posting Amount in Local Currency
84	.INCLUDE	☐				0	0	VELO: Transfer Structure for Actions (Header Data)
85	QUEUE	☐	VLC_XQUEUE	XFLAG	CHAR	1	0	Mark for Quotation
86	PSDATU	☐	VLC_PDATUM	DATUM	DATS	8	0	Planned Delivery Date
87	PDDATU	☐	VLC_PRODDATUM	DATUM	DATS	8	0	Production Date
88	CDDATE	☐	VLC_CDATE	DATUM	DATS	8	0	Confirmed Delivery Date (According to CTP Logic)
89	CSTRYEAR	☐	VLC_YEAR_OF_CONSTRUCTION	GJAHR	NUMC	4	0	Construction Year of Vehicle
90	CSTRMONTH	☐	VLC_MONTH	VLC_MONTH	NUMC	2	0	Month of Construction of Vehicle
91	CSTRWEEK	☐	VLC_WEEK	VLC_WEEK	NUMC	2	0	Production Week
92	ENDCU	☐	VLC_ENDCU	BU_PARTNER	CHAR	10	0	End Customer (Central Business Partner)	BUT000
93	LOCTNTXT	☐	VLC_LOCTNTXT	TEXT30	CHAR	30	0	Description of VMS Vehicle Location
94	ENDCU_NAME	☐	BU_DESCRIP	BU_TEXT50	CHAR	50	0	Short name of business partner
95	.INCLUDE	☐				0	0	VELO : Additional Data in the vlcvehicle for Vehicle
96	VHVIN	☐	VLC_VHVIN	TEXT35	CHAR	35	0	Vehicle Identification Number (Vehicle Identification No.)
97	VHCEX	☐	VLC_VHCEX	CHAR35	CHAR	35	0	External Vehicle Number
98	AVAIL	☐	VLC_AVAILABILITY	VLC_AVAILABILITY	CHAR	2	0	Availability Status	CVLC10
99	VBLTY	☐	VLC_VISIBILITY	VLC_VISIBILITY	CHAR	1	0	Visibility
100	LOCTN	☐	VLC_LOCTN	CHAR10	CHAR	10	0	VMS-Vehicle Location
101	GPRICE	☐	VLC_GPRICE		CURR	17	2	Gross List Price of Vehicle
102	GPRICECUKY	☐	VLC_GPRICECUKY	WAERS	CUKY	5	0	Currency of Vehicle Price	TCURC
103	CDTSP	☐	VLC_CTSTAMP	TZNTSTMPS	DEC	15	0	Time Stamp for Confirmed Delivery Date
104	PSTSP	☐	VLC_PTSTAMP	TZNTSTMPS	DEC	15	0	Time Stamp for Planned Delivery Time
105	PDTSP	☐	VLC_PRODTSTAMP	TZNTSTMPS	DEC	15	0	Time Stamp for Production Time
106	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
107	VHUSG	☐	VLC_VEHIUSAGE	VLC_VEHIUSAGE	CHAR	2	0	Vehicle Usage	CVLC13
108	CMPGN	☐	VLC_SALESCAMPAIGN	VLC_SALESCAMPAIGN	CHAR	10	0	Sales Campaign	VLCSCAMPGN
109	PCOUNT	☐	VLC_PCOUNT	VLC_PCOUNT	QUAN	7	0	Counter Reading
110	PCOUNT_U	☐	FLEET_COUNT_UNIT	MEINS	UNIT	3	0	Fleet counter unit	T006
111	IMMATDATE	☐	VLC_IMMATDATE	DATE	DATS	8	0	Initial Registration Date
112	VHSAR	☐	VLC_VHSAR	VLC_VHSAR	CHAR	10	0	Vehicle Search Area	CVLC18
113	VHORD	☐	VLC_VHORD	KUNNR	CHAR	10	0	Original Ordering Party of Vehicle	KNA1
114	SHLVL	☐	VLC_SHLVL	VLC_SHLVL	CHAR	2	0	Sharing Levels for Vehicle Search	CVLC27
115	ARCHIVE_FLAG	☐	VLC_ARCHIVE_VEHICLE	XFELD	CHAR	1	0	Archiving
116	USED_VEHICLE	☐	VLC_USED_FLAG	XFELD	CHAR	1	0	Flag That Indicates That the Vehicle Is a Used Vehicle
117	.INCLUDE	☐				0	0	VELO: Transfer Structure for Actions (Header Data)
118	MGANR1	☐	MGANR	MGANR	CHAR	20	0	Master warranty number	*
119	GWLDT1	☐	GWLDT	DATUM	DATS	8	0	Guarantee date
120	MGANR2	☐	MGANR	MGANR	CHAR	20	0	Master warranty number	*
121	GWLDT2	☐	GWLDT	DATUM	DATS	8	0	Guarantee date
122	MGANR1VLC	☐	MGANR	MGANR	CHAR	20	0	Master warranty number	*
123	GWLDT1VLC	☐	GWLDT	DATUM	DATS	8	0	Guarantee date
124	MGANR2VLC	☐	MGANR	MGANR	CHAR	20	0	Master warranty number	*
125	GWLDT2VLC	☐	GWLDT	DATUM	DATS	8	0	Guarantee date
126	.INCLUDE	☐				0	0	Header data for used vehicle process
127	BBDATE	☐	VLC_BBDATE	DATS	DATS	8	0	Buy-Back Date
128	BBPRICE	☐	VLC_BBPRICE		CURR	17	2	Agreed Buy-Back Price
129	BBSTEXT	☐	VLC_BBTEXT	CHAR40	CHAR	40	0	Buy-Back Description
130	BBCUR	☐	VLC_CUKY	WAERS	CUKY	5	0	Currency	*
131	LT_LANG	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
132	PREV_VHCLE	☐	VLC_PREV_VHCLE	CHARG	CHAR	10	0	Preceding Internal Vehicle Number (New Vehicle)	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VLCBATCHACT	ACTION	CVLC03	AKTION
2	VLCBATCHACT	AUGRU	TVAU	AUGRU
3	VLCBATCHACT	AVAIL	CVLC10	AVAIL
4	VLCBATCHACT	CMPGN	VLCSCAMPGN	CMPGN		1	CN
5	VLCBATCHACT	CURRENCY	TCURC	WAERS
6	VLCBATCHACT	ENDCU	BUT000	PARTNER
7	VLCBATCHACT	GPRICECUKY	TCURC	WAERS
8	VLCBATCHACT	KUNNR	KNA1	KUNNR
9	VLCBATCHACT	LGORT	T001L	LGORT
10	VLCBATCHACT	MANDT	T000	MANDT
11	VLCBATCHACT	PCOUNT_U	T006	MSEHI		1	CN
12	VLCBATCHACT	REVREASON	T041C	STGRD
13	VLCBATCHACT	SHLVL	CVLC27	SHLVL
14	VLCBATCHACT	TAX_CODE	T007A	MWSKZ
15	VLCBATCHACT	UMLGO	T001L	LGORT
16	VLCBATCHACT	VHORD	KNA1	KUNNR
17	VLCBATCHACT	VHSAR	CVLC18	VHSAR		1	CN
18	VLCBATCHACT	VHUSG	CVLC13	VHUSG		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C