I_ProcmtAutomnSAPObjFieldVH

DDL: I_PROCMTAUTOMNSAPOBJFIELDVH SQL: IOBJTYPFLD Type: view BASIC Package: VDM_MM_PUR_BUS_PROC_AUTOMN

Base view for SAP Object Type Field

I_ProcmtAutomnSAPObjFieldVH is a Basic CDS View that provides data about "Base view for SAP Object Type Field" in SAP S/4HANA. It reads from 2 data sources (dd03l, sbo_i_node_cds) and exposes 2 fields with key fields BusinessObjectFieldName, SAPObjectNodeType. Part of development package VDM_MM_PUR_BUS_PROC_AUTOMN.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
dd03l c inner
sbo_i_node_cds n inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IOBJTYPFLD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Base view for SAP Object Type Field view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY BusinessObjectFieldName dd03l fieldname
KEY SAPObjectNodeType sbo_i_node_cds object_node_type 
@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
         d.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'
    )
  )
  or (
         n.object_node_type = 'ResponsibilityManagementTeam'
    and

    (   
         c.fieldname          = 'RESPYMGMTGLOBALTEAMID'
      ) )

Learn More