P_MaintOrdNonStkCompFromPurOrd

DDL: P_MAINTORDNONSTKCOMPFROMPURORD SQL: PMORDNSTOCKPO Type: view CONSUMPTION

P_MaintOrdNonStkCompFromPurOrd is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_MaintenanceOrder, I_PurgDocAccountAssignment) and exposes 13 fields with key fields PurchaseOrder, PurchaseOrderItem. It has 5 associations to related views.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_MaintenanceOrder I_MaintenanceOrder inner
I_PurgDocAccountAssignment I_PurgDocAccountAssignment from

Associations (5)

CardinalityTargetAliasCondition
[0..1] P_MaintPlngBcktOrder _PlanningBucketOrder _PlanningBucketOrder.MaintenanceOrder = $projection.MaintenanceOrder
[1..1] I_MaintenanceOrder _MaintenanceOrder _MaintenanceOrder.MaintenanceOrder = I_PurgDocAccountAssignment.OrderID
[0..1] I_MaintenanceOrderOperation _MaintenanceOrderOperation I_PurgDocAccountAssignment.OrderID = _MaintenanceOrderOperation.MaintenanceOrder and I_PurgDocAccountAssignment.OrderIntBillOfOperationsItem = _MaintenanceOrderOperation.MaintOrderOperationCounter
[1..1] I_PurchasingDocument _PurchasingDocument I_PurgDocAccountAssignment.PurchasingDocument = _PurchasingDocument.PurchasingDocument
[0..1] I_PurchasingDocumentItem _PurchasingDocumentItem I_PurgDocAccountAssignment.PurchasingDocument = _PurchasingDocumentItem.PurchasingDocument and I_PurgDocAccountAssignment.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem

Annotations (7)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName PMORDNSTOCKPO view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchasingDocument
KEY PurchaseOrderItem PurchasingDocumentItem
AccountAssignmentNumber I_PurgDocAccountAssignment AccountAssignmentNumber
MaintenanceOrder I_PurgDocAccountAssignment OrderID
MaintenanceOrderType I_MaintenanceOrder MaintenanceOrderType
ProjectNetworkInternalID I_PurgDocAccountAssignment ProjectNetworkInternalID
NetworkActivityInternalID I_PurgDocAccountAssignment NetworkActivityInternalID
OrderIntBillOfOperationsItem I_PurgDocAccountAssignment OrderIntBillOfOperationsItem
_PlanningBucketOrder _PlanningBucketOrder
_PurchasingDocument _PurchasingDocument
_PurchasingDocumentItem _PurchasingDocumentItem
_MaintenanceOrder _MaintenanceOrder
_MaintenanceOrderOperation _MaintenanceOrderOperation 
@VDM: { 
  viewType: #CONSUMPTION,
  private: true
}
@AccessControl: {
  authorizationCheck: #PRIVILEGED_ONLY,
  privilegedAssociations: ['_PlanningBucketOrder']
}
@AbapCatalog.sqlViewName: 'PMORDNSTOCKPO'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey:true

// This is private view which is created for only that purpose: It collects the component which directly procured from Purchase Order in the Manage Backlog app

define view P_MaintOrdNonStkCompFromPurOrd
  as select from I_PurgDocAccountAssignment
    inner join   I_MaintenanceOrder on I_MaintenanceOrder.MaintenanceOrder = I_PurgDocAccountAssignment.OrderID
  association [0..1] to P_MaintPlngBcktOrder        as _PlanningBucketOrder       on  _PlanningBucketOrder.MaintenanceOrder = $projection.MaintenanceOrder
  association [1..1] to I_MaintenanceOrder          as _MaintenanceOrder          on  _MaintenanceOrder.MaintenanceOrder = I_PurgDocAccountAssignment.OrderID
  association [0..1] to I_MaintenanceOrderOperation as _MaintenanceOrderOperation on  I_PurgDocAccountAssignment.OrderID                      = _MaintenanceOrderOperation.MaintenanceOrder
                                                                                  and I_PurgDocAccountAssignment.OrderIntBillOfOperationsItem = _MaintenanceOrderOperation.MaintOrderOperationCounter
  association [1..1] to I_PurchasingDocument        as _PurchasingDocument        on  I_PurgDocAccountAssignment.PurchasingDocument = _PurchasingDocument.PurchasingDocument
  association [0..1] to I_PurchasingDocumentItem    as _PurchasingDocumentItem    on  I_PurgDocAccountAssignment.PurchasingDocument     = _PurchasingDocumentItem.PurchasingDocument
                                                                                  and I_PurgDocAccountAssignment.PurchasingDocumentItem = _PurchasingDocumentItem.PurchasingDocumentItem
{
  key PurchasingDocument                 as PurchaseOrder,
  key PurchasingDocumentItem             as PurchaseOrderItem,
      @UI.hidden: true
      I_PurgDocAccountAssignment.AccountAssignmentNumber,
      I_PurgDocAccountAssignment.OrderID as MaintenanceOrder,
      I_MaintenanceOrder.MaintenanceOrderType,
      I_PurgDocAccountAssignment.ProjectNetworkInternalID,
      I_PurgDocAccountAssignment.NetworkActivityInternalID,
      I_PurgDocAccountAssignment.OrderIntBillOfOperationsItem,

      _PlanningBucketOrder,
      _PurchasingDocument,
      _PurchasingDocumentItem,
      _MaintenanceOrder,
      _MaintenanceOrderOperation
}
where
      I_PurgDocAccountAssignment.IsDeleted        = ''
  and I_MaintenanceOrder.MaintenanceOrder         is not null
  and I_MaintenanceOrder.MaintenanceOrderCategory = '30'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDER",
"I_PURGDOCACCOUNTASSIGNMENT"
],
"ASSOCIATED":
[
"I_MAINTENANCEORDER",
"I_MAINTENANCEORDEROPERATION",
"I_PURCHASINGDOCUMENT",
"I_PURCHASINGDOCUMENTITEM",
"P_MAINTPLNGBCKTORDER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More