I_CABusinessPartnerLock

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_CABusinessPartnerLock.
-- 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 I_CABusinessPartnerLock AS
SELECT
  gpart AS BusinessPartner,
  lockr_md AS CAMasterDataLockReason,
  lockr_dd AS CAPostgAndClrgLockReason,
  lockr_dunning AS CADunningLockReason,
  lockr_inc_pay AS CAIncomingPaymentLockReason,
  lockr_out_pay AS CAOutgoingPaymentLockReason,
  fdate AS CABusinessPartnerLockStartDate,
  tdate AS CABusinessPartnerLockEndDate,
  lockt AS CABusinessPartnerLockComment,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  ertim AS CreationTime
FROM dfkkbplock
LEFT OUTER JOIN I_CAContractPartner AS _ContractPartner ON BusinessPartner = _ContractPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CAMasterDataLockReason AS _CAMasterDataLockReason ON CAMasterDataLockReason = _CAMasterDataLockReason.CAMasterDataLockReason  -- association [1..1]
LEFT OUTER JOIN I_CAPostgAndClrgLockReason AS _CAPostgAndClrgLockReason ON CAPostgAndClrgLockReason = _CAPostgAndClrgLockReason.CAPostgAndClrgLockReason  -- association [1..1]
LEFT OUTER JOIN I_CADunningLockReason AS _CADunningLockReason ON CADunningLockReason = _CADunningLockReason.CADunningLockReason  -- association [1..1]
LEFT OUTER JOIN I_CAPaymentLockReason AS _CAIncomingPaymentLockReason ON CAIncomingPaymentLockReason = _CAIncomingPaymentLockReason.CAPaymentLockReason  -- association [1..1]
LEFT OUTER JOIN I_CAPaymentLockReason AS _CAOutgoingPaymentLockReason ON CAOutgoingPaymentLockReason = _CAOutgoingPaymentLockReason.CAPaymentLockReason  -- association [1..1]
;