R_CustomerReturnItemPartnerTP

DDL: R_CUSTOMERRETURNITEMPARTNERTP Type: view_entity TRANSACTIONAL
54 Fields 2 Data Sources 5 Associations

Returns Order Item Partner - TP

R_CustomerReturnItemPartnerTP is a Transactional CDS View that provides data about "Returns Order Item Partner - TP" in SAP S/4HANA. It reads from 2 data sources (I_SalesDocumentBasic, I_SalesDocItemCompletePartner) and exposes 54 fields with key fields CustomerReturn, CustomerReturnItem, PartnerFunction. It has 5 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_SalesDocumentBasic CustomerReturn inner
I_SalesDocItemCompletePartner CustomerReturnItemPartner from

Associations (5)

CardinalityTargetAliasCondition
[1..1] R_CustomerReturnTP _CustomerReturn $projection.CustomerReturn = _CustomerReturn.CustomerReturn
[0..1] I_PartnerFunction _PartnerFunction $projection.PartnerFunctionForEdit = _PartnerFunction.PartnerFunction
[0..1] I_FormOfAddress _FormOfAddress $projection.FormOfAddress = _FormOfAddress.FormOfAddress
[0..1] I_Language _CorrespondenceLanguage $projection.CorrespondenceLanguage = _CorrespondenceLanguage.Language
[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 Returns Order Item Partner - TP view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn
KEY CustomerReturnItem
KEY PartnerFunction
PartnerFunctionForEdit
Customer I_SalesDocItemCompletePartner Customer Sold-to Party
Supplier I_SalesDocItemCompletePartner Supplier Supplier
Personnel I_SalesDocItemCompletePartner Personnel Personnel No.
ContactPerson I_SalesDocItemCompletePartner ContactPerson Contact Person Key
Partner I_SalesDocItemCompletePartner Partner With Partner
FullName I_SalesDocItemCompletePartner FullName Name
SDDocumentPartnerType _PartnerFunction SDDocumentPartnerType Partner Type
FormOfAddress I_SalesDocItemCompletePartner FormOfAddress Title Key
StreetName
HouseNumber
PostalCode
Country
Region
DistrictName
CityName
POBox
POBoxPostalCode
CorrespondenceLanguage I_SalesDocItemCompletePartner CorrespondenceLanguage Language
TaxJurisdiction
TransportZone
PartnerIsSpecificForSDDocItem I_SalesDocItemCompletePartner PartnerIsSpecificForSDDocItem
ReferenceBusinessPartner I_SalesDocItemCompletePartner ReferenceBusinessPartner Busn. Partner
AddressID I_SalesDocItemCompletePartner AddressID Ship-to address
AddressPersonID I_SalesDocItemCompletePartner AddressPersonID Person Number
AddressObjectType I_SalesDocItemCompletePartner AddressObjectType Address Type
SDDocPartnerAddrIsDocSpecific I_SalesDocItemCompletePartner SDDocPartnerAddrIsDocSpecific
VATRegistration I_SalesDocItemCompletePartner VATRegistration VAT Registration No.
UnloadingPointName I_SalesDocItemCompletePartner UnloadingPointName Unloading Point Name
InternationalPhoneNumber I_SalesDocItemCompletePartner InternationalPhoneNumber Telephone no.
InternationalMobilePhoneNumber I_SalesDocItemCompletePartner InternationalMobilePhoneNumber
EmailAddress I_SalesDocItemCompletePartner EmailAddress E-Mail Address
SDDocPartnerAddressRefType I_SalesDocItemCompletePartner SDDocPartnerAddressRefType Adress ind.
BPAddrDeterminationTransaction I_SalesDocItemCompletePartner BPAddrDeterminationTransaction Address Detn
BPRefAddressIDForDocSpcfcAddr I_SalesDocItemCompletePartner BPRefAddressIDForDocSpcfcAddr BP Ref. Address Num.
CustomerReturnType _CustomerReturn CustomerReturnType
SalesOrganization _CustomerReturn SalesOrganization Sales Organization
DistributionChannel _CustomerReturn DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _CustomerReturn OrganizationDivision Org. Division
_Item _Item
_CustomerReturn _CustomerReturn
_PartnerFunction _PartnerFunction
_CorrespondenceLanguage _CorrespondenceLanguage
_TransportationZone _TransportationZone
_FormOfAddress _FormOfAddress
_ContactPerson I_SalesDocItemCompletePartner _ContactPerson
_DfltAddrRprstn I_SalesDocItemCompletePartner _DfltAddrRprstn
_BusinessPartnerAddress I_SalesDocItemCompletePartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_SalesDocItemCompletePartner _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_CustomerReturnItemPartnerTP.
-- 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_CustomerReturnItemPartnerTP AS
SELECT
  cast(CustomerReturnItemPartner.SalesDocument as vdm_customer_return preserving type) AS CustomerReturn,
  cast(CustomerReturnItemPartner.SalesDocumentItem as vdm_customer_return_item preserving type) AS CustomerReturnItem,
  cast(CustomerReturnItemPartner.PartnerFunction as parvw_unv preserving type) AS PartnerFunction,
  cast(CustomerReturnItemPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunctionForEdit,
  CustomerReturnItemPartner.Customer AS Customer,
  CustomerReturnItemPartner.Supplier AS Supplier,
  CustomerReturnItemPartner.Personnel AS Personnel,
  CustomerReturnItemPartner.ContactPerson AS ContactPerson,
  CustomerReturnItemPartner.Partner AS Partner,
  CustomerReturnItemPartner.FullName AS FullName,
  _PartnerFunction.SDDocumentPartnerType AS SDDocumentPartnerType,
  CustomerReturnItemPartner.FormOfAddress AS FormOfAddress,
  CustomerReturnItemPartner._OrgNamePostalAddress.StreetName AS StreetName,
  CustomerReturnItemPartner._OrgNamePostalAddress.HouseNumber AS HouseNumber,
  CustomerReturnItemPartner._OrgNamePostalAddress.PostalCode AS PostalCode,
  CustomerReturnItemPartner._OrgNamePostalAddress.Country AS Country,
  CustomerReturnItemPartner._OrgNamePostalAddress.Region AS Region,
  CustomerReturnItemPartner._OrgNamePostalAddress.DistrictName AS DistrictName,
  CustomerReturnItemPartner._OrgNamePostalAddress.CityName AS CityName,
  CustomerReturnItemPartner._OrgNamePostalAddress.POBox AS POBox,
  CustomerReturnItemPartner._OrgNamePostalAddress.POBoxPostalCode AS POBoxPostalCode,
  CustomerReturnItemPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  CustomerReturnItemPartner._OrgNamePostalAddress.TaxJurisdiction AS TaxJurisdiction,
  CustomerReturnItemPartner._OrgNamePostalAddress.TransportZone AS TransportZone,
  CustomerReturnItemPartner.PartnerIsSpecificForSDDocItem AS PartnerIsSpecificForSDDocItem,
  CustomerReturnItemPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  CustomerReturnItemPartner.AddressID AS AddressID,
  CustomerReturnItemPartner.AddressPersonID AS AddressPersonID,
  CustomerReturnItemPartner.AddressObjectType AS AddressObjectType,
  CustomerReturnItemPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  CustomerReturnItemPartner.VATRegistration AS VATRegistration,
  CustomerReturnItemPartner.UnloadingPointName AS UnloadingPointName,
  CustomerReturnItemPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  CustomerReturnItemPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  CustomerReturnItemPartner.EmailAddress AS EmailAddress,
  CustomerReturnItemPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  CustomerReturnItemPartner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  CustomerReturnItemPartner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  _CustomerReturn.CustomerReturnType AS CustomerReturnType,
  _CustomerReturn.SalesOrganization AS SalesOrganization,
  _CustomerReturn.DistributionChannel AS DistributionChannel,
  _CustomerReturn.OrganizationDivision AS OrganizationDivision,
  CustomerReturnItemPartner._ContactPerson AS _ContactPerson,
  CustomerReturnItemPartner._DfltAddrRprstn AS _DfltAddrRprstn,
  CustomerReturnItemPartner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  CustomerReturnItemPartner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr,
  CustomerReturnItemPartner._OrgNamePostalAddress._Country AS _Country,
  CustomerReturnItemPartner._OrgNamePostalAddress._Region AS _Region
FROM I_SalesDocItemCompletePartner AS CustomerReturnItemPartner
INNER JOIN I_SalesDocumentBasic AS CustomerReturn ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_CustomerReturnTP AS _CustomerReturn ON CustomerReturn = _CustomerReturn.CustomerReturn  -- association [1..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON PartnerFunctionForEdit = _PartnerFunction.PartnerFunction  -- association [0..1]
LEFT OUTER JOIN I_FormOfAddress AS _FormOfAddress ON FormOfAddress = _FormOfAddress.FormOfAddress  -- association [0..1]
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]
;

Learn More