C_PurchaseOrderValueHelp

DDL: C_PURCHASEORDERVALUEHELP SQL: CPURORD_VH Type: view CONSUMPTION

Purchase Order Value Help

C_PurchaseOrderValueHelp is a Consumption CDS View that provides data about "Purchase Order Value Help" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrder) and exposes 14 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 2 associations to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrder PurchaseOrder from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_PurchaseOrderItem _PurchaseOrderItem PurchaseOrder.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder
[0..*] I_MaterialText _MaterialText $projection.Material = _MaterialText.Material

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPURORD_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.representativeKey PurchaseOrder view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Purchase Order Value Help view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrder PurchaseOrder
KEY PurchaseOrderItem _PurchaseOrderItem PurchaseOrderItem
Supplier I_PurchaseOrder Supplier
PurchasingGroup I_PurchaseOrder PurchasingGroup
CompanyCode I_PurchaseOrder CompanyCode
PurchasingDocumentDeletionCode I_PurchaseOrder PurchasingDocumentDeletionCode
ReleaseIsNotCompleted I_PurchaseOrder ReleaseIsNotCompleted
PurchasingCompletenessStatus I_PurchaseOrder PurchasingCompletenessStatus
ProductType _PurchaseOrderItem ProductType
Material _PurchaseOrderItem Material
ServicePerformer _PurchaseOrderItem ServicePerformer
IsCompletelyDelivered _PurchaseOrderItem IsCompletelyDelivered
IsFinallyInvoiced _PurchaseOrderItem IsFinallyInvoiced
_MaterialText _MaterialText 
@AbapCatalog.sqlViewName: 'CPURORD_VH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.semanticKey: ['PurchaseOrder', 'PurchaseOrderItem']
@ObjectModel.representativeKey: 'PurchaseOrder'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Purchase Order Value Help'
@ClientHandling.algorithm: #SESSION_VARIABLE

define view C_PurchaseOrderValueHelp
  as select from I_PurchaseOrder as PurchaseOrder

  association [0..*] to I_PurchaseOrderItem as _PurchaseOrderItem on PurchaseOrder.PurchaseOrder = _PurchaseOrderItem.PurchaseOrder

  association [0..*] to I_MaterialText      as _MaterialText      on $projection.Material = _MaterialText.Material

{

      @Search: { defaultSearchElement: true, ranking: #HIGH }
  key PurchaseOrder.PurchaseOrder                  as PurchaseOrder,

  key _PurchaseOrderItem.PurchaseOrderItem         as PurchaseOrderItem,

      @Search: { defaultSearchElement: true, ranking: #HIGH }
      PurchaseOrder.Supplier                       as Supplier,

      @Search: { defaultSearchElement: true, ranking: #MEDIUM }
      PurchaseOrder.PurchasingGroup                as PurchasingGroup,

      @Search: { defaultSearchElement: true, ranking: #LOW }
      PurchaseOrder.CompanyCode                    as CompanyCode,

      PurchaseOrder.PurchasingDocumentDeletionCode as PurchasingDocumentDeletionCode,

      PurchaseOrder.ReleaseIsNotCompleted          as ReleaseIsNotCompleted,

      PurchaseOrder.PurchasingCompletenessStatus   as PurchasingCompletenessStatus,

      @Search: { defaultSearchElement: true, ranking: #MEDIUM }
      _PurchaseOrderItem.ProductType               as ProductType,

      @ObjectModel.text.association: '_MaterialText'
      @Search: { defaultSearchElement: true, ranking: #MEDIUM }
      _PurchaseOrderItem.Material                  as Material,

      @Search: { defaultSearchElement: true, ranking: #MEDIUM }
      _PurchaseOrderItem.ServicePerformer          as ServicePerformer,

      _PurchaseOrderItem.IsCompletelyDelivered     as IsCompletelyDelivered,

      _PurchaseOrderItem.IsFinallyInvoiced         as IsFinallyInvoiced,

      _MaterialText

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PURCHASEORDER",
"I_PURCHASEORDERITEM"
],
"ASSOCIATED":
[
"I_MATERIALTEXT",
"I_PURCHASEORDERITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More