I_PURCONTRHDRCNDNAMOUNT

CDS View
47 Fields 4 CDS Views

Contract Header Condition amount

I_PURCONTRHDRCNDNAMOUNT is a CDS View in S/4HANA. Contract Header Condition amount. It contains 47 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_PurContrHdrCndnAmount view from COMPOSITE Purchase Contract Header Conditions Amount
I_PurContrHdrCndnAmountTP view from TRANSACTIONAL Contract Header Condition Amount - TP
I_PurContrHdrCndnScale view inner COMPOSITE Header Condition Scales Basic Data
R_PPS_PurContrHdrCndnAmtTP view_entity from TRANSACTIONAL TP for Pc Cndn Amt for Hdr Pricing

Fields (47)

KeyField CDS FieldsUsed in Views
KEY ConditionRecord ConditionRecord 3
KEY ConditionSequentialNumber ConditionSequentialNumber,ConditionSequentialNumberShort 3
KEY ConditionValidityEndDate ConditionValidityEndDate 4
KEY PurchaseContract PurchaseContract 4
AdditionalValueDays AdditionalValueDays 3
BaseUnit BaseUnit 3
CmmdtyPricingEngineIsEnabled CmmdtyPricingEngineIsEnabled 2
CndnMaxNumberOfSalesOrders CndnMaxNumberOfSalesOrders 3
ConditionAlternativeCurrency ConditionAlternativeCurrency 3
ConditionCalculationType ConditionCalculationType 2
ConditionChangeReason ConditionChangeReason 3
ConditionCurrency ConditionCurrency 3
ConditionExclusion ConditionExclusion 3
ConditionHasScales ConditionHasScales 3
ConditionIsDeleted ConditionIsDeleted 3
ConditionLowerLimit ConditionLowerLimit 2
ConditionLowerLimitAmount ConditionLowerLimitAmount 2
ConditionLowerLimitRatio ConditionLowerLimitRatio 2
ConditionQuantity ConditionQuantity 4
ConditionQuantityUnit ConditionQuantityUnit 4
ConditionRateAmount ConditionRateAmount 3
ConditionRateRatio ConditionRateRatio 3
ConditionRateRatioUnit ConditionRateRatioUnit 3
ConditionRateValue ConditionRateValue 3
ConditionRateValueUnit ConditionRateValueUnit 3
ConditionReleaseStatus ConditionReleaseStatus 3
ConditionScaleAmount ConditionScaleAmount 2
ConditionScaleAmountCurrency ConditionScaleAmountCurrency 2
ConditionScaleQuantity ConditionScaleQuantity 2
ConditionScaleQuantityUnit ConditionScaleQuantityUnit 2
ConditionTextID ConditionTextID 3
ConditionToBaseQtyDnmntr ConditionToBaseQtyDnmntr 3
ConditionToBaseQtyNmrtr ConditionToBaseQtyNmrtr 3
ConditionType ConditionType 3
ConditionUpperLimit ConditionUpperLimit 2
ConditionUpperLimitAmount ConditionUpperLimitAmount 2
ConditionUpperLimitRatio ConditionUpperLimitRatio 2
ConditionValidityStartDate ConditionValidityStartDate 3
FixedValueDate FixedValueDate 3
MaximumConditionAmount MaximumConditionAmount 3
MaximumConditionBasisValue MaximumConditionBasisValue 3
MinimumConditionBasisValue MinimumConditionBasisValue 3
PaymentTerms PaymentTerms 3
PricingScaleBasis PricingScaleBasis 2
PricingScaleCheckingRule PricingScaleCheckingRule 3
PricingScaleLine PricingScaleLine 3
PricingScaleType PricingScaleType 4

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.

-- Contract Header Condition amount
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCONTRHDRCNDNAMOUNT (
    CONDITIONRECORD,
    CONDITIONSEQUENTIALNUMBER,
    CONDITIONVALIDITYENDDATE,
    PURCHASECONTRACT,
    ADDITIONALVALUEDAYS,
    BASEUNIT,
    CMMDTYPRICINGENGINEISENABLED,
    CNDNMAXNUMBEROFSALESORDERS,
    CONDITIONALTERNATIVECURRENCY,
    CONDITIONCALCULATIONTYPE,
    CONDITIONCHANGEREASON,
    CONDITIONCURRENCY,
    CONDITIONEXCLUSION,
    CONDITIONHASSCALES,
    CONDITIONISDELETED,
    CONDITIONLOWERLIMIT,
    CONDITIONLOWERLIMITAMOUNT,
    CONDITIONLOWERLIMITRATIO,
    CONDITIONQUANTITY,
    CONDITIONQUANTITYUNIT,
    CONDITIONRATEAMOUNT,
    CONDITIONRATERATIO,
    CONDITIONRATERATIOUNIT,
    CONDITIONRATEVALUE,
    CONDITIONRATEVALUEUNIT,
    CONDITIONRELEASESTATUS,
    CONDITIONSCALEAMOUNT,
    CONDITIONSCALEAMOUNTCURRENCY,
    CONDITIONSCALEQUANTITY,
    CONDITIONSCALEQUANTITYUNIT,
    CONDITIONTEXTID,
    CONDITIONTOBASEQTYDNMNTR,
    CONDITIONTOBASEQTYNMRTR,
    CONDITIONTYPE,
    CONDITIONUPPERLIMIT,
    CONDITIONUPPERLIMITAMOUNT,
    CONDITIONUPPERLIMITRATIO,
    CONDITIONVALIDITYSTARTDATE,
    FIXEDVALUEDATE,
    MAXIMUMCONDITIONAMOUNT,
    MAXIMUMCONDITIONBASISVALUE,
    MINIMUMCONDITIONBASISVALUE,
    PAYMENTTERMS,
    PRICINGSCALEBASIS,
    PRICINGSCALECHECKINGRULE,
    PRICINGSCALELINE,
    PRICINGSCALETYPE,
    PRIMARY KEY (CONDITIONRECORD, CONDITIONSEQUENTIALNUMBER, CONDITIONVALIDITYENDDATE, PURCHASECONTRACT)
);

Learn More