P_RecrrgSuplrInvcCoCodeVH

DDL: P_RECRRGSUPLRINVCCOCODEVH SQL: PRSICOCODEVH Type: view BASIC

P_RecrrgSuplrInvcCoCodeVH is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (t001) and exposes 4 fields with key field CompanyCode.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
t001 t001 from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PRSICOCODEVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.private true view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey CompanyCode view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode t001 bukrs
CompanyCodeName t001 butxt
CityName t001 ort01
Currency t001 waers 
@AbapCatalog.sqlViewName: 'PRSICOCODEVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@VDM.viewType: #BASIC
@VDM.private:true
@Search.searchable: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'CompanyCode'
define view P_RecrrgSuplrInvcCoCodeVH as select from t001

left outer to one join  P_UserParameter
  on t001.mandt = P_UserParameter.mandt 
  and P_UserParameter.UserParameter = 'F_SHOW_OBSOLETE_T001'
 {
  @ObjectModel.text.element: ['CompanyCodeName']
  @Search.defaultSearchElement: true
  @Search.fuzzinessThreshold: 0.8
  @Search.ranking: #HIGH
  @UI.textArrangement: #TEXT_LAST
  key t001.bukrs as CompanyCode,
  @Semantics.text: true
  @Search: { defaultSearchElement: true, ranking: #LOW }
  t001.butxt as CompanyCodeName,
  @Search: { defaultSearchElement: true, ranking: #LOW }
  t001.ort01 as CityName,
  @Search: { defaultSearchElement: true, ranking: #LOW }
  t001.waers as Currency
} where P_UserParameter.UserParameterValue = 'X' or t001.f_obsolete <> 'X' 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_USERPARAMETER",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More