C_LoadID

DDL: C_LOADID SQL: CLOADID Type: view CONSUMPTION
78 Fields 1 Data Sources

Load ID

C_LoadID is a Consumption CDS View that provides data about "Load ID" in SAP S/4HANA. It reads from 1 data source (I_LoadIDBasic) and exposes 78 fields with key field LoadID.

Data Sources (1)

SourceAliasJoin Type
I_LoadIDBasic I_LoadIDBasic from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CLOADID view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Load ID view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
UI.headerInfo.typeName Load ID view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value LoadID view

Fields (78)

KeyFieldSource TableSource FieldDescription
KEY LoadID LoadID Load ID
LoadIDType LoadIDType Load ID type
LoadIDDescription LoadIDDescription LID descr.
LoadIDControlStructure LoadIDControlStructure
LoadIDControlStructureType LoadIDControlStructureType CS type
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LoadIDActivationCode LoadIDActivationCode Activation ind.
LoadIDIsMarkedForDeletion LoadIDIsMarkedForDeletion Delet.ind.
LoadIDIsBlocked LoadIDIsBlocked Blocking ind.
LoadIDCtrlFldMsg LoadIDCtrlFldMsg
Plant Plant Valuation Area
StorageLocation StorageLocation StorageLocation
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
LoadIDTrip LoadIDTrip Trip Number
TransportationVehicle TransportationVehicle Vehicle Number
LoadIDValuationType LoadIDValuationType Valuation Type
ExciseDutyHandlingType ExciseDutyHandlingType Handling Type
LoadIDModeOfTransport LoadIDModeOfTransport Mode of transp.
SoldToParty SoldToParty Sold-to Party
ShipToParty ShipToParty Ship-To Party (obsolete)
TransportationPlanningPoint TransportationPlanningPoint TransportPlanPt
TransportationVehicleDriver TransportationVehicleDriver Driver
TranspVehicleDriverShift TranspVehicleDriverShift Driver shift
ShippingCondition ShippingCondition Shipping Conditions
ShippingPoint ShippingPoint Shipping Point
ThirdPartyLoadID ThirdPartyLoadID LID Depot
ThirdPartyLoadIDCode ThirdPartyLoadIDCode 3rd party code
LoadIDAddOnNumber LoadIDAddOnNumber TAS add.no.
ThirdPartyMaterialInformation ThirdPartyMaterialInformation MatInfo3rd
ThirdPartyDeliveryNumber ThirdPartyDeliveryNumber 3rd-p.del no.
ThirdPartyMaterialDescription ThirdPartyMaterialDescription MatText3rdParty
ThirdPartyCustomerInformation ThirdPartyCustomerInformation Customer3rdInfo
LoadIDUserField21 LoadIDUserField21
LoadIDUserField1 LoadIDUserField1 TAS user fld.
LoadIDUserField2 LoadIDUserField2 TAS user fld.
LoadIDUserField3 LoadIDUserField3 TAS user fld.
LoadIDUserField4 LoadIDUserField4 TAS user fld.
LoadIDUserField5 LoadIDUserField5 TAS user fld.
LoadIDUserField6 LoadIDUserField6 TAS user fld.
LoadIDUserField7 LoadIDUserField7 TAS user fld.
LoadIDUserField8 LoadIDUserField8 TAS user fld.
LoadIDUserField9 LoadIDUserField9 TAS user fld.
LoadIDUserField10 LoadIDUserField10 TAS user fld.
LoadIDUserField11 LoadIDUserField11 TAS user fld.
LoadIDUserField12 LoadIDUserField12 TAS user fld.
LoadIDUserField13 LoadIDUserField13 TAS user fld.
LoadIDUserField14 LoadIDUserField14 TAS user fld.
LoadIDUserField15 LoadIDUserField15 TAS user fld.
LoadIDUserField16 LoadIDUserField16 TAS user fld.
LoadIDUserField17 LoadIDUserField17 TAS user fld.
LoadIDUserField18 LoadIDUserField18 TAS user fld.
LoadIDUserField19 LoadIDUserField19 TAS user fld.
LoadIDUserField20 LoadIDUserField20 TAS user fld.
_LoadIDType _LoadIDType
_ShipToParty _ShipToParty
_SoldToParty _SoldToParty
_ShippingPoint _ShippingPoint
_Plant _Plant
_StorageLocation _StorageLocation
_MaterialGroup _MaterialGroup
_ExciseDutyHandlingType _ExciseDutyHandlingType
_BulkShptTranspPlngPt _BulkShptTranspPlngPt
_BulkShipmentVehicleHeader _BulkShipmentVehicleHeader
_TransportationMode _TransportationMode
_ShippingCondition _ShippingCondition
_ValuationType _ValuationType
_BulkShptTranspVehDriverShft _BulkShptTranspVehDriverShft
_LoadIDControlField _LoadIDControlField
_LoadIDCtrlStrucTypeText _LoadIDCtrlStrucTypeText
_BulkShptTranspVehicleDriver _BulkShptTranspVehicleDriver
_Material _Material
_LoadIDReferenceDocument _LoadIDReferenceDocument
_LoadIDActivationCode _LoadIDActivationCode
_LoadIDIsMarkedForDeletion _LoadIDIsMarkedForDeletion
_LoadIDIsBlocked _LoadIDIsBlocked
_LoadIDControlStructure _LoadIDControlStructure

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_LoadID.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CLOADID

CREATE VIEW C_LoadID AS
SELECT
  LoadID,
  LoadIDType,
  LoadIDDescription,
  LoadIDControlStructure,
  LoadIDControlStructureType,
  CreatedByUser,
  CreationDate,
  LoadIDActivationCode,
  LoadIDIsMarkedForDeletion,
  LoadIDIsBlocked,
  LoadIDCtrlFldMsg,
  Plant,
  StorageLocation,
  Material,
  MaterialGroup,
  LoadIDTrip,
  TransportationVehicle,
  LoadIDValuationType,
  ExciseDutyHandlingType,
  LoadIDModeOfTransport,
  SoldToParty,
  ShipToParty,
  TransportationPlanningPoint,
  TransportationVehicleDriver,
  TranspVehicleDriverShift,
  ShippingCondition,
  ShippingPoint,
  ThirdPartyLoadID,
  ThirdPartyLoadIDCode,
  LoadIDAddOnNumber,
  ThirdPartyMaterialInformation,
  ThirdPartyDeliveryNumber,
  ThirdPartyMaterialDescription,
  ThirdPartyCustomerInformation,
  LoadIDUserField21,
  LoadIDUserField1,
  LoadIDUserField2,
  LoadIDUserField3,
  LoadIDUserField4,
  LoadIDUserField5,
  LoadIDUserField6,
  LoadIDUserField7,
  LoadIDUserField8,
  LoadIDUserField9,
  LoadIDUserField10,
  LoadIDUserField11,
  LoadIDUserField12,
  LoadIDUserField13,
  LoadIDUserField14,
  LoadIDUserField15,
  LoadIDUserField16,
  LoadIDUserField17,
  LoadIDUserField18,
  LoadIDUserField19,
  LoadIDUserField20
FROM I_LoadIDBasic
;

Learn More