I_LegalTransaction

@AbapCatalog.sqlViewName: 'ILEGALTR'
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType : #BASIC

@ObjectModel: {
  representativeKey: 'LegalTransactionUUID',
  usageType.serviceQuality: #B,
  usageType.sizeCategory: #XL,
  usageType.dataClass: #TRANSACTIONAL
}

@AccessControl.personalData.blocking: #REQUIRED
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@AccessControl.privilegedAssociations:  [ '_CreatedBy', '_ChangedBy' ]

@EndUserText.label: 'Basic View for LCM Legal Transaction'
define view I_LegalTransaction
  as select from lcm_legaltr

  association [0..1] to Sgbt_Nte_Cds_Cont            as _Note                       on  _Note.noteid         = $projection.LglCntntMLongTextUUID
                                                                                    and _Note.objectnodetype = 'LegalTransaction'
                                                                                    and _Note.notetype       = 'LCM_LONGTEXT'
  //Extension

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

  // ESH associations

  association [1..1] to I_LglCntntMContextBasic      as _Context                    on  $projection.LglCntntMContextUUID = _Context.LglCntntMContextUUID

  association [1..1] to I_LegalTransactionEntity     as _MainLegalTransactionEntity on  $projection.LegalTransactionUUID                  = _MainLegalTransactionEntity.LegalTransactionUUID
                                                                                    and _MainLegalTransactionEntity.LglCntntMIsMainEntity = 'X'

  association [1..*] to I_LegalTransactionEntity     as _LegalTransactionEntity     on  $projection.LegalTransactionUUID = _LegalTransactionEntity.LegalTransactionUUID

  association [1..*] to I_LegalTrParentCategory      as _LegalTrParentCategory      on  $projection.LegalTransactionUUID = _LegalTrParentCategory.LegalTransactionUUID

  association [1..*] to I_LegalTransactionCategory   as _LegalTransactionCategory   on  $projection.LegalTransactionUUID = _LegalTransactionCategory.LegalTransactionUUID

  association [0..*] to I_LegalTrLinkedObjects       as _LegalTrLinkedObjects       on  $projection.LegalTransactionUUID = _LegalTrLinkedObjects.LegalTransactionUUID

  association [0..*] to I_LegalTrRelationship        as _LegalTrRelationship        on  $projection.LegalTransactionUUID = _LegalTrRelationship.LegalTransactionUUID

  association [0..*] to I_LegalTransactionIntContact as _LegalTransactionIntContact on  $projection.LegalTransactionUUID = _LegalTransactionIntContact.LegalTransactionUUID

  association [0..1] to I_LglCntntMMainOrgTypeText   as _LglCntntMMainOrgTypeText   on  $projection.LglCntntMMainOrgType   = _LglCntntMMainOrgTypeText.LglCntntMMainOrgType
                                                                                    and _LglCntntMMainOrgTypeText.Language = $session.system_language

  association [0..1] to I_PurchasingOrganization     as _PurchasingOrganization     on  $projection.LglCntntMMainOrgPurOrg = _PurchasingOrganization.PurchasingOrganization

  association [0..1] to I_SalesOrganizationText      as _SalesOrganizationText      on  $projection.LglCntntMMainOrgSalesOrg = _SalesOrganizationText.SalesOrganization
                                                                                    and _SalesOrganizationText.Language      = $session.system_language

  association [0..1] to I_CompanyCode                as _CompanyCode                on  $projection.LglCntntMMainOrgCoCode = _CompanyCode.CompanyCode

  association [0..1] to I_LegalTransactionHealthText as _LegalTransactionHealthText on  $projection.LegalTransactionHealth   = _LegalTransactionHealthText.LegalTransactionHealth
                                                                                    and _LegalTransactionHealthText.Language = $session.system_language

  association [0..1] to I_LanguageText               as _LanguageText               on  $projection.LglCntntMLanguage = _LanguageText.LanguageCode
                                                                                    and _LanguageText.Language        = $session.system_language

  association [0..1] to I_LglCntntMAccessLvlText     as _LglCntntMAccessLvlText     on  $projection.LglTransAccessLvl    = _LglCntntMAccessLvlText.LglCntntMAccessLvl
                                                                                    and _LglCntntMAccessLvlText.Language = $session.system_language

  association [0..1] to I_LCMUserAddressAssignment   as _CreatedBy                  on  $projection.LglCntntMCreatedByUser = _CreatedBy.ContactCardID

  association [0..1] to I_LCMUserAddressAssignment   as _ChangedBy                  on  $projection.LglCntntMChangedByUser = _ChangedBy.ContactCardID

  association [0..1] to I_LglCntntMGovLawText        as _LglCntntMGovLawText        on  $projection.LglCntntMGovLaw   = _LglCntntMGovLawText.LglCntntMGovLaw
                                                                                    and _LglCntntMGovLawText.Language = $session.system_language
  association [0..1] to I_LglCntntMIntegTypeText     as _LglCntntMIntegTypeText     on  $projection.LglCntntMIntegrationType = _LglCntntMIntegTypeText.LglCntntMIntegrationType
                                                                                    and Language                             = $session.system_language

{
      @Consumption.filter.hidden : true
  key legaltransactionuuid          as LegalTransactionUUID,

      legaltransaction              as LegalTransaction,

      @Semantics.text: true
      legaltransactiontitle         as LegalTransactionTitle,

      legaltransactionhealth        as LegalTransactionHealth,
      lglcntntmlanguage             as LglCntntMLanguage,
      lglcntntmcreatedbyuser        as LglCntntMCreatedByUser,

      @Consumption.filter.hidden : true
      lglcntntmcontextuuid          as LglCntntMContextUUID,
      @Consumption.filter.hidden : true
      lgltranswrkflwmodinstce       as LglTransWrkFlwModInstce,
      //      @Consumption.filter.hidden : true

      lglcntntmcreatedutcdatetime   as LglCntntMCreatedUTCDateTime,
      lglcntntmchangedbyuser        as LglCntntMChangedByUser,
      //      @Consumption.filter.hidden : true

      lglcntntmchangedutcdatetime   as LglCntntMChangedUTCDateTime,

      lglcntntmprofile              as LglCntntMProfile,
      //      @Consumption.filter.hidden: true

      legaltransactionsource        as LegalTransactionSource,
      @Consumption.filter.hidden: true
      @Semantics.booleanIndicator: true
      isendofpurposeblocked         as IsEndOfPurposeBlocked,

      @Consumption.filter.hidden : true
      _dataaging                    as LglCntntMAgingTemperature,
      lglcntntmrtntnperdstartdate   as LglCntntMRtntnPerdStartDate,

      lglcntntmgovlaw               as LglCntntMGovLaw,

      lgltransaccesslvl             as LglTransAccessLvl,

      lglcntntmmainorgtype          as LglCntntMMainOrgType,

      lglcntntmmainorgcocode        as LglCntntMMainOrgCoCode,

      lglcntntmmainorgsalesorg      as LglCntntMMainOrgSalesOrg,

      lglcntntmmainorgpurorg        as LglCntntMMainOrgPurOrg,
      @Consumption.filter.hidden : true
      lglcntntmlongtextuuid         as LglCntntMLongTextUUID,

      lglcntntmintegrationtype      as LglCntntMIntegrationType,

      //copiedfromlegaltransactionuuid                                            as  CopiedFromLegalTransactionUUID,


      lglcntntmcrtedfrmlgltransuuid as LglCntntMCrtedFrmLglTransUUID,

      _Note.content                 as LglCntntMLongText,
      _Note.mimetype                as LglCntntMLongTextMimeType,

      _Context,

      _MainLegalTransactionEntity,

      _LegalTransactionEntity,

      _LegalTrParentCategory,

      _LegalTransactionCategory,

      _LegalTrLinkedObjects,

      _LegalTrRelationship,

      _LegalTransactionIntContact,

      _LglCntntMMainOrgTypeText,

      _PurchasingOrganization,

      _SalesOrganizationText,

      _CompanyCode,

      _LegalTransactionHealthText,

      _LanguageText,

      _LglCntntMAccessLvlText,

      _CreatedBy,

      _ChangedBy,

      _LglCntntMGovLawText,

      _LglCntntMIntegTypeText

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"SGBT_NTE_CDS_CONT",
"LCM_LEGALTR"
],
"ASSOCIATED":
[
"E_LEGALTRANSACTION",
"I_COMPANYCODE",
"I_LANGUAGETEXT",
"I_LCMUSERADDRESSASSIGNMENT",
"I_LEGALTRANSACTIONCATEGORY",
"I_LEGALTRANSACTIONENTITY",
"I_LEGALTRANSACTIONHEALTHTEXT",
"I_LEGALTRANSACTIONINTCONTACT",
"I_LEGALTRLINKEDOBJECTS",
"I_LEGALTRPARENTCATEGORY",
"I_LEGALTRRELATIONSHIP",
"I_LGLCNTNTMACCESSLVLTEXT",
"I_LGLCNTNTMCONTEXTBASIC",
"I_LGLCNTNTMGOVLAWTEXT",
"I_LGLCNTNTMINTEGTYPETEXT",
"I_LGLCNTNTMMAINORGTYPETEXT",
"I_PURCHASINGORGANIZATION",
"I_SALESORGANIZATIONTEXT",
"SGBT_NTE_CDS_CONT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/