ESH_N_FLCONTAINERUNITS

DDL: ESH_N_FLCONTAINERUNITS SQL: ESH_L_FLCTNUNITS Type: view Package: FLOG_SHIPMENT
11 Fields 1 Data Sources

Anchor view -FLCONTAINERUNITS

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

Data Sources (1)

SourceAliasJoin Type
I_FLDLOGSSHPTCTNUNITRECORD I_FLDLOGSSHPTCTNUNITRECORD from

Annotations (5)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ESH_L_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
FLDLOGSCTNUNITCURRENTPLANT FLDLOGSCTNUNITCURRENTPLANT Plant
FLDLOGSDESTPLNT FLDLOGSDESTPLNT Plant
FLDLOGSSHPTCTNINTTRANSPSTSTEXT FLDLOGSSHPTCTNINTTRANSPSTSTEXT
FLDLOGSSRCEPLNT FLDLOGSSRCEPLNT Plant
FLDLOGSVOYASSGMTSTATUSTEXT FLDLOGSVOYASSGMTSTATUSTEXT

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_N_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_L_FLCTNUNITS

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

Learn More