I_CNTRLPURCONTRHDRCNDNAMOUNT

CDS View
43 Fields 4 CDS Views

Central Purchase Contract Hdr Condition

I_CNTRLPURCONTRHDRCNDNAMOUNT is a CDS View in S/4HANA. Central Purchase Contract Hdr Condition. It contains 43 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_CntrlPurContrHdrCndnAmount view from COMPOSITE Header Condition Amount
I_CntrlPurContrHdrCndnAmountTP view from TRANSACTIONAL Central Purchase Contract Hdr Condition
I_CntrlPurContrHdrCndnScales view inner COMPOSITE CCTR Hdr Condition Scales Basic Data
R_CntrlPurContrHdrCndnAmountTP view_entity from TRANSACTIONAL CCTR Header Condition Amount

Fields (43)

KeyField CDS FieldsUsed in Views
KEY CentralPurchaseContract CentralPurchaseContract 2
KEY ConditionRecord ConditionRecord 1
KEY ConditionSequentialNumber ConditionSequentialNumber 1
KEY ConditionValidityEndDate ConditionValidityEndDate 2
AdditionalValueDays AdditionalValueDays 1
BaseUnit BaseUnit 1
CmmdtyPricingEngineIsEnabled CmmdtyPricingEngineIsEnabled 1
CndnMaxNumberOfSalesOrders CndnMaxNumberOfSalesOrders 1
ConditionAlternativeCurrency ConditionAlternativeCurrency 1
ConditionCalculationType ConditionCalculationType 1
ConditionChangeReason ConditionChangeReason 1
ConditionCurrency ConditionCurrency 1
ConditionExclusion ConditionExclusion 1
ConditionHasScales ConditionHasScales 1
ConditionIsDeleted ConditionIsDeleted 1
ConditionLowerLimit ConditionLowerLimit 1
ConditionQuantity ConditionQuantity 2
ConditionQuantityUnit ConditionQuantityUnit 2
ConditionRateAmount ConditionRateAmount 1
ConditionRateRatio ConditionRateRatio 1
ConditionRateRatioUnit ConditionRateRatioUnit 1
ConditionRateValue ConditionRateValue 1
ConditionRateValueUnit ConditionRateValueUnit 1
ConditionReleaseStatus ConditionReleaseStatus 1
ConditionScaleAmount ConditionScaleAmount 1
ConditionScaleAmountCurrency ConditionScaleAmountCurrency 1
ConditionScaleQuantity ConditionScaleQuantity 1
ConditionScaleQuantityUnit ConditionScaleQuantityUnit 1
ConditionTextID ConditionTextID 1
ConditionToBaseQtyDnmntr ConditionToBaseQtyDnmntr 1
ConditionToBaseQtyNmrtr ConditionToBaseQtyNmrtr 1
ConditionType ConditionType 1
ConditionUpperLimit ConditionUpperLimit 1
ConditionValidityStartDate ConditionValidityStartDate 1
FixedValueDate FixedValueDate 1
MaximumConditionAmount MaximumConditionAmount 1
MaximumConditionBasisValue MaximumConditionBasisValue 1
MinimumConditionBasisValue MinimumConditionBasisValue 1
PaymentTerms PaymentTerms 1
PricingScaleBasis PricingScaleBasis 1
PricingScaleCheckingRule PricingScaleCheckingRule 1
PricingScaleLine PricingScaleLine 1
PricingScaleType PricingScaleType 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.

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

Learn More