P_CABusLockForContrAcct

DDL: P_CABUSLOCKFORCONTRACCT Type: view_entity COMPOSITE Package: ODATA_O2C_FICA_DOCUMENT_MANAGE

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_CABusinessLockEnhanced, I_CADocumentBPItem) and exposes 28 fields with key fields CABusinessLockObjectCategory, CABusinessProcess, CABusinessLockReason, CABusinessLockValidFrom, CABusinessLockValidTo. Part of development package ODATA_O2C_FICA_DOCUMENT_MANAGE.

Data Sources (2)

SourceAliasJoin Type
I_CABusinessLockEnhanced BusLock inner
I_CADocumentBPItem DocBPItem from

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 (28)

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
_CABusinessLockObjCategory I_CABusinessLockEnhanced _CABusinessLockObjCategory
_CABusinessLockReason I_CABusinessLockEnhanced _CABusinessLockReason
_CABusinessProcess I_CABusinessLockEnhanced _CABusinessProcess
_BusinessPartner I_CADocumentBPItem _BusinessPartner
_CAProviderContract I_CADocumentBPItem _CAProviderContract
_ContractAccount I_CADocumentBPItem _ContractAccount
_ContractAccountPartner I_CADocumentBPItem _ContractAccountPartner
@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 DocBPItem
    inner join   I_CABusinessLockEnhanced  as BusLock on  BusLock.CABusinessLockObjectCategory = '06'
                                                    and BusLock.BusinessPartner              = DocBPItem.BusinessPartner
                                                    and BusLock.ContractAccount              = DocBPItem.ContractAccount
{
  key BusLock.CABusinessLockObjectCategory,
  key BusLock.CABusinessProcess,
  key BusLock.CABusinessLockReason,
  key BusLock.CABusinessLockValidFrom,
  key BusLock.CABusinessLockValidTo,
  key DocBPItem.BusinessPartner,
  key DocBPItem.ContractAccount,
  key DocBPItem.CAContract,
  key BusLock.CAProviderContractItemCharUUID,
  key DocBPItem.CADocumentNumber,
  key DocBPItem.CARepetitionItemNumber,
  key DocBPItem.CABPItemNumber,
  key DocBPItem.CASubItemNumber,
      
      BusLock.LastChangedByUser,
      BusLock.LastChangeDate,
      BusLock.LastChangeTime,
      
      DocBPItem.CompanyCode,
      DocBPItem.CADocumentOriginCode,
      DocBPItem.BusinessArea,
      DocBPItem.Segment,
      DocBPItem.CASubApplication,
      
      /* associations */
      BusLock._CABusinessLockObjCategory,
      BusLock._CABusinessLockReason,
      BusLock._CABusinessProcess,
      
      DocBPItem._BusinessPartner,
      DocBPItem._CAProviderContract,
      DocBPItem._ContractAccount,
      DocBPItem._ContractAccountPartner
}