C_SupplierDfltReturnToAddr

DDL: C_SUPPLIERDFLTRETURNTOADDR SQL: CSUPPDFLTA Type: view CONSUMPTION

Supplier Default Return to Address

C_SupplierDfltReturnToAddr is a Consumption CDS View that provides data about "Supplier Default Return to Address" in SAP S/4HANA. It reads from 1 data source (I_CustSalesPartnerFunc) and exposes 23 fields with key fields Supplier, SalesOrganization, DistributionChannel, Division. It has 1 association to related views.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_CustSalesPartnerFunc PartnerFunction inner

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Customer _ShipToCustomer $projection.BPCustomerNumber = _ShipToCustomer.Customer

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName CSUPPDFLTA view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Supplier Default Return to Address view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier Supplier
KEY SalesOrganization I_CustSalesPartnerFunc SalesOrganization
KEY DistributionChannel I_CustSalesPartnerFunc DistributionChannel
KEY Division I_CustSalesPartnerFunc Division
Customer Supplier Customer
AddressID _ShipToCustomer AddressID
BPCustomerNumber I_CustSalesPartnerFunc BPCustomerNumber
CityName111asSupplierAddress
AuthorizationGroup Supplier AuthorizationGroup
SupplierAccountGroup Supplier SupplierAccountGroup
IsBusinessPurposeCompleted Supplier IsBusinessPurposeCompleted
DataControllerSet Supplier DataControllerSet
DataController1 Supplier DataController1
DataController2 Supplier DataController2
DataController3 Supplier DataController3
DataController4 Supplier DataController4
DataController5 Supplier DataController5
DataController6 Supplier DataController6
DataController7 Supplier DataController7
DataController8 Supplier DataController8
DataController9 Supplier DataController9
DataController10 Supplier DataController10
SupplyingPlant 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'CSUPPDFLTA'
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking:#BLOCKED_DATA_EXCLUDED
@VDM.viewType: #CONSUMPTION

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@EndUserText.label: 'Supplier Default Return to Address'

define view C_SupplierDfltReturnToAddr
  as select distinct from I_Supplier                  as Supplier
    inner join            I_CustSalesPartnerFunc      as PartnerFunction  on  Supplier.Customer               = PartnerFunction.Customer
                                                                         and  PartnerFunction.PartnerFunction = 'WE'
                                                                         and  (
                                                                               PartnerFunction.PartnerCounter = '000'
                                                                           or  PartnerFunction.DefaultPartner = 'X'
                                                                              )
  association [0..1] to I_Customer as _ShipToCustomer on $projection.BPCustomerNumber = _ShipToCustomer.Customer
{
  key Supplier.Supplier,
  key PartnerFunction.SalesOrganization,
  key PartnerFunction.DistributionChannel,
  key PartnerFunction.Division,

      Supplier.Customer,
      _ShipToCustomer.AddressID,
      PartnerFunction.BPCustomerNumber,

      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,      

      cast( '' as abap.char( 4 ))                                                           as SupplyingPlant
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS_2",
"I_CUSTOMER",
"I_CUSTSALESPARTNERFUNC",
"I_SUPPLIER"
],
"ASSOCIATED":
[
"I_CUSTOMER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More