P_MPSESData

DDL: P_MPSESDATA SQL: PMPSESDATA Type: view COMPOSITE

P_MPSESData is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_PurchaseOrderHistory, I_ServEntDetails) and exposes 22 fields with key fields PurchaseOrder, PurchaseOrderItem, MaterialDocument, MaterialDocumentItem.

2 data source(s) 22 fields

Data Sources (2)

SourceAliasJoin Type
I_PurchaseOrderHistory PurchaseOrderHistory from
I_ServEntDetails ServEntDetails inner

Annotations (9)

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

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderHistory PurchaseOrder
KEY PurchaseOrderItem
KEY MaterialDocument I_PurchaseOrderHistory MaterialDocument
KEY MaterialDocumentItem I_PurchaseOrderHistory MaterialDocumentItem
Material I_PurchaseOrderHistory Material
GoodsMovementType I_PurchaseOrderHistory GoodsMovementType
DebitCreditCode I_PurchaseOrderHistory DebitCreditCode
MaterialDocumentYear I_PurchaseOrderHistory MaterialDocumentYear
PurchaseOrderHistCategory I_PurchaseOrderHistory PurchaseOrderHistCategory
PostingDate I_PurchaseOrderHistory PostingDate
Quantity I_PurchaseOrderHistory Quantity
DeliveryQuantityUnit
PurchaseOrderStatus
OrderStatusText I_ServEntDetails OrderStatusText
ReferenceDocumentFiscalYear I_PurchaseOrderHistory ReferenceDocumentFiscalYear
InvoiceAmtInCoCodeCrcy I_PurchaseOrderHistory InvoiceAmtInCoCodeCrcy
PurOrdAmountInCompanyCodeCrcy I_PurchaseOrderHistory PurOrdAmountInCompanyCodeCrcy
Currency I_PurchaseOrderHistory Currency
PurchaseOrderType
PurchasingOrganization
PurchasingGroup
Plant 
@AbapCatalog.sqlViewName: 'PMPSESDATA'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private: true
@ObjectModel.usageType.sizeCategory:#XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_MPSESData as select from I_PurchaseOrderHistory as PurchaseOrderHistory
inner join I_ServEntDetails as ServEntDetails on PurchaseOrderHistory.MaterialDocument  = ServEntDetails.ServiceEntrySheet
                                             and PurchaseOrderHistory.PurchaseOrder     = ServEntDetails.PurchaseOrder
                                             and PurchaseOrderHistory.PurchaseOrderItem =  ServEntDetails.PurchaseOrderItem
{

   key PurchaseOrderHistory.PurchaseOrder,


   key ltrim(PurchaseOrderHistory.PurchaseOrderItem,'0') as PurchaseOrderItem,


   key PurchaseOrderHistory.MaterialDocument,

   key PurchaseOrderHistory.MaterialDocumentItem,

   PurchaseOrderHistory.Material,

   PurchaseOrderHistory.GoodsMovementType,
   
   PurchaseOrderHistory.DebitCreditCode,

   PurchaseOrderHistory.MaterialDocumentYear,


   PurchaseOrderHistory.PurchaseOrderHistCategory,



   PurchaseOrderHistory.PostingDate,

 //  '' as Quantity,


   PurchaseOrderHistory.Quantity,

//   '' as DeliveryQuantityUnit,


   PurchaseOrderHistory._PurchaseOrderItem.PurchaseOrderQuantityUnit as DeliveryQuantityUnit,
 // ServEntDetails.QuantityUnit as DeliveryQuantityUnit,


   '' as PurchaseOrderStatus,

    ServEntDetails.OrderStatusText,

    PurchaseOrderHistory.ReferenceDocumentFiscalYear,


   PurchaseOrderHistory.InvoiceAmtInCoCodeCrcy,


   PurchaseOrderHistory.PurOrdAmountInCompanyCodeCrcy,


   PurchaseOrderHistory.Currency,


   PurchaseOrderHistory._PurchaseOrderItem._PurchaseOrder.PurchaseOrderType,


   PurchaseOrderHistory._PurchaseOrderItem._PurchaseOrder.PurchasingOrganization,


   PurchaseOrderHistory._PurchaseOrderItem._PurchaseOrder.PurchasingGroup,


   PurchaseOrderHistory._PurchaseOrderItem.Plant


}
where
PurchaseOrderHistory.PurchaseOrderHistCategory = 'D'
and
PurchaseOrderHistory.PurchaseOrderTransactionType = '9'



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

Learn More