R_SalesQuotationItemPartnerTP

DDL: R_SALESQUOTATIONITEMPARTNERTP Type: view_entity TRANSACTIONAL
54 Fields 2 Data Sources 5 Associations

Sales Quotation Item Partner - TP

R_SalesQuotationItemPartnerTP is a Transactional CDS View that provides data about "Sales Quotation Item Partner - TP" in SAP S/4HANA. It reads from 2 data sources (I_SalesDocItemCompletePartner, I_SalesDocumentBasic) and exposes 54 fields with key fields SalesQuotation, SalesQuotationItem, PartnerFunction. It has 5 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_SalesDocItemCompletePartner ItemPartner from
I_SalesDocumentBasic SalesQuotation inner

Associations (5)

CardinalityTargetAliasCondition
[1..1] R_SalesQuotationTP _SalesQuotation $projection.SalesQuotation = _SalesQuotation.SalesQuotation
[0..1] I_PartnerFunction _PartnerFunction $projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction
[0..1] I_FormOfAddress _FormOfAddress $projection.FormOfAddress = _FormOfAddress.FormOfAddress
[0..1] I_Language _CorrespondenceLanguage $projection.CorrespondenceLanguage = _CorrespondenceLanguage.Language
[0..1] I_TransportationZone _TransportationZone $projection.transportzone = _TransportationZone.TransportZone and $projection.country = _TransportationZone.CountryCode

Annotations (8)

NameValueLevelField
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Sales Quotation Item Partner - TP view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY SalesQuotation
KEY SalesQuotationItem
KEY PartnerFunction
PartnerFunctionForEdit
Customer I_SalesDocItemCompletePartner Customer Sold-to Party
Supplier I_SalesDocItemCompletePartner Supplier Supplier
Personnel I_SalesDocItemCompletePartner Personnel Personnel No.
ContactPerson I_SalesDocItemCompletePartner ContactPerson Contact Person Key
Partner I_SalesDocItemCompletePartner Partner With Partner
FullName I_SalesDocItemCompletePartner FullName Name
SDDocumentPartnerType _PartnerFunction SDDocumentPartnerType Partner Type
FormOfAddress I_SalesDocItemCompletePartner FormOfAddress Title Key
StreetName
HouseNumber
PostalCode
Country
Region
DistrictName
CityName
POBox
POBoxPostalCode
CorrespondenceLanguage I_SalesDocItemCompletePartner CorrespondenceLanguage Language
TaxJurisdiction
TransportZone
PartnerIsSpecificForSDDocItem I_SalesDocItemCompletePartner PartnerIsSpecificForSDDocItem
ReferenceBusinessPartner I_SalesDocItemCompletePartner ReferenceBusinessPartner Busn. Partner
AddressID I_SalesDocItemCompletePartner AddressID Ship-to address
AddressPersonID I_SalesDocItemCompletePartner AddressPersonID Person Number
AddressObjectType I_SalesDocItemCompletePartner AddressObjectType Address Type
SDDocPartnerAddrIsDocSpecific I_SalesDocItemCompletePartner SDDocPartnerAddrIsDocSpecific
VATRegistration I_SalesDocItemCompletePartner VATRegistration VAT Registration No.
UnloadingPointName I_SalesDocItemCompletePartner UnloadingPointName Unloading Point Name
InternationalPhoneNumber I_SalesDocItemCompletePartner InternationalPhoneNumber Telephone no.
InternationalMobilePhoneNumber I_SalesDocItemCompletePartner InternationalMobilePhoneNumber
EmailAddress I_SalesDocItemCompletePartner EmailAddress E-Mail Address
SDDocPartnerAddressRefType I_SalesDocItemCompletePartner SDDocPartnerAddressRefType Adress ind.
BPAddrDeterminationTransaction I_SalesDocItemCompletePartner BPAddrDeterminationTransaction Address Detn
BPRefAddressIDForDocSpcfcAddr I_SalesDocItemCompletePartner BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
SalesQuotationType _SalesQuotation SalesQuotationType
SalesOrganization _SalesQuotation SalesOrganization Sales Organization
DistributionChannel _SalesQuotation DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesQuotation OrganizationDivision Org. Division
_Item _Item
_SalesQuotation _SalesQuotation
_PartnerFunction _PartnerFunction
_CorrespondenceLanguage _CorrespondenceLanguage
_TransportationZone _TransportationZone
_FormOfAddress _FormOfAddress
_ContactPerson I_SalesDocItemCompletePartner _ContactPerson
_DfltAddrRprstn I_SalesDocItemCompletePartner _DfltAddrRprstn
_BusinessPartnerAddress I_SalesDocItemCompletePartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_SalesDocItemCompletePartner _BPRefAddressForDocSpcfcAddr
_Country
_Region

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 R_SalesQuotationItemPartnerTP.
-- 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 R_SalesQuotationItemPartnerTP AS
SELECT
  cast(ItemPartner.SalesDocument as sales_quotation preserving type) AS SalesQuotation,
  cast(ItemPartner.SalesDocumentItem as sales_quotation_item preserving type) AS SalesQuotationItem,
  cast(ItemPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  cast(ItemPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunctionForEdit,
  ItemPartner.Customer AS Customer,
  ItemPartner.Supplier AS Supplier,
  ItemPartner.Personnel AS Personnel,
  ItemPartner.ContactPerson AS ContactPerson,
  ItemPartner.Partner AS Partner,
  ItemPartner.FullName AS FullName,
  _PartnerFunction.SDDocumentPartnerType AS SDDocumentPartnerType,
  ItemPartner.FormOfAddress AS FormOfAddress,
  ItemPartner._OrgNamePostalAddress.StreetName AS StreetName,
  ItemPartner._OrgNamePostalAddress.HouseNumber AS HouseNumber,
  ItemPartner._OrgNamePostalAddress.PostalCode AS PostalCode,
  ItemPartner._OrgNamePostalAddress.Country AS Country,
  ItemPartner._OrgNamePostalAddress.Region AS Region,
  ItemPartner._OrgNamePostalAddress.DistrictName AS DistrictName,
  ItemPartner._OrgNamePostalAddress.CityName AS CityName,
  ItemPartner._OrgNamePostalAddress.POBox AS POBox,
  ItemPartner._OrgNamePostalAddress.POBoxPostalCode AS POBoxPostalCode,
  ItemPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  ItemPartner._OrgNamePostalAddress.TaxJurisdiction AS TaxJurisdiction,
  ItemPartner._OrgNamePostalAddress.TransportZone AS TransportZone,
  ItemPartner.PartnerIsSpecificForSDDocItem AS PartnerIsSpecificForSDDocItem,
  ItemPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  ItemPartner.AddressID AS AddressID,
  ItemPartner.AddressPersonID AS AddressPersonID,
  ItemPartner.AddressObjectType AS AddressObjectType,
  ItemPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  ItemPartner.VATRegistration AS VATRegistration,
  ItemPartner.UnloadingPointName AS UnloadingPointName,
  ItemPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  ItemPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  ItemPartner.EmailAddress AS EmailAddress,
  ItemPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  ItemPartner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  ItemPartner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  _SalesQuotation.SalesQuotationType AS SalesQuotationType,
  _SalesQuotation.SalesOrganization AS SalesOrganization,
  _SalesQuotation.DistributionChannel AS DistributionChannel,
  _SalesQuotation.OrganizationDivision AS OrganizationDivision,
  ItemPartner._ContactPerson AS _ContactPerson,
  ItemPartner._DfltAddrRprstn AS _DfltAddrRprstn,
  ItemPartner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  ItemPartner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr,
  ItemPartner._OrgNamePostalAddress._Country AS _Country,
  ItemPartner._OrgNamePostalAddress._Region AS _Region
FROM I_SalesDocItemCompletePartner AS ItemPartner
INNER JOIN I_SalesDocumentBasic AS SalesQuotation ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_SalesQuotationTP AS _SalesQuotation ON SalesQuotation = _SalesQuotation.SalesQuotation  -- association [1..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON PartnerFunctionForEdit = _PartnerFunction.PartnerFunction  -- association [0..1]
LEFT OUTER JOIN I_FormOfAddress AS _FormOfAddress ON FormOfAddress = _FormOfAddress.FormOfAddress  -- association [0..1]
LEFT OUTER JOIN I_Language AS _CorrespondenceLanguage ON CorrespondenceLanguage = _CorrespondenceLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_TransportationZone AS _TransportationZone ON transportzone = _TransportationZone.TransportZone AND country = _TransportationZone.CountryCode  -- association [0..1]
;

Learn More