I_CABllbleItmExceptionHistory

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_CABllbleItmExceptionHistory.
-- 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: ICABITEXCHIST

CREATE VIEW I_CABllbleItmExceptionHistory AS
SELECT
  bitcat AS CABllbleItmClass,
  bitrectype AS CABllbleItmRecordType,
  bitpackuuid AS CABllbleItmPackageUUID,
  bitpackcno AS CABllbleItmPackNo,
  excdate AS CABllbleItmExceptionDate,
  exctime AS CABllbleItmExceptionTime,
  excreason AS CABllbleItmExceptionReason,
  excusnam AS CABllbleItmExceptionUserName,
  excrevdate AS CABllbleItmExcptnRvslDate,
  excrevtime AS CABllbleItmExcptnRvslTime,
  excrevreason AS CABllbleItmExcptnRvslRsn,
  excrevusnam AS CABllbleItmExcptnRvslUserName,
  vkont AS ContractAccount,
  srctatype AS CABllbleItmSourceTransType,
  srctaid AS CABllbleItmSourceTransId
FROM dfkkbixbit_hist
LEFT OUTER JOIN I_CABllbleItmClass AS _CABllbleItmClass ON _CABllbleItmClass.CABllbleItmClass = CABllbleItmClass  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmRecordType AS _CABllbleItmRecordType ON _CABllbleItmRecordType.CABllbleItmRecordType = CABllbleItmRecordType  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmExcptnReason AS _CABllbleItmExcptnReason ON _CABllbleItmExcptnReason.CABllbleItmExceptionReason = CABllbleItmExceptionReason  -- association [0..1]
LEFT OUTER JOIN I_User AS _CABllbleItmExceptionUserName ON _CABllbleItmExceptionUserName.UserID = CABllbleItmExceptionUserName  -- association [0..1]
LEFT OUTER JOIN I_User AS _CABllbleItmExcptnRvslUserName ON _CABllbleItmExcptnRvslUserName.UserID = CABllbleItmExcptnRvslUserName  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmExcptnRvslReason AS _CABllbleItmExcptnRvslReason ON _CABllbleItmExcptnRvslReason.CABllbleItmExcptnRvslRsn = CABllbleItmExcptnRvslRsn  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON _ContractAccountHeader.ContractAccount = ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmSrceTransType AS _CABllbleItmSrceTransType ON _CABllbleItmSrceTransType.CABllbleItmSourceTransType = CABllbleItmSourceTransType  -- association [0..1]
;