I_CustProjSlsOrdItemPartner

DDL: I_CUSTPROJSLSORDITEMPARTNER SQL: ICUSTPROJSOIP Type: view COMPOSITE
26 Fields 2 Data Sources 4 Associations

Sales Order Item Partner for Cust Proj

I_CustProjSlsOrdItemPartner (Composite)

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

Sales

I_CustProjSlsOrdItemPartner is a Composite CDS View that provides data about "Sales Order Item Partner for Cust Proj" in SAP S/4HANA. It reads from 2 data sources (I_CustProjSlsOrdItem, I_SalesOrderItemPartner) and exposes 26 fields with key fields CustomerProject, PartnerFunction, SalesOrderItem. It has 4 associations to related views.

SAP Help Documentation

CategoryCDS Views for Customer and Internal Project Management
Purpose
This CDS view provides the data to answer the following business questions: What are the partner functions specified in a given project for a professional service sales order item? Who is the customer, supplier, personnel, or contact person of a given sales order item? What is the address ID of a deviating item partner in a given project? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Structure
Important fields in this view include the following: Field Name Description CustomerProject Customer Project PartnerFunction Partner Function SalesOrderItem Sales Order Item Partner Business Partner AddressID Address ID The key fields are CustomerProject , PartnerFunction , and SalesOrderItem .

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSales
Application ComponentSD-SLS-PBS
CapabilitiesAssociation Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities
PackageSales for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
I_CustProjSlsOrdItem CustProjSlsOrdItemPartner inner
I_SalesOrderItemPartner SalesOrderItemPartner from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_CustProjSlsOrdItem _CustProjSlsOrdItem $projection.CustomerProject = _CustProjSlsOrdItem.CustomerProject and $projection.SalesOrderItem = _CustProjSlsOrdItem.SalesOrderItem
[1..1] I_SalesOrderItem _SalesOrderItem $projection.SalesOrder = _SalesOrderItem.SalesOrder and $projection.SalesOrderItem = _SalesOrderItem.SalesOrderItem
[1..1] I_CustomerProject _CustomerProject $projection.CustomerProject = _CustomerProject.CustomerProject
[1..1] I_SalesOrder _SalesOrder $projection.SalesOrder = _SalesOrder.SalesOrder

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTPROJSOIP view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey 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
EndUserText.label Sales Order Item Partner for Cust Proj view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CustomerProject I_CustProjSlsOrdItem CustomerProject Commercial Project ID
KEY PartnerFunction I_SalesOrderItemPartner PartnerFunction Partner Function
KEY SalesOrderItem I_SalesOrderItemPartner SalesOrderItem Sales Order Item
SalesOrder I_SalesOrderItemPartner SalesOrder SD Document
Partner I_SalesOrderItemPartner Partner Customer Number
ContactPerson I_SalesOrderItemPartner ContactPerson Number of Contact Person
AddressID I_SalesOrderItemPartner AddressID Ship-to address
AddressPersonID I_SalesOrderItemPartner AddressPersonID Person Number
AddressObjectType I_SalesOrderItemPartner AddressObjectType Address type (1=Organization, 2=Person, 3=Contact person)
SDDocPartnerAddressRefType I_SalesOrderItemPartner SDDocPartnerAddressRefType Address indicator
ReferenceBusinessPartner I_SalesOrderItemPartner ReferenceBusinessPartner Business Partner Number
BPAddrDeterminationTransaction I_SalesOrderItemPartner BPAddrDeterminationTransaction Address Determination in Document
BPRefAddressIDForDocSpcfcAddr I_SalesOrderItemPartner BPRefAddressIDForDocSpcfcAddr BP Reference Address Number
SalesOrderType I_CustProjSlsOrdItem SalesOrderType Sales Order Type
OrganizationDivision I_CustProjSlsOrdItem OrganizationDivision Org. Division
SalesOrganization I_CustProjSlsOrdItem SalesOrganization Sales Organization
DistributionChannel I_CustProjSlsOrdItem DistributionChannel Distribution Channel
_CustomerProject _CustomerProject
_CustProjSlsOrdItem _CustProjSlsOrdItem
_SalesOrderItem _SalesOrderItem
_SalesOrder _SalesOrder
_PartnerFunction I_SalesOrderItemPartner _PartnerFunction
_Address I_SalesOrderItemPartner _Address
_DfltAddrRprstn I_SalesOrderItemPartner _DfltAddrRprstn
_BusinessPartnerAddress I_SalesOrderItemPartner _BusinessPartnerAddress
_BPRefAddressForDocSpcfcAddr I_SalesOrderItemPartner _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_CustProjSlsOrdItemPartner.
-- 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.
-- SQL view name: ICUSTPROJSOIP

CREATE VIEW I_CustProjSlsOrdItemPartner AS
SELECT
  CustProjSlsOrdItemPartner.CustomerProject AS CustomerProject,
  SalesOrderItemPartner.PartnerFunction AS PartnerFunction,
  SalesOrderItemPartner.SalesOrderItem AS SalesOrderItem,
  SalesOrderItemPartner.SalesOrder AS SalesOrder,
  SalesOrderItemPartner.Partner AS Partner,
  SalesOrderItemPartner.ContactPerson AS ContactPerson,
  SalesOrderItemPartner.AddressID AS AddressID,
  SalesOrderItemPartner.AddressPersonID AS AddressPersonID,
  SalesOrderItemPartner.AddressObjectType AS AddressObjectType,
  SalesOrderItemPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  SalesOrderItemPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  SalesOrderItemPartner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  SalesOrderItemPartner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  CustProjSlsOrdItemPartner.SalesOrderType AS SalesOrderType,
  CustProjSlsOrdItemPartner.OrganizationDivision AS OrganizationDivision,
  CustProjSlsOrdItemPartner.SalesOrganization AS SalesOrganization,
  CustProjSlsOrdItemPartner.DistributionChannel AS DistributionChannel,
  SalesOrderItemPartner._PartnerFunction AS _PartnerFunction,
  SalesOrderItemPartner._Address AS _Address,
  SalesOrderItemPartner._DfltAddrRprstn AS _DfltAddrRprstn,
  SalesOrderItemPartner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  SalesOrderItemPartner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr
FROM I_SalesOrderItemPartner AS SalesOrderItemPartner
INNER JOIN I_CustProjSlsOrdItem AS CustProjSlsOrdItemPartner ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustProjSlsOrdItem AS _CustProjSlsOrdItem ON CustomerProject = _CustProjSlsOrdItem.CustomerProject AND SalesOrderItem = _CustProjSlsOrdItem.SalesOrderItem  -- association [1..1]
LEFT OUTER JOIN I_SalesOrderItem AS _SalesOrderItem ON SalesOrder = _SalesOrderItem.SalesOrder AND SalesOrderItem = _SalesOrderItem.SalesOrderItem  -- association [1..1]
LEFT OUTER JOIN I_CustomerProject AS _CustomerProject ON CustomerProject = _CustomerProject.CustomerProject  -- association [1..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [1..1]
;

Learn More