OIK01

IS-OIL/TAS: LID Document Data | #transactional | Component: Interface to Terminal Automation System

🔑 Keys (8)
💰 Amounts
∑ Quantities
📅 Dates (9)
☰ Categorical (10)
Other (35)
🔗 Relations (27)

Column Name	Description
CLIENT FK	Client
VBTYP	SD Document Category	Show values
DOCNO FK	SAP Document Number (TAS)
ITEMNO	SAP document item for TAS
LIDNO FK	LOAD ID
LIDADDON	LOAD ID ADDON
LIDTYPE FK	LOAD ID type
CONTRTYP	Control structure type	Show values

Column Name	Description

Column Name	Description

Column Name	Description
FROMDATE	Valid from date (TAS)
FROMTIME	Valid from-time (TAS)
TODATE	Valid to date (TAS)
TOTIME	Valid to Time TAS
ERDAT	Date on which the record was created
ERZEIT	Time at Which Record Was Added
AEDAT	Last Changed On
AEZEIT	Time of Change
_DATAAGING	Data Filter Value for Data Aging

Column Name	Description
VBTYP	SD Document Category	Show values
CONTRTYP	Control structure type	Show values
COPY_FLAG	Copy flag	Show values
SEND_FLAG	Flag: LID distributed	Show values
AUTOA_FLAG	Automatic LID assignment enabled	Show values
LIDACTIND	LID activation indicator	Show values
LIDDELIND	LID deletion indicator	Show values
LIDBLKIND	LID blocking indicator	Show values
BSTYP	Purchasing Document Category	Show values
TASCFLAG	Check flag for load ID	Show values

Column Name	Description	Domain name
CNTRLIND	LID control field indicator	CHAR20
ERNAM	Name of Person Responsible for Creating the Object	USNAM
AENAME	Last Changed By	UNAME
LIDDESC	Load ID description	TEXT36
LIDDEPOT	LID used at depot	CHAR30
LID3COD1	3rd party code	TEXT30
LID3RDPRTY	3rd-party delivery number	CHAR30
MATNR3RDP	3rd party material info	TEXT40
MATTXT3RDP	3rd party material text	TEXT64
CUST3RDP	3rd party customer info	TEXT40
MATNRTAS	TAS material number	TEXT40
ADDITTAS	TAS additive number	TEXT40
LIDTAS	Load ID TAS	TEXT30
KALSU	Procedure for material determination	KALSM
USERFLD1	TAS user fields	TEXT30
USERFLD2	TAS user fields	TEXT30
USERFLD3	TAS user fields	TEXT30
USERFLD4	TAS user fields	TEXT30
USERFLD5	TAS user fields	TEXT30
USERFLD6	TAS user fields	TEXT30
USERFLD7	TAS user fields	TEXT30
USERFLD8	TAS user fields	TEXT30
USERFLD9	TAS user fields	TEXT30
USERFLD10	TAS user fields	TEXT30
USERFLD11	TAS user fields	TEXT30
USERFLD12	TAS user fields	TEXT30
USERFLD13	TAS user fields	TEXT30
USERFLD14	TAS user fields	TEXT30
USERFLD15	TAS user fields	TEXT30
USERFLD16	TAS user fields	TEXT30
USERFLD17	TAS user fields	TEXT30
USERFLD18	TAS user fields	TEXT30
USERFLD19	TAS user fields	TEXT30
USERFLD20	TAS user fields	TEXT30
TRIP	Trip Number	OIG_TRIP

Master Data Relations	Join Conditions
Valuation Type	`OIK01.CLIENT == T149D.MANDT` `OIK01.BWTAR == T149D.BWTAR`
Client	`OIK01.CLIENT == T000.MANDT`
TD driver number TD driver number Client	`OIK01.DRIVERCODE == OIGD.DRIVERCODE` `OIK01.CLIENT == OIGD.CLIENT`
LOAD ID function group	`OIK01.CLIENT == TOIKLIDG.CLIENT` `OIK01.FUNCGROUP == TOIKLIDG.LIDGROUP`
Storage location Storage location Client Plant	`OIK01.LGORT == T001L.LGORT` `OIK01.CLIENT == T001L.MANDT` `OIK01.WERKS == T001L.WERKS`
LID activation reason code LID activation reason code ? Client	`OIK01.LIDACTREAS == OIKLR.REACODE` `OIK01.[column in domain "OIK_RTYPE"] == OIKLR.REATYPE` `OIK01.CLIENT == OIKLR.CLIENT`
LID blocking reason code LID blocking reason code ? Client	`OIK01.LIDBLKREAS == OIKLR.REACODE` `OIK01.[column in domain "OIK_RTYPE"] == OIKLR.REATYPE` `OIK01.CLIENT == OIKLR.CLIENT`
LID deletion reason code LID deletion reason code ? Client	`OIK01.LIDDELREAS == OIKLR.REACODE` `OIK01.[column in domain "OIK_RTYPE"] == OIKLR.REATYPE` `OIK01.CLIENT == OIKLR.CLIENT`
LOAD ID	`OIK01.CLIENT == OIKLIDW.CLIENT` `OIK01.LIDNO == OIKLIDW.LIDNO`
LOAD ID type LOAD ID type Client Control structure type	`OIK01.LIDTYPE == OIKLT.LIDTYPE` `OIK01.CLIENT == OIKLT.CLIENT` `OIK01.CONTRTYP == OIKLT.CONTRTYP`
Material Group	`OIK01.CLIENT == T023.MANDT` `OIK01.MATKL == T023.MATKL`
IS-OIL MAP external details mode of transport	`OIK01.CLIENT == TVTR.MANDT` `OIK01.OIC_MOT == TVTR.VKTRA`
Excise Duty Handling Type Excise Duty Handling Type Client	`OIK01.OIHANTYP == OIH5.HANTYP` `OIK01.CLIENT == OIH5.MANDT`
Subsequent document type	`OIK01.CLIENT == TVAK.MANDT` `OIK01.SDOCART == TVAK.AUART`
TD driver shift TD driver shift Client	`OIK01.SHIFT == TOIGH.SHIFT` `OIK01.CLIENT == TOIGH.CLIENT`
Ship-to Party	`OIK01.CLIENT == KNA1.MANDT` `OIK01.SHIPTO == KNA1.KUNNR`
Sold-to Party	`OIK01.CLIENT == KNA1.MANDT` `OIK01.SOLDTO == KNA1.KUNNR`
TAS Group 1 TAS Group 1 Client	`OIK01.TASGRP1 == TOIKTGRP.TASGROUP` `OIK01.CLIENT == TOIKTGRP.CLIENT`
TAS Group 2 TAS Group 2 Client	`OIK01.TASGRP2 == TOIKTGRP.TASGROUP` `OIK01.CLIENT == TOIKTGRP.CLIENT`
Transportation planning point Transportation planning point Client	`OIK01.TPLST == TTDS.TPLST` `OIK01.CLIENT == TTDS.MANDT`
TD Vehicle Number	`OIK01.CLIENT == OIGV.CLIENT` `OIK01.VEHICLE == OIGV.VEHICLE`
Shipping Conditions	`OIK01.CLIENT == TVSB.MANDT` `OIK01.VSBED == TVSB.VSBED`
Shipping Point / Receiving Point	`OIK01.CLIENT == TVST.MANDT` `OIK01.VSTEL == TVST.VSTEL`
Plant	`OIK01.CLIENT == T001W.MANDT` `OIK01.WERKS == T001W.WERKS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Control structure Control structure LOAD ID type Control structure type	`OIK01.CLIENT == OIKLTC.CLIENT` `OIK01.CONTRSTR == OIKLTC.CONTRSTR` `OIK01.LIDTYPE == OIKLTC.LIDTYPE` `OIK01.CONTRTYP == OIKLTC.CONTRTYP`