A_SalesOrderPartner_2

DDL: A_SALESORDERPARTNER_2 Type: view_entity CONSUMPTION Package: ODATA_SD_SALESORDER_API
50 Fields 1 Data Sources 1 OData Services

Header Partner

A_SalesOrderPartner_2 is a Consumption CDS View that provides data about "Header Partner" in SAP S/4HANA. It reads from 1 data source (R_SalesOrderPartnerTP) and exposes 50 fields with key fields SalesOrder, PartnerFunction. It is exposed through 1 OData service (API_SALESORDER). Part of development package ODATA_SD_SALESORDER_API.

Data Sources (1)

SourceAliasJoin Type
R_SalesOrderPartnerTP R_SalesOrderPartnerTP projection

Annotations (9)

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

OData Services (1)

ServiceBindingVersionContractRelease
API_SALESORDER API_SALESORDER V4 C2 C1

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesOrderPartner SalesOrder SD Document
KEY PartnerFunction SalesOrderPartner PartnerFunction Partner Functn
Customer SalesOrderPartner Customer Sold-to Party
Supplier SalesOrderPartner Supplier Supplier
Personnel SalesOrderPartner Personnel Personnel No.
ContactPerson SalesOrderPartner ContactPerson Contact Person Key
WorkAssignmentExternalID SalesOrderPartner WorkAssignmentExternalID WFA Ext. ID
ReferenceBusinessPartner SalesOrderPartner ReferenceBusinessPartner Busn. Partner
virtualBusinessPartnerName1ad_name1
virtualBusinessPartnerName2ad_name2
virtualBusinessPartnerName3ad_name3
virtualBusinessPartnerName4ad_name4
AddressID SalesOrderPartner AddressID Ship-to address
AddressPersonID SalesOrderPartner AddressPersonID Person Number
AddressObjectType SalesOrderPartner AddressObjectType Address Type
StreetName SalesOrderPartner StreetName Text
StreetPrefixName1 SalesOrderPartner StreetPrefixName1 Street 2
StreetPrefixName2 SalesOrderPartner StreetPrefixName2 Street 3
StreetSuffixName1 SalesOrderPartner StreetSuffixName1 Street 4
StreetSuffixName2 SalesOrderPartner StreetSuffixName2 Street 5
HouseNumber SalesOrderPartner HouseNumber House Number
PostalCode SalesOrderPartner PostalCode Postal Code
CityName SalesOrderPartner CityName Name
DistrictName SalesOrderPartner DistrictName District
Region SalesOrderPartner Region Venue Region
Country SalesOrderPartner Country Venue: Ctry/Reg
PhoneNumberCountry SalesOrderPartner PhoneNumberCountry
PhoneNumber SalesOrderPartner PhoneNumber Telephone no.
PhoneNumberExtension SalesOrderPartner PhoneNumberExtension Extension
MobilePhoneCountry SalesOrderPartner MobilePhoneCountry Country/Region
MobilePhoneNumber SalesOrderPartner MobilePhoneNumber Telephone
FaxNumberCountry SalesOrderPartner FaxNumberCountry Country/Region
FaxNumber SalesOrderPartner FaxNumber Fax Number
FaxNumberExtension SalesOrderPartner FaxNumberExtension Extension
InternationalPhoneNumber SalesOrderPartner InternationalPhoneNumber Telephone no.
InternationalMobilePhoneNumber SalesOrderPartner InternationalMobilePhoneNumber
InternationalFaxNumber SalesOrderPartner InternationalFaxNumber Fax Number
POBox SalesOrderPartner POBox PO Box
POBoxPostalCode SalesOrderPartner POBoxPostalCode PO Box Postal Code
FormOfAddress SalesOrderPartner FormOfAddress Title Key
EmailAddress SalesOrderPartner EmailAddress E-Mail Address
TaxJurisdiction SalesOrderPartner TaxJurisdiction Tax Jurisdiction
TransportZone SalesOrderPartner TransportZone Transport Zone
UnloadingPointName SalesOrderPartner UnloadingPointName Unloading Point Name
VATRegistration SalesOrderPartner VATRegistration VAT Registration No.
SDDocPartnerAddrIsDocSpecific SalesOrderPartner SDDocPartnerAddrIsDocSpecific
SalesOrderType SalesOrderPartner SalesOrderType Sales Order Type
OrganizationDivision SalesOrderPartner OrganizationDivision Org. Division
SalesOrganization SalesOrderPartner SalesOrganization Sales Organization
DistributionChannel SalesOrderPartner 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_SalesOrderPartner_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_SalesOrderPartner_2 AS
SELECT
  SalesOrderPartner.SalesOrder AS SalesOrder,
  SalesOrderPartner.PartnerFunction AS PartnerFunction,
  SalesOrderPartner.Customer AS Customer,
  SalesOrderPartner.Supplier AS Supplier,
  SalesOrderPartner.Personnel AS Personnel,
  SalesOrderPartner.ContactPerson AS ContactPerson,
  SalesOrderPartner.WorkAssignmentExternalID AS WorkAssignmentExternalID,
  SalesOrderPartner.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,
  SalesOrderPartner.AddressID AS AddressID,
  SalesOrderPartner.AddressPersonID AS AddressPersonID,
  SalesOrderPartner.AddressObjectType AS AddressObjectType,
  SalesOrderPartner.StreetName AS StreetName,
  SalesOrderPartner.StreetPrefixName1 AS StreetPrefixName1,
  SalesOrderPartner.StreetPrefixName2 AS StreetPrefixName2,
  SalesOrderPartner.StreetSuffixName1 AS StreetSuffixName1,
  SalesOrderPartner.StreetSuffixName2 AS StreetSuffixName2,
  SalesOrderPartner.HouseNumber AS HouseNumber,
  SalesOrderPartner.PostalCode AS PostalCode,
  SalesOrderPartner.CityName AS CityName,
  SalesOrderPartner.DistrictName AS DistrictName,
  SalesOrderPartner.Region AS Region,
  SalesOrderPartner.Country AS Country,
  SalesOrderPartner.PhoneNumberCountry AS PhoneNumberCountry,
  SalesOrderPartner.PhoneNumber AS PhoneNumber,
  SalesOrderPartner.PhoneNumberExtension AS PhoneNumberExtension,
  SalesOrderPartner.MobilePhoneCountry AS MobilePhoneCountry,
  SalesOrderPartner.MobilePhoneNumber AS MobilePhoneNumber,
  SalesOrderPartner.FaxNumberCountry AS FaxNumberCountry,
  SalesOrderPartner.FaxNumber AS FaxNumber,
  SalesOrderPartner.FaxNumberExtension AS FaxNumberExtension,
  SalesOrderPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  SalesOrderPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  SalesOrderPartner.InternationalFaxNumber AS InternationalFaxNumber,
  SalesOrderPartner.POBox AS POBox,
  SalesOrderPartner.POBoxPostalCode AS POBoxPostalCode,
  SalesOrderPartner.FormOfAddress AS FormOfAddress,
  SalesOrderPartner.EmailAddress AS EmailAddress,
  SalesOrderPartner.TaxJurisdiction AS TaxJurisdiction,
  SalesOrderPartner.TransportZone AS TransportZone,
  SalesOrderPartner.UnloadingPointName AS UnloadingPointName,
  SalesOrderPartner.VATRegistration AS VATRegistration,
  SalesOrderPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  SalesOrderPartner.SalesOrderType AS SalesOrderType,
  SalesOrderPartner.OrganizationDivision AS OrganizationDivision,
  SalesOrderPartner.SalesOrganization AS SalesOrganization,
  SalesOrderPartner.DistributionChannel AS DistributionChannel
FROM R_SalesOrderPartnerTP
;

Learn More