P_SuplrReturnToPartnerFunction

DDL: P_SUPLRRETURNTOPARTNERFUNCTION SQL: SPLRRETTPADRPF Type: view COMPOSITE
15 Fields 3 Data Sources

P_SuplrReturnToPartnerFunction is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_AdvncdRetsMgmtSttgAtClient, I_CustSalesPartnerFunc_2, I_CustSalesPartnerFunc) and exposes 15 fields with key fields Customer, SalesOrganization, DistributionChannel, Division, PartnerCounter.

Data Sources (3)

SourceAliasJoin Type
I_AdvncdRetsMgmtSttgAtClient AdvncdRetsMgmtSttgAtClient inner
I_CustSalesPartnerFunc_2 CustRetToPartnerFunction from
I_CustSalesPartnerFunc CustShipToPartnerFunction union

Annotations (7)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName SPLRRETTPADRPF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Customer I_CustSalesPartnerFunc_2 Customer Sold-to Party
KEY SalesOrganization I_CustSalesPartnerFunc_2 SalesOrganization Sales Organization
KEY DistributionChannel I_CustSalesPartnerFunc_2 DistributionChannel RefDistCh-Cust/Mat.
KEY Division I_CustSalesPartnerFunc_2 Division Internal Division ID
KEY PartnerCounter I_CustSalesPartnerFunc_2 PartnerCounter Partner counter
KEY PartnerFunction I_CustSalesPartnerFunc_2 PartnerFunction Partner Functn
BPCustomerNumber I_CustSalesPartnerFunc_2 BPCustomerNumber Customer
Customer Sold-to Party
KEY SalesOrganization I_CustSalesPartnerFunc SalesOrganization Sales Organization
KEY DistributionChannel I_CustSalesPartnerFunc DistributionChannel RefDistCh-Cust/Mat.
KEY Division I_CustSalesPartnerFunc Division Internal Division ID
KEY PartnerCounter I_CustSalesPartnerFunc PartnerCounter Partner counter
KEY PartnerFunction I_CustSalesPartnerFunc PartnerFunction Partner Functn
BPCustomerNumber I_CustSalesPartnerFunc BPCustomerNumber Customer
DefaultPartner I_CustSalesPartnerFunc DefaultPartner Default Partner

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 P_SuplrReturnToPartnerFunction.
-- 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: SPLRRETTPADRPF

CREATE VIEW P_SuplrReturnToPartnerFunction AS
SELECT
  CustRetToPartnerFunction.Customer AS Customer,
  CustRetToPartnerFunction.SalesOrganization AS SalesOrganization,
  CustRetToPartnerFunction.DistributionChannel AS DistributionChannel,
  CustRetToPartnerFunction.Division AS Division,
  CustRetToPartnerFunction.PartnerCounter AS PartnerCounter,
  CustRetToPartnerFunction.PartnerFunction AS PartnerFunction,
  CustRetToPartnerFunction.BPCustomerNumber AS BPCustomerNumber,
  CustShipToPartnerFunction.DefaultPartner AS DefaultPartner
FROM I_CustSalesPartnerFunc_2 AS CustRetToPartnerFunction
INNER JOIN I_AdvncdRetsMgmtSttgAtClient AS AdvncdRetsMgmtSttgAtClient ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): I_CustSalesPartnerFunc
;

Learn More