I_LegalTransactionExtContactTP

DDL: I_LEGALTRANSACTIONEXTCONTACTTP SQL: ILGLTREXTCONTTP Type: view TRANSACTIONAL

TP View for LCM LT External Contact

I_LegalTransactionExtContactTP is a Transactional CDS View that provides data about "TP View for LCM LT External Contact" in SAP S/4HANA. It reads from 1 data source (I_LegalTransactionExtContact) and exposes 13 fields with key field LegalTransactionExtCntctUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_LegalTransactionExtContact I_LegalTransactionExtContact from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_LegalTransactionTP _LegalTransactionTP $projection.LegalTransactionUUID = _LegalTransactionTP.LegalTransactionUUID
[0..1] I_LCMExtContactTypeText _LCMExtContactTypeText $projection.LglCntntMExtCntctType = _LCMExtContactTypeText.LglCntntMExtCntctType and _LCMExtContactTypeText.Language = $session.system_language

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName ILGLTREXTCONTTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label TP View for LCM LT External Contact view
VDM.viewType #TRANSACTIONAL view
ObjectModel.representativeKey LegalTransactionExtCntctUUID view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled EXTERNAL_CALCULATION view
ObjectModel.writeActivePersistence LCM_LT_EXTCONT view
ObjectModel.writeDraftPersistence LCM_LT_EXTCONT_D view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionExtCntctUUID I_LegalTransactionExtContact LegalTransactionExtCntctUUID
LglCntntMRank I_LegalTransactionExtContact LglCntntMRank
LglCntntMExtCntctBP I_LegalTransactionExtContact LglCntntMExtCntctBP
LglCntntMExtCntctType I_LegalTransactionExtContact LglCntntMExtCntctType
LegalTransactionUUID I_LegalTransactionExtContact LegalTransactionUUID
LegalTransactionMandatoryFlag I_LegalTransactionExtContact LegalTransactionMandatoryFlag
LglCntntMIsIntegRelevant LglCntntMIsIntegRelevant
LglCntntMIsAddedByIntegVarbl LglCntntMIsAddedByIntegVarbl
LglCntntMExtCntctBPName _BusinessPartner BusinessPartnerFullName
_LCMExtContactTypeText _LCMExtContactTypeText
_LegalTransaction _LegalTransaction
_LegalTransactionTP _LegalTransactionTP
_BusinessPartner _BusinessPartner
@AbapCatalog.sqlViewName: 'ILGLTREXTCONTTP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'TP View for LCM LT External Contact'

@VDM.viewType : #TRANSACTIONAL

@ObjectModel: {
  representativeKey: 'LegalTransactionExtCntctUUID',
  semanticKey:  [ 'LegalTransactionExtCntctUUID' ] ,

  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: 'EXTERNAL_CALCULATION',

  writeActivePersistence: 'LCM_LT_EXTCONT',
  writeDraftPersistence: 'LCM_LT_EXTCONT_D',

  usageType.serviceQuality: #A,
  usageType.sizeCategory: #L,
  usageType.dataClass: #TRANSACTIONAL
}
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_LegalTransactionExtContactTP
  as select from I_LegalTransactionExtContact
  association [1..1] to I_LegalTransactionTP    as _LegalTransactionTP    on  $projection.LegalTransactionUUID = _LegalTransactionTP.LegalTransactionUUID
  association [0..1] to I_LCMExtContactTypeText as _LCMExtContactTypeText on  $projection.LglCntntMExtCntctType = _LCMExtContactTypeText.LglCntntMExtCntctType
                                                                          and _LCMExtContactTypeText.Language   = $session.system_language
{
  key I_LegalTransactionExtContact.LegalTransactionExtCntctUUID,
      //@ObjectModel.readOnly: true

      I_LegalTransactionExtContact.LglCntntMRank,

      @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
      I_LegalTransactionExtContact.LglCntntMExtCntctBP,

      @ObjectModel: {
            readOnly: 'EXTERNAL_CALCULATION',
            mandatory: true
        }
      I_LegalTransactionExtContact.LglCntntMExtCntctType,

      @ObjectModel.mandatory: true
      I_LegalTransactionExtContact.LegalTransactionUUID,

      //@ObjectModel.readOnly: true

      I_LegalTransactionExtContact.LegalTransactionMandatoryFlag,

      LglCntntMIsIntegRelevant,

      LglCntntMIsAddedByIntegVarbl,

      //      concat_with_space( _BusinessPartner.FirstName, _BusinessPartner.LastName, 1 ) as LglCntntMExtCntctBPName,

      _BusinessPartner.BusinessPartnerFullName as LglCntntMExtCntctBPName,

      _LCMExtContactTypeText,
      _LegalTransaction,

      @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _LegalTransactionTP,
      _BusinessPartner
}