P_DRFEWMCustomer

DDL: P_DRFEWMCUSTOMER SQL: PDRFEWMCUSTOUT Type: view BASIC Package: VDM_MD_EWM

DRF EWM integration of customer

P_DRFEWMCustomer is a Basic CDS View that provides data about "DRF EWM integration of customer" in SAP S/4HANA. It reads from 1 data source (I_Customer) and exposes 5 fields with key field KUNNR. Part of development package VDM_MD_EWM.

Data Sources (1)

SourceAliasJoin Type
I_Customer I_Customer from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PDRFEWMCUSTOUT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #BASIC view
VDM.private true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY KUNNR Customer
CustomerAccountGroup CustomerAccountGroup
CustomerSalesOrg _CustomerSalesArea SalesOrganization
CustomerCompanyCode _CustomerCompany CompanyCode
CustomerPartnerFunction _CustomerPartnerFunc PartnerFunction
@AbapCatalog.sqlViewName: 'PDRFEWMCUSTOUT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass:#MASTER

//@EndUserText.label: 'DRF EWM integration of customer'


@VDM.viewType: #BASIC
@VDM.private: true


define view P_DRFEWMCustomer
  as select from I_Customer

 association to I_CustSalesPartnerFunc as _CustomerPartnerFunc on $projection.KUNNR = _CustomerPartnerFunc.Customer
{

  key Customer as KUNNR,
  CustomerAccountGroup,
  _CustomerSalesArea.SalesOrganization as CustomerSalesOrg,
  _CustomerCompany.CompanyCode as CustomerCompanyCode,
  _CustomerPartnerFunc.PartnerFunction as CustomerPartnerFunction
}