C_CAComplexBusinessLockOnMD

DDL: C_CACOMPLEXBUSINESSLOCKONMD SQL: CCACMPLXLOCKONMD Type: view CONSUMPTION
10 Fields 2 Data Sources

Komplexe Sperren auf Stammdaten

C_CAComplexBusinessLockOnMD is a Consumption CDS View that provides data about "Komplexe Sperren auf Stammdaten" in SAP S/4HANA. It reads from 2 data sources (P_CAComplexBusinessLockOnMD, I_CABusinessLockEnhanced) and exposes 10 fields with key fields CABusinessLockObject, CABusinessLockObjectCategory, CABusinessProcess, CABusinessLockReason, CABusinessLockValidFrom.

Data Sources (2)

SourceAliasJoin Type
P_CAComplexBusinessLockOnMD ActiveLocks inner
I_CABusinessLockEnhanced AllLocks from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CCACMPLXLOCKONMD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Komplexe Sperren auf Stammdaten view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY CABusinessLockObject I_CABusinessLockEnhanced CABusinessLockObject
KEY CABusinessLockObjectCategory I_CABusinessLockEnhanced CABusinessLockObjectCategory
KEY CABusinessProcess I_CABusinessLockEnhanced CABusinessProcess Process
KEY CABusinessLockReason I_CABusinessLockEnhanced CABusinessLockReason Lock Reason
KEY CABusinessLockValidFrom I_CABusinessLockEnhanced CABusinessLockValidFrom From
KEY CABusinessLockValidTo I_CABusinessLockEnhanced CABusinessLockValidTo To
KEY BusinessPartner I_CABusinessLockEnhanced BusinessPartner Issuing Authority
KEY ContractAccount I_CABusinessLockEnhanced ContractAccount Contract Acct
KEY CAProviderContractItemCharUUID I_CABusinessLockEnhanced CAProviderContractItemCharUUID
LastChangeDate I_CABusinessLockEnhanced LastChangeDate Time Stamp

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 C_CAComplexBusinessLockOnMD.
-- 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: CCACMPLXLOCKONMD

CREATE VIEW C_CAComplexBusinessLockOnMD AS
SELECT
  AllLocks.CABusinessLockObject AS CABusinessLockObject,
  AllLocks.CABusinessLockObjectCategory AS CABusinessLockObjectCategory,
  AllLocks.CABusinessProcess AS CABusinessProcess,
  AllLocks.CABusinessLockReason AS CABusinessLockReason,
  AllLocks.CABusinessLockValidFrom AS CABusinessLockValidFrom,
  AllLocks.CABusinessLockValidTo AS CABusinessLockValidTo,
  AllLocks.BusinessPartner AS BusinessPartner,
  AllLocks.ContractAccount AS ContractAccount,
  AllLocks.CAProviderContractItemCharUUID AS CAProviderContractItemCharUUID,
  AllLocks.LastChangeDate AS LastChangeDate
FROM I_CABusinessLockEnhanced AS AllLocks
INNER JOIN P_CAComplexBusinessLockOnMD AS ActiveLocks ON /* join condition not captured in parsed metadata */
;

Learn More