P_CABusLockForContract

DDL: P_CABUSLOCKFORCONTRACT Type: view_entity COMPOSITE Package: ODATA_O2C_FICA_DOCUMENT_MANAGE

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

2 data source(s) 27 fields

Data Sources (2)

SourceAliasJoin Type
I_CABusinessLockEnhanced BusLock inner
I_CADocumentBPItemUI DocBPItem from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
VDM.private true view
VDM.viewType #COMPOSITE 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
CompanyCode I_CADocumentBPItemUI CompanyCode
CADocumentOriginCode I_CADocumentBPItemUI CADocumentOriginCode
BusinessArea I_CADocumentBPItemUI BusinessArea
Segment I_CADocumentBPItemUI Segment
CASubApplication I_CADocumentBPItemUI CASubApplication
_CABusinessLockObjCategory I_CABusinessLockEnhanced _CABusinessLockObjCategory
_CABusinessLockReason I_CABusinessLockEnhanced _CABusinessLockReason
_CABusinessProcess I_CABusinessLockEnhanced _CABusinessProcess
_BusinessPartner I_CADocumentBPItemUI _BusinessPartner
_CAProviderContract I_CADocumentBPItemUI _ProviderContract
_ContractAccountPartner I_CADocumentBPItemUI _CAPartner 
@AbapCatalog.viewEnhancementCategory: [#NONE]

@AccessControl.authorizationCheck: #NOT_REQUIRED

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType:{ dataClass: #TRANSACTIONAL,
                         serviceQuality: #C,
                         sizeCategory: #XXL }

@VDM: { private: true,
        viewType: #COMPOSITE }

define view entity P_CABusLockForContract
  as select from I_CADocumentBPItemUI     as DocBPItem
    inner join   I_CABusinessLockEnhanced as BusLock on  BusLock.CABusinessLockObjectCategory = '24'
                                                     and BusLock.CAContract                   = DocBPItem.CAContract
                                                     and BusLock.CAProviderContractItemUUID   = DocBPItem.CAProviderContractItemUUID
{

  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 DocBPItem.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,

      BusLock._CABusinessLockObjCategory,
      BusLock._CABusinessLockReason,
      BusLock._CABusinessProcess,

      DocBPItem._BusinessPartner,
      DocBPItem._ProviderContract as _CAProviderContract,
      DocBPItem._CAPartner        as _ContractAccountPartner
}

Learn More