C_InboundDeliveryManage_F7286

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_InboundDeliveryManage_F7286.
-- 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.

CREATE VIEW C_InboundDeliveryManage_F7286 AS
SELECT
  cast(InboundDelivery as inbound_delivery preserving type) AS InboundDelivery,
  SDDocumentCategory,
  InboundDelivery.DeliveryDocumentType AS DeliveryDocumentType,
  InboundDelivery.GoodsReceivingPoint AS GoodsReceivingPoint,
  InboundDelivery.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
  InboundDelivery.DeliveryPriority AS DeliveryPriority,
  InboundDelivery.DeliveryBlockReason AS DeliveryBlockReason,
  InboundDelivery.DeliveryDocumentBySupplier AS DeliveryDocumentBySupplier,
  InboundDelivery.DeliveryIsInPlant AS DeliveryIsInPlant,
  InboundDelivery.DocumentDate AS DocumentDate,
  InboundDelivery.ExternalIdentificationType AS ExternalIdentificationType,
  InboundDelivery.GoodsMovementSlipNumber AS GoodsMovementSlipNumber,
  InboundDelivery.HeaderGrossWeight AS HeaderGrossWeight,
  InboundDelivery.HeaderNetWeight AS HeaderNetWeight,
  InboundDelivery.HeaderVolume AS HeaderVolume,
  InboundDelivery.HeaderVolumeUnit AS HeaderVolumeUnit,
  InboundDelivery.HeaderWeightUnit AS HeaderWeightUnit,
  InboundDelivery.IsExportDelivery AS IsExportDelivery,
  InboundDelivery.MeansOfTransportRefMaterial AS MeansOfTransportRefMaterial,
  InboundDelivery.OrderCombinationIsAllowed AS OrderCombinationIsAllowed,
  InboundDelivery.ReceivingPlant AS ReceivingPlant,
  InboundDelivery.SpecialProcessingCode AS SpecialProcessingCode,
  InboundDelivery.Supplier AS Supplier,
  InboundDelivery.Warehouse AS Warehouse,
  InboundDelivery.WarehouseGate AS WarehouseGate,
  InboundDelivery.WarehouseStagingArea AS WarehouseStagingArea,
  InboundDelivery.TotalNumberOfPackage AS TotalNumberOfPackage,
  InboundDelivery.LoadingDate AS LoadingDate,
  InboundDelivery.LoadingTime AS LoadingTime,
  InboundDelivery.BillOfLading AS BillOfLading,
  InboundDelivery.HandlingUnitInStock AS HandlingUnitInStock,
  InboundDelivery.DeliveryDate AS DeliveryDate,
  InboundDelivery.DeliveryTime AS DeliveryTime,
  InboundDelivery.ShippingCondition AS ShippingCondition,
  InboundDelivery.ShippingType AS ShippingType,
  InboundDelivery.ShipmentBlockReason AS ShipmentBlockReason,
  InboundDelivery.TransportationPlanningDate AS TransportationPlanningDate,
  InboundDelivery.TransportationPlanningTime AS TransportationPlanningTime,
  InboundDelivery.RouteSchedule AS RouteSchedule,
  InboundDelivery.PlannedGoodsMovementDate AS PlannedGoodsMovementDate,
  InboundDelivery.PlannedGoodsMovementTime AS PlannedGoodsMovementTime,
  InboundDelivery.ActualGoodsMovementDate AS ActualGoodsMovementDate,
  InboundDelivery.ActualGoodsMovementTime AS ActualGoodsMovementTime,
  InboundDelivery.IncotermsClassification AS IncotermsClassification,
  InboundDelivery.IncotermsTransferLocation AS IncotermsTransferLocation,
  InboundDelivery.ExternalTransportSystem AS ExternalTransportSystem,
  InboundDelivery.TransportationGroup AS TransportationGroup,
  InboundDelivery.MeansOfTransport AS MeansOfTransport,
  InboundDelivery.MeansOfTransportType AS MeansOfTransportType,
  InboundDelivery.ProofOfDeliveryDate AS ProofOfDeliveryDate,
  InboundDelivery.ProofOfDeliveryTime AS ProofOfDeliveryTime,
  InboundDelivery.FactoryCalendarByCustomer AS FactoryCalendarByCustomer,
  InboundDelivery.ShippingLocationTimeZone AS ShippingLocationTimeZone,
  InboundDelivery.ReceivingLocationTimeZone AS ReceivingLocationTimeZone,
  InboundDelivery.IntercompanyBillingDate AS IntercompanyBillingDate,
  InboundDelivery.BillingDocumentDate AS BillingDocumentDate,
  InboundDelivery.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  InboundDelivery.InternalFinancialDocument AS InternalFinancialDocument,
  InboundDelivery.PaymentGuaranteeProcedure AS PaymentGuaranteeProcedure,
  InboundDelivery.DepreciationInPercent AS DepreciationInPercent,
  InboundDelivery.CustomerGroup AS CustomerGroup,
  InboundDelivery.TransactionCurrency AS TransactionCurrency,
  InboundDelivery.StatisticsCurrency AS StatisticsCurrency,
  InboundDelivery.OverallIntcoBillingStatus AS OverallIntcoBillingStatus,
  InboundDelivery.OverallDeliveryProcessStatus AS OverallDeliveryProcessStatus,
  InboundDelivery.OverallDelivConfStatus AS OverallDelivConfStatus,
  InboundDelivery.OverallPutawayConfStatus AS OverallPutawayConfStatus,
  InboundDelivery.OverallPutawayStatus AS OverallPutawayStatus,
  InboundDelivery.OverallPackingStatus AS OverallPackingStatus,
  InboundDelivery.OverallWarehouseActivityStatus AS OverallWarehouseActivityStatus,
  InboundDelivery.DistrStatusByDecentralizedWrhs AS DistrStatusByDecentralizedWrhs,
  InboundDelivery.OverallGoodsMovementStatus AS OverallGoodsMovementStatus,
  InboundDelivery.OverallDelivReltdBillgStatus AS OverallDelivReltdBillgStatus,
  InboundDelivery.OverallProofOfDeliveryStatus AS OverallProofOfDeliveryStatus,
  InboundDelivery.TotalCreditCheckStatus AS TotalCreditCheckStatus,
  InboundDelivery.HdrGeneralIncompletionStatus AS HdrGeneralIncompletionStatus,
  InboundDelivery.HeaderDelivIncompletionStatus AS HeaderDelivIncompletionStatus,
  InboundDelivery.HeaderPutawayIncompltnStatus AS HeaderPutawayIncompltnStatus,
  InboundDelivery.HeaderPackingIncompletionSts AS HeaderPackingIncompletionSts,
  InboundDelivery.HdrGoodsMvtIncompletionStatus AS HdrGoodsMvtIncompletionStatus,
  InboundDelivery.HeaderBillgIncompletionStatus AS HeaderBillgIncompletionStatus,
  InboundDelivery.TransportationPlanningStatus AS TransportationPlanningStatus,
  InboundDelivery.OvrlItmDelivIncompletionSts AS OvrlItmDelivIncompletionSts,
  InboundDelivery.OvrlItmGdsMvtIncompletionSts AS OvrlItmGdsMvtIncompletionSts,
  InboundDelivery.OvrlItmGeneralIncompletionSts AS OvrlItmGeneralIncompletionSts,
  InboundDelivery.OvrlItmPackingIncompletionSts AS OvrlItmPackingIncompletionSts,
  InboundDelivery.OvrlItmPutawayIncompletionSts AS OvrlItmPutawayIncompletionSts,
  cast(CreatedByUser as abp_creation_user preserving type ) AS CreatedByUser,
  cast(CreationDate as abp_creation_date preserving type ) AS CreationDate,
  cast(CreationTime as abp_creation_time preserving type ) AS CreationTime,
  cast(LastChangedByUser as abp_lastchange_user preserving type ) AS LastChangedByUser,
  cast(LastChangeDate as abp_lastchange_date preserving type ) AS LastChangeDate
FROM R_InboundDeliveryTP
LEFT OUTER JOIN I_DeliveryDocumentTypeStdVH AS _DeliveryDocumentType ON DeliveryDocumentType = _DeliveryDocumentType.DeliveryDocumentType  -- association [0..1]
LEFT OUTER JOIN I_DeliveryPriorityStdVH AS _DeliveryPriority ON DeliveryPriority = _DeliveryPriority.DeliveryPriority  -- association [0..1]
LEFT OUTER JOIN I_DeliveryBlockReasonStdVH AS _DeliveryBlockReason ON DeliveryBlockReason = _DeliveryBlockReason.DeliveryBlockReason  -- association [0..1]
LEFT OUTER JOIN I_DelivDocSuplrIdnType AS _ExternalIdentificationType ON ExternalIdentificationType = _ExternalIdentificationType.ExternalIdentificationType  -- association [0..1]
LEFT OUTER JOIN I_MaterialStdVH AS _MeansOfTransportRefMaterial ON MeansOfTransportRefMaterial = _MeansOfTransportRefMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_PlantStdVH AS _ReceivingPlant ON ReceivingPlant = _ReceivingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_SpecialProcessingCode AS _SpecialProcessingCode ON SpecialProcessingCode = _SpecialProcessingCode.SpecialProcessingCode  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN C_GoodsReceivingPointVH AS _GoodsReceivingPoint ON GoodsReceivingPoint = _GoodsReceivingPoint.GoodsReceivingPoint  -- association [0..1]
LEFT OUTER JOIN C_PutawayStatusByDelivery AS _PutawayStatusByDelivery ON InboundDelivery = _PutawayStatusByDelivery.InboundDelivery  -- association [0..1]
LEFT OUTER JOIN C_OvrlDelivProcessStatus_F7286 AS _OverallDeliveryProcessStatus ON OverallDeliveryProcessStatus = _OverallDeliveryProcessStatus.OverallDeliveryProcessStatus  -- association [0..1]
LEFT OUTER JOIN C_OvrlGdsMovementStatus_F7286 AS _OverallGoodsMovementStatus ON OverallGoodsMovementStatus = _OverallGoodsMovementStatus.OverallGoodsMovementStatus  -- association [0..1]
LEFT OUTER JOIN C_OvrlPtwyConfStatus_F7286 AS _OverallPutawayConfStatus ON OverallPutawayConfStatus = _OverallPutawayConfStatus.OverallPutawayConfStatus  -- association [0..1]
LEFT OUTER JOIN C_OverallPutawayStatus_F7286 AS _OverallPutawayStatus ON OverallPutawayStatus = _OverallPutawayStatus.PutawayStatus  -- association [0..1]
LEFT OUTER JOIN C_OverallPackingStatus_F7286 AS _OverallPackingStatus ON OverallPackingStatus = _OverallPackingStatus.OverallPackingStatus  -- association [0..1]
LEFT OUTER JOIN C_OvrlWhseActivityStatus_F7286 AS _OvrlWarehouseActyStatus ON OverallWarehouseActivityStatus = _OvrlWarehouseActyStatus.OverallWarehouseActivityStatus  -- association [0..1]
LEFT OUTER JOIN C_DistrStsByDcntrlzdWrhs_F7286 AS _DistrStatusByDectrlzdWrhs ON DistrStatusByDecentralizedWrhs = _DistrStatusByDectrlzdWrhs.DistrStatusByDecentralizedWrhs  -- association [0..1]
LEFT OUTER JOIN C_OvrlDelivReltdBillgSts_F7286 AS _OverallIntcoBillingStatus ON OverallIntcoBillingStatus = _OverallIntcoBillingStatus.OverallDelivReltdBillgStatus  -- association [0..1]
LEFT OUTER JOIN C_OvrlDelivReltdBillgSts_F7286 AS _OverallDelivReltdBillgStatus ON OverallDelivReltdBillgStatus = _OverallDelivReltdBillgStatus.OverallDelivReltdBillgStatus  -- association [0..1]
LEFT OUTER JOIN C_OvrlDelivConfStatus_F7286 AS _OverallDelivConfStatus ON OverallDelivConfStatus = _OverallDelivConfStatus.OverallDelivConfStatus  -- association [0..1]
LEFT OUTER JOIN C_OvrlProofOfDelivStatus_F7286 AS _OverallProofOfDeliveryStatus ON OverallProofOfDeliveryStatus = _OverallProofOfDeliveryStatus.OverallProofOfDeliveryStatus  -- association [0..1]
LEFT OUTER JOIN C_TotalCreditCheckStatus_F7286 AS _TotalCreditCheckStatus ON TotalCreditCheckStatus = _TotalCreditCheckStatus.TotalCreditCheckStatus  -- association [0..1]
LEFT OUTER JOIN C_HdrGdsMvtIncompltnSts_F7286 AS _HdrGoodsMvtIncompletionStatus ON HdrGoodsMvtIncompletionStatus = _HdrGoodsMvtIncompletionStatus.HdrGoodsMvtIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN C_HdrBillgIncompltnSts_F7286 AS _HdrBillingIncompletionStatus ON HeaderBillgIncompletionStatus = _HdrBillingIncompletionStatus.HeaderBillgIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN C_HdrTranspPlngStatus_F7286 AS _HdrTranspPlanningStatus ON TransportationPlanningStatus = _HdrTranspPlanningStatus.TransportationPlanningStatus  -- association [0..1]
LEFT OUTER JOIN C_HdrGenIncompltnStatus_F7286 AS _HdrGeneralIncompletionStatus ON HdrGeneralIncompletionStatus = _HdrGeneralIncompletionStatus.HdrGeneralIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN C_HdrDelivIncompltnSts_F7286 AS _HeaderDelivIncompletionStatus ON HeaderDelivIncompletionStatus = _HeaderDelivIncompletionStatus.HeaderDelivIncompletionStatus  -- association [0..1]
LEFT OUTER JOIN C_HdrPtwyIncompltnStatus_F7286 AS _HeaderPutawayIncompltnStatus ON HeaderPutawayIncompltnStatus = _HeaderPutawayIncompltnStatus.HeaderPutawayIncompltnStatus  -- association [0..1]
LEFT OUTER JOIN C_HdrPackgIncompltnSts_F7286 AS _HeaderPackingIncompletionSts ON HeaderPackingIncompletionSts = _HeaderPackingIncompletionSts.HeaderPackingIncompletionSts  -- association [0..1]
LEFT OUTER JOIN C_OvrlItmGenIncompltnSts_F7286 AS _OvrlItmGeneralIncompletionSts ON OvrlItmGeneralIncompletionSts = _OvrlItmGeneralIncompletionSts.OvrlItmGeneralIncompletionSts  -- association [0..1]
LEFT OUTER JOIN C_OvrlItmPackgIncplSts_F7286 AS _OvrlItmPackingIncompletionSts ON OvrlItmPackingIncompletionSts = _OvrlItmPackingIncompletionSts.OvrlItmPackingIncompletionSts  -- association [0..1]
LEFT OUTER JOIN C_OvrlItmPtwyIncplSts_F7286 AS _OvrlItmPutawayIncompletionSts ON OvrlItmPutawayIncompletionSts = _OvrlItmPutawayIncompletionSts.OvrlItmPutawayIncompletionSts  -- association [0..1]
LEFT OUTER JOIN C_OvrlItmDelivIncplSts_F7286 AS _OvrlItmDelivIncompletionSts ON OvrlItmDelivIncompletionSts = _OvrlItmDelivIncompletionSts.OvrlItmDelivIncompletionSts  -- association [0..1]
LEFT OUTER JOIN C_OvrlItmGdsMvtIncplSts_F7286 AS _OvrlItmGdsMvtIncompletionSts ON OvrlItmGdsMvtIncompletionSts = _OvrlItmGdsMvtIncompletionSts.OvrlItmGdsMvtIncompletionSts  -- association [0..1]
;