C_FldLogsShipmentContainerVH

DDL: C_FLDLOGSSHIPMENTCONTAINERVH Type: view_entity CONSUMPTION
34 Fields 1 Data Sources 3 Associations

FL Shipment Container for Assign Container

C_FldLogsShipmentContainerVH is a Consumption CDS View that provides data about "FL Shipment Container for Assign Container" in SAP S/4HANA. It reads from 1 data source (I_FldLogsShptContainerRecord) and exposes 34 fields with key field FldLogsContainerUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FldLogsShptContainerRecord I_FldLogsShptContainerRecord from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_FldLogsShptCtnUnitRecord _ShptCtnUnit _ShptCtnUnit.FldLogsContainerUUID = $projection.FldLogsContainerUUID and( _ShptCtnUnit.FldLogsCtnPackgStsCode = '10' or _ShptCtnUnit.FldLogsCtnPackgStsCode = '30' ) and( _ShptCtnUnit.FldLogsCtnIntTranspStsCode = '10' or _ShptCtnUnit.FldLogsCtnIntTranspStsCode = '25' --Added for Multiple JVS )
[1] I_FldLogsShptCtnCertExpiryDate _CertificateExpiry $projection.FldLogsContainerUUID = _CertificateExpiry.FldLogsContainerUUID
[1] I_FldLogsContainerCategory _CtnCat $projection.FldLogsContainerCategory = _CtnCat.FldLogsContainerCategory

Annotations (9)

NameValueLevelField
EndUserText.label FL Shipment Container for Assign Container view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
Consumption.ranked true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY FldLogsContainerUUID FldLogsContainerUUID Container UUID
FldLogsContainerID FldLogsContainerID Container ID
Equipment Equipment Equipment
EquipmentType EquipmentType Container Type
EquipmentGroup EquipmentGroup Equipment Group
FldLogsContainerText FldLogsContainerText Description
FldLogsContainerCategory FldLogsContainerCategory Container Category
FldLogsContainerStatus FldLogsContainerStatus Container Status
Plant Plant Base Plant
StorageLocation StorageLocation Base Storage Location
FldLogsCtnCurrentLocation FldLogsCtnCurrentLocation Current Plant
FldLogsCtnCurrentStorageLoc FldLogsCtnCurrentStorageLoc Current Storage Location
FldLogsCertEndDate _CertificateExpiry FldLogsCertEndDate Expiry Date
FldLogsCtnIsTemperatureCtrld FldLogsCtnIsTemperatureCtrld Temperature Controlled
FldLogsContainerVentilation FldLogsContainerVentilation Ventilated
FldLogsCtnCubicCapacity FldLogsCtnCubicCapacity Total Container Volume
FldLogsCtnCubicCapacityUnit FldLogsCtnCubicCapacityUnit Total Container Volume Unit
FldLogsContainerSafeLoadQty FldLogsContainerSafeLoadQty Total Container Weight
FldLogsContainerSafeLoadUnit FldLogsContainerSafeLoadUnit Total Container Weight Unit
FldLogsContainerTareWeight FldLogsContainerTareWeight Tare Weight
FldLogsContainerTareWeightUnit FldLogsContainerTareWeightUnit Tare Weight UoM
FldLogsGrossVolume _ShptCtnUnit FldLogsGrossVolume Volume
FldLogsGrossVolumeUnit _ShptCtnUnit FldLogsGrossVolumeUnit Volume Unit
ProductGrossWeight _ShptCtnUnit ProductGrossWeight Gross Weight
ProductWeightUnit _ShptCtnUnit ProductWeightUnit Unit of Weight
FldLogsContainerUnitUUID _ShptCtnUnit FldLogsContainerUnitUUID Container Unit ID
_EquipmentTypeText _EquipmentTypeText
_CtnCategoryText _CtnCategoryText
_ShptCtnUnit _ShptCtnUnit
_SrcePlantText _SrcePlantText
PlantName _SrcePlantText PlantName Plant Name
PlantName2 _DestPlantText PlantName Plant Name
FldLogsVoyageDestStage _ShptCtnUnit FldLogsVoyageDestStage Receiving Point
FldLogsCtnUnitCurShipgPoint _ShptCtnUnit FldLogsCtnUnitCurShipgPoint Current Shipping Point

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_FldLogsShipmentContainerVH.
-- 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_FldLogsShipmentContainerVH AS
SELECT
  FldLogsContainerUUID,
  FldLogsContainerID,
  Equipment,
  EquipmentType,
  EquipmentGroup,
  FldLogsContainerText,
  FldLogsContainerCategory,
  FldLogsContainerStatus,
  Plant,
  StorageLocation,
  FldLogsCtnCurrentLocation,
  FldLogsCtnCurrentStorageLoc,
  _CertificateExpiry.FldLogsCertEndDate AS FldLogsCertEndDate,
  FldLogsCtnIsTemperatureCtrld,
  FldLogsContainerVentilation,
  FldLogsCtnCubicCapacity,
  FldLogsCtnCubicCapacityUnit,
  FldLogsContainerSafeLoadQty,
  FldLogsContainerSafeLoadUnit,
  FldLogsContainerTareWeight,
  FldLogsContainerTareWeightUnit,
  _ShptCtnUnit.FldLogsGrossVolume AS FldLogsGrossVolume,
  _ShptCtnUnit.FldLogsGrossVolumeUnit AS FldLogsGrossVolumeUnit,
  _ShptCtnUnit.ProductGrossWeight AS ProductGrossWeight,
  _ShptCtnUnit.ProductWeightUnit AS ProductWeightUnit,
  _ShptCtnUnit.FldLogsContainerUnitUUID AS FldLogsContainerUnitUUID,
  _SrcePlantText.PlantName AS PlantName,
  _DestPlantText.PlantName AS PlantName2,
  _ShptCtnUnit.FldLogsVoyageDestStage AS FldLogsVoyageDestStage,
  _ShptCtnUnit.FldLogsCtnUnitCurShipgPoint AS FldLogsCtnUnitCurShipgPoint
FROM I_FldLogsShptContainerRecord
LEFT OUTER JOIN I_FldLogsShptCtnUnitRecord AS _ShptCtnUnit ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN I_FldLogsShptCtnCertExpiryDate AS _CertificateExpiry ON FldLogsContainerUUID = _CertificateExpiry.FldLogsContainerUUID  -- association [1]
LEFT OUTER JOIN I_FldLogsContainerCategory AS _CtnCat ON FldLogsContainerCategory = _CtnCat.FldLogsContainerCategory  -- association [1]
;

Learn More