I_UtilsFact

DDL: I_UTILSFACT SQL: IEPSUTILSFACT Type: view BASIC

Product Facts/Operand Mapping

I_UtilsFact is a Basic CDS View that provides data about "Product Facts/Operand Mapping" in SAP S/4HANA. It reads from 2 data sources (dd07t, isuc_ps_fact) and exposes 8 fields with key fields UtilsBillingOperand, UtilsProductType.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
dd07t dd07t inner
isuc_ps_fact isuc_ps_fact from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IEPSUTILSFACT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Product Facts/Operand Mapping view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY UtilsBillingOperand isuc_ps_fact operand
KEY UtilsProductType isuc_ps_fact producttype
UtilsOperandMappingID isuc_ps_fact mappingid
UtilsSemanticsType semanticstype
UtilsSemanticsName1 isuc_ps_fact semantics1
UtilsSemanticsName2 isuc_ps_fact semantics2
UtilsSemanticsTypeDescription dd07t ddtext
_UtilsOperand _UtilsOperand 
@AbapCatalog.sqlViewName: 'IEPSUTILSFACT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Product Facts/Operand Mapping'
define view I_UtilsFact
  as select from isuc_ps_fact
    inner join   dd07t on domvalue_l = isuc_ps_fact.semanticstype
    association[0..1] to I_UtilsOperand as _UtilsOperand on $projection.UtilsBillingOperand = _UtilsOperand.UtilsBillingOperand
{

  key isuc_ps_fact.operand                as UtilsBillingOperand,
  key isuc_ps_fact.producttype            as UtilsProductType,
      isuc_ps_fact.mappingid              as UtilsOperandMappingID,
      semanticstype                       as UtilsSemanticsType,
      isuc_ps_fact.semantics1             as UtilsSemanticsName1,
      isuc_ps_fact.semantics2             as UtilsSemanticsName2,
      dd07t.ddtext                        as UtilsSemanticsTypeDescription,
      _UtilsOperand  

}
where
      domname    = 'ISU_PS_SEMANTICS_TYPE'
  and ddlanguage = $session.system_language
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T",
"ISUC_PS_FACT"
],
"ASSOCIATED":
[
"I_UTILSOPERAND"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More