C_POMntnDocumentTypeValueHelp

DDL: C_POMNTNDOCUMENTTYPEVALUEHELP SQL: CPOMAINTDOCTY_VH Type: view CONSUMPTION Package: ODATA_MM_PUR_PO_MAINTAIN_V2

Value Help for Order Types in "Manage Purchase Orders"

C_POMntnDocumentTypeValueHelp is a Consumption CDS View that provides data about "Value Help for Order Types in "Manage Purchase Orders"" in SAP S/4HANA. It reads from 1 data source (I_PurchasingDocumentType) and exposes 3 fields with key field PurchaseOrderType. It has 1 association to related views. Part of development package ODATA_MM_PUR_PO_MAINTAIN_V2.

1 data source(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocumentType I_PurchasingDocumentType from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PurchasingDocumentTypeText _PurchaseOrderTypeText _PurchaseOrderTypeText.PurchasingDocumentCategory = 'F' and _PurchaseOrderTypeText.PurchasingDocumentType = $projection.PurchaseOrderType and Language = $session.system_language

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPOMAINTDOCTY_VH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Value Help for Order Types in "Manage Purchase Orders" view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
Search.searchable true view
ObjectModel.representativeKey PurchaseOrderType view
ObjectModel.resultSet.sizeCategory #XS view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrderType
PurchasingDocumentTypeName _PurchaseOrderTypeText PurchasingDocumentTypeName
_PurchaseOrderTypeText _PurchaseOrderTypeText 
@AbapCatalog.sqlViewName: 'CPOMAINTDOCTY_VH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Value Help for Order Types in "Manage Purchase Orders"'
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm:#SESSION_VARIABLE
@ObjectModel.dataCategory:#VALUE_HELP
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.semanticKey: ['PurchaseOrderType']
@Search.searchable: true
@ObjectModel.representativeKey: 'PurchaseOrderType'
@ObjectModel.resultSet.sizeCategory: #XS

//----------------------------------------------------------------------------------------------

// This is the F4 help CDS view for document types in "Manage Purchase Orders" app:

//

//  -> the CDS view itself returns ALL PO document types from table T161 

//  -> the check if a PO document type is supported in "Manage Purchase Orders" is done in 

//     class "CL_MM_PUR_PO_MAINT_V2_DPC_EXT" in the re-defined methods 

//     "C_POMNTNDOCUMENT_GET_ENTITYSET" and "C_POMNTNDOCUMENT_GET_ENTITY"

//

//----------------------------------------------------------------------------------------------

define view C_POMntnDocumentTypeValueHelp 

  as select from I_PurchasingDocumentType
 
    association [0..1] to I_PurchasingDocumentTypeText as _PurchaseOrderTypeText on  _PurchaseOrderTypeText.PurchasingDocumentCategory = 'F'
                                                                                 and _PurchaseOrderTypeText.PurchasingDocumentType     = $projection.PurchaseOrderType
                                                                                 and Language = $session.system_language
                                                                                
 {
 
  @Search: { defaultSearchElement: true, ranking: #HIGH }
  @ObjectModel.text.association: '_PurchaseOrderTypeText'
  key cast (PurchasingDocumentType as mm_purchaseordertype preserving type ) as PurchaseOrderType,
  
      @Consumption.filter.hidden: true
      _PurchaseOrderTypeText.PurchasingDocumentTypeName,
      _PurchaseOrderTypeText
      
}
where
  PurchasingDocumentCategory = 'F'

Learn More