C_CADocumentReversal

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 C_CADocumentReversal.
-- 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: CCADOCREVERSE

CREATE VIEW C_CADocumentReversal AS
SELECT
  CADocumentNumber,
  cast (CAReferenceDocument as xblnr_gfn_kk preserving type) AS CAReferenceDocument,
  CADocumentType,
  _CADocumentType._Text[1:Language = $session.system_language].CADocumentTypeName AS CADocumentTypeName,
  CADocumentOriginCode,
  _CADocumentOriginCode._Text[1:Language = $session.system_language].CADocumentOriginCodeName AS CADocumentOriginCodeName,
  CAReversedDocumentNumber,
  CAReversalDocumentNumber,
  CreatedByUser,
  _CreatedByContact.FullName AS CreatedByUserName,
  CreationDate,
  CAPostingDate,
  TransactionCurrency,
  DocumentDate,
  cast ('' as xfeld) AS CADocumentIsBlockedForUser,
  _CADocumentIsBlocked.AuthorizationGroup AS AuthorizationGroup,
  _CADocumentIsBlocked.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _CADocumentIsBlocked.CANumberOfAuthorizationGroups AS CANumberOfAuthorizationGroups,
  CAClearingInformation,
  cast('' as xfeld) AS CAClearingDocIsExisting,
  cast('' as xfeld) AS CAClarificationDocIsExisting,
  cast('' as opbel_semobj_kk) AS CADocumentSemanticObject,
  cast('' as xfeld) AS CADocRepetitionItemIsExisting,
  cast('' as xfeld) AS CADocumentRepetitionItemIsOpen,
  cast('' as xfeld) AS ChequeIsExisting,
  cast('X' as xfeld) AS CAAllRepetitionsAreReversed,
  cast('' as xfeld) AS CAPostgToClrfctnAcctIsAllowed,
  CAReconciliationKey,
  CADocumentClass,
  CAApplicationArea
FROM I_CADocumentHeader
LEFT OUTER JOIN I_CADocumentType AS _CADocumentType ON CADocumentType = _CADocumentType.CADocumentType AND CAApplicationArea = _CADocumentType.CAApplicationArea  -- association [1..1]
LEFT OUTER JOIN I_CADocumentOriginCode AS _CADocumentOriginCode ON CADocumentOriginCode = _CADocumentOriginCode.CADocumentOriginCode  -- association [1..1]
LEFT OUTER JOIN C_CAInvcgUserContact AS _CreatedByContact ON CreatedByUser = _CreatedByContact.ContactCardID  -- association [0..1]
LEFT OUTER JOIN P_CADocumentIsBlocked AS _CADocumentIsBlocked ON CADocumentNumber = _CADocumentIsBlocked.CADocumentNumber  -- association [0..1]
LEFT OUTER JOIN E_CADocumentHeader AS _Extension ON CADocumentNumber = _Extension.CADocumentNumber  -- association [1..1]
;