SAP table LYACT (Yard activities)
SAP table LYACT has 3 primary key fields being MANDT,LYARD,ACTVY.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
*
MANDT
Yard
CHAR
3
0
LYYRD
LXYRD_YARD
Activity Number
NUMC
10
0
LXYRD_ACTVY
ACTTY
Activity Type
CHAR
2
0
LXYRD_ACTTY
Possible values
01
Check-in
02
Check-out
03
Loading
04
Unloading
05
Movement
06
Scheduling
07
Weighing
08
Block
09
Un-block
10
Sealing
11
Un-sealing
ACTST
Activity Status
CHAR
1
0
LXYRD_ACTST
Possible values
1
Planned
2
Started
4
Completed
5
Cancelled
6
Vehicle departed
VENUM
Internal Handling Unit Number
CHAR
10
0
*
LEINT_VENUM
YLCCLFR
Location Class
CHAR
2
0
LXYRD_YLCCL
Possible values
01
External location
02
Checkpoint
03
Parking space
04
Weighing point
05
Door
06
Staging area
YLOCTFR
Location
CHAR
10
0
LYLOC
LXYRD_YLOCT
YLCCLTO
Location Class
CHAR
2
0
LXYRD_YLCCL
Possible values
01
External location
02
Checkpoint
03
Parking space
04
Weighing point
05
Door
06
Staging area
YLOCTTO
Location
CHAR
10
0
LYLOC
LXYRD_YLOCT
GLCGR
Location Group
CHAR
3
0
LXYRD_GLCGR
PRRTY
Vehicle Priority
CHAR
1
0
LXYRD_OBPRI
PTMSF
Planned Start Time
DEC
15
0
LXYRD_PTMSF
PTMST
Planned End Time
DEC
15
0
LXYRD_PTMST
ATMSF
Actual Start Time
DEC
15
0
LXYRD_ATMSF
ATMST
Actual End Time of Yard Activity
DEC
15
0
LXYRD_ATMST
XDIND
Cross-Docking
CHAR
1
0
LXYRD_XDIND
WEGHT
Vehicle Weight
QUAN
15
3
LXYRD_WEGHT
TDVTN
Time Deviation
NUMC
3
0
LXYRD_DVITN
RSNCD
Reason Code
CHAR
2
0
LXYRD_RSNCD
FWAGN
Forwarding Agent
CHAR
10
0
*
LXYRD_FWAGN
SCACD
Standard carrier access code
CHAR
4
0
LEINT_SCACD
AUCNF
Enable Automatic Confirmation
CHAR
1
0
LXYRD_AUCNF
SEALN1
Sealing Number
CHAR
10
0
LXYRD_SEALN
SEALN2
Sealing Number
CHAR
10
0
LXYRD_SEALN
SEALN3
Sealing Number
CHAR
10
0
LXYRD_SEALN
SEALN4
Sealing Number
CHAR
10
0
LXYRD_SEALN
SEALN5
Sealing Number
CHAR
10
0
LXYRD_SEALN
EXIDV2
License Plate
CHAR
20
0
LXYRD_LCSPL
SIGNI
Container ID
CHAR
20
0
LEINT_SIGNI
NAMEF
Name of Driver
CHAR
35
0
LEINT_NAMEF
RFTYP
Reference Document Type
CHAR
2
0
LXYRD_RFDTY
Possible values
01
Outbound Delivery
03
Inbound Delivery
04
Outbound Shipment
05
Inbound Shipment
08
Non-SAP Document
33
Return Delivery
35
Return Shipment
REFER
Reference Document
CHAR
10
0
LXYRD_DOCRF
STATS
Vehicle Stock Status
CHAR
2
0
LXYRD_OBSTS
LTEXT
Text
CHAR
40
0
LXYRD_TEXT_DE
TSTMPINS
Time Stamp
DEC
15
0
LXHME_TSTMP
UNAMEINS
Last changed by
CHAR
12
0
UNAM
TCODEINS
Transaction Code
CHAR
20
0
*
SYTCODE
SAPRLINS
Release of SAP System
CHAR
4
0
SYSAPRL
TSTMPUPD
Time Stamp
DEC
15
0
LXHME_TSTMP
UNAMEUPD
Last changed by
CHAR
12
0
UNAM
TCODEUPD
Transaction Code
CHAR
20
0
*
SYTCODE
SAPRLUPD
Release of SAP System
CHAR
4
0
SYSAPRL
LYACT foreign key relationships
Table
Field
Check Table
Check Field
0 LYACT
YLOCTFR
LYLOC Yard location
MANDT
0 LYACT
YLOCTFR
LYLOC Yard location
LYARD
0 LYACT
YLOCTFR
LYLOC Yard location
YLCCL
0 LYACT
YLOCTFR
LYLOC Yard location
YLOCT
1 LYACT
YLOCTTO
LYLOC Yard location
MANDT
1 LYACT
YLOCTTO
LYLOC Yard location
LYARD
1 LYACT
YLOCTTO
LYLOC Yard location
YLCCL
1 LYACT
YLOCTTO
LYLOC Yard location
YLOCT