ESH_S_PROCESSORDER

DDL: ESH_S_PROCESSORDER SQL: ESH_U_PROCORDER Type: view Package: BSESH_PP_PI
40 Fields 1 Data Sources 1 Associations

Search view -PROCESSORDER

ESH_S_PROCESSORDER is a CDS View that provides data about "Search view -PROCESSORDER" in SAP S/4HANA. It reads from 1 data source (ESH_N_PROCESSORDER) and exposes 40 fields with key field ORDERID. It has 1 association to related views. Part of development package BSESH_PP_PI.

Data Sources (1)

SourceAliasJoin Type
ESH_N_PROCESSORDER ESH_N_PROCESSORDER from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_LOGISTICSORDER _EXTENSION ( $projection.ORDERID = _EXTENSION.ORDERID )

Annotations (19)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #CLIENT_DEPENDENT 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 ProcessOrder view
UI.headerInfo.typeName Process Order view
UI.headerInfo.typeNamePlural Process Orders view
Consumption.semanticObject ProcessOrder view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value ORDERID view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_PROCORDER view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY ORDERID ORDERID Order ID
BASEUNIT BASEUNIT Unit of Measure
BATCH BATCH Lot No.
ISMARKEDFORDELETION ISMARKEDFORDELETION Purch.org. data
LEADINGORDER LEADINGORDER Last order
MATERIAL MATERIAL Material
MRPAREA MRPAREA MRP Area
MRPAREATEXT MRPAREATEXT MRP Area Description
MRPCONTROLLER MRPCONTROLLER MRP Controller
MRPPLANT MRPPLANT Planning Plant
OBJECTINTERNALID OBJECTINTERNALID Object number
ORDERCATEGORY ORDERCATEGORY Order Category
ORDERCOMPONENTLONGTEXT ORDERCOMPONENTLONGTEXT Component Long Texts
ORDERDESCRIPTION ORDERDESCRIPTION
ORDERINTERNALBILLOFOPERATIONS ORDERINTERNALBILLOFOPERATIONS Order Internal Bill of Operations
ORDEROPERATIONLONGTEXT ORDEROPERATIONLONGTEXT Operation Long Texts
ORDERPLANNEDTOTALQTY ORDERPLANNEDTOTALQTY Total Quantity
ORDERTYPE ORDERTYPE Order Type
ORDERTYPENAME ORDERTYPENAME Order Type Description
ORGANIZATIONBPNAME1 ORGANIZATIONBPNAME1 Customer Name
ORDERLONGTEXT ORDERLONGTEXT Order Long Texts
PLANNEDENDDATE PLANNEDENDDATE Basic End Date
PLANNEDSTARTDATE PLANNEDSTARTDATE Basic Start Date
PLANTNAME PLANTNAME Production Plant Description
MRPPLANTNAME MRPPLANTNAME Planning Plant Description
PRODUCTIONPLANT PRODUCTIONPLANT Production Plant
MATERIALCOMPONENTNAME MATERIALCOMPONENTNAME Material Description of Component
PRODUCTNAME PRODUCTNAME Material Description
SALESORDER SALESORDER SD Document
SCHEDULEDBASICENDDATE SCHEDULEDBASICENDDATE Scheduled End
SCHEDULEDBASICENDTIME SCHEDULEDBASICENDTIME Scheduled end time
SCHEDULEDBASICSTARTDATE SCHEDULEDBASICSTARTDATE Scheduled Start
SCHEDULEDBASICSTARTTIME SCHEDULEDBASICSTARTTIME
SOLDTOPARTY SOLDTOPARTY Customer ID
SYSTEMSTATUSNAME SYSTEMSTATUSNAME System Status Description
CREATEDBYUSERDESCRIPTION CREATEDBYUSERDESCRIPTION Created By
LASTCHANGEDBYUSERDESCRIPTION LASTCHANGEDBYUSERDESCRIPTION Changed By
WBSDESCRIPTION WBSDESCRIPTION WBS Element Description
WBSELEMENT WBSELEMENT WBS Internal 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_PROCESSORDER.
-- 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_PROCORDER
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_PROCESSORDER AS
SELECT
  ORDERID,
  BASEUNIT,
  BATCH,
  ISMARKEDFORDELETION,
  LEADINGORDER,
  MATERIAL,
  MRPAREA,
  MRPAREATEXT,
  MRPCONTROLLER,
  MRPPLANT,
  OBJECTINTERNALID,
  ORDERCATEGORY,
  ORDERCOMPONENTLONGTEXT,
  ORDERDESCRIPTION,
  ORDERINTERNALBILLOFOPERATIONS,
  ORDEROPERATIONLONGTEXT,
  ORDERPLANNEDTOTALQTY,
  ORDERTYPE,
  ORDERTYPENAME,
  ORGANIZATIONBPNAME1,
  ORDERLONGTEXT,
  PLANNEDENDDATE,
  PLANNEDSTARTDATE,
  PLANTNAME,
  MRPPLANTNAME,
  PRODUCTIONPLANT,
  MATERIALCOMPONENTNAME,
  PRODUCTNAME,
  SALESORDER,
  SCHEDULEDBASICENDDATE,
  SCHEDULEDBASICENDTIME,
  SCHEDULEDBASICSTARTDATE,
  SCHEDULEDBASICSTARTTIME,
  SOLDTOPARTY,
  SYSTEMSTATUSNAME,
  CREATEDBYUSERDESCRIPTION,
  LASTCHANGEDBYUSERDESCRIPTION,
  WBSDESCRIPTION,
  WBSELEMENT,
  WORKCENTERTEXT
FROM ESH_N_PROCESSORDER
LEFT OUTER JOIN E_LOGISTICSORDER AS _EXTENSION ON ( ORDERID = _EXTENSION.ORDERID )  -- association [0..1]
;

Learn More