C_InvgCsMLocationVH

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_InvgCsMLocationVH.
-- 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: CINVGCSMLOCVH

CREATE VIEW C_InvgCsMLocationVH AS
SELECT
  InvgCsMLocationID,
  InvgCsMLocationName,
  cast ( bintohex(InvgCsMLocationCategoryUUID) as char32) AS InvgCsMLocationCategoryUUID,
  InvgCsMLocationSecurityLevel,
  ArchivingStatus,
  InvgCsMLocationIsHidden,
  cast( BusinessUser as sysid ) AS BusinessUser
FROM I_InvgCsMVisibleLocation
LEFT OUTER JOIN C_InvgCsMLocCategoryVH AS _catvh ON InvgCsMLocationCategoryUUID = _catvh.InvgCsMCategoryUUID  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMCategoryText AS _catTextvh ON InvgCsMLocationCategoryUUID = _catTextvh.InvgCsMCategoryUUID  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMSecurityLevelVH AS _slvh ON InvgCsMLocationSecurityLevel = _slvh.InvgCsMAuthScopeCode  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMSecurityLevelText AS _sltextvh ON InvgCsMLocationSecurityLevel = _sltextvh.InvgCsMAuthScopeCode  -- association [0..*]
;