What is P_CAReturnHistory in SAP S/4HANA?

P_CAReturnHistory is a composite CDS view in SAP S/4HANA. It contains 106 fields.

Which tables does P_CAReturnHistory read from?

P_CAReturnHistory reads data from: I_CAReturnHistory.

What VDM layer is P_CAReturnHistory?

P_CAReturnHistory is classified as a Composite view that combines data from multiple basic views.

P_CAReturnHistory

DDL: P_CARETURNHISTORY Type: view_entity COMPOSITE

106 Fields 1 Data Sources 3 Associations

P_CAReturnHistory is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_CAReturnHistory) and exposes 106 fields with key fields BusinessPartner, ContractAccount, CAReturnDocumentNumber. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_CAReturnHistory	I_CAReturnHistory	from

Parameters (1)

Name	Type	Default
P_DisplayCurrency	waers_kk

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	I_CABusPartLastWorklistItem	_LastWorklistItem	`$projection.BusinessPartner = _LastWorklistItem.BusinessPartner and _LastWorklistItem.CAFioriApplication = 'F2600A' and _LastWorklistItem.CADocumentBPItemPyblRblCode = $projection.CADocumentBPItemPyblRblCode`
[0..1]	I_CalendarDate	_CAPostingDate	`_CAPostingDate.CalendarDate = $projection.CAPostingDate`
[0..1]	I_CalendarDate	_CAValueDate	`_CAValueDate.CalendarDate = $projection.ValueDate`

Annotations (7)

Name	Value	Level
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MIXED	view
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#REQUIRED	view
VDM.private	true	view
VDM.viewType	#COMPOSITE	view

Fields (106)

Key	Field	Source Table	Source Field	Description
KEY	BusinessPartner	I_CAReturnHistory	BusinessPartner	Issuing Authority
KEY	ContractAccount	I_CAReturnHistory	ContractAccount	Contract Acct
KEY	CAReturnDocumentNumber	I_CAReturnHistory	CAReturnDocumentNumber	Returns Doc.
	BusinessPartnerFullName
	IsBusinessPurposeCompleted
	CAAuthorizationGroup
	CAReturnLot	I_CAReturnHistory	CAReturnLot	Returns lot
	CAItemNumberInReturnLot	I_CAReturnHistory	CAItemNumberInReturnLot	Item
	CADocumentNumber	I_CAReturnHistory	CADocumentNumber	Document Number
	CARepetitionItemNumber
	CABPItemNumber
	CASubItemNumber
	CAReturnReason	I_CAReturnHistory	CAReturnReason	Return Reason
	CompanyCode	I_CAReturnHistory	CompanyCode	Receiver Company Code
	BusinessArea	I_CAReturnHistory	BusinessArea	Business Area
	CAReturnTypeendasCAReturnType
	TransactionCurrency	I_CAReturnHistory	TransactionCurrency	Transaction Currency
	DisplayCurrency
	BPBalanceAmountInDC	_TotalAmounts	BPBalanceAmountInDC
	BPCreditAmountInDC	_TotalAmounts	BPCreditAmountInDC
	BPDebitAmountInDC	_TotalAmounts	BPDebitAmountInDC
	CAPartialAmountOfReturn
	CAChargeAmountFromBank
	CATaxAmountOfBankCharge
	CATaxAmountForReturnCharge
	CAReturnCharge
	NumberOfItems
	DocumentDate	I_CAReturnHistory	DocumentDate	Journal Entry Date
	ValueDate	I_CAReturnHistory	ValueDate	Value Date
	CAPostingDate	I_CAReturnHistory	CAPostingDate	Posting Date
	CalendarYear	_CAPostingDate	CalendarYear	Year
	CalendarQuarter	_CAPostingDate	CalendarQuarter	Calendar Quarter
	CalendarQuarterName
	CalendarMonth	_CAPostingDate	CalendarMonth	Calendar Month
	CalendarMonthName
	CalendarWeek	_CAPostingDate	CalendarWeek	Calendar Week
	ValueDateYear	_CAValueDate	CalendarYear	Year
	ValueDateQuarter	_CAValueDate	CalendarQuarter	Calendar Quarter
	ValueDateQuarterName
	ValueDateMonth	_CAValueDate	CalendarMonth	Calendar Month
	ValueDateMonthName
	ValueDateWeek	_CAValueDate	CalendarWeek	Calendar Week
	IBAN	I_CAReturnHistory	IBAN	IBAN House Bank
	HouseBank	I_CAReturnHistory	HouseBank	House Bank
	HouseBankAccount	I_CAReturnHistory	HouseBankAccount	House Bank Account
	CABankingCountryOfBusPart	I_CAReturnHistory	CABankingCountryOfBusPart	House Bank
	CABankNumberOfBusinessPartner	I_CAReturnHistory	CABankNumberOfBusinessPartner	BP bank number
	CABankAccountOfBusinessPartner	I_CAReturnHistory	CABankAccountOfBusinessPartner	Bank acct
	CANumberOfReturnedCheque	I_CAReturnHistory	CANumberOfReturnedCheque	Check number
	CAPaymentFormNumber	I_CAReturnHistory	CAPaymentFormNumber	Payment Form
	CAPostingTypeOfReturn	I_CAReturnHistory	CAPostingTypeOfReturn	Type of posting
	CAPostingDateOfReversalDoc	I_CAReturnHistory	CAPostingDateOfReversalDoc	Reversal Date
	CANumberOfReverseDocOrResetDoc	I_CAReturnHistory	CANumberOfReverseDocOrResetDoc	Reversed With
	CADocumentHasBeenReversed	I_CAReturnHistory	CADocumentHasBeenReversed	Type of posting
	CANumberOfRetsInObsvnPerd	I_CAReturnHistory	CANumberOfRetsInObsvnPerd	No. of Retrns
	CACreditWorthiness	I_CAReturnHistory	CACreditWorthiness	FI-CA Creditwth
	CAToleranceGroup	I_CAReturnHistory	CAToleranceGroup	Tolerance group
	CABankChargeIsPassedOnBP	I_CAReturnHistory	CABankChargeIsPassedOnBP	Pass charges on
	CAGraduatedChargeIsCalculated	I_CAReturnHistory	CAGraduatedChargeIsCalculated	Calc.Grad.Chrge
	CABankDetailsAreDeleted	I_CAReturnHistory	CABankDetailsAreDeleted	Delete bank det
	CADeferralDays	I_CAReturnHistory	CADeferralDays	Deferral days
	CADeferralDate	I_CAReturnHistory	CADeferralDate	Deferral To
	CADunningLockReasonForLineItem	I_CAReturnHistory	CADunningLockReasonForLineItem	Item Dun. Locks
	CADurationInDaysOfDunLockItem	I_CAReturnHistory	CADurationInDaysOfDunLockItem	Item dun lock:days
	CAPaymentLockReasonForLineItem	I_CAReturnHistory	CAPaymentLockReasonForLineItem	Item Pymt Locks
	CADurationInDaysOfIncgPaytLock	I_CAReturnHistory	CADurationInDaysOfIncgPaytLock	Lock duration days
	CADunningLockRsnForContrAcct	I_CAReturnHistory	CADunningLockRsnForContrAcct	CA Dunning Lock
	CADurnInDaysOfContrAcctDunLock	I_CAReturnHistory	CADurnInDaysOfContrAcctDunLock	Dun lock: days
	CAIncgPayLockRsnForContrAcct	I_CAReturnHistory	CAIncgPayLockRsnForContrAcct	Inc. Pmt Lock
	CADurnOfContrAcctIncgPaytLock	I_CAReturnHistory	CADurnOfContrAcctIncgPaytLock	Lock duration days
	CAOutgPayLockRsnForContrAcct	I_CAReturnHistory	CAOutgPayLockRsnForContrAcct	Out. payt lock
	CADurnOfContrAcctOutgPaytLock	I_CAReturnHistory	CADurnOfContrAcctOutgPaytLock	Lock Duration Days
	CAPaymentMethodForIncgPayment	I_CAReturnHistory	CAPaymentMethodForIncgPayment	Inc.Payt Method
	CAChargeIsPostedStatistically	I_CAReturnHistory	CAChargeIsPostedStatistically	Stat. charges
	CAIncgPaytMethInAcctIsDeltd	I_CAReturnHistory	CAIncgPaytMethInAcctIsDeltd	Delete PymtMeth
	CAOutgPaytMethInAcctIsDeltd	I_CAReturnHistory	CAOutgPaytMethInAcctIsDeltd	Delete outgPMeth
	CAEvtForChggMDIsActivated	I_CAReturnHistory	CAEvtForChggMDIsActivated	Change Master
	CASpecialistWillBeInformed	I_CAReturnHistory	CASpecialistWillBeInformed	Inform Spec.
	CAEvtForCrtnCorrespncIsActvtd	I_CAReturnHistory	CAEvtForCrtnCorrespncIsActvtd	Create Corr.
	CAIncgPaytLockReasonInContract	I_CAReturnHistory	CAIncgPaytLockReasonInContract	IncmPaytLock contr
	CADurnOfIncgPaytLockInContract	I_CAReturnHistory	CADurnOfIncgPaytLockInContract	Lock duration days
	CAOutgPaytLockReasonInContract	I_CAReturnHistory	CAOutgPaytLockReasonInContract	OutgPayt lock contr.
	CADurnOfOutgPaytLockInContract	I_CAReturnHistory	CADurnOfOutgPaytLockInContract	Lock Duration Days
	CADunningLockReasonForContract	I_CAReturnHistory	CADunningLockReasonForContract	Dunn.lock contr
	CADurnOfDunningLockInContract	I_CAReturnHistory	CADurnOfDunningLockInContract	Dun lock: days
	CAPaymentMethodInItemIsDeleted	I_CAReturnHistory	CAPaymentMethodInItemIsDeleted	Del. Pymt Method
	CAPaytMethInItemCanBeChanged	I_CAReturnHistory	CAPaytMethInItemCanBeChanged	Change Item PM
	CAWriteToInfoCtnIsActivated	I_CAReturnHistory	CAWriteToInfoCtnIsActivated	InfoContain
	SWIFTCode	I_CAReturnHistory	SWIFTCode	SWIFT/BIC
	_CAValueDate		_CAValueDate
	_LastWorklistItem		_LastWorklistItem
	_BusinessPartner	I_CAReturnHistory	_BusinessPartner
	_CAReturnDocument	I_CAReturnHistory	_CAReturnDocument
	_CAReturnLot	I_CAReturnHistory	_CAReturnLot
	_CAReturnLotItem	I_CAReturnHistory	_CAReturnLotItem
	_CAReturnReason	I_CAReturnHistory	_CAReturnReason
	_HouseBank	I_CAReturnHistory	_HouseBank
	_CAHeader	I_CAReturnHistory	_CAHeader
	_CAPartner	I_CAReturnHistory	_CAPartner
	_CAAuthorizationGroup
	_Currency	I_CAReturnHistory	_Currency
	_CAPostingDate		_CAPostingDate
	_CalendarYear	_CAPostingDate	_CalendarYear
	_CalendarQuarter	_CAPostingDate	_CalendarQuarter
	_CalendarMonth	_CAPostingDate	_CalendarMonth
	_CalendarWeek	_CAPostingDate	_CalendarWeek

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

CREATE VIEW P_CAReturnHistory AS
SELECT
  I_CAReturnHistory.BusinessPartner AS BusinessPartner,
  I_CAReturnHistory.ContractAccount AS ContractAccount,
  I_CAReturnHistory.CAReturnDocumentNumber AS CAReturnDocumentNumber,
  I_CAReturnHistory._BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  I_CAReturnHistory._BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_CAReturnHistory._CAPartner.CAAuthorizationGroup AS CAAuthorizationGroup,
  I_CAReturnHistory.CAReturnLot AS CAReturnLot,
  I_CAReturnHistory.CAItemNumberInReturnLot AS CAItemNumberInReturnLot,
  I_CAReturnHistory.CADocumentNumber AS CADocumentNumber,
  cast('' as opupw_kk) AS CARepetitionItemNumber,
  cast('' as opupk_kk) AS CABPItemNumber,
  cast('' as opupz_kk) AS CASubItemNumber,
  I_CAReturnHistory.CAReturnReason AS CAReturnReason,
  I_CAReturnHistory.CompanyCode AS CompanyCode,
  I_CAReturnHistory.BusinessArea AS BusinessArea,
  case when I_CAReturnHistory._CAReturnReason.CAReturnType is null then I_CAReturnHistory._CAReturnReasonFallback.CAReturnType when I_CAReturnHistory._CAReturnReason.CAReturnType is not null then I_CAReturnHistory._CAReturnReason.CAReturnType end as CAReturnType AS CAReturnTypeendasCAReturnType,
  I_CAReturnHistory.TransactionCurrency AS TransactionCurrency,
  $parameters.P_DisplayCurrency AS DisplayCurrency,
  _TotalAmounts.BPBalanceAmountInDC AS BPBalanceAmountInDC,
  _TotalAmounts.BPCreditAmountInDC AS BPCreditAmountInDC,
  _TotalAmounts.BPDebitAmountInDC AS BPDebitAmountInDC,
  abs( I_CAReturnHistory.CAPartialAmountOfReturn ) AS CAPartialAmountOfReturn,
  abs( cast( I_CAReturnHistory.CAChargeAmountFromBank1 + I_CAReturnHistory.CAChargeAmountFromBank2 as btrb_gfn_kk ) ) AS CAChargeAmountFromBank,
  abs( cast( I_CAReturnHistory.CATaxAmountOfBankCharge1 + I_CAReturnHistory.CATaxAmountOfBankCharge2 as stbb_gfn_kk ) ) AS CATaxAmountOfBankCharge,
  cast( I_CAReturnHistory.CATaxAmountForReturnCharge1 + I_CAReturnHistory.CATaxAmountForReturnCharge2 as stbv_gfn_kk ) AS CATaxAmountForReturnCharge,
  abs( cast( I_CAReturnHistory.CAReturnCharge1 + I_CAReturnHistory.CAReturnCharge2 as btrv_gfn_kk ) ) AS CAReturnCharge,
  cast(1 as abap.int4) AS NumberOfItems,
  I_CAReturnHistory.DocumentDate AS DocumentDate,
  I_CAReturnHistory.ValueDate AS ValueDate,
  I_CAReturnHistory.CAPostingDate AS CAPostingDate,
  _CAPostingDate.CalendarYear AS CalendarYear,
  _CAPostingDate.CalendarQuarter AS CalendarQuarter,
  _CAPostingDate._CalendarQuarter._Text[1:Language=$session.system_language].CalendarQuarterName AS CalendarQuarterName,
  _CAPostingDate.CalendarMonth AS CalendarMonth,
  _CAPostingDate._CalendarMonth._Text[1:Language=$session.system_language].CalendarMonthName AS CalendarMonthName,
  _CAPostingDate.CalendarWeek AS CalendarWeek,
  _CAValueDate.CalendarYear AS ValueDateYear,
  _CAValueDate.CalendarQuarter AS ValueDateQuarter,
  _CAValueDate._CalendarQuarter._Text[1:Language=$session.system_language].CalendarQuarterName AS ValueDateQuarterName,
  _CAValueDate.CalendarMonth AS ValueDateMonth,
  _CAValueDate._CalendarMonth._Text[1:Language=$session.system_language].CalendarMonthName AS ValueDateMonthName,
  _CAValueDate.CalendarWeek AS ValueDateWeek,
  I_CAReturnHistory.IBAN AS IBAN,
  I_CAReturnHistory.HouseBank AS HouseBank,
  I_CAReturnHistory.HouseBankAccount AS HouseBankAccount,
  I_CAReturnHistory.CABankingCountryOfBusPart AS CABankingCountryOfBusPart,
  I_CAReturnHistory.CABankNumberOfBusinessPartner AS CABankNumberOfBusinessPartner,
  I_CAReturnHistory.CABankAccountOfBusinessPartner AS CABankAccountOfBusinessPartner,
  I_CAReturnHistory.CANumberOfReturnedCheque AS CANumberOfReturnedCheque,
  I_CAReturnHistory.CAPaymentFormNumber AS CAPaymentFormNumber,
  I_CAReturnHistory.CAPostingTypeOfReturn AS CAPostingTypeOfReturn,
  I_CAReturnHistory.CAPostingDateOfReversalDoc AS CAPostingDateOfReversalDoc,
  I_CAReturnHistory.CANumberOfReverseDocOrResetDoc AS CANumberOfReverseDocOrResetDoc,
  I_CAReturnHistory.CADocumentHasBeenReversed AS CADocumentHasBeenReversed,
  I_CAReturnHistory.CANumberOfRetsInObsvnPerd AS CANumberOfRetsInObsvnPerd,
  I_CAReturnHistory.CACreditWorthiness AS CACreditWorthiness,
  I_CAReturnHistory.CAToleranceGroup AS CAToleranceGroup,
  I_CAReturnHistory.CABankChargeIsPassedOnBP AS CABankChargeIsPassedOnBP,
  I_CAReturnHistory.CAGraduatedChargeIsCalculated AS CAGraduatedChargeIsCalculated,
  I_CAReturnHistory.CABankDetailsAreDeleted AS CABankDetailsAreDeleted,
  I_CAReturnHistory.CADeferralDays AS CADeferralDays,
  I_CAReturnHistory.CADeferralDate AS CADeferralDate,
  I_CAReturnHistory.CADunningLockReasonForLineItem AS CADunningLockReasonForLineItem,
  I_CAReturnHistory.CADurationInDaysOfDunLockItem AS CADurationInDaysOfDunLockItem,
  I_CAReturnHistory.CAPaymentLockReasonForLineItem AS CAPaymentLockReasonForLineItem,
  I_CAReturnHistory.CADurationInDaysOfIncgPaytLock AS CADurationInDaysOfIncgPaytLock,
  I_CAReturnHistory.CADunningLockRsnForContrAcct AS CADunningLockRsnForContrAcct,
  I_CAReturnHistory.CADurnInDaysOfContrAcctDunLock AS CADurnInDaysOfContrAcctDunLock,
  I_CAReturnHistory.CAIncgPayLockRsnForContrAcct AS CAIncgPayLockRsnForContrAcct,
  I_CAReturnHistory.CADurnOfContrAcctIncgPaytLock AS CADurnOfContrAcctIncgPaytLock,
  I_CAReturnHistory.CAOutgPayLockRsnForContrAcct AS CAOutgPayLockRsnForContrAcct,
  I_CAReturnHistory.CADurnOfContrAcctOutgPaytLock AS CADurnOfContrAcctOutgPaytLock,
  I_CAReturnHistory.CAPaymentMethodForIncgPayment AS CAPaymentMethodForIncgPayment,
  I_CAReturnHistory.CAChargeIsPostedStatistically AS CAChargeIsPostedStatistically,
  I_CAReturnHistory.CAIncgPaytMethInAcctIsDeltd AS CAIncgPaytMethInAcctIsDeltd,
  I_CAReturnHistory.CAOutgPaytMethInAcctIsDeltd AS CAOutgPaytMethInAcctIsDeltd,
  I_CAReturnHistory.CAEvtForChggMDIsActivated AS CAEvtForChggMDIsActivated,
  I_CAReturnHistory.CASpecialistWillBeInformed AS CASpecialistWillBeInformed,
  I_CAReturnHistory.CAEvtForCrtnCorrespncIsActvtd AS CAEvtForCrtnCorrespncIsActvtd,
  I_CAReturnHistory.CAIncgPaytLockReasonInContract AS CAIncgPaytLockReasonInContract,
  I_CAReturnHistory.CADurnOfIncgPaytLockInContract AS CADurnOfIncgPaytLockInContract,
  I_CAReturnHistory.CAOutgPaytLockReasonInContract AS CAOutgPaytLockReasonInContract,
  I_CAReturnHistory.CADurnOfOutgPaytLockInContract AS CADurnOfOutgPaytLockInContract,
  I_CAReturnHistory.CADunningLockReasonForContract AS CADunningLockReasonForContract,
  I_CAReturnHistory.CADurnOfDunningLockInContract AS CADurnOfDunningLockInContract,
  I_CAReturnHistory.CAPaymentMethodInItemIsDeleted AS CAPaymentMethodInItemIsDeleted,
  I_CAReturnHistory.CAPaytMethInItemCanBeChanged AS CAPaytMethInItemCanBeChanged,
  I_CAReturnHistory.CAWriteToInfoCtnIsActivated AS CAWriteToInfoCtnIsActivated,
  I_CAReturnHistory.SWIFTCode AS SWIFTCode,
  I_CAReturnHistory._BusinessPartner AS _BusinessPartner,
  I_CAReturnHistory._CAReturnDocument AS _CAReturnDocument,
  I_CAReturnHistory._CAReturnLot AS _CAReturnLot,
  I_CAReturnHistory._CAReturnLotItem AS _CAReturnLotItem,
  I_CAReturnHistory._CAReturnReason AS _CAReturnReason,
  I_CAReturnHistory._HouseBank AS _HouseBank,
  I_CAReturnHistory._CAHeader AS _CAHeader,
  I_CAReturnHistory._CAPartner AS _CAPartner,
  I_CAReturnHistory._CAPartner._CAAuthorizationGroup AS _CAAuthorizationGroup,
  I_CAReturnHistory._Currency AS _Currency,
  _CAPostingDate._CalendarYear AS _CalendarYear,
  _CAPostingDate._CalendarQuarter AS _CalendarQuarter,
  _CAPostingDate._CalendarMonth AS _CalendarMonth,
  _CAPostingDate._CalendarWeek AS _CalendarWeek
FROM I_CAReturnHistory
LEFT OUTER JOIN I_CABusPartLastWorklistItem AS _LastWorklistItem ON BusinessPartner = _LastWorklistItem.BusinessPartner AND _LastWorklistItem.CAFioriApplication = 'F2600A' AND _LastWorklistItem.CADocumentBPItemPyblRblCode = CADocumentBPItemPyblRblCode  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CAPostingDate ON _CAPostingDate.CalendarDate = CAPostingDate  -- association [0..1]
LEFT OUTER JOIN I_CalendarDate AS _CAValueDate ON _CAValueDate.CalendarDate = ValueDate  -- association [0..1]
;

Depth:

P_CAReturnHistory view_entity

I_CAReturnHistory view_entity

C_CAReturnHistoryAnalysis view_entity