I_PURCONTRHDRCNDNAMOUNT

CDS View
50 Fields 3 CDS Views

Contract Header Condition amount

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

CDS Views using this table (3)

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

Fields (50)

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

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,
    PURCONTRBASEUNITISOCODE,
    PURCONTRCNDNQTYUNITISOCODE,
    PURCONTRCNDNRATERATIOUNTISOCD,
    PRIMARY KEY (CONDITIONRECORD, CONDITIONSEQUENTIALNUMBER, CONDITIONVALIDITYENDDATE, PURCHASECONTRACT)
);

Learn More