C_CAPaytRunSrchPaymentOrder

DDL: C_CAPAYTRUNSRCHPAYMENTORDER SQL: CCAPAYSRCHPAYORD Type: view CONSUMPTION
66 Fields 1 Data Sources 1 Associations

Zahlungsauftrag

C_CAPaytRunSrchPaymentOrder is a Consumption CDS View that provides data about "Zahlungsauftrag" in SAP S/4HANA. It reads from 1 data source (C_CAPaymentRunSearch) and exposes 66 fields with key fields CAMassRunDate, CAMassRunID, CAIntPaymentIdentification, CAIntAddlPaymentIdentification. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
C_CAPaymentRunSearch C_CAPaymentRunSearch from

Associations (1)

CardinalityTargetAliasCondition
[1..*] C_CAPaymentRunSearchPaidItem _PaidItem $projection.CAMassRunDate = _PaidItem.CAMassRunDate and $projection.CAMassRunID = _PaidItem.CAMassRunID and $projection.CAIntPaymentIdentification = _PaidItem.CAIntPaymentIdentification and $projection.CAIntAddlPaymentIdentification = _PaidItem.CAIntAddlPaymentIdentification

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CCAPAYSRCHPAYORD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Zahlungsauftrag view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (66)

KeyFieldSource TableSource FieldDescription
KEY CAMassRunDate CAMassRunDate Zahllaufdatum
KEY CAMassRunID CAMassRunID Zahllauf-ID
KEY CAIntPaymentIdentification CAIntPaymentIdentification
KEY CAIntAddlPaymentIdentification CAIntAddlPaymentIdentification
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerFullName BusinessPartnerFullName Broker Name
ContractAccount ContractAccount Contract Acct
ContractAccountName ContractAccountName Cont. acct name
CAPaymentDocumentReference CAPaymentDocumentReference
CAPaymentDocumentType CAPaymentDocumentType
CAPaymentDocumentTypeName CAPaymentDocumentTypeName
CADocumentNumber CADocumentNumber Document Number
CAPaymentOrder CAPaymentOrder
CARepaymentRequest CARepaymentRequest
CASEPAPreNotificationNumber CASEPAPreNotificationNumber Pre-Notif.
PayeeCountryName PayeeCountryName
PayeeCountry PayeeCountry
AddressLine2 AddressLine2 PLZ / Ort
AddressLine1 AddressLine1 Straße / Nr.
TransactionCurrency TransactionCurrency Transaction Currency
PaidAmountInPaytCurrency PaidAmountInPaytCurrency Payment Amount
ValueDate ValueDate Value Date
CAPaymentMethodName CAPaymentMethodName
CAPaymentMethod CAPaymentMethod Payment Method
PaidItemBusinessPartner PaidItemBusinessPartner
PaidItemContractAccount PaidItemContractAccount
CAContract CAContract Contract
DocumentDate DocumentDate Journal Entry Date
CADocumentTypeName CADocumentTypeName
CADocumentType CADocumentType Document Type
CAReturnReason CAReturnReason Return Reason
CAReturnReasonName CAReturnReasonName
CAReversalDocumentNumber CAReversalDocumentNumber Revers.document
CAPaymentOrderStatus CAPaymentOrderStatus Status
CAPaymentOrderStatusName CAPaymentOrderStatusName
CAPaymentDocument CAPaymentDocument Zahlbeleg
CADocumentIsReversed CADocumentIsReversed
PayeeBankName PayeeBankName Bank Name
PayeeBank PayeeBank
PayeeBankCountry PayeeBankCountry
PayeeBankCountryName PayeeBankCountryName
PayeeBankNumber PayeeBankNumber
PayeeBankAccount PayeeBankAccount
PayeeIBAN PayeeIBAN
CABankAccountHolderName CABankAccountHolderName
SWIFTCode SWIFTCode SWIFT/BIC
BankNumber BankNumber Bank Key
BankAccount BankAccount Bank acct
HouseBank HouseBank House Bank
HouseBankName HouseBankName
HouseBankAccount HouseBankAccount House Bank Account
HouseBankAccountDescription HouseBankAccountDescription
BankCountry BankCountry Bank Ctry/Rgn. Key
BankCountryName BankCountryName Country/Region
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName CompanyCodeName Company Name
CAAuthorizationGroup _CAPartner CAAuthorizationGroup AuthorizGroup
CAPaymentSpecificationRef CAPaymentSpecificationRef
CAPromiseToPay CAPromiseToPay
CAPromisedPaymentDate CAPromisedPaymentDate
_PaidItem _PaidItem
_AssocPaymentOrder _AssocPaymentOrder
_BusinessPartner _BusinessPartner
_Currency _Currency
_DocHeader _DocHeader
_PaymentRunItem _PaymentRunItem

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_CAPaytRunSrchPaymentOrder.
-- 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: CCAPAYSRCHPAYORD

CREATE VIEW C_CAPaytRunSrchPaymentOrder AS
SELECT
  CAMassRunDate,
  CAMassRunID,
  CAIntPaymentIdentification,
  CAIntAddlPaymentIdentification,
  BusinessPartner,
  BusinessPartnerFullName,
  ContractAccount,
  ContractAccountName,
  CAPaymentDocumentReference,
  CAPaymentDocumentType,
  CAPaymentDocumentTypeName,
  CADocumentNumber,
  CAPaymentOrder,
  CARepaymentRequest,
  CASEPAPreNotificationNumber,
  PayeeCountryName,
  PayeeCountry,
  AddressLine2,
  AddressLine1,
  TransactionCurrency,
  PaidAmountInPaytCurrency,
  ValueDate,
  CAPaymentMethodName,
  CAPaymentMethod,
  PaidItemBusinessPartner,
  PaidItemContractAccount,
  CAContract,
  DocumentDate,
  CADocumentTypeName,
  CADocumentType,
  CAReturnReason,
  CAReturnReasonName,
  CAReversalDocumentNumber,
  CAPaymentOrderStatus,
  CAPaymentOrderStatusName,
  CAPaymentDocument,
  CADocumentIsReversed,
  PayeeBankName,
  PayeeBank,
  PayeeBankCountry,
  PayeeBankCountryName,
  PayeeBankNumber,
  PayeeBankAccount,
  PayeeIBAN,
  CABankAccountHolderName,
  SWIFTCode,
  BankNumber,
  BankAccount,
  HouseBank,
  HouseBankName,
  HouseBankAccount,
  HouseBankAccountDescription,
  BankCountry,
  BankCountryName,
  CompanyCode,
  CompanyCodeName,
  _CAPartner.CAAuthorizationGroup AS CAAuthorizationGroup,
  CAPaymentSpecificationRef,
  CAPromiseToPay,
  CAPromisedPaymentDate
FROM C_CAPaymentRunSearch
LEFT OUTER JOIN C_CAPaymentRunSearchPaidItem AS _PaidItem ON CAMassRunDate = _PaidItem.CAMassRunDate AND CAMassRunID = _PaidItem.CAMassRunID AND CAIntPaymentIdentification = _PaidItem.CAIntPaymentIdentification AND CAIntAddlPaymentIdentification = _PaidItem.CAIntAddlPaymentIdentification  -- association [1..*]
;

Learn More