LYACT

Transparent Table Application Table
43 Fields 1 CDS Views

Yard activities

LYACT is an SAP database table in S/4HANA. Yard activities. It contains 43 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
WM_BRIDGE_ACT_YM view left_outer WM bridge YARD

Fields (43)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY lyard LXYRD_YARD Yard
KEY actvy LXYRD_ACTVY Activity
actty LXYRD_ACTTY Activity Type
actst LXYRD_ACTST Activity Status
venum LEINT_VENUM Internal HU no.
ylcclfr LXYRD_YLCCL Loc. Class
yloctfr LXYRD_YLOCT Location
ylcclto LXYRD_YLCCL Loc. Class
yloctto LXYRD_YLOCT Location
glcgr LXYRD_GLCGR Location Group
prrty LXYRD_OBPRI Veh.Priority
ptmsf LXYRD_PTMSF Plnd Start Time
ptmst LXYRD_PTMST Plnd End Time
atmsf LXYRD_ATMSF Actl Start Time
atmst LXYRD_ATMST Actual End Time
xdind LXYRD_XDIND X-Dock Indicaor
weght LXYRD_WEGHT Vehicle Weight
tdvtn LXYRD_DVITN Time Deviation
rsncd LXYRD_RSNCD Reason Code
fwagn LXYRD_FWAGN Fwd. Agent
scacd LEINT_SCACD SCAC
aucnf LXYRD_AUCNF Auto-confirm
sealn1 LXYRD_SEALN Sealing Number
sealn2 LXYRD_SEALN Sealing Number
sealn3 LXYRD_SEALN Sealing Number
sealn4 LXYRD_SEALN Sealing Number
sealn5 LXYRD_SEALN Sealing Number
exidv2 LXYRD_LCSPL License Plate
signi LEINT_SIGNI Container ID
namef LEINT_NAMEF Driver
rftyp LXYRD_RFDTY Ref. Doc. Type
refer LXYRD_DOCRF Ref. Document
stats LXYRD_OBSTS Vehcle Status
ltext LXYRD_TEXT_DE Text
tstmpins LXHME_TSTMP Time Stamp
unameins UNAM Last changed by
tcodeins SYTCODE Transaction code
saprlins SYSAPRL SAP Release
tstmpupd LXHME_TSTMP Time Stamp
unameupd UNAM Last changed by
tcodeupd SYTCODE Transaction code
saprlupd SYSAPRL SAP Release

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Yard activities
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LYACT (
    MANDT,     -- Client [MANDT]
    LYARD,     -- Yard [LXYRD_YARD]
    ACTVY,     -- Activity [LXYRD_ACTVY]
    ACTTY,     -- Activity Type [LXYRD_ACTTY]
    ACTST,     -- Activity Status [LXYRD_ACTST]
    VENUM,     -- Internal HU no. [LEINT_VENUM]
    YLCCLFR,   -- Loc. Class [LXYRD_YLCCL]
    YLOCTFR,   -- Location [LXYRD_YLOCT]
    YLCCLTO,   -- Loc. Class [LXYRD_YLCCL]
    YLOCTTO,   -- Location [LXYRD_YLOCT]
    GLCGR,     -- Location Group [LXYRD_GLCGR]
    PRRTY,     -- Veh.Priority [LXYRD_OBPRI]
    PTMSF,     -- Plnd Start Time [LXYRD_PTMSF]
    PTMST,     -- Plnd End Time [LXYRD_PTMST]
    ATMSF,     -- Actl Start Time [LXYRD_ATMSF]
    ATMST,     -- Actual End Time [LXYRD_ATMST]
    XDIND,     -- X-Dock Indicaor [LXYRD_XDIND]
    WEGHT,     -- Vehicle Weight [LXYRD_WEGHT]
    TDVTN,     -- Time Deviation [LXYRD_DVITN]
    RSNCD,     -- Reason Code [LXYRD_RSNCD]
    FWAGN,     -- Fwd. Agent [LXYRD_FWAGN]
    SCACD,     -- SCAC [LEINT_SCACD]
    AUCNF,     -- Auto-confirm [LXYRD_AUCNF]
    SEALN1,    -- Sealing Number [LXYRD_SEALN]
    SEALN2,    -- Sealing Number [LXYRD_SEALN]
    SEALN3,    -- Sealing Number [LXYRD_SEALN]
    SEALN4,    -- Sealing Number [LXYRD_SEALN]
    SEALN5,    -- Sealing Number [LXYRD_SEALN]
    EXIDV2,    -- License Plate [LXYRD_LCSPL]
    SIGNI,     -- Container ID [LEINT_SIGNI]
    NAMEF,     -- Driver [LEINT_NAMEF]
    RFTYP,     -- Ref. Doc. Type [LXYRD_RFDTY]
    REFER,     -- Ref. Document [LXYRD_DOCRF]
    STATS,     -- Vehcle Status [LXYRD_OBSTS]
    LTEXT,     -- Text [LXYRD_TEXT_DE]
    TSTMPINS,  -- Time Stamp [LXHME_TSTMP]
    UNAMEINS,  -- Last changed by [UNAM]
    TCODEINS,  -- Transaction code [SYTCODE]
    SAPRLINS,  -- SAP Release [SYSAPRL]
    TSTMPUPD,  -- Time Stamp [LXHME_TSTMP]
    UNAMEUPD,  -- Last changed by [UNAM]
    TCODEUPD,  -- Transaction code [SYTCODE]
    SAPRLUPD,  -- SAP Release [SYSAPRL]
    PRIMARY KEY (MANDT, LYARD, ACTVY)
);

Learn More