R_SrcgProjQtnItmCndnAmtDraft

DDL: R_SRCGPROJQTNITMCNDNAMTDRAFT Type: view_entity BASIC Package: RAP_MM_PUR_SRCGPROJQTN
51 Fields 1 Data Sources 1 Associations

Cndn Amt for Itm in SrcgProjQtn - Draft

R_SrcgProjQtnItmCndnAmtDraft is a Basic CDS View that provides data about "Cndn Amt for Itm in SrcgProjQtn - Draft" in SAP S/4HANA. It reads from 1 data source (mmspqtnicndamt_d) and exposes 51 fields with key fields ConditionRecord, ConditionSequentialNumberShort. It has 1 association to related views. Part of development package RAP_MM_PUR_SRCGPROJQTN.

Data Sources (1)

SourceAliasJoin Type
mmspqtnicndamt_d mmspqtnicndamt_d from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_SourcingProjectQuotation _SourcingProjectQuotation $projection.SourcingProjectQuotationUUID = _SourcingProjectQuotation.SourcingProjectQuotationUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Cndn Amt for Itm in SrcgProjQtn - Draft view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord conditionrecord Cond.Record No.
KEY ConditionSequentialNumberShort conditionsequentialnumbershort Sequent. No. of Cond
ConditionValidityEndDate conditionvalidityenddate Valid To
ConditionValidityStartDate conditionvaliditystartdate Valid From
ConditionType conditiontype Condition type
ConditionTextID conditiontextid Text number
ConditionCalculationTypeShort conditioncalculationtypeshort Calculat.Type
ConditionRateValue conditionratevalue Condition Rate Value
ConditionRateValueUnit conditionratevalueunit Unit of Condition Rate Value
ConditionRateAmount conditionrateamount Condition Amount
ConditionCurrency conditioncurrency Currency
ConditionRateRatio conditionrateratio Ratio
ConditionRateRatioUnit conditionrateratiounit Unit of Measure
ConditionQuantity conditionquantity Pricing Unit
ConditionQuantityUnit conditionquantityunit Unit of Measure
ConditionRateValueIsAmount conditionratevalueisamount TRUE
ConditionRateValueIsRatio conditionratevalueisratio TRUE
ConditionToBaseQtyNmrtr conditiontobaseqtynmrtr Numerator
ConditionToBaseQtyDnmntr conditiontobaseqtydnmntr Denominator
BaseUnit baseunit Unit of Measure
ConditionLowerLimit conditionlowerlimit Lower limit
ConditionUpperLimit conditionupperlimit Upper limit
ConditionAlternativeCurrency conditionalternativecurrency Cndn Currency
ConditionExclusion conditionexclusion Exclusion
ConditionIsDeleted conditionisdeleted Deletion Indic.
AdditionalValueDays additionalvaluedays Add. Value Days
FixedValueDate fixedvaluedate Fixed Val. Date
PaymentTerms paymentterms Pyt Terms
CndnMaxNumberOfSalesOrders cndnmaxnumberofsalesorders NumberOfOrders
MinimumConditionBasisValue minimumconditionbasisvalue MinCondBaseVal.
MaximumConditionBasisValue maximumconditionbasisvalue MaxCondBaseVal.
MaximumConditionAmount maximumconditionamount MaxConditValue
ConditionReleaseStatus conditionreleasestatus Release Status
ConditionChangeReason conditionchangereason Cndn Change Reason
CmmdtyPricingEngineIsEnabled cmmdtypricingengineisenabled Enabled for CPE
PricingScaleType pricingscaletype Scale Type
PricingScaleBasisShort pricingscalebasisshort Scale Base Type
PricingScaleLine pricingscaleline Pricing scale
ConditionScaleQuantity conditionscalequantity Scale Quantity
ConditionScaleQuantityUnit conditionscalequantityunit Scale UoM
ConditionScaleAmount conditionscaleamount Scale Value
ConditionScaleAmountCurrency conditionscaleamountcurrency Scale Currency
SourcingProjectQuotationUUID sourcingprojectquotationuuid Supplier Quotation UUID
CmmdtyPrcgConditionIsActivated cmmdtyprcgconditionisactivated Boolean Variable (X = True, - = False, Space = Unknown)
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes
_SourcingProjectQuotation _SourcingProjectQuotation

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 R_SrcgProjQtnItmCndnAmtDraft.
-- 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.

CREATE VIEW R_SrcgProjQtnItmCndnAmtDraft AS
SELECT
  ConditionRecord,
  ConditionSequentialNumberShort,
  ConditionValidityEndDate,
  ConditionValidityStartDate,
  ConditionType,
  ConditionTextID,
  ConditionCalculationTypeShort,
  ConditionRateValue,
  ConditionRateValueUnit,
  ConditionRateAmount,
  ConditionCurrency,
  ConditionRateRatio,
  ConditionRateRatioUnit,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionRateValueIsAmount,
  ConditionRateValueIsRatio,
  ConditionToBaseQtyNmrtr,
  ConditionToBaseQtyDnmntr,
  BaseUnit,
  ConditionLowerLimit,
  ConditionUpperLimit,
  ConditionAlternativeCurrency,
  ConditionExclusion,
  ConditionIsDeleted,
  AdditionalValueDays,
  FixedValueDate,
  PaymentTerms,
  CndnMaxNumberOfSalesOrders,
  MinimumConditionBasisValue,
  MaximumConditionBasisValue,
  MaximumConditionAmount,
  ConditionReleaseStatus,
  ConditionChangeReason,
  CmmdtyPricingEngineIsEnabled,
  PricingScaleType,
  PricingScaleBasisShort,
  PricingScaleLine,
  ConditionScaleQuantity,
  ConditionScaleQuantityUnit,
  ConditionScaleAmount,
  ConditionScaleAmountCurrency,
  SourcingProjectQuotationUUID,
  CmmdtyPrcgConditionIsActivated,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM mmspqtnicndamt_d
LEFT OUTER JOIN R_SourcingProjectQuotation AS _SourcingProjectQuotation ON SourcingProjectQuotationUUID = _SourcingProjectQuotation.SourcingProjectQuotationUUID  -- association [1..1]
;

Learn More