P_PURREQEMAILTEMPLATEHDR
P_PURREQEMAILTEMPLATEHDR is a CDS View in S/4HANA. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PurRequisitionEmailTemplate | view | left_outer | COMPOSITE | Email Template for Purchase Requisition |
@AbapCatalog.sqlViewName: 'PURREQMAILTMPHDR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MIXED
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_purreqemailtemplatehdr as select from I_WorkflowTaskApplObject
{
key WorkflowTaskInternalID,
key cast(substring(SAPBusinessObjectNodeKey1, 1 , 10) as banfn) as Purchaserequisition,
//key cast(substring(SAPBusinessObjectNodeKey2, 1 , 5) as bnfpo) as PurchaseRequisitionItem,
key WorkflowTaskObject,
WorkflowObjectRole,
TopLevelWorkflowTask,
TechnicalWrkflwObjectCategory,
TechnicalWrkflwObjectType,
TechnicalWrkflwObject,
SAPBusinessObjectNodeKey3,
SAPBusinessObjectNodeKey4,
SAPBusinessObjectNodeKey5,
SAPBusinessObjectNodeKey6,
SAPObjectNodeRepresentation
}
where ( SAPObjectNodeRepresentation = 'PurchaseRequisition' )