C_IntcoValueChainMntrProcStep

DDL: C_INTCOVALUECHAINMNTRPROCSTEP SQL: CVCM_ICMST Type: view CONSUMPTION Package: ODATA_CA_VCM_MNTR

Intco Value Chain Instance Monitor Process Step

C_IntcoValueChainMntrProcStep is a Consumption CDS View that provides data about "Intco Value Chain Instance Monitor Process Step" in SAP S/4HANA. It reads from 1 data source (I_ValueChainStepInstance) and exposes 10 fields with key field ValueChainStepInstanceUUID. It has 2 associations to related views. It is exposed through 2 OData services (ASQL_F4854, UI_VALUECHAINMONITOR). It is used in 1 Fiori application: Monitor Value Chains. Part of development package ODATA_CA_VCM_MNTR.

Data Sources (1)

SourceAliasJoin Type
I_ValueChainStepInstance StepInstance from

Associations (2)

CardinalityTargetAliasCondition
[0..1] R_ValueChainStepInstanceTP _Step _Step.ValueChainStepInstanceUUID = $projection.ValueChainStepInstanceUUID
[0..1] I_ValueChainStepType _ValueChainStepType _ValueChainStepType.ValueChainType = $projection.ValueChainType and _ValueChainStepType.ValueChainTypeVersion = $projection.ValueChainTypeVersion and _ValueChainStepType.ValueChainStepType = $projection.ValueChainStepType

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CVCM_ICMST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
EndUserText.label Intco Value Chain Instance Monitor Process Step view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F4854 ASQL_F4854 C2 NOT_RELEASED
UI_VALUECHAINMONITOR UI_VALUECHAINMONITOR V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4854 Monitor Value Chains Transactional You use this app to track all steps of advanced intercompany sales, advanced intercompany stock transfer, and sell from stock with valuated stock in transit (VSiT) business processes.

Monitor Value Chains

Business Role: Others

Intercompany sales processes allow two affiliated companies and an external customer to participate in a single intercompany process. With the Advanced Intercompany Sales process, the system automatically creates the following additional business documents:Purchase orders in the selling companies Sales orders in the delivering companies For the transfer of control of goods between the affiliated companies and to the customer, this advanced process uses valuated stock in transit (VSiT).

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ValueChainStepInstanceUUID I_ValueChainStepInstance ValueChainStepInstanceUUID UUID 22 char.
ValueChainStepPredecessorUUID I_ValueChainStepInstance ValueChainStepPredecessorUUID UUID
ValueChainInstanceUUID I_ValueChainStepInstance ValueChainInstanceUUID UUID
ValueChainType I_ValueChainStepInstance ValueChainType
ValueChainStepType I_ValueChainStepInstance ValueChainStepType VSS Sol. Step Type
ValueChainTypeVersion I_ValueChainStepInstance ValueChainTypeVersion
ValueChainStepTypeDescription
ValueChainStepInstanceStatus ValueChainStepInstanceStatus Process Step Stage
ValueChainStepInstanceStsName
_ValueChainStepType _ValueChainStepType

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 C_IntcoValueChainMntrProcStep.
-- 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: CVCM_ICMST

CREATE VIEW C_IntcoValueChainMntrProcStep AS
SELECT
  StepInstance.ValueChainStepInstanceUUID AS ValueChainStepInstanceUUID,
  StepInstance.ValueChainStepPredecessorUUID AS ValueChainStepPredecessorUUID,
  StepInstance.ValueChainInstanceUUID AS ValueChainInstanceUUID,
  StepInstance.ValueChainType AS ValueChainType,
  StepInstance.ValueChainStepType AS ValueChainStepType,
  StepInstance.ValueChainTypeVersion AS ValueChainTypeVersion,
  _ValueChainStepType._Text[1: Language = $session.system_language].ValueChainStepTypeDescription AS ValueChainStepTypeDescription,
  ValueChainStepInstanceStatus,
  _Step._StatusText[1: Language = $session.system_language].ValueChainStepInstanceStsName AS ValueChainStepInstanceStsName
FROM I_ValueChainStepInstance AS StepInstance
LEFT OUTER JOIN R_ValueChainStepInstanceTP AS _Step ON _Step.ValueChainStepInstanceUUID = ValueChainStepInstanceUUID  -- association [0..1]
LEFT OUTER JOIN I_ValueChainStepType AS _ValueChainStepType ON _ValueChainStepType.ValueChainType = ValueChainType AND _ValueChainStepType.ValueChainTypeVersion = ValueChainTypeVersion AND _ValueChainStepType.ValueChainStepType = ValueChainStepType  -- association [0..1]
;