R_SettlmtDocPartner

DDL: R_SETTLMTDOCPARTNER Type: view BASIC
29 Fields 1 Data Sources 1 Associations

Settlement Document Partner

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

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName RWLFSTDOCPART view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Settlement Document 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 (29)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDoc 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
SettlmtDocPartAddrRefType 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
SettlmtDocPrtnHierarchyLevel SettlmtMgmtDocPrtnHierLevel
SettlmtDocPrtnHierFixedLevel SettlmtMgmtDocPrtnHierFxdLevel
_SettlmtDoc _SettlmtDoc
_PartnerFunction _PartnerFunction
_Supplier _Supplier
_Customer _Customer
_ContactPerson _ContactPerson
_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_SettlmtDocPartner.
-- 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_SettlmtDocPartner AS
SELECT
  cast( SettlmtMgmtDoc as wbeln_zr preserving type ) AS SettlmtDoc,
  PartnerFunction,
  PartnerCounter,
  CreatedByUser,
  CreationDate,
  Supplier,
  Customer,
  ContactPerson,
  Personnel,
  AddressID,
  AddressPersonID,
  ReferenceBusinessPartner,
  SettlmtMgmtPartAddrRefType AS SettlmtDocPartAddrRefType,
  AddressObjectType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  VATRegistration,
  PartnerIsOneTimeAccount,
  SettlmtMgmtDocPrtnHierLevel AS SettlmtDocPrtnHierarchyLevel,
  SettlmtMgmtDocPrtnHierFxdLevel AS SettlmtDocPrtnHierFixedLevel
FROM R_SettlmtMgmtDocPartner
LEFT OUTER JOIN R_SettlmtDoc AS _SettlmtDoc ON SettlmtDoc = _SettlmtDoc.SettlmtDoc  -- association [1..1]
;

Learn More