I_ExpnSettlmtItemPartner

DDL: I_EXPNSETTLMTITEMPARTNER Type: view BASIC
28 Fields 1 Data Sources 3 Associations

Expense Settlement Item Partner

I_ExpnSettlmtItemPartner is a Basic CDS View (Dimension) that provides data about "Expense Settlement Item Partner" in SAP S/4HANA. It reads from 1 data source (R_ExpnSettlmtItemPartner) and exposes 28 fields with key fields ExpnSettlmt, ExpnSettlmtItem, PartnerFunction, PartnerCounter. It has 3 associations to related views.

SAP Help Documentation

CategoryExpense Settlement
Data CategoryDimension
StatusReleased
Purpose
This CDS view is used to select the Expense Settlement Item Partner. This CDS view provides the prerequisites for answering the following business questions: What is the Expense Settlement Item 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: Sales Org ( 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

Structure
Measures and attributes Some important measures and attributes are: Expense Settlement Settlement Management Document Item Partner function Partner counter Supplier Customer Contact person Address VAT Registration

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
R_ExpnSettlmtItemPartner R_ExpnSettlmtItemPartner from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_ExpnSettlmt _ExpnSettlmt _ExpnSettlmt.ExpnSettlmt = $projection.ExpnSettlmt
[1..1] I_ExpnSettlmtItem _ExpnSettlmtItem _ExpnSettlmtItem.ExpnSettlmt = $projection.ExpnSettlmt and _ExpnSettlmtItem.ExpnSettlmtItem = $projection.ExpnSettlmtItem
[0..1] I_Address _Address $projection.AddressID = _Address.AddressID

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName IWLFEXPNSMTITMPT 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 Expense Settlement Item Partner view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY ExpnSettlmt ExpnSettlmt
KEY ExpnSettlmtItem ExpnSettlmtItem Item
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 ExpnSettlmtPartAddrRefType
AddressObjectType AddressObjectType Address Type
BPAddrDeterminationTransaction BPAddrDeterminationTransaction Address Detn
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
VATRegistration VATRegistration VAT Registration No.
_ExpnSettlmt _ExpnSettlmt
_ExpnSettlmtItem _ExpnSettlmtItem
_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_ExpnSettlmtItemPartner.
-- 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_ExpnSettlmtItemPartner AS
SELECT
  ExpnSettlmt,
  ExpnSettlmtItem,
  PartnerFunction,
  PartnerCounter,
  CreatedByUser,
  CreationDate,
  Supplier,
  Customer,
  ContactPerson,
  Personnel,
  AddressID,
  AddressPersonID,
  ReferenceBusinessPartner,
  ExpnSettlmtPartAddrRefType,
  AddressObjectType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  VATRegistration
FROM R_ExpnSettlmtItemPartner
LEFT OUTER JOIN I_ExpnSettlmt AS _ExpnSettlmt ON _ExpnSettlmt.ExpnSettlmt = ExpnSettlmt  -- association [1..1]
LEFT OUTER JOIN I_ExpnSettlmtItem AS _ExpnSettlmtItem ON _ExpnSettlmtItem.ExpnSettlmt = ExpnSettlmt AND _ExpnSettlmtItem.ExpnSettlmtItem = ExpnSettlmtItem  -- association [1..1]
LEFT OUTER JOIN I_Address AS _Address ON AddressID = _Address.AddressID  -- association [0..1]
;

Learn More