R_SalesQuotationShipToPartyTP

DDL: R_SALESQUOTATIONSHIPTOPARTYTP Type: view_entity TRANSACTIONAL Package: RAP_SD_SLS_QUT
47 Fields 1 Data Sources 3 Associations

Ship-to Party for Sales Quotation - TP

R_SalesQuotationShipToPartyTP is a Transactional CDS View that provides data about "Ship-to Party for Sales Quotation - TP" in SAP S/4HANA. It reads from 1 data source (I_SalesQuotationPartner) and exposes 47 fields with key field SalesQuotation. It has 3 associations to related views. Part of development package RAP_SD_SLS_QUT.

Data Sources (1)

SourceAliasJoin Type
I_SalesQuotationPartner SalesQuotationPartner from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Language _CorrespondenceLanguage $projection.CorrespondenceLanguage = _CorrespondenceLanguage.Language
[0..1] I_FormOfAddress _FormOfAddress $projection.FormOfAddress = _FormOfAddress.FormOfAddress
[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 Ship-to Party for Sales Quotation - TP view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY SalesQuotation SalesQuotation
Partner I_SalesQuotationPartner Customer Sold-to Party
ReferenceBusinessPartner I_SalesQuotationPartner ReferenceBusinessPartner Busn. Partner
FullName I_SalesQuotationPartner FullName Name
BusinessPartnerName1
BusinessPartnerName2
BusinessPartnerName3
BusinessPartnerName4
FormOfAddress I_SalesQuotationPartner FormOfAddress Title Key
PostalCode
CityName
DistrictName
Country
Region
StreetName
StreetPrefixName1
StreetPrefixName2
StreetSuffixName1
StreetSuffixName2
HouseNumber
InternationalPhoneNumber I_SalesQuotationPartner InternationalPhoneNumber Telephone no.
PhoneNumberExtension
InternationalMobilePhoneNumber I_SalesQuotationPartner InternationalMobilePhoneNumber
InternationalFaxNumber I_SalesQuotationPartner InternationalFaxNumber Fax Number
FaxNumberExtension
EmailAddress I_SalesQuotationPartner EmailAddress E-Mail Address
POBox
POBoxPostalCode
CorrespondenceLanguage I_SalesQuotationPartner CorrespondenceLanguage Correspondence Language
TaxJurisdiction
TransportZone
UnloadingPointName I_SalesQuotationPartner UnloadingPointName Unloading Point Name
VATRegistration I_SalesQuotationPartner VATRegistration VAT Registration No.
AddressID I_SalesQuotationPartner AddressID Ship-to address
AddressPersonID I_SalesQuotationPartner AddressPersonID Person Number
AddressObjectType I_SalesQuotationPartner AddressObjectType Address Type
SDDocPartnerAddrIsDocSpecific I_SalesQuotationPartner SDDocPartnerAddrIsDocSpecific
SalesQuotationType _SalesQuotation SalesQuotationType
SalesOrganization _SalesQuotation SalesOrganization Sales Organization
DistributionChannel _SalesQuotation DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesQuotation OrganizationDivision Org. Division
_SalesQuotation _SalesQuotation
_CorrespondenceLanguage _CorrespondenceLanguage
_FormOfAddress _FormOfAddress
_TransportationZone _TransportationZone
_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_SalesQuotationShipToPartyTP.
-- 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_SalesQuotationShipToPartyTP AS
SELECT
  SalesQuotation,
  SalesQuotationPartner.Customer AS Partner,
  SalesQuotationPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  SalesQuotationPartner.FullName AS FullName,
  SalesQuotationPartner._OrgNamePostalAddress.AddresseeName1 AS BusinessPartnerName1,
  SalesQuotationPartner._OrgNamePostalAddress.AddresseeName2 AS BusinessPartnerName2,
  SalesQuotationPartner._OrgNamePostalAddress.AddresseeName3 AS BusinessPartnerName3,
  SalesQuotationPartner._OrgNamePostalAddress.AddresseeName4 AS BusinessPartnerName4,
  SalesQuotationPartner.FormOfAddress AS FormOfAddress,
  SalesQuotationPartner._OrgNamePostalAddress.PostalCode AS PostalCode,
  SalesQuotationPartner._OrgNamePostalAddress.CityName AS CityName,
  SalesQuotationPartner._OrgNamePostalAddress.DistrictName AS DistrictName,
  SalesQuotationPartner._OrgNamePostalAddress.Country AS Country,
  SalesQuotationPartner._OrgNamePostalAddress.Region AS Region,
  SalesQuotationPartner._OrgNamePostalAddress.StreetName AS StreetName,
  SalesQuotationPartner._OrgNamePostalAddress.StreetPrefixName1 AS StreetPrefixName1,
  SalesQuotationPartner._OrgNamePostalAddress.StreetPrefixName2 AS StreetPrefixName2,
  SalesQuotationPartner._OrgNamePostalAddress.StreetSuffixName1 AS StreetSuffixName1,
  SalesQuotationPartner._OrgNamePostalAddress.StreetSuffixName2 AS StreetSuffixName2,
  SalesQuotationPartner._OrgNamePostalAddress.HouseNumber AS HouseNumber,
  SalesQuotationPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  cast(' ' as ad_tlxtns) AS PhoneNumberExtension,
  SalesQuotationPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  SalesQuotationPartner.InternationalFaxNumber AS InternationalFaxNumber,
  cast(' ' as ad_fxxtns) AS FaxNumberExtension,
  SalesQuotationPartner.EmailAddress AS EmailAddress,
  SalesQuotationPartner._OrgNamePostalAddress.POBox AS POBox,
  SalesQuotationPartner._OrgNamePostalAddress.POBoxPostalCode AS POBoxPostalCode,
  SalesQuotationPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  SalesQuotationPartner._OrgNamePostalAddress.TaxJurisdiction AS TaxJurisdiction,
  SalesQuotationPartner._OrgNamePostalAddress.TransportZone AS TransportZone,
  SalesQuotationPartner.UnloadingPointName AS UnloadingPointName,
  SalesQuotationPartner.VATRegistration AS VATRegistration,
  SalesQuotationPartner.AddressID AS AddressID,
  SalesQuotationPartner.AddressPersonID AS AddressPersonID,
  SalesQuotationPartner.AddressObjectType AS AddressObjectType,
  SalesQuotationPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  _SalesQuotation.SalesQuotationType AS SalesQuotationType,
  _SalesQuotation.SalesOrganization AS SalesOrganization,
  _SalesQuotation.DistributionChannel AS DistributionChannel,
  _SalesQuotation.OrganizationDivision AS OrganizationDivision,
  SalesQuotationPartner._OrgNamePostalAddress._Country AS _Country,
  SalesQuotationPartner._OrgNamePostalAddress._Region AS _Region
FROM I_SalesQuotationPartner AS SalesQuotationPartner
LEFT OUTER JOIN I_Language AS _CorrespondenceLanguage ON CorrespondenceLanguage = _CorrespondenceLanguage.Language  -- association [0..1]
LEFT OUTER JOIN I_FormOfAddress AS _FormOfAddress ON FormOfAddress = _FormOfAddress.FormOfAddress  -- association [0..1]
LEFT OUTER JOIN I_TransportationZone AS _TransportationZone ON transportzone = _TransportationZone.TransportZone AND country = _TransportationZone.CountryCode  -- association [0..1]
;

Learn More