I_SalesQuotationPartner

DDL: I_SALESQUOTATIONPARTNER Type: view COMPOSITE
34 Fields 1 Data Sources

Sales Quotation Partner

I_SalesQuotationPartner (Composite)

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

Sales

I_SalesQuotationPartner is a Composite CDS View that provides data about "Sales Quotation Partner" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentPartner) and exposes 34 fields with key fields SalesQuotation, PartnerFunction.

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentSD-SLS-QUT
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities, Association Target for Defining CDS Entities
PackageSales for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering questions about sales quotation partners at header level.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentPartner Partner from

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Quotation Partner view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDSLSQTANPT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey PartnerFunction view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY SalesQuotation Sales Quotation
KEY PartnerFunction PartnerFunction Partner Function
Customer Customer Customer Number
Supplier Supplier Account Number of Supplier
Personnel Personnel Personnel Number
AddressID AddressID Ship-to address
ContactPerson ContactPerson Number of Contact Person
Partner Partner Customer Number
FullName FullName Full Name of Person
AddressPersonID AddressPersonID Person Number
AddressObjectType AddressObjectType Address type (1=Organization, 2=Person, 3=Contact person)
SDDocPartnerAddressRefType SDDocPartnerAddressRefType Address indicator
ReferenceBusinessPartner ReferenceBusinessPartner Business Partner Number
BPRefAddressIDForDocSpcfcAddr BPRefAddressIDForDocSpcfcAddr BP Reference Address Number
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific Document-Specific Address Indicator
BPAddrDeterminationTransaction BPAddrDeterminationTransaction Address Determination in Document
VATRegistration VATRegistration VAT Registration Number
UnloadingPointName UnloadingPointName Unloading Point Name
CorrespondenceLanguage CorrespondenceLanguage Language
FormOfAddress FormOfAddress Form-of-Address Key
InternationalPhoneNumber InternationalPhoneNumber Complete Number: Dialing Code+Number+Extension
InternationalMobilePhoneNumber InternationalMobilePhoneNumber Complete Number: Dialing Code+Number+Extension
InternationalFaxNumber InternationalFaxNumber Complete Number: Dialing Code+Number+Extension
EmailAddress EmailAddress E-Mail Address
_SalesQuotation _SalesQuotation
_PartnerFunction _PartnerFunction
_ContactPerson _ContactPerson
_Address _Address
_DfltAddrRprstn _DfltAddrRprstn
_BusinessPartnerAddress _BusinessPartnerAddress
_PersonAddress _PersonAddress
_PersonName _PersonName
_OrganizationAddress _OrganizationAddress
_OrgNamePostalAddress _OrgNamePostalAddress

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_SalesQuotationPartner.
-- 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_SalesQuotationPartner AS
SELECT
  cast(SalesDocument as sales_quotation preserving type) AS SalesQuotation,
  PartnerFunction,
  Customer,
  Supplier,
  Personnel,
  AddressID,
  ContactPerson,
  Partner,
  FullName,
  AddressPersonID,
  AddressObjectType,
  SDDocPartnerAddressRefType,
  ReferenceBusinessPartner,
  BPRefAddressIDForDocSpcfcAddr,
  SDDocPartnerAddrIsDocSpecific,
  BPAddrDeterminationTransaction,
  VATRegistration,
  UnloadingPointName,
  CorrespondenceLanguage,
  FormOfAddress,
  InternationalPhoneNumber,
  InternationalMobilePhoneNumber,
  InternationalFaxNumber,
  EmailAddress
FROM I_SalesDocumentPartner AS Partner
;

Learn More