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
  cast(gpart as bu_partner) 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,
  cast(cast(ernam as abap.char(12)) as fclm_bam_created_by) AS CreatedByUser,
  cast(cast(erdat as abap.dats) as fis_cpdat) AS CreationDate,
  cast(cast(ertim as abap.tims) as ttet_dt_cr_time) AS CreationTime
FROM dfkkbplock
LEFT OUTER JOIN I_CAContractPartner AS _ContractPartner ON BusinessPartner = _ContractPartner.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_CAMasterDataLockReason AS _MasterDataLockRsn ON CAMasterDataLockReason = _MasterDataLockRsn.CAMasterDataLockReason  -- association [1..1]
LEFT OUTER JOIN I_CAPostgAndClrgLockReason AS _PostgAndClrgLockRsn ON CAPostgAndClrgLockReason = _PostgAndClrgLockRsn.CAPostgAndClrgLockReason  -- association [1..1]
LEFT OUTER JOIN I_CADunningLockReason AS _DunningLockRsn ON CADunningLockReason = _DunningLockRsn.CADunningLockReason  -- association [1..1]
LEFT OUTER JOIN I_CAPaymentLockReason AS _IncomingPaytLockRsn ON CAIncomingPaymentLockReason = _IncomingPaytLockRsn.CAPaymentLockReason  -- association [1..1]
LEFT OUTER JOIN I_CAPaymentLockReason AS _OutgoingPaytLockRsn ON CAOutgoingPaymentLockReason = _OutgoingPaytLockRsn.CAPaymentLockReason  -- association [1..1]
;