SAP ABAP View V_LECI_EVENTDATA (Check-in: Database View via EVENT and EVENT_DATA)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LE-SHP-GF (Application Component) Basic Functions
     ⤷ LE_CHKIN (Package) Check-in at Checkpoint for Means of Transport and Visitors

Basic Data

View Type	D	Database View
Database View	V_LECI_EVENTDATA
Short Description	Check-in: Database View via EVENT and EVENT_DATA
Root table	LECI_EVENT	Activities Within the Check-in/Check-out Process

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LECI_EVENT	LECI_EVENT
2	LECI_EVENT_DATA

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	LECI_EVENT_DATA	CLIENT	JL	EQ				0	0
2	LECI_EVENT	CLIENT	JR	EQ			AND	0	0
3	LECI_EVENT_DATA	GUID_EVENT_DATA	JL	EQ				0	0
4	LECI_EVENT	GUID_EVENT_DATA	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	LECI_EVENT	CLIENT		☐	MANDT	☐	Client
2	GUID_EVENT	LECI_EVENT	GUID_EVENT		☐	LECI_GUID_EVENT	☐	Key for Check-in/Check-out Process That Is Unique Worldwide
3	CREAT_DATE	LECI_EVENT	CREAT_DATE		☐	ERDAT	☐	Date on which the record was created
4	CREAT_TIME	LECI_EVENT	CREAT_TIME		☐	ERZET	☐	Entry time
5	PASS_NUMB	LECI_EVENT	PASS_NUMB		☐	PASS_NUMB	☐	Sequence Number of a Check-in Activity
6	EVENT_NUMB	LECI_EVENT	EVENT_NUMB		☐	CIEVENT_NUMB	☐	Number of an Actitiy Within the Check-in/Check-out Process
7	FLG_PROC_FIN	LECI_EVENT	FLG_PROC_FIN		☐	FL_PROC_FIN	☐	Indicator: Process Has Been Completed
8	EVENT	LECI_EVENT	EVENT		☐	CHK_EVENT	☐	Activity Within the Check-in/Check-out Process
9	EVENT_DATE	LECI_EVENT	EVENT_DATE		☐	LECI_EVENT_DATE	☐	Date of the Check-in/Check-out Process
10	EVENT_TIME	LECI_EVENT	EVENT_TIME		☐	LECI_EVENT_TIME	☐	Time of the Check-in/Check-out Process
11	FLG_REVERSE	LECI_EVENT	FLG_REVERSE		☐	STORN	☐	Indicator: Document is reversed
12	ST_PRT_PASS	LECI_EVENT	ST_PRT_PASS		☐	LECI_PRINT	☐	Indicator: Document Was Printed
13	CHK_POINT	LECI_EVENT	CHK_POINT		☐	CHK_PT	☐	Checkpoint Number
14	TAKER	LECI_EVENT	TAKER		☐	LECI_TAKER	☐	Created by
15	NOTE_TXT	LECI_EVENT	NOTE_TXT		☐	NOTE_TXT	☐	Comments
16	GUID_EVENT_DATA	LECI_EVENT	GUID_EVENT_DATA		☐	LECI_GUID_EVENT_DATA	☐	Worldwide-Unique Key for Check-in/Check-out Process Data
17	SHPMNT_NUMB	LECI_EVENT_DATA	SHPMNT_NUMB		☐	TKNUM	☐	Shipment Number
18	DELIV_NUMB	LECI_EVENT_DATA	DELIV_NUMB		☐	VBELN_VL	☐	Delivery
19	VEHICLE_REG_NUMB	LECI_EVENT_DATA	VEHICLE_REG_NUMB		☐	VREGNB	☐	Truck's/Car's License Plate Number
20	TRAILER_REG_NUMB	LECI_EVENT_DATA	TRAILER_REG_NUMB		☐	TREGNB	☐	Trailer's License Plate Number
21	CONT_REG_NUMB1	LECI_EVENT_DATA	CONT_REG_NUMB1		☐	C1RENB	☐	Number of the First Container
22	CONT_REG_NUMB2	LECI_EVENT_DATA	CONT_REG_NUMB2		☐	C2RENB	☐	Number of the Second Container
23	VEND_NUMB	LECI_EVENT_DATA	VEND_NUMB		☐	TDLNR	☐	Number of forwarding agent
24	NAME_DRVR	LECI_EVENT_DATA	NAME_DRVR		☐	NAMEF	☐	Driver name
25	NAME_CODRVR	LECI_EVENT_DATA	NAME_CODRVR		☐	NAMBE	☐	Passenger's name
26	NAT_DRVR	LECI_EVENT_DATA	NAT_DRVR		☐	LANDF	☐	Driver's Nationality
27	CARD_NUMB	LECI_EVENT_DATA	CARD_NUMB		☐	PCRD_NUMB	☐	Extended Pass Number for Check-in at Plant Grounds
28	ALLOWED_WGHT	LECI_EVENT_DATA	ALLOWED_WGHT		☐	MAGEW_VEKP	☐	Allowed Loading Weight of a Handling Unit
29	UNIT_OF_WGHT	LECI_EVENT_DATA	UNIT_OF_WGHT		☐	GEWEI	☐	Weight Unit
30	PARKING_TXT	LECI_EVENT_DATA	PARKING_TXT		☐	PARKING_TXT	☐	Text Field for Entering the Parking Space
31	CARGO_TXT	LECI_EVENT_DATA	CARGO_TXT		☐	CARGO_TXT	☐	Text Relating to the Load
32	STAGING_AREA	LECI_EVENT_DATA	STAGING_AREA		☐	LGBZO	☐	Staging Area for Warehouse Complex
33	SHP_POINT	LECI_EVENT_DATA	SHP_POINT		☐	VSTEL	☐	Shipping Point/Receiving Point
34	WHS_NUMB	LECI_EVENT_DATA	WHS_NUMB		☐	LGNUM	☐	Warehouse Number / Warehouse Complex
35	WHS_GATE	LECI_EVENT_DATA	WHS_GATE		☐	LGTOR	☐	Door for Warehouse Number
36	COMPANY	LECI_EVENT_DATA	COMPANY		☐	COMP_TXT	☐	Company name
37	CITY	LECI_EVENT_DATA	CITY		☐	AD_CITY1	☐	City
38	NAME_CONTACT	LECI_EVENT_DATA	NAME_CONTACT		☐	MIGO_USERNAME	☐	Search for a user name
39	ID_CARD_NUMB	LECI_EVENT_DATA	ID_CARD_NUMB		☐	ID_CARD_NUMB	☐	ID Number
40	CARR_OBJECTS	LECI_EVENT_DATA	CARR_OBJECTS		☐	COBJCTS_TXT	☐	Personal Effects
41	CHK_IN_TYPE	LECI_EVENT_DATA	CHK_IN_TYPE		☐	CHKI_TYPE	☐	Classification of the Check-in Object (M. of Tran., Visitor)
42	DEPARTMENT	LECI_EVENT_DATA	DEPARTMENT		☐	AD_DPRTMNT	☐	Department
43	BUILDING	LECI_EVENT_DATA	BUILDING		☐	AD_BLDNG_P	☐	Building (number or code)
44	PHONE	LECI_EVENT_DATA	PHONE		☐	AD_TLNMBR1	☐	First telephone no.: dialling code+number
45	FST_NAME_DRVR	LECI_EVENT_DATA	FST_NAME_DRVR		☐	LECI_NAMEFIR	☐	First Name
46	FST_NAME_CODRVR	LECI_EVENT_DATA	FST_NAME_CODRVR		☐	LECI_NAMEFIR	☐	First Name

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in