P_CABusLockForBusinessPartner

DDL: P_CABUSLOCKFORBUSINESSPARTNER Type: view_entity COMPOSITE
26 Fields 2 Data Sources 3 Associations

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.

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 Process
KEY CABusinessLockReason P_CABusinessPartnerLock2 CABusinessLockReason Lock Reason
KEY CABusinessLockValidFrom P_CABusinessPartnerLock2 CABusinessLockValidFrom From
KEY CABusinessLockValidTo P_CABusinessPartnerLock2 CABusinessLockValidTo To
KEY BusinessPartner I_CADocumentBPItem BusinessPartner Issuing Authority
KEY ContractAccount I_CADocumentBPItem ContractAccount Contract Acct
KEY CAContract I_CADocumentBPItem CAContract Contract
KEY CADocumentNumber I_CADocumentBPItem CADocumentNumber Document Number
KEY CARepetitionItemNumber I_CADocumentBPItem CARepetitionItemNumber Repetition Item
KEY CABPItemNumber I_CADocumentBPItem CABPItemNumber Item
KEY CASubItemNumber I_CADocumentBPItem CASubItemNumber Subitem
LastChangedByUser P_CABusinessPartnerLock2 CreatedByUser User Name
LastChangeDate P_CABusinessPartnerLock2 CreationDate Time Stamp
LastChangeTime P_CABusinessPartnerLock2 CreationTime Time of Change
_BusLockObjCategory _BusLockObjCategory
_BusinessProcess _BusinessProcess
_BusinessLockReason _BusinessLockReason
CompanyCode I_CADocumentBPItem CompanyCode Receiver Company Code
CADocumentOriginCode I_CADocumentBPItem CADocumentOriginCode Document Origin
BusinessArea I_CADocumentBPItem BusinessArea Business Area
Segment I_CADocumentBPItem Segment Segment number
CASubApplication I_CADocumentBPItem CASubApplication Subapplication
_CAPartner I_CADocumentBPItem _CAPartner
_ProviderContract I_CADocumentBPItem _ProviderContract
_BusinessPartner I_CADocumentBPItem _BusinessPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_CABusLockForBusinessPartner.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_CABusLockForBusinessPartner AS
SELECT
  '05' AS CABusinessLockObjectCategory,
  _Lock.CABusinessProcess AS CABusinessProcess,
  _Lock.CABusinessLockReason AS CABusinessLockReason,
  _Lock.CABusinessLockValidFrom AS CABusinessLockValidFrom,
  _Lock.CABusinessLockValidTo AS CABusinessLockValidTo,
  _Item.BusinessPartner AS BusinessPartner,
  _Item.ContractAccount AS ContractAccount,
  _Item.CAContract AS CAContract,
  _Item.CADocumentNumber AS CADocumentNumber,
  _Item.CARepetitionItemNumber AS CARepetitionItemNumber,
  _Item.CABPItemNumber AS CABPItemNumber,
  _Item.CASubItemNumber AS CASubItemNumber,
  _Lock.CreatedByUser AS LastChangedByUser,
  _Lock.CreationDate AS LastChangeDate,
  _Lock.CreationTime AS LastChangeTime,
  _Item.CompanyCode AS CompanyCode,
  _Item.CADocumentOriginCode AS CADocumentOriginCode,
  _Item.BusinessArea AS BusinessArea,
  _Item.Segment AS Segment,
  _Item.CASubApplication AS CASubApplication,
  _Item._CAPartner AS _CAPartner,
  _Item._ProviderContract AS _ProviderContract,
  _Item._BusinessPartner AS _BusinessPartner
FROM I_CADocumentBPItem AS _Item
INNER JOIN P_CABusinessPartnerLock2 AS _Lock ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CABusinessLockObjCategory AS _BusLockObjCategory ON CABusinessLockObjectCategory = _BusLockObjCategory.CABusinessLockObjectCategory  -- association [1..1]
LEFT OUTER JOIN I_CABusinessProcess AS _BusinessProcess ON CABusinessProcess = _BusinessProcess.CABusinessProcess  -- association [1..1]
LEFT OUTER JOIN I_CABusinessLockReason AS _BusinessLockReason ON CABusinessProcess = _BusinessLockReason.CABusinessProcess AND CABusinessLockReason = _BusinessLockReason.CABusinessLockReason  -- association [1..1]
;

Learn More