SAP ABAP View V_LECI_CARDDATA (Check-in: Database View via CARD 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_CARDDATA
Short Description	Check-in: Database View via CARD and EVENT_DATA
Root table	LECI_CARD	Extended Pass for Registration at the Checkpoint

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	LECI_CARD	LECI_CARD
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_CARD	CLIENT	JR	EQ			AND	0	0
3	LECI_EVENT_DATA	GUID_EVENT_DATA	JL	EQ				0	0
4	LECI_CARD	GUID_EVENT_DATA	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	LECI_CARD	CLIENT		☐	MANDT	☐	Client
2	GUID_CARD	LECI_CARD	GUID_CARD		☐	LECI_GUID_EVENT	☐	Key for Check-in/Check-out Process That Is Unique Worldwide
3	CARD_NUMB	LECI_CARD	CARD_NUMB		☐	PCRD_NUMB	☐	Extended Pass Number for Check-in at Plant Grounds
4	VALID_DATE_FROM	LECI_CARD	VALID_DATE_FROM		☐	LECI_VALID_DATE_CARD	☐	Validity Period for an Extended Pass
5	VALID_DATE_TO	LECI_CARD	VALID_DATE_TO		☐	LECI_VALID_DATE_CARD	☐	Validity Period for an Extended Pass
6	CREAT_TAKER	LECI_CARD	CREAT_TAKER		☐	LECI_TAKER	☐	Created by
7	LAST_TAKER	LECI_CARD	LAST_TAKER		☐	LECI_TAKER	☐	Created by
8	CREAT_DATE	LECI_CARD	CREAT_DATE		☐	ERDAT	☐	Date on which the record was created
9	CHANGE_DATE	LECI_CARD	CHANGE_DATE		☐	AEDAT	☐	Last Changed On
10	NOTE_TEXT	LECI_CARD	NOTE_TEXT		☐	NOTE_TXT	☐	Comments
11	FLG_REVERSE	LECI_CARD	FLG_REVERSE		☐	STORN	☐	Indicator: Document is reversed
12	ST_PRT_PASS	LECI_CARD	ST_PRT_PASS		☐	LECI_PRINT	☐	Indicator: Document Was Printed
13	GUID_EVENT_DATA	LECI_CARD	GUID_EVENT_DATA		☐	LECI_GUID_EVENT_DATA	☐	Worldwide-Unique Key for Check-in/Check-out Process Data
14	SHPMNT_NUMB	LECI_EVENT_DATA	SHPMNT_NUMB		☐	TKNUM	☐	Shipment Number
15	DELIV_NUMB	LECI_EVENT_DATA	DELIV_NUMB		☐	VBELN_VL	☐	Delivery
16	TRAILER_REG_NUMB	LECI_EVENT_DATA	TRAILER_REG_NUMB		☐	TREGNB	☐	Trailer's License Plate Number
17	CONT_REG_NUMB1	LECI_EVENT_DATA	CONT_REG_NUMB1		☐	C1RENB	☐	Number of the First Container
18	CONT_REG_NUMB2	LECI_EVENT_DATA	CONT_REG_NUMB2		☐	C2RENB	☐	Number of the Second Container
19	VEND_NUMB	LECI_EVENT_DATA	VEND_NUMB		☐	TDLNR	☐	Number of forwarding agent
20	NAT_DRVR	LECI_EVENT_DATA	NAT_DRVR		☐	LANDF	☐	Driver's Nationality
21	ALLOWED_WGHT	LECI_EVENT_DATA	ALLOWED_WGHT		☐	MAGEW_VEKP	☐	Allowed Loading Weight of a Handling Unit
22	UNIT_OF_WGHT	LECI_EVENT_DATA	UNIT_OF_WGHT		☐	GEWEI	☐	Weight Unit
23	PARKING_TXT	LECI_EVENT_DATA	PARKING_TXT		☐	PARKING_TXT	☐	Text Field for Entering the Parking Space
24	CARGO_TXT	LECI_EVENT_DATA	CARGO_TXT		☐	CARGO_TXT	☐	Text Relating to the Load
25	STAGING_AREA	LECI_EVENT_DATA	STAGING_AREA		☐	LGBZO	☐	Staging Area for Warehouse Complex
26	SHP_POINT	LECI_EVENT_DATA	SHP_POINT		☐	VSTEL	☐	Shipping Point/Receiving Point
27	WHS_NUMB	LECI_EVENT_DATA	WHS_NUMB		☐	LGNUM	☐	Warehouse Number / Warehouse Complex
28	WHS_GATE	LECI_EVENT_DATA	WHS_GATE		☐	LGTOR	☐	Door for Warehouse Number
29	COMPANY	LECI_EVENT_DATA	COMPANY		☐	COMP_TXT	☐	Company name
30	CITY	LECI_EVENT_DATA	CITY		☐	AD_CITY1	☐	City
31	DEPARTMENT	LECI_EVENT_DATA	DEPARTMENT		☐	AD_DPRTMNT	☐	Department
32	BUILDING	LECI_EVENT_DATA	BUILDING		☐	AD_BLDNG_P	☐	Building (number or code)
33	NAME_CONTACT	LECI_EVENT_DATA	NAME_CONTACT		☐	MIGO_USERNAME	☐	Search for a user name
34	PHONE	LECI_EVENT_DATA	PHONE		☐	AD_TLNMBR1	☐	First telephone no.: dialling code+number
35	ID_CARD_NUMB	LECI_EVENT_DATA	ID_CARD_NUMB		☐	ID_CARD_NUMB	☐	ID Number
36	CARR_OBJECTS	LECI_EVENT_DATA	CARR_OBJECTS		☐	COBJCTS_TXT	☐	Personal Effects
37	CHK_IN_TYPE	LECI_EVENT_DATA	CHK_IN_TYPE		☐	CHKI_TYPE	☐	Classification of the Check-in Object (M. of Tran., Visitor)

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