P_CABusLockForContrAcct

DDL: P_CABUSLOCKFORCONTRACCT Type: view_entity COMPOSITE

Business Lock for a Contract Account

P_CABusLockForContrAcct is a Composite CDS View that provides data about "Business Lock for a Contract Account" in SAP S/4HANA. It reads from 2 data sources (I_CADocumentBPItem, 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_CADocumentBPItem _BPItem from
I_CABusinessLockEnhanced _Lock inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Lock for a Contract Account 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_CADocumentBPItem BusinessPartner
KEY ContractAccount I_CADocumentBPItem ContractAccount
KEY CAContract I_CADocumentBPItem CAContract
KEY CAProviderContractItemCharUUID I_CABusinessLockEnhanced CAProviderContractItemCharUUID
KEY CADocumentNumber I_CADocumentBPItem CADocumentNumber
KEY CARepetitionItemNumber I_CADocumentBPItem CARepetitionItemNumber
KEY CABPItemNumber I_CADocumentBPItem CABPItemNumber
KEY CASubItemNumber I_CADocumentBPItem CASubItemNumber
LastChangedByUser I_CABusinessLockEnhanced LastChangedByUser
LastChangeDate I_CABusinessLockEnhanced LastChangeDate
LastChangeTime I_CABusinessLockEnhanced LastChangeTime
CompanyCode I_CADocumentBPItem CompanyCode
CADocumentOriginCode I_CADocumentBPItem CADocumentOriginCode
BusinessArea I_CADocumentBPItem BusinessArea
Segment I_CADocumentBPItem Segment
CASubApplication I_CADocumentBPItem CASubApplication
_BusLockObjCategory I_CABusinessLockEnhanced _BusLockObjCategory
_BusinessProcess I_CABusinessLockEnhanced _BusinessProcess
_BusinessLockReason I_CABusinessLockEnhanced _BusinessLockReason
_CAPartner I_CADocumentBPItem _CAPartner
_ProviderContract I_CADocumentBPItem _ProviderContract
_BusinessPartner I_CADocumentBPItem _BusinessPartner 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business Lock for a Contract Account'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}

@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_CABusLockForContrAcct
  as select from I_CADocumentBPItem as _BPItem
    inner join   I_CABusinessLockEnhanced  as _Lock on  _Lock.CABusinessLockObjectCategory = '06'
                                                    and _Lock.BusinessPartner              = _BPItem.BusinessPartner
                                                    and _Lock.ContractAccount              = _BPItem.ContractAccount
{
  key _Lock.CABusinessLockObjectCategory,
  key _Lock.CABusinessProcess,
  key _Lock.CABusinessLockReason,
  key _Lock.CABusinessLockValidFrom,
  key _Lock.CABusinessLockValidTo,
  key _BPItem.BusinessPartner,
  key _BPItem.ContractAccount,
  key _BPItem.CAContract,
  key _Lock.CAProviderContractItemCharUUID,
  key _BPItem.CADocumentNumber,
  key _BPItem.CARepetitionItemNumber,
  key _BPItem.CABPItemNumber,
  key _BPItem.CASubItemNumber,
      _Lock.LastChangedByUser,
      _Lock.LastChangeDate,
      _Lock.LastChangeTime,
      
      _BPItem.CompanyCode,
      _BPItem.CADocumentOriginCode,
      _BPItem.BusinessArea,
      _BPItem.Segment,
      _BPItem.CASubApplication,
      
      _Lock._BusLockObjCategory,
      _Lock._BusinessProcess,
      _Lock._BusinessLockReason,
      
      _BPItem._CAPartner,
      _BPItem._ProviderContract,
      _BPItem._BusinessPartner
      
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CABUSINESSLOCKENHANCED",
"I_CADOCUMENTBPITEM"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CABUSINESSLOCKOBJCATEGORY",
"I_CABUSINESSLOCKREASON",
"I_CABUSINESSPROCESS",
"I_CAPROVIDERCONTRACTHEADER",
"I_CONTRACTACCOUNTPARTNER"
],
"BASE":
[
"I_CABUSINESSLOCKENHANCED",
"I_CADOCUMENTBPITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More