P_Bomitmspprc

DDL: P_BOMITMSPPRC SQL: PBomitmspprc Type: view BASIC

P_Bomitmspprc is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (t460a) and exposes 3 fields with key fields BOMItemSpecialProcurementType, Plant. It has 1 association to related views.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
t460a t460a from

Associations (1)

CardinalityTargetAliasCondition
[0..*] P_Bomitmspprctxt _Text $projection.BOMItemSpecialProcurementType = _Text.BOMItemSpecialProcurementType

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PBomitmspprc view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view
ObjectModel.representativeKey BOMItemSpecialProcurementType view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY BOMItemSpecialProcurementType sobsl
KEY Plant werks
_Text _Text 
@AbapCatalog.sqlViewName: 'PBomitmspprc'
@VDM.viewType: #BASIC
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Search.searchable: true
//@EndUserText.label: 'Value help for BOM Prc typ'

@ObjectModel.representativeKey:'BOMItemSpecialProcurementType'
define view P_Bomitmspprc as select from t460a 


association [0..*] to P_Bomitmspprctxt as _Text 
        on $projection.BOMItemSpecialProcurementType = _Text.BOMItemSpecialProcurementType
{

  @Search.defaultSearchElement: true
  @Search.ranking: #HIGH
  @Search.fuzzinessThreshold: 0.8 
key sobsl as BOMItemSpecialProcurementType,
 @Search.defaultSearchElement: true
  @Search.ranking: #HIGH
  @Search.fuzzinessThreshold: 0.8 
key werks as Plant,

_Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T460A"
],
"ASSOCIATED":
[
"P_BOMITMSPPRCTXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More