P_purreqemailtemplateitm

DDL: P_PURREQEMAILTEMPLATEITM SQL: PURREQMAILTMP Type: view COMPOSITE

P_purreqemailtemplateitm is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_WorkflowTaskApplObject) and exposes 14 fields with key fields WorkflowTaskInternalID, Purchaserequisition, PurchaseRequisitionItem, WorkflowTaskObject.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTaskApplObject I_WorkflowTaskApplObject from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PURREQMAILTMP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID WorkflowTaskInternalID
KEY Purchaserequisition
KEY PurchaseRequisitionItem
KEY WorkflowTaskObject WorkflowTaskObject
WorkflowObjectRole WorkflowObjectRole
TopLevelWorkflowTask TopLevelWorkflowTask
TechnicalWrkflwObjectCategory TechnicalWrkflwObjectCategory
TechnicalWrkflwObjectType TechnicalWrkflwObjectType
TechnicalWrkflwObject TechnicalWrkflwObject
SAPBusinessObjectNodeKey3 SAPBusinessObjectNodeKey3
SAPBusinessObjectNodeKey4 SAPBusinessObjectNodeKey4
SAPBusinessObjectNodeKey5 SAPBusinessObjectNodeKey5
SAPBusinessObjectNodeKey6 SAPBusinessObjectNodeKey6
SAPObjectNodeRepresentation SAPObjectNodeRepresentation 
@AbapCatalog.sqlViewName: 'PURREQMAILTMP'
@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
//@EndUserText.label: 'Private view for email template purchase requsition item'

define view P_purreqemailtemplateitm 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 = 'PurchaseRequisitionItem'  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKFLOWTASKAPPLOBJECT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More