I_CAReturnActivity

DDL: I_CARETURNACTIVITY SQL: ICARETURNACT Type: view COMPOSITE
46 Fields 1 Data Sources 2 Associations

Return Activity

I_CAReturnActivity is a Composite CDS View that provides data about "Return Activity" in SAP S/4HANA. It reads from 1 data source (I_CAReturnHistory) and exposes 46 fields with key fields BusinessPartner, ContractAccount, CAReturnDocumentNumber. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CAReturnHistory I_CAReturnHistory from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CAReturnLot _ReturnLot $projection.CAReturnLot = _ReturnLot.CAReturnLot
[0..1] I_CAReturnLotItem _ReturnLotItem $projection.CAReturnLot = _ReturnLotItem.CAReturnLot and $projection.CAItemNumberInReturnLot = _ReturnLotItem.CAItemNumberInReturnLot

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICARETURNACT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Return Activity view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view

Fields (46)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner Issuing Authority
KEY ContractAccount ContractAccount Contract Acct
KEY CAReturnDocumentNumber CAReturnDocumentNumber Returns Doc.
CAReturnLot CAReturnLot Returns lot
CAItemNumberInReturnLot CAItemNumberInReturnLot Item
TransactionCurrency TransactionCurrency Transaction Currency
CABankAccountOfBusinessPartner CABankAccountOfBusinessPartner Bank acct
CABankNumberOfBusinessPartner CABankNumberOfBusinessPartner BP bank number
CABankingCountryOfBusPart CABankingCountryOfBusPart House Bank
IBAN IBAN IBAN House Bank
CANumberOfReturnedCheque CANumberOfReturnedCheque Check number
CAReturnReason CAReturnReason Return Reason
CADocumentNumber CADocumentNumber Document Number
DocumentDate DocumentDate Journal Entry Date
CAReturnAmount
CAReturnCharge1
CATaxAmountForReturnCharge1
CompanyCode _ReturnLotItem CompanyCode Receiver Company Code
CANumberOfRetsInObsvnPerd CANumberOfRetsInObsvnPerd No. of Retrns
CACreditWorthiness CACreditWorthiness FI-CA Creditwth
CAToleranceGroup CAToleranceGroup Tolerance group
CABankChargeIsPassedOnBP CABankChargeIsPassedOnBP Pass charges on
CAGraduatedChargeIsCalculated CAGraduatedChargeIsCalculated Calc.Grad.Chrge
CABankDetailsAreDeleted CABankDetailsAreDeleted Delete bank det
CADeferralDays CADeferralDays Deferral days
CADeferralDate CADeferralDate Deferral To
CADunningLockReasonForLineItem CADunningLockReasonForLineItem Item Dun. Locks
CADurationInDaysOfDunLockItem CADurationInDaysOfDunLockItem Item dun lock:days
CAPaymentLockReasonForLineItem CAPaymentLockReasonForLineItem Item Pymt Locks
CADurationInDaysOfIncgPaytLock CADurationInDaysOfIncgPaytLock Lock duration days
CADunningLockRsnForContrAcct CADunningLockRsnForContrAcct CA Dunning Lock
CADurnInDaysOfContrAcctDunLock CADurnInDaysOfContrAcctDunLock Dun lock: days
CAIncgPayLockRsnForContrAcct CAIncgPayLockRsnForContrAcct Inc. Pmt Lock
CADurnOfContrAcctIncgPaytLock CADurnOfContrAcctIncgPaytLock Lock duration days
CAOutgPayLockRsnForContrAcct CAOutgPayLockRsnForContrAcct Out. payt lock
CADurnOfContrAcctOutgPaytLock CADurnOfContrAcctOutgPaytLock Lock Duration Days
CAPaymentMethodForIncgPayment CAPaymentMethodForIncgPayment Inc.Payt Method
CAChargeIsPostedStatistically CAChargeIsPostedStatistically Stat. charges
CAEvtForChggMDIsActivated CAEvtForChggMDIsActivated Change Master
CASpecialistWillBeInformed CASpecialistWillBeInformed Inform Spec.
CAEvtForCrtnCorrespncIsActvtd CAEvtForCrtnCorrespncIsActvtd Create Corr.
CAPaymentMethodInItemIsDeleted CAPaymentMethodInItemIsDeleted Del. Pymt Method
CAPaytMethInItemCanBeChanged CAPaytMethInItemCanBeChanged Change Item PM
CAWriteToInfoCtnIsActivated CAWriteToInfoCtnIsActivated InfoContain
CADocumentType _ReturnLotItem CADocumentType Document Type
BankChargeIsIncludingTax _ReturnLot BankChargeIsIncludingTax

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_CAReturnActivity.
-- 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: ICARETURNACT

CREATE VIEW I_CAReturnActivity AS
SELECT
  BusinessPartner,
  ContractAccount,
  CAReturnDocumentNumber,
  CAReturnLot,
  CAItemNumberInReturnLot,
  TransactionCurrency,
  CABankAccountOfBusinessPartner,
  CABankNumberOfBusinessPartner,
  CABankingCountryOfBusPart,
  IBAN,
  CANumberOfReturnedCheque,
  CAReturnReason,
  CADocumentNumber,
  DocumentDate,
  abs(CAPartialAmountOfReturn ) AS CAReturnAmount,
  abs( CAReturnCharge1 ) AS CAReturnCharge1,
  abs(CATaxAmountForReturnCharge1 ) AS CATaxAmountForReturnCharge1,
  _ReturnLotItem.CompanyCode AS CompanyCode,
  CANumberOfRetsInObsvnPerd,
  CACreditWorthiness,
  CAToleranceGroup,
  CABankChargeIsPassedOnBP,
  CAGraduatedChargeIsCalculated,
  CABankDetailsAreDeleted,
  CADeferralDays,
  CADeferralDate,
  CADunningLockReasonForLineItem,
  CADurationInDaysOfDunLockItem,
  CAPaymentLockReasonForLineItem,
  CADurationInDaysOfIncgPaytLock,
  CADunningLockRsnForContrAcct,
  CADurnInDaysOfContrAcctDunLock,
  CAIncgPayLockRsnForContrAcct,
  CADurnOfContrAcctIncgPaytLock,
  CAOutgPayLockRsnForContrAcct,
  CADurnOfContrAcctOutgPaytLock,
  CAPaymentMethodForIncgPayment,
  CAChargeIsPostedStatistically,
  CAEvtForChggMDIsActivated,
  CASpecialistWillBeInformed,
  CAEvtForCrtnCorrespncIsActvtd,
  CAPaymentMethodInItemIsDeleted,
  CAPaytMethInItemCanBeChanged,
  CAWriteToInfoCtnIsActivated,
  _ReturnLotItem.CADocumentType AS CADocumentType,
  _ReturnLot.BankChargeIsIncludingTax AS BankChargeIsIncludingTax
FROM I_CAReturnHistory
LEFT OUTER JOIN I_CAReturnLot AS _ReturnLot ON CAReturnLot = _ReturnLot.CAReturnLot  -- association [1..1]
LEFT OUTER JOIN I_CAReturnLotItem AS _ReturnLotItem ON CAReturnLot = _ReturnLotItem.CAReturnLot AND CAItemNumberInReturnLot = _ReturnLotItem.CAItemNumberInReturnLot  -- association [0..1]
;

Learn More