I_InvgCsMLocationOtherName

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_InvgCsMLocationOtherName.
-- 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: IINVGCSMLOCOTRNM

CREATE VIEW I_InvgCsMLocationOtherName AS
SELECT
  entity_id AS InvgCsMLocationID,
  seqnr AS InvgCsMSeqNumber,
  entity_type AS InvgCsMRelatedEntityType,
  profile_id AS InvgCsMAltvIdnPrflID,
  spras AS InvgCsMLanguageCode,
  type AS InvgCsMOtherNameType,
  name AS InvgCsMOtherName,
  mcname AS InvgCsMUpperCaseOtherName,
  _OtherNameTextVH.InvgCsMOtherNameTypeText AS InvgCsMOtherNameTypeText,
  _RlibtyMtrx.InvgCsMReliabilityMatrixUUID AS InvgCsMReliabilityMatrixUUID,
  _RlibtyMtrx.InvgCsMRlibtyMtrxRefTypeCode AS InvgCsMRlibtyMtrxRefTypeCode,
  _RlibtyMtrx.InvgCsMRlibtyMtrxRefSetTypeID AS InvgCsMRlibtyMtrxRefSetTypeID,
  _RlibtyMtrx.InvgCsMRlibtyMtrxRefLogSystID AS InvgCsMRlibtyMtrxRefLogSystID,
  _RlibtyMtrx.InvgCsMRlibtyMtrxSrceRlibtyID AS InvgCsMRlibtyMtrxSrceRlibtyID,
  _RlibtyMtrx.InvgCsMRlibtyMtrxInfoRlibtyID AS InvgCsMRlibtyMtrxInfoRlibtyID,
  _RlibtyMtrx.InvgCsMRlibtyMtrxHndlgCodeID AS InvgCsMRlibtyMtrxHndlgCodeID,
  _RlibtyMtrx.InvgCsMRlibtyMtrxIsDeleted AS InvgCsMRlibtyMtrxIsDeleted,
  _RlibtyMtrx.InvgCsMRlibtyMtrxArchiveSts AS InvgCsMRlibtyMtrxArchiveSts,
  _RlibtyMtrx.InvgCsMRlibtyMtrxRlibtyID AS InvgCsMRlibtyMtrxRlibtyID
FROM crms4d_othr_name
LEFT OUTER JOIN I_InvgCsMOtherNameTypeText AS _OtherNameTextVH ON InvgCsMOtherNameType = _OtherNameTextVH.InvgCsMOtherNameType AND _OtherNameTextVH.InvgCsMLanguageCode = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_InvgCsMReliabilityMatrix AS _RlibtyMtrx ON InvgCsMLocationID = _RlibtyMtrx.InvgCsMRlibtyMtrxCharRefObjID AND _RlibtyMtrx.InvgCsMRlibtyMtrxRefTypeCode = 'PSIC_NAMES' AND _RlibtyMtrx.InvgCsMRlibtyMtrxIsDeleted != 'X' AND InvgCsMSeqNumber = _RlibtyMtrx.InvgCsMRlibtyMtrxRefSetTypeID  -- association [1..1]
;