I_SlsPricingConditionFieldText

DDL: I_SLSPRICINGCONDITIONFIELDTEXT SQL: ICNDNFIELDT Type: view BASIC

Sales Pricing Field Catalog - Text

I_SlsPricingConditionFieldText is a Basic CDS View that provides data about "Sales Pricing Field Catalog - Text" in SAP S/4HANA. It reads from 2 data sources (dd03l, dd04t) and exposes 7 fields with key fields Language, ConditionUsage, ConditionApplication, PricingConditionField, DatabaseTable. It has 1 association to related views.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
dd03l dd03l from
dd04t dd04t inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_SalesPricingConditionField _SalesPricingConditionField $projection.ConditionUsage = _SalesPricingConditionField.ConditionUsage and $projection.ConditionApplication = _SalesPricingConditionField.ConditionApplication and $projection.PricingConditionField = _SalesPricingConditionField.PricingConditionField

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ICNDNFIELDT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #TEXT view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
EndUserText.label Sales Pricing Field Catalog - Text view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Language dd04t ddlanguage
KEY ConditionUsage
KEY ConditionApplication
KEY PricingConditionField dd03l fieldname
KEY DatabaseTable dd03l tabname
PricingConditionFieldText dd04t scrtext_l
_SalesPricingConditionField _SalesPricingConditionField 
@AbapCatalog.sqlViewName: 'ICNDNFIELDT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.dataCategory: #TEXT
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities:
    [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #CDS_MODELING_ASSOCIATION_TARGET ]
@ObjectModel.modelingPattern: #ANALYTICAL_CUBE
@EndUserText.label: 'Sales Pricing Field Catalog  - Text'
define view I_SlsPricingConditionFieldText
  as select from dd03l
    inner join   dd04t on  (
        dd03l.tabname                     = 'KOMP'
        or dd03l.tabname                  = 'KOMK'
        or dd03l.tabname                  = 'KOMG'
      )
                       and dd03l.rollname = dd04t.rollname
  association [1..1] to I_SalesPricingConditionField as _SalesPricingConditionField on  $projection.ConditionUsage        = _SalesPricingConditionField.ConditionUsage
                                                                                    and $projection.ConditionApplication  = _SalesPricingConditionField.ConditionApplication
                                                                                    and $projection.PricingConditionField = _SalesPricingConditionField.PricingConditionField

{
      @Semantics.language: true
  key dd04t.ddlanguage      as Language,
  key cast ( 'A' as kvewe ) as ConditionUsage,
  key cast ( 'V' as kappl ) as ConditionApplication,
  key dd03l.fieldname       as PricingConditionField,
  key dd03l.tabname         as DatabaseTable,
      @Semantics.text: true
      dd04t.scrtext_l       as PricingConditionFieldText,
      _SalesPricingConditionField

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD03L",
"DD04T"
],
"ASSOCIATED":
[
"I_SALESPRICINGCONDITIONFIELD"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More