C_HandlingUnitShippingLabelFDP
Form Data Provider HU Shippping Label
C_HandlingUnitShippingLabelFDP is a Consumption CDS View that provides data about "Form Data Provider HU Shippping Label" in SAP S/4HANA. It reads from 1 data source (I_HandlingUnitHeaderCombined) and exposes 99 fields with key fields HandlingUnitNumber, Warehouse. It has 1 association to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_HandlingUnitHeaderCombined | huhdr | from |
Associations (1)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_HandlingUnitHeader | _Extension | $projection.HandlingUnitNumber = _Extension.HandlingUnitExternalID |
Annotations (12)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | CHUSHIPLABEL | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Form Data Provider HU Shippping Label | view | |
| VDM.viewType | #CONSUMPTION | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.modelingPattern | #OUTPUT_FORM_DATA_PROVIDER | view |
Fields (99)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | HandlingUnitNumber | HandlingUnitExternalID | ||
| KEY | Warehouse | Warehouse | ||
| PackagingMaterial | PackagingMaterial | |||
| HandlingUnitTareWeight | HandlingUnitTareWeight | |||
| HandlingUnitTareWeightUnit | HandlingUnitTareWeightUnit | |||
| GrossVolume | GrossVolume | |||
| HandlingUnitNetVolume | HandlingUnitNetVolume | |||
| VolumeUnit | VolumeUnit | |||
| HandlingUnitTareVolume | HandlingUnitTareVolume | |||
| HandlingUnitTareVolumeUnit | HandlingUnitTareVolumeUnit | |||
| HandlingUnitLength | HandlingUnitLength | |||
| HandlingUnitWidth | HandlingUnitWidth | |||
| HandlingUnitHeight | HandlingUnitHeight | |||
| UnitOfMeasureDimension | UnitOfMeasureDimension | |||
| HandlingUnitReferenceDocument | HandlingUnitReferenceDocument | |||
| HandlingUnitProcessStatus | HandlingUnitProcessStatus | |||
| HandlingUnitIndicator | ||||
| HandlingUnitQuantity | ||||
| HandlingUnitQuantityUnit | ||||
| Batch | ||||
| InternationalArticleNumber | ||||
| Product | ||||
| ProductDescription | ||||
| ShipToPartyAddressLine1Text | ||||
| ShipToPartyAddressLine2Text | ||||
| ShipToPartyAddressLine3Text | ||||
| ShipToPartyAddressLine4Text | ||||
| ShipToPartyAddressLine5Text | ||||
| ShipToPartyAddressLine6Text | ||||
| ShipToPartyAddressLine7Text | ||||
| ShipToPartyAddressLine8Text | ||||
| ShipFromPartyAddressLine1Text | ||||
| ShipFromPartyAddressLine2Text | ||||
| ShipFromPartyAddressLine3Text | ||||
| ShipFromPartyAddressLine4Text | ||||
| ShipFromPartyAddressLine5Text | ||||
| ShipFromPartyAddressLine6Text | ||||
| ShipFromPartyAddressLine7Text | ||||
| ShipFromPartyAddressLine8Text | ||||
| BarCodeLine1 | ||||
| BarCodeLine2 | ||||
| BarCodeLine3 | ||||
| BarCodeLine1Text | ||||
| BarCodeLine2Text | ||||
| BarCodeLine3Text | ||||
| HandlingUnitWeightTolerance | ||||
| HandlingUnitVolumeTolerance | ||||
| HandlingUnitIsClosed | ||||
| HandlingUnitMaxVolume | I_HandlingUnitHeaderCombined | HandlingUnitMaxVolume | ||
| HandlingUnitMaxLength | I_HandlingUnitHeaderCombined | HandlingUnitMaxLength | ||
| HandlingUnitMaxWidth | I_HandlingUnitHeaderCombined | HandlingUnitMaxWidth | ||
| HandlingUnitMaxHeight | I_HandlingUnitHeaderCombined | HandlingUnitMaxHeight | ||
| HandlingUnitMaxDimensionUnit | I_HandlingUnitHeaderCombined | HandlingUnitMaxDimensionUnit | ||
| HandlingUnitType | I_HandlingUnitHeaderCombined | HandlingUnitType | ||
| StorageType | I_HandlingUnitHeaderCombined | StorageType | ||
| StorageSection | I_HandlingUnitHeaderCombined | StorageSection | ||
| StorageBin | I_HandlingUnitHeaderCombined | StorageBin | ||
| ConsolidationGroup | ||||
| WorkloadIdentification | ||||
| EntitledToDisposeParty | ||||
| HandlingUnitPackingGroup | ||||
| HazardousSubstanceIndicator | ||||
| HandlingUnitLogicalPosition | ||||
| ExternalStorageProcessStep | ||||
| ProcessStepCompletedInd | ||||
| StorageProcess | ||||
| GrossWeight | GrossWeight | |||
| NetWeight | NetWeight | |||
| HandlingUnitMaxWeight | HandlingUnitMaxWeight | |||
| WeightUnit | WeightUnit | |||
| PackagingMaterialType | PackagingMaterialType | |||
| DeliveryDocument | ||||
| DeliveryItem | ||||
| UnloadingPointName | ||||
| CustomerPartnerDescription | ||||
| ManufactureDate | ||||
| ShelfLifeExpirationDate | ||||
| ActualGoodsMovementDate | ||||
| GoodsMovementDate | ||||
| DeliveryDate | ||||
| HandlingUnitShippingLabelDate | ||||
| DeliveryTime | ||||
| CountryOfOrigin | ||||
| HandlingUnitShipLabelDateCode | ||||
| Customer | ||||
| DestinationPlant | ||||
| DestinationLocationName | ||||
| Quantity | ||||
| Material | ||||
| SupplierAccountNumberSoldTo | ||||
| SupplierAccountNumberShipTo | ||||
| CustEngineeringChgStatus | ||||
| CustomerPointOfConsumption | ||||
| MaterialByCustomer | ||||
| HandlingUnitCustomerPackMat | ||||
| MaterialDescriptionByCustomer | ||||
| NumberOfItems | ||||
| HandlingUnitLabelType | ||||
| HandlingUnitContentType |
@AbapCatalog.sqlViewName: 'CHUSHIPLABEL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Form Data Provider HU Shippping Label'
@VDM.viewType: #CONSUMPTION
@AccessControl.personalData.blocking
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.modelingPattern: #OUTPUT_FORM_DATA_PROVIDER
@ObjectModel.supportedCapabilities: [ #OUTPUT_FORM_DATA_PROVIDER ]
define view C_HandlingUnitShippingLabelFDP as select from I_HandlingUnitHeaderCombined as huhdr
//Extensibility
association [0..1] to E_HandlingUnitHeader as _Extension on $projection.HandlingUnitNumber = _Extension.HandlingUnitExternalID
{
key HandlingUnitExternalID as HandlingUnitNumber,
key Warehouse,
PackagingMaterial,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitTareWeightUnit'
HandlingUnitTareWeight,
@Semantics.unitOfMeasure:true
HandlingUnitTareWeightUnit,
@Semantics.quantity.unitOfMeasure: 'VolumeUnit'
GrossVolume,
@Semantics.quantity.unitOfMeasure: 'VolumeUnit'
HandlingUnitNetVolume,
@Semantics.unitOfMeasure:true
VolumeUnit,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitTareVolumeUnit'
HandlingUnitTareVolume,
// HandlingUnitVolumeTolerance,
@Semantics.unitOfMeasure:true
HandlingUnitTareVolumeUnit,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
HandlingUnitLength,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
HandlingUnitWidth,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
HandlingUnitHeight,
@Semantics.unitOfMeasure:true
UnitOfMeasureDimension,
HandlingUnitReferenceDocument,
// CreatedByUser,
// CreationDateTime,
// LastChangedByUser,
// LastChangeDateTime,
HandlingUnitProcessStatus,
// EWM specific fields
// cast ( ' ' as /scwm/de_huident preserving type) as handlingunitnumber,
cast ( ' ' as /scwm/vhi preserving type) as HandlingUnitIndicator,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
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,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
fltp_to_dec( 0.0 as abap.dec(3,1) ) as HandlingUnitWeightTolerance,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
fltp_to_dec( 0.0 as abap.dec(3,1) ) as HandlingUnitVolumeTolerance,
cast ( ' ' as boole_d preserving type) as HandlingUnitIsClosed,
@Semantics.quantity.unitOfMeasure: 'VolumeUnit'
huhdr.HandlingUnitMaxVolume,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitMaxDimensionUnit'
huhdr.HandlingUnitMaxLength,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitMaxDimensionUnit'
huhdr.HandlingUnitMaxWidth,
@Semantics.quantity.unitOfMeasure: 'HandlingUnitMaxDimensionUnit'
huhdr.HandlingUnitMaxHeight,
huhdr.HandlingUnitMaxDimensionUnit,
huhdr.HandlingUnitType,
@ObjectModel.virtualElement: true
@ObjectModel.virtualElementCalculatedBy: 'CL_P_EWM_HANDLINGUNITHEADER02'
huhdr.StorageType,
@ObjectModel.virtualElement: true
@ObjectModel.virtualElementCalculatedBy: 'CL_P_EWM_HANDLINGUNITHEADER02'
huhdr.StorageSection,
@ObjectModel.virtualElement: true
@ObjectModel.virtualElementCalculatedBy: 'CL_P_EWM_HANDLINGUNITHEADER02'
huhdr.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,
// LE Fields
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
GrossWeight,
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
NetWeight,
@Semantics.quantity.unitOfMeasure: 'WeightUnit'
HandlingUnitMaxWeight,
@Semantics.unitOfMeasure:true
WeightUnit,
PackagingMaterialType,
// there is a maximum of 1333 for Char so we concatenate 13 times char100 and once char33
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
' ' ) ) ) ) ) ) ) ) ) ) ) ) ) as HandlingUnitBarCodePart1Value,
// altogether DataMatrix ECC200 can store 2.335 Char so we put 1002 Char in the second part
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
' ' ) ) ) ) ) ) ) ) ) ) as HandlingUnitBarCodePart2Value,
// there is a maximum of 1333 for Char so we concatenate 13 times char100 and once char33
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
concat(' ',
' ' ) ) ) ) ) ) ) ) ) ) ) ) ) as MatrixBarCodeNorm4994Value,
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,
// date fields
cast ( '00010101' as hsdat ) as ManufactureDate,
cast ( '00010101' as hsdat ) as ShelfLifeExpirationDate,
cast ('00010101' as wadat_ist ) as ActualGoodsMovementDate, //GoodsIssueDate
cast ('00010101' as wadat ) as GoodsMovementDate, //GoodsIssueDate
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,
@Semantics.quantity.unitOfMeasure: 'UnitOfMeasureDimension'
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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_HANDLINGUNITHEADERCOMBINED"
],
"ASSOCIATED":
[
"E_HANDLINGUNITHEADER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA