I_CSTRTSWMATLCSTRT

CDS View

Software Material with Constriant Data

I_CSTRTSWMATLCSTRT is a CDS View in S/4HANA. Software Material with Constriant Data. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_CstrtSwMatlAllVers view from BASIC All Version Data of Software Materials 
@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