SAP ABAP Table VLCIDACTDATA (VELO : Transfer Structure for Actions with Reference to IDOC)

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	VLCIDACTDATA	Table Relationship Diagram
Short Description	VELO : Transfer Structure for Actions with Reference to IDOC

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

Foreign Keys

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

History

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