A_PurContrItemCondition

DDL: A_PURCONTRITEMCONDITION SQL: APURCTRITEMCND Type: view BASIC
40 Fields 2 Data Sources 2 Associations

Item Condition

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

Data Sources (2)

SourceAliasJoin Type
P_PrcgCndnRecordItem ConditionDetails inner
I_PurCtrCondItem ConditionItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] A_PurchaseContractItem _PurchaseContractItem $projection.PurchaseContract = _PurchaseContractItem.PurchaseContract and $projection.PurchaseContractItem = _PurchaseContractItem.PurchaseContractItem
[1..1] A_PurchaseContract _PurchaseContract _PurchaseContract.PurchaseContract = $projection.PurchaseContract

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName APURCTRITEMCND view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Item Condition view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
AccessControl.personalData.blocking #REQUIRED view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY PurchaseContract I_PurCtrCondItem PurchaseContract Purchasing Doc.
KEY PurchaseContractItem I_PurCtrCondItem PurchaseContractItem Item
KEY ConditionValidityEndDate
KEY ConditionType P_PrcgCndnRecordItem ConditionType Condition type
KEY ConditionRecord I_PurCtrCondItem ConditionRecord Cond.Record No.
KEY ConditionSequentialNumber P_PrcgCndnRecordItem ConditionSequentialNumber SequNo of Cond.
ConditionValidityStartDate
ConditionTextID P_PrcgCndnRecordItem ConditionTextID Text number
PricingScaleType P_PrcgCndnRecordItem PricingScaleType Scale Type
PricingScaleBasis P_PrcgCndnRecordItem PricingScaleBasis Scale Basis
ConditionScaleQuantity P_PrcgCndnRecordItem ConditionScaleQuantity Scale Quantity
ConditionScaleQuantityUnit P_PrcgCndnRecordItem ConditionScaleQuantityUnit Scale UoM
ConditionScaleAmount P_PrcgCndnRecordItem ConditionScaleAmount Scale Value
ConditionScaleAmountCurrency P_PrcgCndnRecordItem ConditionScaleAmountCurrency Scale Currency
ConditionCalculationType P_PrcgCndnRecordItem ConditionCalculationType Calculat.Type
ConditionRateValue P_PrcgCndnRecordItem ConditionRateValue Condition Rate Value
ConditionRateValueUnit P_PrcgCndnRecordItem ConditionRateValueUnit Unit of Condition Rate Value
ConditionQuantity P_PrcgCndnRecordItem ConditionQuantity Pricing Unit
ConditionQuantityUnit P_PrcgCndnRecordItem ConditionQuantityUnit Unit of Measure
ConditionToBaseQtyNmrtr P_PrcgCndnRecordItem ConditionToBaseQtyNmrtr Numerator
ConditionToBaseQtyDnmntr P_PrcgCndnRecordItem ConditionToBaseQtyDnmntr Denominator
BaseUnit P_PrcgCndnRecordItem BaseUnit Unit of Measure
ConditionLowerLimit P_PrcgCndnRecordItem ConditionLowerLimit Lower limit
ConditionUpperLimit P_PrcgCndnRecordItem ConditionUpperLimit Upper limit
ConditionAlternativeCurrency P_PrcgCndnRecordItem ConditionAlternativeCurrency Cndn Currency
ConditionExclusion P_PrcgCndnRecordItem ConditionExclusion Exclusion
ConditionIsDeleted P_PrcgCndnRecordItem ConditionIsDeleted Deletion Indic.
AdditionalValueDays P_PrcgCndnRecordItem AdditionalValueDays Add. Value Days
FixedValueDate P_PrcgCndnRecordItem FixedValueDate Fixed Val. Date
PaymentTerms P_PrcgCndnRecordItem PaymentTerms Pyt Terms
CndnMaxNumberOfSalesOrders P_PrcgCndnRecordItem CndnMaxNumberOfSalesOrders NumberOfOrders
MinimumConditionBasisValue P_PrcgCndnRecordItem MinimumConditionBasisValue MinCondBaseVal.
MaximumConditionBasisValue P_PrcgCndnRecordItem MaximumConditionBasisValue MaxCondBaseVal.
MaximumConditionAmount P_PrcgCndnRecordItem MaximumConditionAmount MaxConditValue
IncrementalScale P_PrcgCndnRecordItem IncrementalScale Increment scale
PricingScaleLine P_PrcgCndnRecordItem PricingScaleLine Pricing scale
ConditionReleaseStatus P_PrcgCndnRecordItem ConditionReleaseStatus Release Status
ConditionClassification
_PurchaseContract _PurchaseContract
_PurchaseContractItem _PurchaseContractItem

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 A_PurContrItemCondition.
-- 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: APURCTRITEMCND

CREATE VIEW A_PurContrItemCondition AS
SELECT
  ConditionItem.PurchaseContract AS PurchaseContract,
  ConditionItem.PurchaseContractItem AS PurchaseContractItem,
  cast (ConditionItem.ConditionValidityEndDate as abap.dats) AS ConditionValidityEndDate,
  ConditionDetails.ConditionType AS ConditionType,
  ConditionItem.ConditionRecord AS ConditionRecord,
  ConditionDetails.ConditionSequentialNumber AS ConditionSequentialNumber,
  cast (ConditionItem.ConditionValidityStartDate as abap.dats) AS ConditionValidityStartDate,
  ConditionDetails.ConditionTextID AS ConditionTextID,
  ConditionDetails.PricingScaleType AS PricingScaleType,
  ConditionDetails.PricingScaleBasis AS PricingScaleBasis,
  ConditionDetails.ConditionScaleQuantity AS ConditionScaleQuantity,
  ConditionDetails.ConditionScaleQuantityUnit AS ConditionScaleQuantityUnit,
  ConditionDetails.ConditionScaleAmount AS ConditionScaleAmount,
  ConditionDetails.ConditionScaleAmountCurrency AS ConditionScaleAmountCurrency,
  ConditionDetails.ConditionCalculationType AS ConditionCalculationType,
  ConditionDetails.ConditionRateValue AS ConditionRateValue,
  ConditionDetails.ConditionRateValueUnit AS ConditionRateValueUnit,
  ConditionDetails.ConditionQuantity AS ConditionQuantity,
  ConditionDetails.ConditionQuantityUnit AS ConditionQuantityUnit,
  ConditionDetails.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  ConditionDetails.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  ConditionDetails.BaseUnit AS BaseUnit,
  ConditionDetails.ConditionLowerLimit AS ConditionLowerLimit,
  ConditionDetails.ConditionUpperLimit AS ConditionUpperLimit,
  ConditionDetails.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  ConditionDetails.ConditionExclusion AS ConditionExclusion,
  ConditionDetails.ConditionIsDeleted AS ConditionIsDeleted,
  ConditionDetails.AdditionalValueDays AS AdditionalValueDays,
  ConditionDetails.FixedValueDate AS FixedValueDate,
  ConditionDetails.PaymentTerms AS PaymentTerms,
  ConditionDetails.CndnMaxNumberOfSalesOrders AS CndnMaxNumberOfSalesOrders,
  ConditionDetails.MinimumConditionBasisValue AS MinimumConditionBasisValue,
  ConditionDetails.MaximumConditionBasisValue AS MaximumConditionBasisValue,
  ConditionDetails.MaximumConditionAmount AS MaximumConditionAmount,
  ConditionDetails.IncrementalScale AS IncrementalScale,
  ConditionDetails.PricingScaleLine AS PricingScaleLine,
  ConditionDetails.ConditionReleaseStatus AS ConditionReleaseStatus,
  cast( '' as abap.char(1)) AS ConditionClassification
FROM I_PurCtrCondItem AS ConditionItem
INNER JOIN P_PrcgCndnRecordItem AS ConditionDetails ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_PurchaseContractItem AS _PurchaseContractItem ON PurchaseContract = _PurchaseContractItem.PurchaseContract AND PurchaseContractItem = _PurchaseContractItem.PurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN A_PurchaseContract AS _PurchaseContract ON _PurchaseContract.PurchaseContract = PurchaseContract  -- association [1..1]
;

Learn More