R_ExpnSettlmtPartner

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

Expense Settlement Partner

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

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName RWLFEXPNSMTPART view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Expense 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 ExpnSettlmt 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
ExpnSettlmtPartAddrRefType 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
_ExpnSettlmt _ExpnSettlmt
_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_ExpnSettlmtPartner.
-- 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_ExpnSettlmtPartner AS
SELECT
  cast( SettlmtMgmtDoc as wbeln_expns preserving type ) AS ExpnSettlmt,
  PartnerFunction,
  PartnerCounter,
  CreatedByUser,
  CreationDate,
  Supplier,
  Customer,
  ContactPerson,
  Personnel,
  AddressID,
  AddressPersonID,
  ReferenceBusinessPartner,
  SettlmtMgmtPartAddrRefType AS ExpnSettlmtPartAddrRefType,
  AddressObjectType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  VATRegistration,
  PartnerIsOneTimeAccount
FROM R_SettlmtMgmtDocPartner
LEFT OUTER JOIN R_ExpnSettlmt AS _ExpnSettlmt ON ExpnSettlmt = _ExpnSettlmt.ExpnSettlmt  -- association [1..1]
;

Learn More