I_SchedgAgrmtItmCndnAmount

DDL: I_SCHEDGAGRMTITMCNDNAMOUNT SQL: ISCHAGRMTCNDAMT Type: view COMPOSITE Package: VDM_MM_PUR_SCHD
32 Fields 2 Data Sources 2 Associations

Scheduling Agrmt Item Condition Amount

I_SchedgAgrmtItmCndnAmount is a Composite CDS View that provides data about "Scheduling Agrmt Item Condition Amount" in SAP S/4HANA. It reads from 2 data sources (I_PricingConditionRecord, I_SchedgAgrmtItmCndnValdty) and exposes 32 fields with key fields SchedulingAgreement, SchedulingAgreementItem, ConditionRecord, ConditionValidityEndDate, ConditionSequentialNumber. It has 2 associations to related views. Part of development package VDM_MM_PUR_SCHD.

Data Sources (2)

SourceAliasJoin Type
I_PricingConditionRecord ConditionItem from
I_SchedgAgrmtItmCndnValdty I_SchedgAgrmtItmCndnValdty inner

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SchedgAgrmtItmCndnValdty _SchedgAgrmtItmCndnValdty $projection.SchedulingAgreement = _SchedgAgrmtItmCndnValdty.SchedulingAgreement and $projection.SchedulingAgreementItem = _SchedgAgrmtItmCndnValdty.SchedulingAgreementItem and $projection.ConditionRecord = _SchedgAgrmtItmCndnValdty.ConditionRecord and $projection.ConditionValidityEndDate = _SchedgAgrmtItmCndnValdty.ConditionValidityEndDate
[1..1] I_Schedgagrmthdr _ScheduleAgreement _ScheduleAgreement.SchedulingAgreement = $projection.SchedulingAgreement

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISCHAGRMTCNDAMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Scheduling Agrmt Item Condition Amount view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY SchedulingAgreement I_SchedgAgrmtItmCndnValdty SchedulingAgreement Scheduling Agreement
KEY SchedulingAgreementItem I_SchedgAgrmtItmCndnValdty SchedulingAgreementItem Schedule Item Number
KEY ConditionRecord I_PricingConditionRecord ConditionRecord Cond.Record No.
KEY ConditionValidityEndDate I_SchedgAgrmtItmCndnValdty ConditionValidityEndDate Valid To
KEY ConditionSequentialNumber I_PricingConditionRecord ConditionSequentialNumber SequNo of Cond.
ConditionValidityStartDate I_SchedgAgrmtItmCndnValdty ConditionValidityStartDate Valid From
ConditionApplication I_PricingConditionRecord ConditionApplication Application
ConditionType I_PricingConditionRecord ConditionType Condition type
ConditionTextID I_PricingConditionRecord ConditionTextID Text number
ConditionCalculationType I_PricingConditionRecord ConditionCalculationType Calculat.Type
ConditionRateValue I_PricingConditionRecord ConditionRateValue Condition Rate Value
ConditionRateValueUnit I_PricingConditionRecord ConditionRateValueUnit Unit of Condition Rate Value
ConditionQuantity I_PricingConditionRecord ConditionQuantity Pricing Unit
ConditionQuantityUnit I_PricingConditionRecord ConditionQuantityUnit Unit of Measure
ConditionToBaseQtyNmrtr I_PricingConditionRecord ConditionToBaseQtyNmrtr Numerator
ConditionToBaseQtyDnmntr I_PricingConditionRecord ConditionToBaseQtyDnmntr Denominator
BaseUnit I_PricingConditionRecord BaseUnit Unit of Measure
ConditionLowerLimit I_PricingConditionRecord ConditionLowerLimit Lower limit
ConditionUpperLimit I_PricingConditionRecord ConditionUpperLimit Upper limit
ConditionAlternativeCurrency I_PricingConditionRecord ConditionAlternativeCurrency Cndn Currency
ConditionExclusion I_PricingConditionRecord ConditionExclusion Exclusion
ConditionIsDeleted I_PricingConditionRecord ConditionIsDeleted Deletion Indic.
AdditionalValueDays I_PricingConditionRecord AdditionalValueDays Add. Value Days
FixedValueDate I_PricingConditionRecord FixedValueDate Fixed Val. Date
PaymentTerms I_PricingConditionRecord PaymentTerms Pyt Terms
CndnMaxNumberOfSalesOrders I_PricingConditionRecord CndnMaxNumberOfSalesOrders NumberOfOrders
MinimumConditionBasisValue I_PricingConditionRecord MinimumConditionBasisValue MinCondBaseVal.
MaximumConditionBasisValue I_PricingConditionRecord MaximumConditionBasisValue MaxCondBaseVal.
MaximumConditionAmount I_PricingConditionRecord MaximumConditionAmount MaxConditValue
ConditionReleaseStatus I_PricingConditionRecord ConditionReleaseStatus Release Status
_SchedgAgrmtItmCndnValdty _SchedgAgrmtItmCndnValdty
_ScheduleAgreement _ScheduleAgreement

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_SchedgAgrmtItmCndnAmount.
-- 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: ISCHAGRMTCNDAMT

CREATE VIEW I_SchedgAgrmtItmCndnAmount AS
SELECT
  I_SchedgAgrmtItmCndnValdty.SchedulingAgreement AS SchedulingAgreement,
  I_SchedgAgrmtItmCndnValdty.SchedulingAgreementItem AS SchedulingAgreementItem,
  ConditionItem.ConditionRecord AS ConditionRecord,
  I_SchedgAgrmtItmCndnValdty.ConditionValidityEndDate AS ConditionValidityEndDate,
  ConditionItem.ConditionSequentialNumber AS ConditionSequentialNumber,
  I_SchedgAgrmtItmCndnValdty.ConditionValidityStartDate AS ConditionValidityStartDate,
  ConditionItem.ConditionApplication AS ConditionApplication,
  ConditionItem.ConditionType AS ConditionType,
  ConditionItem.ConditionTextID AS ConditionTextID,
  ConditionItem.ConditionCalculationType AS ConditionCalculationType,
  ConditionItem.ConditionRateValue AS ConditionRateValue,
  ConditionItem.ConditionRateValueUnit AS ConditionRateValueUnit,
  ConditionItem.ConditionQuantity AS ConditionQuantity,
  ConditionItem.ConditionQuantityUnit AS ConditionQuantityUnit,
  ConditionItem.ConditionToBaseQtyNmrtr AS ConditionToBaseQtyNmrtr,
  ConditionItem.ConditionToBaseQtyDnmntr AS ConditionToBaseQtyDnmntr,
  ConditionItem.BaseUnit AS BaseUnit,
  ConditionItem.ConditionLowerLimit AS ConditionLowerLimit,
  ConditionItem.ConditionUpperLimit AS ConditionUpperLimit,
  ConditionItem.ConditionAlternativeCurrency AS ConditionAlternativeCurrency,
  ConditionItem.ConditionExclusion AS ConditionExclusion,
  ConditionItem.ConditionIsDeleted AS ConditionIsDeleted,
  ConditionItem.AdditionalValueDays AS AdditionalValueDays,
  ConditionItem.FixedValueDate AS FixedValueDate,
  ConditionItem.PaymentTerms AS PaymentTerms,
  ConditionItem.CndnMaxNumberOfSalesOrders AS CndnMaxNumberOfSalesOrders,
  ConditionItem.MinimumConditionBasisValue AS MinimumConditionBasisValue,
  ConditionItem.MaximumConditionBasisValue AS MaximumConditionBasisValue,
  ConditionItem.MaximumConditionAmount AS MaximumConditionAmount,
  ConditionItem.ConditionReleaseStatus AS ConditionReleaseStatus
FROM I_PricingConditionRecord AS ConditionItem
INNER JOIN I_SchedgAgrmtItmCndnValdty ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SchedgAgrmtItmCndnValdty AS _SchedgAgrmtItmCndnValdty ON SchedulingAgreement = _SchedgAgrmtItmCndnValdty.SchedulingAgreement AND SchedulingAgreementItem = _SchedgAgrmtItmCndnValdty.SchedulingAgreementItem AND ConditionRecord = _SchedgAgrmtItmCndnValdty.ConditionRecord AND ConditionValidityEndDate = _SchedgAgrmtItmCndnValdty.ConditionValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_Schedgagrmthdr AS _ScheduleAgreement ON _ScheduleAgreement.SchedulingAgreement = SchedulingAgreement  -- association [1..1]
;

Learn More