I_CustProjSlsOrdPartner

DDL: I_CUSTPROJSLSORDPARTNER SQL: ICUSTPROJSOHP Type: view COMPOSITE
24 Fields 2 Data Sources 3 Associations

Sales Order Partner for Customer Project

I_CustProjSlsOrdPartner (Composite)

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

Sales

I_CustProjSlsOrdPartner is a Composite CDS View that provides data about "Sales Order Partner for Customer Project" in SAP S/4HANA. It reads from 2 data sources (I_CustProjSlsOrd, I_SalesOrderPartner) and exposes 24 fields with key fields CustomerProject, PartnerFunction. It has 3 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? Who is the customer, supplier, personnel, or contact person of a given sales order? What is the address ID of a 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 Partner Business Partner AddressID Address ID The key fields are CustomerProject and PartnerFunction .

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_CustProjSlsOrd CustProjSlsOrd inner
I_SalesOrderPartner SalesOrderPartner from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_SalesOrder _SalesOrder $projection.SalesOrder = _SalesOrder.SalesOrder
[1..1] I_CustProjSlsOrd _CustProjSlsOrd $projection.CustomerProject = _CustProjSlsOrd.CustomerProject
[1..1] I_CustomerProject _CustomerProject $projection.CustomerProject = _CustomerProject.CustomerProject

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTPROJSOHP 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 Partner for Customer Project view

Fields (24)

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

CREATE VIEW I_CustProjSlsOrdPartner AS
SELECT
  CustProjSlsOrd.CustomerProject AS CustomerProject,
  SalesOrderPartner.PartnerFunction AS PartnerFunction,
  SalesOrderPartner.SalesOrder AS SalesOrder,
  SalesOrderPartner.Partner AS Partner,
  SalesOrderPartner.ContactPerson AS ContactPerson,
  SalesOrderPartner.AddressID AS AddressID,
  SalesOrderPartner.AddressPersonID AS AddressPersonID,
  SalesOrderPartner.AddressObjectType AS AddressObjectType,
  SalesOrderPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  SalesOrderPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  SalesOrderPartner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  SalesOrderPartner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  CustProjSlsOrd.SalesOrderType AS SalesOrderType,
  CustProjSlsOrd.OrganizationDivision AS OrganizationDivision,
  CustProjSlsOrd.SalesOrganization AS SalesOrganization,
  CustProjSlsOrd.DistributionChannel AS DistributionChannel,
  SalesOrderPartner._PartnerFunction AS _PartnerFunction,
  SalesOrderPartner._Address AS _Address,
  SalesOrderPartner._DfltAddrRprstn AS _DfltAddrRprstn,
  SalesOrderPartner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  SalesOrderPartner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr
FROM I_SalesOrderPartner AS SalesOrderPartner
INNER JOIN I_CustProjSlsOrd AS CustProjSlsOrd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [1..1]
LEFT OUTER JOIN I_CustProjSlsOrd AS _CustProjSlsOrd ON CustomerProject = _CustProjSlsOrd.CustomerProject  -- association [1..1]
LEFT OUTER JOIN I_CustomerProject AS _CustomerProject ON CustomerProject = _CustomerProject.CustomerProject  -- association [1..1]
;

Learn More