I_CrsCtlgUsableMappingVersion

DDL: I_CRSCTLGUSABLEMAPPINGVERSION SQL: ICRSCTLGUSEVRSN Type: view BASIC

Usable Cross Catalog Mapping Version

I_CrsCtlgUsableMappingVersion is a Basic CDS View that provides data about "Usable Cross Catalog Mapping Version" in SAP S/4HANA. It reads from 3 data sources (crms4d_som_vrsn, crms4d_som_vrst, crms4d_som_spsd) and exposes 4 fields with key fields CrsCatalogMappingVersionNumber, Product.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
crms4d_som_vrsn _CrsCtlgMappingVersion from
crms4d_som_vrst _CrsCtlgMappingVersionT inner
crms4d_som_spsd _Product inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICRSCTLGUSEVRSN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Usable Cross Catalog Mapping Version view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CrsCatalogMappingVersionNumber crms4d_som_vrsn crscatalogmappingversionnumber
KEY Product crms4d_som_spsd product
CrsCtlgMappgVersionDescription crms4d_som_vrst crsctlgmappgversiondescription
CrossCatalogMappingVersionUUID crms4d_som_vrsn crosscatalogmappingversionuuid 
@AbapCatalog.sqlViewName: 'ICRSCTLGUSEVRSN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory : #M
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Usable Cross Catalog Mapping Version'
define view I_CrsCtlgUsableMappingVersion
  as select from crms4d_som_vrsn as _CrsCtlgMappingVersion
    inner join   crms4d_som_spsd as _Product                on _Product.subscrpnprodspecuuid = _CrsCtlgMappingVersion.subscrpnprodspecuuid
    inner join   crms4d_som_vrst as _CrsCtlgMappingVersionT on  _CrsCtlgMappingVersionT.crosscatalogmappingversionuuid = _CrsCtlgMappingVersion.crosscatalogmappingversionuuid
                                                            and _CrsCtlgMappingVersionT.language                       = $session.system_language

{

  key  _CrsCtlgMappingVersion.crscatalogmappingversionnumber  as CrsCatalogMappingVersionNumber,
  key  _Product.product                                       as Product,
       _CrsCtlgMappingVersionT.crsctlgmappgversiondescription as CrsCtlgMappgVersionDescription,
       _CrsCtlgMappingVersion.crosscatalogmappingversionuuid  as CrossCatalogMappingVersionUUID

}
where
  _CrsCtlgMappingVersion.crscatalogmappingversionnumber is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CRMS4D_SOM_SPSD",
"CRMS4D_SOM_VRSN",
"CRMS4D_SOM_VRST"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More