R_SalesContractShipToPartyTP

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

Sales Contract Ship-to Party - TP

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

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentPartner SalesContractPartner 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 Contract Ship-to Party - TP view

Fields (47)

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