C_LoadID

Load ID | view: CLOADID | TRAN | Extraction: Not supported | Component: Downstream

Tables used: OIKLID, OIKCFW

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates (1)
☰ Categorical (4)
Other (33)
🔗 Relations (15)

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
LoadIDControlStructure	Control structure	OIK_CNTSTR
CreatedByUser	Addresses: Created by	USERNAME
LoadIDCtrlFldMsg	null
LoadIDTrip	Trip Number	OIG_TRIP
ThirdPartyLoadID	LID used at depot	CHAR30
ThirdPartyLoadIDCode	3rd party code	TEXT30
LoadIDAddOnNumber	TAS additive number	TEXT40
ThirdPartyMaterialInformation	3rd party material info	TEXT40
ThirdPartyDeliveryNumber	3rd-party delivery number	CHAR30
ThirdPartyMaterialDescription	3rd party material text	TEXT64
ThirdPartyCustomerInformation	3rd party customer info	TEXT40
LoadIDUserField21	null
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

Master Data Relations	Join Conditions
Excise Duty Handling Type Excise Duty Handling Type Client	`C_LOADID.EXCISEDUTYHANDLINGTYPE == OIH5.HANTYP` `C_LOADID.MANDT == OIH5.MANDT`
IS-OIL MAP external details mode of transport Client IS-OIL MAP external details mode of transport	`C_LOADID.MANDT == TVTR.MANDT` `C_LOADID.LOADIDMODEOFTRANSPORT == TVTR.VKTRA`
LOAD ID type LOAD ID type Client Control structure type	`C_LOADID.LOADIDTYPE == OIKLT.LIDTYPE` `C_LOADID.MANDT == OIKLT.CLIENT` `C_LOADID.LOADIDCONTROLSTRUCTURETYPE == OIKLT.CONTRTYP`
Valuation Type Valuation Type Client	`C_LOADID.LOADIDVALUATIONTYPE == T149D.BWTAR` `C_LOADID.MANDT == T149D.MANDT`
Material Group Material Group Client	`C_LOADID.MATERIALGROUP == T023.MATKL` `C_LOADID.MANDT == T023.MANDT`
Plant Plant Client	`C_LOADID.PLANT == T001W.WERKS` `C_LOADID.MANDT == T001W.MANDT`
Shipping Conditions Shipping Conditions Client	`C_LOADID.SHIPPINGCONDITION == TVSB.VSBED` `C_LOADID.MANDT == TVSB.MANDT`
Shipping Point / Receiving Point Client Shipping Point / Receiving Point	`C_LOADID.MANDT == TVST.MANDT` `C_LOADID.SHIPPINGPOINT == TVST.VSTEL`
Ship-to Party Client Ship-to Party	`C_LOADID.MANDT == KNA1.MANDT` `C_LOADID.SHIPTOPARTY == KNA1.KUNNR`
Sold-to Party Client Sold-to Party	`C_LOADID.MANDT == KNA1.MANDT` `C_LOADID.SOLDTOPARTY == KNA1.KUNNR`
Storage location Plant Client Storage location	`C_LOADID.PLANT == T001L.WERKS` `C_LOADID.MANDT == T001L.MANDT` `C_LOADID.STORAGELOCATION == T001L.LGORT`
Transportation planning point Client Transportation planning point	`C_LOADID.MANDT == TTDS.MANDT` `C_LOADID.TRANSPORTATIONPLANNINGPOINT == TTDS.TPLST`
TD Vehicle Number TD Vehicle Number Client	`C_LOADID.TRANSPORTATIONVEHICLE == OIGV.VEHICLE` `C_LOADID.MANDT == OIGV.CLIENT`
TD driver number TD driver number Client	`C_LOADID.TRANSPORTATIONVEHICLEDRIVER == OIGD.DRIVERCODE` `C_LOADID.MANDT == OIGD.CLIENT`
TD driver shift TD driver shift Client	`C_LOADID.TRANSPVEHICLEDRIVERSHIFT == TOIGH.SHIFT` `C_LOADID.MANDT == TOIGH.CLIENT`