I_ValueChainStepExpdBusObjItm

DDL: I_VALUECHAINSTEPEXPDBUSOBJITM Type: view COMPOSITE Package: CA_VCM_RUNTIME_RAP
13 Fields 2 Data Sources 1 Associations

Expected Business Object Item of Value Chain Instance

I_ValueChainStepExpdBusObjItm is a Composite CDS View that provides data about "Expected Business Object Item of Value Chain Instance" in SAP S/4HANA. It reads from 2 data sources (I_ValueChainBusObjItem, I_ValueChainStepInboundItem) and exposes 13 fields with key fields ValueChainStepInstanceUUID, ValueChainBusinessObject, ValueChainBusinessObjectItem. It has 1 association to related views. Part of development package CA_VCM_RUNTIME_RAP.

Data Sources (2)

SourceAliasJoin Type
I_ValueChainBusObjItem BusObjItem inner
I_ValueChainStepInboundItem InboundItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_ValueChainInstance _Instance _Instance.ValueChainInstanceUUID = $projection.ValueChainInstanceUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IVCM_CHAINEXBOI view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view
EndUserText.label Expected Business Object Item of Value Chain Instance view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ValueChainStepInstanceUUID I_ValueChainStepInboundItem ValueChainStepInstanceUUID UUID
KEY ValueChainBusinessObject I_ValueChainStepInboundItem ValueChainBusinessObject Business Object ID
KEY ValueChainBusinessObjectItem I_ValueChainStepInboundItem ValueChainBusinessObjectItem BO Item
ValueChainBusObjItemProcStat I_ValueChainStepInboundItem ValueChainBusObjItemProcStat User Status Code
ValueChainStepBusinessObject
ValueChainInstanceUUID Step ValueChainInstanceUUID UUID
ValueChainStepPredecessorUUID Step ValueChainStepPredecessorUUID
ValueChainPredecessorBusObj I_ValueChainBusObjItem ValueChainBusinessObject Business Object ID
ValueChainPrdcssrBusObjItem I_ValueChainBusObjItem ValueChainBusinessObjectItem BO Item
ValueChainPredecessorStpBusObj I_ValueChainBusObjItem ValueChainStepBusinessObject Business Object
ValueChainItemUUID I_ValueChainBusObjItem ValueChainItemUUID UUID
IsReversalDocument I_ValueChainBusObjItem IsReversalDocument Reverse
_Instance _Instance

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_ValueChainStepExpdBusObjItm.
-- 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_ValueChainStepExpdBusObjItm AS
SELECT
  InboundItem.ValueChainStepInstanceUUID AS ValueChainStepInstanceUUID,
  InboundItem.ValueChainBusinessObject AS ValueChainBusinessObject,
  InboundItem.ValueChainBusinessObjectItem AS ValueChainBusinessObjectItem,
  InboundItem.ValueChainBusObjItemProcStat AS ValueChainBusObjItemProcStat,
  Step._ValueChainStepType.ValueChainStepBusinessObject AS ValueChainStepBusinessObject,
  Step.ValueChainInstanceUUID AS ValueChainInstanceUUID,
  Step.ValueChainStepPredecessorUUID AS ValueChainStepPredecessorUUID,
  BusObjItem.ValueChainBusinessObject AS ValueChainPredecessorBusObj,
  BusObjItem.ValueChainBusinessObjectItem AS ValueChainPrdcssrBusObjItem,
  BusObjItem.ValueChainStepBusinessObject AS ValueChainPredecessorStpBusObj,
  BusObjItem.ValueChainItemUUID AS ValueChainItemUUID,
  BusObjItem.IsReversalDocument AS IsReversalDocument
FROM I_ValueChainStepInboundItem AS InboundItem
INNER JOIN I_ValueChainBusObjItem AS BusObjItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ValueChainInstance AS _Instance ON _Instance.ValueChainInstanceUUID = ValueChainInstanceUUID  -- association [0..1]
;

Learn More