P_CABusLockForBusinessPartner

DDL: P_CABUSLOCKFORBUSINESSPARTNER Type: view_entity COMPOSITE

Business Lock for a Business Partner

P_CABusLockForBusinessPartner is a Composite CDS View that provides data about "Business Lock for a Business Partner" in SAP S/4HANA. It reads from 2 data sources (I_CADocumentBPItem, P_CABusinessPartnerLock2) and exposes 26 fields with key fields CABusinessLockObjectCategory, CABusinessProcess, CABusinessLockReason, CABusinessLockValidFrom, CABusinessLockValidTo. It has 3 associations to related views.

2 data source(s) 26 fields

Data Sources (2)

SourceAliasJoin Type
I_CADocumentBPItem _Item from
P_CABusinessPartnerLock2 _Lock inner

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CABusinessLockObjCategory _BusLockObjCategory $projection.CABusinessLockObjectCategory = _BusLockObjCategory.CABusinessLockObjectCategory
[1..1] I_CABusinessProcess _BusinessProcess $projection.CABusinessProcess = _BusinessProcess.CABusinessProcess
[1..1] I_CABusinessLockReason _BusinessLockReason $projection.CABusinessProcess = _BusinessLockReason.CABusinessProcess and $projection.CABusinessLockReason = _BusinessLockReason.CABusinessLockReason

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Business Lock for a Business Partner 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 (26)

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

@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_CABusLockForBusinessPartner
  as select from I_CADocumentBPItem       as _Item
    inner join   P_CABusinessPartnerLock2 as _Lock on _Lock.BusinessPartner = _Item.BusinessPartner

  association [1..1] to I_CABusinessLockObjCategory as _BusLockObjCategory on  $projection.CABusinessLockObjectCategory = _BusLockObjCategory.CABusinessLockObjectCategory
  association [1..1] to I_CABusinessProcess         as _BusinessProcess    on  $projection.CABusinessProcess = _BusinessProcess.CABusinessProcess
  association [1..1] to I_CABusinessLockReason      as _BusinessLockReason on  $projection.CABusinessProcess    = _BusinessLockReason.CABusinessProcess
                                                                           and $projection.CABusinessLockReason = _BusinessLockReason.CABusinessLockReason

{
  key '05'                as CABusinessLockObjectCategory,
  key _Lock.CABusinessProcess,
  key _Lock.CABusinessLockReason,
  key _Lock.CABusinessLockValidFrom,
  key _Lock.CABusinessLockValidTo,
  key _Item.BusinessPartner,
  key _Item.ContractAccount,
  key _Item.CAContract,
  key _Item.CADocumentNumber,
  key _Item.CARepetitionItemNumber,
  key _Item.CABPItemNumber,
  key _Item.CASubItemNumber,
      _Lock.CreatedByUser as LastChangedByUser,
      _Lock.CreationDate  as LastChangeDate,
      _Lock.CreationTime  as LastChangeTime,
      _BusLockObjCategory,
      _BusinessProcess,
      _BusinessLockReason,
      
      _Item.CompanyCode,
      _Item.CADocumentOriginCode,
      _Item.BusinessArea,
      _Item.Segment,
      _Item.CASubApplication,
      
      _Item._CAPartner,
      _Item._ProviderContract,
      _Item._BusinessPartner
}

Learn More