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
  huhdr.HandlingUnitNumber 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,
  huhdr.HandlingUnitWeightTolerance AS HandlingUnitWeightTolerance,
  huhdr.HandlingUnitVolumeTolerance AS HandlingUnitVolumeTolerance,
  huhdr.HandlingUnitIsClosed 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,
  huhdr.ConsolidationGroup AS ConsolidationGroup,
  huhdr.WorkloadIdentification AS WorkloadIdentification,
  huhdr.EntitledToDisposeParty AS EntitledToDisposeParty,
  huhdr.HandlingUnitPackingGroup AS HandlingUnitPackingGroup,
  huhdr.HazardousSubstanceIndicator AS HazardousSubstanceIndicator,
  huhdr.HandlingUnitLogicalPosition AS HandlingUnitLogicalPosition,
  huhdr.ExternalStorageProcessStep AS ExternalStorageProcessStep,
  huhdr.ProcessStepCompletedInd AS ProcessStepCompletedInd,
  huhdr.StorageProcess 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,
  cast (' ' as route preserving type) AS Route,
  cast (' ' as /scdl/dl_tzone preserving type) AS TimeZoneName
FROM I_HandlingUnitShippingLabelFDP AS huhdr
LEFT OUTER JOIN E_HandlingUnitHeader AS _Extension ON HandlingUnitNumber = _Extension.HandlingUnitExternalID AND huhdr.HandlingUnitInternalID = _Extension.HandlingUnitInternalID  -- association [0..1]
;