SAP ABAP View M_OIKLC (Generated view for matchcode ID OIKL -C)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-TAS (Application Component) Interface to Terminal Automation System
     ⤷ OIK (Package) TAS/TPI Common Objects

Basic Data

View Type	D	Database View
Database View	M_OIKLC
Short Description	Generated view for matchcode ID OIKL -C
Root table	OIKLID	TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	OIKLID	OIKLID
2	OIKCF

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	OIKLID	CLIENT		☐	MANDT	☐	Client
2	LIDNO	OIKLID	LIDNO		☐	OIK_LID	☐	LOAD ID
3	CONTRTYP	OIKLID	CONTRTYP		☐	OIK_CNTTYP	☐	Control structure type
4	SOLDTO	OIKCF	SOLDTO		☐	KUNAG	☐	Sold-to party
5	SHIPTO	OIKCF	SHIPTO		☐	KUNWE	☐	Ship-to party
6	VSTEL	OIKCF	VSTEL		☐	VSTEL	☐	Shipping Point/Receiving Point
7	WERKS	OIKCF	WERKS		☐	WERKS_D	☐	Plant
8	LGORT	OIKCF	LGORT		☐	LGORT_D	☐	Storage location
9	MATKL	OIKCF	MATKL		☐	MATKL	☐	Material Group
10	MATNR	OIKCF	MATNR		☐	MATNR	☐	Material Number
11	OIHANTYP	OIKCF	OIHANTYP		☐	OIH_HANTYP	☐	Excise Duty Handling Type
12	TPLST	OIKCF	TPLST		☐	TPLST	☐	Transportation planning point
13	VEHICLE	OIKCF	VEHICLE		☐	OIG_VHLNMR	☐	TD Vehicle Number
14	DRIVERCODE	OIKCF	DRIVERCODE		☐	OIG_DRVNMR	☐	TD driver number
15	BWTAR	OIKCF	BWTAR		☐	BWTAR_D	☐	Valuation type
16	SHIFT	OIKCF	SHIFT		☐	OIG_SHIFT	☐	TD driver shift
17	TRIP	OIKCF	TRIP		☐	OIG_TRIP	☐	Trip Number
18	OIC_MOT	OIKCF	OIC_MOT		☐	OIC_MOT	☐	IS-OIL MAP external details mode of transport
19	VSBED	OIKCF	VSBED		☐	VSBED	☐	Shipping conditions

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	20110901
SAP Release Created in