P_SLSPRCGCONDITIONRECORD

CDS View

P_SLSPRCGCONDITIONRECORD is a CDS View in S/4HANA. It contains 55 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SlsPrcgCndnRecdTemplate view from BASIC Template for Importing Sales Prices
I_SlsPrcgConditionRecord view from BASIC Condition Record for Pricing in Sales

Fields (55)

KeyField CDS FieldsUsed in Views
KEY ConditionRecord ConditionRecord 2
KEY ConditionValidityEndDate ConditionValidityEndDate 2
AdditionalValueDays AdditionalValueDays 2
BaseUnit BaseUnit 1
CndnMaxNumberOfSalesOrders CndnMaxNumberOfSalesOrders 1
ConditionAlternativeCurrency ConditionAlternativeCurrency 1
ConditionApplication ConditionApplication 1
ConditionCalculationType ConditionCalculationType 1
ConditionChangeReason ConditionChangeReason 1
ConditionCurrency ConditionCurrency 1
ConditionExclusion ConditionExclusion 1
ConditionIsDeleted ConditionIsDeleted 1
ConditionLowerLimit ConditionLowerLimit 2
ConditionLowerLimitAmount ConditionLowerLimitAmount 1
ConditionLowerLimitRatio ConditionLowerLimitRatio 1
ConditionQuantity ConditionQuantity 2
ConditionQuantityUnit ConditionQuantityUnit 2
ConditionRateAmount ConditionRateAmount 1
ConditionRateRatio ConditionRateRatio 1
ConditionRateRatioUnit ConditionRateRatioUnit 1
ConditionRateValue ConditionRateValue 2
ConditionRateValueUnit ConditionRateValueUnit 2
ConditionReleaseStatus ConditionReleaseStatus 1
ConditionScaleAmount ConditionScaleAmount 2
ConditionScaleAmountCurrency ConditionScaleAmountCurrency 2
ConditionScaleQuantity ConditionScaleQuantity 2
ConditionScaleQuantityUnit ConditionScaleQuantityUnit 2
ConditionSequentialNumber ConditionSequentialNumber 1
ConditionTable ConditionTable 2
ConditionTaxCode ConditionTaxCode 2
ConditionTextID ConditionTextID 1
ConditionToBaseQtyDnmntr ConditionToBaseQtyDnmntr 1
ConditionToBaseQtyNmrtr ConditionToBaseQtyNmrtr 1
ConditionType ConditionType 2
ConditionUpperLimit ConditionUpperLimit 2
ConditionUpperLimitAmount ConditionUpperLimitAmount 1
ConditionUpperLimitRatio ConditionUpperLimitRatio 1
ConditionValidityStartDate ConditionValidityStartDate 1
ConditionWithholdingTaxCode ConditionWithholdingTaxCode 2
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
FixedValueDate FixedValueDate 2
IncrementalScale IncrementalScale 1
LastChangeDateTime LastChangeDateTime 1
LicenseGrantDate LicenseGrantDate 1
MaximumConditionAmount MaximumConditionAmount 1
MaximumConditionBasisValue MaximumConditionBasisValue 1
MinimumConditionBasisValue MinimumConditionBasisValue 1
PaymentTerms PaymentTerms 2
PrevApprovedConditionRecord PrevApprovedConditionRecord 1
PricingScaleBasis PricingScaleBasis 1
PricingScaleLine PricingScaleLine 1
PricingScaleType PricingScaleType 2
SalesPriceApprovalRequest SalesPriceApprovalRequest 1
TaxExemptionLicense TaxExemptionLicense 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SLSPRCGCONDITIONRECORD (
    CONDITIONRECORD,
    CONDITIONVALIDITYENDDATE,
    ADDITIONALVALUEDAYS,
    BASEUNIT,
    CNDNMAXNUMBEROFSALESORDERS,
    CONDITIONALTERNATIVECURRENCY,
    CONDITIONAPPLICATION,
    CONDITIONCALCULATIONTYPE,
    CONDITIONCHANGEREASON,
    CONDITIONCURRENCY,
    CONDITIONEXCLUSION,
    CONDITIONISDELETED,
    CONDITIONLOWERLIMIT,
    CONDITIONLOWERLIMITAMOUNT,
    CONDITIONLOWERLIMITRATIO,
    CONDITIONQUANTITY,
    CONDITIONQUANTITYUNIT,
    CONDITIONRATEAMOUNT,
    CONDITIONRATERATIO,
    CONDITIONRATERATIOUNIT,
    CONDITIONRATEVALUE,
    CONDITIONRATEVALUEUNIT,
    CONDITIONRELEASESTATUS,
    CONDITIONSCALEAMOUNT,
    CONDITIONSCALEAMOUNTCURRENCY,
    CONDITIONSCALEQUANTITY,
    CONDITIONSCALEQUANTITYUNIT,
    CONDITIONSEQUENTIALNUMBER,
    CONDITIONTABLE,
    CONDITIONTAXCODE,
    CONDITIONTEXTID,
    CONDITIONTOBASEQTYDNMNTR,
    CONDITIONTOBASEQTYNMRTR,
    CONDITIONTYPE,
    CONDITIONUPPERLIMIT,
    CONDITIONUPPERLIMITAMOUNT,
    CONDITIONUPPERLIMITRATIO,
    CONDITIONVALIDITYSTARTDATE,
    CONDITIONWITHHOLDINGTAXCODE,
    CREATEDBYUSER,
    CREATIONDATE,
    FIXEDVALUEDATE,
    INCREMENTALSCALE,
    LASTCHANGEDATETIME,
    LICENSEGRANTDATE,
    MAXIMUMCONDITIONAMOUNT,
    MAXIMUMCONDITIONBASISVALUE,
    MINIMUMCONDITIONBASISVALUE,
    PAYMENTTERMS,
    PREVAPPROVEDCONDITIONRECORD,
    PRICINGSCALEBASIS,
    PRICINGSCALELINE,
    PRICINGSCALETYPE,
    SALESPRICEAPPROVALREQUEST,
    TAXEXEMPTIONLICENSE,
    PRIMARY KEY (CONDITIONRECORD, CONDITIONVALIDITYENDDATE)
);