P_CABusLockForContract

DDL: P_CABUSLOCKFORCONTRACT Type: view_entity COMPOSITE Package: ODATA_O2C_FICA_DOCUMENT_MANAGE
27 Fields 2 Data Sources

Business Lock for a CA Contract

P_CABusLockForContract is a Composite CDS View that provides data about "Business Lock for a CA Contract" in SAP S/4HANA. It reads from 2 data sources (I_CABusinessLockEnhanced, I_CADocumentBPItemUI) and exposes 27 fields with key fields CABusinessLockObjectCategory, CABusinessProcess, CABusinessLockReason, CABusinessLockValidFrom, CABusinessLockValidTo. Part of development package ODATA_O2C_FICA_DOCUMENT_MANAGE.

Data Sources (2)

SourceAliasJoin Type
I_CABusinessLockEnhanced BusLock inner
I_CADocumentBPItemUI DocBPItem from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (27)

KeyFieldSource TableSource FieldDescription
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_CADocumentBPItemUI BusinessPartner Issuing Authority
KEY ContractAccount I_CADocumentBPItemUI ContractAccount Contract Acct
KEY CAContract I_CADocumentBPItemUI CAContract Contract
KEY CAProviderContractItemCharUUID I_CADocumentBPItemUI CAProviderContractItemCharUUID
KEY CADocumentNumber I_CADocumentBPItemUI CADocumentNumber Document Number
KEY CARepetitionItemNumber I_CADocumentBPItemUI CARepetitionItemNumber Repetition Item
KEY CABPItemNumber I_CADocumentBPItemUI CABPItemNumber Item
KEY CASubItemNumber I_CADocumentBPItemUI CASubItemNumber Subitem
LastChangedByUser I_CABusinessLockEnhanced LastChangedByUser User Name
LastChangeDate I_CABusinessLockEnhanced LastChangeDate Time Stamp
LastChangeTime I_CABusinessLockEnhanced LastChangeTime Time changed
CompanyCode I_CADocumentBPItemUI CompanyCode Receiver Company Code
CADocumentOriginCode I_CADocumentBPItemUI CADocumentOriginCode Document Origin
BusinessArea I_CADocumentBPItemUI BusinessArea Business Area
Segment I_CADocumentBPItemUI Segment Segment number
CASubApplication I_CADocumentBPItemUI CASubApplication Subapplication
_CABusinessLockObjCategory I_CABusinessLockEnhanced _CABusinessLockObjCategory
_CABusinessLockReason I_CABusinessLockEnhanced _CABusinessLockReason
_CABusinessProcess I_CABusinessLockEnhanced _CABusinessProcess
_BusinessPartner I_CADocumentBPItemUI _BusinessPartner
_CAProviderContract I_CADocumentBPItemUI _ProviderContract
_ContractAccountPartner I_CADocumentBPItemUI _CAPartner

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_CABusLockForContract.
-- 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_CABusLockForContract AS
SELECT
  BusLock.CABusinessLockObjectCategory AS CABusinessLockObjectCategory,
  BusLock.CABusinessProcess AS CABusinessProcess,
  BusLock.CABusinessLockReason AS CABusinessLockReason,
  BusLock.CABusinessLockValidFrom AS CABusinessLockValidFrom,
  BusLock.CABusinessLockValidTo AS CABusinessLockValidTo,
  DocBPItem.BusinessPartner AS BusinessPartner,
  DocBPItem.ContractAccount AS ContractAccount,
  DocBPItem.CAContract AS CAContract,
  DocBPItem.CAProviderContractItemCharUUID AS CAProviderContractItemCharUUID,
  DocBPItem.CADocumentNumber AS CADocumentNumber,
  DocBPItem.CARepetitionItemNumber AS CARepetitionItemNumber,
  DocBPItem.CABPItemNumber AS CABPItemNumber,
  DocBPItem.CASubItemNumber AS CASubItemNumber,
  BusLock.LastChangedByUser AS LastChangedByUser,
  BusLock.LastChangeDate AS LastChangeDate,
  BusLock.LastChangeTime AS LastChangeTime,
  DocBPItem.CompanyCode AS CompanyCode,
  DocBPItem.CADocumentOriginCode AS CADocumentOriginCode,
  DocBPItem.BusinessArea AS BusinessArea,
  DocBPItem.Segment AS Segment,
  DocBPItem.CASubApplication AS CASubApplication,
  BusLock._CABusinessLockObjCategory AS _CABusinessLockObjCategory,
  BusLock._CABusinessLockReason AS _CABusinessLockReason,
  BusLock._CABusinessProcess AS _CABusinessProcess,
  DocBPItem._BusinessPartner AS _BusinessPartner,
  DocBPItem._ProviderContract AS _CAProviderContract,
  DocBPItem._CAPartner AS _ContractAccountPartner
FROM I_CADocumentBPItemUI AS DocBPItem
INNER JOIN I_CABusinessLockEnhanced AS BusLock ON /* join condition not captured in parsed metadata */
;

Learn More