P_Swlist

DDL: P_SWLIST SQL: PSWLIST Type: view BASIC

P_Swlist is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (/plmi/esd_c_gs, mara) and exposes 11 fields with key fields Material, DocNumber, DocumentVersion, DocumentPart, DocumentType.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
/plmi/esd_c_gs /plmi/esd_c_gs inner
mara mara inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PSWLIST view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Material mara matnr
KEY DocNumber drad doknr
KEY DocumentVersion
KEY DocumentPart drad doktl
KEY DocumentType drad dokar
KEY LinkedSAPObject drad dokob
EmbeddedSwSoftwareMaterial /plmi/sw_cstrt sw_module
EmbeddedSwConstraintObjectType /plmi/sw_cstrt cstrt_obj_type
ProductStructureNodeUUID /plmi/sw_cstrt db_key
EmbeddedSoftwareETag /plmi/sw_cstrt etag
AuthorizationGroup mara begru 
@AbapCatalog.sqlViewName: 'PSWLIST'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_Swlist
  as select distinct from drad
    inner join          /plmi/esd_c_gs on /plmi/esd_c_gs.dokar = drad.dokar
    inner join          mara           on mara.matnr           = drad.objky    
  association [0..*] to /plmi/sw_cstrt on $projection.Material = /plmi/sw_cstrt.sw_module
{
  key  mara.matnr                            as  Material,
  key  drad.doknr                            as  DocNumber,
       //@EndUserText.label: 'Software Version'

  key  cast ( drad.dokvr as /plmb/dokvr )    as  DocumentVersion,
       //  key  drad.dokvr    as  DocumentVersion,

  key  drad.doktl                            as  DocumentPart,
  key  drad.dokar                            as  DocumentType,
  key  drad.dokob                            as  LinkedSAPObject,
       /plmi/sw_cstrt.sw_module              as  EmbeddedSwSoftwareMaterial,
       /plmi/sw_cstrt.cstrt_obj_type         as  EmbeddedSwConstraintObjectType,
       /plmi/sw_cstrt.db_key                 as  ProductStructureNodeUUID,
       /plmi/sw_cstrt.etag                   as  EmbeddedSoftwareETag,
       mara.begru                            as  AuthorizationGroup
}
where
  dokob = 'MARA'          
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/PLMI/ESD_C_GS",
"/PLMI/SW_CSTRT",
"DRAD",
"MARA"
],
"ASSOCIATED":
[
"/PLMI/SW_CSTRT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More