1. Home
  2. Resources
  3. SAP Tables
  4. LYACT - Yard activities

SAP Table LYACT

Yard activities

LYACT (Yard activities) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link LYACT to other SAP tables.

LYACT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
LYARD Yard LXYRD_YARD LYYRD CHAR 3 0
ACTVY Activity Number LXYRD_ACTVY NUMC 10 0
ACTTY Activity Type LXYRD_ACTTY CHAR 2 0
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 LXYRD_ACTST CHAR 1 0
1 Planned
2 Started
4 Completed
5 Cancelled
6 Vehicle departed
VENUM Internal Handling Unit Number LEINT_VENUM CHAR 10 0
YLCCLFR Location Class LXYRD_YLCCL CHAR 2 0
01 External location
02 Checkpoint
03 Parking space
04 Weighing point
05 Door
06 Staging area
YLOCTFR Location LXYRD_YLOCT LYLOC CHAR 10 0
YLCCLTO Location Class LXYRD_YLCCL CHAR 2 0
01 External location
02 Checkpoint
03 Parking space
04 Weighing point
05 Door
06 Staging area
YLOCTTO Location LXYRD_YLOCT LYLOC CHAR 10 0
GLCGR Location Group LXYRD_GLCGR CHAR 3 0
PRRTY Vehicle Priority LXYRD_OBPRI CHAR 1 0
PTMSF Planned Start Time LXYRD_PTMSF DEC 15 0
PTMST Planned End Time LXYRD_PTMST DEC 15 0
ATMSF Actual Start Time LXYRD_ATMSF DEC 15 0
ATMST Actual End Time of Yard Activity LXYRD_ATMST DEC 15 0
XDIND Cross-Docking LXYRD_XDIND CHAR 1 0
X Yes
NULL No
WEGHT Vehicle Weight LXYRD_WEGHT QUAN 15 3
TDVTN Time Deviation LXYRD_DVITN NUMC 3 0
RSNCD Reason Code LXYRD_RSNCD CHAR 2 0
FWAGN Forwarding Agent LXYRD_FWAGN CHAR 10 0
SCACD Standard carrier access code LEINT_SCACD CHAR 4 0
AUCNF Enable Automatic Confirmation LXYRD_AUCNF CHAR 1 0
X Yes
NULL No
SEALN1 Sealing Number LXYRD_SEALN CHAR 10 0
SEALN2 Sealing Number LXYRD_SEALN CHAR 10 0
SEALN3 Sealing Number LXYRD_SEALN CHAR 10 0
SEALN4 Sealing Number LXYRD_SEALN CHAR 10 0
SEALN5 Sealing Number LXYRD_SEALN CHAR 10 0
EXIDV2 License Plate LXYRD_LCSPL CHAR 20 0
SIGNI Container ID LEINT_SIGNI CHAR 20 0
NAMEF Name of Driver LEINT_NAMEF CHAR 35 0
RFTYP Reference Document Type LXYRD_RFDTY CHAR 2 0
01 Outbound Delivery
03 Inbound Delivery
33 Return Delivery
04 Outbound Shipment
05 Inbound Shipment
35 Return Shipment
08 Non-SAP Document
REFER Reference Document LXYRD_DOCRF CHAR 10 0
STATS Vehicle Stock Status LXYRD_OBSTS CHAR 2 0
01 Empty
02 Partially full
03 Full
CO Checked-Out vehicle
LTEXT Text LXYRD_TEXT_DE CHAR 40 0
TSTMPINS Time Stamp LXHME_TSTMP DEC 15 0
UNAMEINS Last changed by UNAM CHAR 12 0
TCODEINS Transaction Code SYTCODE CHAR 20 0
SAPRLINS Release of SAP System SYSAPRL CHAR 4 0
TSTMPUPD Time Stamp LXHME_TSTMP DEC 15 0
UNAMEUPD Last changed by UNAM CHAR 12 0
TCODEUPD Transaction Code SYTCODE CHAR 20 0
SAPRLUPD Release of SAP System SYSAPRL CHAR 4 0

LYACT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
LYACT LYARD LYACT MANDT LYYRD Yard MANDT
LYACT LYARD LYACT LYARD LYYRD Yard LYARD
LYACT YLOCTFR LYACT YLCCLFR LYLOC Yard location YLCCL
LYACT YLOCTFR LYACT YLOCTFR LYLOC Yard location YLOCT
LYACT YLOCTFR SYST MANDT LYLOC Yard location MANDT
LYACT YLOCTFR * LYLOC Yard location LYARD
LYACT YLOCTTO LYACT YLOCTTO LYLOC Yard location YLOCT
LYACT YLOCTTO SYST MANDT LYLOC Yard location MANDT
LYACT YLOCTTO * LYLOC Yard location LYARD
LYACT YLOCTTO LYACT YLCCLTO LYLOC Yard location YLCCL