I_CADisputeCaseFllwUpPosting

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_CADisputeCaseFllwUpPosting.
-- 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: ICADCFLLWUP

CREATE VIEW I_CADisputeCaseFllwUpPosting AS
SELECT
  _CADocumentHeader.CADocumentNumber AS CADocumentNumber,
  _DisputedObject.CaseUniqueID AS CaseUniqueID,
  I_CADisputeCaseAmountChange.CADisputedAmountType AS CADisputedAmountType,
  _DisputedObject.ObjectType AS ObjectType,
  _DisputedObject.ObjectKey AS ObjectKey,
  _DisputedObject.RelationshipNumber AS RelationshipNumber,
  _DisputedObject.RelationToLinkedObject AS RelationToLinkedObject,
  cast(_CADocumentHeader.CreationDate as erdat preserving type ) AS CreationDate,
  cast(_CADocumentHeader.CreationTime as crtime_kk preserving type ) AS CreationTime,
  _CADocumentHeader.CADocumentOriginCodeName AS CADocumentOriginCodeName,
  CADisputeAmount AS CAAmountInTransactionCurrency,
  I_CADisputeCaseAmountChange.TransactionCurrency AS TransactionCurrency,
  _CADocumentHeader.CreatedByUser AS CreatedByUser,
  _CADocumentHeader.CADocumentOriginCode AS CADocumentOriginCode,
  cast('' as hvorg_kk ) AS CAMainTransaction,
  cast('' as tvorg_gfn_kk ) AS CASubTransaction,
  cast('' as hvorg_txt ) AS CAMainTransactionName,
  cast('' as tvorg_txt ) AS CASubTransactionName,
  CADisputedAmountTypeName,
  _CADocumentHeader.CAReversalDocumentNumber AS CAReversalDocumentNumber,
  _CADocumentHeader.CAReversedDocumentNumber AS CAReversedDocumentNumber,
  _Case.CADisputeType AS CADisputeType,
  _DisputedObject.BusinessPartner AS BusinessPartner,
  _DisputedObject.ContractAccount AS ContractAccount
FROM I_CADisputeCaseAmountChange
LEFT OUTER JOIN I_CADocumentHeader AS _CADocumentHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_CADisputeCase AS _Case ON /* join condition not captured in parsed metadata */
INNER JOIN I_CADisputedObject AS _DisputedObject ON /* join condition not captured in parsed metadata */
INNER JOIN I_CADisputedPaymentInfo AS _DisputedPaymentInfo ON /* join condition not captured in parsed metadata */
;