SAP ABAP Table VLCACTDATA_ITEM_S (VELO: Transfer Structure for Actions (Item Data))
Hierarchy
☛
ECC-DIMP (Software Component) DIMP
⤷ IS-A-VMS (Application Component) Vehicle Management System
⤷ ISAUTO_VLC (Package) Vehicle Management System (VMS)
⤷ IS-A-VMS (Application Component) Vehicle Management System
⤷ ISAUTO_VLC (Package) Vehicle Management System (VMS)
Basic Data
Table Category | INTTAB | Structure |
Structure | VLCACTDATA_ITEM_S | Table Relationship Diagram |
Short Description | VELO: Transfer Structure for Actions (Item Data) |
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 | VGUID | VLC_GUID | SYSUUID_22 | CHAR | 22 | 0 | Vehicle GUID (Globally Unique IDentifier) | ||
2 | VHCLE | VLC_VHCLE | CHARG | CHAR | 10 | 0 | Internal Vehicle Number | * | |
3 | .INCLUDE | 0 | 0 | VELO: Transfer Structure for Actions (Item Data) | |||||
4 | EINDT_CHANGED | EINDT | DATUM | DATS | 8 | 0 | Item delivery date | ||
5 | LPEIN | LPEIN | PRGBZ | CHAR | 1 | 0 | Category of delivery date | * | |
6 | CUOBJ | CUOBJ | CUOBJ | NUMC | 18 | 0 | Configuration (internal object number) | ||
7 | PO_NUMBER | BSTNR | EBELN | CHAR | 10 | 0 | Purchase order number | * | |
8 | PO_ITEM | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | * | |
9 | REF_DOC | MBLNR | BELNR | CHAR | 10 | 0 | Number of Material Document | ||
10 | REF_DOC_YEAR | MJAHR | GJAHR | NUMC | 4 | 0 | Year of material document | ||
11 | REF_DOC_IT | MBLPO | MBLPO | NUMC | 4 | 0 | Item in material document | ||
12 | ITEM_AMOUNT | WRBTR | WERT7 | CURR | 13 | 2 | Amount in document currency | ||
13 | ITEM_CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
14 | BUZEI | RBLGP | NUMC6 | NUMC | 6 | 0 | Document Item in Invoice Document | ||
15 | NETPR | BPREI | WERT11 | CURR | 11 | 2 | Net Price in Purchasing Document (in Document Currency) | ||
16 | MATNR | VLC_MATNR | MATNR | CHAR | 18 | 0 | Vehicle Model | * | |
17 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | * | |
18 | VALUE | SALK3 | WERT13N | CURR | 13 | 2 | Value of Total Valuated Stock | ||
19 | VALUE_WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
20 | RVALUE | CKMPC_ZUUMB | WERTV8 | CURR | 15 | 2 | Debit/credit amount for a material | ||
21 | RVALUE_WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
22 | .INCLUDE | 0 | 0 | VELO: Transfer Structure for Actions (Item Data) | |||||
23 | ANGDT | ANGDT_V | DATUM | DATS | 8 | 0 | Quotation/Inquiry is valid from | ||
24 | BNDDT | BNDDT | DATUM | DATS | 8 | 0 | Date until which bid/quotation is binding (valid-to date) | ||
25 | POSNR | POSNR_VF | POSNR | NUMC | 6 | 0 | Billing item | * | |
26 | RESTSTMP | VLC_LTSTAMP | TZNTSTMPL | DEC | 21 | 7 | Long Time Stamp | ||
27 | RESDATTO | VLC_RESDATBI | SYDATS | DATS | 8 | 0 | Date to Which Reservation Is Valid | ||
28 | RESDATFROM | VLC_RESDATVO | SYDATS | DATS | 8 | 0 | Date from Which Reservation Is Valid | ||
29 | LBELN | VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | * | |
30 | NETPR_SD | NETPR | WERTV6 | CURR | 11 | 2 | Net price | ||
31 | NETWR | NETWR_AK | WERTV8 | CURR | 15 | 2 | Net Value of the Sales Order in Document Currency | ||
32 | WAERK | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
33 | .INCLUDE | 0 | 0 | VELO: Transfer Structure for Actions (Item Data) | |||||
34 | PDDATU | VLC_PRODDATUM | DATUM | DATS | 8 | 0 | Production Date | ||
35 | PSDATU | VLC_PDATUM | DATUM | DATS | 8 | 0 | Planned Delivery Date | ||
36 | CDATE | VLC_CDATE | DATUM | DATS | 8 | 0 | Confirmed Delivery Date (According to CTP Logic) | ||
37 | CSTRYEAR | VLC_YEAR_OF_CONSTRUCTION | GJAHR | NUMC | 4 | 0 | Construction Year of Vehicle | ||
38 | CSTRMONTH | VLC_MONTH | VLC_MONTH | NUMC | 2 | 0 | Month of Construction of Vehicle | ||
39 | FILENAME | LOCALFILE | LOCALFILE | CHAR | 128 | 0 | Local file for upload/download | ||
40 | ENDCU | VLC_ENDCU | BU_PARTNER | CHAR | 10 | 0 | End Customer (Central Business Partner) | BUT000 | |
41 | ENDCU_NAME | BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
42 | LOCTNTXT | VLC_LOCTNTXT | TEXT30 | CHAR | 30 | 0 | Description of VMS Vehicle Location | ||
43 | .INCLUDE | 0 | 0 | VELO : Additional Data in the vlcvehicle for Vehicle | |||||
44 | VHVIN | VLC_VHVIN | TEXT35 | CHAR | 35 | 0 | Vehicle Identification Number (Vehicle Identification No.) | ||
45 | VHCEX | VLC_VHCEX | CHAR35 | CHAR | 35 | 0 | External Vehicle Number | ||
46 | AVAIL | VLC_AVAILABILITY | VLC_AVAILABILITY | CHAR | 2 | 0 | Availability Status | CVLC10 | |
47 | VBLTY | VLC_VISIBILITY | VLC_VISIBILITY | CHAR | 1 | 0 | Visibility | ||
48 | LOCTN | VLC_LOCTN | CHAR10 | CHAR | 10 | 0 | VMS-Vehicle Location | ||
49 | GPRICE | VLC_GPRICE | CURR | 17 | 2 | Gross List Price of Vehicle | |||
50 | GPRICECUKY | VLC_GPRICECUKY | WAERS | CUKY | 5 | 0 | Currency of Vehicle Price | TCURC | |
51 | CDTSP | VLC_CTSTAMP | TZNTSTMPS | DEC | 15 | 0 | Time Stamp for Confirmed Delivery Date | ||
52 | PSTSP | VLC_PTSTAMP | TZNTSTMPS | DEC | 15 | 0 | Time Stamp for Planned Delivery Time | ||
53 | PDTSP | VLC_PRODTSTAMP | TZNTSTMPS | DEC | 15 | 0 | Time Stamp for Production Time | ||
54 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
55 | VHUSG | VLC_VEHIUSAGE | VLC_VEHIUSAGE | CHAR | 2 | 0 | Vehicle Usage | CVLC13 | |
56 | CMPGN | VLC_SALESCAMPAIGN | VLC_SALESCAMPAIGN | CHAR | 10 | 0 | Sales Campaign | VLCSCAMPGN | |
57 | PCOUNT | VLC_PCOUNT | VLC_PCOUNT | QUAN | 7 | 0 | Counter Reading | ||
58 | PCOUNT_U | FLEET_COUNT_UNIT | MEINS | UNIT | 3 | 0 | Fleet counter unit | * | |
59 | IMMATDATE | VLC_IMMATDATE | DATE | DATS | 8 | 0 | Initial Registration Date | ||
60 | VHSAR | VLC_VHSAR | VLC_VHSAR | CHAR | 10 | 0 | Vehicle Search Area | CVLC18 | |
61 | VHORD | VLC_VHORD | KUNNR | CHAR | 10 | 0 | Original Ordering Party of Vehicle | KNA1 | |
62 | SHLVL | VLC_SHLVL | VLC_SHLVL | CHAR | 2 | 0 | Sharing Levels for Vehicle Search | CVLC27 | |
63 | ARCHIVE_FLAG | VLC_ARCHIVE_VEHICLE | XFELD | CHAR | 1 | 0 | Archiving | ||
64 | USED_VEHICLE | VLC_USED_FLAG | XFELD | CHAR | 1 | 0 | Flag That Indicates That the Vehicle Is a Used Vehicle | ||
65 | RESPRICE | VLC_RESELLPRICE | CURR | 17 | 2 | Resale Price | |||
66 | RESCUKEY | VLC_GPRICECUKY | WAERS | CUKY | 5 | 0 | Currency of Vehicle Price | * | |
67 | .INCLUDE | 0 | 0 | VELO: Transfer Structure for Actions (Item Data) | |||||
68 | EQUNR | EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | * | |
69 | MSEQUI | VLC_MSEQUI | EQUNR | CHAR | 18 | 0 | Reference Equipment for Measuring Points | * | |
70 | MGANR1 | MGANR | MGANR | CHAR | 20 | 0 | Master warranty number | * | |
71 | GWLDT1 | GWLDT | DATUM | DATS | 8 | 0 | Guarantee date | ||
72 | MGANR2 | MGANR | MGANR | CHAR | 20 | 0 | Master warranty number | * | |
73 | GWLDT2 | GWLDT | DATUM | DATS | 8 | 0 | Guarantee date | ||
74 | VAPLZ | GEWRK | ARBPL | CHAR | 8 | 0 | Main work center for maintenance tasks | ||
75 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
76 | QMNUM | QMNUM | QMNUM | CHAR | 12 | 0 | Message Number | * | |
77 | AUFART_SM | AUFART | AUFART | CHAR | 4 | 0 | Order Type | T003O | |
78 | IWERK_SM | IWERK | WERKS | CHAR | 4 | 0 | Maintenance Planning Plant | T001W | |
79 | VAWRK_SM | WERGW | WERKS | CHAR | 4 | 0 | Plant associated with main work center | T001W | |
80 | QMART | QMART | QMART | CHAR | 2 | 0 | Message Type | TQ80 | |
81 | KTEXT | AUFTEXT | TEXT40 | CHAR | 40 | 0 | Description | ||
82 | PRSDT | VPKPRSDT | DATUM | DATS | 8 | 0 | Pricing date | ||
83 | BUDAT | VPKDATETO | DATUM | DATS | 8 | 0 | Posting date to | ||
84 | VBELN_SM | VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | * | |
85 | OPR_CONTAINER | SCRFNAME | DYNFNAM | CHAR | 132 | 0 | Name of a Screen Element | ||
86 | KLASSE_SM | KLASSE_D | KLASSE | CHAR | 18 | 0 | Class number | ||
87 | KDAUF | VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | VBUK | |
88 | KDPOS | POSNR_VA | POSNR | NUMC | 6 | 0 | Sales Document Item | VBUP | |
89 | .INCLUDE | 0 | 0 | VELO: Transfer Structure for Actions (Item Data) | |||||
90 | LGORT_PREV | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
91 | EXBWR | EXBWR | WERT7 | CURR | 13 | 2 | Externally Entered Posting Amount in Local Currency | ||
92 | .INCLUDE | 0 | 0 | Data for used vehicle process on the item level | |||||
93 | 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 | VLCACTDATA_ITEM_S | AUFART_SM | T003O | AUART | |||
2 | VLCACTDATA_ITEM_S | AUFNR | AUFK | AUFNR | |||
3 | VLCACTDATA_ITEM_S | AVAIL | CVLC10 | AVAIL | |||
4 | VLCACTDATA_ITEM_S | CMPGN | VLCSCAMPGN | CMPGN | 1 | CN | |
5 | VLCACTDATA_ITEM_S | ENDCU | BUT000 | PARTNER | |||
6 | VLCACTDATA_ITEM_S | GPRICECUKY | TCURC | WAERS | |||
7 | VLCACTDATA_ITEM_S | ITEM_CURRENCY | TCURC | WAERS | |||
8 | VLCACTDATA_ITEM_S | IWERK_SM | T001W | WERKS | |||
9 | VLCACTDATA_ITEM_S | KDAUF | VBUK | VBELN | |||
10 | VLCACTDATA_ITEM_S | KDPOS | VBUP | POSNR | |||
11 | VLCACTDATA_ITEM_S | QMART | TQ80 | QMART | |||
12 | VLCACTDATA_ITEM_S | SHLVL | CVLC27 | SHLVL | |||
13 | VLCACTDATA_ITEM_S | VAWRK_SM | T001W | WERKS | |||
14 | VLCACTDATA_ITEM_S | VHORD | KNA1 | KUNNR | |||
15 | VLCACTDATA_ITEM_S | VHSAR | CVLC18 | VHSAR | 1 | CN | |
16 | VLCACTDATA_ITEM_S | VHUSG | CVLC13 | VHUSG | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 46C |