I_CAInvcgDocReversalRequest

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_CAInvcgDocReversalRequest.
-- 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: ICAINVDOCREV

CREATE VIEW I_CAInvcgDocReversalRequest AS
SELECT
  invdocno AS CAInvoicingDocument,
  revtask AS CARvslTsk,
  status AS CAReversalRequestStatus,
  revreason AS CAInvcgDocumentReversalReason,
  stodt AS CAReversalRequestDate,
  inv_type AS CAInvcgType,
  inv_process AS CAInvcgProcess,
  inv_category AS CAInvcgCategory,
  gpart AS BusinessPartner,
  gpart_sel AS CABusinessPartnerDocRlvt,
  vkont AS ContractAccount,
  vkont_sel AS CAContractAccountDocRlvt,
  mdcat AS CAInvcgMasterDataType,
  invdoc_crdate AS CAInvcgCreationDate,
  invdoc_crtime AS CAInvcgCreationTime,
  invpercat AS CAInvcgDocPeriodCategory,
  invperiod AS CAInvcgDocPeriodDate,
  faedn AS CANetDueDate,
  total_curr AS TransactionCurrency,
  total_amt AS CAAmountInTransactionCurrency,
  crname AS CreatedByUser,
  crdate AS CreationDate,
  crtime AS CreationTime,
  loedt AS CADeletionDate,
  _CAApplicationArea.CAApplicationArea AS CAApplicationArea
FROM dfkkinvdoc_rev AS invdoc_rev
LEFT OUTER JOIN I_CAApplicationArea AS _CAApplicationArea ON CAApplicationArea = _CAApplicationArea.CAApplicationArea  -- association [1..1]
LEFT OUTER JOIN I_CAInvcgDocReversalReason AS _CAInvcgDocReversalReason ON CAInvcgDocumentReversalReason = _CAInvcgDocReversalReason.CAInvcgDocumentReversalReason  -- association [0..1]
LEFT OUTER JOIN I_CAReversalRequestStatus AS _CAReversalRequestStatus ON CAReversalRequestStatus = _CAReversalRequestStatus.CAReversalRequestStatus  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgProcess AS _CAInvcgProcess ON CAInvcgProcess = _CAInvcgProcess.CAInvcgProcess AND CAApplicationArea = _CAInvcgProcess.CAApplicationArea  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgType AS _CAInvcgType ON CAInvcgType = _CAInvcgType.CAInvcgType AND CAApplicationArea = _CAInvcgType.CAApplicationArea  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgCategory AS _CAInvcgCategory ON CAInvcgCategory = _CAInvcgCategory.CAInvcgCategory  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgMasterDataType AS _CAInvcgMasterDataType ON CAInvcgMasterDataType = _CAInvcgMasterDataType.CAInvcgMasterDataType  -- association [0..1]
LEFT OUTER JOIN I_CAInvcgPeriodCat AS _CAInvcgPeriodCat ON CAInvcgDocPeriodCategory = _CAInvcgPeriodCat.CAInvcgPeriodCategory  -- association [0..1]
;