SAP ABAP Table VLCDIAVEHI_MARK (VELO : Dialog Structure for Vehicles (with Selection Box))
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 | VLCDIAVEHI_MARK | Table Relationship Diagram |
Short Description | VELO : Dialog Structure for Vehicles (with Selection Box) |
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 | MARK | XUMARK | XUMARK | CHAR | 1 | 0 | Selection 'X' selected, ' ' unselected | ||
2 | .INCLUDE | 0 | 0 | VELO: Dialog Structure for Vehicles | |||||
3 | .INCLUDE | 0 | 0 | VELO: Vehicle | |||||
4 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
5 | VGUID | VLC_GUID | SYSUUID_22 | CHAR | 22 | 0 | Vehicle GUID (Globally Unique IDentifier) | ||
6 | VHCLE | VLC_VHCLE | CHARG | CHAR | 10 | 0 | Internal Vehicle Number | * | |
7 | MATNR | VLC_MATNR | MATNR | CHAR | 18 | 0 | Vehicle Model | MARA | |
8 | LIFNR | VLC_LIFNR | LIFNR | CHAR | 10 | 0 | Vendor | LFA1 | |
9 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCH1 | |
10 | EQUNR | EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | EQUI | |
11 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
12 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
13 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | MBEW | |
14 | CUOBJ | CUOBJ | CUOBJ | NUMC | 18 | 0 | Configuration (internal object number) | ||
15 | CUABA | VLC_ACTDOCTYPE | VLC_ACTDOCTYPE | CHAR | 4 | 0 | Type of Document for Action | ||
16 | MMCTR | VLC_CNTRL | VLC_CNTRL | CHAR | 4 | 0 | Action Control | CVLC01 | |
17 | MMSTA | VLC_MMSTATU | VLC_STATU | CHAR | 4 | 0 | Primary Status | CVLC02 | |
18 | MMTSP | VLC_LTSTAMP | TZNTSTMPL | DEC | 21 | 7 | Long Time Stamp | ||
19 | SDCTR | VLC_CNTRL | VLC_CNTRL | CHAR | 4 | 0 | Action Control | CVLC01 | |
20 | SDSTA | VLC_SDSTATU | VLC_STATU | CHAR | 4 | 0 | Secondary Status | CVLC02 | |
21 | SDTSP | VLC_LTSTAMP | TZNTSTMPL | DEC | 21 | 7 | Long Time Stamp | ||
22 | KUNNR | VLC_KUNNR | KUNNR | CHAR | 10 | 0 | Customer | KNA1 | |
23 | ENDCU | VLC_ENDCU | BU_PARTNER | CHAR | 10 | 0 | End Customer (Central Business Partner) | BUT000 | |
24 | .INCLUDE | 0 | 0 | VELO : Additional Data in the vlcvehicle for Vehicle | |||||
25 | VHVIN | VLC_VHVIN | TEXT35 | CHAR | 35 | 0 | Vehicle Identification Number (Vehicle Identification No.) | ||
26 | VHCEX | VLC_VHCEX | CHAR35 | CHAR | 35 | 0 | External Vehicle Number | ||
27 | AVAIL | VLC_AVAILABILITY | VLC_AVAILABILITY | CHAR | 2 | 0 | Availability Status | CVLC10 | |
28 | VBLTY | VLC_VISIBILITY | VLC_VISIBILITY | CHAR | 1 | 0 | Visibility | ||
29 | LOCTN | VLC_LOCTN | CHAR10 | CHAR | 10 | 0 | VMS-Vehicle Location | ||
30 | GPRICE | VLC_GPRICE | CURR | 17 | 2 | Gross List Price of Vehicle | |||
31 | GPRICECUKY | VLC_GPRICECUKY | WAERS | CUKY | 5 | 0 | Currency of Vehicle Price | TCURC | |
32 | CDTSP | VLC_CTSTAMP | TZNTSTMPS | DEC | 15 | 0 | Time Stamp for Confirmed Delivery Date | ||
33 | PSTSP | VLC_PTSTAMP | TZNTSTMPS | DEC | 15 | 0 | Time Stamp for Planned Delivery Time | ||
34 | PDTSP | VLC_PRODTSTAMP | TZNTSTMPS | DEC | 15 | 0 | Time Stamp for Production Time | ||
35 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
36 | VHUSG | VLC_VEHIUSAGE | VLC_VEHIUSAGE | CHAR | 2 | 0 | Vehicle Usage | CVLC13 | |
37 | CMPGN | VLC_SALESCAMPAIGN | VLC_SALESCAMPAIGN | CHAR | 10 | 0 | Sales Campaign | VLCSCAMPGN | |
38 | PCOUNT | VLC_PCOUNT | VLC_PCOUNT | QUAN | 7 | 0 | Counter Reading | ||
39 | PCOUNT_U | FLEET_COUNT_UNIT | MEINS | UNIT | 3 | 0 | Fleet counter unit | T006 | |
40 | IMMATDATE | VLC_IMMATDATE | DATE | DATS | 8 | 0 | Initial Registration Date | ||
41 | VHSAR | VLC_VHSAR | VLC_VHSAR | CHAR | 10 | 0 | Vehicle Search Area | CVLC18 | |
42 | VHORD | VLC_VHORD | KUNNR | CHAR | 10 | 0 | Original Ordering Party of Vehicle | KNA1 | |
43 | SHLVL | VLC_SHLVL | VLC_SHLVL | CHAR | 2 | 0 | Sharing Levels for Vehicle Search | CVLC27 | |
44 | ARCHIVE_FLAG | VLC_ARCHIVE_VEHICLE | XFELD | CHAR | 1 | 0 | Archiving | ||
45 | USED_VEHICLE | VLC_USED_FLAG | XFELD | CHAR | 1 | 0 | Flag That Indicates That the Vehicle Is a Used Vehicle | ||
46 | MMDATU | VLC_MMDATUM | DATUM | DATS | 8 | 0 | Date of Primary Status | ||
47 | MMTIME | VLC_MMTIME | UZEIT | TIMS | 6 | 0 | Time of Primary Status | ||
48 | SDDATU | VLC_SDDATUM | DATUM | DATS | 8 | 0 | Date of Secondary Status | ||
49 | SDTIME | VLC_SDTIME | UZEIT | TIMS | 6 | 0 | Time of Secondary Status | ||
50 | CDDATE | VLC_CDATE | DATUM | DATS | 8 | 0 | Confirmed Delivery Date (According to CTP Logic) | ||
51 | CDTIME | VLC_CTIME | UZEIT | TIMS | 6 | 0 | Confirmed Time on Delivery Date | ||
52 | PSDATU | VLC_PDATUM | DATUM | DATS | 8 | 0 | Planned Delivery Date | ||
53 | PSTIME | VLC_PTIME | UZEIT | TIMS | 6 | 0 | Planned Time of Delivery | ||
54 | PDDATU | VLC_PRODDATUM | DATUM | DATS | 8 | 0 | Production Date | ||
55 | PDTIME | VLC_PRODTIME | UZEIT | TIMS | 6 | 0 | Production Time | ||
56 | CSTRYEAR | VLC_YEAR_OF_CONSTRUCTION | GJAHR | NUMC | 4 | 0 | Construction Year of Vehicle | ||
57 | CSTRMONTH | VLC_MONTH | VLC_MONTH | NUMC | 2 | 0 | Month of Construction of Vehicle | ||
58 | .INCLUDE | 0 | 0 | VELO : Short Texts | |||||
59 | MATNRTXT | VLC_MAKTX | TEXT40 | CHAR | 40 | 0 | Description of Vehicle Model | ||
60 | MMCTRTXT | VLC_MMCNTRLT | TEXT40 | CHAR | 40 | 0 | Description of Primary Action Control | ||
61 | MMSTATXT | VLC_MMSTATUT | TEXT40 | CHAR | 40 | 0 | Description of Primary Status | ||
62 | SDCTRTXT | VLC_SDCNTRLT | TEXT40 | CHAR | 40 | 0 | Description of Secondary Action Control | ||
63 | SDSTATXT | VLC_SDSTATUT | TEXT40 | CHAR | 40 | 0 | Description of Secondary Status | ||
64 | AVAILTXT | VLC_AVAILABILITYT | TEXT40 | CHAR | 40 | 0 | Description of Availability Status | ||
65 | LOCTNCITY | VLC_LOCTNCITY | TEXT30 | CHAR | 30 | 0 | Vehicle Location (City) | ||
66 | LOCTNTXT | VLC_LOCTNTXT | TEXT30 | CHAR | 30 | 0 | Description of VMS Vehicle Location | ||
67 | VHUSGTXT | VLC_VEHIUSAGET | TEXT40 | CHAR | 40 | 0 | Description of Vehicle Usage | ||
68 | VBLTYTXT | VLC_VISIBILITYT | TEXT40 | CHAR | 40 | 0 | Description of Visibility | ||
69 | SHLVL_TXT | VLC_SHLVL_TXT | TEXT60 | CHAR | 60 | 0 | Access Authorization Description During Vehicle Search | ||
70 | VHSARTXT | VLC_VHSAR_TXT | TEXT30 | CHAR | 30 | 0 | Vehicle Search Area Description | ||
71 | CMPGNTXT | VLC_SALESCAMPAIGNT | TEXT40 | CHAR | 40 | 0 | Description of Sales Campaign | ||
72 | ENDCUTXT | AD_NAME1 | TEXT40 | CHAR | 40 | 0 | Name 1 | ||
73 | CU_NAME1 | VLC_CU_NAME1_GP | NAME | CHAR | 35 | 0 | Name of Customer | ||
74 | SU_NAME1 | VLC_SU_NAME1_GP | NAME | CHAR | 35 | 0 | Name of Vendor | ||
75 | CONVPRICE | VLC_GPRICE | CURR | 17 | 2 | Gross List Price of Vehicle | |||
76 | CONVPRICECUKY | VLC_GPRICECUKY | WAERS | CUKY | 5 | 0 | Currency of Vehicle Price | * | |
77 | XERROR | VLC_XERROR | XFLAG | CHAR | 1 | 0 | Error Indicator | ||
78 | ACTLED | VLC_ACTLED | SYCHAR132 | CHAR | 132 | 0 | Success Indicator | ||
79 | NEWTSP | VLC_LTSTAMP | TZNTSTMPL | DEC | 21 | 7 | Long Time Stamp | ||
80 | ACTDOCTYPE | VLC_ACTDOCTYPE | VLC_ACTDOCTYPE | CHAR | 4 | 0 | Type of Document for Action | ||
81 | CATEGORY | VLC_CATEGORY | BOOL_ID | CHAR | 11 | 0 | Category for Vehicle Search | * | |
82 | ACTERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
83 | PREV_VHCLE | VLC_PREV_VHCLE | CHARG | CHAR | 10 | 0 | Preceding Internal Vehicle Number (New Vehicle) | * | |
84 | FOLL_VHCLE | VLC_FOLL_VHCLE | CHARG | CHAR | 10 | 0 | Following Internal Vehicle Number (Used Vehicle) | * | |
85 | .INCLUDE | 0 | 0 | VELO: Dialog Structure for SD documents | |||||
86 | .INCLUDE | 0 | 0 | VELO: SD document (Header Data) | |||||
87 | VBELN | VBELN_VA | VBELN | CHAR | 10 | 0 | Sales Document | * | |
88 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | * | |
89 | TIMESTAMP | TIMESTAMPL | TZNTSTMPL | DEC | 21 | 7 | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VLCDIAVEHI_MARK | AVAIL | CVLC10 | AVAIL | |||
2 | VLCDIAVEHI_MARK | BWTAR | MBEW | BWTAR | |||
3 | VLCDIAVEHI_MARK | CHARG | MCH1 | CHARG | |||
4 | VLCDIAVEHI_MARK | CMPGN | VLCSCAMPGN | CMPGN | 1 | CN | |
5 | VLCDIAVEHI_MARK | ENDCU | BUT000 | PARTNER | |||
6 | VLCDIAVEHI_MARK | EQUNR | EQUI | EQUNR | |||
7 | VLCDIAVEHI_MARK | GPRICECUKY | TCURC | WAERS | |||
8 | VLCDIAVEHI_MARK | KUNNR | KNA1 | KUNNR | 1 | CN | |
9 | VLCDIAVEHI_MARK | LGORT | T001L | LGORT | |||
10 | VLCDIAVEHI_MARK | LIFNR | LFA1 | LIFNR | 1 | CN | |
11 | VLCDIAVEHI_MARK | MANDT | T000 | MANDT | |||
12 | VLCDIAVEHI_MARK | MATNR | MARA | MATNR | |||
13 | VLCDIAVEHI_MARK | MMCTR | CVLC01 | CNTRL | 1 | CN | |
14 | VLCDIAVEHI_MARK | MMSTA | CVLC02 | STATU | 1 | CN | |
15 | VLCDIAVEHI_MARK | PCOUNT_U | T006 | MSEHI | 1 | CN | |
16 | VLCDIAVEHI_MARK | SDCTR | CVLC01 | CNTRL | 1 | CN | |
17 | VLCDIAVEHI_MARK | SDSTA | CVLC02 | STATU | 1 | CN | |
18 | VLCDIAVEHI_MARK | SHLVL | CVLC27 | SHLVL | |||
19 | VLCDIAVEHI_MARK | VHORD | KNA1 | KUNNR | |||
20 | VLCDIAVEHI_MARK | VHSAR | CVLC18 | VHSAR | 1 | CN | |
21 | VLCDIAVEHI_MARK | VHUSG | CVLC13 | VHUSG | 1 | CN | |
22 | VLCDIAVEHI_MARK | WERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 46C |