I_CABillgDocReversalRequest

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_CABillgDocReversalRequest.
-- 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_CABillgDocReversalRequest AS
SELECT
  billdocno AS CABillgDocument,
  revtask AS CABillgDocReversalTask,
  status AS CAReversalRequestStatus,
  revreason AS CABillgDocumentReversalReason,
  srcprocess AS CABillgDocOriginProcess,
  bill_process AS CABillgProcess,
  bill_type AS CABillgType,
  gpart AS BusinessPartner,
  vkont AS ContractAccount,
  mdcat AS CAInvcgMasterDataType,
  billdoc_crdate AS CABillgDocCreationDate,
  billdoc_crtime AS CABillgDocCreationTime,
  crname AS CreatedByUser,
  crdate AS CreationDate,
  crtime AS CreationTime,
  loedt AS CADeletionDate
FROM dfkkinvbill_rev AS invbill_rev
LEFT OUTER JOIN I_CABillgDocHeader AS _CABillgDocHeader ON CABillgDocument = _CABillgDocHeader.CABillgDocument  -- association [0..1]
LEFT OUTER JOIN I_CAReversalRequestStatus AS _CAReversalRequestStatus ON CAReversalRequestStatus = _CAReversalRequestStatus.CAReversalRequestStatus  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgMasterDataType AS _CAInvcgMasterDataType ON CAInvcgMasterDataType = _CAInvcgMasterDataType.CAInvcgMasterDataType  -- association [0..1]
LEFT OUTER JOIN I_CABillgDocReversalReason AS _CABillgDocReversalReason ON CABillgDocumentReversalReason = _CABillgDocReversalReason.CABillgDocumentReversalReason  -- association [0..1]
LEFT OUTER JOIN I_CABillgDocOriginProcess AS _CABillgDocOriginProcess ON CABillgDocOriginProcess = _CABillgDocOriginProcess.CABillgDocOriginProcess  -- association [0..1]
LEFT OUTER JOIN I_CABillgProcess AS _CABillgProcess ON CABillgProcess = _CABillgProcess.CABillgProcess  -- association [0..1]
LEFT OUTER JOIN I_CABillgType AS _CABillgType ON CABillgType = _CABillgType.CABillgType  -- association [0..1]
;