I_TransportationOrderBlock

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_TransportationOrderBlock.
-- 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_TransportationOrderBlock AS
SELECT
  cast(node_key as /scmtms/vdm_tor_block_nodekey preserving type ) AS TranspOrderBlockNodeKeyUUID,
  cast(db_key as /scmtms/vdm_tor_block_db_key preserving type) AS TransportationOrderBlockUUID,
  cast(root_key as /scmtms/vdm_tor_db_key preserving type) AS TransportationOrderUUID,
  cast(parent_key as /scmtms/vdm_tor_blknode_db_key preserving type) AS TranspOrdBlockedNodeUUID,
  block_rc AS BlockReason,
  overruled AS TranspOrdBlockIsOverruled,
  blk_plan AS TranspOrdPlanningBlock,
  blk_exec AS TranspOrdExecutionIsBlocked,
  blk_invo AS InvoicingIsBlocked,
  block_cat AS BlockCategory
FROM /scmtms/d_torblk
LEFT OUTER JOIN I_TransportationOrder AS _TransportationOrder ON TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID  -- association [1..1]
LEFT OUTER JOIN I_TransportationOrderStage AS _TransportationOrderStage ON TranspOrdBlockedNodeUUID = _TransportationOrderStage.TransportationOrderStageUUID  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdBlockIsOverruled AS _TranspOrdBlockIsOverruled ON TranspOrdBlockIsOverruled = _TranspOrdBlockIsOverruled.TranspOrdBlockIsOverruled  -- association [0..1]
LEFT OUTER JOIN I_BlockReasonCode AS _BlockReason ON BlockReason = _BlockReason.BlockReason  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdPlanningBlock AS _TranspOrdPlanningBlock ON TranspOrdPlanningBlock = _TranspOrdPlanningBlock.TranspOrdPlanningBlock  -- association [0..1]
LEFT OUTER JOIN I_TranspOrdExecutionIsBlocked AS _TranspOrdExecutionIsBlocked ON TranspOrdExecutionIsBlocked = _TranspOrdExecutionIsBlocked.TranspOrdExecutionIsBlocked  -- association [0..1]
LEFT OUTER JOIN I_InvoicingIsBlocked AS _InvoicingIsBlocked ON InvoicingIsBlocked = _InvoicingIsBlocked.InvoicingIsBlocked  -- association [0..1]
LEFT OUTER JOIN I_BlockCategory AS _BlockCategory ON BlockCategory = _BlockCategory.BlockCategory  -- association [0..1]
;