I_CustSettlmtPartner

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

Customer Settlement Partner

I_CustSettlmtPartner (Basic)

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

Sales

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

SAP Help Documentation

CategoryCustomer Settlement
Data CategoryDimension
StatusReleased
Purpose
This CDS view is used to select the customer settlement partner. This CDS view provides the prerequisites for answering the following business questions: Who is the customer settlement partner?

Prerequisites
You have authorizations to access the following: The relevant condition contract types. The relevant sales organizations. 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: Sales Org data (VKORG) Distribution Channel (VTWEG) Division (SPART) Company Code (BUKRS) 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: Settlement Management document number ( CustSettlmt ) Partner function identifier ( PartnerFunction ) Sequential number when ther is more than one Partner function ( PartnerCounter ) Created by user Creation Date 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 →

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentLO-AB
CapabilitiesAnalytical Dimension, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities
PackageSales for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view is used to select the customer settlement partner.</p> This CDS view provides the prerequisites for answering the following business questions:<ul> <li><p>Who is the customer settlement partner?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
R_CustSettlmtPartner R_CustSettlmtPartner from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CustSettlmt _CustSettlmt $projection.CustSettlmt = _CustSettlmt.CustSettlmt
[0..1] I_Address _Address $projection.AddressID = _Address.AddressID

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName IWLFCUSTSMTPART view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API 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
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled false view
Analytics.internalName #LOCAL view
EndUserText.label Customer Settlement Partner view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CustSettlmt CustSettlmt Customer Settlement
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
CustSettlmtPartAddrRefType CustSettlmtPartAddrRefType 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
_CustSettlmt _CustSettlmt
_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_CustSettlmtPartner.
-- 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_CustSettlmtPartner AS
SELECT
  CustSettlmt,
  PartnerFunction,
  PartnerCounter,
  CreatedByUser,
  CreationDate,
  Supplier,
  Customer,
  ContactPerson,
  Personnel,
  AddressID,
  AddressPersonID,
  ReferenceBusinessPartner,
  CustSettlmtPartAddrRefType,
  AddressObjectType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  VATRegistration
FROM R_CustSettlmtPartner
LEFT OUTER JOIN I_CustSettlmt AS _CustSettlmt ON CustSettlmt = _CustSettlmt.CustSettlmt  -- association [1..1]
LEFT OUTER JOIN I_Address AS _Address ON AddressID = _Address.AddressID  -- association [0..1]
;

Learn More