fins_rev_rec_VCMHM_CHAIN

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 fins_rev_rec_VCMHM_CHAIN.
-- 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: TRR_VCMHMC

CREATE VIEW fins_rev_rec_VCMHM_CHAIN AS
SELECT
  vcm_rt_chain_ins.version AS version,
  vcm_rt_chain_ins.status AS ValueChainInstanceStatus,
  Step.step_type AS step_type,
  Step.status AS ValueChainStepInstanceStatus,
  Step.guid AS ValueChainStepInstanceUUID,
  Schedule.sched_status AS SchedulingStatus,
  Schedule.scheduled_at AS SchedulingTimestamp,
  BoItem.business_object_id AS BUSINESS_OBJECT_ID,
  BoItem.deleted AS deleted,
  BoItem.cancelled AS cancelled,
  InboundItem.ValueChainBusinessObject AS InboundBusinessObjectID,
  InboundItem.ValueChainBusinessObjectItem AS InboundBusinessObjectItemID,
  InboundItem.ValueChainBusObjItemProcStat AS InboundItemProcessingStatus
FROM vcm_rt_chain_ins
LEFT OUTER JOIN vcm_rt_step_ins AS Step ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vcm_rt_step_schd AS Schedule ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN vcm_rt_bo_item AS BoItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ValueChainStepInboundItem AS InboundItem ON /* join condition not captured in parsed metadata */
;