I_ProdToExplctAsstmtMdlVersTP

DDL: I_PRODTOEXPLCTASSTMTMDLVERSTP Type: view_entity TRANSACTIONAL

Product Assignable to Assortment Module Version

I_ProdToExplctAsstmtMdlVersTP is a Transactional CDS View that provides data about "Product Assignable to Assortment Module Version" in SAP S/4HANA. It reads from 2 data sources (I_ExplicitAsstmtMdlVersionTP, I_ProductToAssortmentModule) and exposes 16 fields with key fields AssortmentModuleUUID, Product, ValidityStartDate, ValidityEndDate. It has 4 associations to related views.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_ExplicitAsstmtMdlVersionTP ExplicitModule inner
I_ProductToAssortmentModule Product from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_ExplicitAsstmtMdlVersionTP _ExplicitAssortmentModuleVers $projection.AssortmentModuleUUID = _ExplicitAssortmentModuleVers.AssortmentModuleVersionUUID
[1..1] I_ProdAssgblToExplctModuleTP _ExplctAssortmentMdlProduct $projection.Product = _ExplctAssortmentMdlProduct.Product
[0..1] I_UserContactCard _User _User.ContactCardID = $projection.LastChangedByUserName
[0..1] I_ExclsnRatioForAsstmtMdlProd _ExclusionRatio $projection.AssortmentModuleObjectUUID = _ExclusionRatio.AssortmentModuleObjectUUID and $projection.Product = _ExclusionRatio.Product

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Product Assignable to Assortment Module Version view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name AssortmentModuleVersionProduct view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleUUID I_ProductToAssortmentModule AssortmentModuleUUID
KEY Product I_ProductToAssortmentModule Product
KEY ValidityStartDate I_ProductToAssortmentModule ValidityStartDate
KEY ValidityEndDate I_ProductToAssortmentModule ValidityEndDate
ProductIsMandatoryInAssortment I_ProductToAssortmentModule ProductIsMandatoryInAssortment
AssortmentModuleName I_ExplicitAsstmtMdlVersionTP AssortmentModuleName
LastChangeDate I_ProductToAssortmentModule LastChangeDate
LastChangeDateTime I_ProductToAssortmentModule LastChangeDateTime
LastChangedByUserName I_ProductToAssortmentModule LastChangedByUserName
AssortmentModuleObjectUUID I_ExplicitAsstmtMdlVersionTP AssortmentModuleUUID
_ExplicitAssortmentModuleVers _ExplicitAssortmentModuleVers
_ExplctAssortmentMdlProduct _ExplctAssortmentMdlProduct
_User _User
_Product I_ProductToAssortmentModule _Product
_ExclusionRatio _ExclusionRatio
_ProdToExplicitAsstmtMdl _ProdToExplicitAsstmtMdl 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Product Assignable to Assortment Module Version'

@ObjectModel: {
    usageType: {
        serviceQuality: #C,
        sizeCategory: #L,
        dataClass: #MASTER
   },
   sapObjectNodeType.name: 'AssortmentModuleVersionProduct'
}
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle: {
    contract: {
      type: #SAP_INTERNAL_API
    }
  }
}

define view entity I_ProdToExplctAsstmtMdlVersTP
  as select from I_ProductToAssortmentModule  as Product
    inner join   I_ExplicitAsstmtMdlVersionTP as ExplicitModule on Product.AssortmentModuleUUID = ExplicitModule.AssortmentModuleVersionUUID

  association [1..1] to I_ExplicitAsstmtMdlVersionTP  as _ExplicitAssortmentModuleVers on  $projection.AssortmentModuleUUID = _ExplicitAssortmentModuleVers.AssortmentModuleVersionUUID
  association [1..1] to I_ProdAssgblToExplctModuleTP  as _ExplctAssortmentMdlProduct   on  $projection.Product = _ExplctAssortmentMdlProduct.Product
  association [0..1] to I_UserContactCard             as _User                         on  _User.ContactCardID = $projection.LastChangedByUserName
  association [0..1] to I_ExclsnRatioForAsstmtMdlProd as _ExclusionRatio               on  $projection.AssortmentModuleObjectUUID = _ExclusionRatio.AssortmentModuleObjectUUID
                                                                                       and $projection.Product                    = _ExclusionRatio.Product
  association to parent I_ProdToExplicitAsstmtMdlTP as _ProdToExplicitAsstmtMdl on _ProdToExplicitAsstmtMdl.AssortmentModuleUUID  = $projection.AssortmentModuleObjectUUID
                                                                                  and _ProdToExplicitAsstmtMdl.Product = $projection.Product
                                                                                  and _ProdToExplicitAsstmtMdl.AssortmentModuleName = $projection.AssortmentModuleName
{
  key  Product.AssortmentModuleUUID,
  key  Product.Product,
  key  Product.ValidityStartDate,
  key  Product.ValidityEndDate,
       Product.ProductIsMandatoryInAssortment,
       ExplicitModule.AssortmentModuleName,
       Product.LastChangeDate,
       Product.LastChangeDateTime,
       Product.LastChangedByUserName,

       ExplicitModule.AssortmentModuleUUID as AssortmentModuleObjectUUID,

       _ExplicitAssortmentModuleVers,
       _ExplctAssortmentMdlProduct,
       _User,
       Product._Product,
       _ExclusionRatio,
       _ProdToExplicitAsstmtMdl
}

Learn More