SAP Table LXYRDM_DLVRY_SELECT

Processed delivery documents for yard monitor

LXYRDM_DLVRY_SELECT (Processed delivery documents for yard monitor) 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 LXYRDM_DLVRY_SELECT to other SAP tables.

LXYRDM_DLVRY_SELECT table fields

Field Data element Checktable Datatype Length Decimals
DOCRF Reference Document LXYRD_DOCRF CHAR 10 0
DOCPR Reference Document Priority LXHME_DOCPR NUMC 2 0
BPRTN Business Partner LXHME_BPRTN CHAR 10 0
SHPNR Shipment LXHME_SHPNR CHAR 10 0
SHPST Shipment Status LXHME_SHPST NUMC 2 0
EXIDV External Handling Unit Identification EXIDV CHAR 20 0
EXIDV2 License Plate LXYRD_LCSPL CHAR 20 0
SIGNI Container ID SIGNI CHAR 20 0
NAMEF Driver name NAMEF CHAR 35 0
LANDF Driver's Nationality LANDF CHAR 3 0
NAMBE Alternate Driver's Name NAMBE CHAR 35 0
OWNER Vehicle Owner LXYRD_OWNER CHAR 10 0
FWAGN Forwarding Agent LXYRD_FWAGN CHAR 10 0
TRNPD Transponder LXYRD_TRNPD CHAR 20 0
VHILM Vehicle Type LEINT_YVHILM CHAR 18 0
VHART Vehicle Type Group LEINT_VHIART TVTY CHAR 4 0
VELTP Vehicle Category LEINT_VELTP CHAR 1 0
A Means of transport
B Transport equipment
C Packaging materials
D Auxiliary packaging material
PRRTY Vehicle Priority LXYRD_PRRTY CHAR 2 0
STATS Vehicle Stock Status LXYRD_OBSTS CHAR 2 0
01 Empty
02 Partially full
03 Full
CO Checked-Out vehicle
LYARD Yard LXYRD_YARD CHAR 3 0
YLCCL Location Class LXYRDM_YLCCL CHAR 2 0
01 External location
02 Checkpoint
03 Parking space
04 Weighing point
05 Door
YLOCT Location LXYRD_YLOCT CHAR 10 0
BLIND Block LXYRD_BLOCK CHAR 1 0
X Yes
NULL No
RSNCD Reason Code LXYRD_RSNCD LYRSN CHAR 2 0
SCACD Standard carrier access code SCACD CHAR 4 0
PRFLG Permanence of Vehicle in Yard LXYRD_PRFLG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
SLFLG Sealing Required LXYRD_SLFLG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
LTEXT Text LXYRD_TEXT_DE CHAR 40 0
YSTATS Processing Status LXYRD_YSTATS CHAR 2 0
01 Vehicle inside yard
02 Vehicle outside yard
03 Vehicle blocked
04 Vehicle being loaded
05 Vehicle loaded
06 Vehicle being unloaded
07 Vehicle unloaded
08 Vehicle awaiting loading
09 Vehicle awaiting unloading
10 Vehicle checked-out
SCHFL Location Scheduled for Vehicle LXYRD_SCHFL CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
SCLCL Scheduling Location Class LXYRD_SCLCL CHAR 2 0
05 Door
06 Staging area
SCLOC Scheduled Location LXYRD_SCLOC CHAR 10 0
SCSTM Scheduled Start Time LXYRD_SCSTM DEC 15 0
SCETM Planned End Time LXYRD_PTMST DEC 15 0
ATMSFSCH Actual Start Time LXYRD_ATMSF DEC 15 0
ATMSTSCH Actual End Time of Yard Activity LXYRD_ATMST DEC 15 0
TMIYD Time in the Yard LXYRD_TMIYD QUAN 10 3
ATMSF Actual Start Time LXYRD_ATMSF DEC 15 0
ATMST Actual End Time of Yard Activity LXYRD_ATMST DEC 15 0

LXYRDM_DLVRY_SELECT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
LXYRDM_DLVRY_SELECT RSNCD SYST MANDT LYRSN Reason codes MANDT
LXYRDM_DLVRY_SELECT RSNCD LXYRDM_DLVRY_SELECT LYARD LYRSN Reason codes LYARD
LXYRDM_DLVRY_SELECT RSNCD LXYRDM_DLVRY_SELECT RSNCD LYRSN Reason codes RSNCD
LXYRDM_DLVRY_SELECT VHART SYST MANDT TVTY Packaging Material Types MANDT
LXYRDM_DLVRY_SELECT VHART LXYRDM_DLVRY_SELECT VHART TVTY Packaging Material Types TRATY