R_SalesOrderItemPartnerTP

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

Partner for Sales Order Item - TP

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

Data Sources (2)

SourceAliasJoin Type
I_SalesDocumentBasic SalesOrder inner
I_SalesDocItemCompletePartner SalesOrderItemPartner from

Associations (5)

CardinalityTargetAliasCondition
[1..1] R_SalesOrderTP _SalesOrder $projection.SalesOrder = _SalesOrder.SalesOrder
[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 Partner for Sales Order Item - TP view

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder
KEY SalesOrderItem
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.
SalesOrderType _SalesOrder SalesOrderType Sales Order Type
SalesOrganization _SalesOrder SalesOrganization Sales Organization
DistributionChannel _SalesOrder DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision _SalesOrder OrganizationDivision Org. Division
_Item _Item
_SalesOrder _SalesOrder
_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_SalesOrderItemPartnerTP.
-- 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_SalesOrderItemPartnerTP AS
SELECT
  cast(SalesOrderItemPartner.SalesDocument as vdm_sales_order preserving type) AS SalesOrder,
  cast(SalesOrderItemPartner.SalesDocumentItem as sales_order_item preserving type) AS SalesOrderItem,
  cast(SalesOrderItemPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunction,
  cast(SalesOrderItemPartner.PartnerFunction as parvw_unv preserving type ) AS PartnerFunctionForEdit,
  SalesOrderItemPartner.Customer AS Customer,
  SalesOrderItemPartner.Supplier AS Supplier,
  SalesOrderItemPartner.Personnel AS Personnel,
  SalesOrderItemPartner.ContactPerson AS ContactPerson,
  SalesOrderItemPartner.Partner AS Partner,
  SalesOrderItemPartner.FullName AS FullName,
  _PartnerFunction.SDDocumentPartnerType AS SDDocumentPartnerType,
  SalesOrderItemPartner.FormOfAddress AS FormOfAddress,
  SalesOrderItemPartner._OrgNamePostalAddress.StreetName AS StreetName,
  SalesOrderItemPartner._OrgNamePostalAddress.HouseNumber AS HouseNumber,
  SalesOrderItemPartner._OrgNamePostalAddress.PostalCode AS PostalCode,
  SalesOrderItemPartner._OrgNamePostalAddress.Country AS Country,
  SalesOrderItemPartner._OrgNamePostalAddress.Region AS Region,
  SalesOrderItemPartner._OrgNamePostalAddress.DistrictName AS DistrictName,
  SalesOrderItemPartner._OrgNamePostalAddress.CityName AS CityName,
  SalesOrderItemPartner._OrgNamePostalAddress.POBox AS POBox,
  SalesOrderItemPartner._OrgNamePostalAddress.POBoxPostalCode AS POBoxPostalCode,
  SalesOrderItemPartner.CorrespondenceLanguage AS CorrespondenceLanguage,
  SalesOrderItemPartner._OrgNamePostalAddress.TaxJurisdiction AS TaxJurisdiction,
  SalesOrderItemPartner._OrgNamePostalAddress.TransportZone AS TransportZone,
  SalesOrderItemPartner.PartnerIsSpecificForSDDocItem AS PartnerIsSpecificForSDDocItem,
  SalesOrderItemPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  SalesOrderItemPartner.AddressID AS AddressID,
  SalesOrderItemPartner.AddressPersonID AS AddressPersonID,
  SalesOrderItemPartner.AddressObjectType AS AddressObjectType,
  SalesOrderItemPartner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  SalesOrderItemPartner.VATRegistration AS VATRegistration,
  SalesOrderItemPartner.UnloadingPointName AS UnloadingPointName,
  SalesOrderItemPartner.InternationalPhoneNumber AS InternationalPhoneNumber,
  SalesOrderItemPartner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  SalesOrderItemPartner.EmailAddress AS EmailAddress,
  SalesOrderItemPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  SalesOrderItemPartner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  SalesOrderItemPartner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  _SalesOrder.SalesOrderType AS SalesOrderType,
  _SalesOrder.SalesOrganization AS SalesOrganization,
  _SalesOrder.DistributionChannel AS DistributionChannel,
  _SalesOrder.OrganizationDivision AS OrganizationDivision,
  SalesOrderItemPartner._ContactPerson AS _ContactPerson,
  SalesOrderItemPartner._DfltAddrRprstn AS _DfltAddrRprstn,
  SalesOrderItemPartner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  SalesOrderItemPartner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr,
  SalesOrderItemPartner._OrgNamePostalAddress._Country AS _Country,
  SalesOrderItemPartner._OrgNamePostalAddress._Region AS _Region
FROM I_SalesDocItemCompletePartner AS SalesOrderItemPartner
INNER JOIN I_SalesDocumentBasic AS SalesOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_SalesOrderTP AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- 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