A_SalesOrderItemPartner_2

DDL: A_SALESORDERITEMPARTNER_2 Type: view_entity CONSUMPTION
42 Fields 1 Data Sources

Sales Order Item Partner

A_SalesOrderItemPartner_2 is a Consumption CDS View that provides data about "Sales Order Item Partner" in SAP S/4HANA. It reads from 1 data source (R_SalesOrderItemPartnerTP) and exposes 42 fields with key fields SalesOrder, SalesOrderItem, PartnerFunction.

Data Sources (1)

SourceAliasJoin Type
R_SalesOrderItemPartnerTP R_SalesOrderItemPartnerTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Sales Order Item Partner view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name SalesOrderItemPartner_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

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesOrderItemPartner SalesOrder SD Document
KEY SalesOrderItem SalesOrderItemPartner SalesOrderItem Sales Order Item
KEY PartnerFunction
Customer SalesOrderItemPartner Customer Sold-to Party
Supplier SalesOrderItemPartner Supplier Supplier
Personnel SalesOrderItemPartner Personnel Personnel No.
ContactPerson SalesOrderItemPartner ContactPerson Contact Person Key
ReferenceBusinessPartner SalesOrderItemPartner ReferenceBusinessPartner Busn. Partner
virtualBusinessPartnerName1ad_name1
virtualBusinessPartnerName2ad_name2
virtualBusinessPartnerName3ad_name3
virtualBusinessPartnerName4ad_name4
AddressID SalesOrderItemPartner AddressID Ship-to address
AddressPersonID SalesOrderItemPartner AddressPersonID Person Number
AddressObjectType SalesOrderItemPartner AddressObjectType Address Type
StreetName SalesOrderItemPartner StreetName Text
StreetPrefixName1 SalesOrderItemPartner StreetPrefixName1 Street 2
StreetPrefixName2 SalesOrderItemPartner StreetPrefixName2 Street 3
StreetSuffixName1 SalesOrderItemPartner StreetSuffixName1 Street 4
StreetSuffixName2 SalesOrderItemPartner StreetSuffixName2 Street 5
HouseNumber SalesOrderItemPartner HouseNumber House Number
PostalCode SalesOrderItemPartner PostalCode Postal Code
CityName SalesOrderItemPartner CityName Name
DistrictName SalesOrderItemPartner DistrictName District
Region SalesOrderItemPartner Region Venue Region
Country SalesOrderItemPartner Country Venue: Ctry/Reg
InternationalPhoneNumber SalesOrderItemPartner InternationalPhoneNumber Telephone no.
InternationalMobilePhoneNumber SalesOrderItemPartner InternationalMobilePhoneNumber
POBox SalesOrderItemPartner POBox PO Box
POBoxPostalCode SalesOrderItemPartner POBoxPostalCode PO Box Postal Code
FormOfAddress SalesOrderItemPartner FormOfAddress Title Key
EmailAddress SalesOrderItemPartner EmailAddress E-Mail Address
TaxJurisdiction SalesOrderItemPartner TaxJurisdiction Tax Jurisdiction
TransportZone SalesOrderItemPartner TransportZone Transport Zone
UnloadingPointName SalesOrderItemPartner UnloadingPointName Unloading Point Name
VATRegistration SalesOrderItemPartner VATRegistration VAT Registration No.
PartnerIsSpecificForSDDocItem SalesOrderItemPartner PartnerIsSpecificForSDDocItem
SDDocPartnerAddrIsDocSpecific SalesOrderItemPartner SDDocPartnerAddrIsDocSpecific
SalesOrderType SalesOrderItemPartner SalesOrderType Sales Order Type
SalesOrganization SalesOrderItemPartner SalesOrganization Sales Organization
DistributionChannel SalesOrderItemPartner DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision SalesOrderItemPartner 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_SalesOrderItemPartner_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_SalesOrderItemPartner_2 AS
SELECT
  SalesOrderItemPartner.SalesOrder AS SalesOrder,
  SalesOrderItemPartner.SalesOrderItem AS SalesOrderItem,
  cast(SalesOrderItemPartner.PartnerFunction as parvw_unv preserving type) AS PartnerFunction,
  SalesOrderItemPartner.Customer AS Customer,
  SalesOrderItemPartner.Supplier AS Supplier,
  SalesOrderItemPartner.Personnel AS Personnel,
  SalesOrderItemPartner.ContactPerson AS ContactPerson,
  SalesOrderItemPartner.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,
  SalesOrderItemPartner.AddressID AS AddressID,
  SalesOrderItemPartner.AddressPersonID AS AddressPersonID,
  SalesOrderItemPartner.AddressObjectType AS AddressObjectType,
  SalesOrderItemPartner.StreetName AS StreetName,
  SalesOrderItemPartner.StreetPrefixName1 AS StreetPrefixName1,
  SalesOrderItemPartner.StreetPrefixName2 AS StreetPrefixName2,
  SalesOrderItemPartner.StreetSuffixName1 AS StreetSuffixName1,
  SalesOrderItemPartner.StreetSuffixName2 AS StreetSuffixName2,
  SalesOrderItemPartner.HouseNumber AS HouseNumber,
  SalesOrderItemPartner.PostalCode AS PostalCode,
  SalesOrderItemPartner.CityName AS CityName,
  SalesOrderItemPartner.DistrictName AS DistrictName,
  SalesOrderItemPartner.Region AS Region,
  SalesOrderItemPartner.Country AS Country,
  SalesOrderItemPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  SalesOrderItemPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  SalesOrderItemPartner.POBox AS POBox,
  SalesOrderItemPartner.POBoxPostalCode AS POBoxPostalCode,
  SalesOrderItemPartner.FormOfAddress AS FormOfAddress,
  SalesOrderItemPartner.EmailAddress AS EmailAddress,
  SalesOrderItemPartner.TaxJurisdiction AS TaxJurisdiction,
  SalesOrderItemPartner.TransportZone AS TransportZone,
  SalesOrderItemPartner.UnloadingPointName AS UnloadingPointName,
  SalesOrderItemPartner.VATRegistration AS VATRegistration,
  SalesOrderItemPartner.PartnerIsSpecificForSDDocItem AS PartnerIsSpecificForSDDocItem,
  SalesOrderItemPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  SalesOrderItemPartner.SalesOrderType AS SalesOrderType,
  SalesOrderItemPartner.SalesOrganization AS SalesOrganization,
  SalesOrderItemPartner.DistributionChannel AS DistributionChannel,
  SalesOrderItemPartner.OrganizationDivision AS OrganizationDivision
FROM R_SalesOrderItemPartnerTP
;

Learn More