SAP ABAP Table VLCACTDATA (VELO: Transfer Structure for Actions (Header and Items))

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	INTTAB	Structure
Structure	VLCACTDATA	Table Relationship Diagram
Short Description	VELO: Transfer Structure for Actions (Header and Items)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

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

Foreign Keys

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

History

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