C_PurchaseOrderTypeValueHelp

DDL: C_PURCHASEORDERTYPEVALUEHELP SQL: CPURORDTYPEVH Type: view CONSUMPTION Package: ODATA_MM_PUR_PR_PROCESS

Purchase Order Type

C_PurchaseOrderTypeValueHelp is a Consumption CDS View that provides data about "Purchase Order Type" in SAP S/4HANA. It reads from 1 data source (I_PurchasingDocumentType) and exposes 2 fields with key field PurchaseOrderType. It has 1 association to related views. Part of development package ODATA_MM_PUR_PR_PROCESS.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocumentType I_PurchasingDocumentType from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_PurchasingDocumentTypeText _PurchasingDocumentTypeText _PurchasingDocumentTypeText.PurchasingDocumentCategory = 'F' and _PurchasingDocumentTypeText.PurchasingDocumentType = $projection.PurchaseOrderType

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPURORDTYPEVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label Purchase Order Type view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrderType
_PurchasingDocumentTypeText _PurchasingDocumentTypeText 
@AbapCatalog.sqlViewName: 'CPURORDTYPEVH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@EndUserText.label: 'Purchase Order Type'
@ObjectModel.resultSet.sizeCategory: #XS 

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #CUSTOMIZING
define view C_PurchaseOrderTypeValueHelp as select from I_PurchasingDocumentType
 association [0..*] to I_PurchasingDocumentTypeText as _PurchasingDocumentTypeText on  _PurchasingDocumentTypeText.PurchasingDocumentCategory = 'F'
                                                   and _PurchasingDocumentTypeText.PurchasingDocumentType     = $projection.PurchaseOrderType
 {
 
  @Search: { defaultSearchElement: true, ranking: #HIGH }
      @ObjectModel.text.association: '_PurchasingDocumentTypeText'
   
 key cast (PurchasingDocumentType as mm_purchaseordertype preserving type ) as PurchaseOrderType,

      _PurchasingDocumentTypeText
}
where
  PurchasingDocumentCategory = 'F'

Learn More