I_LoadIDBasic

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 I_LoadIDBasic.
-- 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: ILOADIDBASIC

CREATE VIEW I_LoadIDBasic AS
SELECT
  lidno AS LoadID,
  lidtype AS LoadIDType,
  contrtyp AS LoadIDControlStructureType,
  liddesc AS LoadIDDescription,
  creaauthor AS CreatedByUser,
  creadate AS CreationDate,
  werks AS Plant,
  matnr AS Material,
  liddepot AS ThirdPartyLoadID,
  lid3cod1 AS ThirdPartyLoadIDCode,
  lid3rdprty AS ThirdPartyDeliveryNumber,
  matnr3rdp AS ThirdPartyMaterialInformation,
  mattxt3rdp AS ThirdPartyMaterialDescription,
  cust3rdp AS ThirdPartyCustomerInformation,
  matnrtas AS ThirdPartyMaterial,
  addittas AS LoadIDAddOnNumber,
  userfld1 AS LoadIDUserField1,
  userfld2 AS LoadIDUserField2,
  userfld3 AS LoadIDUserField3,
  userfld4 AS LoadIDUserField4,
  userfld5 AS LoadIDUserField5,
  userfld6 AS LoadIDUserField6,
  userfld7 AS LoadIDUserField7,
  userfld8 AS LoadIDUserField8,
  userfld9 AS LoadIDUserField9,
  userfld10 AS LoadIDUserField10,
  userfld11 AS LoadIDUserField11,
  userfld12 AS LoadIDUserField12,
  userfld13 AS LoadIDUserField13,
  userfld14 AS LoadIDUserField14,
  userfld15 AS LoadIDUserField15,
  userfld16 AS LoadIDUserField16,
  userfld17 AS LoadIDUserField17,
  userfld18 AS LoadIDUserField18,
  userfld19 AS LoadIDUserField19,
  userfld20 AS LoadIDUserField20,
  cast( '' as abap.char(30) ) AS LoadIDUserField21,
  cast( '' as abap.char(1) ) AS LoadIDCtrlFldMsg,
  lidactind AS LoadIDActivationCode,
  liddelind AS LoadIDIsMarkedForDeletion,
  lidblkind AS LoadIDIsBlocked,
  shipto AS ShipToParty,
  soldto AS SoldToParty,
  lgort AS StorageLocation,
  matkl AS MaterialGroup,
  oihantyp AS ExciseDutyHandlingType,
  tplst AS TransportationPlanningPoint,
  vehicle AS TransportationVehicle,
  drivercode AS TransportationVehicleDriver,
  shift AS TranspVehicleDriverShift,
  trip AS LoadIDTrip,
  bwtar AS LoadIDValuationType,
  vstel AS ShippingPoint,
  oic_mot AS LoadIDModeOfTransport,
  vsbed AS ShippingCondition,
  _LoadIDControlField.LoadIDControlStructure AS LoadIDControlStructure
FROM oiklid
LEFT OUTER JOIN I_LoadIDType AS _LoadIDType ON LoadIDType = _LoadIDType.LoadIDType AND LoadIDControlStructureType = _LoadIDType.LoadIDControlStructureType  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON ShippingPoint = _ShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON StorageLocation = _StorageLocation.StorageLocation AND Plant = _StorageLocation.Plant  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_ExciseDutyHandlingType AS _ExciseDutyHandlingType ON ExciseDutyHandlingType = _ExciseDutyHandlingType.ExciseDutyHandlingType  -- association [0..1]
LEFT OUTER JOIN I_BulkShptTranspPlngPt AS _BulkShptTranspPlngPt ON TransportationPlanningPoint = _BulkShptTranspPlngPt.TransportationPlanningPoint  -- association [0..1]
LEFT OUTER JOIN I_BulkShipmentVehicleHeader AS _BulkShipmentVehicleHeader ON TransportationVehicle = _BulkShipmentVehicleHeader.TransportationVehicle  -- association [0..1]
LEFT OUTER JOIN I_TransportationMode AS _TransportationMode ON LoadIDModeOfTransport = _TransportationMode.TransportationMode  -- association [0..1]
LEFT OUTER JOIN I_ShippingCondition AS _ShippingCondition ON ShippingCondition = _ShippingCondition.ShippingCondition  -- association [0..1]
LEFT OUTER JOIN I_InventoryValuationType AS _ValuationType ON LoadIDValuationType = _ValuationType.InventoryValuationType  -- association [0..1]
LEFT OUTER JOIN I_BulkShptTranspVehDriverShft AS _BulkShptTranspVehDriverShft ON TranspVehicleDriverShift = _BulkShptTranspVehDriverShft.TranspVehicleDriverShift  -- association [0..1]
LEFT OUTER JOIN I_LoadIDControlField AS _LoadIDControlField ON LoadID = _LoadIDControlField.LoadID  -- association [0..1]
LEFT OUTER JOIN I_LoadIDCtrlStrucTypeText AS _LoadIDCtrlStrucTypeText ON LoadIDControlStructureType = _LoadIDCtrlStrucTypeText.LoadIDControlStructureType  -- association [0..*]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_BulkShptTranspVehicleDriver AS _BulkShptTranspVehicleDriver ON TransportationVehicleDriver = _BulkShptTranspVehicleDriver.TransportationVehicleDriver  -- association [0..1]
LEFT OUTER JOIN I_LoadIDStatusText AS _LoadIDActivationCode ON LoadIDActivationCode = _LoadIDActivationCode.LoadIDStatus AND _LoadIDActivationCode.ABAPDomain = 'OIK_ACTIND'  -- association [0..*]
LEFT OUTER JOIN I_LoadIDStatusText AS _LoadIDIsMarkedForDeletion ON LoadIDIsMarkedForDeletion = _LoadIDIsMarkedForDeletion.LoadIDStatus AND _LoadIDIsMarkedForDeletion.ABAPDomain = 'OIK_DELIND'  -- association [0..*]
LEFT OUTER JOIN I_LoadIDStatusText AS _LoadIDIsBlocked ON LoadIDIsBlocked = _LoadIDIsBlocked.LoadIDStatus AND _LoadIDIsBlocked.ABAPDomain = 'OIK_BLKIND'  -- association [0..*]
LEFT OUTER JOIN I_LoadIDControlStructure AS _LoadIDControlStructure ON LoadIDControlStructure = _LoadIDControlStructure.LoadIDControlStructure AND LoadIDControlStructureType = _LoadIDControlStructure.LoadIDControlStructureType  -- association [0..1]
;