ESH_N_SUPPLIERITEMS

DDL: ESH_N_SUPPLIERITEMS SQL: ESH_L_SUPLRITEM Type: view Package: FLOG_SERVICES
10 Fields 1 Data Sources

Anchor view -SUPPLIERITEMS

ESH_N_SUPPLIERITEMS is a CDS View that provides data about "Anchor view -SUPPLIERITEMS" in SAP S/4HANA. It reads from 1 data source (I_FLDLOGSSUPPLIERITEMRECORD) and exposes 10 fields with key field FLDLOGSSUPLRITEMUUID. Part of development package FLOG_SERVICES.

Data Sources (1)

SourceAliasJoin Type
I_FLDLOGSSUPPLIERITEMRECORD I_FLDLOGSSUPPLIERITEMRECORD from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (7)

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
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_SUPLRITEM view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY FLDLOGSSUPLRITEMUUID FLDLOGSSUPLRITEMUUID Suplr Item UUID
FLDLOGSSUPLRITEMNAME FLDLOGSSUPLRITEMNAME Suplr Item Name
FLDLOGSSUPLRITEMPLNDDELIVDATE FLDLOGSSUPLRITEMPLNDDELIVDATE Delivery Date
FLDLOGSSUPLRITEMSERIALNUMBER FLDLOGSSUPLRITEMSERIALNUMBER Manuf. SerialNr
FLDLOGSSUPLRITEMSTATUSTEXT
FLDLOGSSUPLRITMPOITMUNIQUEID FLDLOGSSUPLRITMPOITMUNIQUEID PO Item Uniq ID
PLANTNAME _REMOTEPLANTTEXT PLANTNAME Plant Name
BASEPLANT _BASEPLANTTEXT PLANTNAME Plant Name
PREFERREDSUPPLIER PREFERREDSUPPLIER Supplier
SUPPLIER _SUPPLIER SUPPLIER Supplier

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_SUPPLIERITEMS.
-- 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_SUPLRITEM
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_SUPPLIERITEMS AS
SELECT
  FLDLOGSSUPLRITEMUUID,
  FLDLOGSSUPLRITEMNAME,
  FLDLOGSSUPLRITEMPLNDDELIVDATE,
  FLDLOGSSUPLRITEMSERIALNUMBER,
  _SUPLRITEMSTATUSTEXT[1: Language = $parameters. P_Language].FLDLOGSSUPLRITEMSTATUSTEXT AS FLDLOGSSUPLRITEMSTATUSTEXT,
  FLDLOGSSUPLRITMPOITMUNIQUEID,
  _REMOTEPLANTTEXT.PLANTNAME AS PLANTNAME,
  _BASEPLANTTEXT.PLANTNAME AS BASEPLANT,
  PREFERREDSUPPLIER,
  _SUPPLIER.SUPPLIER AS SUPPLIER
FROM I_FLDLOGSSUPPLIERITEMRECORD
;

Learn More