What is I_CustSettlmtListPartner in SAP S/4HANA?

I_CustSettlmtListPartner is a basic CDS view in SAP S/4HANA. Customer Settlement List Partner It contains 26 fields.

Which tables does I_CustSettlmtListPartner read from?

I_CustSettlmtListPartner reads data from: R_CustSettlmtListPartner.

What VDM layer is I_CustSettlmtListPartner?

I_CustSettlmtListPartner is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_CustSettlmtListPartner

DDL: I_CUSTSETTLMTLISTPARTNER Type: view BASIC

26 Fields 1 Data Sources 2 Associations

Customer Settlement List Partner

I_CustSettlmtListPartner (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sales

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

SAP Help Documentation

Category	Customer Settlement List
Status	Released

Purpose
This CDS view is used to select the customer settlement list partner. This CDS view provides the prerequisites for answering the following business questions: Who is the customer settlement list 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 Org data (VKORG) Distribution Channel (VTWEG) Division (SPART) You have relevant Bill to Party Authorization Authorization Object: F_KNA1_BED You have relevant Payer Party Authorization Authorization Object: F_KNA1_BED You have relevant Partner Data Authorization Authorization Object: F_LFA1_BEK

Structure
Main CDS parameters and filters This view has no input parameters. Measures and attributes Some important measures and attributes are: Customer Settlement List ( CustSettlmtList ) Partner Function ( PartnerFunction ) Partner Counter ( PartnerCounter ) Created by User ( CreatedByUser ) Creation Date ( CreationDate ) Supplier account number ( Supplier ) Customer number ( Customer ) Number of Contact Person ( ContactPerson ) Personnel number ( Personnel ) Partner Address ( AddressID ) VAT Registration number ( VATRegistration )

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Sales
Application Component	LO-AB
Capabilities	Analytical Dimension, Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
Package	Sales for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view is used to select the customer settlement list partner.</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Who is the customer settlement list partner?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
R_CustSettlmtListPartner	R_CustSettlmtListPartner	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_CustSettlmtList	_CustSettlmtList	`$projection.CustSettlmtList = _CustSettlmtList.CustSettlmtList`
[0..1]	I_Address	_Address	`$projection.AddressID = _Address.AddressID`

Annotations (19)

Name	Value	Level
AbapCatalog.sqlViewName	IWLFCSTSMTLTPART	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.modelingPattern	#ANALYTICAL_DIMENSION	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#B	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)

Key	Field	Source Field	Description
KEY	CustSettlmtList	CustSettlmtList	Settlement Document: Customer Settlement List
KEY	PartnerFunction	PartnerFunction	Partner Function
KEY	PartnerCounter	PartnerCounter	Partner counter
	CreatedByUser	CreatedByUser	Name of User who Created the Document
	CreationDate	CreationDate	Date of Document Creation
	Supplier	Supplier	Account Number of Supplier
	Customer	Customer	Customer Number
	ContactPerson	ContactPerson	Number of Contact Person
	Personnel	Personnel	Personnel Number
	AddressID	AddressID	Ship-to address
	AddressPersonID	AddressPersonID	Person Number
	ReferenceBusinessPartner	ReferenceBusinessPartner	Business Partner Number
	CustSettlmtListPartAddrRefType	CustSettlmtListPartAddrRefType	Address indicator
	AddressObjectType	AddressObjectType	Address type (1=Organization, 2=Person, 3=Contact person)
	BPAddrDeterminationTransaction	BPAddrDeterminationTransaction	Address Determination in Document
	BPRefAddressIDForDocSpcfcAddr	BPRefAddressIDForDocSpcfcAddr	BP Reference Address Number
	VATRegistration	VATRegistration	VAT Registration Number
	_CustSettlmtList	_CustSettlmtList
	_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_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 I_CustSettlmtListPartner AS
SELECT
  CustSettlmtList,
  PartnerFunction,
  PartnerCounter,
  CreatedByUser,
  CreationDate,
  Supplier,
  Customer,
  ContactPerson,
  Personnel,
  AddressID,
  AddressPersonID,
  ReferenceBusinessPartner,
  CustSettlmtListPartAddrRefType,
  AddressObjectType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  VATRegistration
FROM R_CustSettlmtListPartner
LEFT OUTER JOIN I_CustSettlmtList AS _CustSettlmtList ON CustSettlmtList = _CustSettlmtList.CustSettlmtList  -- association [1..1]
LEFT OUTER JOIN I_Address AS _Address ON AddressID = _Address.AddressID  -- association [0..1]
;

Depth:

I_CustSettlmtListPartner view

R_CustSettlmtListPartner view