C_HandlingUnitShippingLabelFDP

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_HandlingUnitShippingLabelFDP.
-- 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: CHUSHIPLABEL

CREATE VIEW C_HandlingUnitShippingLabelFDP AS
SELECT
  HandlingUnitExternalID AS HandlingUnitNumber,
  Warehouse,
  PackagingMaterial,
  HandlingUnitTareWeight,
  HandlingUnitTareWeightUnit,
  GrossVolume,
  HandlingUnitNetVolume,
  VolumeUnit,
  HandlingUnitTareVolume,
  HandlingUnitTareVolumeUnit,
  HandlingUnitLength,
  HandlingUnitWidth,
  HandlingUnitHeight,
  UnitOfMeasureDimension,
  HandlingUnitReferenceDocument,
  HandlingUnitProcessStatus,
  cast ( ' ' as /scwm/vhi preserving type) AS HandlingUnitIndicator,
  cast ( 0 as /scwm/de_quantity ) AS HandlingUnitQuantity,
  cast ( ' ' as meins ) AS HandlingUnitQuantityUnit,
  cast ( ' ' as /scwm/de_charg preserving type) AS Batch,
  cast ( ' ' as ean11 preserving type ) AS InternationalArticleNumber,
  cast ( ' ' as /scwm/de_matnr preserving type) AS Product,
  cast ( ' ' as /scwm/de_ui_maktx preserving type) AS ProductDescription,
  cast ( ' ' as lines preserving type) AS ShipToPartyAddressLine1Text,
  cast ( ' ' as lines preserving type) AS ShipToPartyAddressLine2Text,
  cast ( ' ' as lines preserving type) AS ShipToPartyAddressLine3Text,
  cast ( ' ' as lines preserving type) AS ShipToPartyAddressLine4Text,
  cast ( ' ' as lines preserving type) AS ShipToPartyAddressLine5Text,
  cast ( ' ' as lines preserving type) AS ShipToPartyAddressLine6Text,
  cast ( ' ' as lines preserving type) AS ShipToPartyAddressLine7Text,
  cast ( ' ' as lines preserving type) AS ShipToPartyAddressLine8Text,
  cast ( ' ' as lines preserving type) AS ShipFromPartyAddressLine1Text,
  cast ( ' ' as lines preserving type) AS ShipFromPartyAddressLine2Text,
  cast ( ' ' as lines preserving type) AS ShipFromPartyAddressLine3Text,
  cast ( ' ' as lines preserving type) AS ShipFromPartyAddressLine4Text,
  cast ( ' ' as lines preserving type) AS ShipFromPartyAddressLine5Text,
  cast ( ' ' as lines preserving type) AS ShipFromPartyAddressLine6Text,
  cast ( ' ' as lines preserving type) AS ShipFromPartyAddressLine7Text,
  cast ( ' ' as lines preserving type) AS ShipFromPartyAddressLine8Text,
  cast ( ' ' as /scwm/barcode_print preserving type) AS BarCodeLine1,
  cast ( ' ' as /scwm/barcode_print preserving type) AS BarCodeLine2,
  cast ( ' ' as /scwm/barcode_print preserving type) AS BarCodeLine3,
  cast ( ' ' as /scwm/barcode_print preserving type) AS BarCodeLine1Text,
  cast ( ' ' as /scwm/barcode_print preserving type) AS BarCodeLine2Text,
  cast ( ' ' as /scwm/barcode_print preserving type) AS BarCodeLine3Text,
  fltp_to_dec( 0.0 as abap.dec(3,1) ) AS HandlingUnitWeightTolerance,
  fltp_to_dec( 0.0 as abap.dec(3,1) ) AS HandlingUnitVolumeTolerance,
  cast ( ' ' as boole_d preserving type) AS HandlingUnitIsClosed,
  huhdr.HandlingUnitMaxVolume AS HandlingUnitMaxVolume,
  huhdr.HandlingUnitMaxLength AS HandlingUnitMaxLength,
  huhdr.HandlingUnitMaxWidth AS HandlingUnitMaxWidth,
  huhdr.HandlingUnitMaxHeight AS HandlingUnitMaxHeight,
  huhdr.HandlingUnitMaxDimensionUnit AS HandlingUnitMaxDimensionUnit,
  huhdr.HandlingUnitType AS HandlingUnitType,
  huhdr.StorageType AS StorageType,
  huhdr.StorageSection AS StorageSection,
  huhdr.StorageBin AS StorageBin,
  cast ( ' ' as /scwm/de_dstgrp preserving type) AS ConsolidationGroup,
  cast ( '123456789012' as /scwm/de_wklid preserving type) AS WorkloadIdentification,
  cast ( ' ' as /scwm/de_entitled preserving type) AS EntitledToDisposeParty,
  cast ( ' ' as /scwm/de_packgr preserving type) AS HandlingUnitPackingGroup,
  cast ( ' ' as /scmb/de_hazmat preserving type) AS HazardousSubstanceIndicator,
  cast ( ' ' as /scwm/de_logpos preserving type) AS HandlingUnitLogicalPosition,
  cast ( ' ' as /scwm/de_procs preserving type) AS ExternalStorageProcessStep,
  cast ( ' ' as /scwm/de_copst preserving type) AS ProcessStepCompletedInd,
  cast ( ' ' as /scwm/de_prces preserving type) AS StorageProcess,
  GrossWeight,
  NetWeight,
  HandlingUnitMaxWeight,
  WeightUnit,
  PackagingMaterialType,
  cast ( ' ' as vbeln_vl preserving type ) AS DeliveryDocument,
  cast ( '000000' as posnr_vl preserving type ) AS DeliveryItem,
  cast ( ' ' as ablad preserving type ) AS UnloadingPointName,
  cast ( ' ' as knref preserving type ) AS CustomerPartnerDescription,
  cast ( '00010101' as hsdat ) AS ManufactureDate,
  cast ( '00010101' as hsdat ) AS ShelfLifeExpirationDate,
  cast ('00010101' as wadat_ist ) AS ActualGoodsMovementDate,
  cast ('00010101' as wadat ) AS GoodsMovementDate,
  cast ( '00010101' as dats ) AS DeliveryDate,
  cast ( '00010101' as dats ) AS HandlingUnitShippingLabelDate,
  cast ( '000101' as tims ) AS DeliveryTime,
  cast ( ' ' as land1 ) AS CountryOfOrigin,
  cast ( ' ' as hu_shipping_label_date_code preserving type ) AS HandlingUnitShipLabelDateCode,
  cast ( ' ' as name1 preserving type ) AS Customer,
  cast ( ' ' as werks_d preserving type ) AS DestinationPlant,
  cast ( ' ' as empst preserving type ) AS DestinationLocationName,
  cast ( 0 as vemng ) AS Quantity,
  cast ( ' ' as matnr preserving type ) AS Material,
  cast ( ' ' as eikto_m preserving type ) AS SupplierAccountNumberSoldTo,
  cast ( ' ' as eikto_m preserving type ) AS SupplierAccountNumberShipTo,
  cast ( ' ' as aeskd preserving type ) AS CustEngineeringChgStatus,
  cast ( ' ' as vbrst preserving type ) AS CustomerPointOfConsumption,
  cast ( ' ' as matnr_ku preserving type ) AS MaterialByCustomer,
  cast ( ' ' as matnr_ku preserving type ) AS HandlingUnitCustomerPackMat,
  cast ( ' ' as kdptx preserving type ) AS MaterialDescriptionByCustomer,
  cast ( 1234567890 as int4 preserving type ) AS NumberOfItems,
  cast ( ' ' as char10 preserving type ) AS HandlingUnitLabelType,
  cast ( ' ' as hu_content_type preserving type ) AS HandlingUnitContentType
FROM I_HandlingUnitHeaderCombined AS huhdr
LEFT OUTER JOIN E_HandlingUnitHeader AS _Extension ON HandlingUnitNumber = _Extension.HandlingUnitExternalID  -- association [0..1]
;