I_CABllbleItmReversalRequest

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_CABllbleItmReversalRequest.
-- 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_CABllbleItmReversalRequest AS
SELECT
  status AS CABllbleItmRvslReqStatus,
  vkont AS ContractAccount,
  srctatype AS CABllbleItmSourceTransType,
  srctaid_from AS CABllbleItmSourceTransId,
  revtriguuid AS CABllbleItmRvslReqUUID,
  srctaid_to AS CABllbleItmSourceTransIDTo,
  xsingle_srcta AS CABllbleItmSrceTransIDIsSingle,
  revtask AS CARvslTsk,
  reratetriguuid AS CABllbleItmReratgReqUUID,
  cast(gpart as bu_partner preserving type) AS BusinessPartner,
  vtref AS CAContract,
  subap AS CASubApplication,
  bitpackuuid AS CABllbleItmPackageUUID,
  bitcat AS CABllbleItmClass,
  bitstatus AS CABllbleItmStatus,
  snapshotid AS CACnvChrgSnapshotIDDate,
  excreason AS CABllbleItmExceptionReason,
  revfrdate AS CABllbleItmRvslReqStartDate,
  crname AS CreatedByUser,
  crdate AS CreationDate,
  crtime AS CreationTime,
  loedt AS CADeletionDate
FROM dfkkbixbit_rev AS bit_rev
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [0..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccountPartner ON ContractAccount = _ContractAccountPartner.ContractAccount AND BusinessPartner = _ContractAccountPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmSrceTransType AS _CABllbleItmSrceTransType ON CABllbleItmSourceTransType = _CABllbleItmSrceTransType.CABllbleItmSourceTransType  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmRvslReqStatus AS _CABllbleItmRvslReqStatus ON CABllbleItmRvslReqStatus = _CABllbleItmRvslReqStatus.CABllbleItmRvslReqStatus  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmExcptnReason AS _CABllbleItmExcptnReason ON CABllbleItmExceptionReason = _CABllbleItmExcptnReason.CABllbleItmExceptionReason  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmStatus AS _CABllbleItmStatus ON CABllbleItmStatus = _CABllbleItmStatus.CABllbleItmStatus  -- association [0..1]
LEFT OUTER JOIN I_CASubApplication AS _CASubApplication ON CASubApplication = _CASubApplication.CASubApplication  -- association [0..1]
LEFT OUTER JOIN I_CABllbleItmClass AS _CABllbleItmClass ON CABllbleItmClass = _CABllbleItmClass.CABllbleItmClass  -- association [0..1]
;