I_PurInfCndPeriodWithDraft
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)
| Source | Alias | Join Type |
|---|---|---|
| I_PurInfCndPeriod | Document | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA