I_PRODTOEXPLCTASSTMTMDLVERSTP

CDS View

Product Assignable to Assortment Module Version

I_PRODTOEXPLCTASSTMTMDLVERSTP is a CDS View in S/4HANA. Product Assignable to Assortment Module Version. It contains 2 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 2 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_ProdToExplicitAsstmtMdlVers view_entity projection CONSUMPTION Product Assignment to Assortment Module Version
C_ProductToAssortmentMdlVersTP view_entity projection CONSUMPTION Product Assignment to Assortment Module Version
I_ProdAssgblToExplctMdlVersTP view_entity left_outer TRANSACTIONAL Product Assignable to Assortment Module Version

Fields (2)

KeyField CDS FieldsUsed in Views
ValidityEndDate AssignmentValidityEndDate 1
ValidityStartDate AssignmentValidityStartDate 1 
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EXPLICITASSTMTMDLVERSIONTP",
"I_PRODUCTTOASSORTMENTMODULE"
],
"ASSOCIATED":
[
"I_EXCLSNRATIOFORASSTMTMDLPROD",
"I_EXPLICITASSTMTMDLVERSIONTP",
"I_PRODASSGBLTOEXPLCTMODULETP",
"I_PRODTOEXPLICITASSTMTMDLTP",
"I_PRODUCT",
"I_USERCONTACTCARD"
],
"BASE":
[
"I_PRODUCTTOASSORTMENTMODULE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More