P_CABusinessLockExtension

DDL: P_CABUSINESSLOCKEXTENSION SQL: PCABUSLOCKEXT Type: view CONSUMPTION Package: ODATA_O2C_FICA_LOCK
5 Fields 1 Data Sources

Anzahl der Verängerungen

P_CABusinessLockExtension is a Consumption CDS View that provides data about "Anzahl der Verängerungen" in SAP S/4HANA. It reads from 1 data source (P_CABusinessLockValidToday) and exposes 5 fields with key fields CABusinessLockObject, CABusinessLockObjectCategory, CABusinessProcess, CABusinessLockReason. Part of development package ODATA_O2C_FICA_LOCK.

Data Sources (1)

SourceAliasJoin Type
P_CABusinessLockValidToday Lock from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PCABUSLOCKEXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Anzahl der Verängerungen view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.private true view
VDM.viewType #CONSUMPTION view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CABusinessLockObject P_CABusinessLockValidToday CABusinessLockObject
KEY CABusinessLockObjectCategory P_CABusinessLockValidToday CABusinessLockObjectCategory
KEY CABusinessProcess P_CABusinessLockValidToday CABusinessProcess Process
KEY CABusinessLockReason P_CABusinessLockValidToday CABusinessLockReason Lock Reason
NumberOfExtensions

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_CABusinessLockExtension.
-- 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.
-- SQL view name: PCABUSLOCKEXT

CREATE VIEW P_CABusinessLockExtension AS
SELECT
  Lock.CABusinessLockObject AS CABusinessLockObject,
  Lock.CABusinessLockObjectCategory AS CABusinessLockObjectCategory,
  Lock.CABusinessProcess AS CABusinessProcess,
  Lock.CABusinessLockReason AS CABusinessLockReason,
  count( * ) AS NumberOfExtensions
FROM P_CABusinessLockValidToday AS Lock
;

Learn More