OIKLID

TAS active LIDs(NOTE:keep eq to DB OIKLIDW->append includes) | #masterdata | Component: Interface to Terminal Automation System
Column Name Description
CLIENT FK Client
LIDNO LOAD ID
Column Name Description
Column Name Description
Column Name Description
CREADATE Created On
CREATIME Calendar: Creation or change time
CHDATE Changed On
CHTIME Calendar: Creation or change time
Column Name Description
CONTRTYP Control structure type 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
LIDDESC Load ID description TEXT36
LIDDEPOT LID used at depot CHAR30
LID3COD1 3rd party code TEXT30
LIDACTREAS LID activation reason code OIK_REACOD
LIDDELREAS LID deletion reason code OIK_REACOD
LIDBLKREAS LID blocking reason code OIK_REACOD
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
SDOCART Subsequent document type AUART
KALSU Procedure for material determination KALSM
CREAAUTHOR Addresses: Created by USERNAME
CHAUTHOR Addresses: Changed by USERNAME
TRIP Trip Number OIG_TRIP
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
Master Data Relations Join Conditions
Valuation Type
  • OIKLID.CLIENT == T149D.MANDT
  • OIKLID.BWTAR == T149D.BWTAR
Client OIKLID.CLIENT == T000.MANDT
TD driver number
  • TD driver number
  • Client
  • OIKLID.DRIVERCODE == OIGD.DRIVERCODE
  • OIKLID.CLIENT == OIGD.CLIENT
LOAD ID function group
Storage location
  • Storage location
  • Client
  • Plant
  • OIKLID.LGORT == T001L.LGORT
  • OIKLID.CLIENT == T001L.MANDT
  • OIKLID.WERKS == T001L.WERKS
LOAD ID type
  • LOAD ID type
  • Client
  • Control structure type
  • OIKLID.LIDTYPE == OIKLT.LIDTYPE
  • OIKLID.CLIENT == OIKLT.CLIENT
  • OIKLID.CONTRTYP == OIKLT.CONTRTYP
Material Group
  • OIKLID.CLIENT == T023.MANDT
  • OIKLID.MATKL == T023.MATKL
IS-OIL MAP external details mode of transport
  • OIKLID.CLIENT == TVTR.MANDT
  • OIKLID.OIC_MOT == TVTR.VKTRA
Excise Duty Handling Type
  • Excise Duty Handling Type
  • Client
  • OIKLID.OIHANTYP == OIH5.HANTYP
  • OIKLID.CLIENT == OIH5.MANDT
TD driver shift
  • TD driver shift
  • Client
  • OIKLID.SHIFT == TOIGH.SHIFT
  • OIKLID.CLIENT == TOIGH.CLIENT
Ship-to Party
  • OIKLID.CLIENT == KNA1.MANDT
  • OIKLID.SHIPTO == KNA1.KUNNR
Sold-to Party
  • OIKLID.CLIENT == KNA1.MANDT
  • OIKLID.SOLDTO == KNA1.KUNNR
TAS Group 1
  • TAS Group 1
  • Client
TAS Group 2
  • TAS Group 2
  • Client
Transportation planning point
  • Transportation planning point
  • Client
  • OIKLID.TPLST == TTDS.TPLST
  • OIKLID.CLIENT == TTDS.MANDT
TD Vehicle Number
  • OIKLID.CLIENT == OIGV.CLIENT
  • OIKLID.VEHICLE == OIGV.VEHICLE
Shipping Conditions
  • OIKLID.CLIENT == TVSB.MANDT
  • OIKLID.VSBED == TVSB.VSBED
Shipping Point / Receiving Point
  • OIKLID.CLIENT == TVST.MANDT
  • OIKLID.VSTEL == TVST.VSTEL
Plant
  • OIKLID.CLIENT == T001W.MANDT
  • OIKLID.WERKS == T001W.WERKS