ESH_N_CATALOG_ITEM

DDL: ESH_N_CATALOG_ITEM SQL: ESH_L_CTLG_ITM Type: view
81 Fields 1 Data Sources

ESH_N_CATALOG_ITEM is a CDS View in SAP S/4HANA. It reads from 1 data source (I_CATALOGITEM) and exposes 81 fields with key fields OPNCTLGITEMID, SAPCLIENT.

Data Sources (1)

SourceAliasJoin Type
I_CATALOGITEM I_CATALOGITEM from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ESH_L_CTLG_ITM view

Fields (81)

KeyFieldSource TableSource FieldDescription
KEY OPNCTLGITEMID OPNCTLGITEMID Catalog Item Key
KEY SAPCLIENT SAPCLIENT Client ID
BASEUNIT BASEUNIT Unit of Measure
CALCULATEDPRICE CALCULATEDPRICE
COMPANYCODE COMPANYCODE Receiver Company Code
CURRENCY CURRENCY Valuation Crcy
DELETIONINDICATOR DELETIONINDICATOR Deletion Ind.
ISMARKEDFORDELETION ISMARKEDFORDELETION Purch.org. data
ISOPNCTLGITEM ISOPNCTLGITEM Is Catalog Item
ISOPNCTLGITMFRMMATLMSTR ISOPNCTLGITMFRMMATLMSTR Is Material Master
ISOPNCTLGMANAGED ISOPNCTLGMANAGED Is Catalog Managed
LANGUAGE
MANUFACTURER MANUFACTURER Manufacturer
MANUFACTURERNAME MANUFACTURERNAME Manufacturer
MATERIAL MATERIAL Vehicle Model
MATERIALGROUPNAME MATERIALGROUPNAME prod Grp Desc.
NETPRICEAMOUNT NETPRICEAMOUNT Net Price
OPENCATALOGMATERIALGROUP OPENCATALOGMATERIALGROUP Product Group
OPENCATALOGUNITOFMEASURE OPENCATALOGUNITOFMEASURE UoM
OPENCATALOGUSERRATINGVALUE OPENCATALOGUSERRATINGVALUE Rating
OPNCTLGARCHIVINGSTATUS OPNCTLGARCHIVINGSTATUS Archiving Status
OPNCTLGCOMCURRENCYID OPNCTLGCOMCURRENCYID
OPNCTLGDIRECTEMISSIONUNIT OPNCTLGDIRECTEMISSIONUNIT Direct Emission Unit
OPNCTLGDIRECTEMISSIONVALUE OPNCTLGDIRECTEMISSIONVALUE Direct Emission Val
OPNCTLGENERGYCONSUMPTIONUNIT OPNCTLGENERGYCONSUMPTIONUNIT Energy Consumption U
OPNCTLGENERGYCONSUMPTIONVALUE OPNCTLGENERGYCONSUMPTIONVALUE Energy Consumption V
OPNCTLGEXTERNALPRODUCTID OPNCTLGEXTERNALPRODUCTID External Product ID
OPNCTLGHASPRICESCALE OPNCTLGHASPRICESCALE Price Scale
OPNCTLGINDRCTEMISSIONUNIT OPNCTLGINDRCTEMISSIONUNIT InDirect Emission Un
OPNCTLGINDRCTEMISSIONVALUE OPNCTLGINDRCTEMISSIONVALUE Temp Emission Value
OPNCTLGINTCATALOGNAME OPNCTLGINTCATALOGNAME Int Catalog name
OPNCTLGISSERVICEMATERIALTYPE OPNCTLGISSERVICEMATERIALTYPE Service Type
OPNCTLGITEMCURRENCY OPNCTLGITEMCURRENCY
OPNCTLGITEMKEY OPNCTLGITEMKEY Item Hash Key
OPNCTLGITEMPRICE OPNCTLGITEMPRICE
OPNCTLGITEMPRICEQUANTITYVALUE OPNCTLGITEMPRICEQUANTITYVALUE Quantity
OPNCTLGITEMSUSTAINCOMPLIANCE OPNCTLGITEMSUSTAINCOMPLIANCE Item Sustainable Com
OPNCTLGLEADTMEANNCMNTDUDAYSVAL OPNCTLGLEADTMEANNCMNTDUDAYSVAL Lead Time in Days
OPNCTLGMAINIMAGEID OPNCTLGMAINIMAGEID
OPNCTLGMAINIMAGENAME OPNCTLGMAINIMAGENAME
OPNCTLGMAINIMAGETEXT OPNCTLGMAINIMAGETEXT
OPNCTLGMAINIMAGEURL OPNCTLGMAINIMAGEURL
OPNCTLGMATERIALIDBYSUPPLIER OPNCTLGMATERIALIDBYSUPPLIER Vendor Product
OPNCTLGMATLFIXEDLOTSIZEQTYVAL OPNCTLGMATLFIXEDLOTSIZEQTYVAL Quantity
OPNCTLGMFRMATERIALNUMBER OPNCTLGMFRMATERIALNUMBER Manufacturer PartNo.
OPNCTLGMINORDERQUANTITYVALUE OPNCTLGMINORDERQUANTITYVALUE Quantity
OPNCTLGPRCAMOUNTINCOMCURRENCY OPNCTLGPRCAMOUNTINCOMCURRENCY
OPNCTLGPRICEVALIDFROMDATETIME OPNCTLGPRICEVALIDFROMDATETIME
OPNCTLGPRICEVALIDTODATETIME OPNCTLGPRICEVALIDTODATETIME
OPNCTLGRECYCLEUNIT OPNCTLGRECYCLEUNIT Recycle Unit
OPNCTLGRECYCLEVALUE OPNCTLGRECYCLEVALUE Recycle Value
OPNCTLGSEARCHTERM
OPNCTLGSOURCELISTVALIDFROMDATE OPNCTLGSOURCELISTVALIDFROMDATE Valid From
OPNCTLGSOURCELISTVALIDTODATE OPNCTLGSOURCELISTVALIDTODATE Valid to
OPNCTLGSRCHLONGTEXT OPNCTLGSRCHLONGTEXT
OPNCTLGSUPPLIERID OPNCTLGSUPPLIERID Vendor
OPNCTLGSUPPLIERNAME OPNCTLGSUPPLIERNAME Vendor Name
OPNCTLGTEMPEMISSIONUNIT OPNCTLGTEMPEMISSIONUNIT Temp Emission Unit
OPNCTLGTEMPEMISSIONVALUE OPNCTLGTEMPEMISSIONVALUE Temp Emission Value
OPNCTLGWASTEGENERATEDUNIT OPNCTLGWASTEGENERATEDUNIT Waste Generated Unit
OPNCTLGWASTEGENERATEDVALUE OPNCTLGWASTEGENERATEDVALUE Waste Generated Valu
OPNCTLGWATERCONSUMPTIONUNIT OPNCTLGWATERCONSUMPTIONUNIT Water Consumption Un
OPNCTLGWATERCONSUMPTIONVALUE OPNCTLGWATERCONSUMPTIONVALUE Water Consumption Va
OPNCTLGWEBSERVICEID OPNCTLGWEBSERVICEID Web Service ID
OPNCTLGWEBSERVICENAME OPNCTLGWEBSERVICENAME Description
ORDERPRICEUNITQTY ORDERPRICEUNITQTY Price Unit
ORDERQUANTITYUNIT ORDERQUANTITYUNIT Sales Unit
PLANTNAME PLANTNAME Plant Name
PROCUREMENTHUBSOURCESYSTEM PROCUREMENTHUBSOURCESYSTEM Connected System ID
PRODUCTCATALOGNAME PRODUCTCATALOGNAME Catalog name
PRODUCTDESCRIPTION
PURCHASINGDOCUMENT PURCHASINGDOCUMENT Purchasing Document
PURCHASINGDOCUMENTITEM PURCHASINGDOCUMENTITEM Purchasing Doc. Item
PURCHASINGISBLOCKED PURCHASINGISBLOCKED Purch. block
PURCHASINGORGANIZATION PURCHASINGORGANIZATION Purchasing Organization
PURREQNSOURCEOFSUPPLYTYPE PURREQNSOURCEOFSUPPLYTYPE Doc. Category
SOURCEOFSUPPLYISBLOCKED SOURCEOFSUPPLYISBLOCKED Blocked
SOURCEOFSUPPLYISFIXED SOURCEOFSUPPLYISFIXED Indicator
TAXTOLERANCEPERCENT TAXTOLERANCEPERCENT Tax Amount
VALIDITYENDDATE VALIDITYENDDATE ValidTo
VALIDITYSTARTDATE VALIDITYSTARTDATE Validity Start 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 ESH_N_CATALOG_ITEM.
-- 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_CTLG_ITM
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_CATALOG_ITEM AS
SELECT
  OPNCTLGITEMID,
  SAPCLIENT,
  BASEUNIT,
  CALCULATEDPRICE,
  COMPANYCODE,
  CURRENCY,
  DELETIONINDICATOR,
  ISMARKEDFORDELETION,
  ISOPNCTLGITEM,
  ISOPNCTLGITMFRMMATLMSTR,
  ISOPNCTLGMANAGED,
  _ITEMDESC[1: LANGUAGE = $parameters. P_Language].LANGUAGE AS LANGUAGE,
  MANUFACTURER,
  MANUFACTURERNAME,
  MATERIAL,
  MATERIALGROUPNAME,
  NETPRICEAMOUNT,
  OPENCATALOGMATERIALGROUP,
  OPENCATALOGUNITOFMEASURE,
  OPENCATALOGUSERRATINGVALUE,
  OPNCTLGARCHIVINGSTATUS,
  OPNCTLGCOMCURRENCYID,
  OPNCTLGDIRECTEMISSIONUNIT,
  OPNCTLGDIRECTEMISSIONVALUE,
  OPNCTLGENERGYCONSUMPTIONUNIT,
  OPNCTLGENERGYCONSUMPTIONVALUE,
  OPNCTLGEXTERNALPRODUCTID,
  OPNCTLGHASPRICESCALE,
  OPNCTLGINDRCTEMISSIONUNIT,
  OPNCTLGINDRCTEMISSIONVALUE,
  OPNCTLGINTCATALOGNAME,
  OPNCTLGISSERVICEMATERIALTYPE,
  OPNCTLGITEMCURRENCY,
  OPNCTLGITEMKEY,
  OPNCTLGITEMPRICE,
  OPNCTLGITEMPRICEQUANTITYVALUE,
  OPNCTLGITEMSUSTAINCOMPLIANCE,
  OPNCTLGLEADTMEANNCMNTDUDAYSVAL,
  OPNCTLGMAINIMAGEID,
  OPNCTLGMAINIMAGENAME,
  OPNCTLGMAINIMAGETEXT,
  OPNCTLGMAINIMAGEURL,
  OPNCTLGMATERIALIDBYSUPPLIER,
  OPNCTLGMATLFIXEDLOTSIZEQTYVAL,
  OPNCTLGMFRMATERIALNUMBER,
  OPNCTLGMINORDERQUANTITYVALUE,
  OPNCTLGPRCAMOUNTINCOMCURRENCY,
  OPNCTLGPRICEVALIDFROMDATETIME,
  OPNCTLGPRICEVALIDTODATETIME,
  OPNCTLGRECYCLEUNIT,
  OPNCTLGRECYCLEVALUE,
  _SRCHTRM[1: LANGUAGECODE = $parameters. P_Language].OPNCTLGSEARCHTERM AS OPNCTLGSEARCHTERM,
  OPNCTLGSOURCELISTVALIDFROMDATE,
  OPNCTLGSOURCELISTVALIDTODATE,
  OPNCTLGSRCHLONGTEXT,
  OPNCTLGSUPPLIERID,
  OPNCTLGSUPPLIERNAME,
  OPNCTLGTEMPEMISSIONUNIT,
  OPNCTLGTEMPEMISSIONVALUE,
  OPNCTLGWASTEGENERATEDUNIT,
  OPNCTLGWASTEGENERATEDVALUE,
  OPNCTLGWATERCONSUMPTIONUNIT,
  OPNCTLGWATERCONSUMPTIONVALUE,
  OPNCTLGWEBSERVICEID,
  OPNCTLGWEBSERVICENAME,
  ORDERPRICEUNITQTY,
  ORDERQUANTITYUNIT,
  PLANTNAME,
  PROCUREMENTHUBSOURCESYSTEM,
  PRODUCTCATALOGNAME,
  _ITEMDESC[1: LANGUAGE = $parameters. P_Language].PRODUCTDESCRIPTION AS PRODUCTDESCRIPTION,
  PURCHASINGDOCUMENT,
  PURCHASINGDOCUMENTITEM,
  PURCHASINGISBLOCKED,
  PURCHASINGORGANIZATION,
  PURREQNSOURCEOFSUPPLYTYPE,
  SOURCEOFSUPPLYISBLOCKED,
  SOURCEOFSUPPLYISFIXED,
  TAXTOLERANCEPERCENT,
  VALIDITYENDDATE,
  VALIDITYSTARTDATE
FROM I_CATALOGITEM
;

Learn More