N_CAReturnHistory

DDL: N_CARETURNHISTORY Type: view_entity Package: FKK_ESH
18 Fields 1 Data Sources 1 Associations

Contract Accounting Returns History

N_CAReturnHistory is a CDS View that provides data about "Contract Accounting Returns History" in SAP S/4HANA. It reads from 1 data source (I_CAReturnHistory) and exposes 18 fields with key fields BusinessPartner, ContractAccount, CAReturnDocumentNumber. It has 1 association to related views. Part of development package FKK_ESH.

Data Sources (1)

SourceAliasJoin Type
I_CAReturnHistory I_CAReturnHistory from

Associations (1)

CardinalityTargetAliasCondition
[1..*] N_CADocHasBeenReversedText _CADocHasBeenReversedText $projection.CADocumentHasBeenReversed = _CADocHasBeenReversedText.CADocumentHasBeenReversed

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Contract Accounting Returns History view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.auxiliaryEntity.for.entity I_CAReturnHistory view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner BusinessPartner Issuing Authority
KEY ContractAccount ContractAccount Contract Acct
KEY CAReturnDocumentNumber CAReturnDocumentNumber Returns Doc.
CAReturnLot CAReturnLot Returns lot
CADocumentNumber CADocumentNumber Document Number
CAPartialAmountOfReturn CAPartialAmountOfReturn Partial Amount
CAReturnAmount CAReturnAmount Return amount
TransactionCurrency TransactionCurrency Transaction Currency
CAPostingDate CAPostingDate Posting Date
CAReturnReason CAReturnReason Return Reason
CADocumentHasBeenReversed CADocumentHasBeenReversed Type of posting
CompanyCode CompanyCode Receiver Company Code
BusinessArea BusinessArea Business Area
CADocumentHasBeenReversedName
CAReturnReasonName
ContractAccountName _ContractAccount ContractAccountName Cont. acct name
IsBusinessPurposeCompleted _BusinessPartner IsBusinessPurposeCompleted Purpose Completed
CAAuthorizationGroup _ContractAccountPartner CAAuthorizationGroup AuthorizGroup

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 N_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.

CREATE VIEW N_CAReturnHistory AS
SELECT
  BusinessPartner,
  ContractAccount,
  CAReturnDocumentNumber,
  CAReturnLot,
  CADocumentNumber,
  CAPartialAmountOfReturn,
  CAReturnAmount,
  TransactionCurrency,
  CAPostingDate,
  CAReturnReason,
  CADocumentHasBeenReversed,
  CompanyCode,
  BusinessArea,
  _CADocHasBeenReversedText[1: Language = $session.system_language].CADocumentHasBeenReversedName AS CADocumentHasBeenReversedName,
  _CAReturnReason._Text[1: Language = $session.system_language].CAReturnReasonName AS CAReturnReasonName,
  _ContractAccount.ContractAccountName AS ContractAccountName,
  _BusinessPartner.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _ContractAccountPartner.CAAuthorizationGroup AS CAAuthorizationGroup
FROM I_CAReturnHistory
LEFT OUTER JOIN N_CADocHasBeenReversedText AS _CADocHasBeenReversedText ON CADocumentHasBeenReversed = _CADocHasBeenReversedText.CADocumentHasBeenReversed  -- association [1..*]
;

Learn More