I_FieldLogisticsContainerType

DDL: I_FIELDLOGISTICSCONTAINERTYPE Type: view_entity BASIC
29 Fields 1 Data Sources 2 Associations

Field Logistics Container Type

I_FieldLogisticsContainerType is a Basic CDS View that provides data about "Field Logistics Container Type" in SAP S/4HANA. It reads from 1 data source (flog_ctn_type_c) and exposes 29 fields with key field EquipmentType. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
flog_ctn_type_c flog_ctn_type_c from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_UnitOfMeasure _UnitOfMeasure $projection.FldLogsCtnCubicCapacityUnit = _UnitOfMeasure.UnitOfMeasure
[0..*] I_FldLogsContainerTypeText _Text $projection.EquipmentType = _Text.EquipmentType

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
EndUserText.label Field Logistics Container Type view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
VDM.viewType #BASIC view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY EquipmentType equipmenttype Equipment Type
Material material Vehicle Model
FldLogsCtnMaximumLength fldlogsctnmaximumlength Max. Length
FldLogsCtnMaximumWidth fldlogsctnmaximumwidth Max. Width
FldLogsCtnMaximumDimnUnit fldlogsctnmaximumdimnunit Unit of Meas.
FldLogsContainerFootprintQty fldlogscontainerfootprintqty Footprint
FldLogsContainerFootprintUnit fldlogscontainerfootprintunit Footprint Unit
FldLogsCtnMaxGrossWeight fldlogsctnmaxgrossweight Max. Gross Weight
FldLogsCtnMaxGrossWeightUnit fldlogsctnmaxgrossweightunit Gross Weight UoM
FldLogsContainerTareWeight fldlogscontainertareweight Tare Weight
FldLogsContainerTareWeightUnit fldlogscontainertareweightunit Tare Weight UoM
FldLogsContainerTareVolume fldlogscontainertarevolume Tare Volume
FldLogsContainerTareVolumeUnit fldlogscontainertarevolumeunit Tare Volume UoM
FldLogsContainerSafeLoadQty fldlogscontainersafeloadqty Safe Load
FldLogsContainerSafeLoadUnit fldlogscontainersafeloadunit Safe Load Unit
FldLogsCtnInteriorLength fldlogsctninteriorlength Interior Length
FldLogsCtnInteriorWidth fldlogsctninteriorwidth Interior Width
FldLogsCtnInteriorHeight fldlogsctninteriorheight Interior Height
FldLogsCtnInteriorDimnUnit fldlogsctninteriordimnunit Int. Dim. UoM
FldLogsCtnCubicCapacity fldlogsctncubiccapacity Cubic Capacity
FldLogsCtnCubicCapacityUnit fldlogsctncubiccapacityunit Cub. Capa. UoM
FldLogsCtnIsTemperatureCtrld fldlogsctnistemperaturectrld Temp.Ctrld.
FldLogsCtnMinCtrlTemperature fldlogsctnminctrltemperature Min. Temp.
FldLogsCtnMaxCtrlTemperature fldlogsctnmaxctrltemperature Max. Temp.
FldLogsCtnTemperatureUnit fldlogsctntemperatureunit Temp. UoM
FldLogsContainerVentilation fldlogscontainerventilation Ventilation
FldLogsCtnMaximumHeight fldlogsctnmaximumheight Maximum Height
_UnitOfMeasure _UnitOfMeasure
_Text _Text

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_FieldLogisticsContainerType.
-- 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 I_FieldLogisticsContainerType AS
SELECT
  EquipmentType,
  Material,
  FldLogsCtnMaximumLength,
  FldLogsCtnMaximumWidth,
  FldLogsCtnMaximumDimnUnit,
  FldLogsContainerFootprintQty,
  FldLogsContainerFootprintUnit,
  FldLogsCtnMaxGrossWeight,
  FldLogsCtnMaxGrossWeightUnit,
  FldLogsContainerTareWeight,
  FldLogsContainerTareWeightUnit,
  FldLogsContainerTareVolume,
  FldLogsContainerTareVolumeUnit,
  FldLogsContainerSafeLoadQty,
  FldLogsContainerSafeLoadUnit,
  FldLogsCtnInteriorLength,
  FldLogsCtnInteriorWidth,
  FldLogsCtnInteriorHeight,
  FldLogsCtnInteriorDimnUnit,
  FldLogsCtnCubicCapacity,
  FldLogsCtnCubicCapacityUnit,
  FldLogsCtnIsTemperatureCtrld,
  FldLogsCtnMinCtrlTemperature,
  FldLogsCtnMaxCtrlTemperature,
  FldLogsCtnTemperatureUnit,
  FldLogsContainerVentilation,
  FldLogsCtnMaximumHeight
FROM flog_ctn_type_c
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON FldLogsCtnCubicCapacityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_FldLogsContainerTypeText AS _Text ON EquipmentType = _Text.EquipmentType  -- association [0..*]
;

Learn More