C_InvgCsMLocOtherNameTP

DDL: C_INVGCSMLOCOTHERNAMETP SQL: CINVGCSMOTRNTP Type: view CONSUMPTION
16 Fields 1 Data Sources 6 Associations

Consumptional View for ICM Location Other Names

C_InvgCsMLocOtherNameTP is a Consumption CDS View that provides data about "Consumptional View for ICM Location Other Names" in SAP S/4HANA. It reads from 1 data source (I_InvgCsMLocOtherNameTP) and exposes 16 fields with key fields InvgCsMLocationID, InvgCsMSeqNumber, InvgCsMRelatedEntityType, InvgCsMAltvIdnPrflID. It has 6 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InvgCsMLocOtherNameTP I_InvgCsMLocOtherNameTP from

Associations (6)

CardinalityTargetAliasCondition
[1..1] C_InvgCsMLocationTP _Location _Location.InvgCsMLocationID = $projection.InvgCsMLocationID
[0..1] C_InvgCsMOtherNameTypeVH _othernamevh $projection.InvgCsMOtherNameType = _othernamevh.InvgCsMOtherNameType and $projection.InvgCsMAltvIdnPrflIDForEdit = _othernamevh.InvgCsMAltvIdnPrflID and _othernamevh.InvgCsMAltvIdnProfileAreaID = 'LOCATION'
[0..*] C_InvgCsMOtherNameTypeText _othernametextvh $projection.InvgCsMOtherNameType = _othernametextvh.InvgCsMOtherNameType
[0..*] C_InvgCsMLocProfileIdnVH _PrflIdnVH $projection.InvgCsMAltvIdnPrflIDForEdit = _PrflIdnVH.InvgCsMAltvIdnPrflID
[0..*] C_InvgCsMLocProfileIdnText _PrflIdnTextVH $projection.InvgCsMAltvIdnPrflIDForEdit = _PrflIdnTextVH.InvgCsMAltvIdnPrflID
[0..*] C_InvgCsMReliabilityVH _RlibtyVH $projection.InvgCsMRlibtyMtrxRlibtyID = _RlibtyVH.InvgCsMRlibtyMtrxRlibtyID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CINVGCSMOTRNTP view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Consumptional View for ICM Location Other Names view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY InvgCsMLocationID InvgCsMLocationID
KEY InvgCsMSeqNumber InvgCsMSeqNumber
KEY InvgCsMRelatedEntityType InvgCsMRelatedEntityType
KEY InvgCsMAltvIdnPrflID InvgCsMAltvIdnPrflID
InvgCsMLanguageCode InvgCsMLanguageCode
InvgCsMRlibtyMtrxRlibtyID InvgCsMRlibtyMtrxRlibtyID Reliability
InvgCsMAltvIdnPrflIDForEdit InvgCsMAltvIdnPrflIDForEdit Profile
InvgCsMOtherNameType InvgCsMOtherNameType Type
InvgCsMOtherNameTypeText InvgCsMOtherNameTypeText Description
InvgCsMOtherName InvgCsMOtherName Value
InvgCsMIsDeleteAllowed InvgCsMIsDeleteAllowed
_Location _Location
_othernamevh _othernamevh
_RlibtyVH _RlibtyVH
_PrflIdnVH _PrflIdnVH
_PrflIdnTextVH _PrflIdnTextVH

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_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: CINVGCSMOTRNTP

CREATE VIEW C_InvgCsMLocOtherNameTP AS
SELECT
  InvgCsMLocationID,
  InvgCsMSeqNumber,
  InvgCsMRelatedEntityType,
  InvgCsMAltvIdnPrflID,
  InvgCsMLanguageCode,
  InvgCsMRlibtyMtrxRlibtyID,
  InvgCsMAltvIdnPrflIDForEdit,
  InvgCsMOtherNameType,
  InvgCsMOtherNameTypeText,
  InvgCsMOtherName,
  InvgCsMIsDeleteAllowed
FROM I_InvgCsMLocOtherNameTP
LEFT OUTER JOIN C_InvgCsMLocationTP AS _Location ON _Location.InvgCsMLocationID = InvgCsMLocationID  -- association [1..1]
LEFT OUTER JOIN C_InvgCsMOtherNameTypeVH AS _othernamevh ON InvgCsMOtherNameType = _othernamevh.InvgCsMOtherNameType AND InvgCsMAltvIdnPrflIDForEdit = _othernamevh.InvgCsMAltvIdnPrflID AND _othernamevh.InvgCsMAltvIdnProfileAreaID = 'LOCATION'  -- association [0..1]
LEFT OUTER JOIN C_InvgCsMOtherNameTypeText AS _othernametextvh ON InvgCsMOtherNameType = _othernametextvh.InvgCsMOtherNameType  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMLocProfileIdnVH AS _PrflIdnVH ON InvgCsMAltvIdnPrflIDForEdit = _PrflIdnVH.InvgCsMAltvIdnPrflID  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMLocProfileIdnText AS _PrflIdnTextVH ON InvgCsMAltvIdnPrflIDForEdit = _PrflIdnTextVH.InvgCsMAltvIdnPrflID  -- association [0..*]
LEFT OUTER JOIN C_InvgCsMReliabilityVH AS _RlibtyVH ON InvgCsMRlibtyMtrxRlibtyID = _RlibtyVH.InvgCsMRlibtyMtrxRlibtyID  -- association [0..*]
;

Learn More