I_PurCtrCondItem

DDL: I_PURCTRCONDITEM SQL: IPURCTRCONDITEM Type: view BASIC

Purchase Contract Item Conditions

I_PurCtrCondItem is a Basic CDS View that provides data about "Purchase Contract Item Conditions" in SAP S/4HANA. It reads from 2 data sources (konp, a016) and exposes 18 fields with key fields PurchaseContract, PurchaseContractItem, ConditionValidityEndDate, ConditionType, ConditionRecord. It has 4 associations to related views.

2 data source(s) 18 fields

Data Sources (2)

SourceAliasJoin Type
konp ConditionDetails inner
a016 ConditionItem from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_PurchaseContractItem _ContractItem $projection.PurchaseContract = _ContractItem.PurchaseContract and $projection.PurchaseContractItem = _ContractItem.PurchaseContractItem
[0..1] I_Currency _DocumentCurrency $projection.ConditionRateValueUnit = _DocumentCurrency.Currency
[1..*] I_PurConditionText _ConditionText $projection.ConditionType = _ConditionText.ConditionType
[1..1] I_PurchaseContract _PurchaseContract _PurchaseContract.PurchaseContract = $projection.PurchaseContract

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IPURCTRCONDITEM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Purchase Contract Item Conditions view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract a016 evrtn
KEY PurchaseContractItem a016 evrtp
KEY ConditionValidityEndDate
KEY ConditionType konp kschl
KEY ConditionRecord a016 knumh
KEY ConditionSequentialNumber konp kopos
ConditionValidityStartDate
ConditionRateValue konp kbetr
ConditionRateValueUnit konp konwa
ConditionCalculationType konp krech
ConditionQuantity konp kpein
ConditionQuantityUnit konp kmein
ConditionApplication konp kappl
ConditionIsDeleted konp loevm_ko
_ConditionText _ConditionText
_DocumentCurrency _DocumentCurrency
_PurchaseContract _PurchaseContract
_ContractItem _ContractItem 
@AbapCatalog.sqlViewName: 'IPURCTRCONDITEM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Contract Item Conditions'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.semanticKey:  [ 'PurchaseContract','PurchaseContractItem','ConditionValidityEndDate', 'ConditionType' ,
                             'ConditionRecord', 'ConditionSequentialNumber']
define view I_PurCtrCondItem
  as select from a016 as ConditionItem
    inner join   konp as ConditionDetails on  ConditionItem.knumh       = ConditionDetails.knumh
                                          and ConditionDetails.loevm_ko = ''

  association [1..1] to I_PurchaseContractItem as _ContractItem     on  $projection.PurchaseContract     = _ContractItem.PurchaseContract
                                                                    and $projection.PurchaseContractItem = _ContractItem.PurchaseContractItem

  association [0..1] to I_Currency             as _DocumentCurrency on  $projection.ConditionRateValueUnit = _DocumentCurrency.Currency

  association [1..*] to I_PurConditionText     as _ConditionText    on  $projection.ConditionType = _ConditionText.ConditionType

  association [1..1] to I_PurchaseContract     as _PurchaseContract on  _PurchaseContract.PurchaseContract = $projection.PurchaseContract

{
  key  ConditionItem.evrtn                     as PurchaseContract,

  key  ConditionItem.evrtp                     as PurchaseContractItem,

          @Semantics.businessDate.to: true
  key     cast (ConditionItem.datbi as abap.dats) as  ConditionValidityEndDate,

          @ObjectModel.text.association:  '_ConditionText'
          @ObjectModel.readOnly: true
  key     ConditionDetails.kschl                  as  ConditionType,

  key     ConditionItem.knumh                     as  ConditionRecord,

  key     ConditionDetails.kopos                  as  ConditionSequentialNumber,
  
          @Semantics.businessDate.from: true
          cast (ConditionItem.datab as abap.dats) as  ConditionValidityStartDate,

          ConditionDetails.kbetr                  as  ConditionRateValue,

          @Semantics.currencyCode: true
          @ObjectModel.foreignKey.association: '_DocumentCurrency'
          ConditionDetails.konwa                  as  ConditionRateValueUnit,
          
          ConditionDetails.krech                  as  ConditionCalculationType,

          ConditionDetails.kpein                  as  ConditionQuantity,
          ConditionDetails.kmein                  as  ConditionQuantityUnit,
          ConditionDetails.kappl                  as  ConditionApplication,
          ConditionDetails.loevm_ko               as  ConditionIsDeleted,

          _ConditionText,

          _DocumentCurrency,

         @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT ]
         _PurchaseContract,

         @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT ]
         _ContractItem
         
} 
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"A016",
"KONP"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_PURCHASECONTRACT",
"I_PURCHASECONTRACTITEM",
"I_PURCONDITIONTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More