I_SalesOrderItemPartnerTP

DDL: I_SALESORDERITEMPARTNERTP Type: view_entity TRANSACTIONAL Package: RAP_SD_SLS_SO_API
16 Fields 1 Data Sources

Sales Order Item Partner - TP

I_SalesOrderItemPartnerTP is a Transactional CDS View that provides data about "Sales Order Item Partner - TP" in SAP S/4HANA. It reads from 1 data source (R_SalesOrderItemPartnerTP) and exposes 16 fields with key fields SalesOrder, SalesOrderItem, PartnerFunction. Part of development package RAP_SD_SLS_SO_API.

Data Sources (1)

SourceAliasJoin Type
R_SalesOrderItemPartnerTP R_SalesOrderItemPartnerTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Sales Order Item Partner - TP view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SalesOrder SalesOrderItemPartner SalesOrder SD Document
KEY SalesOrderItem SalesOrderItemPartner SalesOrderItem Sales Order Item
KEY PartnerFunction SalesOrderItemPartner PartnerFunction Partner Functn
PartnerFunctionForEdit SalesOrderItemPartner PartnerFunctionForEdit Partner Funct.
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
Partner SalesOrderItemPartner Partner With Partner
PartnerIsSpecificForSDDocItem SalesOrderItemPartner PartnerIsSpecificForSDDocItem
SalesOrderType SalesOrderItemPartner SalesOrderType Sales Order Type
SalesOrganization SalesOrderItemPartner SalesOrganization Sales Organization
DistributionChannel SalesOrderItemPartner DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision SalesOrderItemPartner OrganizationDivision Org. Division
_SalesOrderredirectedtoI_SalesOrderTP

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_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 I_SalesOrderItemPartnerTP AS
SELECT
  SalesOrderItemPartner.SalesOrder AS SalesOrder,
  SalesOrderItemPartner.SalesOrderItem AS SalesOrderItem,
  SalesOrderItemPartner.PartnerFunction AS PartnerFunction,
  SalesOrderItemPartner.PartnerFunctionForEdit AS PartnerFunctionForEdit,
  SalesOrderItemPartner.Customer AS Customer,
  SalesOrderItemPartner.Supplier AS Supplier,
  SalesOrderItemPartner.Personnel AS Personnel,
  SalesOrderItemPartner.ContactPerson AS ContactPerson,
  SalesOrderItemPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  SalesOrderItemPartner.Partner AS Partner,
  SalesOrderItemPartner.PartnerIsSpecificForSDDocItem AS PartnerIsSpecificForSDDocItem,
  SalesOrderItemPartner.SalesOrderType AS SalesOrderType,
  SalesOrderItemPartner.SalesOrganization AS SalesOrganization,
  SalesOrderItemPartner.DistributionChannel AS DistributionChannel,
  SalesOrderItemPartner.OrganizationDivision AS OrganizationDivision
FROM R_SalesOrderItemPartnerTP
;

Learn More