C_AbpPayee

DDL: C_ABPPAYEE SQL: CABPPAYEE Type: view CONSUMPTION Package: ODATA_BANK_PAYMENT_APPROVAL
18 Fields 1 Data Sources 6 Associations

ABP - Payee

C_AbpPayee is a Consumption CDS View that provides data about "ABP - Payee" in SAP S/4HANA. It reads from 1 data source (I_PaymentProposalHeader) and exposes 18 fields with key fields PaymentDocument, PaymentRecipient, PaymentRunDate, PaymentRunID, PaymentRunIsProposal. It has 6 associations to related views. Part of development package ODATA_BANK_PAYMENT_APPROVAL.

Data Sources (1)

SourceAliasJoin Type
I_PaymentProposalHeader _PaymentProposalHeader from

Associations (6)

CardinalityTargetAliasCondition
[0..1] I_AddressPhoneNumber _PhoneNumber _PhoneNumber.AddressID = _PaymentProposalHeader.AddressID and _PhoneNumber.PhoneNumberType = '1'
[0..1] I_AddressPhoneNumber _MobilePhoneNumber _MobilePhoneNumber.AddressID = _PaymentProposalHeader.AddressID and _MobilePhoneNumber.PhoneNumberType = '3'
[0..1] I_AddressEmailAddress _EmailAddress _EmailAddress.AddressID = _PaymentProposalHeader.AddressID
[0..1] I_CountryText _Country _Country.Country = _PaymentProposalHeader.PayeeCountry and _Country.Language = $session.system_language
[0..1] I_Supplier _Supplier _Supplier.Supplier = _PaymentProposalHeader.Supplier
[0..1] I_Customer _Customer _Customer.Customer = _PaymentProposalHeader.Customer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CABPPAYEE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label ABP - Payee view
Search.searchable true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY PaymentDocument I_PaymentProposalHeader PaymentDocument Payment Document Number
KEY PaymentRecipient I_PaymentProposalHeader PaymentRecipient
KEY PaymentRunDate I_PaymentProposalHeader PaymentRunDate
KEY PaymentRunID I_PaymentProposalHeader PaymentRunID
KEY PaymentRunIsProposal I_PaymentProposalHeader PaymentRunIsProposal
KEY PayingCompanyCode I_PaymentProposalHeader PayingCompanyCode Paying Company Code
KEY Supplier I_PaymentProposalHeader Supplier Supplier
KEY Customer I_PaymentProposalHeader Customer Sold-to Party
PayeeName PayeeName
AddressText
Payee I_PaymentProposalHeader Supplier Supplier
PayeeTitle I_PaymentProposalHeader PayeeTitle
PhoneNumber
MobilePhoneNumber
EmailAddress
SupplierAccountGroup _Supplier SupplierAccountGroup Account group
AuthorizationGroup _Supplier AuthorizationGroup AuthorizGroup
_Customer _Customer

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_AbpPayee.
-- 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: CABPPAYEE

CREATE VIEW C_AbpPayee AS
SELECT
  _PaymentProposalHeader.PaymentDocument AS PaymentDocument,
  _PaymentProposalHeader.PaymentRecipient AS PaymentRecipient,
  _PaymentProposalHeader.PaymentRunDate AS PaymentRunDate,
  _PaymentProposalHeader.PaymentRunID AS PaymentRunID,
  _PaymentProposalHeader.PaymentRunIsProposal AS PaymentRunIsProposal,
  _PaymentProposalHeader.PayingCompanyCode AS PayingCompanyCode,
  _PaymentProposalHeader.Supplier AS Supplier,
  _PaymentProposalHeader.Customer AS Customer,
  PayeeName,
  concat_with_space(concat_with_space(concat_with_space(_Country.CountryName, _PaymentProposalHeader.PostalCode,1), PayeeCityName,1),PayeeStreet,1) AS AddressText,
  _PaymentProposalHeader.Supplier AS Payee,
  _PaymentProposalHeader.PayeeTitle AS PayeeTitle,
  concat_with_space(_Supplier._StandardAddress._DefaultPhoneNumber.PhoneNumber, _Supplier._StandardAddress._DefaultPhoneNumber.PhoneNumberExtension, 1) AS PhoneNumber,
  _Supplier._StandardAddress._DefaultMobilePhoneNumber.PhoneNumber AS MobilePhoneNumber,
  cast( _Supplier._StandardAddress._DefaultEmailAddress.EmailAddress as contactcardemailaddress ) AS EmailAddress,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.AuthorizationGroup AS AuthorizationGroup
FROM I_PaymentProposalHeader AS _PaymentProposalHeader
LEFT OUTER JOIN I_AddressPhoneNumber AS _PhoneNumber ON _PhoneNumber.AddressID = _PaymentProposalHeader.AddressID AND _PhoneNumber.PhoneNumberType = '1'  -- association [0..1]
LEFT OUTER JOIN I_AddressPhoneNumber AS _MobilePhoneNumber ON _MobilePhoneNumber.AddressID = _PaymentProposalHeader.AddressID AND _MobilePhoneNumber.PhoneNumberType = '3'  -- association [0..1]
LEFT OUTER JOIN I_AddressEmailAddress AS _EmailAddress ON _EmailAddress.AddressID = _PaymentProposalHeader.AddressID  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _Country ON _Country.Country = _PaymentProposalHeader.PayeeCountry AND _Country.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = _PaymentProposalHeader.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = _PaymentProposalHeader.Customer  -- association [0..1]
;

Learn More