P_MaintJobCompProdPlntStrgloc

DDL: P_MAINTJOBCOMPPRODPLNTSTRGLOC Type: view_entity BASIC Package: VDM_EAM_MAINTJOB_MNG_CMP_UNPLN

Maint Job Comp Material Plant & Storage

P_MaintJobCompProdPlntStrgloc is a Basic CDS View that provides data about "Maint Job Comp Material Plant & Storage" in SAP S/4HANA. It reads from 1 data source (I_ProductPlant) and exposes 11 fields with key fields Product, Plant, StorageLocation, MaintenanceOrderType. Part of development package VDM_EAM_MAINTJOB_MNG_CMP_UNPLN.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_ProductPlant _MaintJobCompProductPlant from

Annotations (3)

NameValueLevelField
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductPlant Product
KEY Plant I_ProductPlant Plant
KEY StorageLocation _ProductStorageLocation StorageLocation
KEY MaintenanceOrderType _OrderTypeperplant auart
ProductType
ProductGroup
BaseUnit
IsMarkedForDeletion I_ProductPlant IsMarkedForDeletion
SerialNumberProfile I_ProductPlant SerialNumberProfile
AuthorizationGroup
AvailabilityCheckType I_ProductPlant AvailabilityCheckType 
@VDM.viewType: #BASIC
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view entity P_MaintJobCompProdPlntStrgloc // View created to make storage location as key to consume in the I view

  as select from          I_ProductPlant  as _MaintJobCompProductPlant
    left outer to one join I_ProductStorageLocation   as _ProductStorageLocation on  _ProductStorageLocation.Product = _MaintJobCompProductPlant.Product
                                                                                 and _ProductStorageLocation.Plant   = _MaintJobCompProductPlant.Plant
    left outer to one join t350w as _OrderTypeperplant on _OrderTypeperplant.iwerk = _MaintJobCompProductPlant.Plant  
                                                                                   
                                                      
  {
  key _MaintJobCompProductPlant.Product,
  key _MaintJobCompProductPlant.Plant,
  key _ProductStorageLocation.StorageLocation,
  key _OrderTypeperplant.auart as MaintenanceOrderType,
  
      // exposed to apply condition in the consuption view 

      _MaintJobCompProductPlant._Product.ProductType,
      // exposed to use it in DCL 

      _MaintJobCompProductPlant._Product.ProductGroup,
      _MaintJobCompProductPlant._Product.BaseUnit,
      _MaintJobCompProductPlant.IsMarkedForDeletion,
      _MaintJobCompProductPlant.SerialNumberProfile,
       // exposed to use it in DCL

      _MaintJobCompProductPlant._Product.AuthorizationGroup,
      //exposed to use in Quantity Calculation

      _MaintJobCompProductPlant.AvailabilityCheckType
//      _MaintJobCompProductPlant._ProductPlant

}

Learn More