ESH_S_FLDSHIPMENTCONTAINERS

DDL: ESH_S_FLDSHIPMENTCONTAINERS SQL: ESH_U_FLDSHPTCTN Type: view Package: FLOG_SHIPMENT

Search view -FLDSHIPMENTCONTAINERS

ESH_S_FLDSHIPMENTCONTAINERS is a CDS View that provides data about "Search view -FLDSHIPMENTCONTAINERS" in SAP S/4HANA. It reads from 1 data source (ESH_N_FLDSHIPMENTCONTAINERS) and exposes 11 fields with key field FLDLOGSCONTAINERUUID. Part of development package FLOG_SHIPMENT.

Data Sources (1)

SourceAliasJoin Type
ESH_N_FLDSHIPMENTCONTAINERS ESH_N_FLDSHIPMENTCONTAINERS from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (18)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name FldLogsShptContainer view
UI.headerInfo.typeName Field Logistics Shipment Container view
UI.headerInfo.typeNamePlural Field Logistics Shipment Containers view
Consumption.semanticObject FldLogsShptCtn view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value FLDLOGSCONTAINERID view
UI.headerInfo.description.value FLDLOGSCONTAINERTEXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_FLDSHPTCTN view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY FLDLOGSCONTAINERUUID FLDLOGSCONTAINERUUID Container UUID
EQUIPMENTCATEGORY EQUIPMENTCATEGORY EquipCategory
FLDLOGSCONTAINERCATEGORYTEXT FLDLOGSCONTAINERCATEGORYTEXT Container Cat. Text
FLDLOGSCONTAINERID FLDLOGSCONTAINERID Container ID
FLDLOGSCONTAINERSTATUS FLDLOGSCONTAINERSTATUS Container Status
FLDLOGSCONTAINERTEXT FLDLOGSCONTAINERTEXT Container Desc.
FLDLOGSCTNCURRENTLOCATION FLDLOGSCTNCURRENTLOCATION Current Location
FLDLOGSCTNRENTALEXPIRYDATE FLDLOGSCTNRENTALEXPIRYDATE Expiry Date
FLDLOGSCTNRENTALSTARTDATE FLDLOGSCTNRENTALSTARTDATE Rental Date
MATERIAL MATERIAL Vehicle Model
PLANT PLANT Valuation Area

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 ESH_S_FLDSHIPMENTCONTAINERS.
-- 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: ESH_U_FLDSHPTCTN
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_FLDSHIPMENTCONTAINERS AS
SELECT
  FLDLOGSCONTAINERUUID,
  EQUIPMENTCATEGORY,
  FLDLOGSCONTAINERCATEGORYTEXT,
  FLDLOGSCONTAINERID,
  FLDLOGSCONTAINERSTATUS,
  FLDLOGSCONTAINERTEXT,
  FLDLOGSCTNCURRENTLOCATION,
  FLDLOGSCTNRENTALEXPIRYDATE,
  FLDLOGSCTNRENTALSTARTDATE,
  MATERIAL,
  PLANT
FROM ESH_N_FLDSHIPMENTCONTAINERS
;