C_FldLogsEmptyContainerIDVH

DDL: C_FLDLOGSEMPTYCONTAINERIDVH SQL: CFLEMPTYCTNVH Type: view CONSUMPTION
15 Fields 1 Associations

Field Logitics for Empty Containers

C_FldLogsEmptyContainerIDVH is a Consumption CDS View that provides data about "Field Logitics for Empty Containers" in SAP S/4HANA. It has 1 association to related views.

Associations (1)

CardinalityTargetAliasCondition
[1] I_FldLogsShptCtnCertExpiryDate _CertificateExpiry $projection.FldLogsContainerUUID = _CertificateExpiry.FldLogsContainerUUID

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CFLEMPTYCTNVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Field Logitics for Empty Containers view
Consumption.ranked true view
Consumption.valueHelpDefault.fetchValues #AUTOMATICALLY_WHEN_DISPLAYED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY FldLogsContainerUUID FldLogsContainerUUID Container UUID
FldLogsContainerID FldLogsContainerID Container ID
EquipmentType EquipmentType Container Type
EquipmentGroup EquipmentGroup Equipment Group
EquipmentTypeDesc _EquipmentTypeText EquipmentTypeDesc Container Type description
FldLogsContainerText FldLogsContainerText Description
FldLogsContainerCategory FldLogsContainerCategory Container Category
FldLogsContainerCategoryText _CtnCategoryText FldLogsContainerCategoryText Container Category description
FldLogsContainerStatus FldLogsContainerStatus Container Status
Plant Plant Base Plant
StorageLocation StorageLocation Base Storage Location
FldLogsCtnCurrentLocation FldLogsCtnCurrentLocation Current Plant
FldLogsCtnCurrentStorageLoc FldLogsCtnCurrentStorageLoc Current Storage Location
FldLogsContainerOwner FldLogsContainerOwner Supplier
FldLogsCertEndDate _CertificateExpiry FldLogsCertEndDate Expiry Date

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_FldLogsEmptyContainerIDVH.
-- 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: CFLEMPTYCTNVH

CREATE VIEW C_FldLogsEmptyContainerIDVH AS
SELECT
  FldLogsContainerUUID,
  FldLogsContainerID,
  EquipmentType,
  EquipmentGroup,
  _EquipmentTypeText.EquipmentTypeDesc AS EquipmentTypeDesc,
  FldLogsContainerText,
  FldLogsContainerCategory,
  _CtnCategoryText.FldLogsContainerCategoryText AS FldLogsContainerCategoryText,
  FldLogsContainerStatus,
  Plant,
  StorageLocation,
  FldLogsCtnCurrentLocation,
  FldLogsCtnCurrentStorageLoc,
  FldLogsContainerOwner,
  _CertificateExpiry.FldLogsCertEndDate AS FldLogsCertEndDate
LEFT OUTER JOIN I_FldLogsShptCtnCertExpiryDate AS _CertificateExpiry ON FldLogsContainerUUID = _CertificateExpiry.FldLogsContainerUUID  -- association [1]
;

Learn More