P_RU_SupplierData1

DDL: P_RU_SUPPLIERDATA1 SQL: PRUSUPPLDATA1 Type: view COMPOSITE

P_RU_SupplierData1 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_Supplier) and exposes 11 fields with key field Supplier.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_Supplier Supplier from

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName PRUSUPPLDATA1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Supplier I_Supplier Supplier
SupplierName I_Supplier SupplierName
BusinessPartner
BusinessPartnerCategory
PersonNumber
IsNaturalPerson
AddressID I_Supplier AddressID
Country I_Supplier Country
IsOneTimeAccount I_Supplier IsOneTimeAccount
AuthorizationGroup I_Supplier AuthorizationGroup
_SupplierCompany I_Supplier _SupplierCompany 
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'PRUSUPPLDATA1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_RU_SupplierData1
  as select from I_Supplier                  as Supplier

{
  key Supplier.Supplier,
      Supplier.SupplierName,
      Supplier._SupplierToBusinessPartner[inner]._BusinessPartner[inner].BusinessPartner,
      Supplier._SupplierToBusinessPartner[inner]._BusinessPartner[inner].BusinessPartnerCategory,
      Supplier._SupplierToBusinessPartner[inner]._BusinessPartner[inner].PersonNumber,
      Supplier._SupplierToBusinessPartner[inner]._BusinessPartner[inner].IsNaturalPerson,

      Supplier.AddressID,
      Supplier.Country,
      Supplier.IsOneTimeAccount,
      Supplier.AuthorizationGroup,
      Supplier._SupplierCompany
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNER",
"I_SUPPLIER",
"I_SUPPLIERTOBUSINESSPARTNER"
],
"ASSOCIATED":
[
"I_SUPPLIERCOMPANY"
],
"BASE":
[
"I_SUPPLIER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More