I_SettlmtDocListPartner

DDL: I_SETTLMTDOCLISTPARTNER Type: view BASIC
26 Fields 1 Data Sources 2 Associations

Settlement Document List Partner

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

SAP Help Documentation

CategorySettlement Document List
Data CategoryDimension
StatusReleased
Purpose
This CDS view provides the prerequisites for answering questions about partners at a settlement document list level. This CDS view provides the prerequisites for answering the following business questions: What is the function of the partner (e.g. 3rd Party Supplier, Additional Contact)? What is the address of the partner?

Prerequisites
Users who want to run reports using this CDS view must have the authorization to display the following data: Authorization Object: W_WBRK_FKA Authorization required for Settlement document Type ( LFART ) Authorization Object: W_WBRK_ORG Authorization required for the following: Relevant Org data ( BUKRS ) Sales Organization ( VKORG ) Distribution Channel ( VTWEG ) Division (SPART) Purchasing Organization (EKORG) Purchasing Group (EKGRP) Authorization Object: F_LFA1_BEK Authorization group needs to be maintained for the following: Invoicing Party Invoicing Party Company Payee Party Payee Party Company Alternative Invoicing Party Alternative Invoicing Party Company Supplier Authorization Object: F_KNA1_BED Authorization group needs to be maintained for the following: Payer Party Payer Party Company Bill To Party Bill To Party Company Customer

Structure
Object types This view relates to the following SAP object type: Settlement Document List Main CDS parameters and filters This view has no input parameters. Measures and attributes Some important measures and attributes are: Settlement Document List Partner function identifier ( PartnerFunction ) Sequential number when there is more than one Partner function ( PartnerCounter ) Account Number of Supplier ( Supplier ) Customer Number ( Customer ) Number of contact person ( ContactPerson ) Personnel Number ( Personnel ) Address Number ( AddressID ) VAT Registration Number ( VATRegistration )

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
R_SettlmtDocListPartner R_SettlmtDocListPartner from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SettlmtDocList _SettlmtDocList $projection.SettlmtDocList = _SettlmtDocList.SettlmtDocList
[0..1] I_Address _Address $projection.AddressID = _Address.AddressID

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName IWLFSMTDCLSTPART 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.modelingPattern #ANALYTICAL_DIMENSION 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 #PUBLIC_LOCAL_API view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled false view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDocList SettlmtDocList
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 SettlmtDocListPartAddrRefType
AddressObjectType AddressObjectType Address Type
BPAddrDeterminationTransaction BPAddrDeterminationTransaction Address Detn
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
VATRegistration VATRegistration VAT Registration No.
_SettlmtDocList _SettlmtDocList
_PartnerFunction _PartnerFunction
_Supplier _Supplier
_Customer _Customer
_Address _Address
_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 I_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 I_SettlmtDocListPartner AS
SELECT
  SettlmtDocList,
  PartnerFunction,
  PartnerCounter,
  CreatedByUser,
  CreationDate,
  Supplier,
  Customer,
  ContactPerson,
  Personnel,
  AddressID,
  AddressPersonID,
  ReferenceBusinessPartner,
  SettlmtDocListPartAddrRefType,
  AddressObjectType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  VATRegistration
FROM R_SettlmtDocListPartner
LEFT OUTER JOIN I_SettlmtDocList AS _SettlmtDocList ON SettlmtDocList = _SettlmtDocList.SettlmtDocList  -- association [1..1]
LEFT OUTER JOIN I_Address AS _Address ON AddressID = _Address.AddressID  -- association [0..1]
;

Learn More