I_ProdAssgblToExplctMdlVersTP

DDL: I_PRODASSGBLTOEXPLCTMDLVERSTP Type: view_entity TRANSACTIONAL

Product Assignable to Assortment Module Version

I_ProdAssgblToExplctMdlVersTP 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_ProdToExplctAsstmtMdlVersTP, I_ProdAssgblToExplctModuleTP) and exposes 13 fields with key fields AssortmentModuleVersionUUID, Product. It has 1 association to related views.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_ProdToExplctAsstmtMdlVersTP Assignments left_outer
I_ProdAssgblToExplctModuleTP Product cross

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_AssortmentModuleText _Text _Text.AssortmentModuleUUID = $projection.AssortmentModuleVersionUUID

Annotations (9)

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

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY AssortmentModuleVersionUUID ModuleVersion AssortmentModuleVersionUUID
KEY Product I_ProdAssgblToExplctModuleTP Product
AssortmentModuleName ModuleVersion AssortmentModuleName
ValidityStartDate ModuleVersion ValidityStartDate
ValidityEndDate ModuleVersion ValidityEndDate
AssignmentValidityStartDate I_ProdToExplctAsstmtMdlVersTP ValidityStartDate
AssignmentValidityEndDate I_ProdToExplctAsstmtMdlVersTP ValidityEndDate
AuthorizationGroup I_ProdAssgblToExplctModuleTP AuthorizationGroup
ProductGroup I_ProdAssgblToExplctModuleTP ProductGroup
ProductType I_ProdAssgblToExplctModuleTP ProductType
_ProductGroup_2 I_ProdAssgblToExplctModuleTP _ProductGroup_2
_ProductType I_ProdAssgblToExplctModuleTP _ProductType
_Text _Text 
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
  }

@EndUserText.label: 'Product Assignable to Assortment Module Version'

@VDM: {
  viewType: #TRANSACTIONAL,

  lifecycle: {
    contract: {
      type: #SAP_INTERNAL_API
    }
  }
}

@ObjectModel: {
    usageType: {
        serviceQuality: #C,
        sizeCategory: #L,
        dataClass: #MASTER
   },
   sapObjectNodeType.name: 'Product'
}

define root view entity I_ProdAssgblToExplctMdlVersTP
  as select from(
                    I_ExplicitAsstmtMdlVersionTP  as ModuleVersion
      cross join    I_ProdAssgblToExplctModuleTP  as Product
  )
    left outer join I_ProdToExplctAsstmtMdlVersTP as Assignments on  ModuleVersion.AssortmentModuleVersionUUID = Assignments.AssortmentModuleUUID
                                                                 and Product.Product                           = Assignments.Product
  association [1..*] to I_AssortmentModuleText as _Text on _Text.AssortmentModuleUUID = $projection.AssortmentModuleVersionUUID
{
  key ModuleVersion.AssortmentModuleVersionUUID,
  key Product.Product,
      ModuleVersion.AssortmentModuleName,
      ModuleVersion.ValidityStartDate, // as VersionValidityStartDate,

      ModuleVersion.ValidityEndDate, // as VersionValidityEndDate,

      Assignments.ValidityStartDate                        as AssignmentValidityStartDate,
      Assignments.ValidityEndDate                          as AssignmentValidityEndDate,
      cast(
         case  coalesce( Assignments.Product , ' ' )
          when ' ' then ' '
          else 'X' end
        as rfm_asm_is_prod_assgnd_to_mdl preserving type ) as ProductIsAssignedToVersion,
      //for DCL

      Product.AuthorizationGroup,
      Product.ProductGroup,
      Product.ProductType,
      Product._ProductGroup_2,
      Product._ProductType,
      _Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EXPLICITASSTMTMDLVERSIONTP",
"I_PRODASSGBLTOEXPLCTMODULETP",
"I_PRODTOEXPLCTASSTMTMDLVERSTP"
],
"ASSOCIATED":
[
"I_ASSORTMENTMODULETEXT",
"I_PRODUCTGROUP_2",
"I_PRODUCTTYPE"
],
"BASE":
[
"I_PRODASSGBLTOEXPLCTMODULETP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More