R_SalesOrderShipToPartyTP

DDL: R_SALESORDERSHIPTOPARTYTP Type: view_entity TRANSACTIONAL
47 Fields 1 Data Sources 3 Associations

Sales Order Ship-to Party - TP

R_SalesOrderShipToPartyTP is a Transactional CDS View that provides data about "Sales Order Ship-to Party - TP" in SAP S/4HANA. It reads from 1 data source (I_SalesOrderPartner) and exposes 47 fields with key field SalesOrder. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SalesOrderPartner SalesOrderPartner 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 Sales Order Ship-to Party - TP view

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesOrder SD Document
Partner I_SalesOrderPartner Customer Sold-to Party
ReferenceBusinessPartner I_SalesOrderPartner ReferenceBusinessPartner Busn. Partner
FullName I_SalesOrderPartner FullName Name
BusinessPartnerName1
BusinessPartnerName2
BusinessPartnerName3
BusinessPartnerName4
FormOfAddress I_SalesOrderPartner FormOfAddress Title Key
PostalCode
CityName
DistrictName
Country
Region
StreetName
StreetPrefixName1
StreetPrefixName2
StreetSuffixName1
StreetSuffixName2
HouseNumber
InternationalPhoneNumber I_SalesOrderPartner InternationalPhoneNumber Telephone no.
PhoneNumberExtension
InternationalMobilePhoneNumber I_SalesOrderPartner InternationalMobilePhoneNumber
InternationalFaxNumber I_SalesOrderPartner InternationalFaxNumber Fax Number
FaxNumberExtension
EmailAddress I_SalesOrderPartner EmailAddress E-Mail Address
POBox
POBoxPostalCode
CorrespondenceLanguage I_SalesOrderPartner CorrespondenceLanguage Correspondence Language
TaxJurisdiction
TransportZone
UnloadingPointName I_SalesOrderPartner UnloadingPointName Unloading Point Name
VATRegistration I_SalesOrderPartner VATRegistration VAT Registration No.
AddressID I_SalesOrderPartner AddressID Ship-to address
AddressPersonID I_SalesOrderPartner AddressPersonID Person Number
AddressObjectType I_SalesOrderPartner AddressObjectType Address Type
SDDocPartnerAddrIsDocSpecific I_SalesOrderPartner SDDocPartnerAddrIsDocSpecific
SalesOrderType _SalesOrder SalesOrderType Sales Order Type
SalesOrganization _SalesOrder SalesOrganization Sales Organization
DistributionChannel _SalesOrder DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesOrder OrganizationDivision Org. Division
_SalesOrder _SalesOrder
_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_SalesOrderShipToPartyTP.
-- 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_SalesOrderShipToPartyTP AS
SELECT
  SalesOrder,
  SalesOrderPartner.Customer AS Partner,
  SalesOrderPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  SalesOrderPartner.FullName AS FullName,
  SalesOrderPartner._OrgNamePostalAddress.AddresseeName1 AS BusinessPartnerName1,
  SalesOrderPartner._OrgNamePostalAddress.AddresseeName2 AS BusinessPartnerName2,
  SalesOrderPartner._OrgNamePostalAddress.AddresseeName3 AS BusinessPartnerName3,
  SalesOrderPartner._OrgNamePostalAddress.AddresseeName4 AS BusinessPartnerName4,
  SalesOrderPartner.FormOfAddress AS FormOfAddress,
  SalesOrderPartner._OrgNamePostalAddress.PostalCode AS PostalCode,
  SalesOrderPartner._OrgNamePostalAddress.CityName AS CityName,
  SalesOrderPartner._OrgNamePostalAddress.DistrictName AS DistrictName,
  SalesOrderPartner._OrgNamePostalAddress.Country AS Country,
  SalesOrderPartner._OrgNamePostalAddress.Region AS Region,
  SalesOrderPartner._OrgNamePostalAddress.StreetName AS StreetName,
  SalesOrderPartner._OrgNamePostalAddress.StreetPrefixName1 AS StreetPrefixName1,
  SalesOrderPartner._OrgNamePostalAddress.StreetPrefixName2 AS StreetPrefixName2,
  SalesOrderPartner._OrgNamePostalAddress.StreetSuffixName1 AS StreetSuffixName1,
  SalesOrderPartner._OrgNamePostalAddress.StreetSuffixName2 AS StreetSuffixName2,
  SalesOrderPartner._OrgNamePostalAddress.HouseNumber AS HouseNumber,
  SalesOrderPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  cast(' ' as ad_tlxtns) AS PhoneNumberExtension,
  SalesOrderPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  SalesOrderPartner.InternationalFaxNumber AS InternationalFaxNumber,
  cast(' ' as ad_fxxtns) AS FaxNumberExtension,
  SalesOrderPartner.EmailAddress AS EmailAddress,
  SalesOrderPartner._OrgNamePostalAddress.POBox AS POBox,
  SalesOrderPartner._OrgNamePostalAddress.POBoxPostalCode AS POBoxPostalCode,
  SalesOrderPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  SalesOrderPartner._OrgNamePostalAddress.TaxJurisdiction AS TaxJurisdiction,
  SalesOrderPartner._OrgNamePostalAddress.TransportZone AS TransportZone,
  SalesOrderPartner.UnloadingPointName AS UnloadingPointName,
  SalesOrderPartner.VATRegistration AS VATRegistration,
  SalesOrderPartner.AddressID AS AddressID,
  SalesOrderPartner.AddressPersonID AS AddressPersonID,
  SalesOrderPartner.AddressObjectType AS AddressObjectType,
  SalesOrderPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  _SalesOrder.SalesOrderType AS SalesOrderType,
  _SalesOrder.SalesOrganization AS SalesOrganization,
  _SalesOrder.DistributionChannel AS DistributionChannel,
  _SalesOrder.OrganizationDivision AS OrganizationDivision,
  SalesOrderPartner._OrgNamePostalAddress._Country AS _Country,
  SalesOrderPartner._OrgNamePostalAddress._Region AS _Region
FROM I_SalesOrderPartner AS SalesOrderPartner
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