C_CAComplexBusinessLockOnMD

DDL: C_CACOMPLEXBUSINESSLOCKONMD SQL: CCACMPLXLOCKONMD Type: view CONSUMPTION

Komplexe Sperren auf Stammdaten

C_CAComplexBusinessLockOnMD is a Consumption CDS View that provides data about "Komplexe Sperren auf Stammdaten" in SAP S/4HANA. It reads from 2 data sources (P_CAComplexBusinessLockOnMD, I_CABusinessLockEnhanced) and exposes 10 fields with key fields CABusinessLockObject, CABusinessLockObjectCategory, CABusinessProcess, CABusinessLockReason, CABusinessLockValidFrom.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
P_CAComplexBusinessLockOnMD ActiveLocks inner
I_CABusinessLockEnhanced AllLocks from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CCACMPLXLOCKONMD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Komplexe Sperren auf Stammdaten view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CABusinessLockObject I_CABusinessLockEnhanced CABusinessLockObject
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_CABusinessLockEnhanced BusinessPartner
KEY ContractAccount I_CABusinessLockEnhanced ContractAccount
KEY CAProviderContractItemCharUUID I_CABusinessLockEnhanced CAProviderContractItemCharUUID
LastChangeDate I_CABusinessLockEnhanced LastChangeDate 
@AbapCatalog.sqlViewName: 'CCACMPLXLOCKONMD'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Komplexe Sperren auf Stammdaten'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #CONSUMPTION
define view C_CAComplexBusinessLockOnMD
  as select from I_CABusinessLockEnhanced    as AllLocks
    inner join   P_CAComplexBusinessLockOnMD as ActiveLocks on AllLocks.BusinessPartner = ActiveLocks.BusinessPartner
    left outer to one join P_CAProviderContractByItemUUID as ProvContract on AllLocks.CAProviderContractItemUUID = ProvContract.CAProviderContractItemUUID
   
{
      //ActiveLock

  key AllLocks.CABusinessLockObject,
  key AllLocks.CABusinessLockObjectCategory,
  key AllLocks.CABusinessProcess,
  key AllLocks.CABusinessLockReason,
  key AllLocks.CABusinessLockValidFrom,
  key AllLocks.CABusinessLockValidTo,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_BusinessPartnerVH',
                     element: 'BusinessPartner' }
        }]  
  key AllLocks.BusinessPartner,
      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ContractAccountHeaderStdVH',
                     element: 'ContractAccount' }
        }]
  key AllLocks.ContractAccount,
  key case 
      when AllLocks.CAProviderContractItemCharUUID is initial
        then AllLocks.CAContract
      else
    //  cast('0001' as vtref_kk )

        cast(ProvContract.CAProviderContract as vtref_kk preserving type )
      end as CAContract,
  key AllLocks.CAProviderContractItemCharUUID,
      AllLocks.LastChangeDate
  
}

Learn More