R_CustomerReturnPartnerTP

DDL: R_CUSTOMERRETURNPARTNERTP Type: view_entity TRANSACTIONAL Package: RAP_SD_SLS_RE
59 Fields 1 Data Sources 8 Associations

Returns Order Partner - TP

R_CustomerReturnPartnerTP is a Transactional CDS View that provides data about "Returns Order Partner - TP" in SAP S/4HANA. It reads from 1 data source (I_CustomerReturnPartner) and exposes 59 fields with key fields CustomerReturn, PartnerFunction. It has 8 associations to related views. Part of development package RAP_SD_SLS_RE.

Data Sources (1)

SourceAliasJoin Type
I_CustomerReturnPartner CustomerReturnPartner from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_PartnerFunction _PartnerFunction $projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction
[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
[0..1] I_AddrCurDfltLandlinePhoneNmbr _CurrentDfltLandlinePhoneNmbr $projection.AddressID = _CurrentDfltLandlinePhoneNmbr.AddressID and $projection.AddressPersonID = _CurrentDfltLandlinePhoneNmbr.AddressPersonID
[0..1] I_AddrCurDfltMobilePhoneNumber _CurrentDfltMobilePhoneNumber $projection.AddressID = _CurrentDfltMobilePhoneNumber.AddressID and $projection.AddressPersonID = _CurrentDfltMobilePhoneNumber.AddressPersonID
[0..1] I_AddrCurDefaultFaxNumber _CurrentDfltFaxNumber $projection.AddressID = _CurrentDfltFaxNumber.AddressID and $projection.AddressPersonID = _CurrentDfltFaxNumber.AddressPersonID
[1] I_WorkplaceAddress _WorkPlaceAddress $projection.ReferenceBusinessPartner = _WorkPlaceAddress.BusinessPartner

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 Partner - TP view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn I_CustomerReturnPartner CustomerReturn
KEY PartnerFunction
PartnerFunctionForEdit
Customer I_CustomerReturnPartner Customer Sold-to Party
Supplier I_CustomerReturnPartner Supplier Supplier
Personnel I_CustomerReturnPartner Personnel Personnel No.
ContactPerson I_CustomerReturnPartner ContactPerson Contact Person Key
ReferenceBusinessPartner I_CustomerReturnPartner ReferenceBusinessPartner Busn. Partner
Partner I_CustomerReturnPartner Partner With Partner
BusinessPartnerName1
BusinessPartnerName2
BusinessPartnerName3
BusinessPartnerName4
FullName I_CustomerReturnPartner FullName Name
SDDocumentPartnerType _PartnerFunction SDDocumentPartnerType Partner Type
FormOfAddress I_CustomerReturnPartner FormOfAddress Title Key
PostalCode
CityName
DistrictName
Country
Region
StreetName
StreetPrefixName1
StreetPrefixName2
StreetSuffixName1
StreetSuffixName2
HouseNumber
InternationalPhoneNumber I_CustomerReturnPartner InternationalPhoneNumber Telephone no.
InternationalMobilePhoneNumber I_CustomerReturnPartner InternationalMobilePhoneNumber
InternationalFaxNumber I_CustomerReturnPartner InternationalFaxNumber Fax Number
EmailAddress I_CustomerReturnPartner EmailAddress E-Mail Address
POBox
POBoxPostalCode
CorrespondenceLanguage I_CustomerReturnPartner CorrespondenceLanguage 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
SDDocPartnerAddressRefType I_CustomerReturnPartner SDDocPartnerAddressRefType Adress ind.
BPAddrDeterminationTransaction I_CustomerReturnPartner BPAddrDeterminationTransaction Address Detn
BPRefAddressIDForDocSpcfcAddr I_CustomerReturnPartner BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
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
_PartnerFunction _PartnerFunction
_CorrespondenceLanguage _CorrespondenceLanguage
_FormOfAddress _FormOfAddress
_TransportationZone _TransportationZone
_DfltAddrRprstn I_CustomerReturnPartner _DfltAddrRprstn
_BusinessPartnerAddress I_CustomerReturnPartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_CustomerReturnPartner _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_CustomerReturnPartnerTP.
-- 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_CustomerReturnPartnerTP AS
SELECT
  CustomerReturnPartner.CustomerReturn AS CustomerReturn,
  cast(CustomerReturnPartner.PartnerFunction as parvw_unv preserving type) AS PartnerFunction,
  cast(CustomerReturnPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunctionForEdit,
  CustomerReturnPartner.Customer AS Customer,
  CustomerReturnPartner.Supplier AS Supplier,
  CustomerReturnPartner.Personnel AS Personnel,
  CustomerReturnPartner.ContactPerson AS ContactPerson,
  CustomerReturnPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  CustomerReturnPartner.Partner AS Partner,
  cast('' as ad_name1) AS BusinessPartnerName1,
  cast('' as ad_name2) AS BusinessPartnerName2,
  cast('' as ad_name3) AS BusinessPartnerName3,
  cast('' as ad_name4) AS BusinessPartnerName4,
  CustomerReturnPartner.FullName AS FullName,
  _PartnerFunction.SDDocumentPartnerType AS SDDocumentPartnerType,
  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,
  CustomerReturnPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  CustomerReturnPartner.InternationalFaxNumber AS InternationalFaxNumber,
  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.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  CustomerReturnPartner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  CustomerReturnPartner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  CustomerReturnPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  _CustomerReturn.CustomerReturnType AS CustomerReturnType,
  _CustomerReturn.SalesOrganization AS SalesOrganization,
  _CustomerReturn.DistributionChannel AS DistributionChannel,
  _CustomerReturn.OrganizationDivision AS OrganizationDivision,
  CustomerReturnPartner._DfltAddrRprstn AS _DfltAddrRprstn,
  CustomerReturnPartner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  CustomerReturnPartner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr,
  CustomerReturnPartner._OrgNamePostalAddress._Country AS _Country,
  CustomerReturnPartner._OrgNamePostalAddress._Region AS _Region
FROM I_CustomerReturnPartner AS CustomerReturnPartner
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON PartnerFunctionForEdit = _PartnerFunction.PartnerFunction  -- association [0..1]
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]
LEFT OUTER JOIN I_AddrCurDfltLandlinePhoneNmbr AS _CurrentDfltLandlinePhoneNmbr ON AddressID = _CurrentDfltLandlinePhoneNmbr.AddressID AND AddressPersonID = _CurrentDfltLandlinePhoneNmbr.AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltMobilePhoneNumber AS _CurrentDfltMobilePhoneNumber ON AddressID = _CurrentDfltMobilePhoneNumber.AddressID AND AddressPersonID = _CurrentDfltMobilePhoneNumber.AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDefaultFaxNumber AS _CurrentDfltFaxNumber ON AddressID = _CurrentDfltFaxNumber.AddressID AND AddressPersonID = _CurrentDfltFaxNumber.AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_WorkplaceAddress AS _WorkPlaceAddress ON ReferenceBusinessPartner = _WorkPlaceAddress.BusinessPartner  -- association [1]
;

Learn More