ESH_N_PROCESSORDER

DDL: ESH_N_PROCESSORDER SQL: ESH_L_PROCORDER Type: view Package: BSESH_PP_PI
40 Fields 1 Data Sources 2 Associations

Anchor view -PROCESSORDER

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

Data Sources (1)

SourceAliasJoin Type
I_LOGISTICSORDER I_LOGISTICSORDER from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (2)

CardinalityTargetAliasCondition
[1..1] N_ORDEROPERATION _ORDEROPERATION $projection.OrderInternalBillOfOperations=_ORDEROPERATION.OrderInternalID
[0..*] N_STATUSOBJECTSTATUS _STATUSOBJECTSTATUS $projection.ObjectInternalID=_STATUSOBJECTSTATUS.StatusObject and _STATUSOBJECTSTATUS.StatusIsInactive=''

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED 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
AbapCatalog.sqlViewName ESH_L_PROCORDER view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY ORDERID ORDERID Order ID
BASEUNIT BASEUNIT Unit of Measure
BATCH _ORDERMAINITEM BATCH Lot No.
ISMARKEDFORDELETION ISMARKEDFORDELETION Purch.org. data
LEADINGORDER LEADINGORDER Last order
MATERIAL _ORDERMAINITEM MATERIAL Vehicle Model
MRPAREA _ORDERMAINITEM MRPAREA MRP Area
MRPAREATEXT
MRPCONTROLLER MRPCONTROLLER MRP Controller
MRPPLANT _ORDERMAINITEM MRPPLANT Plant
OBJECTINTERNALID OBJECTINTERNALID Object number
ORDERCATEGORY ORDERCATEGORY Order Category
ORDERCOMPONENTLONGTEXT
ORDERDESCRIPTION ORDERDESCRIPTION
ORDERINTERNALBILLOFOPERATIONS ORDERINTERNALBILLOFOPERATIONS Order Internal Bill of Operations
ORDEROPERATIONLONGTEXT
ORDERPLANNEDTOTALQTY ORDERPLANNEDTOTALQTY
ORDERTYPE ORDERTYPE Order Type
ORDERTYPENAME
ORGANIZATIONBPNAME1
ORDERLONGTEXT _LONGTEXT PLAINLONGTEXT Long Text
PLANNEDENDDATE PLANNEDENDDATE Ltst Planned Finish
PLANNEDSTARTDATE PLANNEDSTARTDATE Latest Planned Start
PLANTNAME
MRPPLANTNAME
PRODUCTIONPLANT _ORDERMAINITEM PRODUCTIONPLANT Prod plnt
MATERIALCOMPONENTNAME
PRODUCTNAME
SALESORDER SALESORDER SD Document
SCHEDULEDBASICENDDATE SCHEDULEDBASICENDDATE Sched. finish
SCHEDULEDBASICENDTIME SCHEDULEDBASICENDTIME
SCHEDULEDBASICSTARTDATE SCHEDULEDBASICSTARTDATE Sched. start
SCHEDULEDBASICSTARTTIME SCHEDULEDBASICSTARTTIME
SOLDTOPARTY _SALESORDER SOLDTOPARTY Sold-to Party
SYSTEMSTATUSNAME
CREATEDBYUSERDESCRIPTION _CREATEDBYUSER USERDESCRIPTION Full Name
LASTCHANGEDBYUSERDESCRIPTION _LASTCHANGEDBYUSER USERDESCRIPTION Full Name
WBSDESCRIPTION _WBSELEMENT WBSDESCRIPTION WBS Element Name
WBSELEMENT _WBSELEMENT WBSELEMENT WBS Internal ID
WORKCENTERTEXT _ORDEROPERATION WORKCENTERTEXT Work Center Text

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_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_L_PROCORDER
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_PROCESSORDER AS
SELECT
  ORDERID,
  BASEUNIT,
  _ORDERMAINITEM.BATCH AS BATCH,
  ISMARKEDFORDELETION,
  LEADINGORDER,
  _ORDERMAINITEM.MATERIAL AS MATERIAL,
  _ORDERMAINITEM.MRPAREA AS MRPAREA,
  _ORDERMAINITEM._MRPAREA.MRPAREATEXT AS MRPAREATEXT,
  MRPCONTROLLER,
  _ORDERMAINITEM.MRPPLANT AS MRPPLANT,
  OBJECTINTERNALID,
  ORDERCATEGORY,
  _ORDERCOMPONENT._LONGTEXT.ORDERCOMPONENTLONGTEXT AS ORDERCOMPONENTLONGTEXT,
  ORDERDESCRIPTION,
  ORDERINTERNALBILLOFOPERATIONS,
  _ORDEROPERATION._LONGTEXT.ORDEROPERATIONLONGTEXT AS ORDEROPERATIONLONGTEXT,
  ORDERPLANNEDTOTALQTY,
  ORDERTYPE,
  _ORDERTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].ORDERTYPENAME AS ORDERTYPENAME,
  _SALESORDER._SOLDTOPARTY.ORGANIZATIONBPNAME1 AS ORGANIZATIONBPNAME1,
  _LONGTEXT.PLAINLONGTEXT AS ORDERLONGTEXT,
  PLANNEDENDDATE,
  PLANNEDSTARTDATE,
  _ORDERMAINITEM._PRODUCTIONPLANT.PLANTNAME AS PLANTNAME,
  _ORDERMAINITEM._MRPPLANT.PLANTNAME AS MRPPLANTNAME,
  _ORDERMAINITEM.PRODUCTIONPLANT AS PRODUCTIONPLANT,
  _RESERVATION._RESERVATIONDOCUMENTITEM._PRODUCT._TEXT[1: LANGUAGE = $parameters. P_Language].PRODUCTNAME AS MATERIALCOMPONENTNAME,
  _ORDERMAINITEM._PRODUCT._TEXT[1: LANGUAGE = $parameters. P_Language].PRODUCTNAME AS PRODUCTNAME,
  SALESORDER,
  SCHEDULEDBASICENDDATE,
  SCHEDULEDBASICENDTIME,
  SCHEDULEDBASICSTARTDATE,
  SCHEDULEDBASICSTARTTIME,
  _SALESORDER.SOLDTOPARTY AS SOLDTOPARTY,
  _STATUSOBJECTSTATUS._SYSTEMSTATUS._SYSTEMSTATUSTEXT[1: LANGUAGE = $parameters. P_Language].SYSTEMSTATUSNAME AS SYSTEMSTATUSNAME,
  _CREATEDBYUSER.USERDESCRIPTION AS CREATEDBYUSERDESCRIPTION,
  _LASTCHANGEDBYUSER.USERDESCRIPTION AS LASTCHANGEDBYUSERDESCRIPTION,
  _WBSELEMENT.WBSDESCRIPTION AS WBSDESCRIPTION,
  _WBSELEMENT.WBSELEMENT AS WBSELEMENT,
  _ORDEROPERATION.WORKCENTERTEXT AS WORKCENTERTEXT
FROM I_LOGISTICSORDER
LEFT OUTER JOIN N_ORDEROPERATION AS _ORDEROPERATION ON OrderInternalBillOfOperations=_ORDEROPERATION.OrderInternalID  -- association [1..1]
LEFT OUTER JOIN N_STATUSOBJECTSTATUS AS _STATUSOBJECTSTATUS ON ObjectInternalID=_STATUSOBJECTSTATUS.StatusObject AND _STATUSOBJECTSTATUS.StatusIsInactive=''  -- association [0..*]
;

Learn More