A_CustomerReturnPartner_2

DDL: A_CUSTOMERRETURNPARTNER_2 Type: view_entity CONSUMPTION Package: P_SLSCRET_INTEGRATION_ODATA
47 Fields 1 Data Sources 1 OData Services

Header Partners

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

Data Sources (1)

SourceAliasJoin Type
R_CustomerReturnPartnerTP R_CustomerReturnPartnerTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Header Partners view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
OData.entityType.name CustomerReturnPartner_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 (47)

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

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_CustomerReturnPartner_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_CustomerReturnPartner_2 AS
SELECT
  CustomerReturnPartner.CustomerReturn AS CustomerReturn,
  cast(CustomerReturnPartner.PartnerFunction as parvw_unv preserving type) AS PartnerFunction,
  CustomerReturnPartner.Customer AS Customer,
  CustomerReturnPartner.Supplier AS Supplier,
  CustomerReturnPartner.Personnel AS Personnel,
  CustomerReturnPartner.ContactPerson AS ContactPerson,
  CustomerReturnPartner.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,
  CustomerReturnPartner.AddressID AS AddressID,
  CustomerReturnPartner.AddressPersonID AS AddressPersonID,
  CustomerReturnPartner.AddressObjectType AS AddressObjectType,
  CustomerReturnPartner.StreetName AS StreetName,
  CustomerReturnPartner.StreetPrefixName1 AS StreetPrefixName1,
  CustomerReturnPartner.StreetPrefixName2 AS StreetPrefixName2,
  CustomerReturnPartner.StreetSuffixName1 AS StreetSuffixName1,
  CustomerReturnPartner.StreetSuffixName2 AS StreetSuffixName2,
  CustomerReturnPartner.HouseNumber AS HouseNumber,
  CustomerReturnPartner.PostalCode AS PostalCode,
  CustomerReturnPartner.CityName AS CityName,
  CustomerReturnPartner.DistrictName AS DistrictName,
  CustomerReturnPartner.Region AS Region,
  CustomerReturnPartner.Country AS Country,
  CustomerReturnPartner.PhoneNumberCountry AS PhoneNumberCountry,
  CustomerReturnPartner.PhoneNumber AS PhoneNumber,
  CustomerReturnPartner.PhoneNumberExtension AS PhoneNumberExtension,
  CustomerReturnPartner.MobilePhoneCountry AS MobilePhoneCountry,
  CustomerReturnPartner.MobilePhoneNumber AS MobilePhoneNumber,
  CustomerReturnPartner.FaxNumberCountry AS FaxNumberCountry,
  CustomerReturnPartner.FaxNumber AS FaxNumber,
  CustomerReturnPartner.FaxNumberExtension AS FaxNumberExtension,
  CustomerReturnPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  CustomerReturnPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  CustomerReturnPartner.InternationalFaxNumber AS InternationalFaxNumber,
  CustomerReturnPartner.POBox AS POBox,
  CustomerReturnPartner.POBoxPostalCode AS POBoxPostalCode,
  CustomerReturnPartner.FormOfAddress AS FormOfAddress,
  CustomerReturnPartner.EmailAddress AS EmailAddress,
  CustomerReturnPartner.TaxJurisdiction AS TaxJurisdiction,
  CustomerReturnPartner.TransportZone AS TransportZone,
  CustomerReturnPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  CustomerReturnPartner.CustomerReturnType AS CustomerReturnType,
  CustomerReturnPartner.OrganizationDivision AS OrganizationDivision,
  CustomerReturnPartner.SalesOrganization AS SalesOrganization,
  CustomerReturnPartner.DistributionChannel AS DistributionChannel
FROM R_CustomerReturnPartnerTP
;

Learn More