I_PurInfCndPeriodWithDraft

DDL: I_PURINFCNDPERIODWITHDRAFT SQL: I_PURINFCNDPRDWD Type: view TRANSACTIONAL

Conditions Records Validity with Draft

I_PurInfCndPeriodWithDraft is a Transactional CDS View that provides data about "Conditions Records Validity with Draft" in SAP S/4HANA. It reads from 1 data source (I_PurInfCndPeriod) and exposes 23 fields with key fields ConditionValidityEndDate, Plant, PurchasingInfoRecordCategory, PurchasingOrganization, PurchasingInfoRecord. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurInfCndPeriod Document from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_PurgInfoRecordWWithDraft _PurgInfoRecordWWithDraft _PurgInfoRecordWWithDraft.Plant = $projection.Plant and _PurgInfoRecordWWithDraft.PurchasingInfoRecordCategory = $projection.PurchasingInfoRecordCategory and _PurgInfoRecordWWithDraft.PurchasingOrganization = $projection.PurchasingOrganization and _PurgInfoRecordWWithDraft.PurchasingInfoRecord = $projection.PurchasingInfoRecord
[0..1] I_Currency _DocumentCurrency _DocumentCurrency.Currency = $projection.ConditionRateValueUnit
[0..*] I_PurConditionText _ConditionText _ConditionText.ConditionType = $projection.ConditionType

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName I_PURINFCNDPRDWD view
EndUserText.label Conditions Records Validity with Draft view
ObjectModel.writeDraftPersistence INFREC_HDR_CND_D view
ObjectModel.draftEnabled true view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ConditionValidityEndDate I_PurInfCndPeriod ConditionValidityEndDate
KEY Plant I_PurInfCndPeriod Plant
KEY PurchasingInfoRecordCategory I_PurInfCndPeriod PurchasingInfoRecordCategory
KEY PurchasingOrganization I_PurInfCndPeriod PurchasingOrganization
KEY PurchasingInfoRecord I_PurInfCndPeriod PurchasingInfoRecord
KEY ConditionRecord I_PurInfCndPeriod ConditionRecord
ConditionValdtyEndDateForEdit I_PurInfCndPeriod ConditionValidityEndDate
ConditionSequentialNumber I_PurInfCndPeriod ConditionSequentialNumber
ConditionType I_PurInfCndPeriod ConditionType
ConditionValidityStartDate I_PurInfCndPeriod ConditionValidityStartDate
ConditionRateValue I_PurInfCndPeriod ConditionRateValue
ConditionRateValueUnit I_PurInfCndPeriod ConditionRateValueUnit
ConditionQuantity I_PurInfCndPeriod ConditionQuantity
ConditionQuantityUnit I_PurInfCndPeriod ConditionQuantityUnit
ConditionApplication I_PurInfCndPeriod ConditionApplication
ConditionCalculationType I_PurInfCndPeriod ConditionCalculationType
ConditionIsDeleted I_PurInfCndPeriod ConditionIsDeleted
ConditionToBaseQtyNmrtr I_PurInfCndPeriod ConditionToBaseQtyNmrtr
ConditionToBaseQtyDnmntr I_PurInfCndPeriod ConditionToBaseQtyDnmntr
BaseUnit I_PurInfCndPeriod BaseUnit
_PurgInfoRecordWWithDraft _PurgInfoRecordWWithDraft
_DocumentCurrency _DocumentCurrency
_ConditionText _ConditionText
@AbapCatalog.sqlViewName: 'I_PURINFCNDPRDWD'
@EndUserText.label: 'Conditions Records Validity with Draft'
@ObjectModel.writeDraftPersistence: 'INFREC_HDR_CND_D'
@ObjectModel.draftEnabled:true
@VDM.viewType: #TRANSACTIONAL
@AccessControl.authorizationCheck: #CHECK

@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.semanticKey: ['Plant', 'PurchasingInfoRecordCategory', 'PurchasingOrganization', 'PurchasingInfoRecord', 'ConditionValidityEndDate' ]
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
//@Metadata.ignorePropagatedAnnotations: true


define view I_PurInfCndPeriodWithDraft
  as select from I_PurInfCndPeriod as Document
  association [1..1] to I_PurgInfoRecordWWithDraft as _PurgInfoRecordWWithDraft on  _PurgInfoRecordWWithDraft.Plant                        = $projection.Plant
                                                                                and _PurgInfoRecordWWithDraft.PurchasingInfoRecordCategory = $projection.PurchasingInfoRecordCategory
                                                                                and _PurgInfoRecordWWithDraft.PurchasingOrganization       = $projection.PurchasingOrganization
                                                                                and _PurgInfoRecordWWithDraft.PurchasingInfoRecord         = $projection.PurchasingInfoRecord
  association [0..1] to I_Currency                 as _DocumentCurrency         on  _DocumentCurrency.Currency = $projection.ConditionRateValueUnit
  association [0..*] to I_PurConditionText         as _ConditionText            on  _ConditionText.ConditionType = $projection.ConditionType

{

  key  Document.ConditionValidityEndDate,
  key  Document.Plant,
  key  Document.PurchasingInfoRecordCategory,
  key  Document.PurchasingOrganization,
  key  Document.PurchasingInfoRecord,
  key  Document.ConditionRecord,
       @ObjectModel.mandatory: true
       @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }
       Document.ConditionValidityEndDate as ConditionValdtyEndDateForEdit,

       Document.ConditionSequentialNumber,
       @ObjectModel.readOnly: true
       Document.ConditionType,
       @ObjectModel.mandatory: true
       @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }
       Document.ConditionValidityStartDate,
       Document.ConditionRateValue,
       //      @ObjectModel.foreignKey.association: '_DocumentCurrency'

       Document.ConditionRateValueUnit,
       @ObjectModel: { readOnly: 'EXTERNAL_CALCULATION' }
       Document.ConditionQuantity,
       Document.ConditionQuantityUnit,
       Document.ConditionApplication,
       Document.ConditionCalculationType,
       Document.ConditionIsDeleted,
       Document.ConditionToBaseQtyNmrtr,
       Document.ConditionToBaseQtyDnmntr,
       Document.BaseUnit,

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

       _DocumentCurrency,

       _ConditionText


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