I_CADisputedDocument

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_CADisputedDocument.
-- 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: ICADCDOC

CREATE VIEW I_CADisputedDocument AS
SELECT
  _DocHeader.CADocumentNumber AS CADocumentNumber,
  _DisputedObject.CaseUniqueID AS CaseUniqueID,
  _DisputedObject.ObjectType AS ObjectType,
  _DisputedObject.ObjectKey AS ObjectKey,
  _DisputedObject.RelationshipNumber AS RelationshipNumber,
  _DisputedObject.RelationToLinkedObject AS RelationToLinkedObject,
  _Doc.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  _DocHeader.TransactionCurrency AS TransactionCurrency,
  cast(' ' as hvorg_kk) AS CAMainTransaction,
  cast(' ' as tvorg_gfn_kk) AS CASubTransaction,
  cast('' as vtref_kk) AS CAContract,
  cast('' as subap_kk) AS CASubApplication,
  _DisputedObject.ContractAccount AS ContractAccount,
  _DisputedObject.BusinessPartner AS BusinessPartner,
  cast('00000000' as faedn_kk) AS CANetDueDate,
  cast('00000000' as studt_kk) AS CADeferralDate,
  cast('00000000' as augdt_kk) AS CAClearingDate,
  cast( '' as augrd_gfn_kk) AS CAClearingReasonName,
  cast(''as augrd_kk) AS CAClearingReason,
  _Doc.OpenAmountInTransCrcy AS OpenAmountInTransCrcy,
  cast('' as hvorg_txt) AS CAMainTransactionName,
  cast('' as tvorg_txt) AS CASubTransactionName,
  cast(_DocHeader.CreationDate as erdat) AS CreationDate,
  cast(_DocHeader.CreationTime as crtime_kk) AS CreationTime,
  cast(_DocHeader.CADocumentOriginCodeName as htext_gfn_kk) AS CADocumentOriginCodeName,
  _DocHeader.CreatedByUser AS CreatedByUser,
  _DocHeader.CADocumentOriginCode AS CADocumentOriginCode,
  _DocHeader.DocumentDate AS DocumentDate,
  _DocHeader.CAPostingDate AS CAPostingDate,
  _DocHeader.CAReferenceDocument AS CAReferenceDocument,
  cast(_DocHeader._DocType._Text[1:Language = $session.system_language].CADocumentTypeName as ltext_003t_gfn) AS CADocumentTypeName,
  _DocHeader.CAReconciliationKey AS CAReconciliationKey,
  _DocHeader.CAReversalDocumentNumber AS CAReversalDocumentNumber,
  _DocHeader.CAReversedDocumentNumber AS CAReversedDocumentNumber,
  _DisputedObject._BusinessPartner AS _BusinessPartner,
  _DisputedObject._ContractAccount AS _ContractAccount
FROM I_CADisputedObject AS _DisputedObject
INNER JOIN I_CADocumentHeader AS _DocHeader ON /* join condition not captured in parsed metadata */
INNER JOIN P_CADisputedDocumentAmount AS _Doc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_User AS _CreatedBy ON CreatedByUser = _CreatedBy.UserID  -- association [0..1]
;