C_SettlmtDocPartner_F3254

DDL: C_SETTLMTDOCPARTNER_F3254 Type: view_entity CONSUMPTION
54 Fields 1 Data Sources 1 OData Services

Manage Settlement Document Partner

C_SettlmtDocPartner_F3254 is a Consumption CDS View that provides data about "Manage Settlement Document Partner" in SAP S/4HANA. It reads from 1 data source (R_SettlmtDocPartnerTP) and exposes 54 fields with key fields SettlmtDoc, PartnerFunction, PartnerCounter. It is exposed through 1 OData service (UI_LO_SETMAN_SDOC_MAN).

Data Sources (1)

SourceAliasJoin Type
R_SettlmtDocPartnerTP R_SettlmtDocPartnerTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Manage Settlement Document Partner view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view

OData Services (1)

ServiceBindingVersionContractRelease
UI_LO_SETMAN_SDOC_MAN UI_LO_SETMAN_SDOC_MAN V4 C1 NOT_RELEASED

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDoc SettlmtDoc Settlement Doc.
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
SettlmtDocPartAddrRefType SettlmtDocPartAddrRefType Adress ind.
AddressObjectType AddressObjectType Address Type
BPAddrDeterminationTransaction BPAddrDeterminationTransaction Address Detn
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
VATRegistration VATRegistration VAT Registration No.
PartnerIsOneTimeAccount PartnerIsOneTimeAccount One-time acct
virtualUICT_Supplierboolean
virtualUICT_Customerboolean
virtualUICT_ContactPersonboolean
virtualUICT_Personnelboolean
CustomerName _Customer CustomerName Name of Customer
SupplierName _Supplier SupplierName Supplier Name
FirstName _ContactPerson FirstName First Name
LastName _ContactPerson LastName Last Name
AddresseeFullName _DfltAddrRprstn AddresseeFullName Full Name
FormOfAddress _DfltAddrRprstn FormOfAddress Title Key
StreetName _DfltAddrRprstn StreetName Text
HouseNumber _DfltAddrRprstn HouseNumber House Number
DistrictName _DfltAddrRprstn DistrictName District
PostalCode _DfltAddrRprstn PostalCode Postal Code
CityName _DfltAddrRprstn CityName Name
Country _DfltAddrRprstn Country Venue: Ctry/Reg
Region _DfltAddrRprstn Region Venue Region
TaxJurisdiction _DfltAddrRprstn TaxJurisdiction Tax Jurisdiction
POBox _DfltAddrRprstn POBox PO Box
POBoxPostalCode _DfltAddrRprstn POBoxPostalCode PO Box Postal Code
CorrespondenceLanguage _DfltAddrRprstn CorrespondenceLanguage Language
EmailAddress
InternationalPhoneNumber
InternationalMobilePhoneNumber
FormOfAddressNamelocalized
LanguageNamelocalized
RegionNamelocalized
CountryNamelocalized
_BPRefAddressForDocSpcfcAddr _BPRefAddressForDocSpcfcAddr
_BusinessPartnerAddress _BusinessPartnerAddress
_Customer _Customer
_DfltAddrRprstn _DfltAddrRprstn
_PartnerFunction _PartnerFunction
_PersonWorkplaceAddrDfltRprstn _PersonWorkplaceAddrDfltRprstn
_Supplier _Supplier
_ContactPerson _ContactPerson

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 C_SettlmtDocPartner_F3254.
-- 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 C_SettlmtDocPartner_F3254 AS
SELECT
  SettlmtDoc,
  PartnerFunction,
  PartnerCounter,
  CreatedByUser,
  CreationDate,
  Supplier,
  Customer,
  ContactPerson,
  Personnel,
  AddressID,
  AddressPersonID,
  ReferenceBusinessPartner,
  SettlmtDocPartAddrRefType,
  AddressObjectType,
  BPAddrDeterminationTransaction,
  BPRefAddressIDForDocSpcfcAddr,
  VATRegistration,
  PartnerIsOneTimeAccount,
  virtual UICT_Supplier : boolean AS virtualUICT_Supplierboolean,
  virtual UICT_Customer : boolean AS virtualUICT_Customerboolean,
  virtual UICT_ContactPerson : boolean AS virtualUICT_ContactPersonboolean,
  virtual UICT_Personnel : boolean AS virtualUICT_Personnelboolean,
  _Customer.CustomerName AS CustomerName,
  _Supplier.SupplierName AS SupplierName,
  _ContactPerson.FirstName AS FirstName,
  _ContactPerson.LastName AS LastName,
  _DfltAddrRprstn.AddresseeFullName AS AddresseeFullName,
  _DfltAddrRprstn.FormOfAddress AS FormOfAddress,
  _DfltAddrRprstn.StreetName AS StreetName,
  _DfltAddrRprstn.HouseNumber AS HouseNumber,
  _DfltAddrRprstn.DistrictName AS DistrictName,
  _DfltAddrRprstn.PostalCode AS PostalCode,
  _DfltAddrRprstn.CityName AS CityName,
  _DfltAddrRprstn.Country AS Country,
  _DfltAddrRprstn.Region AS Region,
  _DfltAddrRprstn.TaxJurisdiction AS TaxJurisdiction,
  _DfltAddrRprstn.POBox AS POBox,
  _DfltAddrRprstn.POBoxPostalCode AS POBoxPostalCode,
  _DfltAddrRprstn.CorrespondenceLanguage AS CorrespondenceLanguage,
  _DfltAddrRprstn._CurrentDfltEmailAddress.EmailAddress AS EmailAddress,
  _DfltAddrRprstn._CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber AS InternationalPhoneNumber,
  cast( _DfltAddrRprstn._CurrentDfltMobilePhoneNumber.InternationalPhoneNumber as rbb_telmo preserving type ) AS InternationalMobilePhoneNumber,
  _DfltAddrRprstn._FormOfAddress._Text.FormOfAddressName : localized AS FormOfAddressNamelocalized,
  _DfltAddrRprstn._CorrespondenceLanguage._Text.LanguageName : localized AS LanguageNamelocalized,
  _DfltAddrRprstn._Region._RegionText.RegionName : localized AS RegionNamelocalized,
  _DfltAddrRprstn._Country._Text.CountryName : localized AS CountryNamelocalized
FROM R_SettlmtDocPartnerTP
;

Learn More