P_MaintOrderPurOrdLink

DDL: P_MAINTORDERPURORDLINK Type: view_entity BASIC

Maintenance Order and Purchase Order Link

P_MaintOrderPurOrdLink is a Basic CDS View that provides data about "Maintenance Order and Purchase Order Link" in SAP S/4HANA. It reads from 1 data source (ekkn) and exposes 15 fields with key fields PurchaseOrder, PurchaseOrderItem, PurchaseOrderAcctAssgmtNumber, MaintenanceOrder.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
ekkn ekkn from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Maintenance Order and Purchase Order Link view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder ekkn ebeln
KEY PurchaseOrderItem ekkn ebelp
KEY PurchaseOrderAcctAssgmtNumber ekkn zekkn
KEY MaintenanceOrder ekkn aufnr
Reservation ekpo arsnr
ReservationItem ekpo arsps
ProjectNetworkInternalID ekkn aufpl
OrderInternalID ekkn aufpl_ord
OrderIntBillOfOperationsItem ekkn aplzl_ord
OrderOperationInternalID ekkn aplzl_ord
DeliveryCompletedInd ekpo elikz
ProductType ekpo producttype
PurchaseRequisitionItemID ekpo bnfpo
PurchaseRequisitionNumber ekpo banfn
AccAssignmentCategory ekpo knttp 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM: { viewType: #BASIC,
        private: true }
@ObjectModel: {
  usageType: {
    serviceQuality: #A,
    dataClass:      #TRANSACTIONAL,
    sizeCategory:   #L
  }
}

@EndUserText.label: 'Maintenance Order and Purchase Order Link'

define view entity P_MaintOrderPurOrdLink 
as select from ekkn
   left outer to one join ekpo on  ekkn.ebeln = ekpo.ebeln
                               and ekkn.ebelp = ekpo.ebelp
   left outer to one join aufk on  aufk.aufnr = ekkn.aufnr
 {
    key  ekkn.ebeln          as                 PurchaseOrder,
    key  ekkn.ebelp          as                 PurchaseOrderItem,
    key  ekkn.zekkn          as                 PurchaseOrderAcctAssgmtNumber,
    key  ekkn.aufnr          as                 MaintenanceOrder,
         ekpo.arsnr          as                 Reservation,
         ekpo.arsps          as                 ReservationItem,
         ekkn.aufpl          as                 ProjectNetworkInternalID,
         ekkn.aufpl_ord      as                 OrderInternalID,
         ekkn.aplzl_ord      as                 OrderIntBillOfOperationsItem,
         ekkn.aplzl_ord      as                 OrderOperationInternalID,
         ekpo.elikz          as                 DeliveryCompletedInd,
         ekpo.producttype    as                 ProductType,
         ekpo.bnfpo          as                 PurchaseRequisitionItemID,
         ekpo.banfn          as                 PurchaseRequisitionNumber,
         ekpo.knttp          as                 AccAssignmentCategory
         
                       
 }
  where aufk.autyp = '30'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AUFK",
"EKKN",
"EKPO"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More