Which tables does I_PurCtrCond use?

I_PurCtrCond reads from 2 data source(s): konp, a019.

I_PurCtrCond

Q: How many fields does I_PurCtrCond have?

I_PurCtrCond has 19 fields. Key fields: PurchaseContract, ConditionValidityEndDate, ConditionRecord, ConditionSequentialNumber.

DDL: I_PURCTRCOND SQL: IPURCTRCOND Type: view BASIC

Purchase Contract header Conditions

I_PurCtrCond is a Basic CDS View that provides data about "Purchase Contract header Conditions" in SAP S/4HANA. It reads from 2 data sources (konp, a019) and exposes 19 fields with key fields PurchaseContract, ConditionValidityEndDate, ConditionRecord, ConditionSequentialNumber. It has 3 associations to related views.

Data Sources (2)

Source	Alias	Join Type
konp	ConditionDetails	inner
a019	ConditionHeader	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_PurchaseContract	_ContractHeader	`$projection.PurchaseContract = _ContractHeader.PurchaseContract`
[0..1]	I_Currency	_DocumentCurrency	`$projection.ConditionRateValueUnit = _DocumentCurrency.Currency`
[1..*]	I_PurConditionText	_ConditionText	`$projection.ConditionType = _ConditionText.ConditionType`

Annotations (9)

Name	Value	Level
AbapCatalog.sqlViewName	IPURCTRCOND	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Purchase Contract header 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 (19)

Key	Field	Source Table	Source Field
KEY	PurchaseContract	a019	evrtn
KEY	ConditionValidityEndDate
KEY	ConditionRecord	a019	knumh
KEY	ConditionSequentialNumber	konp	kopos
	ConditionType	konp	kschl
	ConditionValidityStartDate
	ConditionRateValue	konp	kbetr
	ConditionRateValueUnit	konp	konwa
	ConditionQuantity	konp	kpein
	ConditionQuantityUnit	konp	kmein
	ConditionApplication	konp	kappl
	ConditionCalculationType	konp	krech
	ConditionIsDeleted	konp	loevm_ko
	ConditionToBaseQtyNmrtr	konp	kumza
	ConditionToBaseQtyDnmntr	konp	kumne
	BaseUnit	konp	meins
	_ConditionText		_ConditionText
	_DocumentCurrency		_DocumentCurrency
	_ContractHeader		_ContractHeader

@AbapCatalog.sqlViewName: 'IPURCTRCOND'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Purchase Contract header Conditions'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.semanticKey:  [ 'PurchaseContract','ConditionValidityEndDate' ]
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_PurCtrCond
  as select from a019 as ConditionHeader
    inner join   konp as ConditionDetails on  ConditionHeader.knumh     = ConditionDetails.knumh
                                          and ConditionDetails.loevm_ko = ''

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

  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

{

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

  key ConditionHeader.knumh                     as ConditionRecord,
  
  key ConditionDetails.kopos                    as ConditionSequentialNumber,

       // @ObjectModel.foreignKey.association: '_ConditionText'

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

       @Semantics.businessDate.from: true
       cast (ConditionHeader.datab as abap.dats) as ConditionValidityStartDate,

       ConditionDetails.kbetr                    as ConditionRateValue,

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

       ConditionDetails.kpein                    as ConditionQuantity,
       ConditionDetails.kmein                    as ConditionQuantityUnit,
       ConditionDetails.kappl                    as ConditionApplication,
       ConditionDetails.krech                    as ConditionCalculationType,
       ConditionDetails.loevm_ko                 as ConditionIsDeleted,
       ConditionDetails.kumza                    as ConditionToBaseQtyNmrtr,
       ConditionDetails.kumne                    as ConditionToBaseQtyDnmntr,

       @ObjectModel.readOnly: true
       ConditionDetails.meins                    as BaseUnit,

       _ConditionText,

       _DocumentCurrency,

       @ObjectModel.association.type:  [ #TO_COMPOSITION_PARENT,#TO_COMPOSITION_ROOT ]
       _ContractHeader

} 
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"A019",
"KONP"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_PURCHASECONTRACT",
"I_PURCONDITIONTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_PurCtrCond view