SAP ABAP Table LXYRDM_SHPMNT_DOC (Processed shipment documents for yard monitor)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ LE-YM (Application Component) Yard Management
⤷ LXYRD (Package) Yard Management
⤷ LE-YM (Application Component) Yard Management
⤷ LXYRD (Package) Yard Management
Basic Data
Table Category | INTTAB | Structure |
Structure | LXYRDM_SHPMNT_DOC | Table Relationship Diagram |
Short Description | Processed shipment documents for yard monitor |
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 | RFTYP | LXYRD_RFDTY | LXYRD_RFDTY | CHAR | 2 | 0 | Reference Document Type | ||
2 | REFER | LXYRD_DOCRF | LXYRD_DOCRF | CHAR | 10 | 0 | Reference Document | ||
3 | VENUM | LEINT_VENUM | VENUM | CHAR | 10 | 0 | Internal Handling Unit Number | * | |
4 | .INCLUDE | 0 | 0 | Shipment fields(vttk) to be included in other structures | |||||
5 | VBTYP | VBTYP | VBTYP | CHAR | 1 | 0 | SD document category | ||
6 | SHTYP | SHTYP | SHTYP | CHAR | 4 | 0 | Shipment type | * | |
7 | TPLST | TPLST | TPLST | CHAR | 4 | 0 | Transportation planning point | * | |
8 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
9 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
10 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
11 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
12 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
13 | AEZET | AEZET | UZEIT | TIMS | 6 | 0 | Time last change was made | ||
14 | STERM | STERM | STERM | CHAR | 1 | 0 | Leg determination | ||
15 | ABFER | ABFER | ABFER | CHAR | 1 | 0 | Shipment completion type | ||
16 | ABWST | ABWST | ABWST | CHAR | 1 | 0 | Processing control | ||
17 | BFART | BFART | BFART | CHAR | 1 | 0 | Service level | ||
18 | VSART | VSARTTR | VERSART | CHAR | 2 | 0 | Shipping type | * | |
19 | VSAVL | VSAVL | VERSART | CHAR | 2 | 0 | Shipping type of preliminary leg | * | |
20 | VSANL | VSANL | VERSART | CHAR | 2 | 0 | Shipping type of subsequent leg | * | |
21 | LAUFK | LAUFK | LAUFK | CHAR | 1 | 0 | Leg Indicator | ||
22 | VSBED | VSBED | VSBED | CHAR | 2 | 0 | Shipping conditions | * | |
23 | ROUTE | ROUTR | ROUTE | CHAR | 6 | 0 | Shipment route | * | |
24 | EXTI1 | EXTI1 | TEXT20 | CHAR | 20 | 0 | External identification 1 | ||
25 | EXTI2 | EXTI2 | TEXT20 | CHAR | 20 | 0 | External identification 2 | ||
26 | TPBEZ | TPBEZ | TEXT20 | CHAR | 20 | 0 | Description of Shipment | ||
27 | STDIS | STDIS | STTRA | CHAR | 1 | 0 | Status of transportation planning | ||
28 | DTDIS | DTDIS | DATUM | DATS | 8 | 0 | Date of end of planning | ||
29 | UZDIS | UZDIS | UZEIT | TIMS | 6 | 0 | Scheduling end time | ||
30 | STREG | STREG | STTRA | CHAR | 1 | 0 | Status of check-in | ||
31 | DPREG | DPREG | DATUM | DATS | 8 | 0 | Planned date of check-in | ||
32 | UPREG | UPREG | UZEIT | TIMS | 6 | 0 | Planned check-in time | ||
33 | DAREG | DAREG | DATUM | DATS | 8 | 0 | Actual date of check-in | ||
34 | UAREG | UAREG | UZEIT | TIMS | 6 | 0 | Current time of check-in | ||
35 | STLBG | STLBG | STTRA | CHAR | 1 | 0 | Status for start of loading | ||
36 | DPLBG | DPLBG | DATUM | DATS | 8 | 0 | Planned date for start of loading | ||
37 | UPLBG | UPLBG | UZEIT | TIMS | 6 | 0 | Planned loading start time | ||
38 | DALBG | DALBG | DATUM | DATS | 8 | 0 | Current date for start of loading | ||
39 | UALBG | UALBG | UZEIT | TIMS | 6 | 0 | Actual loading start time | ||
40 | STLAD | STLAD | STTRA | CHAR | 1 | 0 | Status for end of loading | ||
41 | DPLEN | DPLEND | DATUM | DATS | 8 | 0 | Planned date for end of loading | ||
42 | UPLEN | UPLEND | UZEIT | TIMS | 6 | 0 | Planned loading end time | ||
43 | DALEN | DALEND | DATUM | DATS | 8 | 0 | Actual date for end of loading | ||
44 | UALEN | UALEND | UZEIT | TIMS | 6 | 0 | Actual loading end time | ||
45 | STABF | STABF | STTRA | CHAR | 1 | 0 | Status of shipment completion | ||
46 | DPABF | DPABF | DATUM | DATS | 8 | 0 | Planned date for shipment completion | ||
47 | UPABF | UPABF | UZEIT | TIMS | 6 | 0 | Planned time for processing | ||
48 | DTABF | DTABF | DATUM | DATS | 8 | 0 | Current date of shipment completion | ||
49 | UZABF | UZABF | UZEIT | TIMS | 6 | 0 | Time of transportation processing | ||
50 | STTBG | STTBG | STTRA | CHAR | 1 | 0 | Status for start of shipment | ||
51 | DPTBG | DPTBG | DATUM | DATS | 8 | 0 | Planned date for start of shipment | ||
52 | UPTBG | UPTBG | UZEIT | TIMS | 6 | 0 | Planned transport start time | ||
53 | DATBG | DATBG | DATUM | DATS | 8 | 0 | Current date for start of shipment | ||
54 | UATBG | UATBG | UZEIT | TIMS | 6 | 0 | Actual transport start time | ||
55 | STTEN | STTEN | STTRA | CHAR | 1 | 0 | Status for end of shipment | ||
56 | DPTEN | DPTEN | DATUM | DATS | 8 | 0 | Planned date for end of shipment | ||
57 | UPTEN | UPTEN | UZEIT | TIMS | 6 | 0 | Planned transport end time | ||
58 | DATEN | DATEND | DATUM | DATS | 8 | 0 | Actual Date for End of Shipment | ||
59 | UATEN | UATEND | UZEIT | TIMS | 6 | 0 | Actual shipment end time | ||
60 | STTRG | STTRG | STTRG | CHAR | 1 | 0 | Overall transportation status | ||
61 | TDLNR | TDLNR | LIFNR | CHAR | 10 | 0 | Number of forwarding agent | * | |
62 | TERNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | * | |
63 | PKSTK | PKSTK_VTTK | XFELD | CHAR | 1 | 0 | Shipment Contains Handling Units | ||
64 | DTMEG | DTMEG | MEINS | UNIT | 3 | 0 | Unit of Weight for Transportation Planning | * | |
65 | DTMEV | DTMEV | MEINS | UNIT | 3 | 0 | Volume Unit for Transportation Planning | * | |
66 | DISTZ | DISTZ | MENG13 | QUAN | 13 | 3 | Distance | ||
67 | MEDST | MEDST | MEINS | UNIT | 3 | 0 | Unit of measure for distance | * | |
68 | FAHZT | FAHZT | FAHZT | QUAN | 5 | 2 | Travelling time only between two locations | ||
69 | GESZT | GESZT | FAHZT | QUAN | 5 | 2 | Total travelling time between two locations incl. breaks | ||
70 | MEIZT | MEIZT | MEINS | UNIT | 3 | 0 | Unit of measure for travelling times | * | |
71 | STAFO | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | * | |
72 | FBSTA | FBSTA | FBSTA | CHAR | 1 | 0 | Status of shipment costs calculation | ||
73 | FBGST | FBGST | FBGST | CHAR | 1 | 0 | Overall status of calculation of shipment costs for shipment | ||
74 | ARSTA | ARSTA | ARSTA | CHAR | 1 | 0 | Status of shipment costs settlement | ||
75 | ARGST | ARGST | ARGST | CHAR | 1 | 0 | Total status of shipment costs settlement for shipment | ||
76 | STERM_DONE | STERM_DONE | STERM_DONE | CHAR | 1 | 0 | Leg determination complete | ||
77 | VSE_FRK | VSE_FRK | VSE_FRK | CHAR | 1 | 0 | Handling Unit Data are Referred in Shipment Cost Document | ||
78 | KKALSM | KALSM_KOPF | KALSM | CHAR | 6 | 0 | Pricing procedure in shipment header | * | |
79 | SDABW | SDABW | SDABW | CHAR | 4 | 0 | Special Processing Indicator | * | |
80 | FRKRL | KFRKRL | FRKRL | CHAR | 1 | 0 | Shipment costs relevance | ||
81 | GESZTD | KP_GESZTDP | TSTRDURAG | DEC | 11 | 0 | Planned total time of transportation (in days) | ||
82 | FAHZTD | KP_EFFZTDP | TSTRDURAN | DEC | 11 | 0 | Planned duration of transportation (in hours:minutes) | ||
83 | GESZTDA | KP_GESZTDA | TSTRDURAG | DEC | 11 | 0 | Actual total time of shipment (in days) | ||
84 | FAHZTDA | KP_EFFZTDA | TSTRDURAN | DEC | 11 | 0 | Actual time needed for transporation (in hours:minutes) | ||
85 | ROCPY_DONE | ROCPY_DONE | ROCPY_DONE | CHAR | 1 | 0 | Route copied from delivery | ||
86 | HANDLE | TSEGGUID | SYSUUID_22 | CHAR | 22 | 0 | Globally unique identifier (linked to time segment, etc) | ||
87 | TSEGFL | TSEGEXISTS | FLAG | CHAR | 1 | 0 | Time segment exists | ||
88 | TSEGTP | TSEGTPLVTT | TSEGTEMPLA | CHAR | 10 | 0 | Time segment event group shipment header | * | |
89 | ADD01 | VTTK_ADD01 | VTTK_ADD01 | CHAR | 10 | 0 | Suppl. 1 | * | |
90 | ADD02 | VTTK_ADD02 | VTTK_ADD02 | CHAR | 10 | 0 | Suppl. 2 | * | |
91 | ADD03 | VTTK_ADD03 | VTTK_ADD03 | CHAR | 10 | 0 | Suppl. 3 | * | |
92 | ADD04 | VTTK_ADD04 | VTTK_ADD04 | CHAR | 10 | 0 | Suppl. 4 | * | |
93 | TEXT1 | VTTK_TEXT1 | TEXT40 | CHAR | 40 | 0 | Addit.text 1 | ||
94 | TEXT2 | VTTK_TEXT2 | TEXT40 | CHAR | 40 | 0 | Addit.text 2 | ||
95 | TEXT3 | VTTK_TEXT3 | TEXT40 | CHAR | 40 | 0 | Addit.text 3 | ||
96 | TEXT4 | VTTK_TEXT4 | TEXT40 | CHAR | 40 | 0 | Addit.text 4 | ||
97 | PROLI | ADGE_PROLI | ADGD_PROLI | CHAR | 3 | 0 | Dangerous Goods Management Profile in SD Documents | * | |
98 | DGTLOCK | ADGE_TLOCK | X | CHAR | 1 | 0 | Block Indicator for Dangerous Goods | ||
99 | DGMDDAT | ADGE_MDDAT | DATUM | DATS | 8 | 0 | Selection date dangerous goods master data | ||
100 | CONT_DG | ADGE_NCDG | X | CHAR | 1 | 0 | Indicator: Document contains dangerous goods | ||
101 | WARZTD | KP_WARZTDP | TSTRDURAN | DEC | 11 | 0 | Planned waiting time of shipment (in hours:minutes) | ||
102 | WARZTDA | KP_WARZTDA | TSTRDURAN | DEC | 11 | 0 | Current waiting time of shipment (in hours:minutes) | ||
103 | AULWE | AULWE | AULWE | CHAR | 10 | 0 | Route Schedule | * | |
104 | TNDRST | TNDRST | TNDRST | CHAR | 2 | 0 | Tender Status | ||
105 | TNDRRC | TNDRRC | TNDRRC | CHAR | 2 | 0 | Acceptance Condition/Rejection Reason | ||
106 | TNDR_TEXT | TNDR_TEXT | TEXT80 | CHAR | 80 | 0 | Tendering Text | ||
107 | TNDRDAT | TNDRDAT | DATUM | DATS | 8 | 0 | Date of tender status | ||
108 | TNDRZET | TNDRZET | UZEIT | TIMS | 6 | 0 | Time of tender status | ||
109 | TNDR_MAXP | TNDR_MAXP | WERT15 | CURR | 15 | 2 | Maximum Price for Shipment | ||
110 | TNDR_MAXC | TNDR_MAXC | WAERS | CUKY | 5 | 0 | Currency of Maximum Price | * | |
111 | TNDR_ACTP | TNDR_ACTP | WERT15 | CURR | 15 | 2 | Actual Shipment Costs for Shipment | ||
112 | TNDR_ACTC | TNDR_ACTC | WAERS | CUKY | 5 | 0 | Currency of Actual Shipment Costs | * | |
113 | TNDR_CARR | TNDR_CARR | TEXT10 | CHAR | 10 | 0 | Forwarding Agent Who Accepted the Shipment | ||
114 | TNDR_CRNM | TNDR_CRNM | NAME | CHAR | 35 | 0 | Name of Carrier Who Accepted the Shipment | ||
115 | TNDR_TRKID | TNDR_TRKID | TEXT35 | CHAR | 35 | 0 | Forwarding Agent Tracking ID | ||
116 | TNDR_EXPD | TNDR_EXPD | DATUM | DATS | 8 | 0 | Date on Which Offer Expires | ||
117 | TNDR_EXPT | TNDR_EXPT | UZEIT | TIMS | 6 | 0 | Time at Which Quotation Expires | ||
118 | TNDR_ERPD | TNDR_ERPD | DATUM | DATS | 8 | 0 | Earliest Pickup Date | ||
119 | TNDR_ERPT | TNDR_ERPT | UZEIT | TIMS | 6 | 0 | Earliest Pickup Time | ||
120 | TNDR_LTPD | TNDR_LTPD | DATUM | DATS | 8 | 0 | Latest Pickup Date | ||
121 | TNDR_LTPT | TNDR_LTPT | UZEIT | TIMS | 6 | 0 | Latest Pickup Time | ||
122 | TNDR_ERDD | TNDR_ERDD | DATUM | DATS | 8 | 0 | Earliest Delivery Date | ||
123 | TNDR_ERDT | TNDR_ERDT | UZEIT | TIMS | 6 | 0 | Earliest Delivery Time | ||
124 | TNDR_LTDD | TNDR_LTDD | DATUM | DATS | 8 | 0 | Latest Delivery Date | ||
125 | TNDR_LTDT | TNDR_LTDT | UZEIT | TIMS | 6 | 0 | Latest Delivery Time | ||
126 | TNDR_LDLG | TNDR_LDLG | MENG13 | QUAN | 13 | 3 | Length of Loading Platform | ||
127 | TNDR_LDLU | TNDR_LDLU | MEINS | UNIT | 3 | 0 | Unit of Measure for Load Length | * | |
128 | KZHULFR | KZHULFR | KZHULFR | CHAR | 1 | 0 | Indicator: HUs Relevant for Delivery Item Generation | ||
129 | ALLOWED_TWGT | ALLOWED_TWGT | MENG12_0 | QUAN | 8 | 0 | Allowed total weight of shipment | ||
130 | VLSTK | VLSTK | VLSTK | CHAR | 1 | 0 | Distribution Status (Decentralized Warehouse Processing) | ||
131 | VERURSYS | TRA_VERURSYS | LOGSYS | CHAR | 10 | 0 | Shipment Distribution: Original System | * | |
132 | .INCLUDE | 0 | 0 | HU fields(vekp) to be included in other structures | |||||
133 | EXIDV | EXIDV | EXIDV | CHAR | 20 | 0 | External Handling Unit Identification | ||
134 | EXIDV2 | LXYRD_LCSPL | LXYRD_LCSPL | CHAR | 20 | 0 | License Plate | ||
135 | SIGNI | SIGNI | TEXT20 | CHAR | 20 | 0 | Container ID | ||
136 | NAMEF | NAMEF | NAME | CHAR | 35 | 0 | Driver name | ||
137 | LANDF | LANDF | LAND1 | CHAR | 3 | 0 | Driver's Nationality | * | |
138 | NAMBE | NAMBE | NAME | CHAR | 35 | 0 | Passenger's name | ||
139 | OWNER | LXYRD_OWNER | CHAR10 | CHAR | 10 | 0 | Vehicle Owner | ||
140 | FWAGN | LXYRD_FWAGN | LIFNR | CHAR | 10 | 0 | Forwarding Agent | * | |
141 | TRNPD | LXYRD_TRNPD | CHAR20 | CHAR | 20 | 0 | Transponder | ||
142 | VHILM | LEINT_YVHILM | MATNR | CHAR | 18 | 0 | Vehicle Type | * | |
143 | VHART | LEINT_VHIART | TRATY | CHAR | 4 | 0 | Vehicle Type Group | TVTY | |
144 | VELTP | LEINT_VELTP | VELTP | CHAR | 1 | 0 | Vehicle Category | ||
145 | PRRTY | LXYRD_PRRTY | CHAR2 | CHAR | 2 | 0 | Vehicle Priority | ||
146 | STATS | LXYRD_OBSTS | LXYRD_HUSTS | CHAR | 2 | 0 | Vehicle Stock Status | ||
147 | LYARD | LXYRD_YARD | LXYRD_YARD | CHAR | 3 | 0 | Yard | * | |
148 | YLCCL | LXYRDM_YLCCL | LXYRDM_YLCCL | CHAR | 2 | 0 | Location Class | ||
149 | YLOCT | LXYRD_YLOCT | CHAR10 | CHAR | 10 | 0 | Location | * | |
150 | BLIND | LXYRD_BLOCK | XFELD | CHAR | 1 | 0 | Block | ||
151 | RSNCD | LXYRD_RSNCD | CHAR2 | CHAR | 2 | 0 | Reason Code | LYRSN | |
152 | SCACD | SCACD | SCACD | CHAR | 4 | 0 | Standard carrier access code | ||
153 | PRFLG | LXYRD_PRFLG | FLAG | CHAR | 1 | 0 | Permanence of Vehicle in Yard | ||
154 | SLFLG | LXYRD_SLFLG | FLAG | CHAR | 1 | 0 | Sealing Required | ||
155 | LTEXT | LXYRD_TEXT_DE | TEXT40 | CHAR | 40 | 0 | Text | ||
156 | .INCLUDE | 0 | 0 | Additional HU fields which calculate for layout purpose | |||||
157 | YSTATS | LXYRD_YSTATS | LXYRD_YSTATS | CHAR | 2 | 0 | Processing Status | ||
158 | SCHFL | LXYRD_SCHFL | FLAG | CHAR | 1 | 0 | Location Scheduled for Vehicle | ||
159 | SCLCL | LXYRD_SCLCL | LXYRD_SCLCL | CHAR | 2 | 0 | Scheduling Location Class | ||
160 | SCLOC | LXYRD_SCLOC | CHAR10 | CHAR | 10 | 0 | Scheduled Location | ||
161 | SCSTM | LXYRD_SCSTM | LXHME_TSTMP | DEC | 15 | 0 | Scheduled Start Time | ||
162 | SCETM | LXYRD_PTMST | LXHME_TSTMP | DEC | 15 | 0 | Planned End Time | ||
163 | .INCLU-SCH | 0 | 0 | Actual timestamps | |||||
164 | ATMSFSCH | LXYRD_ATMSF | LXHME_TSTMP | DEC | 15 | 0 | Actual Start Time | ||
165 | ATMSTSCH | LXYRD_ATMST | LXHME_TSTMP | DEC | 15 | 0 | Actual End Time of Yard Activity | ||
166 | TMIYD | LXYRD_TMIYD | LXYRD_DURTN | QUAN | 10 | 3 | Time in the Yard | ||
167 | .INCLUDE | 0 | 0 | Actual timestamps | |||||
168 | ATMSF | LXYRD_ATMSF | LXHME_TSTMP | DEC | 15 | 0 | Actual Start Time | ||
169 | ATMST | LXYRD_ATMST | LXHME_TSTMP | DEC | 15 | 0 | Actual End Time of Yard Activity |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | LXYRDM_SHPMNT_DOC | RSNCD | LYRSN | RSNCD | REF | 1 | CN |
2 | LXYRDM_SHPMNT_DOC | VHART | TVTY | TRATY | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 200 |