I_LoadIDBasic

Load ID Basic | view: ILOADIDBASIC | TRAN | Extraction: Not supported | Component: Downstream
Tables used: OIKLID, OIKCFW
Column Name Description
LoadID LOAD ID
Column Name Description
Column Name Description
Column Name Description
CreationDate Created On
Column Name Description
LoadIDControlStructureType Control structure type Show values
LoadIDActivationCode LID activation indicator Show values
LoadIDIsMarkedForDeletion LID deletion indicator Show values
LoadIDIsBlocked LID blocking indicator Show values
Column Name Description Domain name
LoadIDDescription Load ID description TEXT36
CreatedByUser Addresses: Created by USERNAME
ThirdPartyLoadID LID used at depot CHAR30
ThirdPartyLoadIDCode 3rd party code TEXT30
ThirdPartyDeliveryNumber 3rd-party delivery number CHAR30
ThirdPartyMaterialInformation 3rd party material info TEXT40
ThirdPartyMaterialDescription 3rd party material text TEXT64
ThirdPartyCustomerInformation 3rd party customer info TEXT40
ThirdPartyMaterial TAS material number TEXT40
LoadIDAddOnNumber TAS additive number TEXT40
LoadIDUserField1 TAS user fields TEXT30
LoadIDUserField2 TAS user fields TEXT30
LoadIDUserField3 TAS user fields TEXT30
LoadIDUserField4 TAS user fields TEXT30
LoadIDUserField5 TAS user fields TEXT30
LoadIDUserField6 TAS user fields TEXT30
LoadIDUserField7 TAS user fields TEXT30
LoadIDUserField8 TAS user fields TEXT30
LoadIDUserField9 TAS user fields TEXT30
LoadIDUserField10 TAS user fields TEXT30
LoadIDUserField11 TAS user fields TEXT30
LoadIDUserField12 TAS user fields TEXT30
LoadIDUserField13 TAS user fields TEXT30
LoadIDUserField14 TAS user fields TEXT30
LoadIDUserField15 TAS user fields TEXT30
LoadIDUserField16 TAS user fields TEXT30
LoadIDUserField17 TAS user fields TEXT30
LoadIDUserField18 TAS user fields TEXT30
LoadIDUserField19 TAS user fields TEXT30
LoadIDUserField20 TAS user fields TEXT30
LoadIDUserField21 null
LoadIDCtrlFldMsg null
LoadIDTrip Trip Number OIG_TRIP
LoadIDControlStructure Control structure OIK_CNTSTR
Master Data Relations Join Conditions
Excise Duty Handling Type
  • Excise Duty Handling Type
  • Client
  • I_LOADIDBASIC.EXCISEDUTYHANDLINGTYPE == OIH5.HANTYP
  • I_LOADIDBASIC.MANDT == OIH5.MANDT
IS-OIL MAP external details mode of transport
  • IS-OIL MAP external details mode of transport
  • Client
  • I_LOADIDBASIC.LOADIDMODEOFTRANSPORT == TVTR.VKTRA
  • I_LOADIDBASIC.MANDT == TVTR.MANDT
LOAD ID type
  • Control structure type
  • LOAD ID type
  • Client
  • I_LOADIDBASIC.LOADIDCONTROLSTRUCTURETYPE == OIKLT.CONTRTYP
  • I_LOADIDBASIC.LOADIDTYPE == OIKLT.LIDTYPE
  • I_LOADIDBASIC.MANDT == OIKLT.CLIENT
Valuation Type
  • Valuation Type
  • Client
  • I_LOADIDBASIC.LOADIDVALUATIONTYPE == T149D.BWTAR
  • I_LOADIDBASIC.MANDT == T149D.MANDT
Material Group
  • Client
  • Material Group
  • I_LOADIDBASIC.MANDT == T023.MANDT
  • I_LOADIDBASIC.MATERIALGROUP == T023.MATKL
Plant
  • Plant
  • Client
  • I_LOADIDBASIC.PLANT == T001W.WERKS
  • I_LOADIDBASIC.MANDT == T001W.MANDT
Shipping Conditions
  • Client
  • Shipping Conditions
  • I_LOADIDBASIC.MANDT == TVSB.MANDT
  • I_LOADIDBASIC.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_LOADIDBASIC.MANDT == TVST.MANDT
  • I_LOADIDBASIC.SHIPPINGPOINT == TVST.VSTEL
Ship-to Party
  • Ship-to Party
  • Client
  • I_LOADIDBASIC.SHIPTOPARTY == KNA1.KUNNR
  • I_LOADIDBASIC.MANDT == KNA1.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • I_LOADIDBASIC.SOLDTOPARTY == KNA1.KUNNR
  • I_LOADIDBASIC.MANDT == KNA1.MANDT
Storage location
  • Plant
  • Client
  • Storage location
  • I_LOADIDBASIC.PLANT == T001L.WERKS
  • I_LOADIDBASIC.MANDT == T001L.MANDT
  • I_LOADIDBASIC.STORAGELOCATION == T001L.LGORT
Transportation planning point
  • Transportation planning point
  • Client
  • I_LOADIDBASIC.TRANSPORTATIONPLANNINGPOINT == TTDS.TPLST
  • I_LOADIDBASIC.MANDT == TTDS.MANDT
TD Vehicle Number
  • TD Vehicle Number
  • Client
  • I_LOADIDBASIC.TRANSPORTATIONVEHICLE == OIGV.VEHICLE
  • I_LOADIDBASIC.MANDT == OIGV.CLIENT
TD driver number
  • TD driver number
  • Client
  • I_LOADIDBASIC.TRANSPORTATIONVEHICLEDRIVER == OIGD.DRIVERCODE
  • I_LOADIDBASIC.MANDT == OIGD.CLIENT
TD driver shift
  • TD driver shift
  • Client
  • I_LOADIDBASIC.TRANSPVEHICLEDRIVERSHIFT == TOIGH.SHIFT
  • I_LOADIDBASIC.MANDT == TOIGH.CLIENT