I_InvgCsMLocOtherNameTP

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_InvgCsMLocOtherNameTP.
-- 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: IINVGCSMLOCOTRNT

CREATE VIEW I_InvgCsMLocOtherNameTP AS
SELECT
  InvgCsMLocationID,
  InvgCsMAltvIdnPrflID,
  InvgCsMSeqNumber,
  InvgCsMRelatedEntityType,
  InvgCsMLanguageCode,
  InvgCsMAltvIdnPrflID AS InvgCsMAltvIdnPrflIDForEdit,
  InvgCsMOtherNameType,
  _OtherNameTextVH.InvgCsMOtherNameTypeText AS InvgCsMOtherNameTypeText,
  InvgCsMOtherName,
  InvgCsMUpperCaseOtherName,
  InvgCsMReliabilityMatrixUUID,
  InvgCsMRlibtyMtrxRefTypeCode,
  InvgCsMRlibtyMtrxRefSetTypeID,
  InvgCsMRlibtyMtrxRefLogSystID,
  InvgCsMRlibtyMtrxSrceRlibtyID,
  InvgCsMRlibtyMtrxInfoRlibtyID,
  InvgCsMRlibtyMtrxHndlgCodeID,
  InvgCsMRlibtyMtrxIsDeleted,
  InvgCsMRlibtyMtrxArchiveSts,
  InvgCsMRlibtyMtrxRlibtyID,
  cast('' as boolean) AS InvgCsMIsDeleteAllowed
FROM I_InvgCsMLocationOtherName
LEFT OUTER JOIN I_InvgCsMLocationTP AS _location ON _location.InvgCsMLocationID = InvgCsMLocationID  -- association [1..1]
LEFT OUTER JOIN I_InvgCsMOtherNameTypeText AS _OtherNameTextVH ON InvgCsMOtherNameType = _OtherNameTextVH.InvgCsMOtherNameType AND _OtherNameTextVH.InvgCsMLanguageCode = $session.system_language  -- association [1..1]
;