What is C_CABusinessLock in SAP S/4HANA?

C_CABusinessLock is a consumption CDS view in SAP S/4HANA. Analyse der betriebswirtschaftl. Sperren It contains 129 fields.

Which tables does C_CABusinessLock read from?

C_CABusinessLock reads data from: P_CABusinessLock.

What VDM layer is C_CABusinessLock?

C_CABusinessLock is classified as a Consumption view optimized for specific business scenarios and reporting.

C_CABusinessLock

DDL: C_CABUSINESSLOCK SQL: CCABUSLOCK Type: view CONSUMPTION

129 Fields 1 Data Sources 3 Associations

Analyse der betriebswirtschaftl. Sperren

C_CABusinessLock is a Consumption CDS View that provides data about "Analyse der betriebswirtschaftl. Sperren" in SAP S/4HANA. It reads from 1 data source (P_CABusinessLock) and exposes 129 fields with key fields CADocumentNumber, CARepetitionItemNumber, CABPItemNumber, CASubItemNumber, CABusinessLockObject. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
P_CABusinessLock	P_CABusinessLock	from

Parameters (3)

Name	Type	Default
P_Date	dats
P_CABusinessProcess	char2
P_CABusinessProcessForMD	char2

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_CADocumentBPItemLogical	_ContractPartnerItem	`Lock.CADocumentNumber = _ContractPartnerItem.CADocumentNumber and Lock.CARepetitionItemNumber = _ContractPartnerItem.CARepetitionItemNumber and Lock.CABPItemNumber = _ContractPartnerItem.CABPItemNumber and Lock.CASubItemNumber = _ContractPartnerItem.CASubItemNumber`
[1..1]	I_CAContractPartner	_ContractPartner	`$projection.BusinessPartner = _ContractPartner.BusinessPartner`
[0..1]	I_ContractAccountPartner	_ContractAccount	`$projection.BusinessPartner = _ContractAccount.BusinessPartner and $projection.ContractAccount = _ContractAccount.ContractAccount`

Annotations (9)

Name	Value	Level
EndUserText.label	Analyse der betriebswirtschaftl. Sperren	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#REQUIRED	view
AbapCatalog.sqlViewName	CCABUSLOCK	view

Fields (129)

Key	Field	Source Table	Source Field	Description
KEY	CADocumentNumber	_ContractPartnerItem	CADocumentNumber	Document Number
KEY	CARepetitionItemNumber	_ContractPartnerItem	CARepetitionItemNumber	Repetition Item
KEY	CABPItemNumber	_ContractPartnerItem	CABPItemNumber	Item
KEY	CASubItemNumber	_ContractPartnerItem	CASubItemNumber	Subitem
KEY	CABusinessLockObject	Lock	CABusinessLockObject
KEY	CABusinessLockValidFrom	Lock	CABusinessLockValidFrom	From
KEY	CABusinessLockValidTo	Lock	CABusinessLockValidTo	To
KEY	ContractAccount	Lock	ContractAccount	Contract Acct
KEY	BusinessPartner	Lock	BusinessPartner	Issuing Authority
KEY	CABusinessLockReason	Lock	CABusinessLockReason	Lock Reason
	LastName
	FirstName
	BusinessPartnerName
	CABusinessLockObjectCategory	Lock	CABusinessLockObjectCategory
	CABusinessProcess	Lock	CABusinessProcess	Process
	LastChangeDate	Lock	LastChangeDate	Time Stamp
	CABusinessLockDuration	Lock	CABusinessLockDuration
	CAContract	_ContractPartnerItem	CAContract	Contract
	CASubApplication	_ContractPartnerItem	CASubApplication	Subapplication
	ContractAccountCategory	_CAHeader	ContractAccountCategory	Cont. Acct Cat.
	CABusinessLockSequenceNumber	_BusLockHistory	CABusinessLockSequenceNumber
	CompanyCode	_ContractPartnerItem	CompanyCode	Receiver Company Code
	Division	_ContractPartnerItem	Division	Internal Division ID
	CAMainTransaction	_ContractPartnerItem	CAMainTransaction	Main Trans.
	CAPaymentMethod	_ContractPartnerItem	CAPaymentMethod	Payment Method
	CAPaymentMethodForIncgPayment	_CAPartner	CAPaymentMethodForIncgPayment
	CADunningProcedure	_ContractPartnerItem	CADunningProcedure	Dunning Proc.
	CADunningProcedureForContrAcct	_CAPartner	CADunningProcedure	Dunning Proc.
	CACollectionStrategy	_CAPartner	CACollectionStrategy	Coll. Strategy
	CAAmountInTransactionCurrency
	TransactionCurrency	_ContractPartnerItem	TransactionCurrency	Transaction Currency
	_ContractPartner		_ContractPartner
	CADocumentNumber			Document Number
KEY	CARepetitionItemNumber	_ContractPartnerItem	CARepetitionItemNumber	Repetition Item
KEY	CABPItemNumber	_ContractPartnerItem	CABPItemNumber	Item
KEY	CASubItemNumber	_ContractPartnerItem	CASubItemNumber	Subitem
KEY	CABusinessLockObject	Lock	CABusinessLockObject
KEY	CABusinessLockValidFrom	Lock	CABusinessLockValidFrom	From
KEY	CABusinessLockValidTo	Lock	CABusinessLockValidTo	To
KEY	ContractAccount	Lock	ContractAccount	Contract Acct
KEY	BusinessPartner	Lock	BusinessPartner	Issuing Authority
KEY	CABusinessLockReason	Lock	CABusinessLockReason	Lock Reason
	LastName
	FirstName
	BusinessPartnerName
	CABusinessLockObjectCategory	Lock	CABusinessLockObjectCategory
	CABusinessProcess	Lock	CABusinessProcess	Process
	LastChangeDate	Lock	LastChangeDate	Time Stamp
	CABusinessLockDuration	Lock	CABusinessLockDuration
	CAContract	_ContractPartnerItem	CAContract	Contract
	CASubApplication	_ContractPartnerItem	CASubApplication	Subapplication
	ContractAccountCategory	_CAHeader	ContractAccountCategory	Cont. Acct Cat.
	CABusinessLockSequenceNumber	_BusLockHistory	CABusinessLockSequenceNumber
	CompanyCode	_ContractPartnerItem	CompanyCode	Receiver Company Code
	Division	_ContractPartnerItem	Division	Internal Division ID
	CAMainTransaction	_ContractPartnerItem	CAMainTransaction	Main Trans.
	CAPaymentMethod	_ContractPartnerItem	CAPaymentMethod	Payment Method
	CAPaymentMethodForIncgPayment	_CAPartner	CAPaymentMethodForIncgPayment
	CADunningProcedure	_ContractPartnerItem	CADunningProcedure	Dunning Proc.
	CADunningProcedureForContrAcct	_CAPartner	CADunningProcedure	Dunning Proc.
	CACollectionStrategy	_CAPartner	CACollectionStrategy	Coll. Strategy
	CAAmountInTransactionCurrency
	TransactionCurrency	_ContractPartnerItem	TransactionCurrency	Transaction Currency
	_ContractPartner		_ContractPartner
	CADocumentNumber			Document Number
KEY	CARepetitionItemNumber	Lock	CARepetitionItemNumber	Repetition Item
KEY	CABPItemNumber	Lock	CABPItemNumber	Item
KEY	CASubItemNumber	Lock	CASubItemNumber	Subitem
KEY	CABusinessLockObject	Lock	CABusinessLockObject
KEY	CABusinessLockValidFrom	Lock	CABusinessLockValidFrom	From
KEY	CABusinessLockValidTo	Lock	CABusinessLockValidTo	To
KEY	ContractAccount	Lock	ContractAccount	Contract Acct
KEY	BusinessPartner	Lock	BusinessPartner	Issuing Authority
KEY	CABusinessLockReason	Lock	CABusinessLockReason	Lock Reason
	LastName
	FirstName
	BusinessPartnerName
	CABusinessLockObjectCategory	Lock	CABusinessLockObjectCategory
	CABusinessProcess	Lock	CABusinessProcess	Process
	LastChangeDate	Lock	LastChangeDate	Time Stamp
	CABusinessLockDuration	Lock	CABusinessLockDuration
	CAContract			Contract
	CASubApplication			Subapplication
	ContractAccountCategory	_CAHeader	ContractAccountCategory	Cont. Acct Cat.
	CABusinessLockSequenceNumber	_BusLockHistory	CABusinessLockSequenceNumber
	CompanyCode	_CAPartner	CAStandardCompanyCode	Receiver Company Code
	Division			Internal Division ID
	CAMainTransaction			Main Trans.
	CAPaymentMethod	_CAPartner	CAPaymentMethodForIncgPayment	Payment Method
	CAPaymentMethodForIncgPayment	_CAPartner	CAPaymentMethodForIncgPayment
	CADunningProcedure	_CAPartner	CADunningProcedure	Dunning Proc.
	CADunningProcedureForContrAcct	_CAPartner	CADunningProcedure	Dunning Proc.
	CACollectionStrategy	_CAPartner	CACollectionStrategy	Coll. Strategy
	CAAmountInTransactionCurrency		0
	TransactionCurrency			Transaction Currency
	_ContractPartner		_ContractPartner
	CADocumentNumber			Document Number
KEY	CARepetitionItemNumber	_ContractPartnerItem	CARepetitionItemNumber	Repetition Item
KEY	CABPItemNumber	_ContractPartnerItem	CABPItemNumber	Item
KEY	CASubItemNumber	_ContractPartnerItem	CASubItemNumber	Subitem
KEY	CABusinessLockObject	Lock	CABusinessLockObject
KEY	CABusinessLockValidFrom	Lock	CABusinessLockValidFrom	From
KEY	CABusinessLockValidTo	Lock	CABusinessLockValidTo	To
KEY	ContractAccount	_ContractPartnerItem	ContractAccount	Contract Acct
KEY	BusinessPartner	Lock	BusinessPartner	Issuing Authority
KEY	CABusinessLockReason	Lock	CABusinessLockReason	Lock Reason
	LastName
	FirstName
	BusinessPartnerName
	CABusinessLockObjectCategory
	CABusinessProcess	Lock	CABusinessProcess	Process
	LastChangeDate	Lock	CreationDate	Time Stamp
	CABusinessLockDuration	Lock	CABusinessLockDuration
	CAContract	_ContractPartnerItem	CAContract	Contract
	CASubApplication	_ContractPartnerItem	CASubApplication	Subapplication
	ContractAccountCategory			Cont. Acct Cat.
	CABusinessLockSequenceNumber
	CompanyCode	_ContractPartnerItem	CompanyCode	Receiver Company Code
	Division	_ContractPartnerItem	Division	Internal Division ID
	CAMainTransaction	_ContractPartnerItem	CAMainTransaction	Main Trans.
	CAPaymentMethod	_ContractPartnerItem	CAPaymentMethod	Payment Method
	CAPaymentMethodForIncgPayment
	CADunningProcedure	_ContractPartnerItem	CADunningProcedure	Dunning Proc.
	CADunningProcedureForContrAcct			Dunning Proc.
	CACollectionStrategy			Coll. Strategy
	CAAmountInTransactionCurrency
	TransactionCurrency	_ContractPartnerItem	TransactionCurrency	Transaction Currency
	_ContractPartner		_ContractPartner
	_ContractAccount		_ContractAccount

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_CABusinessLock.
-- 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: CCABUSLOCK
-- Parameters: P_Date : dats, P_CABusinessProcess : char2, P_CABusinessProcessForMD : char2

CREATE VIEW C_CABusinessLock AS
SELECT
  _ContractPartnerItem.CADocumentNumber AS CADocumentNumber,
  _ContractPartnerItem.CARepetitionItemNumber AS CARepetitionItemNumber,
  _ContractPartnerItem.CABPItemNumber AS CABPItemNumber,
  _ContractPartnerItem.CASubItemNumber AS CASubItemNumber,
  Lock.CABusinessLockObject AS CABusinessLockObject,
  Lock.CABusinessLockValidFrom AS CABusinessLockValidFrom,
  Lock.CABusinessLockValidTo AS CABusinessLockValidTo,
  Lock.ContractAccount AS ContractAccount,
  Lock.BusinessPartner AS BusinessPartner,
  Lock.CABusinessLockReason AS CABusinessLockReason,
  _ContractPartner._BusinessPartner.LastName AS LastName,
  _ContractPartner._BusinessPartner.FirstName AS FirstName,
  _ContractPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  Lock.CABusinessLockObjectCategory AS CABusinessLockObjectCategory,
  Lock.CABusinessProcess AS CABusinessProcess,
  Lock.LastChangeDate AS LastChangeDate,
  Lock.CABusinessLockDuration AS CABusinessLockDuration,
  _ContractPartnerItem.CAContract AS CAContract,
  _ContractPartnerItem.CASubApplication AS CASubApplication,
  _CAHeader.ContractAccountCategory AS ContractAccountCategory,
  _BusLockHistory.CABusinessLockSequenceNumber AS CABusinessLockSequenceNumber,
  _ContractPartnerItem.CompanyCode AS CompanyCode,
  _ContractPartnerItem.Division AS Division,
  _ContractPartnerItem.CAMainTransaction AS CAMainTransaction,
  _ContractPartnerItem.CAPaymentMethod AS CAPaymentMethod,
  _CAPartner.CAPaymentMethodForIncgPayment AS CAPaymentMethodForIncgPayment,
  _ContractPartnerItem.CADunningProcedure AS CADunningProcedure,
  _CAPartner.CADunningProcedure AS CADunningProcedureForContrAcct,
  _CAPartner.CACollectionStrategy AS CACollectionStrategy,
  cast(_ContractPartnerItem.CAAmountInTransactionCurrency as abap.curr(23,2)) AS CAAmountInTransactionCurrency,
  _ContractPartnerItem.TransactionCurrency AS TransactionCurrency
FROM P_CABusinessLock
LEFT OUTER JOIN I_CADocumentBPItemLogical AS _ContractPartnerItem ON Lock.CADocumentNumber = _ContractPartnerItem.CADocumentNumber AND Lock.CARepetitionItemNumber = _ContractPartnerItem.CARepetitionItemNumber AND Lock.CABPItemNumber = _ContractPartnerItem.CABPItemNumber AND Lock.CASubItemNumber = _ContractPartnerItem.CASubItemNumber  -- association [1..1]
LEFT OUTER JOIN I_CAContractPartner AS _ContractPartner ON BusinessPartner = _ContractPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccount ON BusinessPartner = _ContractAccount.BusinessPartner AND ContractAccount = _ContractAccount.ContractAccount  -- association [0..1]
;

Depth:

C_CABusinessLock view

P_CABusinessLock view