P_SUPLRRETURNTOPARTNERFUNCTION

CDS View

P_SUPLRRETURNTOPARTNERFUNCTION is a CDS View in S/4HANA. It contains 7 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 7 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_SupplierReturnToAddressVH view inner CONSUMPTION Supplier Return-To Address

Fields (7)

KeyField CDS FieldsUsed in Views
KEY DistributionChannel DistributionChannel 1
KEY Division Division 1
KEY PartnerCounter PartnerCounter 1
KEY PartnerFunction ReturnToAddressPartnerFunction 1
KEY SalesOrganization SalesOrganization 1
BPCustomerNumber BPCustomerNumber 1
DefaultPartner DefaultPartner 1 
@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