I_CABUSINESSLOCK

CDS View

Business Lock

I_CABUSINESSLOCK is a CDS View in S/4HANA. Business Lock. It contains 14 fields. 18 CDS views read from this table.

CDS Views using this table (18)

ViewTypeJoinVDMDescription
C_CAComplexBusinessLockOnDoc view from CONSUMPTION Komplexe Belegsperren
C_CAPostingLockAnalysis view from CONSUMPTION Analyse der Buchungssperren
CRMS4_IU_I_UBL view from Utilities Business Lock
I_CADocumentBPItemBusLock view_entity from COMPOSITE Document BP Item Business Lock
I_CANmbrOfLocksPerPartner view from COMPOSITE Anzahl der Sperren pro Geschäftspartner
I_ContrAcctPrtnBusinessLock view_entity from COMPOSITE Contract Account Partner Business Lock
I_UtilsCAInvcgLockRsn view from COMPOSITE Invoicing Lock Reason for Contract or Contract Accounting
P_CABusinessLock view from CONSUMPTION
P_CABusinessLockExtension2 view_entity from COMPOSITE Number of Changes
P_CABusinessLockResolve view_entity from COMPOSITE
P_CABusinessLockValidToday view_entity from CONSUMPTION Heute gültige Sperren
P_CAComplexBusinessLockOnDoc view from CONSUMPTION Komplexe Belegsperren
P_CAComplexBusinessLockOnMD view from CONSUMPTION Komplexe Sperren auf Stammdaten
P_CAContractLocks view from CONSUMPTION
P_CAItemLocks view from CONSUMPTION
P_CAPostingLockAnalysis_2 view_entity from COMPOSITE
P_ContractAccountLocks view from CONSUMPTION
P_FR_CAOverDueBizLock view_entity from COMPOSITE FR Overdue Invoice CA Business Lock

Fields (14)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 5
KEY CABusinessLockObject CABusinessLockObject 5
KEY CABusinessLockObjectCategory CABusinessLockObjectCategory 3
KEY CABusinessLockReason CABusinessLockReason 2
KEY CABusinessLockValidFrom CABusinessLockValidFrom 1
KEY CABusinessLockValidTo CABusinessLockValidTo 1
KEY CABusinessProcess CABusinessProcess 2
KEY ContractAccount ContractAccount 2
_BusinessPartner _BusinessPartner 1
_BusinessProcess _BusinessProcess 1
_ContrAcc _ContrAcc 1
LastChangeDate LastChangeDate 1
LastChangedByUser LastChangedByUser 1
LastChangeTime LastChangeTime 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Business Lock
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CABUSINESSLOCK (
    BUSINESSPARTNER,
    CABUSINESSLOCKOBJECT,
    CABUSINESSLOCKOBJECTCATEGORY,
    CABUSINESSLOCKREASON,
    CABUSINESSLOCKVALIDFROM,
    CABUSINESSLOCKVALIDTO,
    CABUSINESSPROCESS,
    CONTRACTACCOUNT,
    _BUSINESSPARTNER,
    _BUSINESSPROCESS,
    _CONTRACC,
    LASTCHANGEDATE,
    LASTCHANGEDBYUSER,
    LASTCHANGETIME,
    PRIMARY KEY (BUSINESSPARTNER, CABUSINESSLOCKOBJECT, CABUSINESSLOCKOBJECTCATEGORY, CABUSINESSLOCKREASON, CABUSINESSLOCKVALIDFROM, CABUSINESSLOCKVALIDTO, CABUSINESSPROCESS, CONTRACTACCOUNT)
);