C_CAWriteOffAnalysis

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_CAWriteOffAnalysis.
-- 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: CCAWRITEOFFANL
-- Parameters: P_DisplayCurrency : waers_kk

CREATE VIEW C_CAWriteOffAnalysis AS
SELECT
  CAWriteOffHistory.CAWriteOffDocumentNumber AS CAWriteOffDocumentNumber,
  CAWriteOffHistory.CADocumentNumber AS CADocumentNumber,
  CAWriteOffHistory.CARepetitionItemNumber AS CARepetitionItemNumber,
  CAWriteOffHistory.CASubItemNumber AS CASubItemNumber,
  CAWriteOffHistory.CABPItemNumber AS CABPItemNumber,
  concat(concat(concat( CAWriteOffHistory.CAWriteOffDocumentNumber, CAWriteOffHistory.CADocumentNumber ), concat( CAWriteOffHistory.CARepetitionItemNumber, CAWriteOffHistory.CASubItemNumber )), CAWriteOffHistory.CABPItemNumber ) as CAWriteOffKey AS CABPItemNumberasCAWriteOffKey,
  CAWriteOffHistory.ContractAccount AS ContractAccount,
  CAWriteOffHistory.CADocumentOriginCode AS CADocumentOriginCode,
  CAWriteOffHistory.CAWriteOffReason AS CAWriteOffReason,
  CAWriteOffHistory.BusinessPartner AS BusinessPartner,
  _DocBPItemLogical.CAContract AS CAContract,
  _DocBPItemLogical.CASubApplication AS CASubApplication,
  CAWriteOffHistory.CompanyCode AS CompanyCode,
  CAWriteOffHistory.CAWriteOffDate AS CAWriteOffDate,
  cast( currency_conversion( amount => CAWriteOffHistory.CAAmountInTransactionCurrency, source_currency => CAWriteOffHistory.TransactionCurrency, round => 'X', target_currency => :P_DisplayCurrency, exchange_rate_date => CAWriteOffHistory.CAWriteOffDate, error_handling => 'FAIL_ON_ERROR' ) as abap.curr(23,2)) as AmountInDisplayCurrency AS curr232asAmountInDisplayCurrency,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  _CADunningItem.CALastIssueDate AS CAIssueDate,
  CAWriteOffHistory._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  _ContractAccountHeader.ContractAccountCategory AS ContractAccountCategory,
  CAWriteOffHistory._DocBPItemLogical.BusinessArea AS BusinessArea,
  CAWriteOffHistory._DocBPItemLogical.CAMainTransaction AS CAMainTransaction,
  CAWriteOffHistory._DocBPItemLogical.CASubTransaction AS CASubTransaction,
  CAWriteOffHistory._DocBPItemLogical.CAAccountDeterminationCode AS CAAccountDeterminationCode,
  CAWriteOffHistory._DocBPItemLogical.Division AS Division,
  CAWriteOffHistory._DocBPItemLogical.Segment AS Segment,
  CAWriteOffHistory.CADocumentType AS CADocumentType,
  _CAPartner.CAAuthorizationGroup AS CAAuthorizationGroup,
  _DocBPItemLogical._ProviderContract.CAAuthorizationGroup AS CAProviderContractAuthznGroup
FROM P_CAWriteOffHistoryEnhanced AS CAWriteOffHistory
LEFT OUTER JOIN I_CALastDunningForDocument AS _CADunningItem ON CADocumentNumber = _CADunningItem.CADocumentNumber AND CARepetitionItemNumber = _CADunningItem.CARepetitionItemNumber AND CABPItemNumber = _CADunningItem.CABPItemNumber AND CASubItemNumber = _CADunningItem.CASubItemNumber  -- association [1]
LEFT OUTER JOIN I_ContractAccountHeader AS _ContractAccountHeader ON ContractAccount = _ContractAccountHeader.ContractAccount  -- association [1..1]
LEFT OUTER JOIN I_ContractAccountPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner AND ContractAccount = _CAPartner.ContractAccount  -- association [0..1]
;