P_DRFEWMSupplier

DDL: P_DRFEWMSUPPLIER SQL: PDRFEWMSUPLROUT Type: view BASIC Package: VDM_MD_EWM

DRF EWM integration of supplier

P_DRFEWMSupplier is a Basic CDS View that provides data about "DRF EWM integration of supplier" in SAP S/4HANA. It reads from 1 data source (I_Supplier) and exposes 6 fields with key field LIFNR. Part of development package VDM_MD_EWM.

Data Sources (1)

SourceAliasJoin Type
I_Supplier I_Supplier from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PDRFEWMSUPLROUT 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 (6)

KeyFieldSource TableSource FieldDescription
KEY LIFNR Supplier
SupplierAccountGroup SupplierAccountGroup
SupplierPurchasingOrg _SupplierPurchasingOrg PurchasingOrganization
SupplierCompanyCode _SupplierCompany CompanyCode
SupplierPurchasingGroup _SupplierPurchasingOrg PurchasingGroup
SupplierPartnerFunction _SupplierPartnerFunc PartnerFunction
@AbapCatalog.sqlViewName: 'PDRFEWMSUPLROUT'
@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 supplier'


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

define view P_DRFEWMSupplier
  as select from I_Supplier
  
  association to I_SupplierPartnerFunc as _SupplierPartnerFunc on $projection.LIFNR = _SupplierPartnerFunc.Supplier
{
  key Supplier as LIFNR,
      SupplierAccountGroup,
      _SupplierPurchasingOrg.PurchasingOrganization as SupplierPurchasingOrg,
      _SupplierCompany.CompanyCode as SupplierCompanyCode,
      _SupplierPurchasingOrg.PurchasingGroup as SupplierPurchasingGroup,
      _SupplierPartnerFunc.PartnerFunction as SupplierPartnerFunction
}