C_SDDocumentCustomerVH

DDL: C_SDDOCUMENTCUSTOMERVH SQL: CSDDOCCUSTVH Type: view CONSUMPTION Package: ODATA_SD_RETURN_V2

SD Document Ship to Party

C_SDDocumentCustomerVH is a Consumption CDS View that provides data about "SD Document Ship to Party" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 23 fields with key fields Customer, AddressID. Part of development package ODATA_SD_RETURN_V2.

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_Customer _Customer inner

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CSDDOCCUSTVH view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label SD Document Ship to Party view
Search.searchable true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.dataCategory #VALUE_HELP view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY Customer Partner Customer
KEY AddressID Partner AddressID
CustomerName
StreetName
PostalCode
CityName
Country
HouseNumber
HouseNumberSupplementText
AuthorizationGroup I_Customer AuthorizationGroup
CustomerAccountGroup I_Customer CustomerAccountGroup
IsBusinessPurposeCompleted I_Customer IsBusinessPurposeCompleted
DataControllerSet I_Customer DataControllerSet
DataController1 I_Customer DataController1
DataController2 I_Customer DataController2
DataController3 I_Customer DataController3
DataController4 I_Customer DataController4
DataController5 I_Customer DataController5
DataController6 I_Customer DataController6
DataController7 I_Customer DataController7
DataController8 I_Customer DataController8
DataController9 I_Customer DataController9
DataController10 I_Customer DataController10 
@AbapCatalog.sqlViewName: 'CSDDOCCUSTVH'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'SD Document Ship to Party'
@Search.searchable: true
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.dataCategory:#VALUE_HELP
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define view C_SDDocumentCustomerVH
  as select distinct from I_SDDocumentPartner as Partner
    inner join            I_Customer          as _Customer on Partner.Customer = _Customer.Customer
{
      @Search:{
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #HIGH
      }
  key Partner.Customer,
      @Search:{
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #HIGH
      }
  key Partner.AddressID,

      @Semantics.text
      Partner._DfltAddrRprstn.AddresseeFullName as CustomerName,

      @Search:{
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #HIGH
      }
      Partner._DfltAddrRprstn.StreetName,
      
      @Search:{
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #HIGH
      }
      Partner._DfltAddrRprstn.PostalCode,
      
      @Search:{
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #HIGH
      }
      Partner._DfltAddrRprstn.CityName,
      
      @Search:{
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #HIGH
      }
      Partner._DfltAddrRprstn.Country,
      
      @Search:{
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #HIGH
      }
      Partner._DfltAddrRprstn.HouseNumber,
      
      @Search:{
        defaultSearchElement: true,
        fuzzinessThreshold: 0.8,
        ranking: #HIGH
      }
      Partner._DfltAddrRprstn.HouseNumberSupplementText,

      //For access control

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

Learn More