P_PricingProcedureText

DDL: P_PRICINGPROCEDURETEXT SQL: PRCGPROCEDT Type: view BASIC

P_PricingProcedureText is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (t683u) and exposes 6 fields with key fields Language, ConditionUsage, ConditionApplication, PricingProcedure. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
t683u t683u from

Associations (1)

CardinalityTargetAliasCondition
[1..1] P_PricingProcedure _PricingProcedure $projection.ConditionUsage = _PricingProcedure.ConditionUsage and $projection.ConditionApplication = _PricingProcedure.ConditionApplication and $projection.PricingProcedure = _PricingProcedure.PricingProcedure

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PRCGPROCEDT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
VDM.private true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Language spras
KEY ConditionUsage kvewe
KEY ConditionApplication kappl
KEY PricingProcedure kalsm
PricingProcedureName vtext
_PricingProcedure _PricingProcedure
@AbapCatalog.sqlViewName: 'PRCGPROCEDT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.buffering.status: #ACTIVE         
@AbapCatalog.buffering.type: #FULL
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.private: true

define view P_PricingProcedureText
  as select from t683u
  association [1..1] to P_PricingProcedure as _PricingProcedure on  $projection.ConditionUsage       = _PricingProcedure.ConditionUsage
                                                                and $projection.ConditionApplication = _PricingProcedure.ConditionApplication
                                                                and $projection.PricingProcedure     = _PricingProcedure.PricingProcedure

{
  key spras as Language,
  key kvewe as ConditionUsage,
  key kappl as ConditionApplication,
  key kalsm as PricingProcedure,
      vtext as PricingProcedureName,
      _PricingProcedure
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T683U"
],
"ASSOCIATED":
[
"P_PRICINGPROCEDURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/