I_ProcmtAutomnSAPObjFieldVH

@AbapCatalog.sqlViewName: 'IOBJTYPFLD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Base view for SAP Object Type Field'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.serviceQuality: #A
define view I_ProcmtAutomnSAPObjFieldVH
  as select distinct from ddldependency  as d
    inner join         dd03l   as c on c.tabname = d.objectname
    inner join  sbo_i_node_cds as n on n.cds_view_name = d.ddlname

{
      //DD03L

      //key tabname as InputTableName,

  key c.fieldname          as BusinessObjectFieldName,
  key n.object_node_type as SAPObjectNodeType
      //c.objectname as sapobjectname

}
where
         objecttype       = 'VIEW'
  and(
         n.object_node_type = 'PrmtHbRpldPurchaseReqnItem'
  )
  or(
         n.object_node_type = 'PurchaseRequisitionItem'
    and

    (   //for 1908 scope , To be relaxed later

         c.fieldname          = 'ACCOUNTASSIGNMENTCATEGORY'
      or c.fieldname          = 'BASEUNIT'
      or c.fieldname          = 'DELIVERYDATE'
      or c.fieldname          = 'FIXEDSUPPLIER'
      or c.fieldname          = 'GOODSRECEIPTISNONVALUATED'
      or c.fieldname          = 'GOODSRECEIPTISEXPECTED'
      or c.fieldname          = 'INVOICEISEXPECTED'
      or c.fieldname          = 'ISCLOSED'
      or c.fieldname          = 'ISPURREQNBLOCKED'
      or c.fieldname          = 'MATERIAL'
      or c.fieldname          = 'MATERIALGROUP'
      or c.fieldname          = 'PLANT'
      or c.fieldname          = 'PURCHASECONTRACT'
      or c.fieldname          = 'PURCHASECONTRACTITEM'
      or c.fieldname          = 'PURCHASEREQUISITIONISFIXED'
      or c.fieldname          = 'PURCHASINGGROUP'
      or c.fieldname          = 'PURCHASINGINFORECORD'
      or c.fieldname          = 'PURCHASINGORGANIZATION'
      or c.fieldname          = 'PURREQNITEMCURRENCY'
      or c.fieldname          = 'REQUIREMENTTRACKING'
      or c.fieldname          = 'REQUISITIONERNAME'
      or c.fieldname          = 'STORAGELOCATION'
      or c.fieldname          = 'SUPPLIER'
      or c.fieldname          = 'SUPPLIERMATERIALNUMBER'
      or c.fieldname          = 'SUPPLYINGPLANT'
      or c.fieldname          = 'PURCHASEREQUISITIONITEMTEXT'
      or c.fieldname          = 'REQUESTEDQUANTITY'
    )
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD03L",
"DDLDEPENDENCY",
"SBO_I_NODE_CDS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/