I_OrderOperationStatusBasic

DDL: I_ORDEROPERATIONSTATUSBASIC Type: view_entity COMPOSITE
18 Fields 1 Data Sources

Order Operation Status Basic

I_OrderOperationStatusBasic is a Composite CDS View (Dimension) that provides data about "Order Operation Status Basic" in SAP S/4HANA. It reads from 1 data source (I_OrderOperationBasic) and exposes 18 fields with key fields OrderInternalID, OrderOperationInternalID.

Data Sources (1)

SourceAliasJoin Type
I_OrderOperationBasic afvc from

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataCategory #DIMENSION view
Analytics.technicalName IORDOPRSTATUSBSC view
ObjectModel.representativeKey OrderOperationInternalID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
EndUserText.label Order Operation Status Basic view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY OrderInternalID I_OrderOperationBasic OrderInternalID Plan No.f.Oper.
KEY OrderOperationInternalID I_OrderOperationBasic OrderOperationInternalID Plan No.f.Oper.
Sequence I_OrderOperationBasic Sequence Visit Sequence
SuperiorOperationInternalID I_OrderOperationBasic SuperiorOperationInternalID Sup. Op. Node
Operation
ObjectInternalID I_OrderOperationBasic ObjectInternalID Object number
OrderID _Order OrderID Order ID
Plant I_OrderOperationBasic Plant Valuation Area
OperationIsCreated
OperationIsReleased
OperationIsConfirmed
OperationIsPartiallyConfirmed
OperationIsDeleted
OperationIsTechlyCompleted
OperationIsClosed
OperationIsPartiallyDelivered
OperationIsDelivered
_OrderInternalID I_OrderOperationBasic _OrderInternalID

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_OrderOperationStatusBasic.
-- 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_OrderOperationStatusBasic AS
SELECT
  afvc.OrderInternalID AS OrderInternalID,
  afvc.OrderOperationInternalID AS OrderOperationInternalID,
  afvc.Sequence AS Sequence,
  afvc.SuperiorOperationInternalID AS SuperiorOperationInternalID,
  cast(afvc.Operation as vdm_vornr preserving type) AS Operation,
  afvc.ObjectInternalID AS ObjectInternalID,
  _Order.OrderID AS OrderID,
  afvc.Plant AS Plant,
  case when _isCreated.StatusCode is null then '' else 'X' end AS OperationIsCreated,
  case when _isReleased.StatusCode is null then '' else 'X' end AS OperationIsReleased,
  case when _isConfirmed.StatusCode is null then '' else 'X' end AS OperationIsConfirmed,
  case when _isPartConf.StatusCode is null then '' else 'X' end AS OperationIsPartiallyConfirmed,
  case when _isDeleted.StatusCode is null then '' else 'X' end AS OperationIsDeleted,
  case when _isTechCompl.StatusCode is null then '' else 'X' end AS OperationIsTechlyCompleted,
  case when _isClosed.StatusCode is null then '' else 'X' end AS OperationIsClosed,
  case when _isPartDeliv.StatusCode is null then '' else 'X' end AS OperationIsPartiallyDelivered,
  case when _isDelivered.StatusCode is null then '' else 'X' end AS OperationIsDelivered,
  afvc._OrderInternalID AS _OrderInternalID
FROM I_OrderOperationBasic AS afvc
;

Learn More