C_CAReturns

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_CAReturns.
-- 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: CCARETURNS
-- Parameters: P_Currency : waers_kk, P_CAInternalAppCode : tileid_kk, P_Language : sylangu, P_Date : sydatum

CREATE VIEW C_CAReturns AS
SELECT
  BusinessPartner,
  ContractAccount,
  CAReturnDocumentNumber,
  CAPostingDate,
  ValueDate,
  CAReturnLot,
  CAReturnReason,
  _CAReturnHistory._CAReturnReason._Text[1:Language = $session.system_language].CAReturnReasonName AS CAReturnReasonName,
  case when _CAReturnHistory._CAReturnReason.CAReturnType is null then _CAReturnHistory._CAReturnReasonFallback.CAReturnType else _CAReturnHistory._CAReturnReason.CAReturnType end as CAReturnType AS CAReturnTypeendasCAReturnType,
  _CAPartner._BusinessPartner.LastName AS LastName,
  _CAPartner._BusinessPartner.FirstName AS FirstName,
  _CAPartner._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _CAPartner._BusinessPartner._CurrentDefaultAddress._AddressDefaultRepresentation.PostalCode AS PostalCode,
  CAReturnAmount,
  abs( CAPartialAmountOfReturn ) AS CAPartialAmountOfReturn,
  cast ( (CAChargeAmountFromBank1 + CAChargeAmountFromBank2 ) as betrr_kk ) AS CAChargeAmountFromBank,
  cast ( (CAReturnCharge1 + CAReturnCharge2) as betrr_kk ) AS CAReturnCharge,
  TransactionCurrency,
  $parameters.P_Currency AS DisplayCurrency,
  HouseBank,
  CABankChargeIsPassedOnBP,
  CAGraduatedChargeIsCalculated,
  CABankDetailsAreDeleted,
  CADeferralDays,
  CADunningLockReasonForLineItem,
  CAPaymentLockReasonForLineItem,
  CADunningLockRsnForContrAcct,
  CAIncgPayLockRsnForContrAcct,
  CAChargeIsPostedStatistically,
  CAPaymentMethodInItemIsDeleted,
  CAPaytMethInItemCanBeChanged,
  CAOutgPayLockRsnForContrAcct,
  CAIncgPaytMethInAcctIsDeltd,
  CAOutgPaytMethInAcctIsDeltd,
  CASpecialistWillBeInformed,
  CAIncgPaytLockReasonInContract,
  CAOutgPaytLockReasonInContract,
  CADunningLockReasonForContract,
  CANumberOfRetsInObsvnPerd,
  CACreditWorthiness,
  CAToleranceGroup,
  CADeferralDate,
  CADurationInDaysOfDunLockItem,
  CADurationInDaysOfIncgPaytLock,
  CADurnInDaysOfContrAcctDunLock,
  CADurnOfContrAcctIncgPaytLock,
  CADurnOfContrAcctOutgPaytLock,
  CAPaymentMethodForIncgPayment,
  CAEvtForChggMDIsActivated,
  CAEvtForCrtnCorrespncIsActvtd,
  CADurnOfIncgPaytLockInContract,
  CADurnOfOutgPaytLockInContract,
  CADurnOfDunningLockInContract,
  CAWriteToInfoCtnIsActivated,
  _DebitsCredits( P_DisplayCurrency : $parameters.P_Currency, P_ExchangeRateDate : $parameters.P_Date ).OpenPayablesAmountInDspCrcy AS CreditAmountInDisplayCrcy,
  _DebitsCredits( P_DisplayCurrency : $parameters.P_Currency, P_ExchangeRateDate : $parameters.P_Date ).OpenReceivablesAmountInDspCrcy AS DebitAmountInDisplayCrcy,
  _LastWorkItem( P_CAInternalAppCode : $parameters.P_CAInternalAppCode, P_Language : $parameters.P_Language ).WorklistItemCreationDate AS WorklistItemCreationDate,
  _LastWorkItem( P_CAInternalAppCode : $parameters.P_CAInternalAppCode, P_Language : $parameters.P_Language ).CAClrfctnStatus AS CAClrfctnStatus,
  _LastWorkItem( P_CAInternalAppCode : $parameters.P_CAInternalAppCode, P_Language : $parameters.P_Language ).CAClrfctnStatusName AS CAClrfctnStatusName,
  _CAReturnHistory._Currency AS _Currency,
  _ContractAccount.CAAuthorizationGroup AS CAAuthorizationGroup
FROM I_CAReturnHistory AS _CAReturnHistory
LEFT OUTER JOIN I_CALastWorklistItem AS _LastWorkItem ON BusinessPartner = _LastWorkItem.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CABPTotalSeparatedAmtsInDC AS _DebitsCredits ON BusinessPartner = _DebitsCredits.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CAContractPartner AS _CAPartner ON BusinessPartner = _CAPartner.BusinessPartner  -- association [1]
LEFT OUTER JOIN I_ContractAccountPartner AS _ContractAccount ON BusinessPartner = _ContractAccount.BusinessPartner AND ContractAccount = _ContractAccount.ContractAccount  -- association [0..1]
;