_PRICINGELEMENT

30 Fields

_PRICINGELEMENT is an SAP database table in S/4HANA. It contains 30 fields.

Fields (30)

KeyField CDS FieldsUsed in Views
ConditionAmount ConditionAmount 2
ConditionBaseValue ConditionBaseValue 4
ConditionBaseValueIntlUnit ConditionBaseValueIntlUnit 4
ConditionBaseValueUnit ConditionBaseValueUnit 4
ConditionCalculationType ConditionCalculationType 1
ConditionCurrency ConditionCurrency 2
ConditionInactiveReason ConditionInactiveReason 5
ConditionInactiveReasonName ConditionInactiveReasonName 4
ConditionIsDeletable ConditionIsDeletable 4
ConditionIsForStatistics ConditionIsForStatistics 4
ConditionIsManuallyChanged ConditionIsManuallyChanged 4
ConditionQuantity ConditionQuantity 1
ConditionQuantityUnit ConditionQuantityUnit 1
ConditionRateRatio ConditionRateRatio 1
ConditionRateRatioUnit ConditionRateRatioUnit 1
ConditionRateValue ConditionRateValue 3
ConditionRateValueIntlUnit ConditionRateValueIntlUnit 4
ConditionType ConditionType 2
ConditionTypeName ConditionTypeName 4
IsGroupCondition IsGroupCondition 4
PricingDateTime PricingDateTime 3
PricingDocumentItem PricingDocumentItem 1
PricingProcedure PricingProcedure 4
PricingProcedureCounter PricingProcedureCounter 1
PricingProcedureStep PricingProcedureStep 1
SuperordinateDocument SuperordinateDocument 4
SuperordinateDocumentItem SuperordinateDocumentItem 4
TaxCode TaxCode 8
TaxCodeName TaxCodeName 4
TransactionCurrency TransactionCurrency 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _PRICINGELEMENT (
    CONDITIONAMOUNT,
    CONDITIONBASEVALUE,
    CONDITIONBASEVALUEINTLUNIT,
    CONDITIONBASEVALUEUNIT,
    CONDITIONCALCULATIONTYPE,
    CONDITIONCURRENCY,
    CONDITIONINACTIVEREASON,
    CONDITIONINACTIVEREASONNAME,
    CONDITIONISDELETABLE,
    CONDITIONISFORSTATISTICS,
    CONDITIONISMANUALLYCHANGED,
    CONDITIONQUANTITY,
    CONDITIONQUANTITYUNIT,
    CONDITIONRATERATIO,
    CONDITIONRATERATIOUNIT,
    CONDITIONRATEVALUE,
    CONDITIONRATEVALUEINTLUNIT,
    CONDITIONTYPE,
    CONDITIONTYPENAME,
    ISGROUPCONDITION,
    PRICINGDATETIME,
    PRICINGDOCUMENTITEM,
    PRICINGPROCEDURE,
    PRICINGPROCEDURECOUNTER,
    PRICINGPROCEDURESTEP,
    SUPERORDINATEDOCUMENT,
    SUPERORDINATEDOCUMENTITEM,
    TAXCODE,
    TAXCODENAME,
    TRANSACTIONCURRENCY
);

Learn More