OIKLIDR

TD - TAS Reference Table | #transactional | Component: Interface to Terminal Automation System
Column Name Description
CLIENT FK Client
LIDNO LOAD ID
LIDADDON LOAD ID ADDON
LIDTYPE FK LOAD ID type
FROMDATE Timestamp valid from
TODATE Timestamp valid from
DOCNO SAP Document Number (TAS)
ITEMNO SAP document item for TAS
DOCTYPE SAP Document Type (TAS) Show values
Column Name Description
Column Name Description
Column Name Description
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
DOCTYPE SAP Document Type (TAS) Show values
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
TRIP Trip Number OIG_TRIP
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAME Last Changed By UNAME
Master Data Relations Join Conditions
Valuation Type
  • OIKLIDR.CLIENT == T149D.MANDT
  • OIKLIDR.BWTAR == T149D.BWTAR
Client OIKLIDR.CLIENT == T000.MANDT
TD driver number
  • TD driver number
  • Client
  • OIKLIDR.DRIVERCODE == OIGD.DRIVERCODE
  • OIKLIDR.CLIENT == OIGD.CLIENT
LOAD ID function group
Storage location
  • Storage location
  • Client
  • Plant
  • OIKLIDR.LGORT == T001L.LGORT
  • OIKLIDR.CLIENT == T001L.MANDT
  • OIKLIDR.WERKS == T001L.WERKS
LOAD ID type
  • LOAD ID type
  • Client
  • Control structure type
  • OIKLIDR.LIDTYPE == OIKLT.LIDTYPE
  • OIKLIDR.CLIENT == OIKLT.CLIENT
  • OIKLIDR.CONTRTYP == OIKLT.CONTRTYP
Material Group
  • OIKLIDR.CLIENT == T023.MANDT
  • OIKLIDR.MATKL == T023.MATKL
IS-OIL MAP external details mode of transport
  • OIKLIDR.CLIENT == TVTR.MANDT
  • OIKLIDR.OIC_MOT == TVTR.VKTRA
Excise Duty Handling Type
  • Excise Duty Handling Type
  • Client
  • OIKLIDR.OIHANTYP == OIH5.HANTYP
  • OIKLIDR.CLIENT == OIH5.MANDT
TD driver shift
  • TD driver shift
  • Client
  • OIKLIDR.SHIFT == TOIGH.SHIFT
  • OIKLIDR.CLIENT == TOIGH.CLIENT
Ship-to Party
  • OIKLIDR.CLIENT == KNA1.MANDT
  • OIKLIDR.SHIPTO == KNA1.KUNNR
Sold-to Party
  • OIKLIDR.CLIENT == KNA1.MANDT
  • OIKLIDR.SOLDTO == KNA1.KUNNR
TAS Group 1
  • TAS Group 1
  • Client
TAS Group 2
  • TAS Group 2
  • Client
Transportation planning point
  • Transportation planning point
  • Client
  • OIKLIDR.TPLST == TTDS.TPLST
  • OIKLIDR.CLIENT == TTDS.MANDT
TD Vehicle Number
  • OIKLIDR.CLIENT == OIGV.CLIENT
  • OIKLIDR.VEHICLE == OIGV.VEHICLE
Shipping Conditions
  • OIKLIDR.CLIENT == TVSB.MANDT
  • OIKLIDR.VSBED == TVSB.VSBED
Shipping Point / Receiving Point
  • OIKLIDR.CLIENT == TVST.MANDT
  • OIKLIDR.VSTEL == TVST.VSTEL
Plant
  • OIKLIDR.CLIENT == T001W.MANDT
  • OIKLIDR.WERKS == T001W.WERKS