I_LCMCtxIntContactTP

DDL: I_LCMCTXINTCONTACTTP Type: view_entity TRANSACTIONAL
16 Fields 1 Data Sources 5 Associations

Tr. Process. view for LCM Int. Contact

I_LCMCtxIntContactTP is a Transactional CDS View that provides data about "Tr. Process. view for LCM Int. Contact" in SAP S/4HANA. It reads from 1 data source (I_LCMCtxIntContact) and exposes 16 fields with key field LglCntntMCntxtIntCntctUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LCMCtxIntContact I_LCMCtxIntContact from

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_LglCntntMCstmIntCntctTypeTxt _LglCntntMCstmIntCntctTypeTxt $projection.LglCntntMIntCntctType = _LglCntntMCstmIntCntctTypeTxt.LglCntntMIntCntctType
[0..1] I_LglCntntMUserValueHelp _LCMUserValueHelp _LCMUserValueHelp.UserID = $projection.LglCntntMIntCntctUser
[0..1] I_LCMUserContactCard _CreatedByContactCard _CreatedByContactCard.ContactCardType = 'User' and _CreatedByContactCard.ContactCardID = $projection.LglCntntMIntCntctUser and _CreatedByContactCard.ContactCardRole = 'Creator'
[0..*] I_LglCntntMIntCntctUsrTypeText _LglCntntMIntCntctUsrTypeText $projection.LglCntntMIntContactUserType = _LglCntntMIntCntctUsrTypeText.LglCntntMIntContactUserType
[0..1] I_LglCntntMIntContactTeam _LglCntntMIntContactTeam $projection.LglCntntMIntContactTeam = _LglCntntMIntContactTeam.LglCntntMIntContactTeam

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Tr. Process. view for LCM Int. Contact view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMCntxtIntCntctUUID LglCntntMCntxtIntCntctUUID Universal Unique ID
LglCntntMContextUUID LglCntntMContextUUID Universal Unique ID
LglCntntMRank LglCntntMRank Seq No
LglCntntMIntCntctUser LglCntntMIntCntctUser User Name
LglCntntMIntContactTeam LglCntntMIntContactTeam Team Name
LglCntntMIntCntctType LglCntntMIntCntctType Contact Type
LglCntntMIntContactUserType LglCntntMIntContactUserType Assignment Type
LglCntntMIsMandatory LglCntntMIsMandatory Is Mandatory
LglCntntMIsIntegRelevant LglCntntMIsIntegRelevant Integrated
_LglCntntMContext _LglCntntMContext
_LCMContextTP _LCMContextTP
_LglCntntMCstmIntCntctTypeTxt _LglCntntMCstmIntCntctTypeTxt
_CreatedByContactCard _CreatedByContactCard
_LCMUserValueHelp _LCMUserValueHelp
_LglCntntMIntCntctUsrTypeText _LglCntntMIntCntctUsrTypeText
_LglCntntMIntContactTeam _LglCntntMIntContactTeam

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_LCMCtxIntContactTP.
-- 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_LCMCtxIntContactTP AS
SELECT
  LglCntntMCntxtIntCntctUUID,
  LglCntntMContextUUID,
  LglCntntMRank,
  LglCntntMIntCntctUser,
  LglCntntMIntContactTeam,
  LglCntntMIntCntctType,
  LglCntntMIntContactUserType,
  LglCntntMIsMandatory,
  LglCntntMIsIntegRelevant
FROM I_LCMCtxIntContact
LEFT OUTER JOIN I_LglCntntMCstmIntCntctTypeTxt AS _LglCntntMCstmIntCntctTypeTxt ON LglCntntMIntCntctType = _LglCntntMCstmIntCntctTypeTxt.LglCntntMIntCntctType  -- association [0..*]
LEFT OUTER JOIN I_LglCntntMUserValueHelp AS _LCMUserValueHelp ON _LCMUserValueHelp.UserID = LglCntntMIntCntctUser  -- association [0..1]
LEFT OUTER JOIN I_LCMUserContactCard AS _CreatedByContactCard ON _CreatedByContactCard.ContactCardType = 'User' AND _CreatedByContactCard.ContactCardID = LglCntntMIntCntctUser AND _CreatedByContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN I_LglCntntMIntCntctUsrTypeText AS _LglCntntMIntCntctUsrTypeText ON LglCntntMIntContactUserType = _LglCntntMIntCntctUsrTypeText.LglCntntMIntContactUserType  -- association [0..*]
LEFT OUTER JOIN I_LglCntntMIntContactTeam AS _LglCntntMIntContactTeam ON LglCntntMIntContactTeam = _LglCntntMIntContactTeam.LglCntntMIntContactTeam  -- association [0..1]
;

Learn More