C_LegalTransactionIntegFacet

DDL: C_LEGALTRANSACTIONINTEGFACET SQL: CLGLTRANSINTEGF Type: view CONSUMPTION

Legal Transaction Integration Facet

C_LegalTransactionIntegFacet is a Consumption CDS View that provides data about "Legal Transaction Integration Facet" in SAP S/4HANA. It reads from 2 data sources (I_LegalTransaction, I_LglCntntMIntegLinkdObj) and exposes 34 fields with key field LegalTransactionLinkdObjUUID. It has 9 associations to related views. It is exposed through 1 OData service (UI_PPS_PURCHASE_CONTRACT).

Data Sources (2)

SourceAliasJoin Type
I_LegalTransaction LegalTransaction from
I_LglCntntMIntegLinkdObj LinkedObject inner

Associations (9)

CardinalityTargetAliasCondition
[1..1] I_LegalTransactionAggr _LegalTransactionAggrgn $projection.LegalTransactionUUID = _LegalTransactionAggrgn.LegalTransactionUUID
[0..1] I_LCMUserContactCard _ChangedByContactCard _ChangedByContactCard.ContactCardType = 'User' and _ChangedByContactCard.ContactCardID = $projection.LglCntntMChangedByUser and _ChangedByContactCard.ContactCardRole = 'Creator'
[0..*] I_LegalTransactionHealthText _LegalTransactionHealthText $projection.LegalTransactionHealth = _LegalTransactionHealthText.LegalTransactionHealth
[0..1] C_LegalTransactionEntityMain _LegalTransactionEntityMain $projection.LegalTransactionUUID = _LegalTransactionEntityMain.LegalTransactionUUID
[0..*] I_LCMEntityTypeText _EntityTypeText $projection.lglcntntmentitytype = _EntityTypeText.LglCntntMEntityType
[0..1] I_Language _Language $projection.LglCntntMLanguage = _Language.Language
[0..1] C_LglCntntMGovLawVH _LCMGovLawVH $projection.LglCntntMGovLaw = _LCMGovLawVH.LglCntntMGovLaw
[1..1] I_LglTransToBeUpdated _LglTransToBeUpdated $projection.LegalTransaction = _LglTransToBeUpdated.LegalTransaction and $projection.LglCntntMLinkdObj = _LglTransToBeUpdated.LglCntntMLinkdObj
[1..1] E_LegalTransaction _LegalTransactionExtension $projection.LegalTransactionUUID = _LegalTransactionExtension.LegalTransactionUUID

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CLGLTRANSINTEGF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
EndUserText.label Legal Transaction Integration Facet view
Metadata.allowExtensions true view
ObjectModel.representativeKey LegalTransactionLinkdObjUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PPS_PURCHASE_CONTRACT UI_PPS_PURCHASE_CONTRACT_2 V2 C1 NOT_RELEASED

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY LegalTransactionLinkdObjUUID I_LglCntntMIntegLinkdObj LegalTransactionLinkdObjUUID
LegalTransactionUUID I_LglCntntMIntegLinkdObj LegalTransactionUUID
LegalTransaction I_LegalTransaction LegalTransaction Legal Transaction
LglCntntMEntityType _LegalTransactionEntityMain LglCntntMEntityType
LglCntntMEntity _LegalTransactionEntityMain LglCntntMEntity Main Entity
LglCntntMEntityName _LegalTransactionEntityMain LglCntntMEntityName
LglCntntMChangedByUser I_LegalTransaction LglCntntMChangedByUser
LglCntntMChangedUTCDateTime I_LegalTransaction LglCntntMChangedUTCDateTime Last Changed On
LegalTransactionTitle I_LegalTransaction LegalTransactionTitle
LglCntntMLinkdObj I_LglCntntMIntegLinkdObj LglCntntMLinkdObj
LglCntntMIntegrationLink I_LglCntntMIntegLinkdObj LglCntntMIntegrationLink
LegalTransactionHealth I_LegalTransaction LegalTransactionHealth Status
LglTransHealthCriticality _LegalTransactionAggrgn LglTransHealthCriticality
_ChangedByContactCard _ChangedByContactCard
LglCntntMLanguage I_LegalTransaction LglCntntMLanguage Language
LglCntntMGovLaw I_LegalTransaction LglCntntMGovLaw Governing Law
LglCntntMGovLawText _LCMGovLawVH LglCntntMGovLawText
LglCntntMMainOrgType I_LegalTransaction LglCntntMMainOrgType Main Organization Type
LglCntntMMainOrg _LegalTransactionAggrgn LglCntntMMainOrg Main Organization
LglCntntMMainOrgName
LglCntntMFromDate Start Date
LglCntntMToDate End Date
LegalTransactionIsTriggerObj I_LglCntntMIntegLinkdObj LegalTransactionIsTriggerObj
LglCntntMLglTransUpdtIsRqd _LglTransToBeUpdated LglCntntMLglTransUpdtIsRqd Update Required
_LegalTransactionHealthText _LegalTransactionHealthText
_EntityTypeText _EntityTypeText
IsEndOfPurposeBlocked I_LegalTransaction IsEndOfPurposeBlocked
LglCntntMProfile I_LegalTransaction LglCntntMProfile
LglTransAccessLvl I_LegalTransaction LglTransAccessLvl
LglCntntMMainOrgCoCode I_LegalTransaction LglCntntMMainOrgCoCode
LglCntntMMainOrgSalesOrg I_LegalTransaction LglCntntMMainOrgSalesOrg
LglCntntMMainOrgPurOrg I_LegalTransaction LglCntntMMainOrgPurOrg
_Language _Language
_LglCntntMMainOrgTypeText I_LegalTransaction _LglCntntMMainOrgTypeText
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CLGLTRANSINTEGF'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Legal Transaction Integration Facet'

@Metadata.allowExtensions: true

@ObjectModel: { semanticKey: ['LegalTransactionLinkdObjUUID'],
                representativeKey: 'LegalTransactionLinkdObjUUID',
                usageType.dataClass: #MIXED,
                usageType.serviceQuality:  #C,
                usageType.sizeCategory: #XL  }

@AccessControl.privilegedAssociations:  [ '_ChangedByContactCard' ]
@Metadata.ignorePropagatedAnnotations: true

/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define view C_LegalTransactionIntegFacet
  as select from I_LegalTransaction       as LegalTransaction
    inner join   I_LglCntntMIntegLinkdObj as LinkedObject on LegalTransaction.LegalTransactionUUID = LinkedObject.LegalTransactionUUID

  association [1..1] to I_LegalTransactionAggr       as _LegalTransactionAggrgn     on  $projection.LegalTransactionUUID = _LegalTransactionAggrgn.LegalTransactionUUID
  association [0..1] to I_LCMUserContactCard         as _ChangedByContactCard       on  _ChangedByContactCard.ContactCardType = 'User'
                                                                                    and _ChangedByContactCard.ContactCardID   = $projection.LglCntntMChangedByUser
                                                                                    and _ChangedByContactCard.ContactCardRole = 'Creator'
  association [0..*] to I_LegalTransactionHealthText as _LegalTransactionHealthText on  $projection.LegalTransactionHealth = _LegalTransactionHealthText.LegalTransactionHealth
  association [0..1] to C_LegalTransactionEntityMain as _LegalTransactionEntityMain on  $projection.LegalTransactionUUID = _LegalTransactionEntityMain.LegalTransactionUUID
  association [0..*] to I_LCMEntityTypeText          as _EntityTypeText             on  $projection.lglcntntmentitytype = _EntityTypeText.LglCntntMEntityType

  //language fix (dump on OData GET C_LegalTransactionIntegFacet)

  association [0..1] to I_Language                   as _Language                   on  $projection.LglCntntMLanguage = _Language.Language

  // Valuehelps

  association [0..1] to C_LglCntntMGovLawVH          as _LCMGovLawVH                on  $projection.LglCntntMGovLaw = _LCMGovLawVH.LglCntntMGovLaw

  association [1..1] to I_LglTransToBeUpdated        as _LglTransToBeUpdated        on  $projection.LegalTransaction  = _LglTransToBeUpdated.LegalTransaction
                                                                                    and $projection.LglCntntMLinkdObj = _LglTransToBeUpdated.LglCntntMLinkdObj
  //Extension

  association [1..1] to E_LegalTransaction           as _LegalTransactionExtension  on  $projection.LegalTransactionUUID = _LegalTransactionExtension.LegalTransactionUUID

{
      @UI.hidden: true
  key LinkedObject.LegalTransactionLinkdObjUUID,

      @UI.hidden: true
      LinkedObject.LegalTransactionUUID,

      @Consumption.semanticObject: 'LegalTransaction'
      @UI.lineItem: [{ position: 10, importance: #HIGH }]
      @ObjectModel.text.element:  [ 'LegalTransactionTitle' ]
      @EndUserText.label: 'Legal Transaction'
      LegalTransaction.LegalTransaction,

      @UI.lineItem: [{ position: 30, importance: #HIGH }]
      @UI.textArrangement: #TEXT_ONLY
      @ObjectModel: { text.association: '_EntityTypeText' }
      _LegalTransactionEntityMain.LglCntntMEntityType,

      @UI.lineItem: [{ position: 40, importance: #HIGH }]
      @ObjectModel.text.element:  [ 'LglCntntMEntityName' ]
      @EndUserText.label: 'Main Entity'
      @EndUserText.quickInfo: 'Main Entity'
      _LegalTransactionEntityMain.LglCntntMEntity,

      @UI.hidden: true
      @Semantics.text: true
      @ObjectModel.readOnly: true
      _LegalTransactionEntityMain.LglCntntMEntityName,

      @UI.hidden: true
      LegalTransaction.LglCntntMChangedByUser,

      @UI.lineItem: [{ position: 60 }]
      @Semantics.systemDate.lastChangedAt: true
      @EndUserText.label: 'Last Changed On'
      @EndUserText.quickInfo: 'Last Changed On'
      LegalTransaction.LglCntntMChangedUTCDateTime,

      @UI.hidden: true
      LegalTransaction.LegalTransactionTitle,

      @UI.hidden: true
      LinkedObject.LglCntntMLinkdObj                    as LglCntntMLinkdObj,

      @UI.hidden: true
      LinkedObject.LglCntntMIntegrationLink             as LglCntntMIntegrationLink,

      @UI.lineItem: [{ position: 70, criticality: 'LglTransHealthCriticality', criticalityRepresentation: #WITHOUT_ICON }]
      @UI.textArrangement: #TEXT_ONLY
      @ObjectModel: { text.association: '_LegalTransactionHealthText' }
      @EndUserText.label: 'Status' // 'Health'

      LegalTransaction.LegalTransactionHealth           as LegalTransactionHealth,

      @UI.hidden: true
      _LegalTransactionAggrgn.LglTransHealthCriticality as LglTransHealthCriticality,

      @UI.lineItem:[{value:'_ChangedByContactCard', position: 50, label: 'Last Changed By', type: #AS_CONTACT}]
      _ChangedByContactCard,

      @UI.lineItem: [{ position: 60 }]
      @UI.textArrangement: #TEXT_ONLY
      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.text: true
      @EndUserText.label: 'Language'
      LegalTransaction.LglCntntMLanguage,

      @UI.lineItem: [{ position: 65 }]
      @UI.textArrangement: #TEXT_FIRST
      @EndUserText.label: 'Governing Law'
      @ObjectModel.text.element: ['LglCntntMGovLawText']
      @Semantics.text: true
      @ObjectModel.readOnly: true
      LegalTransaction.LglCntntMGovLaw,

      @ObjectModel.readOnly: true
      @Semantics.text: true
      @Consumption.filter.hidden: true
      @UI.hidden: true
      _LCMGovLawVH.LglCntntMGovLawText                  as LglCntntMGovLawText,

      @ObjectModel.text.association: '_LglCntntMMainOrgTypeText'
      @UI.lineItem: [{ position: 50 }]
      @UI.textArrangement: #TEXT_ONLY
      @ObjectModel.readOnly: true
      @EndUserText.label: 'Main Organization Type'
      @EndUserText.quickInfo: 'Main Organization Type'
      LegalTransaction.LglCntntMMainOrgType,

      @UI.lineItem: [{ position: 55 }]
      @UI.textArrangement: #TEXT_FIRST
      @ObjectModel.text.element: [ 'LglCntntMMainOrgName' ]
      @ObjectModel.readOnly: true
      @EndUserText.label: 'Main Organization'
      @EndUserText.quickInfo: 'Main Organization'
      _LegalTransactionAggrgn.LglCntntMMainOrg,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_LCM_MAIN_ORG_CALC_EXIT'
      cast( '' as abap.char(25))                        as LglCntntMMainOrgName,

      @UI.lineItem: [{ position: 75 }]
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_LCM_LT_DATES_CALC_EXIT'
      @Semantics.businessDate.from: true
      @EndUserText.label: 'Start Date'
      @EndUserText.quickInfo: 'Start Date'
      cast( '' as lcm_valid_from )                      as LglCntntMFromDate,

      @UI.lineItem: [{ position: 80 }]
      @ObjectModel.readOnly: true
      @ObjectModel.virtualElement: true
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_LCM_LT_DATES_CALC_EXIT'
      @Semantics.businessDate.to: true
      @EndUserText.label: 'End Date'
      @EndUserText.quickInfo: 'End Date'
      cast( '' as lcm_valid_to )                        as LglCntntMToDate,

      @UI.lineItem: [{ position: 85 }]
      @Semantics.booleanIndicator: true
      LinkedObject.LegalTransactionIsTriggerObj         as LegalTransactionIsTriggerObj,

      @UI.lineItem: [{ position: 90}]
      @ObjectModel.readOnly: true
      @EndUserText.label: 'Update Required'
      @EndUserText.quickInfo: 'Update Required'
      @Semantics.booleanIndicator: true
      _LglTransToBeUpdated.LglCntntMLglTransUpdtIsRqd,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      @Consumption.filter.hidden:true
      _LegalTransactionHealthText,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      @Consumption.filter.hidden:true
      _EntityTypeText,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      @Semantics.booleanIndicator: true
      LegalTransaction.IsEndOfPurposeBlocked,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      LegalTransaction.LglCntntMProfile,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      LegalTransaction.LglTransAccessLvl,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      LegalTransaction.LglCntntMMainOrgCoCode,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      LegalTransaction.LglCntntMMainOrgSalesOrg,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      LegalTransaction.LglCntntMMainOrgPurOrg,

      //      @UI.hidden: true

      //      @ObjectModel.readOnly: true

      //      @Consumption.filter.hidden:true

      //      _LanguageText,


      _Language,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      @Consumption.filter.hidden:true
      LegalTransaction._LglCntntMMainOrgTypeText

      //      @Consumption.filter.hidden: true

      //      _LegalDocumentIntegFacet

}
where
  LglCntntMLinkdObj <> ''