P_CABUSINESSPARTNERLOCK2

CDS View

Business Partner Lock

P_CABUSINESSPARTNERLOCK2 is a CDS View in S/4HANA. Business Partner Lock. It contains 7 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 7 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_CACombinedBusinessLock view_entity union_all COMPOSITE Contract Accounting Business Locks
P_CABusLockForBusinessPartner view_entity inner COMPOSITE Business Lock for a Business Partner

Fields (7)

KeyField CDS FieldsUsed in Views
KEY CABusinessLockReason CABusinessLockReason 1
KEY CABusinessLockValidFrom CABusinessLockValidFrom 1
KEY CABusinessLockValidTo CABusinessLockValidTo 1
KEY CABusinessProcess CABusinessProcess 1
CreatedByUser LastChangedByUser 1
CreationDate LastChangeDate 1
CreationTime LastChangeTime 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Business Partner Lock'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #XXL,
  dataClass: #TRANSACTIONAL
}

@VDM.viewType: #COMPOSITE
@VDM.private: true
define view entity P_CABusinessPartnerLock2
  as select from I_CABusinessPartnerLock
{
  key BusinessPartner                as CABusinessLockObject,
      //  key '05' as lotyp,

  key '01'                           as CABusinessProcess,
  key CADunningLockReason            as CABusinessLockReason,
  key CABusinessPartnerLockStartDate as CABusinessLockValidFrom,
  key CABusinessPartnerLockEndDate   as CABusinessLockValidTo,
  key BusinessPartner,
      CreatedByUser,
      CreationDate,
      CreationTime
}
where
  CADunningLockReason <> ' '

union all

select from I_CABusinessPartnerLock
{
  key BusinessPartner                as CABusinessLockObject,
      //  key '05' as lotyp,

  key '02'                           as CABusinessProcess,
  key CAIncomingPaymentLockReason    as CABusinessLockReason,
  key CABusinessPartnerLockStartDate as CABusinessLockValidFrom,
  key CABusinessPartnerLockEndDate   as CABusinessLockValidTo,
  key BusinessPartner,
      CreatedByUser,
      CreationDate,
      CreationTime
}
where
  CAIncomingPaymentLockReason <> ' '

union all

select from I_CABusinessPartnerLock
{
  key BusinessPartner                as CABusinessLockObject,
      //  key '05' as lotyp,

  key '03'                           as CABusinessProcess,
  key CAOutgoingPaymentLockReason    as CABusinessLockReason,
  key CABusinessPartnerLockStartDate as CABusinessLockValidFrom,
  key CABusinessPartnerLockEndDate   as CABusinessLockValidTo,
  key BusinessPartner,
      CreatedByUser,
      CreationDate,
      CreationTime
}
where
  CAOutgoingPaymentLockReason <> ' '

union all

select from I_CABusinessPartnerLock
{
  key BusinessPartner                as CABusinessLockObject,
      //  key '05' as lotyp,

  key '09'                           as CABusinessProcess,
  key CAPostgAndClrgLockReason       as CABusinessLockReason,
  key CABusinessPartnerLockStartDate as CABusinessLockValidFrom,
  key CABusinessPartnerLockEndDate   as CABusinessLockValidTo,
  key BusinessPartner,
      CreatedByUser,
      CreationDate,
      CreationTime
}
where
  CAPostgAndClrgLockReason <> ' '

Learn More