P_SuplrReturnToPartnerFunction

DDL: P_SUPLRRETURNTOPARTNERFUNCTION SQL: SPLRRETTPADRPF Type: view COMPOSITE

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.

3 data source(s) 15 fields

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
KEY SalesOrganization I_CustSalesPartnerFunc_2 SalesOrganization
KEY DistributionChannel I_CustSalesPartnerFunc_2 DistributionChannel
KEY Division I_CustSalesPartnerFunc_2 Division
KEY PartnerCounter I_CustSalesPartnerFunc_2 PartnerCounter
KEY PartnerFunction I_CustSalesPartnerFunc_2 PartnerFunction
BPCustomerNumber I_CustSalesPartnerFunc_2 BPCustomerNumber
Customer
KEY SalesOrganization I_CustSalesPartnerFunc SalesOrganization
KEY DistributionChannel I_CustSalesPartnerFunc DistributionChannel
KEY Division I_CustSalesPartnerFunc Division
KEY PartnerCounter I_CustSalesPartnerFunc PartnerCounter
KEY PartnerFunction I_CustSalesPartnerFunc PartnerFunction
BPCustomerNumber I_CustSalesPartnerFunc BPCustomerNumber
DefaultPartner I_CustSalesPartnerFunc DefaultPartner 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'SPLRRETTPADRPF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_SuplrReturnToPartnerFunction
  as select from I_CustSalesPartnerFunc_2     as CustRetToPartnerFunction
    inner join   I_AdvncdRetsMgmtSttgAtClient as AdvncdRetsMgmtSttgAtClient on CustRetToPartnerFunction.PartnerFunction = AdvncdRetsMgmtSttgAtClient.ReturnToAddressPartnerFunction
{
  key CustRetToPartnerFunction.Customer,
  key CustRetToPartnerFunction.SalesOrganization,
  key CustRetToPartnerFunction.DistributionChannel,
  key CustRetToPartnerFunction.Division,

  key CustRetToPartnerFunction.PartnerCounter,
  key CustRetToPartnerFunction.PartnerFunction,
      CustRetToPartnerFunction.BPCustomerNumber,
      CustRetToPartnerFunction.DefaultPartner
}

//Need to use union to emilate duplicate records if the setting is WE too

union

select from I_CustSalesPartnerFunc as CustShipToPartnerFunction

{
  key CustShipToPartnerFunction.Customer,
  key CustShipToPartnerFunction.SalesOrganization,
  key CustShipToPartnerFunction.DistributionChannel,
  key CustShipToPartnerFunction.Division,

  key CustShipToPartnerFunction.PartnerCounter,
  key CustShipToPartnerFunction.PartnerFunction,
      CustShipToPartnerFunction.BPCustomerNumber,
      CustShipToPartnerFunction.DefaultPartner
}
where
  CustShipToPartnerFunction.PartnerFunction = 'WE'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADVNCDRETSMGMTSTTGATCLIENT",
"I_CUSTSALESPARTNERFUNC",
"I_CUSTSALESPARTNERFUNC_2"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More