LYACT
Yard activities
LYACT is an SAP database table in S/4HANA. Yard activities. It contains 27 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| WM_BRIDGE_ACT_YM | view | left_outer | WM bridge YARD |
Fields (27)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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. | ||||
| glcgr | lxyrd_glcgr | Location Group | ||||
| prrty | lxyrd_obpri | Veh.Priority | ||||
| 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 |
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]
GLCGR, -- Location Group [lxyrd_glcgr]
PRRTY, -- Veh.Priority [lxyrd_obpri]
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]
PRIMARY KEY (MANDT, LYARD, ACTVY)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA