P_CABusLockForContract

DDL: P_CABUSLOCKFORCONTRACT Type: view_entity COMPOSITE

Business Lock for a CA Contract

P_CABusLockForContract is a Composite CDS View that provides data about "Business Lock for a CA Contract" in SAP S/4HANA. It reads from 2 data sources (I_CADocumentBPItemUI, I_CABusinessLockEnhanced) and exposes 27 fields with key fields CABusinessLockObjectCategory, CABusinessProcess, CABusinessLockReason, CABusinessLockValidFrom, CABusinessLockValidTo.

2 data source(s) 27 fields

Data Sources (2)

SourceAliasJoin Type
I_CADocumentBPItemUI _Item from
I_CABusinessLockEnhanced _Lock inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Lock for a CA Contract view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY CABusinessLockObjectCategory I_CABusinessLockEnhanced CABusinessLockObjectCategory
KEY CABusinessProcess I_CABusinessLockEnhanced CABusinessProcess
KEY CABusinessLockReason I_CABusinessLockEnhanced CABusinessLockReason
KEY CABusinessLockValidFrom I_CABusinessLockEnhanced CABusinessLockValidFrom
KEY CABusinessLockValidTo I_CABusinessLockEnhanced CABusinessLockValidTo
KEY BusinessPartner I_CADocumentBPItemUI BusinessPartner
KEY ContractAccount I_CADocumentBPItemUI ContractAccount
KEY CAContract I_CADocumentBPItemUI CAContract
KEY CAProviderContractItemCharUUID I_CADocumentBPItemUI CAProviderContractItemCharUUID
KEY CADocumentNumber I_CADocumentBPItemUI CADocumentNumber
KEY CARepetitionItemNumber I_CADocumentBPItemUI CARepetitionItemNumber
KEY CABPItemNumber I_CADocumentBPItemUI CABPItemNumber
KEY CASubItemNumber I_CADocumentBPItemUI CASubItemNumber
LastChangedByUser I_CABusinessLockEnhanced LastChangedByUser
LastChangeDate I_CABusinessLockEnhanced LastChangeDate
LastChangeTime I_CABusinessLockEnhanced LastChangeTime
_BusLockObjCategory I_CABusinessLockEnhanced _BusLockObjCategory
_BusinessProcess I_CABusinessLockEnhanced _BusinessProcess
_BusinessLockReason I_CABusinessLockEnhanced _BusinessLockReason
CompanyCode I_CADocumentBPItemUI CompanyCode
CADocumentOriginCode I_CADocumentBPItemUI CADocumentOriginCode
BusinessArea I_CADocumentBPItemUI BusinessArea
Segment I_CADocumentBPItemUI Segment
CASubApplication I_CADocumentBPItemUI CASubApplication
_CAPartner I_CADocumentBPItemUI _CAPartner
_ProviderContract I_CADocumentBPItemUI _ProviderContract
_BusinessPartner I_CADocumentBPItemUI _BusinessPartner 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business Lock for a CA Contract'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}

@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_CABusLockForContract as select from I_CADocumentBPItemUI as _Item
 inner join   I_CABusinessLockEnhanced     as _Lock on  _Lock.CABusinessLockObjectCategory = '24'
                                                       and _Lock.CAContract                   = _Item.CAContract
                                                       and _Lock.CAProviderContractItemUUID   = _Item.CAProviderContractItemUUID
{

  key _Lock.CABusinessLockObjectCategory,
  key _Lock.CABusinessProcess,
  key _Lock.CABusinessLockReason,
  key _Lock.CABusinessLockValidFrom,
  key _Lock.CABusinessLockValidTo,
  key _Item.BusinessPartner,
  key _Item.ContractAccount,
  key _Item.CAContract,
  key _Item.CAProviderContractItemCharUUID,
  key _Item.CADocumentNumber,
  key _Item.CARepetitionItemNumber,
  key _Item.CABPItemNumber,
  key _Item.CASubItemNumber,
      _Lock.LastChangedByUser,
      _Lock.LastChangeDate,
      _Lock.LastChangeTime,
      _Lock._BusLockObjCategory,
      _Lock._BusinessProcess,
      _Lock._BusinessLockReason,
      
      _Item.CompanyCode,
      _Item.CADocumentOriginCode,
      _Item.BusinessArea,
      _Item.Segment,
      _Item.CASubApplication,
      
      _Item._CAPartner,
      _Item._ProviderContract,
      _Item._BusinessPartner
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CABUSINESSLOCKENHANCED",
"I_CADOCUMENTBPITEMUI"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CABUSINESSLOCKOBJCATEGORY",
"I_CABUSINESSLOCKREASON",
"I_CABUSINESSPROCESS",
"I_CAPROVIDERCONTRACTHEADER",
"I_CONTRACTACCOUNTPARTNER"
],
"BASE":
[
"I_CABUSINESSLOCKENHANCED",
"I_CADOCUMENTBPITEMUI"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More