I_PurInfCndPeriod

DDL: I_PURINFCNDPERIOD SQL: IPURINFCNDPRD Type: view BASIC
22 Fields 1 Data Sources 3 Associations

CONDITONS VALIDITY

I_PurInfCndPeriod is a Basic CDS View that provides data about "CONDITONS VALIDITY" in SAP S/4HANA. It reads from 1 data source (konp) and exposes 22 fields with key fields PurchasingInfoRecord, PurchasingOrganization, PurchasingInfoRecordCategory, Plant, ConditionValidityEndDate. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
konp ConditionDetails inner

Associations (3)

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

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPURINFCNDPRD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
EndUserText.label CONDITONS VALIDITY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY PurchasingInfoRecord ConditionHelper PurchasingInfoRecord Info Record
KEY PurchasingOrganization ConditionHelper PurchasingOrganization Purchasing Organization
KEY PurchasingInfoRecordCategory ConditionHelper PurchasingInfoRecordCategory Infotype
KEY Plant ConditionHelper Plant Valuation Area
KEY ConditionValidityEndDate
KEY ConditionRecord ConditionHelper ConditionRecord Cond.Record No.
ConditionSequentialNumber konp kopos SequNo of Cond.
ConditionType konp kschl Tax Item Type
ConditionValidityStartDate
ConditionRateValue konp kbetr Tax Rate
ConditionRateValueUnit konp konwa Cond. Currency
ConditionQuantity konp kpein Pricing Unit
ConditionQuantityUnit konp kmein Unit of Measure
ConditionApplication konp kappl Application
ConditionCalculationType konp krech Calculat.Type
ConditionIsDeleted konp loevm_ko Deletion Indic.
ConditionToBaseQtyNmrtr konp kumza Numerator
ConditionToBaseQtyDnmntr konp kumne Denominator
BaseUnit konp meins Valuation Unit
_ConditionText _ConditionText
_DocumentCurrency _DocumentCurrency
_InfoRecord _InfoRecord

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_PurInfCndPeriod.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IPURINFCNDPRD

CREATE VIEW I_PurInfCndPeriod AS
SELECT
  ConditionHelper.PurchasingInfoRecord AS PurchasingInfoRecord,
  ConditionHelper.PurchasingOrganization AS PurchasingOrganization,
  ConditionHelper.PurchasingInfoRecordCategory AS PurchasingInfoRecordCategory,
  ConditionHelper.Plant AS Plant,
  cast(ConditionHelper.ConditionValidityEndDate as abap.dats) AS ConditionValidityEndDate,
  ConditionHelper.ConditionRecord AS ConditionRecord,
  ConditionDetails.kopos AS ConditionSequentialNumber,
  ConditionDetails.kschl AS ConditionType,
  cast (ConditionHelper.ConditionValidityStartDate as abap.dats) AS ConditionValidityStartDate,
  ConditionDetails.kbetr AS ConditionRateValue,
  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,
  ConditionDetails.meins AS BaseUnit
INNER JOIN konp AS ConditionDetails ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurgInfoRecordWithOrgData AS _InfoRecord ON PurchasingInfoRecord = _InfoRecord.PurchasingInfoRecord AND Plant = _InfoRecord.Plant AND PurchasingInfoRecordCategory = _InfoRecord.PurchasingInfoRecordCategory AND PurchasingOrganization = _InfoRecord.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON ConditionRateValueUnit = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_PurConditionText AS _ConditionText ON ConditionType = _ConditionText.ConditionType  -- association [1..*]
;

Learn More