R_CustSettlmtPartner

DDL: R_CUSTSETTLMTPARTNER Type: view BASIC
26 Fields 1 Data Sources 1 Associations

Customer Settlement Partner

R_CustSettlmtPartner is a Basic CDS View that provides data about "Customer Settlement Partner" in SAP S/4HANA. It reads from 1 data source (R_SettlmtMgmtDocPartner) and exposes 26 fields with key fields CustSettlmt, PartnerFunction, PartnerCounter. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_SettlmtMgmtDocPartner R_SettlmtMgmtDocPartner from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_CustSettlmt _CustSettlmt $projection.CustSettlmt = _CustSettlmt.CustSettlmt

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName RWLFCUSTSMTPART view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Customer Settlement Partner view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey PartnerCounter view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CustSettlmt Document Number
KEY PartnerFunction PartnerFunction Partner Functn
KEY PartnerCounter PartnerCounter Partner counter
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
Supplier Supplier Supplier
Customer Customer Sold-to Party
ContactPerson ContactPerson Contact Person Key
Personnel Personnel Personnel No.
AddressID AddressID Ship-to address
AddressPersonID AddressPersonID Person Number
ReferenceBusinessPartner ReferenceBusinessPartner Busn. Partner
CustSettlmtPartAddrRefType SettlmtMgmtPartAddrRefType
AddressObjectType AddressObjectType Address Type
BPAddrDeterminationTransaction BPAddrDeterminationTransaction Address Detn
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
VATRegistration VATRegistration VAT Registration No.
PartnerIsOneTimeAccount PartnerIsOneTimeAccount One-time acct
_CustSettlmt _CustSettlmt
_PartnerFunction _PartnerFunction
_Supplier _Supplier
_Customer _Customer
_DfltAddrRprstn _DfltAddrRprstn
_BusinessPartnerAddress _BusinessPartnerAddress
_PersonWorkplaceAddrDfltRprstn _PersonWorkplaceAddrDfltRprstn
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr

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 R_CustSettlmtPartner.
-- 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 R_CustSettlmtPartner AS
SELECT
  cast( SettlmtMgmtDoc as wbeln_cu preserving type ) AS CustSettlmt,
  PartnerFunction,
  PartnerCounter,
  CreatedByUser,
  CreationDate,
  Supplier,
  Customer,
  ContactPerson,
  Personnel,
  AddressID,
  AddressPersonID,
  ReferenceBusinessPartner,
  SettlmtMgmtPartAddrRefType AS CustSettlmtPartAddrRefType,
  AddressObjectType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  VATRegistration,
  PartnerIsOneTimeAccount
FROM R_SettlmtMgmtDocPartner
LEFT OUTER JOIN R_CustSettlmt AS _CustSettlmt ON CustSettlmt = _CustSettlmt.CustSettlmt  -- association [1..1]
;

Learn More