R_SettlmtDocListPartner

DDL: R_SETTLMTDOCLISTPARTNER Type: view BASIC
26 Fields 1 Data Sources

Settlement Document List Partner

R_SettlmtDocListPartner is a Basic CDS View that provides data about "Settlement Document List Partner" in SAP S/4HANA. It reads from 1 data source (R_SettlmtMgmtDocPartner) and exposes 26 fields with key fields SettlmtDocList, PartnerFunction, PartnerCounter.

Data Sources (1)

SourceAliasJoin Type
R_SettlmtMgmtDocPartner R_SettlmtMgmtDocPartner from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName RWLFSMTDCLSTPART view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Settlement Document 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 SettlmtDocList 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
SettlmtDocListPartAddrRefType 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
_SettlmtDocList _SettlmtDocList
_PartnerFunction _PartnerFunction
_Customer _Customer
_Supplier _Supplier
_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_SettlmtDocListPartner.
-- 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_SettlmtDocListPartner AS
SELECT
  cast( SettlmtMgmtDoc as wbeln_rl preserving type ) AS SettlmtDocList,
  PartnerFunction,
  PartnerCounter,
  CreatedByUser,
  CreationDate,
  Supplier,
  Customer,
  ContactPerson,
  Personnel,
  AddressID,
  AddressPersonID,
  ReferenceBusinessPartner,
  SettlmtMgmtPartAddrRefType AS SettlmtDocListPartAddrRefType,
  AddressObjectType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  VATRegistration,
  PartnerIsOneTimeAccount
FROM R_SettlmtMgmtDocPartner
;

Learn More