R_CustomerReturnShipToPartyTP

DDL: R_CUSTOMERRETURNSHIPTOPARTYTP Type: view_entity TRANSACTIONAL
46 Fields 1 Data Sources 3 Associations

Returns Order Ship-to Party - TP

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

Data Sources (1)

SourceAliasJoin Type
I_CustomerReturnPartner CustomerReturnPartner from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_Language _CorrespondenceLanguage $projection.CorrespondenceLanguage = _CorrespondenceLanguage.Language
[0..1] I_TransportationZone _TransportationZone $projection.transportzone = _TransportationZone.TransportZone and $projection.country = _TransportationZone.CountryCode
[0..1] I_FormOfAddress _FormOfAddress $projection.FormOfAddress = _FormOfAddress.FormOfAddress

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 Returns Order Ship-to Party - TP view

Fields (46)

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

Learn More