I_CADocumentBPItemBusLock

DDL: I_CADOCUMENTBPITEMBUSLOCK Type: view_entity COMPOSITE
15 Fields 1 Data Sources

Document BP Item Business Lock

I_CADocumentBPItemBusLock is a Composite CDS View that provides data about "Document BP Item Business Lock" in SAP S/4HANA. It reads from 1 data source (I_CABusinessLock) and exposes 15 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber, CABusinessProcess.

Data Sources (1)

SourceAliasJoin Type
I_CABusinessLock CABusLock from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Document BP Item Business Lock view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #COMPOSITE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY CADocumentNumber
KEY CARepetitionItemNumber
KEY CABPItemNumber
KEY CASubItemNumber
KEY CABusinessProcess CABusinessProcess Process
KEY CABusinessLockReason CABusinessLockReason Lock Reason
KEY CABusinessLockValidFrom CABusinessLockValidFrom From
KEY CABusinessLockValidTo CABusinessLockValidTo To
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeTime LastChangeTime Time changed
_DocHeader _DocHeader
_BPItem _BPItem
_BusinessProcess _BusinessProcess
_BusinessLockReason _BusinessLockReason

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 I_CADocumentBPItemBusLock.
-- 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 I_CADocumentBPItemBusLock AS
SELECT
  cast( left( CABusLock.CABusinessLockObject, 12 ) as opbel_kk preserving type ) AS CADocumentNumber,
  cast( substring( CABusLock.CABusinessLockObject, 13, 3 ) as opupw_kk ) AS CARepetitionItemNumber,
  cast( substring( CABusLock.CABusinessLockObject, 16, 4 ) as opupk_kk ) AS CABPItemNumber,
  cast( substring( CABusLock.CABusinessLockObject, 20, 3 ) as opupz_kk ) AS CASubItemNumber,
  CABusinessProcess,
  CABusinessLockReason,
  CABusinessLockValidFrom,
  CABusinessLockValidTo,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime
FROM I_CABusinessLock AS CABusLock
;

Learn More