R_CustSettlmtListPartner

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

Customer Settlement List Partner

R_CustSettlmtListPartner is a Basic CDS View that provides data about "Customer Settlement List Partner" in SAP S/4HANA. It reads from 1 data source (R_SettlmtMgmtDocPartner) and exposes 26 fields with key fields CustSettlmtList, 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_CustSettlmtList _CustSettlmtList $projection.CustSettlmtList = _CustSettlmtList.CustSettlmtList

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName RWLFCSTSMTLTPART view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Customer Settlement List 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 CustSettlmtList 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
CustSettlmtListPartAddrRefType 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
_CustSettlmtList _CustSettlmtList
_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_CustSettlmtListPartner.
-- 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_CustSettlmtListPartner AS
SELECT
  cast( SettlmtMgmtDoc as wbeln_rb preserving type ) AS CustSettlmtList,
  PartnerFunction,
  PartnerCounter,
  CreatedByUser,
  CreationDate,
  Supplier,
  Customer,
  ContactPerson,
  Personnel,
  AddressID,
  AddressPersonID,
  ReferenceBusinessPartner,
  SettlmtMgmtPartAddrRefType AS CustSettlmtListPartAddrRefType,
  AddressObjectType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  VATRegistration,
  PartnerIsOneTimeAccount
FROM R_SettlmtMgmtDocPartner
LEFT OUTER JOIN R_CustSettlmtList AS _CustSettlmtList ON CustSettlmtList = _CustSettlmtList.CustSettlmtList  -- association [1..1]
;

Learn More