C_SupplierReturnToAddressVH

DDL: C_SUPPLIERRETURNTOADDRESSVH SQL: CSUPLRRETTOADRVH Type: view CONSUMPTION

Supplier Return-To Address

C_SupplierReturnToAddressVH is a Consumption CDS View that provides data about "Supplier Return-To Address" in SAP S/4HANA. It reads from 2 data sources (P_SuplrReturnToPartnerFunction, I_Supplier) and exposes 34 fields with key fields Supplier, SalesOrganization, DistributionChannel, Division, ReturnToAddressPartnerFunction.

2 data source(s) 34 fields

Data Sources (2)

SourceAliasJoin Type
P_SuplrReturnToPartnerFunction PartnerFunction inner
I_Supplier Supplier from

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName CSUPLRRETTOADRVH view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Supplier Return-To Address view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY Supplier I_Supplier Supplier
KEY SalesOrganization P_SuplrReturnToPartnerFunction SalesOrganization
KEY DistributionChannel P_SuplrReturnToPartnerFunction DistributionChannel
KEY Division P_SuplrReturnToPartnerFunction Division
KEY ReturnToAddressPartnerFunction P_SuplrReturnToPartnerFunction PartnerFunction
KEY PartnerCounter P_SuplrReturnToPartnerFunction PartnerCounter
BPCustomerNumber P_SuplrReturnToPartnerFunction BPCustomerNumber
DefaultPartner P_SuplrReturnToPartnerFunction DefaultPartner
AddressID ShipToCustomer AddressID
CustomerName ShipToCustomer CustomerName
StreetName
HouseNumber
CityName
PostalCode
Region
RegionName
Country
CountryName
CityName111asSupplierAddress
AuthorizationGroup I_Supplier AuthorizationGroup
SupplierAccountGroup I_Supplier SupplierAccountGroup
IsBusinessPurposeCompleted I_Supplier IsBusinessPurposeCompleted
DataControllerSet I_Supplier DataControllerSet
DataController1 I_Supplier DataController1
DataController2 I_Supplier DataController2
DataController3 I_Supplier DataController3
DataController4 I_Supplier DataController4
DataController5 I_Supplier DataController5
DataController6 I_Supplier DataController6
DataController7 I_Supplier DataController7
DataController8 I_Supplier DataController8
DataController9 I_Supplier DataController9
DataController10 I_Supplier DataController10
_AddressRepresentation ShipToCustomer _AddressRepresentation 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'CSUPLRRETTOADRVH'
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@AccessControl.personalData.blockingIndicator: ['IsBusinessPurposeCompleted']
@AccessControl.privilegedAssociations: ['_AddressRepresentation']
@VDM.viewType: #CONSUMPTION
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Supplier Return-To Address'

define view C_SupplierReturnToAddressVH
  as select from           I_Supplier                     as Supplier
    inner join             P_SuplrReturnToPartnerFunction as PartnerFunction on Supplier.Customer = PartnerFunction.Customer
    left outer to one join I_Customer                     as ShipToCustomer  on PartnerFunction.BPCustomerNumber = ShipToCustomer.Customer

{
      @UI.hidden: true
  key Supplier.Supplier,
      @UI.hidden: true
  key PartnerFunction.SalesOrganization,
      @UI.hidden: true
  key PartnerFunction.DistributionChannel,
      @UI.hidden: true
  key PartnerFunction.Division,
      @UI.hidden: true
  key PartnerFunction.PartnerFunction                                                      as ReturnToAddressPartnerFunction,
      //Supplier.Customer,

      @UI.hidden: true
  key PartnerFunction.PartnerCounter,
      @UI.hidden: true
      PartnerFunction.BPCustomerNumber,
      @UI.hidden: true
      PartnerFunction.DefaultPartner,

      ShipToCustomer.AddressID,
      ShipToCustomer.CustomerName,

      ShipToCustomer._AddressRepresentation.StreetName,
      ShipToCustomer._AddressRepresentation.HouseNumber,

      ShipToCustomer._AddressRepresentation.CityName,
      ShipToCustomer._AddressRepresentation.PostalCode,

      ShipToCustomer._AddressRepresentation.Region,
      ShipToCustomer._AddressRepresentation._Region._RegionText[1: Language=$session.system_language].RegionName,

      ShipToCustomer._AddressRepresentation.Country,
      ShipToCustomer._AddressRepresentation._Country._Text[1: Language=$session.system_language].CountryName,

      concat(ShipToCustomer.CustomerName,
        concat_with_space( ',', concat_with_space(ShipToCustomer._AddressRepresentation.StreetName,
          concat(ShipToCustomer._AddressRepresentation.HouseNumber,
            concat_with_space( ',', ShipToCustomer._AddressRepresentation.CityName, 1)), 1), 1)) as SupplierAddress,

      //For access control

      @Consumption.hidden: true
      @UI.hidden: true
      Supplier.AuthorizationGroup,
      @Consumption.hidden: true
      @UI.hidden: true
      Supplier.SupplierAccountGroup,
      @Consumption.hidden: true
      @UI.hidden: true
      Supplier.IsBusinessPurposeCompleted,
      @Consumption.hidden:true
      @UI.hidden:true
      Supplier.DataControllerSet,
      @Consumption.hidden:true
      @UI.hidden:true
      Supplier.DataController1,
      @Consumption.hidden:true
      @UI.hidden:true
      Supplier.DataController2,
      @Consumption.hidden:true
      @UI.hidden:true
      Supplier.DataController3,
      @Consumption.hidden:true
      @UI.hidden:true
      Supplier.DataController4,
      @Consumption.hidden:true
      @UI.hidden:true
      Supplier.DataController5,
      @Consumption.hidden:true
      @UI.hidden:true
      Supplier.DataController6,
      @Consumption.hidden:true
      @UI.hidden:true
      Supplier.DataController7,
      @Consumption.hidden:true
      @UI.hidden:true
      Supplier.DataController8,
      @Consumption.hidden:true
      @UI.hidden:true
      Supplier.DataController9,
      @Consumption.hidden:true
      @UI.hidden:true
      Supplier.DataController10,

      //Association

      ShipToCustomer._AddressRepresentation
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS_2",
"I_COUNTRY",
"I_COUNTRYTEXT",
"I_CUSTOMER",
"I_REGION",
"I_REGIONTEXT",
"I_SUPPLIER",
"P_SUPLRRETURNTOPARTNERFUNCTION"
],
"ASSOCIATED":
[
"I_ADDRESS_2"
],
"BASE":
[
"I_CUSTOMER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More