ESH_S_PRODUCTIONROUTINGS

DDL: ESH_S_PRODUCTIONROUTINGS SQL: ESH_U_PRODNRTG Type: view
43 Fields 1 Data Sources

ESH_S_PRODUCTIONROUTINGS is a CDS View in SAP S/4HANA. It reads from 1 data source (ESH_N_PRODUCTIONROUTINGS) and exposes 43 fields with key fields BILLOFOPERATIONSGROUP, BILLOFOPERATIONSTYPE, BILLOFOPERATIONSVARIANT, BOOINTERNALVERSIONCOUNTER.

Data Sources (1)

SourceAliasJoin Type
ESH_N_PRODUCTIONROUTINGS ESH_N_PRODUCTIONROUTINGS from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (19)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name ProductionRouting view
UI.headerInfo.typeName Production Routing view
UI.headerInfo.typeNamePlural Production Routings view
Consumption.semanticObject ProductionRouting view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value BILLOFOPERATIONSGROUP view
UI.headerInfo.description.value BILLOFOPERATIONSTYPENAME view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_PRODNRTG view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY BILLOFOPERATIONSGROUP BILLOFOPERATIONSGROUP Routing Group
KEY BILLOFOPERATIONSTYPE BILLOFOPERATIONSTYPE Task List Type
KEY BILLOFOPERATIONSVARIANT BILLOFOPERATIONSVARIANT Task List Group Counter
KEY BOOINTERNALVERSIONCOUNTER BOOINTERNALVERSIONCOUNTER
BILLOFMATERIALCOMPONENT BILLOFMATERIALCOMPONENT Assigned Component
BILLOFOPERATIONSDESC BILLOFOPERATIONSDESC
BILLOFOPERATIONSSTATUS BILLOFOPERATIONSSTATUS
BILLOFOPERATIONSSTATUSDESC BILLOFOPERATIONSSTATUSDESC Status
BILLOFOPERATIONSTYPENAME BILLOFOPERATIONSTYPENAME Task List Type
BILLOFOPERATIONSUNIT BILLOFOPERATIONSUNIT
BILLOFOPERATIONSUSAGE BILLOFOPERATIONSUSAGE
CHANGENUMBER CHANGENUMBER Change Number
DOCUMENTDESCRIPTION DOCUMENTDESCRIPTION PRT Document Description
DOCUMENTINFORECORD DOCUMENTINFORECORD PRT Document
EQUIPMENT EQUIPMENT PRT Equipment
EQUIPMENTNAME EQUIPMENTNAME PRT Equipment Description
ISMARKEDFORDELETION ISMARKEDFORDELETION Selected for Archiving
MATERIAL MATERIAL Material
MAXIMUMLOTSIZEQUANTITY MAXIMUMLOTSIZEQUANTITY Maximum Lot Size
MINIMUMLOTSIZEQUANTITY MINIMUMLOTSIZEQUANTITY Minimum Lot Size
MISCPRODUCTIONRESOURCETOOL MISCPRODUCTIONRESOURCETOOL PRT Others
OPERATIONTEXT OPERATIONTEXT Operation Text
PLANT PLANT Valuation Area
PLANTNAME PLANTNAME Plant Description
PRODUCT PRODUCT PRT Material
COMPONENTDESCRIPTION COMPONENTDESCRIPTION Assigned Component Description
PRODUCTNAME PRODUCTNAME Description
MATERIALDESC MATERIALDESC PRT Material Description
RESPONSIBLEPLANNERGROUP RESPONSIBLEPLANNERGROUP
RESPONSIBLEPLANNERGROUPNAME RESPONSIBLEPLANNERGROUPNAME Planner Group Description
SALESORDER SALESORDER SD Document
UNITOFMEASURE_E UNITOFMEASURE_E Task List Unit
LASTCHANGEDBYUSERDESCRIPTION LASTCHANGEDBYUSERDESCRIPTION Changed By
CREATEDBYUSERDESCRIPTION CREATEDBYUSERDESCRIPTION Created By
LASTCHANGEDBYUSER LASTCHANGEDBYUSER Last Changed By
CREATEDBYUSER CREATEDBYUSER Created By
VALIDITYENDDATE VALIDITYENDDATE Valid To
VALIDITYSTARTDATE VALIDITYSTARTDATE Valid From
WBSELEMENTINTERNALID WBSELEMENTINTERNALID WBS Internal ID
PLANNINGWORKCENTER PLANNINGWORKCENTER Planning Work Center
WORKCENTER WORKCENTER Work Center
WORKCENTERINTERNALID WORKCENTERINTERNALID Work Center ID
WORKCENTERTEXT WORKCENTERTEXT Work Center Description

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_PRODUCTIONROUTINGS.
-- 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_PRODNRTG
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_PRODUCTIONROUTINGS AS
SELECT
  BILLOFOPERATIONSGROUP,
  BILLOFOPERATIONSTYPE,
  BILLOFOPERATIONSVARIANT,
  BOOINTERNALVERSIONCOUNTER,
  BILLOFMATERIALCOMPONENT,
  BILLOFOPERATIONSDESC,
  BILLOFOPERATIONSSTATUS,
  BILLOFOPERATIONSSTATUSDESC,
  BILLOFOPERATIONSTYPENAME,
  BILLOFOPERATIONSUNIT,
  BILLOFOPERATIONSUSAGE,
  CHANGENUMBER,
  DOCUMENTDESCRIPTION,
  DOCUMENTINFORECORD,
  EQUIPMENT,
  EQUIPMENTNAME,
  ISMARKEDFORDELETION,
  MATERIAL,
  MAXIMUMLOTSIZEQUANTITY,
  MINIMUMLOTSIZEQUANTITY,
  MISCPRODUCTIONRESOURCETOOL,
  OPERATIONTEXT,
  PLANT,
  PLANTNAME,
  PRODUCT,
  COMPONENTDESCRIPTION,
  PRODUCTNAME,
  MATERIALDESC,
  RESPONSIBLEPLANNERGROUP,
  RESPONSIBLEPLANNERGROUPNAME,
  SALESORDER,
  UNITOFMEASURE_E,
  LASTCHANGEDBYUSERDESCRIPTION,
  CREATEDBYUSERDESCRIPTION,
  LASTCHANGEDBYUSER,
  CREATEDBYUSER,
  VALIDITYENDDATE,
  VALIDITYSTARTDATE,
  WBSELEMENTINTERNALID,
  PLANNINGWORKCENTER,
  WORKCENTER,
  WORKCENTERINTERNALID,
  WORKCENTERTEXT
FROM ESH_N_PRODUCTIONROUTINGS
;

Learn More