P_SubscriptionProductPurpose

DDL: P_SUBSCRIPTIONPRODUCTPURPOSE SQL: PSPRURPOSE Type: view BASIC

P_SubscriptionProductPurpose is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (mara, t134) and exposes 2 fields with key field Product.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
mara Product from
t134 ProductType inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PSPRURPOSE view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.private true view
VDM.viewType #BASIC view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Product mara matnr
ProductType mara mtart 
@AbapCatalog.sqlViewName: 'PSPRURPOSE'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
//@EndUserText.label: 'Subscription Product Purpose'

@ClientHandling.algorithm: #SESSION_VARIABLE


@VDM.private: true
@VDM.viewType: #BASIC

define view P_SubscriptionProductPurpose
  as select from    mara             as Product                   
    inner join      t134             as ProductType                on Product.mtart = ProductType.mtart
    left outer to one join crms4c_som_prcat as SubscriptionProductPurpose on Product.mtart = SubscriptionProductPurpose.producttype
{
  key Product.matnr                         as Product,
      Product.mtart                         as ProductType,
      case SubscriptionProductPurpose.prod_class
       when 'B' then SubscriptionProductPurpose.prod_class 
       when 'P' then SubscriptionProductPurpose.prod_class
       when 'A' then SubscriptionProductPurpose.prod_class
       else ''
     end as SubscriptionProductPurpose
}
where
  ProductType.prod_type_code = '3';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CRMS4C_SOM_PRCAT",
"MARA",
"T134"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More