C_CARepaymentRequest

DDL: C_CAREPAYMENTREQUEST SQL: CCAREPAYMENTREQ Type: view CONSUMPTION
62 Fields 1 Data Sources 2 Associations

Consumption view repayment requests

C_CARepaymentRequest is a Consumption CDS View that provides data about "Consumption view repayment requests" in SAP S/4HANA. It reads from 1 data source (I_CARepaymentRequest) and exposes 62 fields with key field CARepaymentRequest. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CARepaymentRequest _CARepaymentRequest from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CARepaymentRequestAddress _Address $projection.CARepaymentRequest = _Address.CARepaymentRequest
[0..*] I_CARepaymentRequestHistory _History $projection.CARepaymentRequest = _History.CARepaymentRequest

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CCAREPAYMENTREQ view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view
EndUserText.label Consumption view repayment requests view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
UI.headerInfo.typeName Repayment Request view
UI.headerInfo.typeNamePlural Repayment Requests view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.label Repayment Request view
UI.headerInfo.title.value CARepaymentRequest view
AccessControl.personalData.blocking #REQUIRED view

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY CARepaymentRequest
CompanyCode I_CARepaymentRequest CompanyCode Receiver Company Code
CompanyCodeName
CAPaymentCompanyCode I_CARepaymentRequest CAPaymentCompanyCode Paying Co. Code
CAPaymentCompanyCodeName
TransactionCurrency I_CARepaymentRequest TransactionCurrency Transaction Currency
CAAmountInTransactionCurrency I_CARepaymentRequest CAAmountInTransactionCurrency Amount
CANetDueDate I_CARepaymentRequest CANetDueDate Net Due Date
PayeeBankCountry I_CARepaymentRequest PayeeBankCountry Bank Ctry/Rgn. Key
PayeeBankCountryName
PayeeBankNumber I_CARepaymentRequest PayeeBankNumber House Bank
PayeeBankAccount I_CARepaymentRequest PayeeBankAccount Bank acct
PayeeBankControlKey I_CARepaymentRequest PayeeBankControlKey To Account
PayeeBankDetailReference I_CARepaymentRequest PayeeBankDetailReference Reference
IsPostBankAccount I_CARepaymentRequest IsPostBankAccount Postbank Acct
CABankAccountHolderName I_CARepaymentRequest CABankAccountHolderName Sold-To Party
HouseBank I_CARepaymentRequest HouseBank House Bank
HouseBankName I_CARepaymentRequest HouseBankName
HouseBankAccount I_CARepaymentRequest HouseBankAccount House Bank Account
HouseBankAccountDescription
CAPaymentMethod I_CARepaymentRequest CAPaymentMethod Payment Method
CAPaymentMethodName
BusinessArea I_CARepaymentRequest BusinessArea Business Area
BusinessAreaName
Segment I_CARepaymentRequest Segment Segment number
SegmentName
ProfitCenter I_CARepaymentRequest ProfitCenter Profit Center
ProfitCenterName
CABankClearingAccount
CAPaymentDocument I_CARepaymentRequest CAPaymentDocument Usage Doc.
CAPostingDate I_CARepaymentRequest CAPostingDate Posting Date
CreatedByUser CreatedByUser User Name
_CreatedByContact _CreatedByContact
CreatedByUserName _CreatedByContact FullName Name
CreationDate I_CARepaymentRequest CreationDate Time Stamp
CreationTime I_CARepaymentRequest CreationTime Time of Change
CANoteToPayeeInPayment I_CARepaymentRequest CANoteToPayeeInPayment Usage Text
CAApplicationArea I_CARepaymentRequest CAApplicationArea ApplicationArea
CARepaymentRequestDocument I_CARepaymentRequest CARepaymentRequestDocument Request Doc.
CAPaymentLockReason I_CARepaymentRequest CAPaymentLockReason Pymt Lock Rsn
ChangedByUserName I_CARepaymentRequest ChangedByUserName User Name
_ChangedByContact _ChangedByContact
LastChangedByUserFullName _ChangedByContact FullName Name
LastChangeDate I_CARepaymentRequest LastChangeDate Time Stamp
LastChangeTime I_CARepaymentRequest LastChangeTime Time changed
CAWorkflowCheckReason I_CARepaymentRequest CAWorkflowCheckReason Check Reason
CAWorkflowCheckReasonName
CARepaymentReqHasAddressData I_CARepaymentRequest CARepaymentReqHasAddressData Address Data
CARpaytReqHasChangedBankData I_CARepaymentRequest CARpaytReqHasChangedBankData Bank Data Explicitly Specified
PayeeIBAN I_CARepaymentRequest PayeeIBAN
PayeeSWIFTCode I_CARepaymentRequest PayeeSWIFTCode
CARepaymentRequestIsReversible
CARepaymentRequestIsChangeable
_Address _Address
FullName Name
AddressLine1 Street / House Number
AddressLine2 Postal Code / City
CountryCode _Address CountryCode Country/Reg.
PayeeCountryName
POBox _Address POBox PO Box
AddressLine3 PO Box Postal Code / City
_History _History

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_CARepaymentRequest.
-- 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: CCAREPAYMENTREQ

CREATE VIEW C_CARepaymentRequest AS
SELECT
  cast(_CARepaymentRequest.CARepaymentRequest as nrzaa_gfn_kk preserving type ) AS CARepaymentRequest,
  _CARepaymentRequest.CompanyCode AS CompanyCode,
  _CARepaymentRequest._CompCode.CompanyCodeName AS CompanyCodeName,
  _CARepaymentRequest.CAPaymentCompanyCode AS CAPaymentCompanyCode,
  _CARepaymentRequest._PayCompCode.CompanyCodeName AS CAPaymentCompanyCodeName,
  _CARepaymentRequest.TransactionCurrency AS TransactionCurrency,
  _CARepaymentRequest.CAAmountInTransactionCurrency AS CAAmountInTransactionCurrency,
  _CARepaymentRequest.CANetDueDate AS CANetDueDate,
  _CARepaymentRequest.PayeeBankCountry AS PayeeBankCountry,
  _CARepaymentRequest._PayeeBankCountry._Text[1:Language = $session.system_language].CountryName AS PayeeBankCountryName,
  _CARepaymentRequest.PayeeBankNumber AS PayeeBankNumber,
  _CARepaymentRequest.PayeeBankAccount AS PayeeBankAccount,
  _CARepaymentRequest.PayeeBankControlKey AS PayeeBankControlKey,
  _CARepaymentRequest.PayeeBankDetailReference AS PayeeBankDetailReference,
  _CARepaymentRequest.IsPostBankAccount AS IsPostBankAccount,
  _CARepaymentRequest.CABankAccountHolderName AS CABankAccountHolderName,
  _CARepaymentRequest.HouseBank AS HouseBank,
  _CARepaymentRequest.HouseBankName AS HouseBankName,
  _CARepaymentRequest.HouseBankAccount AS HouseBankAccount,
  _HouseBankAccount._Text[1: Language=$session.system_language].HouseBankAccountDescription AS HouseBankAccountDescription,
  _CARepaymentRequest.CAPaymentMethod AS CAPaymentMethod,
  _PaymentMethod._Text[1: Language=$session.system_language].CAPaymentMethodName AS CAPaymentMethodName,
  _CARepaymentRequest.BusinessArea AS BusinessArea,
  _CARepaymentRequest._BusinessArea._Text[1:Language = $session.system_language].BusinessAreaName AS BusinessAreaName,
  _CARepaymentRequest.Segment AS Segment,
  _CARepaymentRequest._Segment._Text[1: Language=$session.system_language].SegmentName AS SegmentName,
  _CARepaymentRequest.ProfitCenter AS ProfitCenter,
  _CARepaymentRequest._ProfitCenter._Text[1: Language=$session.system_language].ProfitCenterName AS ProfitCenterName,
  cast(_CARepaymentRequest.CABankClearingAccount as rzako_gfn_kk preserving type ) AS CABankClearingAccount,
  _CARepaymentRequest.CAPaymentDocument AS CAPaymentDocument,
  _CARepaymentRequest.CAPostingDate AS CAPostingDate,
  CreatedByUser,
  _CreatedByContact.FullName AS CreatedByUserName,
  _CARepaymentRequest.CreationDate AS CreationDate,
  _CARepaymentRequest.CreationTime AS CreationTime,
  _CARepaymentRequest.CANoteToPayeeInPayment AS CANoteToPayeeInPayment,
  _CARepaymentRequest.CAApplicationArea AS CAApplicationArea,
  _CARepaymentRequest.CARepaymentRequestDocument AS CARepaymentRequestDocument,
  _CARepaymentRequest.CAPaymentLockReason AS CAPaymentLockReason,
  _CARepaymentRequest.ChangedByUserName AS ChangedByUserName,
  _ChangedByContact.FullName AS LastChangedByUserFullName,
  _CARepaymentRequest.LastChangeDate AS LastChangeDate,
  _CARepaymentRequest.LastChangeTime AS LastChangeTime,
  _CARepaymentRequest.CAWorkflowCheckReason AS CAWorkflowCheckReason,
  _WorkflowCheckReason._Text[1: Language=$session.system_language].CAWorkflowCheckReasonName AS CAWorkflowCheckReasonName,
  _CARepaymentRequest.CARepaymentReqHasAddressData AS CARepaymentReqHasAddressData,
  _CARepaymentRequest.CARpaytReqHasChangedBankData AS CARpaytReqHasChangedBankData,
  _CARepaymentRequest.PayeeIBAN AS PayeeIBAN,
  _CARepaymentRequest.PayeeSWIFTCode AS PayeeSWIFTCode,
  cast ('' as xfeld) AS CARepaymentRequestIsReversible,
  cast ('' as xfeld) AS CARepaymentRequestIsChangeable,
  concat_with_space( _Address.FirstName,_Address.LastName, 1) AS FullName,
  concat_with_space( _Address.StreetName, _Address.HouseNumber, 1) AS AddressLine1,
  concat_with_space( _Address.PostalCode, _Address.CityName, 1) AS AddressLine2,
  _Address.CountryCode AS CountryCode,
  _Address._PayeeCountry._Text[1:Language = $session.system_language].CountryName AS PayeeCountryName,
  _Address.POBox AS POBox,
  concat_with_space( _Address.POBoxPostalCode, _Address.POBoxCityName, 1) AS AddressLine3
FROM I_CARepaymentRequest AS _CARepaymentRequest
LEFT OUTER JOIN I_CARepaymentRequestAddress AS _Address ON CARepaymentRequest = _Address.CARepaymentRequest  -- association [0..1]
LEFT OUTER JOIN I_CARepaymentRequestHistory AS _History ON CARepaymentRequest = _History.CARepaymentRequest  -- association [0..*]
;

Learn More