P_CustomerSupplierSH

DDL: P_CUSTOMERSUPPLIERSH Type: view_entity COMPOSITE Package: GLO_FIN_IS_RO_ACCOUNTCARD

Search Help View for Customers and Suppliers for Country

P_CustomerSupplierSH is a Composite CDS View that provides data about "Search Help View for Customers and Suppliers for Country" in SAP S/4HANA. It reads from 2 data sources (I_Customer, I_Supplier) and exposes 6 fields with key fields CustomerSupplier, FinancialAccountType, FinancialAccountType. Part of development package GLO_FIN_IS_RO_ACCOUNTCARD.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
I_Customer I_Customer from
I_Supplier I_Supplier union_all

Annotations (8)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CustomerSupplier
KEY FinancialAccountType
CustomerSupplierName
KEY FinancialAccountType
CustomerSupplierName
Country Country 
@VDM.private:true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
  usageType.sizeCategory: #L,
  usageType.serviceQuality: #D,
  usageType.dataClass: #MIXED
}
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true

define view entity P_CustomerSupplierSH

  as select from I_Customer

{
  key cast( Customer as bu_partner )                as CustomerSupplier,
  key cast( 'D' as koart )                          as FinancialAccountType,
      cast( CustomerName as business_partner_name ) as CustomerSupplierName,
      Country                                       as Country
}

union all

select from I_Supplier

{
  key cast( Supplier as bu_partner )                as CustomerSupplier,
  key cast( 'K' as koart )                          as FinancialAccountType,
      cast( SupplierName as business_partner_name ) as CustomerSupplierName,
      Country                                       as Country
}

Learn More