I_ProcessOrderUserStatus

DDL: I_PROCESSORDERUSERSTATUS Type: view_entity COMPOSITE Package: VDM_PP_PROC_ORD_MNG
9 Fields 3 Data Sources 3 Associations 1 OData Services

Process Orders User Status

I_ProcessOrderUserStatus is a Composite CDS View that provides data about "Process Orders User Status" in SAP S/4HANA. It reads from 3 data sources (P_ProcOrdAORListDistinct, I_ProcessOrderStatus, I_ProcessOrderStatusInfo) and exposes 9 fields with key fields OrderID, StatusObject, StatusCode, StatusProfile. It has 3 associations to related views. It is exposed through 1 OData service (ASQL_F4587). Part of development package VDM_PP_PROC_ORD_MNG.

Data Sources (3)

SourceAliasJoin Type
P_ProcOrdAORListDistinct AORList inner
I_ProcessOrderStatus jest from
I_ProcessOrderStatusInfo jsto inner

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_UserStatus _UserStatus _UserStatus.UserStatus = jest.StatusCode and _UserStatus.StatusProfile = jsto.StatusProfile
[0..1] I_StatusProfile _StatusProfile _StatusProfile.StatusProfile = jsto.StatusProfile --FOR DCL
[1..1] I_LogisticsOrder _Order _Order.OrderID = $projection.OrderID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Process Orders User Status view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F4587 ASQL_F4587 C2 NOT_RELEASED

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY OrderID P_ProcOrdAORListDistinct OrderID Order ID
KEY StatusObject I_ProcessOrderStatusInfo StatusObject Status Object
KEY StatusCode I_ProcessOrderStatus StatusCode Statuscode
KEY StatusProfile I_ProcessOrderStatusInfo StatusProfile Status Profile
UserStatusName
UserStatusShortName
_UserStatus _UserStatus
_StatusProfile _StatusProfile
forDCL_Order

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 I_ProcessOrderUserStatus.
-- 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.

CREATE VIEW I_ProcessOrderUserStatus AS
SELECT
  AORList.OrderID AS OrderID,
  jsto.StatusObject AS StatusObject,
  jest.StatusCode AS StatusCode,
  jsto.StatusProfile AS StatusProfile,
  _UserStatus._UserStatusText[ 1:Language = $session.system_language ].UserStatusName AS UserStatusName,
  _UserStatus._UserStatusText[ 1:Language = $session.system_language ].UserStatusShortName AS UserStatusShortName
FROM I_ProcessOrderStatus AS jest
INNER JOIN I_ProcessOrderStatusInfo AS jsto ON /* join condition not captured in parsed metadata */
INNER JOIN P_ProcOrdAORListDistinct AS AORList ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_UserStatus AS _UserStatus ON _UserStatus.UserStatus = jest.StatusCode AND _UserStatus.StatusProfile = jsto.StatusProfile  -- association [0..1]
LEFT OUTER JOIN I_StatusProfile AS _StatusProfile ON _StatusProfile.StatusProfile = jsto.StatusProfile  -- association [0..1]
LEFT OUTER JOIN I_LogisticsOrder AS _Order ON _Order.OrderID = OrderID  -- association [1..1]
;

Learn More