ESH_S_FLCONTAINERUNITS

DDL: ESH_S_FLCONTAINERUNITS SQL: ESH_U_FLCTNUNITS Type: view Package: FLOG_SHIPMENT

Search view -FLCONTAINERUNITS

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

Data Sources (1)

SourceAliasJoin Type
ESH_N_FLCONTAINERUNITS ESH_N_FLCONTAINERUNITS from

Annotations (18)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL 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 FldLogsShptContainerUnit view
UI.headerInfo.typeName Field Logistics Container Unit view
UI.headerInfo.typeNamePlural Field Logistics Container Units view
Consumption.semanticObject FldLogsShptCtnPackg 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_FLCTNUNITS view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY FLDLOGSCONTAINERUNITUUID FLDLOGSCONTAINERUNITUUID Container Unit ID
FLDLOGSCONTAINERID FLDLOGSCONTAINERID Container ID
FLDLOGSCONTAINERTEXT FLDLOGSCONTAINERTEXT Container Desc.
FLDLOGSCONTAINERUUID FLDLOGSCONTAINERUUID Container UUID
FLDLOGSCTNPACKGSTSCODE FLDLOGSCTNPACKGSTSCODE Packing Status
FLDLOGSCTNPACKGSTSTEXT FLDLOGSCTNPACKGSTSTEXT Container Packing Status
FLDLOGSCTNUNITCURRENTPLANT FLDLOGSCTNUNITCURRENTPLANT Current Plant
FLDLOGSDESTPLNT FLDLOGSDESTPLNT Destination Plant
FLDLOGSSHPTCTNINTTRANSPSTSTEXT FLDLOGSSHPTCTNINTTRANSPSTSTEXT Transport Status
FLDLOGSSRCEPLNT FLDLOGSSRCEPLNT Source Plant
FLDLOGSVOYASSGMTSTATUSTEXT FLDLOGSVOYASSGMTSTATUSTEXT Voyage Assignment Status

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_FLCONTAINERUNITS.
-- 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_FLCTNUNITS

CREATE VIEW ESH_S_FLCONTAINERUNITS AS
SELECT
  FLDLOGSCONTAINERUNITUUID,
  FLDLOGSCONTAINERID,
  FLDLOGSCONTAINERTEXT,
  FLDLOGSCONTAINERUUID,
  FLDLOGSCTNPACKGSTSCODE,
  FLDLOGSCTNPACKGSTSTEXT,
  FLDLOGSCTNUNITCURRENTPLANT,
  FLDLOGSDESTPLNT,
  FLDLOGSSHPTCTNINTTRANSPSTSTEXT,
  FLDLOGSSRCEPLNT,
  FLDLOGSVOYASSGMTSTATUSTEXT
FROM ESH_N_FLCONTAINERUNITS
;