P_RecrrgSuplrInvcInvcgPtyVH

DDL: P_RECRRGSUPLRINVCINVCGPTYVH SQL: PRSIINVCGPTYVH Type: view BASIC

P_RecrrgSuplrInvcInvcgPtyVH is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_SupplierCompany) and exposes 7 fields with key fields Supplier, CompanyCode. It has 2 associations to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_SupplierCompany _SupplierCompany from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Supplier _Supplier $projection.Supplier = _Supplier.Supplier
[1..1] P_RecrrgSuplrInvcCoCodeVH _RecrrgSuplrInvcCoCodeVH _SupplierCompany.CompanyCode = _RecrrgSuplrInvcCoCodeVH.CompanyCode

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName PRSIINVCGPTYVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey Supplier view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
Search.searchable true view
VDM.viewType #BASIC view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier
KEY CompanyCode _RecrrgSuplrInvcCoCodeVH CompanyCode
Country _Supplier Country
CityName _Supplier CityName
SortField _Supplier SortField
SupplierName _Supplier SupplierName
_Supplier _Supplier 
@AbapCatalog.sqlViewName: 'PRSIINVCGPTYVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel:
{
  representativeKey: 'Supplier',
  usageType:
              {
                serviceQuality: #B,
                sizeCategory: #S,
                dataClass: #META
              }
}
@Search.searchable: true
@VDM.viewType: #BASIC
@VDM.private:true
define view P_RecrrgSuplrInvcInvcgPtyVH as select from I_SupplierCompany as _SupplierCompany
  association [1..1] to I_Supplier                    as _Supplier                 on $projection.Supplier = _Supplier.Supplier
  association [1..1] to P_RecrrgSuplrInvcCoCodeVH     as _RecrrgSuplrInvcCoCodeVH  on _SupplierCompany.CompanyCode = _RecrrgSuplrInvcCoCodeVH.CompanyCode
{
    @ObjectModel.text.element: 'SupplierName'
    @Search:{
            defaultSearchElement: true, 
            ranking: #HIGH, 
            fuzzinessThreshold: 0.8
            }
    key Supplier,
    
    @Search: { defaultSearchElement: true, ranking: #HIGH }
    //key CompanyCode,    

    key _RecrrgSuplrInvcCoCodeVH.CompanyCode as CompanyCode,
    
    @Search: { defaultSearchElement: true, ranking: #LOW }
    _Supplier.Country,
    
    @Search: { defaultSearchElement: true, ranking: #LOW }
    _Supplier.CityName,
    
    @Search: { defaultSearchElement: true, ranking: #LOW }
    _Supplier.SortField,
    
    @Semantics.text
    _Supplier.SupplierName   as SupplierName,
    
    @Consumption.filter.hidden: true
    _Supplier
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPPLIER",
"I_SUPPLIERCOMPANY",
"P_RECRRGSUPLRINVCCOCODEVH"
],
"ASSOCIATED":
[
"I_SUPPLIER",
"P_RECRRGSUPLRINVCCOCODEVH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More