SAP ABAP Table VLCACTDATA_SUBITEM_SM_S (VELO : Transfer Structure for Actions (Subitem 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_SUBITEM_SM_S | Table Relationship Diagram |
Short Description | VELO : Transfer Structure for Actions (Subitem 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 | ACTION | VLC_ACTION | VLC_ACTION | CHAR | 4 | 0 | Action | * | |
4 | TABLE_CNT | VLC_TABLE_CNT | VLC_TABLE_CNT | NUMC | 3 | 0 | Counter for Subitem Tables | ||
5 | .INCLUDE | 0 | 0 | VELO: Transactions for Service Order | |||||
6 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
7 | VORNR | VORNR | VORNR | CHAR | 4 | 0 | Operation/Activity Number | ||
8 | STEUS | STEUS | STEUS | CHAR | 4 | 0 | Control key | T430 | |
9 | ARBPL | ARBPL | ARBPL | CHAR | 8 | 0 | Work center | ||
10 | LTXA1 | LTXA1 | TEXT40 | CHAR | 40 | 0 | Operation short text | ||
11 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
12 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
13 | PLNAW | PLNAW | PLNAW | CHAR | 1 | 0 | Application of the task list | * | |
14 | ARBEI | ARBEIT | ARBEIT | QUAN | 7 | 1 | Work involved in the activity | ||
15 | ARBEH | ARBEITE | MEINS | UNIT | 3 | 0 | Unit for work | T006 | |
16 | ANZZL | ANZKAP | INT1 | INT1 | 3 | 0 | Number of capacities required | ||
17 | DAUNO | DAUNOR | DAUER_4_1 | QUAN | 5 | 1 | Normal duration of the activity | ||
18 | DAUNE | DAUNORE | MEINS | UNIT | 3 | 0 | Normal duration/unit | T006 | |
19 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
20 | AUFPL | CO_AUFPL | AUFPL | NUMC | 10 | 0 | Routing number of operations in the order | ||
21 | APLZL | CO_APLZL | CO_APLZL | NUMC | 8 | 0 | General counter for order | * | |
22 | PLNFL | PLNFOLGE | PLNFOLGE | CHAR | 6 | 0 | Sequence | ||
23 | .INCLUDE | 0 | 0 | VELO: Items for Service Notification | |||||
24 | REFOBJECTKEY | SWO_TYPEID | SWO_TYPEID | CHAR | 70 | 0 | Object key | ||
25 | ITEM_KEY | FELFD | FELFD | NUMC | 4 | 0 | Item Number in Item Record | * | |
26 | ITEM_SORT_NO | QLFDPOS | QFELFD | NUMC | 4 | 0 | Sort Number for Item | ||
27 | DESCRIPT | FETXT | TEXT40 | CHAR | 40 | 0 | Notification Item Short Text | ||
28 | D_CAT_TYP | FEKAT | QKATART | CHAR | 1 | 0 | Catalog Type - Problems | * | |
29 | D_CODEGRP | FEGRP | QCODEGRP | CHAR | 8 | 0 | Code Group - Problem | * | |
30 | D_CODE | FECOD | QCODE | CHAR | 4 | 0 | Problem | * | |
31 | STXT_GRPCD | QKTEXTGR | QKURZTEXT | CHAR | 40 | 0 | Code Group Description | ||
32 | TXT_PROBCD | TXTCDFE | TEXT40 | CHAR | 40 | 0 | Problem Code Short Text | ||
33 | DL_CAT_TYP | OTKAT | QKATART | CHAR | 1 | 0 | Catalog Type - Object Parts | * | |
34 | DL_CODEGRP | OTGRP | QCODEGRP | CHAR | 8 | 0 | Code Group - Object Parts | * | |
35 | DL_CODE | OTEIL | QCODE | CHAR | 4 | 0 | Part of Object | * | |
36 | TXT_GRPCD | QKTEXTGR | QKURZTEXT | CHAR | 40 | 0 | Code Group Description | ||
37 | TXT_OBJPTCD | TXTCDOT | TEXT40 | CHAR | 40 | 0 | Object Part Code Short Text | ||
38 | ASSEMBLY | BAUTL | MATNR | CHAR | 18 | 0 | Assembly | * | |
39 | .INCLUDE | 0 | 0 | VELO: Cause for Notification Item | |||||
40 | CAUSE_KEY | URNUM | NUM4 | NUMC | 4 | 0 | Sequential Number for Cause | ||
41 | CAUSE_SORT_NO | QURNUM | NUMC04 | NUMC | 4 | 0 | Sort Number for Cause | ||
42 | CAUSE_CAT_TYP | URKAT | QKATART | CHAR | 1 | 0 | Catalog Type - Causes | * | |
43 | CAUSE_CODE | URCOD | QCODE | CHAR | 4 | 0 | Reason Code | * | |
44 | CAUSE_CODEGRP | URGRP | QCODEGRP | CHAR | 8 | 0 | Code Group - Causes | * | |
45 | TXT_CAUSEGRP | QKTEXTGR | QKURZTEXT | CHAR | 40 | 0 | Code Group Description | ||
46 | TXT_CAUSECD | TXTCDUR | TEXT40 | CHAR | 40 | 0 | Cause Code Short Text | ||
47 | CAUSETEXT | URSTX | TEXT40 | CHAR | 40 | 0 | Cause Text | ||
48 | .INCLUDE | 0 | 0 | VELO: Measures for Notification Item | |||||
49 | TASK_KEY | MANUM | NUM4 | NUMC | 4 | 0 | Sequential Task Number | ||
50 | TASK_SORT_NO | QSMNUM | NUMC04 | NUMC | 4 | 0 | Sort number for task | ||
51 | TASK_CAT_TYP | MAKAT | QKATART | CHAR | 1 | 0 | Catalog Type - Tasks | * | |
52 | TASK_CODEGRP | MAGRP | QCODEGRP | CHAR | 8 | 0 | Code group - Tasks | * | |
53 | TASK_CODE | MNCOD | QCODE | CHAR | 4 | 0 | Task code | * | |
54 | TXT_TASKGRP | QKTEXTGR | QKURZTEXT | CHAR | 40 | 0 | Code Group Description | ||
55 | TXT_TASKCD | TXTCDSM | TEXT40 | CHAR | 40 | 0 | Task Code Short Text | ||
56 | TASK_TEXT | MATXT | TEXT40 | CHAR | 40 | 0 | Short text for task | ||
57 | PARTN_ROLE | QMSM_PARVW | PARVW | CHAR | 2 | 0 | Function of Person Responsible for Task | TPAR | |
58 | PARTNER | QMSM_PARNR | I_PARNR | CHAR | 12 | 0 | Person responsible for the task (partner number) | ||
59 | PLND_START_DATE | PSTER | DATUM | DATS | 8 | 0 | Planned start date | ||
60 | PLND_START_TIME | PSTUR | UZEIT | TIMS | 6 | 0 | Planned Start Time for Task | ||
61 | PLND_END_DATE | PETER | DATUM | DATS | 8 | 0 | Planned finish date | ||
62 | PLND_END_TIME | PETUR | UZEIT | TIMS | 6 | 0 | Planned finish time for task | ||
63 | CARRIED_OUT_BY | QMSMERLNAM | USNAM | CHAR | 12 | 0 | Person who carried out the task | ||
64 | STATUS | QMSTTXT | TEXT40 | CHAR | 40 | 0 | System Status for Notification | ||
65 | OBJECT_NO | QMOBJNR | J_OBJNR | CHAR | 22 | 0 | Object Number for Status Management | * | |
66 | .INCLUDE | 0 | 0 | VELO: Actions for Notification Item | |||||
67 | ACT_KEY | AKNUM | NUM4 | NUMC | 4 | 0 | Consecutive Number of Activity | ||
68 | ACT_CAT_TYP | MFKAT | QKATART | CHAR | 1 | 0 | Catalog Type - Actions | * | |
69 | ACT_CODEGRP | MFGRP | QCODEGRP | CHAR | 8 | 0 | Code group - Activities | * | |
70 | ACT_CODE | MFCOD | QCODE | CHAR | 4 | 0 | Action Code | * | |
71 | ACTTEXT | VLC_MFTXT | VLC_MFTXT | CHAR | 38 | 0 | Description of Registration Field | ||
72 | CREATED_BY | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
73 | CREATED_DATE | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
74 | CHANGED_BY | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
75 | CHANGED_DATE | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
76 | START_DATE | PSTERMA | DATUM | DATS | 8 | 0 | Start Date | ||
77 | END_DATE | PETERMA | DATUM | DATS | 8 | 0 | End Date | ||
78 | LONG_TEXT | INDLTX | CHAR1 | CHAR | 1 | 0 | Object Long Text Available | ||
79 | PRILANG | KZMLA | CHAR1 | CHAR | 1 | 0 | Primary language indicator for text segment | ||
80 | START_TIME | PSTURMA | UZEIT | TIMS | 6 | 0 | Start Time of Activity | ||
81 | END_TIME | PETURMA | UZEIT | TIMS | 6 | 0 | End Time of Activity | ||
82 | CREATED_TIME | ERZEIT | UHRZT | TIMS | 6 | 0 | Time, at Which Record Was Added | ||
83 | CHANGED_TIME | AEZEIT | UHRZT | TIMS | 6 | 0 | Time of Change | ||
84 | DELETE_FLAG | KZLOESCH | CHAR1 | CHAR | 1 | 0 | Delete Data Record | ||
85 | ACT_SORT_NO | QMANUM | NUMC04 | NUMC | 4 | 0 | Sort Number for Activity | ||
86 | TXT_ACTGRP | QKTEXTGR | QKURZTEXT | CHAR | 40 | 0 | Code Group Description | ||
87 | TXT_ACTCD | TXTCDMA | TEXT40 | CHAR | 40 | 0 | Activity Code Short Text | ||
88 | .INCLUDE | 0 | 0 | VELO: Confirmation Structure Components in Service Order | |||||
89 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
90 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * | |
91 | ERFMG | MB_ERFMG | MENG13 | QUAN | 13 | 3 | Quantity in Unit of Entry | ||
92 | ERFME | ERFME | MEINS | UNIT | 3 | 0 | Unit of entry | T006 | |
93 | ISMNW_2 | ISMNW_2 | ARBEIT_2 | QUAN | 8 | 2 | Actual Work | ||
94 | ISMNU | ARBEITE | MEINS | UNIT | 3 | 0 | Unit for work | T006 | |
95 | OFMNW | REMNW | ARBEIT | QUAN | 7 | 1 | Remaining work | ||
96 | OFMNE | OFMNE | MEINS | UNIT | 3 | 0 | Unit of measure for remaining work | T006 | |
97 | AUERU | AUERU_VS | AUERU_VS | CHAR | 1 | 0 | Partial/Final Confirmation | ||
98 | SOBKZ | SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | T148 | |
99 | BWART | BWART | BWART | CHAR | 3 | 0 | Movement type (inventory management) | T156 | |
100 | LIFNR | ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | * | |
101 | BEMOT | BEMOT | BEMOT | CHAR | 2 | 0 | Accounting Indicator | TBMOT | |
102 | LEARR | LEARR | LSTAR | CHAR | 6 | 0 | Activity type for confirmation | * | |
103 | LOART | LOHNART | LOART | CHAR | 4 | 0 | Wage type |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | VLCACTDATA_SUBITEM_SM_S | ARBEH | T006 | MSEHI | |||
2 | VLCACTDATA_SUBITEM_SM_S | BEMOT | TBMOT | BEMOT | |||
3 | VLCACTDATA_SUBITEM_SM_S | BWART | T156 | BWART | |||
4 | VLCACTDATA_SUBITEM_SM_S | DAUNE | T006 | MSEHI | |||
5 | VLCACTDATA_SUBITEM_SM_S | ERFME | T006 | MSEHI | |||
6 | VLCACTDATA_SUBITEM_SM_S | ISMNU | T006 | MSEHI | |||
7 | VLCACTDATA_SUBITEM_SM_S | LGORT | T001L | LGORT | |||
8 | VLCACTDATA_SUBITEM_SM_S | OFMNE | T006 | MSEHI | |||
9 | VLCACTDATA_SUBITEM_SM_S | PARTN_ROLE | TPAR | PARVW | |||
10 | VLCACTDATA_SUBITEM_SM_S | SOBKZ | T148 | SOBKZ | |||
11 | VLCACTDATA_SUBITEM_SM_S | STEUS | T430 | STEUS | |||
12 | VLCACTDATA_SUBITEM_SM_S | WERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 46C |