I_UtilsCAInvcgLockRsn

DDL: I_UTILSCAINVCGLOCKRSN SQL: IECCACCTINLCKRSN Type: view COMPOSITE
18 Fields 1 Data Sources 3 Associations

Invoicing Lock Reason for Contract or Contract Accounting

I_UtilsCAInvcgLockRsn is a Composite CDS View that provides data about "Invoicing Lock Reason for Contract or Contract Accounting" in SAP S/4HANA. It reads from 1 data source (I_CABusinessLock) and exposes 18 fields with key fields CABusinessLockObject, CABusinessLockObjectCategory, CABusinessProcess, CABusinessLockReason, CABusinessLockValidFrom. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CABusinessLock CABusinessLock from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_CAInvcgLockReason _CAInvcgLockReason $projection.CABusinessLockReason = _CAInvcgLockReason.CAInvcgLockReason
[1..1] I_CABusinessLockObjCategory _ObjCategory $projection.CABusinessLockObjectCategory = _ObjCategory.CABusinessLockObjectCategory
[1..1] I_User _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID

Annotations (8)

NameValueLevelField
EndUserText.label Invoicing Lock Reason for Contract or Contract Accounting view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IECCACCTINLCKRSN view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY CABusinessLockObject I_CABusinessLock CABusinessLockObject Lock object
KEY CABusinessLockObjectCategory I_CABusinessLock CABusinessLockObjectCategory Lock Category
KEY CABusinessProcess I_CABusinessLock CABusinessProcess Process
KEY CABusinessLockReason I_CABusinessLock CABusinessLockReason Lock Reason
KEY CABusinessLockValidFrom I_CABusinessLock CABusinessLockValidFrom From
KEY CABusinessLockValidTo I_CABusinessLock CABusinessLockValidTo To
KEY BusinessPartner I_CABusinessLock BusinessPartner Issuing Authority
KEY ContractAccount I_CABusinessLock ContractAccount Contract Acct
LastChangedByUser I_CABusinessLock LastChangedByUser User Name
LastChangeDate I_CABusinessLock LastChangeDate Time Stamp
LastChangeTime I_CABusinessLock LastChangeTime Time changed
UtilsCABusLockRsnAndValidFrom
_BusinessProcess I_CABusinessLock _BusinessProcess
_BusinessPartner I_CABusinessLock _BusinessPartner
_ContrAcc I_CABusinessLock _ContrAcc
_CAInvcgLockReason _CAInvcgLockReason
_ObjCategory _ObjCategory
_LastChangedByUser _LastChangedByUser

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_UtilsCAInvcgLockRsn.
-- 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: IECCACCTINLCKRSN

CREATE VIEW I_UtilsCAInvcgLockRsn AS
SELECT
  CABusinessLock.CABusinessLockObject AS CABusinessLockObject,
  CABusinessLock.CABusinessLockObjectCategory AS CABusinessLockObjectCategory,
  CABusinessLock.CABusinessProcess AS CABusinessProcess,
  CABusinessLock.CABusinessLockReason AS CABusinessLockReason,
  CABusinessLock.CABusinessLockValidFrom AS CABusinessLockValidFrom,
  CABusinessLock.CABusinessLockValidTo AS CABusinessLockValidTo,
  CABusinessLock.BusinessPartner AS BusinessPartner,
  CABusinessLock.ContractAccount AS ContractAccount,
  CABusinessLock.LastChangedByUser AS LastChangedByUser,
  CABusinessLock.LastChangeDate AS LastChangeDate,
  CABusinessLock.LastChangeTime AS LastChangeTime,
  concat(CABusinessLock.CABusinessLockValidFrom, CABusinessLock.CABusinessLockReason) AS UtilsCABusLockRsnAndValidFrom,
  CABusinessLock._BusinessProcess AS _BusinessProcess,
  CABusinessLock._BusinessPartner AS _BusinessPartner,
  CABusinessLock._ContrAcc AS _ContrAcc
FROM I_CABusinessLock AS CABusinessLock
LEFT OUTER JOIN I_CAInvcgLockReason AS _CAInvcgLockReason ON CABusinessLockReason = _CAInvcgLockReason.CAInvcgLockReason  -- association [0..1]
LEFT OUTER JOIN I_CABusinessLockObjCategory AS _ObjCategory ON CABusinessLockObjectCategory = _ObjCategory.CABusinessLockObjectCategory  -- association [1..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [1..1]
;

Learn More