I_CstrtSwMatlAllVers

DDL: I_CSTRTSWMATLALLVERS SQL: ICSTRTSWALLVERS Type: view BASIC

All Version Data of Software Materials

I_CstrtSwMatlAllVers is a Basic CDS View that provides data about "All Version Data of Software Materials" in SAP S/4HANA. It reads from 3 data sources (I_CstrtSwMatlCstrt, /plmi/esd_c_gs, drat) and exposes 9 fields with key fields Material, DocNumber, DocumentPart, DocumentType, DocumentVersion.

3 data source(s) 9 fields

Data Sources (3)

SourceAliasJoin Type
I_CstrtSwMatlCstrt _SwMatlCstrt from
/plmi/esd_c_gs /plmi/esd_c_gs inner
drat drat left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICSTRTSWALLVERS 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 All Version Data of Software Materials view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY Material Material
KEY DocNumber DocNumber
KEY DocumentPart DocumentPart
KEY DocumentType DocumentType
KEY DocumentVersion DocumentVersion
EmbeddedSoftwareVersionStatus EmbeddedSoftwareVersionStatus
EmbeddedSwExternalVersion EmbeddedSwExternalVersion
EmbeddedSwVersionDescription drat dktxt
AuthorizationGroup AuthorizationGroup 
@AbapCatalog.sqlViewName: 'ICSTRTSWALLVERS'

@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: 'All Version Data of Software Materials'
define view I_CstrtSwMatlAllVers as select from I_CstrtSwMatlCstrt as _SwMatlCstrt
    inner join      /plmi/esd_c_gs    on  /plmi/esd_c_gs.dokar = _SwMatlCstrt.DocumentType
//    left outer join tdws              on  tdws.dokar   = _SwMatlCstrt.DocumentType

//                                      and tdws.dokst   = _SwMatlCstrt.EmbeddedSoftwareVersionStatus    

    left outer join drat              on  drat.dokar   = _SwMatlCstrt.DocumentType
                                      and drat.doknr   = _SwMatlCstrt.DocNumber
                                      and drat.dokvr   = _SwMatlCstrt.DocumentVersion
                                      and drat.doktl   = _SwMatlCstrt.DocumentPart
                                      and drat.langu   = $session.system_language                                                                     
{   key  Material,
    key  DocNumber,
    key  DocumentPart,
    key  DocumentType,
    key  DocumentVersion,
         EmbeddedSoftwareVersionStatus,
         EmbeddedSwExternalVersion,
         drat.dktxt       as EmbeddedSwVersionDescription,
         AuthorizationGroup
}//where tdws.frknz = 'X'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CSTRTSWMATLCSTRT",
"/PLMI/ESD_C_GS",
"DRAT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More