I_QTNPRICINGELEMENT

CDS View
88 Fields 2 CDS Views

Supplier Quotation Pricing Element

I_QTNPRICINGELEMENT is a CDS View in S/4HANA. Supplier Quotation Pricing Element. It contains 88 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_QTNPricingElementWD view from TRANSACTIONAL Supplier Quotation Pricing Element
R_SupplierQuotationPrcElmntTP view_entity from TRANSACTIONAL Supplier Quotation Pricing Element

Fields (88)

KeyField CDS FieldsUsed in Views
KEY PricingDocument PricingDocument 2
KEY PricingDocumentItem PricingDocumentItem 2
KEY PricingProcedureCounter PricingProcedureCounter 2
KEY PricingProcedureStep PricingProcedureStep 2
KEY SupplierQuotation SupplierQuotation 2
KEY SupplierQuotationItem SupplierQuotationItem 2
_BillingPriceSource _BillingPriceSource 1
_ConditionAcctAssgmtRelevance _ConditionAcctAssgmtRelevance 1
_ConditionAlternativeCurrency _ConditionAlternativeCurrency 1
_ConditionAmountLimitExceeded _ConditionAmountLimitExceeded 1
_ConditionApplication _ConditionApplication 1
_ConditionBasisLimitExceeded _ConditionBasisLimitExceeded 1
_ConditionCalculationType _ConditionCalculationType 1
_ConditionCategory _ConditionCategory 1
_ConditionClass _ConditionClass 1
_ConditionControl _ConditionControl 1
_ConditionCurrency _ConditionCurrency 1
_ConditionInactiveReason _ConditionInactiveReason 1
_ConditionOrigin _ConditionOrigin 1
_ConditionQuantityUnit _ConditionQuantityUnit 1
_Customer _Customer 1
_PricingConditionType _PricingConditionType 1
_PricingScaleBasis _PricingScaleBasis 1
_ScaleCurrency _ScaleCurrency 1
_ScaleUnitOfMeasure _ScaleUnitOfMeasure 1
_StructureCondition _StructureCondition 1
_Supplier _Supplier 1
_VariantCondition _VariantCondition 1
AccessNumberOfAccessSequence AccessNumberOfAccessSequence 2
AccountKeyForGLAccount AccountKeyForGLAccount 2
AccrualsGLAccount AccrualsGLAccount 2
AcctKeyForAccrualsGLAccount AcctKeyForAccrualsGLAccount 2
BillingPriceSource BillingPriceSource 2
CndnIsRelevantForIntcoBilling CndnIsRelevantForIntcoBilling 2
CndnIsRelevantForInvoiceList CndnIsRelevantForInvoiceList 2
CndnIsRelevantForLimitValue CndnIsRelevantForLimitValue 2
CndnRoundingOffDiffAmount CndnRoundingOffDiffAmount 2
ConditionAcctAssgmtRelevance ConditionAcctAssgmtRelevance 2
ConditionAdjustedQuantity ConditionAdjustedQuantity 2
ConditionAlternativeCurrency ConditionAlternativeCurrency 2
ConditionAmount ConditionAmount 2
ConditionAmountInLocalCrcy ConditionAmountInLocalCrcy 2
ConditionAmountLimitExceeded ConditionAmountLimitExceeded 2
ConditionApplication ConditionApplication 2
ConditionBaseValue ConditionBaseValue 2
ConditionBasisLimitExceeded ConditionBasisLimitExceeded 2
ConditionByteSequence ConditionByteSequence 2
ConditionCalculationType ConditionCalculationType 2
ConditionCategory ConditionCategory 2
ConditionClass ConditionClass 2
ConditionControl ConditionControl 2
ConditionCurrency ConditionCurrency 2
ConditionInactiveReason ConditionInactiveReason 2
ConditionIsForConfiguration ConditionIsForConfiguration 2
ConditionIsForStatistics ConditionIsForStatistics 2
ConditionIsManuallyChanged ConditionIsManuallyChanged 2
ConditionMatrixMaintRelevance ConditionMatrixMaintRelevance 2
ConditionOrigin ConditionOrigin 2
ConditionQuantity ConditionQuantity 2
ConditionQuantityUnit ConditionQuantityUnit 2
ConditionRateValue ConditionRateValue 2
ConditionRecord ConditionRecord 2
ConditionScaleBasisCurrency ConditionScaleBasisCurrency 2
ConditionScaleBasisUnit ConditionScaleBasisUnit 2
ConditionScaleBasisValue ConditionScaleBasisValue 2
ConditionSequentialNumber ConditionSequentialNumber 2
ConditionToBaseQtyDnmntr ConditionToBaseQtyDnmntr 2
ConditionToBaseQtyNmrtr ConditionToBaseQtyNmrtr 2
ConditionType ConditionType 2
ConfigblParametersAndFormulas ConfigblParametersAndFormulas 2
CumulatedConditionBasisValue CumulatedConditionBasisValue 2
CustomerRebateRecipient CustomerRebateRecipient 2
FactorForConditionBasisValue FactorForConditionBasisValue 2
FreightSupplier FreightSupplier 2
GLAccount GLAccount 2
IsGroupCondition IsGroupCondition 2
IsRelevantForAccrual IsRelevantForAccrual 2
PeriodFactorForCndnBasisValue PeriodFactorForCndnBasisValue 2
PrcgProcedureCounterForHeader PrcgProcedureCounterForHeader 2
PricingDateTime PricingDateTime 1
PricingScaleBasis PricingScaleBasis 2
PricingScaleType PricingScaleType 2
StructureCondition StructureCondition 2
TaxCode TaxCode 2
TaxJurisdictionLevel TaxJurisdictionLevel 2
TransactionCurrency TransactionCurrency 2
VariantCondition VariantCondition 2
WithholdingTaxCode WithholdingTaxCode 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Supplier Quotation Pricing Element
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_QTNPRICINGELEMENT (
    PRICINGDOCUMENT,
    PRICINGDOCUMENTITEM,
    PRICINGPROCEDURECOUNTER,
    PRICINGPROCEDURESTEP,
    SUPPLIERQUOTATION,
    SUPPLIERQUOTATIONITEM,
    _BILLINGPRICESOURCE,
    _CONDITIONACCTASSGMTRELEVANCE,
    _CONDITIONALTERNATIVECURRENCY,
    _CONDITIONAMOUNTLIMITEXCEEDED,
    _CONDITIONAPPLICATION,
    _CONDITIONBASISLIMITEXCEEDED,
    _CONDITIONCALCULATIONTYPE,
    _CONDITIONCATEGORY,
    _CONDITIONCLASS,
    _CONDITIONCONTROL,
    _CONDITIONCURRENCY,
    _CONDITIONINACTIVEREASON,
    _CONDITIONORIGIN,
    _CONDITIONQUANTITYUNIT,
    _CUSTOMER,
    _PRICINGCONDITIONTYPE,
    _PRICINGSCALEBASIS,
    _SCALECURRENCY,
    _SCALEUNITOFMEASURE,
    _STRUCTURECONDITION,
    _SUPPLIER,
    _VARIANTCONDITION,
    ACCESSNUMBEROFACCESSSEQUENCE,
    ACCOUNTKEYFORGLACCOUNT,
    ACCRUALSGLACCOUNT,
    ACCTKEYFORACCRUALSGLACCOUNT,
    BILLINGPRICESOURCE,
    CNDNISRELEVANTFORINTCOBILLING,
    CNDNISRELEVANTFORINVOICELIST,
    CNDNISRELEVANTFORLIMITVALUE,
    CNDNROUNDINGOFFDIFFAMOUNT,
    CONDITIONACCTASSGMTRELEVANCE,
    CONDITIONADJUSTEDQUANTITY,
    CONDITIONALTERNATIVECURRENCY,
    CONDITIONAMOUNT,
    CONDITIONAMOUNTINLOCALCRCY,
    CONDITIONAMOUNTLIMITEXCEEDED,
    CONDITIONAPPLICATION,
    CONDITIONBASEVALUE,
    CONDITIONBASISLIMITEXCEEDED,
    CONDITIONBYTESEQUENCE,
    CONDITIONCALCULATIONTYPE,
    CONDITIONCATEGORY,
    CONDITIONCLASS,
    CONDITIONCONTROL,
    CONDITIONCURRENCY,
    CONDITIONINACTIVEREASON,
    CONDITIONISFORCONFIGURATION,
    CONDITIONISFORSTATISTICS,
    CONDITIONISMANUALLYCHANGED,
    CONDITIONMATRIXMAINTRELEVANCE,
    CONDITIONORIGIN,
    CONDITIONQUANTITY,
    CONDITIONQUANTITYUNIT,
    CONDITIONRATEVALUE,
    CONDITIONRECORD,
    CONDITIONSCALEBASISCURRENCY,
    CONDITIONSCALEBASISUNIT,
    CONDITIONSCALEBASISVALUE,
    CONDITIONSEQUENTIALNUMBER,
    CONDITIONTOBASEQTYDNMNTR,
    CONDITIONTOBASEQTYNMRTR,
    CONDITIONTYPE,
    CONFIGBLPARAMETERSANDFORMULAS,
    CUMULATEDCONDITIONBASISVALUE,
    CUSTOMERREBATERECIPIENT,
    FACTORFORCONDITIONBASISVALUE,
    FREIGHTSUPPLIER,
    GLACCOUNT,
    ISGROUPCONDITION,
    ISRELEVANTFORACCRUAL,
    PERIODFACTORFORCNDNBASISVALUE,
    PRCGPROCEDURECOUNTERFORHEADER,
    PRICINGDATETIME,
    PRICINGSCALEBASIS,
    PRICINGSCALETYPE,
    STRUCTURECONDITION,
    TAXCODE,
    TAXJURISDICTIONLEVEL,
    TRANSACTIONCURRENCY,
    VARIANTCONDITION,
    WITHHOLDINGTAXCODE,
    PRIMARY KEY (PRICINGDOCUMENT, PRICINGDOCUMENTITEM, PRICINGPROCEDURECOUNTER, PRICINGPROCEDURESTEP, SUPPLIERQUOTATION, SUPPLIERQUOTATIONITEM)
);

Learn More