C_LegalTransactionExtContact

DDL: C_LEGALTRANSACTIONEXTCONTACT SQL: CLEGTRANSEXTC Type: view CONSUMPTION

Legal Transaction External Contacts

C_LegalTransactionExtContact is a Consumption CDS View that provides data about "Legal Transaction External Contacts" in SAP S/4HANA. It reads from 1 data source (I_LegalTransactionExtContact) and exposes 14 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
[0..1] C_LCMExtContactTypeValueHelp _LCMExtContactTypeValueHelp $projection.LglCntntMExtCntctType = _LCMExtContactTypeValueHelp.LglCntntMExtCntctType
[0..1] C_LCMExtContactDetailsVH _LCMExtContactDetailsVH _LCMExtContactDetailsVH.BusinessPartner = $projection.LglCntntMExtCntctBP and _LCMExtContactDetailsVH.LglCntntMExtCntctBPName = $projection.LglCntntMExtCntctBPName

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CLEGTRANSEXTC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.semanticKey LglCntntMExtCntctBp view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Legal Transaction External Contacts view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionExtCntctUUID LegalTransactionExtCntctUUID
LglCntntMRank LglCntntMRank Rank
LglCntntMExtCntctType LglCntntMExtCntctType Contact Type
LglCntntMExtCntctTypeName _LCMExtContactTypeValueHelp LglCntntMExtCntctTypeName
LglCntntMExtCntctBP LglCntntMExtCntctBP Name
LglCntntMExtCntctBPName
LegalTransactionMandatoryFlag LegalTransactionMandatoryFlag
LglCntntMEntityData
LglCntntMIsMandatory Required
LegalTransactionUUID LegalTransactionUUID
_LCMExtContactTypeValueHelp _LCMExtContactTypeValueHelp
_LCMExtContactDetailsVH _LCMExtContactDetailsVH
_LegalTransaction _LegalTransaction
_BusinessPartner _BusinessPartner
@AbapCatalog.sqlViewName: 'CLEGTRANSEXTC'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: { createEnabled,
                updateEnabled,
                deleteEnabled,
                semanticKey: 'LglCntntMExtCntctBp',
                usageType.dataClass: #MIXED,
                usageType.serviceQuality: #C,
                usageType.sizeCategory: #L
                }

@VDM.viewType: #CONSUMPTION

@Metadata.ignorePropagatedAnnotations: true

@AccessControl: { authorizationCheck:    #CHECK,
                  personalData.blocking: #NOT_REQUIRED }

@EndUserText.label: 'Legal Transaction External Contacts'
define view C_LegalTransactionExtContact 
  as select from I_LegalTransactionExtContact


  association [0..1] to C_LCMExtContactTypeValueHelp as _LCMExtContactTypeValueHelp on  $projection.LglCntntMExtCntctType = _LCMExtContactTypeValueHelp.LglCntntMExtCntctType

  //Value Help

  //association [0..1] to C_LCMContactsVH              as _LCMContactsVH              on _LCMContactsVH.BusinessPartner = $projection.LglCntntMExtCntctBp//


  association [0..1] to C_LCMExtContactDetailsVH     as _LCMExtContactDetailsVH     on  _LCMExtContactDetailsVH.BusinessPartner         = $projection.LglCntntMExtCntctBP
                                                                                    and _LCMExtContactDetailsVH.LglCntntMExtCntctBPName = $projection.LglCntntMExtCntctBPName
{

      @UI.hidden: true
  key LegalTransactionExtCntctUUID,

      @EndUserText.label: 'Rank'
      @EndUserText.quickInfo: 'Rank'
      LglCntntMRank,


      @ObjectModel.mandatory: true
      @ObjectModel: { text.element: 'LglCntntMExtCntctTypeName' }
      @Consumption.valueHelp: '_LCMExtContactTypeValueHelp'
      @UI.textArrangement: #TEXT_ONLY
      @EndUserText.label: 'Contact Type'
      LglCntntMExtCntctType,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      @Semantics.text: true
      _LCMExtContactTypeValueHelp.LglCntntMExtCntctTypeName                         as LglCntntMExtCntctTypeName,

      //      @UI: {

      //             identification: {position: 30, importance: #HIGH, label: 'Name'},

      //             lineItem: {position: 30, importance: #HIGH,label:'Name'}

      //             }

      //    @Consumption.valueHelp: '_LCMExtContactDetailsVH'


      @Consumption.valueHelpDefinition: [{

                   entity: {
                     name: 'C_LglCntntMExtContactByBPVH',
                     element: 'BusinessPartnerPerson'
                   }
//                   qualifier: 'EntityVH'


               },
               {
                   entity: {
                       name: 'C_LglCntntMExtCntctByEntityVH',
                       element: 'BusinessPartnerPerson'
                   },
                   qualifier: 'EntityVH',
                   additionalBinding: [{

                           localElement: 'LglCntntMEntityData',
                           element: 'LglCntntMEntityData'
                     }]

              }]
      @ObjectModel.text.element: [ 'LglCntntMExtCntctBPName' ]
      @UI.textArrangement: #TEXT_FIRST
      @EndUserText.label: 'Name'
      LglCntntMExtCntctBP,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      @Semantics.text: true
      concat_with_space( _BusinessPartner.FirstName, _BusinessPartner.LastName, 1 ) as LglCntntMExtCntctBPName,
      //      _LCMExtContactDetailsVH.LglCntntMExtCntctBPName,


      @UI.hidden: true
      LegalTransactionMandatoryFlag,

      @UI.hidden: true
      cast ( '' as lcm_entity_identifier )                                         as  LglCntntMEntityData,


      @EndUserText.label: 'Required'
      //cast( LegalTransactionMandatoryFlag as lcm_lt_mandatory_ctrl_to_bool preserving type )  as LglCntntMIsMandatory,

      cast ( '' as lcm_is_mandatory preserving type )                               as LglCntntMIsMandatory,

      @UI.hidden: true
      LegalTransactionUUID,


      _LCMExtContactTypeValueHelp,

      _LCMExtContactDetailsVH,

      _LegalTransaction,
      
      _BusinessPartner
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_LCMEXTCONTACTTYPEVALUEHELP",
"I_BUSINESSPARTNER",
"I_LEGALTRANSACTIONEXTCONTACT"
],
"ASSOCIATED":
[
"C_LCMEXTCONTACTDETAILSVH",
"C_LCMEXTCONTACTTYPEVALUEHELP",
"I_BUSINESSPARTNER",
"I_LEGALTRANSACTION"
],
"BASE":
[
"I_LEGALTRANSACTIONEXTCONTACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/