A_CustomerReturnItemPartner_2

DDL: A_CUSTOMERRETURNITEMPARTNER_2 Type: view_entity CONSUMPTION Package: P_SLSCRET_INTEGRATION_ODATA
49 Fields 1 Data Sources 1 OData Services

Item Partners

A_CustomerReturnItemPartner_2 is a Consumption CDS View that provides data about "Item Partners" in SAP S/4HANA. It reads from 1 data source (R_CustomerReturnItemPartnerTP) and exposes 49 fields with key fields CustomerReturn, CustomerReturnItem, PartnerFunction. It is exposed through 1 OData service (API_CUSTOMERRETURN). Part of development package P_SLSCRET_INTEGRATION_ODATA.

Data Sources (1)

SourceAliasJoin Type
R_CustomerReturnItemPartnerTP R_CustomerReturnItemPartnerTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Item Partners view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
OData.entityType.name CustomerReturnItemPartner_Type view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
API_CUSTOMERRETURN API_CUSTOMERRETURN V4 C2 C1

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn CustomerReturnItemPartner CustomerReturn
KEY CustomerReturnItem CustomerReturnItemPartner CustomerReturnItem
KEY PartnerFunction
Customer CustomerReturnItemPartner Customer Sold-to Party
Supplier CustomerReturnItemPartner Supplier Supplier
Personnel CustomerReturnItemPartner Personnel Personnel No.
ContactPerson CustomerReturnItemPartner ContactPerson Contact Person Key
ReferenceBusinessPartner CustomerReturnItemPartner ReferenceBusinessPartner Busn. Partner
virtualBusinessPartnerName1ad_name1
virtualBusinessPartnerName2ad_name2
virtualBusinessPartnerName3ad_name3
virtualBusinessPartnerName4ad_name4
AddressID CustomerReturnItemPartner AddressID Ship-to address
AddressPersonID CustomerReturnItemPartner AddressPersonID Person Number
AddressObjectType CustomerReturnItemPartner AddressObjectType Address Type
StreetName CustomerReturnItemPartner StreetName Text
StreetPrefixName1 CustomerReturnItemPartner StreetPrefixName1 Street 2
StreetPrefixName2 CustomerReturnItemPartner StreetPrefixName2 Street 3
StreetSuffixName1 CustomerReturnItemPartner StreetSuffixName1 Street 4
StreetSuffixName2 CustomerReturnItemPartner StreetSuffixName2 Street 5
HouseNumber CustomerReturnItemPartner HouseNumber House Number
PostalCode CustomerReturnItemPartner PostalCode Postal Code
CityName CustomerReturnItemPartner CityName Name
DistrictName CustomerReturnItemPartner DistrictName District
Region CustomerReturnItemPartner Region Venue Region
Country CustomerReturnItemPartner Country Venue: Ctry/Reg
PhoneNumberCountry CustomerReturnItemPartner PhoneNumberCountry
PhoneNumber CustomerReturnItemPartner PhoneNumber Telephone no.
PhoneNumberExtension CustomerReturnItemPartner PhoneNumberExtension Extension
MobilePhoneCountry CustomerReturnItemPartner MobilePhoneCountry Country/Region
MobilePhoneNumber CustomerReturnItemPartner MobilePhoneNumber Telephone
FaxNumberCountry CustomerReturnItemPartner FaxNumberCountry Country/Region
FaxNumber CustomerReturnItemPartner FaxNumber Fax Number
FaxNumberExtension CustomerReturnItemPartner FaxNumberExtension Extension
InternationalPhoneNumber CustomerReturnItemPartner InternationalPhoneNumber Telephone no.
InternationalMobilePhoneNumber CustomerReturnItemPartner InternationalMobilePhoneNumber
InternationalFaxNumber CustomerReturnItemPartner InternationalFaxNumber Fax Number
POBox CustomerReturnItemPartner POBox PO Box
POBoxPostalCode CustomerReturnItemPartner POBoxPostalCode PO Box Postal Code
FormOfAddress CustomerReturnItemPartner FormOfAddress Title Key
EmailAddress CustomerReturnItemPartner EmailAddress E-Mail Address
TaxJurisdiction CustomerReturnItemPartner TaxJurisdiction Tax Jurisdiction
TransportZone CustomerReturnItemPartner TransportZone Transport Zone
PartnerIsSpecificForSDDocItem CustomerReturnItemPartner PartnerIsSpecificForSDDocItem
SDDocPartnerAddrIsDocSpecific CustomerReturnItemPartner SDDocPartnerAddrIsDocSpecific
CustomerReturnType CustomerReturnItemPartner CustomerReturnType
SalesOrganization CustomerReturnItemPartner SalesOrganization Sales Organization
DistributionChannel CustomerReturnItemPartner DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision CustomerReturnItemPartner OrganizationDivision Org. Division

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 A_CustomerReturnItemPartner_2.
-- 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 A_CustomerReturnItemPartner_2 AS
SELECT
  CustomerReturnItemPartner.CustomerReturn AS CustomerReturn,
  CustomerReturnItemPartner.CustomerReturnItem AS CustomerReturnItem,
  cast(CustomerReturnItemPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  CustomerReturnItemPartner.Customer AS Customer,
  CustomerReturnItemPartner.Supplier AS Supplier,
  CustomerReturnItemPartner.Personnel AS Personnel,
  CustomerReturnItemPartner.ContactPerson AS ContactPerson,
  CustomerReturnItemPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  virtual BusinessPartnerName1 : ad_name1 AS virtualBusinessPartnerName1ad_name1,
  virtual BusinessPartnerName2 : ad_name2 AS virtualBusinessPartnerName2ad_name2,
  virtual BusinessPartnerName3 : ad_name3 AS virtualBusinessPartnerName3ad_name3,
  virtual BusinessPartnerName4 : ad_name4 AS virtualBusinessPartnerName4ad_name4,
  CustomerReturnItemPartner.AddressID AS AddressID,
  CustomerReturnItemPartner.AddressPersonID AS AddressPersonID,
  CustomerReturnItemPartner.AddressObjectType AS AddressObjectType,
  CustomerReturnItemPartner.StreetName AS StreetName,
  CustomerReturnItemPartner.StreetPrefixName1 AS StreetPrefixName1,
  CustomerReturnItemPartner.StreetPrefixName2 AS StreetPrefixName2,
  CustomerReturnItemPartner.StreetSuffixName1 AS StreetSuffixName1,
  CustomerReturnItemPartner.StreetSuffixName2 AS StreetSuffixName2,
  CustomerReturnItemPartner.HouseNumber AS HouseNumber,
  CustomerReturnItemPartner.PostalCode AS PostalCode,
  CustomerReturnItemPartner.CityName AS CityName,
  CustomerReturnItemPartner.DistrictName AS DistrictName,
  CustomerReturnItemPartner.Region AS Region,
  CustomerReturnItemPartner.Country AS Country,
  CustomerReturnItemPartner.PhoneNumberCountry AS PhoneNumberCountry,
  CustomerReturnItemPartner.PhoneNumber AS PhoneNumber,
  CustomerReturnItemPartner.PhoneNumberExtension AS PhoneNumberExtension,
  CustomerReturnItemPartner.MobilePhoneCountry AS MobilePhoneCountry,
  CustomerReturnItemPartner.MobilePhoneNumber AS MobilePhoneNumber,
  CustomerReturnItemPartner.FaxNumberCountry AS FaxNumberCountry,
  CustomerReturnItemPartner.FaxNumber AS FaxNumber,
  CustomerReturnItemPartner.FaxNumberExtension AS FaxNumberExtension,
  CustomerReturnItemPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  CustomerReturnItemPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  CustomerReturnItemPartner.InternationalFaxNumber AS InternationalFaxNumber,
  CustomerReturnItemPartner.POBox AS POBox,
  CustomerReturnItemPartner.POBoxPostalCode AS POBoxPostalCode,
  CustomerReturnItemPartner.FormOfAddress AS FormOfAddress,
  CustomerReturnItemPartner.EmailAddress AS EmailAddress,
  CustomerReturnItemPartner.TaxJurisdiction AS TaxJurisdiction,
  CustomerReturnItemPartner.TransportZone AS TransportZone,
  CustomerReturnItemPartner.PartnerIsSpecificForSDDocItem AS PartnerIsSpecificForSDDocItem,
  CustomerReturnItemPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  CustomerReturnItemPartner.CustomerReturnType AS CustomerReturnType,
  CustomerReturnItemPartner.SalesOrganization AS SalesOrganization,
  CustomerReturnItemPartner.DistributionChannel AS DistributionChannel,
  CustomerReturnItemPartner.OrganizationDivision AS OrganizationDivision
FROM R_CustomerReturnItemPartnerTP
;

Learn More