I_SalesOrderItemPartner

DDL: I_SALESORDERITEMPARTNER Type: view COMPOSITE Package: VDM_SD_SLS_SO
27 Fields 1 Data Sources 1 OData Services

Sales Order Item Partner

I_SalesOrderItemPartner (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Sales

I_SalesOrderItemPartner is a Composite CDS View that provides data about "Sales Order Item Partner" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentItemPartner) and exposes 27 fields with key fields SalesOrder, SalesOrderItem, PartnerFunction. It is exposed through 1 OData service (ASQL_F4293). Part of development package VDM_SD_SLS_SO.

SAP API Hub

CategoryComposite
StateC1
Line of BusinessSales
Application ComponentSD-SLS-SO-2CL
CapabilitiesData Source in SQL Select,Data Source for Defining CDS Entities,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageSales for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering questions about sales order partners at item level.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentItemPartner Partner from

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Order Item Partner view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.sqlViewName ISDSLSORDITMPT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.representativeKey PartnerFunction view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F4293 ASQL_F4293 C2 NOT_RELEASED

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder Sales Order
KEY SalesOrderItem Sales Order Item
KEY PartnerFunction I_SalesDocumentItemPartner PartnerFunction Partner Function
Customer I_SalesDocumentItemPartner Customer Customer Number
Supplier I_SalesDocumentItemPartner Supplier Account Number of Supplier
Personnel I_SalesDocumentItemPartner Personnel Personnel Number
ContactPerson I_SalesDocumentItemPartner ContactPerson Number of Contact Person
Partner I_SalesDocumentItemPartner Partner Customer Number
FullName I_SalesDocumentItemPartner FullName Full Name of Person
ReferenceBusinessPartner I_SalesDocumentItemPartner ReferenceBusinessPartner Reference Business Partner
AddressID I_SalesDocumentItemPartner AddressID Ship-to address
AddressPersonID I_SalesDocumentItemPartner AddressPersonID Person Number
AddressObjectType I_SalesDocumentItemPartner AddressObjectType Address type (1=Organization, 2=Person, 3=Contact person)
SDDocPartnerAddressRefType I_SalesDocumentItemPartner SDDocPartnerAddressRefType Address indicator
BPAddrDeterminationTransaction I_SalesDocumentItemPartner BPAddrDeterminationTransaction Address Determination in Document
BPRefAddressIDForDocSpcfcAddr I_SalesDocumentItemPartner BPRefAddressIDForDocSpcfcAddr BP Reference Address Number
InternationalPhoneNumber I_SalesDocumentItemPartner InternationalPhoneNumber Landline Phone
InternationalMobilePhoneNumber I_SalesDocumentItemPartner InternationalMobilePhoneNumber Cell Phone
EmailAddress I_SalesDocumentItemPartner EmailAddress E-Mail Address
_SalesOrder _SalesOrder
_SalesOrderItem _SalesOrderItem
_PartnerFunction I_SalesDocumentItemPartner _PartnerFunction
_WorkforcePersonMappings I_SalesDocumentItemPartner _WorkforcePersonMappings
_Address I_SalesDocumentItemPartner _Address
_DfltAddrRprstn I_SalesDocumentItemPartner _DfltAddrRprstn
_BusinessPartnerAddress I_SalesDocumentItemPartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_SalesDocumentItemPartner _BPRefAddressForDocSpcfcAddr

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 I_SalesOrderItemPartner.
-- 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 I_SalesOrderItemPartner AS
SELECT
  cast(Partner.SalesDocument as vdm_sales_order preserving type) AS SalesOrder,
  cast(Partner.SalesDocumentItem as sales_order_item preserving type) AS SalesOrderItem,
  Partner.PartnerFunction AS PartnerFunction,
  Partner.Customer AS Customer,
  Partner.Supplier AS Supplier,
  Partner.Personnel AS Personnel,
  Partner.ContactPerson AS ContactPerson,
  Partner.Partner AS Partner,
  Partner.FullName AS FullName,
  Partner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  Partner.AddressID AS AddressID,
  Partner.AddressPersonID AS AddressPersonID,
  Partner.AddressObjectType AS AddressObjectType,
  Partner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  Partner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  Partner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  Partner.InternationalPhoneNumber AS InternationalPhoneNumber,
  Partner.InternationalMobilePhoneNumber AS InternationalMobilePhoneNumber,
  Partner.EmailAddress AS EmailAddress,
  Partner._PartnerFunction AS _PartnerFunction,
  Partner._WorkforcePersonMappings AS _WorkforcePersonMappings,
  Partner._Address AS _Address,
  Partner._DfltAddrRprstn AS _DfltAddrRprstn,
  Partner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  Partner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr
FROM I_SalesDocumentItemPartner AS Partner
;

Learn More