I_CstrtSwMatlCstrt

DDL: I_CSTRTSWMATLCSTRT SQL: ICSTRTSWMATLC Type: view BASIC

Software Material with Constriant Data

I_CstrtSwMatlCstrt is a Basic CDS View that provides data about "Software Material with Constriant Data" in SAP S/4HANA. It reads from 5 data sources (/plmi/esd_c_swmt, /plmi/sw_cstrt_h, drad, draw, mara) and exposes 10 fields with key fields Material, DocNumber, DocumentVersion, DocumentPart, DocumentType.

5 data source(s) 10 fields

Data Sources (5)

SourceAliasJoin Type
/plmi/esd_c_swmt /plmi/esd_c_swmt inner
/plmi/sw_cstrt_h /plmi/sw_cstrt_h left_outer
drad drad left_outer
draw draw left_outer
mara mara from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICSTRTSWMATLC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Software Material with Constriant Data view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Material matnr
KEY DocNumber drad doknr
KEY DocumentVersion drad dokvr
KEY DocumentPart drad doktl
KEY DocumentType drad dokar
KEY LinkedSAPObject drad dokob
EmbeddedSoftwareVersionStatus draw dokst
EmbeddedSwExternalVersion draw res1
AuthorizationGroup mara begru
EmbeddedSoftwareUUID /plmi/sw_cstrt_h db_key 
@AbapCatalog.sqlViewName: 'ICSTRTSWMATLC'

@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #C

@EndUserText.label: 'Software Material with Constriant Data'
define view I_CstrtSwMatlCstrt as select from mara  
     inner join      /plmi/esd_c_swmt  on  mara.mtart = /plmi/esd_c_swmt.sw_mtart 
     left outer join drad              on  mara.matnr = drad.objky
                                       and drad.dokob = 'MARA' 
//     left outer join /plmi/esd_c_gs    on  drad.dokar = /plmi/esd_c_gs.dokar

     left outer join /plmi/sw_cstrt_h  on  mara.matnr = /plmi/sw_cstrt_h.sw_module
     left outer join draw              on  draw.dokar   = drad.dokar
                                       and draw.doknr   = drad.doknr
                                       and draw.doktl   = drad.doktl 
                                       and draw.dokvr   = drad.dokvr
//     left outer join tdws              on  tdws.dokar = drad.dokar

//                                       and tdws.dokst = draw.dokst    

{
    key  matnr                                 as Material,  
    key  drad.doknr                            as DocNumber,
    key  drad.dokvr                            as DocumentVersion,
    key  drad.doktl                            as DocumentPart,
    key  drad.dokar                            as DocumentType,
    key  drad.dokob                            as LinkedSAPObject,
         draw.dokst                            as EmbeddedSoftwareVersionStatus,
         draw.res1                             as EmbeddedSwExternalVersion,
         mara.begru                            as AuthorizationGroup,
         /plmi/sw_cstrt_h.db_key               as EmbeddedSoftwareUUID
}  
//where drad.dokob = 'MARA' 

//and tdws.frknz = 'X'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/PLMI/ESD_C_SWMT",
"/PLMI/SW_CSTRT_H",
"DRAD",
"DRAW",
"MARA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More