P_CABusLockForBusinessPartner

DDL: P_CABUSLOCKFORBUSINESSPARTNER Type: view_entity COMPOSITE Package: ODATA_O2C_FICA_DOCUMENT_MANAGE

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 (P_CABusinessPartnerLock2, I_CADocumentBPItem) and exposes 26 fields with key fields CABusinessLockObjectCategory, CABusinessProcess, CABusinessLockReason, CABusinessLockValidFrom, CABusinessLockValidTo. It has 3 associations to related views. Part of development package ODATA_O2C_FICA_DOCUMENT_MANAGE.

2 data source(s) 26 fields

Data Sources (2)

SourceAliasJoin Type
P_CABusinessPartnerLock2 BusLock inner
I_CADocumentBPItem DocBPItem from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_CABusinessLockObjCategory _CABusinessLockObjCategory $projection.CABusinessLockObjectCategory = _CABusinessLockObjCategory.CABusinessLockObjectCategory
[1..1] I_CABusinessProcess _CABusinessProcess $projection.CABusinessProcess = _CABusinessProcess.CABusinessProcess
[1..1] I_CABusinessLockReason _CABusinessLockReason $projection.CABusinessProcess = _CABusinessLockReason.CABusinessProcess and $projection.CABusinessLockReason = _CABusinessLockReason.CABusinessLockReason

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 (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
CompanyCode I_CADocumentBPItem CompanyCode
CADocumentOriginCode I_CADocumentBPItem CADocumentOriginCode
BusinessArea I_CADocumentBPItem BusinessArea
Segment I_CADocumentBPItem Segment
CASubApplication I_CADocumentBPItem CASubApplication
_CABusinessLockObjCategory _CABusinessLockObjCategory
_CABusinessLockReason _CABusinessLockReason
_CABusinessProcess _CABusinessProcess
_BusinessPartner I_CADocumentBPItem _BusinessPartner
_CAProviderContract I_CADocumentBPItem _CAProviderContract
_ContractAccountPartner I_CADocumentBPItem _ContractAccountPartner 
@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_CABusLockForBusinessPartner
  as select from I_CADocumentBPItem       as DocBPItem
    inner join   P_CABusinessPartnerLock2 as BusLock on BusLock.BusinessPartner = DocBPItem.BusinessPartner

  association [1..1] to I_CABusinessLockObjCategory as _CABusinessLockObjCategory on  $projection.CABusinessLockObjectCategory = _CABusinessLockObjCategory.CABusinessLockObjectCategory
  association [1..1] to I_CABusinessProcess         as _CABusinessProcess         on  $projection.CABusinessProcess = _CABusinessProcess.CABusinessProcess
  association [1..1] to I_CABusinessLockReason      as _CABusinessLockReason      on  $projection.CABusinessProcess    = _CABusinessLockReason.CABusinessProcess
                                                                                  and $projection.CABusinessLockReason = _CABusinessLockReason.CABusinessLockReason

{
  key '05'                       as CABusinessLockObjectCategory,
  key BusLock.CABusinessProcess,
  key BusLock.CABusinessLockReason,
  key BusLock.CABusinessLockValidFrom,
  key BusLock.CABusinessLockValidTo,
  key DocBPItem.BusinessPartner,
  key DocBPItem.ContractAccount,
  key DocBPItem.CAContract,
  key DocBPItem.CADocumentNumber,
  key DocBPItem.CARepetitionItemNumber,
  key DocBPItem.CABPItemNumber,
  key DocBPItem.CASubItemNumber,

      BusLock.CreatedByUser        as LastChangedByUser,
      BusLock.CreationDate         as LastChangeDate,
      BusLock.CreationTime         as LastChangeTime,

      DocBPItem.CompanyCode,
      DocBPItem.CADocumentOriginCode,
      DocBPItem.BusinessArea,
      DocBPItem.Segment,
      DocBPItem.CASubApplication,

      _CABusinessLockObjCategory,
      _CABusinessLockReason,
      _CABusinessProcess,

      DocBPItem._BusinessPartner,
      DocBPItem._CAProviderContract,
      DocBPItem._ContractAccountPartner
}

Learn More