P_EngmntProjSalesOrder

DDL: P_ENGMNTPROJSALESORDER SQL: PEPSALESORD Type: view COMPOSITE

P_EngmntProjSalesOrder is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_EngagementProject, I_EngagementProjectItem, I_SalesDocumentItem) and exposes 19 fields with key fields EngagementProject, WBSElement, SalesDocument, SalesDocumentItem, BillingPlan.

3 data source(s) 19 fields

Data Sources (3)

SourceAliasJoin Type
I_EngagementProject ProjectData from
I_EngagementProjectItem ProjItem inner
I_SalesDocumentItem SalesOrderItem inner

Annotations (10)

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

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY EngagementProject I_EngagementProject EngagementProject
KEY WBSElement I_SalesDocumentItem WBSElementInternalID
KEY SalesDocument I_SalesDocumentItem SalesDocument
KEY SalesDocumentItem I_SalesDocumentItem SalesDocumentItem
KEY BillingPlan I_SalesDocumentItem BillingPlan
ProjectStartDate I_EngagementProject ProjectStartDate
ProjectEndDate I_EngagementProject ProjectEndDate
LastChangedByUser I_EngagementProject LastChangedByUser
ProjectCurrency _EngagementProjFinancialPlan Currency
Customer
CustomerName
EngagementProjectServiceOrg I_EngagementProject EngagementProjectServiceOrg
ControllingArea I_EngagementProject ControllingArea
CompanyCode I_EngagementProject CompanyCode
ProfitCenter I_EngagementProject ProfitCenter
CostCenter I_EngagementProject CostCenter
Material I_SalesDocumentItem Product
SalesDocumentItemCategory I_SalesDocumentItem SalesDocumentItemCategory
BillAmtInProjCrcy I_SalesDocumentItem NetAmount 
@AbapCatalog.sqlViewName: 'PEPSALESORD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Engagement Project Sales Order Details'

@ObjectModel.usageType: {
  serviceQuality: #P,
  sizeCategory: #XL,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_EngmntProjSalesOrder as select from   I_EngagementProject  as ProjectData
inner join I_EngagementProjectItem as ProjItem on ProjectData.EngagementProject = ProjItem.EngagementProject
                                               and ProjItem.EngagementProjectItemType = '0SOH'
inner join       I_SalesDocumentItem as SalesOrderItem on ProjItem.EngagementProjectItem     = SalesOrderItem.SalesDocument
{
key ProjectData.EngagementProject,
key SalesOrderItem.WBSElementInternalID as WBSElement,
key SalesOrderItem.SalesDocument as SalesDocument,
key SalesOrderItem.SalesDocumentItem as SalesDocumentItem,
key SalesOrderItem.BillingPlan as BillingPlan,
ProjectData.ProjectStartDate,
ProjectData.ProjectEndDate,
ProjectData.LastChangedByUser,

_EngagementProjFinancialPlan.Currency as ProjectCurrency,
ProjectData._Customer.Customer,
ProjectData._Customer.CustomerName,
ProjectData.EngagementProjectServiceOrg,
ProjectData.ControllingArea,
ProjectData.CompanyCode,
ProjectData.ProfitCenter,
ProjectData.CostCenter,
SalesOrderItem.Product as Material,
SalesOrderItem.SalesDocumentItemCategory,

SalesOrderItem.NetAmount as BillAmtInProjCrcy

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CUSTOMER",
"I_ENGAGEMENTPROJECT",
"I_ENGAGEMENTPROJECTITEM",
"I_ENGAGEMENTPROJFINANCIALPLAN",
"I_SALESDOCUMENTITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More