P_SerialNumberProfileProcedure

DDL: P_SERIALNUMBERPROFILEPROCEDURE Type: view_entity COMPOSITE Package: VDM_EAM_MAINTJOB_MANAGE_COMP

Serial number profile procedure

P_SerialNumberProfileProcedure is a Composite CDS View that provides data about "Serial number profile procedure" in SAP S/4HANA. It reads from 2 data sources (I_ProductPlant, I_SerialNumberProfileProcedure) and exposes 5 fields with key fields Product, Plant, SerialNumberProcedure. Part of development package VDM_EAM_MAINTJOB_MANAGE_COMP.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_ProductPlant _ProductPlant from
I_SerialNumberProfileProcedure _SerialNumberProfileProcedure inner

Annotations (3)

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

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Product I_ProductPlant Product
KEY Plant I_ProductPlant Plant
KEY SerialNumberProcedure I_SerialNumberProfileProcedure SerialNumberProcedure
SerialNumberProfile I_ProductPlant SerialNumberProfile
SerialNumberUsageInAssignment I_SerialNumberProfileProcedure SerialNumberUsageInAssignment 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@VDM.viewType: #COMPOSITE

// used to get serial number profile procedures maintained(tcode:OIS2) for a serial number profile.


define view entity P_SerialNumberProfileProcedure
  as select from I_ProductPlant as _ProductPlant
    inner join   I_SerialNumberProfileProcedure as _SerialNumberProfileProcedure on _SerialNumberProfileProcedure.SerialNumberProfile = _ProductPlant.SerialNumberProfile
{
  key _ProductPlant.Product,
  key _ProductPlant.Plant,
  key _SerialNumberProfileProcedure.SerialNumberProcedure,
      _ProductPlant.SerialNumberProfile,
      _SerialNumberProfileProcedure.SerialNumberUsageInAssignment
}

Learn More